DBA Data[Home] [Help]

APPS.JG_ZZ_AR_AUTO_INVOICE dependencies on FND_PROFILE

Line 30: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);

26:
27: Function Is_Reg_Loc_Enabled Return Boolean IS
28: l_country_code Varchar2(30);
29: Begin
30: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);
31: -- Start Bug 8982308
32: If (l_country_code = 'TW' or l_country_code = 'AR' or l_country_code = 'BR') THEN
33: -- Start Bug 8982308
34: Return TRUE;

Line 138: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);

134: l_imp_batch_source_id Number;
135: -- End Bug 8709620
136:
137: Begin
138: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);
139: --fnd_profile.get('ORG_ID',l_org_id);
140: l_org_id := MO_GLOBAL.get_current_org_id; -- bug 8304339
141:
142: If l_country_code = 'TW' Then

Line 139: --fnd_profile.get('ORG_ID',l_org_id);

135: -- End Bug 8709620
136:
137: Begin
138: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);
139: --fnd_profile.get('ORG_ID',l_org_id);
140: l_org_id := MO_GLOBAL.get_current_org_id; -- bug 8304339
141:
142: If l_country_code = 'TW' Then
143: l_debug_loc := 'jg_zz_ar_auto_invoice.trx_num_upd, country code TW';

Line 202: --fnd_profile.get('ORG_ID',f_org_id);

198: and request_id = p_request_id;
199: End If;
200:
201: Elsif l_country_code = 'AR' Then
202: --fnd_profile.get('ORG_ID',f_org_id);
203: f_org_id := MO_GLOBAL.get_current_org_id;
204:
205: l_debug_loc := 'jg_zz_ar_auto_invoice.trx_num_upd, country code AR';
206: Open C_AR_Trx_lines(p_request_id);

Line 287: -- fnd_profile.get('ORG_ID',f_org_id);

283:
284: -- Start Bug 8982308
285: Elsif l_country_code = 'BR' Then
286:
287: -- fnd_profile.get('ORG_ID',f_org_id);
288: f_org_id := MO_GLOBAL.get_current_org_id;
289: l_debug_loc := 'jg_zz_ar_auto_invoice.trx_num_upd, country code BR';
290: Open C_Trx_lines(p_request_id);
291: Fetch C_Trx_lines Bulk Collect Into trx_number, customer_trx_id;

Line 430: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);

426: l_last_trx_num Varchar2(8);
427: l_message_text Varchar2(240);
428: l_batch_source_name Varchar2(50);
429: BEGIN
430: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);
431: --fnd_profile.get('ORG_ID',l_org_id);
432: l_org_id := MO_GLOBAL.get_current_org_id;
433:
434: BEGIN

Line 431: --fnd_profile.get('ORG_ID',l_org_id);

427: l_message_text Varchar2(240);
428: l_batch_source_name Varchar2(50);
429: BEGIN
430: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);
431: --fnd_profile.get('ORG_ID',l_org_id);
432: l_org_id := MO_GLOBAL.get_current_org_id;
433:
434: BEGIN
435: SELECT TO_NUMBER(cr.argument3) INTO l_batch_source_id

Line 613: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);

609: GET_BATCH_ID_ERR Exception;
610:
611: Begin
612: l_debug_loc := 'Getting the Country Code';
613: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);
614:
615: -- Bug 12595382 Start
616: l_debug_loc := 'Getting the Org_Id';
617: f_org_id := MO_GLOBAL.get_current_org_id;