APPS.AR_INVOICE_UTILS dependencies on FND_PROFILE

Line 11: pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');

7:
8: /*Bug 5122918/4709987/3752043*/
9: pg_so_org_id NUMBER := to_number(oe_profile.value('SO_ORGANIZATION_ID'));
10:
11: pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
12:
13:
14: PROCEDURE debug (
15: p_message IN VARCHAR2,

Line 930: l_seq_num_profile fnd_profile_option_values.profile_option_value%type;

926: SELECT *
927: FROM ar_trx_header_gt gt
928: WHERE gt.doc_sequence_value IS NOT NULL;
929:
930: l_seq_num_profile fnd_profile_option_values.profile_option_value%type;
931:
932: l_doc_seq_ret_stat NUMBER;
933: l_doc_sequence_id NUMBER;
934: l_doc_sequence_name VARCHAR2(50);

Line 1667: if(nvl(FND_PROFILE.value('AR_TRX_DEFAULT_PRIM_SITE_USE'),'BILL_SHIP_TO') not in ('BILL_TO','BILL_SHIP_TO')) then

1663: debug ('AR_INVOICE_UTILS.validate_bill_to_site_use_id(+)' );
1664: END IF;
1665: x_return_status := FND_API.G_RET_STS_SUCCESS;
1666:
1667: if(nvl(FND_PROFILE.value('AR_TRX_DEFAULT_PRIM_SITE_USE'),'BILL_SHIP_TO') not in ('BILL_TO','BILL_SHIP_TO')) then
1668: INSERT INTO ar_trx_errors_gt (
1669: trx_header_id,
1670: error_message,
1671: invalid_value)

Line 1824: if( nvl(FND_PROFILE.value('AR_TRX_DEFAULT_PRIM_SITE_USE'),'BILL_SHIP_TO') not in ('SHIP_TO','BILL_SHIP_TO')) then

1820: x_return_status := FND_API.G_RET_STS_SUCCESS;
1821:
1822: -- The below if condition is added to validate ship_to_site_use_id before defaulting ship_to details
1823: if(x_called = 'BEFORE') then
1824: if( nvl(FND_PROFILE.value('AR_TRX_DEFAULT_PRIM_SITE_USE'),'BILL_SHIP_TO') not in ('SHIP_TO','BILL_SHIP_TO')) then
1825:
1826: INSERT INTO ar_trx_errors_gt (
1827: trx_header_id,
1828: error_message,

Line 5118: l_seq_num_profile fnd_profile_option_values.profile_option_value%type;

5114: l_seq_err boolean := FALSE;
5115: l_trx_str VARCHAR2(2000);
5116: l_org_str VARCHAR2(30);
5117: l_trx_number ra_customer_trx.trx_number%type;
5118: l_seq_num_profile fnd_profile_option_values.profile_option_value%type;
5119: BEGIN
5120: IF pg_debug = 'Y'
5121: THEN
5122: debug ('AR_INVOICE_UTILS.populate_doc_sequence (+)' );

Line 5424: l_so_id_flex_code fnd_profile_option_values.profile_option_value%type;

5420: PROCEDURE validate_item_kflex (
5421: x_errmsg OUT NOCOPY VARCHAR2,
5422: x_return_status OUT NOCOPY VARCHAR2) IS
5423:
5424: l_so_id_flex_code fnd_profile_option_values.profile_option_value%type;
5425: l_so_org_id fnd_profile_option_values.profile_option_value%type;
5426:
5427: CURSOR cItemFlex IS
5428: SELECT trx_header_id, trx_line_id,inventory_item_id, org_id

Line 5425: l_so_org_id fnd_profile_option_values.profile_option_value%type;

5421: x_errmsg OUT NOCOPY VARCHAR2,
5422: x_return_status OUT NOCOPY VARCHAR2) IS
5423:
5424: l_so_id_flex_code fnd_profile_option_values.profile_option_value%type;
5425: l_so_org_id fnd_profile_option_values.profile_option_value%type;
5426:
5427: CURSOR cItemFlex IS
5428: SELECT trx_header_id, trx_line_id,inventory_item_id, org_id
5429: FROM ar_trx_lines_gt