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_FILE

Line 371: fnd_file.put_line(fnd_file.log, '*API input parameters**');

367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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());

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 375: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());

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;
379: CLOSE get_active_cont_ids;

Line 383: fnd_file.put_line(fnd_file.log, 'before calling Calc_Contract_Exp_Date, number of records = '||l_count);

379: CLOSE get_active_cont_ids;
380:
381: l_count := l_warranty_contract_id_tbl.COUNT;
382:
383: fnd_file.put_line(fnd_file.log, 'before calling Calc_Contract_Exp_Date, number of records = '||l_count);
384:
385: Calc_Contract_Exp_Date(
386: p_api_version => p_api_version,
387: p_module_type => 'CP', --passing p_module_type as Concurrent Program

Line 396: fnd_file.put_line(fnd_file.log, 'Following error occured while calculating Warranty Expiration...');

392:
393:
394: l_msg_count := FND_MSG_PUB.Count_Msg;
395: IF (l_msg_count > 0) THEN
396: fnd_file.put_line(fnd_file.log, 'Following error occured while calculating Warranty Expiration...');
397: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
398: RAISE FND_API.G_EXC_ERROR;
399: ELSE
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 404: fnd_file.put_line(fnd_file.log, 'After calling Calc_Contract_Exp_Date successfully');

400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402: END IF;
403:
404: fnd_file.put_line(fnd_file.log, 'After calling Calc_Contract_Exp_Date successfully');
405:
406: -- set the output
407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Successfully calculated and updated expiration date for '|| l_count ||' warranty contracts. ');
408:

Line 407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Successfully calculated and updated expiration date for '|| l_count ||' warranty contracts. ');

403:
404: fnd_file.put_line(fnd_file.log, 'After calling Calc_Contract_Exp_Date successfully');
405:
406: -- set the output
407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Successfully calculated and updated expiration date for '|| l_count ||' warranty contracts. ');
408:
409:
410: EXCEPTION
411: WHEN FND_API.G_EXC_ERROR THEN

Line 422: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);

418: p_encoded => FND_API.G_FALSE,
419: p_data => l_err_msg,
420: p_msg_index_out => l_msg_index_out);
421:
422: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
423: END LOOP;
424:
425:
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 438: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);

434: p_encoded => FND_API.G_FALSE,
435: p_data => l_err_msg,
436: p_msg_index_out => l_msg_index_out);
437:
438: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
439: END LOOP;
440:
441:
442: WHEN OTHERS THEN

Line 459: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);

455: p_encoded => FND_API.G_FALSE,
456: p_data => l_err_msg,
457: p_msg_index_out => l_msg_index_out);
458:
459: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
460: END LOOP;
461:
462:
463: END Calc_Contract_Exp_Date_CP;

Line 531: fnd_file.put_line(fnd_file.log, '*API input parameters**');

527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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());

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 535: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());

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;
539: FETCH disable_templates_csr BULK COLLECT INTO csrTbl;

Line 545: fnd_file.put_line(fnd_file.log, 'before updating table AHL_WARRANTY_TEMPLATES_B, rows = ' || csrTbl.COUNT );

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
548: LOOP
549: UPDATE AHL_WARRANTY_TEMPLATES_B SET ENABLED_FLAG = 'N',

Line 559: fnd_file.put_line(fnd_file.log, 'After updating table AHL_WARRANTY_TEMPLATES_B successfully');

555: WHERE WARRANTY_TEMPLATE_ID = csrTbl(i).warranty_template_id;
556:
557: END LOOP;
558:
559: fnd_file.put_line(fnd_file.log, 'After updating table AHL_WARRANTY_TEMPLATES_B successfully');
560:
561: -- set the output
562: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Successfully disables '|| csrTbl.COUNT ||' Warranty Templates having end date less than '||sysdate);
563:

Line 562: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Successfully disables '|| csrTbl.COUNT ||' Warranty Templates having end date less than '||sysdate);

558:
559: fnd_file.put_line(fnd_file.log, 'After updating table AHL_WARRANTY_TEMPLATES_B successfully');
560:
561: -- set the output
562: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Successfully disables '|| csrTbl.COUNT ||' Warranty Templates having end date less than '||sysdate);
563:
564: EXCEPTION
565:
566: WHEN OTHERS THEN

Line 583: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);

579: p_encoded => FND_API.G_FALSE,
580: p_data => l_err_msg,
581: p_msg_index_out => l_msg_index_out);
582:
583: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
584: END LOOP;
585:
586:
587: END Disable_Templates_CP;