eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGIRSTPT dependencies on FND_PROFILE

Line 8: --l_org_id number := fnd_profile.value('ORG_ID'); --shsaxena for bug 2964361

4: l_debug varchar2(5) := NULL;
5: l_variable varchar2(80) := NULL;
6: l_value varchar2(2000) := NULL;
7: -- Bug 1058426
8: --l_org_id number := fnd_profile.value('ORG_ID'); --shsaxena for bug 2964361
9: p_receivables_batch_source varchar2(80) := fnd_profile.value('IGI_STP_RECEIVABLES_BATCH');
10:
11: p_payables_batch_source varchar2(80) := fnd_profile.value('IGI_STP_PAYABLES_SOURCE');
12:

Line 9: p_receivables_batch_source varchar2(80) := fnd_profile.value('IGI_STP_RECEIVABLES_BATCH');

5: l_variable varchar2(80) := NULL;
6: l_value varchar2(2000) := NULL;
7: -- Bug 1058426
8: --l_org_id number := fnd_profile.value('ORG_ID'); --shsaxena for bug 2964361
9: p_receivables_batch_source varchar2(80) := fnd_profile.value('IGI_STP_RECEIVABLES_BATCH');
10:
11: p_payables_batch_source varchar2(80) := fnd_profile.value('IGI_STP_PAYABLES_SOURCE');
12:
13: p_interface_context varchar2(80) := fnd_profile.value('IGI_STP_INTERFACE_CONTEXT');

Line 11: p_payables_batch_source varchar2(80) := fnd_profile.value('IGI_STP_PAYABLES_SOURCE');

7: -- Bug 1058426
8: --l_org_id number := fnd_profile.value('ORG_ID'); --shsaxena for bug 2964361
9: p_receivables_batch_source varchar2(80) := fnd_profile.value('IGI_STP_RECEIVABLES_BATCH');
10:
11: p_payables_batch_source varchar2(80) := fnd_profile.value('IGI_STP_PAYABLES_SOURCE');
12:
13: p_interface_context varchar2(80) := fnd_profile.value('IGI_STP_INTERFACE_CONTEXT');
14:
15: -- End of Bug 1058426

Line 13: p_interface_context varchar2(80) := fnd_profile.value('IGI_STP_INTERFACE_CONTEXT');

9: p_receivables_batch_source varchar2(80) := fnd_profile.value('IGI_STP_RECEIVABLES_BATCH');
10:
11: p_payables_batch_source varchar2(80) := fnd_profile.value('IGI_STP_PAYABLES_SOURCE');
12:
13: p_interface_context varchar2(80) := fnd_profile.value('IGI_STP_INTERFACE_CONTEXT');
14:
15: -- End of Bug 1058426
16: --following variables added for bug 3199481: fnd logging changes: sdixit
17: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 46: l_term_id number := fnd_profile.value('IGI_STP_AR_TERMS');

42: IS
43:
44: -- Only Lines are managed --
45: l_line_type varchar2(20) := 'LINE';
46: l_term_id number := fnd_profile.value('IGI_STP_AR_TERMS');
47:
48: l_uom_code varchar2(25) := fnd_profile.value('IGI_STP_UOM');
49:
50:

Line 48: l_uom_code varchar2(25) := fnd_profile.value('IGI_STP_UOM');

44: -- Only Lines are managed --
45: l_line_type varchar2(20) := 'LINE';
46: l_term_id number := fnd_profile.value('IGI_STP_AR_TERMS');
47:
48: l_uom_code varchar2(25) := fnd_profile.value('IGI_STP_UOM');
49:
50:
51:
52: -- Accounts combinations fro receivable and revenue --

Line 141: from fnd_profile_option_values fpov,

137:
138: -- Term identifier --
139: /* select fpov.profile_option_value
140: into l_term_id
141: from fnd_profile_option_values fpov,
142: fnd_profile_options fpo
143: where fpo.profile_option_id = fpov.profile_option_id
144: and profile_option_name = 'IGI_STP_AR_TERMS'; */
145: --fnd_file.put_line(fnd_file.log , 'l_term_id'||l_term_id);

Line 142: fnd_profile_options fpo

138: -- Term identifier --
139: /* select fpov.profile_option_value
140: into l_term_id
141: from fnd_profile_option_values fpov,
142: fnd_profile_options fpo
143: where fpo.profile_option_id = fpov.profile_option_id
144: and profile_option_name = 'IGI_STP_AR_TERMS'; */
145: --fnd_file.put_line(fnd_file.log , 'l_term_id'||l_term_id);
146: IF l_debug = 'TRUE'

Line 158: from fnd_profile_option_values fpov,

154:
155:
156: /* select fpov.profile_option_value
157: into l_uom_code
158: from fnd_profile_option_values fpov,
159: fnd_profile_options fpo
160: where fpo.profile_option_id = fpov.profile_option_id
161: and profile_option_name = 'IGI_STP_UOM'; */
162: IF l_debug = 'TRUE'

Line 159: fnd_profile_options fpo

155:
156: /* select fpov.profile_option_value
157: into l_uom_code
158: from fnd_profile_option_values fpov,
159: fnd_profile_options fpo
160: where fpo.profile_option_id = fpov.profile_option_id
161: and profile_option_name = 'IGI_STP_UOM'; */
162: IF l_debug = 'TRUE'
163: THEN

Line 431: l_term_id number := fnd_profile.value('IGI_STP_AP_TERMS');

427: IS
428:
429: l_invoice_id number;
430: l_ap_source varchar2(25);
431: l_term_id number := fnd_profile.value('IGI_STP_AP_TERMS');
432:
433: --l_term_id number ;
434: l_pay_group varchar2(25);
435:

Line 470: l_pay_group := fnd_profile.value('IGI_STP_PAYGROUP');

466: BEGIN
467:
468:
469:
470: l_pay_group := fnd_profile.value('IGI_STP_PAYGROUP');
471:
472: --l_pay_group := 'Standard';
473:
474:

Line 505: from fnd_profile_option_values fpov,

501:
502:
503: /* select fpov.profile_option_value
504: into l_term_id
505: from fnd_profile_option_values fpov,
506: fnd_profile_options fpo
507: where fpo.profile_option_id = fpov.profile_option_id
508: and profile_option_name = 'IGI_STP_AP_TERMS'; */
509: IF l_debug = 'TRUE'

Line 506: fnd_profile_options fpo

502:
503: /* select fpov.profile_option_value
504: into l_term_id
505: from fnd_profile_option_values fpov,
506: fnd_profile_options fpo
507: where fpo.profile_option_id = fpov.profile_option_id
508: and profile_option_name = 'IGI_STP_AP_TERMS'; */
509: IF l_debug = 'TRUE'
510: THEN

Line 709: /* p_org_id := fnd_profile.value('ORG_ID');

705: BEGIN
706:
707:
708: p_sysdate := trunc(sysdate);
709: /* p_org_id := fnd_profile.value('ORG_ID');
710: p_set_of_books_id := fnd_profile.value('SET_OF_BOOKS_ID');
711: p_user_id := fnd_profile.value('USER_ID');
712: p_login_id := fnd_profile.value('LOGIN_ID'); */
713:

Line 710: p_set_of_books_id := fnd_profile.value('SET_OF_BOOKS_ID');

706:
707:
708: p_sysdate := trunc(sysdate);
709: /* p_org_id := fnd_profile.value('ORG_ID');
710: p_set_of_books_id := fnd_profile.value('SET_OF_BOOKS_ID');
711: p_user_id := fnd_profile.value('USER_ID');
712: p_login_id := fnd_profile.value('LOGIN_ID'); */
713:
714:

Line 711: p_user_id := fnd_profile.value('USER_ID');

707:
708: p_sysdate := trunc(sysdate);
709: /* p_org_id := fnd_profile.value('ORG_ID');
710: p_set_of_books_id := fnd_profile.value('SET_OF_BOOKS_ID');
711: p_user_id := fnd_profile.value('USER_ID');
712: p_login_id := fnd_profile.value('LOGIN_ID'); */
713:
714:
715:

Line 712: p_login_id := fnd_profile.value('LOGIN_ID'); */

708: p_sysdate := trunc(sysdate);
709: /* p_org_id := fnd_profile.value('ORG_ID');
710: p_set_of_books_id := fnd_profile.value('SET_OF_BOOKS_ID');
711: p_user_id := fnd_profile.value('USER_ID');
712: p_login_id := fnd_profile.value('LOGIN_ID'); */
713:
714:
715:
716:

Line 719: p_user_id := fnd_profile.value('USER_ID');

715:
716:
717:
718: mo_utils.get_ledger_info(p_org_id,p_set_of_books_id,p_ledger_name);
719: p_user_id := fnd_profile.value('USER_ID');
720: p_login_id := fnd_profile.value('LOGIN_ID');
721:
722:
723:

Line 720: p_login_id := fnd_profile.value('LOGIN_ID');

716:
717:
718: mo_utils.get_ledger_info(p_org_id,p_set_of_books_id,p_ledger_name);
719: p_user_id := fnd_profile.value('USER_ID');
720: p_login_id := fnd_profile.value('LOGIN_ID');
721:
722:
723:
724: IF l_debug = 'TRUE'

Line 918: l_batch_source_name := fnd_profile.value('IGI_STP_RECEIVABLES_BATCH');

914: l_pay_group varchar2(25);
915: l_flag varchar2(1) := 'P';
916:
917: BEGIN
918: l_batch_source_name := fnd_profile.value('IGI_STP_RECEIVABLES_BATCH');
919: --l_batch_source_name := 'BR Automatic Numbering';
920: l_payables_source_name :=fnd_profile.value('IGI_STP_PAYABLES_SOURCE');
921: --l_payables_source_name := 'INVOICE GATEWAY';
922: l_interface_context :=fnd_profile.value('IGI_STP_INTERFACE_CONTEXT');

Line 920: l_payables_source_name :=fnd_profile.value('IGI_STP_PAYABLES_SOURCE');

916:
917: BEGIN
918: l_batch_source_name := fnd_profile.value('IGI_STP_RECEIVABLES_BATCH');
919: --l_batch_source_name := 'BR Automatic Numbering';
920: l_payables_source_name :=fnd_profile.value('IGI_STP_PAYABLES_SOURCE');
921: --l_payables_source_name := 'INVOICE GATEWAY';
922: l_interface_context :=fnd_profile.value('IGI_STP_INTERFACE_CONTEXT');
923: --l_interface_context := 'STP NETTING';
924: l_pay_group := fnd_profile.value('IGI_STP_PAYGROUP');

Line 922: l_interface_context :=fnd_profile.value('IGI_STP_INTERFACE_CONTEXT');

918: l_batch_source_name := fnd_profile.value('IGI_STP_RECEIVABLES_BATCH');
919: --l_batch_source_name := 'BR Automatic Numbering';
920: l_payables_source_name :=fnd_profile.value('IGI_STP_PAYABLES_SOURCE');
921: --l_payables_source_name := 'INVOICE GATEWAY';
922: l_interface_context :=fnd_profile.value('IGI_STP_INTERFACE_CONTEXT');
923: --l_interface_context := 'STP NETTING';
924: l_pay_group := fnd_profile.value('IGI_STP_PAYGROUP');
925: --l_pay_group := 'Standard';
926:

Line 924: l_pay_group := fnd_profile.value('IGI_STP_PAYGROUP');

920: l_payables_source_name :=fnd_profile.value('IGI_STP_PAYABLES_SOURCE');
921: --l_payables_source_name := 'INVOICE GATEWAY';
922: l_interface_context :=fnd_profile.value('IGI_STP_INTERFACE_CONTEXT');
923: --l_interface_context := 'STP NETTING';
924: l_pay_group := fnd_profile.value('IGI_STP_PAYGROUP');
925: --l_pay_group := 'Standard';
926:
927: IF l_pay_group is null
928: THEN

Line 934: --p_org_id := fnd_profile.value('ORG_ID');

930: l_pay_group := 'Standard';
931:
932: END IF;
933:
934: --p_org_id := fnd_profile.value('ORG_ID');
935: IF l_debug = 'TRUE'
936: THEN
937: l_message := 'ORG_ID : '||to_char(p_org_id);
938: fnd_file.put_line(fnd_file.log , l_message);

Line 943: --p_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');

939: l_variable := 'p_org_id';
940: l_value := to_char(p_org_id);
941: END IF;
942:
943: --p_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
944:
945: mo_utils.get_ledger_info(p_org_id,p_set_of_books_id,p_ledger_name);
946: IF l_debug = 'TRUE'
947: THEN

Line 966: p_user_id := fnd_profile.value('USER_ID');

962: l_variable := 'l_chart_of_accounts_id';
963: l_value := to_char(l_chart_of_accounts_id);
964: END IF;
965:
966: p_user_id := fnd_profile.value('USER_ID');
967: IF l_debug = 'TRUE'
968: THEN
969: l_message := 'USER_ID : '||to_char(p_user_id);
970: fnd_file.put_line(fnd_file.log , l_message);

Line 975: p_login_id := fnd_profile.value('LOGIN_ID');

971: l_variable := 'p_user_id';
972: l_value := to_char(p_user_id);
973: END IF;
974:
975: p_login_id := fnd_profile.value('LOGIN_ID');
976: IF l_debug = 'TRUE'
977: THEN
978: l_message := 'LOGIN_ID : '||to_char(p_login_id);
979: fnd_file.put_line(fnd_file.log , l_message);

Line 1514: fnd_profile.get('IGI_DEBUG',l_debug);

1510: p_net_batch_id in number,
1511: p_org_id in number) IS
1512: BEGIN
1513:
1514: fnd_profile.get('IGI_DEBUG',l_debug);
1515:
1516: l_message := '*** Open Interface for Netting called for batch '||p_net_batch_id||' ***';
1517: --fnd_file.put_line(fnd_file.log , l_message);
1518: --fnd_file.put_line(fnd_file.log , ' ');