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.IGI_EXP_UTILS dependencies on FND_PROFILE

Line 172: --FND_PROFILE.Get('GL_SET_OF_BKS_ID', l_sob_id);

168: RAISE e_invalid_params;
169: END IF;
170:
171: -- Get the set of books attached to the responsibility
172: --FND_PROFILE.Get('GL_SET_OF_BKS_ID', l_sob_id);
173: /*Bug#5905190 - MOAC changes start*/
174: -- Get current org_id
175: l_current_org_id := mo_global.get_current_org_id();
176: IF l_current_org_id is NULL THEN

Line 311: FND_PROFILE.GET('SO_SOURCE_CODE',v_source);

307: l_debug_info := 'v_status is: ';
308: --dbms_output.put_line(l_debug_info||','||v_status);
309: ----------------------------------
310:
311: FND_PROFILE.GET('SO_SOURCE_CODE',v_source);
312:
313:
314: -----------------------------
315: l_debug_info := ' FND_PROFILE.GET(SO_SOURCE_CODE is :';

Line 315: l_debug_info := ' FND_PROFILE.GET(SO_SOURCE_CODE is :';

311: FND_PROFILE.GET('SO_SOURCE_CODE',v_source);
312:
313:
314: -----------------------------
315: l_debug_info := ' FND_PROFILE.GET(SO_SOURCE_CODE is :';
316: --dbms_output.put_line(l_debug_info||','||v_source);
317: ----------------------------------
318:
319: v_count := 0;

Line 576: --fnd_profile.get('GL_SET_OF_BKS_ID', l_sob_id) ; -- commented for Bug 5905190

572:
573: p_update_gl_date := 'Y';
574:
575: -- get set of books id
576: --fnd_profile.get('GL_SET_OF_BKS_ID', l_sob_id) ; -- commented for Bug 5905190
577:
578: /*Bug#5905190 - MOAC changes start*/
579: -- Get current org_id
580: l_current_org_id := mo_global.get_current_org_id();

Line 936: apd.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),

932: /* shsaxena bug.2777575 START */
933:
934: UPDATE ap_invoice_distributions apd
935: SET apd.accounting_date = TRUNC(p_gl_date),
936: apd.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
937: apd.last_update_date = SYSDATE,
938: apd.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
939: WHERE apd.invoice_id = r_ap_invoices.invoice_id
940: AND apd.posted_flag = 'N';

Line 938: apd.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)

934: UPDATE ap_invoice_distributions apd
935: SET apd.accounting_date = TRUNC(p_gl_date),
936: apd.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
937: apd.last_update_date = SYSDATE,
938: apd.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
939: WHERE apd.invoice_id = r_ap_invoices.invoice_id
940: AND apd.posted_flag = 'N';
941:
942:

Line 947: apl.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),

943: /* dvjoshi bug#5905190 START
944:
945: UPDATE ap_invoice_lines apl
946: SET apl.gl_date = TRUNC(p_gl_date),
947: apl.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
948: apl.last_update_date = SYSDATE,
949: apl.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
950: WHERE apl.invoice_id = r_ap_invoices.invoice_id
951: AND EXISTS

Line 949: apl.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)

945: UPDATE ap_invoice_lines apl
946: SET apl.gl_date = TRUNC(p_gl_date),
947: apl.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
948: apl.last_update_date = SYSDATE,
949: apl.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
950: WHERE apl.invoice_id = r_ap_invoices.invoice_id
951: AND EXISTS
952: (SELECT 'x' FROM ap_invoice_distributions aid
953: WHERE aid.invoice_id = apl.invoice_id

Line 960: api.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),

956: dvjoshi bug#5905190 END */
957:
958: UPDATE ap_invoices api
959: SET api.gl_date = TRUNC(p_gl_date),
960: api.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
961: api.last_update_date = SYSDATE,
962: api.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
963: WHERE api.invoice_id = r_ap_invoices.invoice_id
964: AND EXISTS

Line 962: api.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)

958: UPDATE ap_invoices api
959: SET api.gl_date = TRUNC(p_gl_date),
960: api.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
961: api.last_update_date = SYSDATE,
962: api.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
963: WHERE api.invoice_id = r_ap_invoices.invoice_id
964: AND EXISTS
965: (SELECT 'x' FROM ap_invoice_distributions aid
966: WHERE aid.invoice_id = api.invoice_id

Line 1025: rgd.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),

1021: /* shsaxena bug.2777575 START */
1022:
1023: UPDATE ra_cust_trx_line_gl_dist rgd
1024: SET rgd.gl_date = TRUNC(p_gl_date),
1025: rgd.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
1026: rgd.last_update_date = SYSDATE,
1027: rgd.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
1028: WHERE rgd.customer_trx_id = r_ar_trx.customer_trx_id
1029: AND rgd.gl_posted_date IS NULL;

Line 1027: rgd.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)

1023: UPDATE ra_cust_trx_line_gl_dist rgd
1024: SET rgd.gl_date = TRUNC(p_gl_date),
1025: rgd.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
1026: rgd.last_update_date = SYSDATE,
1027: rgd.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
1028: WHERE rgd.customer_trx_id = r_ar_trx.customer_trx_id
1029: AND rgd.gl_posted_date IS NULL;
1030:
1031: UPDATE ra_customer_trx rct

Line 1033: rct.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),

1029: AND rgd.gl_posted_date IS NULL;
1030:
1031: UPDATE ra_customer_trx rct
1032: SET rct.trx_date = TRUNC(p_gl_date),
1033: rct.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
1034: rct.last_update_date = SYSDATE,
1035: rct.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
1036: WHERE rct.customer_trx_id = r_ar_trx.customer_trx_id
1037: AND EXISTS

Line 1035: rct.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)

1031: UPDATE ra_customer_trx rct
1032: SET rct.trx_date = TRUNC(p_gl_date),
1033: rct.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
1034: rct.last_update_date = SYSDATE,
1035: rct.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
1036: WHERE rct.customer_trx_id = r_ar_trx.customer_trx_id
1037: AND EXISTS
1038: (SELECT 'x' FROM ra_cust_trx_line_gl_dist rgd
1039: WHERE rgd.customer_trx_id = rct.customer_trx_id