APPS.ARP_PROC_RCT_UTIL dependencies on FND_FLEX_KEYVAL

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

802: -- Using the flex field server APIs to do this ...
803: -- (note also that we are using the same error message
804: -- for each case.
805: --
806: -- Firstly, call fnd_flex_keyval.validate_ccid to populate
807: -- all of the relevant global variables.
808: --
809: IF fnd_flex_keyval.validate_ccid(
810: appl_short_name => 'SQLGL',

Line 809: IF fnd_flex_keyval.validate_ccid(

805: --
806: -- Firstly, call fnd_flex_keyval.validate_ccid to populate
807: -- all of the relevant global variables.
808: --
809: IF fnd_flex_keyval.validate_ccid(
810: appl_short_name => 'SQLGL',
811: key_flex_code => 'GL#',
812: structure_number => arp_global.chart_of_accounts_id,
813: combination_id => l_trx_code_combination_id ) THEN

Line 816: IF not fnd_flex_keyval.enabled_flag THEN

812: structure_number => arp_global.chart_of_accounts_id,
813: combination_id => l_trx_code_combination_id ) THEN
814: -- Secondly, check is the key flex is enabled.
815: -- Fix 1341201, Added rollback
816: IF not fnd_flex_keyval.enabled_flag THEN
817: rollback;
818: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
819: APP_EXCEPTION.Raise_Exception;
820: -- Thirdly, check if the key flex is valid for this date.

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

818: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
819: APP_EXCEPTION.Raise_Exception;
820: -- Thirdly, check if the key flex is valid for this date.
821: --
822: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
823: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN
824: rollback;
825: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
826: APP_EXCEPTION.Raise_Exception;

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

819: APP_EXCEPTION.Raise_Exception;
820: -- Thirdly, check if the key flex is valid for this date.
821: --
822: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
823: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN
824: rollback;
825: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
826: APP_EXCEPTION.Raise_Exception;
827: END IF;

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

1596: -- Using the flex field server APIs to do this ...
1597: -- (note also that we are using the same error message
1598: -- for each case.
1599: --
1600: -- Firstly, call fnd_flex_keyval.validate_ccid to populate
1601: -- all of the relevant global variables.
1602: --
1603: IF fnd_flex_keyval.validate_ccid(
1604: appl_short_name => 'SQLGL',

Line 1603: IF fnd_flex_keyval.validate_ccid(

1599: --
1600: -- Firstly, call fnd_flex_keyval.validate_ccid to populate
1601: -- all of the relevant global variables.
1602: --
1603: IF fnd_flex_keyval.validate_ccid(
1604: appl_short_name => 'SQLGL',
1605: key_flex_code => 'GL#',
1606: structure_number => arp_global.chart_of_accounts_id,
1607: combination_id => dist.dist_code_combination_id) THEN

Line 1610: IF not fnd_flex_keyval.enabled_flag THEN

1606: structure_number => arp_global.chart_of_accounts_id,
1607: combination_id => dist.dist_code_combination_id) THEN
1608: -- Secondly, check is the key flex is enabled.
1609: --
1610: IF not fnd_flex_keyval.enabled_flag THEN
1611: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
1612: APP_EXCEPTION.Raise_Exception;
1613: -- Thirdly, check if the key flex is valid for this date.
1614: --

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

1611: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
1612: APP_EXCEPTION.Raise_Exception;
1613: -- Thirdly, check if the key flex is valid for this date.
1614: --
1615: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
1616: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN
1617: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
1618: APP_EXCEPTION.Raise_Exception;
1619: END IF;

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

1612: APP_EXCEPTION.Raise_Exception;
1613: -- Thirdly, check if the key flex is valid for this date.
1614: --
1615: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
1616: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN
1617: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
1618: APP_EXCEPTION.Raise_Exception;
1619: END IF;
1620: END IF;