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.AHL_WARRANTY_UTILS_PVT dependencies on FND_GLOBAL

Line 182: l_user_id := to_number(fnd_global.USER_ID);

178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: END IF;
180: CLOSE get_cont_details;
181:
182: l_user_id := to_number(fnd_global.USER_ID);
183: l_login_id := to_number(fnd_global.LOGIN_ID);
184:
185:
186: --Calculate Expiration Dates for individual Counters associated with this contract.

Line 183: l_login_id := to_number(fnd_global.LOGIN_ID);

179: END IF;
180: CLOSE get_cont_details;
181:
182: l_user_id := to_number(fnd_global.USER_ID);
183: l_login_id := to_number(fnd_global.LOGIN_ID);
184:
185:
186: --Calculate Expiration Dates for individual Counters associated with this contract.
187: rec_i := 0;

Line 372: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);

368: END IF;
369:
370: -- 2. Dump all input parameters
371: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
372: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
373: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
374: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
375: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
376:

Line 373: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);

369:
370: -- 2. Dump all input parameters
371: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
372: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
373: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
374: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
375: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
376:
377: OPEN get_active_cont_ids;

Line 374: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);

370: -- 2. Dump all input parameters
371: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
372: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
373: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
374: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
375: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
376:
377: OPEN get_active_cont_ids;
378: FETCH get_active_cont_ids BULK COLLECT INTO l_warranty_contract_id_tbl;

Line 532: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);

528: END IF;
529:
530: -- 2. Dump all input parameters
531: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
532: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
533: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
534: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
535: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
536:

Line 533: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);

529:
530: -- 2. Dump all input parameters
531: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
532: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
533: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
534: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
535: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
536:
537: -- Bulk collect

Line 534: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);

530: -- 2. Dump all input parameters
531: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
532: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
533: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
534: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
535: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
536:
537: -- Bulk collect
538: OPEN disable_templates_csr;

Line 542: l_user_id := to_number(fnd_global.USER_ID);

538: OPEN disable_templates_csr;
539: FETCH disable_templates_csr BULK COLLECT INTO csrTbl;
540: CLOSE disable_templates_csr;
541:
542: l_user_id := to_number(fnd_global.USER_ID);
543: l_login_id := to_number(fnd_global.LOGIN_ID);
544:
545: fnd_file.put_line(fnd_file.log, 'before updating table AHL_WARRANTY_TEMPLATES_B, rows = ' || csrTbl.COUNT );
546:

Line 543: l_login_id := to_number(fnd_global.LOGIN_ID);

539: FETCH disable_templates_csr BULK COLLECT INTO csrTbl;
540: CLOSE disable_templates_csr;
541:
542: l_user_id := to_number(fnd_global.USER_ID);
543: l_login_id := to_number(fnd_global.LOGIN_ID);
544:
545: fnd_file.put_line(fnd_file.log, 'before updating table AHL_WARRANTY_TEMPLATES_B, rows = ' || csrTbl.COUNT );
546:
547: FOR i IN 1..csrTbl.COUNT

Line 636: l_user_id NUMBER := fnd_global.user_id;

632: L_API_NAME CONSTANT VARCHAR2(30) := 'Disable_Templates_For_Vendor';
633: L_API_VERSION CONSTANT NUMBER := 1.0;
634: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
635:
636: l_user_id NUMBER := fnd_global.user_id;
637: l_login_id NUMBER := fnd_global.login_id;
638:
639:
640: --Cursors

Line 637: l_login_id NUMBER := fnd_global.login_id;

633: L_API_VERSION CONSTANT NUMBER := 1.0;
634: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
635:
636: l_user_id NUMBER := fnd_global.user_id;
637: l_login_id NUMBER := fnd_global.login_id;
638:
639:
640: --Cursors
641: --JKJain, 30 Nov 2010

Line 821: l_user_id NUMBER := fnd_global.user_id;

817: l_msg_data VARCHAR2(2000);
818: l_return_status VARCHAR2(1);
819: l_msg_count NUMBER;
820:
821: l_user_id NUMBER := fnd_global.user_id;
822: l_login_id NUMBER := fnd_global.login_id;
823:
824: l_row_char VARCHAR2(30);
825: l_attch_doc_id NUMBER;

Line 822: l_login_id NUMBER := fnd_global.login_id;

818: l_return_status VARCHAR2(1);
819: l_msg_count NUMBER;
820:
821: l_user_id NUMBER := fnd_global.user_id;
822: l_login_id NUMBER := fnd_global.login_id;
823:
824: l_row_char VARCHAR2(30);
825: l_attch_doc_id NUMBER;
826: l_doc_id NUMBER := null;