APPS.ARP_PROC_RCT_UTIL dependencies on FND_FLEX_KEYVAL

Line 821: -- Firstly, call fnd_flex_keyval.validate_ccid to populate

817: -- Using the flex field server APIs to do this ...
818: -- (note also that we are using the same error message
819: -- for each case.
820: --
821: -- Firstly, call fnd_flex_keyval.validate_ccid to populate
822: -- all of the relevant global variables.
823: --
824: IF fnd_flex_keyval.validate_ccid(
825: appl_short_name => 'SQLGL',

Line 824: IF fnd_flex_keyval.validate_ccid(

820: --
821: -- Firstly, call fnd_flex_keyval.validate_ccid to populate
822: -- all of the relevant global variables.
823: --
824: IF fnd_flex_keyval.validate_ccid(
825: appl_short_name => 'SQLGL',
826: key_flex_code => 'GL#',
827: structure_number => arp_global.chart_of_accounts_id,
828: combination_id => l_trx_code_combination_id ) THEN

Line 831: IF not fnd_flex_keyval.enabled_flag THEN

827: structure_number => arp_global.chart_of_accounts_id,
828: combination_id => l_trx_code_combination_id ) THEN
829: -- Secondly, check is the key flex is enabled.
830: -- Fix 1341201, Added rollback
831: IF not fnd_flex_keyval.enabled_flag THEN
832: rollback;
833: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
834: APP_EXCEPTION.Raise_Exception;
835: -- Thirdly, check if the key flex is valid for this date.

Line 837: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)

833: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
834: APP_EXCEPTION.Raise_Exception;
835: -- Thirdly, check if the key flex is valid for this date.
836: --
837: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
838: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN
839: rollback;
840: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
841: APP_EXCEPTION.Raise_Exception;

Line 838: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN

834: APP_EXCEPTION.Raise_Exception;
835: -- Thirdly, check if the key flex is valid for this date.
836: --
837: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
838: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN
839: rollback;
840: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
841: APP_EXCEPTION.Raise_Exception;
842: END IF;

Line 1615: -- Firstly, call fnd_flex_keyval.validate_ccid to populate

1611: -- Using the flex field server APIs to do this ...
1612: -- (note also that we are using the same error message
1613: -- for each case.
1614: --
1615: -- Firstly, call fnd_flex_keyval.validate_ccid to populate
1616: -- all of the relevant global variables.
1617: --
1618: IF fnd_flex_keyval.validate_ccid(
1619: appl_short_name => 'SQLGL',

Line 1618: IF fnd_flex_keyval.validate_ccid(

1614: --
1615: -- Firstly, call fnd_flex_keyval.validate_ccid to populate
1616: -- all of the relevant global variables.
1617: --
1618: IF fnd_flex_keyval.validate_ccid(
1619: appl_short_name => 'SQLGL',
1620: key_flex_code => 'GL#',
1621: structure_number => arp_global.chart_of_accounts_id,
1622: combination_id => dist.dist_code_combination_id) THEN

Line 1625: IF not fnd_flex_keyval.enabled_flag THEN

1621: structure_number => arp_global.chart_of_accounts_id,
1622: combination_id => dist.dist_code_combination_id) THEN
1623: -- Secondly, check is the key flex is enabled.
1624: --
1625: IF not fnd_flex_keyval.enabled_flag THEN
1626: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
1627: APP_EXCEPTION.Raise_Exception;
1628: -- Thirdly, check if the key flex is valid for this date.
1629: --

Line 1630: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)

1626: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
1627: APP_EXCEPTION.Raise_Exception;
1628: -- Thirdly, check if the key flex is valid for this date.
1629: --
1630: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
1631: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN
1632: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
1633: APP_EXCEPTION.Raise_Exception;
1634: END IF;

Line 1631: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN

1627: APP_EXCEPTION.Raise_Exception;
1628: -- Thirdly, check if the key flex is valid for this date.
1629: --
1630: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
1631: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN
1632: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
1633: APP_EXCEPTION.Raise_Exception;
1634: END IF;
1635: END IF;