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.PO_CLOSEOUT_PVT dependencies on PO_LOG

Line 4: d_pkg_name CONSTANT varchar2(50) := PO_LOG.get_package_base('PO_CLOSEOUT_PVT');

1: PACKAGE BODY PO_CLOSEOUT_PVT AS
2: --$Header: PO_CLOSEOUT_PVT.plb 120.9.12020000.22 2013/05/09 11:52:04 mabaig noship $
3:
4: d_pkg_name CONSTANT varchar2(50) := PO_LOG.get_package_base('PO_CLOSEOUT_PVT');
5:
6:
7: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
8: --------------------------------------------------------------------------------

Line 33: IF (PO_LOG.d_stmt) THEN

29: AS
30:
31: BEGIN
32:
33: IF (PO_LOG.d_stmt) THEN
34: PO_LOG.stmt(p_module_base => p_module_base,
35: p_position => p_position ,
36: p_message_text => p_log_message);
37: END IF;

Line 34: PO_LOG.stmt(p_module_base => p_module_base,

30:
31: BEGIN
32:
33: IF (PO_LOG.d_stmt) THEN
34: PO_LOG.stmt(p_module_base => p_module_base,
35: p_position => p_position ,
36: p_message_text => p_log_message);
37: END IF;
38:

Line 99: IF (PO_LOG.d_proc) THEN

95:
96: BEGIN
97:
98: d_position := 0;
99: IF (PO_LOG.d_proc) THEN
100: PO_LOG.proc_begin(d_module);
101: END IF;
102:
103: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_doc_id ' || p_doc_id);

Line 100: PO_LOG.proc_begin(d_module);

96: BEGIN
97:
98: d_position := 0;
99: IF (PO_LOG.d_proc) THEN
100: PO_LOG.proc_begin(d_module);
101: END IF;
102:
103: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_doc_id ' || p_doc_id);
104: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_closeout_type ' || p_closeout_type);

Line 238: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

234: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'x_contract_ver ' || x_contract_ver);
235: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'x_contract_type ' || x_contract_type);
236: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'x_return_status ' || x_return_status);
237:
238: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
239:
240: EXCEPTION
241: WHEN OTHERS THEN
242:

Line 296: IF (PO_LOG.d_proc) THEN

292: d_position NUMBER;
293:
294: BEGIN
295: d_position := 0;
296: IF (PO_LOG.d_proc) THEN
297: PO_LOG.proc_begin(d_module);
298: END IF;
299:
300: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);

Line 297: PO_LOG.proc_begin(d_module);

293:
294: BEGIN
295: d_position := 0;
296: IF (PO_LOG.d_proc) THEN
297: PO_LOG.proc_begin(d_module);
298: END IF;
299:
300: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);
301: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_closeout_type ' || p_closeout_type);

Line 351: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

347: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'x_contract_type ' || x_contract_type);
348: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'x_contract_id ' || x_contract_id);
349: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'x_contract_ver ' || x_contract_ver);
350:
351: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
352:
353: EXCEPTION
354: WHEN OTHERS THEN
355:

Line 414: IF (PO_LOG.d_proc) THEN

410:
411:
412: BEGIN
413: d_position := 0;
414: IF (PO_LOG.d_proc) THEN
415: PO_LOG.proc_begin(d_module);
416: END IF;
417:
418: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);

Line 415: PO_LOG.proc_begin(d_module);

411:
412: BEGIN
413: d_position := 0;
414: IF (PO_LOG.d_proc) THEN
415: PO_LOG.proc_begin(d_module);
416: END IF;
417:
418: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);
419: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_closeout_type ' || p_closeout_type);

Line 448: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

444: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'x_contract_type ' || x_contract_type);
445: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'x_contract_id ' || x_contract_id);
446: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'x_contract_ver ' || x_contract_ver);
447:
448: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
449:
450: EXCEPTION
451: WHEN OTHERS THEN
452:

Line 493: IF (PO_LOG.d_proc) THEN

489:
490:
491: BEGIN
492: d_position := 0;
493: IF (PO_LOG.d_proc) THEN
494: PO_LOG.proc_begin(d_module);
495: END IF;
496:
497: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);

Line 494: PO_LOG.proc_begin(d_module);

490:
491: BEGIN
492: d_position := 0;
493: IF (PO_LOG.d_proc) THEN
494: PO_LOG.proc_begin(d_module);
495: END IF;
496:
497: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);
498:

Line 514: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

510: ELSE
511: x_result_type := c_result_type_SUCCESS;
512: END IF;
513:
514: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
515:
516: EXCEPTION
517: WHEN NO_DATA_FOUND THEN
518: x_result_type := c_result_type_SUCCESS;

Line 555: IF (PO_LOG.d_proc) THEN

551:
552:
553: BEGIN
554: d_position := 0;
555: IF (PO_LOG.d_proc) THEN
556: PO_LOG.proc_begin(d_module);
557: END IF;
558:
559: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);

Line 556: PO_LOG.proc_begin(d_module);

552:
553: BEGIN
554: d_position := 0;
555: IF (PO_LOG.d_proc) THEN
556: PO_LOG.proc_begin(d_module);
557: END IF;
558:
559: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);
560:

Line 576: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

572: ELSE
573: x_result_type := c_result_type_SUCCESS;
574: END IF;
575:
576: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
577:
578: EXCEPTION
579:
580: WHEN NO_DATA_FOUND THEN

Line 617: IF (PO_LOG.d_proc) THEN

613:
614:
615: BEGIN
616: d_position := 0;
617: IF (PO_LOG.d_proc) THEN
618: PO_LOG.proc_begin(d_module);
619: END IF;
620:
621: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);

Line 618: PO_LOG.proc_begin(d_module);

614:
615: BEGIN
616: d_position := 0;
617: IF (PO_LOG.d_proc) THEN
618: PO_LOG.proc_begin(d_module);
619: END IF;
620:
621: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);
622:

Line 637: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

633: ELSE
634: x_result_type := c_result_type_SUCCESS;
635: END IF;
636:
637: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
638:
639: EXCEPTION
640: WHEN NO_DATA_FOUND THEN
641: x_result_type := c_result_type_SUCCESS;

Line 677: IF (PO_LOG.d_proc) THEN

673:
674:
675: BEGIN
676: d_position := 0;
677: IF (PO_LOG.d_proc) THEN
678: PO_LOG.proc_begin(d_module);
679: END IF;
680:
681: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);

Line 678: PO_LOG.proc_begin(d_module);

674:
675: BEGIN
676: d_position := 0;
677: IF (PO_LOG.d_proc) THEN
678: PO_LOG.proc_begin(d_module);
679: END IF;
680:
681: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);
682:

Line 723: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

719: x_result_type := c_result_type_FAILURE;
720:
721: END IF;
722:
723: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
724:
725: EXCEPTION
726: WHEN NO_DATA_FOUND THEN
727: x_result_type := c_result_type_FAILURE;

Line 769: IF (PO_LOG.d_proc) THEN

765:
766:
767: BEGIN
768: d_position := 0;
769: IF (PO_LOG.d_proc) THEN
770: PO_LOG.proc_begin(d_module);
771: END IF;
772:
773: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);

Line 770: PO_LOG.proc_begin(d_module);

766:
767: BEGIN
768: d_position := 0;
769: IF (PO_LOG.d_proc) THEN
770: PO_LOG.proc_begin(d_module);
771: END IF;
772:
773: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);
774:

Line 820: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

816: ELSE
817: x_result_type := c_result_type_FAILURE;
818: END IF;
819:
820: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
821:
822: EXCEPTION
823: WHEN NO_DATA_FOUND THEN
824: x_result_type := c_result_type_FAILURE;

Line 874: IF (PO_LOG.d_proc) THEN

870: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'validate_manage_closeout';
871:
872:
873: BEGIN
874: IF (PO_LOG.d_proc) THEN
875: PO_LOG.proc_begin(d_module);
876: END IF;
877:
878: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_doc_id ' || p_doc_id);

Line 875: PO_LOG.proc_begin(d_module);

871:
872:
873: BEGIN
874: IF (PO_LOG.d_proc) THEN
875: PO_LOG.proc_begin(d_module);
876: END IF;
877:
878: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_doc_id ' || p_doc_id);
879: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_chk_list_req ' || p_chk_list_req);

Line 1077: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

1073: END IF;
1074:
1075: l_progress := 100;
1076:
1077: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
1078:
1079: EXCEPTION
1080: WHEN OTHERS THEN
1081:

Line 1129: IF (PO_LOG.d_proc) THEN PO_LOG.proc_begin(d_module); END IF;

1125: WHERE MULTI_MOD_REQUEST_ID = p_req_id;
1126:
1127:
1128: BEGIN
1129: IF (PO_LOG.d_proc) THEN PO_LOG.proc_begin(d_module); END IF;
1130: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_req_id ' || p_req_id);
1131: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_chk_list_req ' || p_chk_list_req);
1132:
1133: l_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.NEW_INSTANCE();

Line 1256: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

1252: WHERE MULTI_MOD_REQUEST_ID = p_req_id;
1253:
1254: l_progress := 100;
1255:
1256: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259:
1260: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'check_exceptions : when others exception at '

Line 1324: IF (PO_LOG.d_proc) THEN PO_LOG.proc_begin(d_module); END IF;

1320: SELECT document_id
1321: FROM po_multi_mod_docs
1322: WHERE MULTI_MOD_REQUEST_ID = p_req_id;
1323: BEGIN
1324: IF (PO_LOG.d_proc) THEN PO_LOG.proc_begin(d_module); END IF;
1325: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_req_id ' || p_req_id);
1326: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1327: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1328: fnd_file.put_line(FND_FILE.LOG,'Closeout RequestSet Id: '|| p_req_id);

Line 1634: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

1630: fnd_file.put_line(FND_FILE.LOG, 'return message from Delete contract : ' || l_msg_data);
1631: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Delete contract status ' || l_return_status);
1632: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'return message from Delete contract : ' || l_msg_data);
1633: l_progress := 100;
1634: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
1635: EXCEPTION
1636: WHEN OTHERS THEN
1637: errbuf := sqlerrm;
1638: retcode := '2';

Line 1677: IF (PO_LOG.d_proc) THEN

1673: l_doc_ids VARCHAR2(2000);
1674: l_query VARCHAR2(2000);
1675:
1676: BEGIN
1677: IF (PO_LOG.d_proc) THEN
1678: PO_LOG.proc_begin(d_module);
1679: END IF;
1680: --PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_selected_docs ' || p_selected_docs);
1681:

Line 1678: PO_LOG.proc_begin(d_module);

1674: l_query VARCHAR2(2000);
1675:
1676: BEGIN
1677: IF (PO_LOG.d_proc) THEN
1678: PO_LOG.proc_begin(d_module);
1679: END IF;
1680: --PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_selected_docs ' || p_selected_docs);
1681:
1682: SELECT listagg(DOCUMENT_ID,',') within GROUP (ORDER BY DOCUMENT_ID)

Line 1704: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

1700: EXECUTE IMMEDIATE l_query INTO x_failed_docs;
1701: END IF;
1702:
1703: l_progress := 100;
1704: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
1705: EXCEPTION
1706: WHEN OTHERS THEN
1707:
1708: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'mass_closeout_validate_set : when others exception at '

Line 1771: IF (PO_LOG.d_proc) THEN

1767:
1768: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'validate_mass_closeout';
1769:
1770: BEGIN
1771: IF (PO_LOG.d_proc) THEN
1772: PO_LOG.proc_begin(d_module);
1773: END IF;
1774:
1775: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_req_id ' || p_req_id);

Line 1772: PO_LOG.proc_begin(d_module);

1768: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'validate_mass_closeout';
1769:
1770: BEGIN
1771: IF (PO_LOG.d_proc) THEN
1772: PO_LOG.proc_begin(d_module);
1773: END IF;
1774:
1775: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_req_id ' || p_req_id);
1776: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_chk_list_req ' || p_chk_list_req);

Line 2140: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

2136: WHERE MULTI_MOD_REQUEST_ID = p_req_id;
2137:
2138: l_progress := 100;
2139:
2140: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
2141:
2142: EXCEPTION
2143: WHEN OTHERS THEN
2144: errbuf := sqlerrm;

Line 2210: IF (PO_LOG.d_proc) THEN

2206:
2207: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'eligible_docs_for_closeout';
2208:
2209: BEGIN
2210: IF (PO_LOG.d_proc) THEN
2211: PO_LOG.proc_begin(d_module);
2212: END IF;
2213:
2214: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

Line 2211: PO_LOG.proc_begin(d_module);

2207: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'eligible_docs_for_closeout';
2208:
2209: BEGIN
2210: IF (PO_LOG.d_proc) THEN
2211: PO_LOG.proc_begin(d_module);
2212: END IF;
2213:
2214: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
2215: p_orig_system:= 'PER';

Line 2354: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

2350: END IF;
2351:
2352: END LOOP;
2353: CLOSE clmAwardAdmins;
2354: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
2355: fnd_file.put_line(FND_FILE.LOG,'Process Completed');
2356: EXCEPTION
2357: WHEN OTHERS THEN
2358: errbuf := sqlerrm;

Line 2410: IF (PO_LOG.d_proc) THEN

2406:
2407: BEGIN
2408:
2409: d_position := 0;
2410: IF (PO_LOG.d_proc) THEN
2411: PO_LOG.proc_begin(d_module);
2412: END IF;
2413:
2414: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_messages ' || messages);

Line 2411: PO_LOG.proc_begin(d_module);

2407: BEGIN
2408:
2409: d_position := 0;
2410: IF (PO_LOG.d_proc) THEN
2411: PO_LOG.proc_begin(d_module);
2412: END IF;
2413:
2414: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_messages ' || messages);
2415: l_firstcolon := instr(messages, '#');

Line 2431: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

2427: WF_NOTIFICATION.WriteToClob(document, l_msgbody);
2428:
2429: l_progress := 4;
2430:
2431: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
2432:
2433: EXCEPTION
2434: WHEN OTHERS THEN
2435: WF_CORE.context('PO_CLOSEOUT_PVT','get_eligible_doc_notfn_body',l_progress);

Line 2608: IF (PO_LOG.d_proc) THEN

2604:
2605: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'delete_contract';
2606:
2607: BEGIN
2608: IF (PO_LOG.d_proc) THEN
2609: PO_LOG.proc_begin(d_module);
2610: END IF;
2611:
2612: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_doc_id ' || p_doc_id);

Line 2609: PO_LOG.proc_begin(d_module);

2605: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'delete_contract';
2606:
2607: BEGIN
2608: IF (PO_LOG.d_proc) THEN
2609: PO_LOG.proc_begin(d_module);
2610: END IF;
2611:
2612: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_doc_id ' || p_doc_id);
2613: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_closeout_type ' || p_closeout_type);

Line 2675: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

2671: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'x_return_status ' || x_return_status);
2672:
2673: l_progress := 50;
2674:
2675: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
2676:
2677: EXCEPTION
2678: WHEN OTHERS THEN
2679:

Line 2731: IF (PO_LOG.d_proc) THEN

2727:
2728: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'set_closeout_status';
2729:
2730: BEGIN
2731: IF (PO_LOG.d_proc) THEN
2732: PO_LOG.proc_begin(d_module);
2733: END IF;
2734:
2735: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'itemkey ' || itemkey);

Line 2732: PO_LOG.proc_begin(d_module);

2728: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'set_closeout_status';
2729:
2730: BEGIN
2731: IF (PO_LOG.d_proc) THEN
2732: PO_LOG.proc_begin(d_module);
2733: END IF;
2734:
2735: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'itemkey ' || itemkey);
2736: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'itemtype ' || itemtype);

Line 2913: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

2909: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'insert query count ' || SQL%ROWCOUNT);
2910:
2911: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;
2912:
2913: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
2914:
2915: EXCEPTION
2916: WHEN OTHERS THEN
2917:

Line 2974: IF (PO_LOG.d_proc) THEN

2970:
2971: BEGIN
2972:
2973: d_position := 0;
2974: IF (PO_LOG.d_proc) THEN
2975: PO_LOG.proc_begin(d_module);
2976: END IF;
2977:
2978: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'PO_CLOSEOUT_PVT.get_clsout_err_msg_body: 01');

Line 2975: PO_LOG.proc_begin(d_module);

2971: BEGIN
2972:
2973: d_position := 0;
2974: IF (PO_LOG.d_proc) THEN
2975: PO_LOG.proc_begin(d_module);
2976: END IF;
2977:
2978: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'PO_CLOSEOUT_PVT.get_clsout_err_msg_body: 01');
2979: l_firstcolon := instr(message_type, ':');

Line 3016: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

3012: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'PO_CLOSEOUT_PVT.get_clsout_err_msg_body: 03');
3013:
3014: l_progress := 1;
3015:
3016: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
3017:
3018: EXCEPTION
3019: WHEN OTHERS THEN
3020: --l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);

Line 3075: IF (PO_LOG.d_proc) THEN

3071:
3072: BEGIN
3073:
3074: d_position := 0;
3075: IF (PO_LOG.d_proc) THEN
3076: PO_LOG.proc_begin(d_module);
3077: END IF;
3078:
3079: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_messages ' || messages);

Line 3076: PO_LOG.proc_begin(d_module);

3072: BEGIN
3073:
3074: d_position := 0;
3075: IF (PO_LOG.d_proc) THEN
3076: PO_LOG.proc_begin(d_module);
3077: END IF;
3078:
3079: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_messages ' || messages);
3080: l_firstcolon := instr(messages, '#');

Line 3095: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

3091: WF_NOTIFICATION.WriteToClob(document, l_msgbody);
3092:
3093: l_progress := 4;
3094:
3095: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
3096:
3097: EXCEPTION
3098: WHEN OTHERS THEN
3099: --l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);

Line 3155: IF (PO_LOG.d_proc) THEN

3151: d_position NUMBER;
3152:
3153: BEGIN
3154: d_position := 0;
3155: IF (PO_LOG.d_proc) THEN
3156: PO_LOG.proc_begin(d_module);
3157: END IF;
3158:
3159: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemkey ' || itemkey);

Line 3156: PO_LOG.proc_begin(d_module);

3152:
3153: BEGIN
3154: d_position := 0;
3155: IF (PO_LOG.d_proc) THEN
3156: PO_LOG.proc_begin(d_module);
3157: END IF;
3158:
3159: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemkey ' || itemkey);
3160: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemtype ' || itemtype);

Line 3240: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

3236:
3237: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'wf_validate_closeout result ' || resultout);
3238: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_result_type ' || l_result_type);
3239:
3240: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
3241:
3242: EXCEPTION
3243: WHEN OTHERS THEN
3244:

Line 3299: IF (PO_LOG.d_proc) THEN

3295: d_position NUMBER;
3296:
3297: BEGIN
3298: d_position := 0;
3299: IF (PO_LOG.d_proc) THEN
3300: PO_LOG.proc_begin(d_module);
3301: END IF;
3302:
3303: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemkey ' || itemkey);

Line 3300: PO_LOG.proc_begin(d_module);

3296:
3297: BEGIN
3298: d_position := 0;
3299: IF (PO_LOG.d_proc) THEN
3300: PO_LOG.proc_begin(d_module);
3301: END IF;
3302:
3303: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemkey ' || itemkey);
3304: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemtype ' || itemtype);

Line 3363: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

3359: ELSIF (l_return_status = fnd_api.g_ret_sts_error OR l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3360: resultout := wf_engine.eng_completed || ':' || 'ERROR' ;
3361: END IF;
3362:
3363: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
3364:
3365: EXCEPTION
3366: WHEN OTHERS THEN
3367:

Line 3420: IF (PO_LOG.d_proc) THEN

3416: d_position NUMBER;
3417:
3418: BEGIN
3419: d_position := 0;
3420: IF (PO_LOG.d_proc) THEN
3421: PO_LOG.proc_begin(d_module);
3422: END IF;
3423:
3424: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemkey ' || itemkey);

Line 3421: PO_LOG.proc_begin(d_module);

3417:
3418: BEGIN
3419: d_position := 0;
3420: IF (PO_LOG.d_proc) THEN
3421: PO_LOG.proc_begin(d_module);
3422: END IF;
3423:
3424: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemkey ' || itemkey);
3425: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemtype ' || itemtype);

Line 3429: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

3425: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemtype ' || itemtype);
3426:
3427: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;
3428:
3429: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
3430:
3431: EXCEPTION
3432: WHEN OTHERS THEN
3433:

Line 3486: IF (PO_LOG.d_proc) THEN

3482: d_position NUMBER;
3483:
3484: BEGIN
3485: d_position := 0;
3486: IF (PO_LOG.d_proc) THEN
3487: PO_LOG.proc_begin(d_module);
3488: END IF;
3489:
3490: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemkey ' || itemkey);

Line 3487: PO_LOG.proc_begin(d_module);

3483:
3484: BEGIN
3485: d_position := 0;
3486: IF (PO_LOG.d_proc) THEN
3487: PO_LOG.proc_begin(d_module);
3488: END IF;
3489:
3490: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemkey ' || itemkey);
3491: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemtype ' || itemtype);

Line 3518: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

3514: END;
3515:
3516: resultout := wf_engine.eng_completed || ':' || l_is_physical_complete;
3517:
3518: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
3519:
3520: EXCEPTION
3521: WHEN OTHERS THEN
3522:

Line 3566: IF (PO_LOG.d_proc) THEN

3562:
3563:
3564: BEGIN
3565: d_position := 0;
3566: IF (PO_LOG.d_proc) THEN
3567: PO_LOG.proc_begin(d_module);
3568: END IF;
3569:
3570: p_orig_system:= 'PER';

Line 3567: PO_LOG.proc_begin(d_module);

3563:
3564: BEGIN
3565: d_position := 0;
3566: IF (PO_LOG.d_proc) THEN
3567: PO_LOG.proc_begin(d_module);
3568: END IF;
3569:
3570: p_orig_system:= 'PER';
3571: WF_DIRECTORY.GetUserName(p_orig_system, p_employee_id, x_username, x_user_display_name);

Line 3573: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

3569:
3570: p_orig_system:= 'PER';
3571: WF_DIRECTORY.GetUserName(p_orig_system, p_employee_id, x_username, x_user_display_name);
3572:
3573: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
3574:
3575: EXCEPTION
3576: WHEN OTHERS THEN
3577: wf_core.context('PO_CLOSEOUTOUT_PVT','get_user_name',TO_CHAR(p_employee_id));

Line 3618: IF (PO_LOG.d_proc) THEN

3614: d_position NUMBER;
3615:
3616: BEGIN
3617: d_position := 0;
3618: IF (PO_LOG.d_proc) THEN
3619: PO_LOG.proc_begin(d_module);
3620: END IF;
3621:
3622: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemkey ' || itemkey);

Line 3619: PO_LOG.proc_begin(d_module);

3615:
3616: BEGIN
3617: d_position := 0;
3618: IF (PO_LOG.d_proc) THEN
3619: PO_LOG.proc_begin(d_module);
3620: END IF;
3621:
3622: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemkey ' || itemkey);
3623: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemtype ' || itemtype);

Line 3629: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

3625: l_administrator_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ADMINISTRATOR_ID');
3626: get_user_name(l_administrator_id, l_name, l_disp);
3627:
3628: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_name ' || l_name);
3629: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
3630:
3631: RETURN(l_name);
3632: END;
3633:

Line 3673: IF (PO_LOG.d_proc) THEN

3669:
3670: BEGIN
3671:
3672: d_position := 0;
3673: IF (PO_LOG.d_proc) THEN
3674: PO_LOG.proc_begin(d_module);
3675: END IF;
3676:
3677: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_itemtype ' || p_itemtype);

Line 3674: PO_LOG.proc_begin(d_module);

3670: BEGIN
3671:
3672: d_position := 0;
3673: IF (PO_LOG.d_proc) THEN
3674: PO_LOG.proc_begin(d_module);
3675: END IF;
3676:
3677: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_itemtype ' || p_itemtype);
3678: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_itemkey ' || p_itemkey);

Line 3692: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

3688:
3689: get_user_name(l_signer_id, l_name, l_disp_name);
3690:
3691: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_name ' || l_name);
3692: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
3693:
3694: RETURN(l_name);
3695: END get_signer;
3696:

Line 3752: IF (PO_LOG.d_proc) THEN

3748: d_position NUMBER;
3749: BEGIN
3750:
3751: d_position := 0;
3752: IF (PO_LOG.d_proc) THEN
3753: PO_LOG.proc_begin(d_module);
3754: END IF;
3755:
3756: l_firstcolon := instr(document_id, ':');

Line 3753: PO_LOG.proc_begin(d_module);

3749: BEGIN
3750:
3751: d_position := 0;
3752: IF (PO_LOG.d_proc) THEN
3753: PO_LOG.proc_begin(d_module);
3754: END IF;
3755:
3756: l_firstcolon := instr(document_id, ':');
3757: l_secondcolon := instr(document_id, ':', 1,2);

Line 3818: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

3814: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'PO_CLOSEOUT_PVT.get_sign_notfn_body: 03');
3815:
3816: l_progress := 1;
3817:
3818: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
3819:
3820: EXCEPTION
3821: WHEN OTHERS THEN
3822: --l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);

Line 3881: IF (PO_LOG.d_proc) THEN

3877: d_position NUMBER;
3878:
3879: BEGIN
3880: d_position := 0;
3881: IF (PO_LOG.d_proc) THEN
3882: PO_LOG.proc_begin(d_module);
3883: END IF;
3884:
3885: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);

Line 3882: PO_LOG.proc_begin(d_module);

3878:
3879: BEGIN
3880: d_position := 0;
3881: IF (PO_LOG.d_proc) THEN
3882: PO_LOG.proc_begin(d_module);
3883: END IF;
3884:
3885: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);
3886:

Line 4152: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

4148: END IF;
4149:
4150: x_return_status := FND_API.G_RET_STS_SUCCESS;
4151:
4152: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
4153:
4154: EXCEPTION
4155: WHEN OTHERS THEN
4156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4216: IF (PO_LOG.d_proc) THEN

4212:
4213: BEGIN
4214:
4215: d_position := 0;
4216: IF (PO_LOG.d_proc) THEN
4217: PO_LOG.proc_begin(d_module);
4218: END IF;
4219:
4220: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');

Line 4217: PO_LOG.proc_begin(d_module);

4213: BEGIN
4214:
4215: d_position := 0;
4216: IF (PO_LOG.d_proc) THEN
4217: PO_LOG.proc_begin(d_module);
4218: END IF;
4219:
4220: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
4221: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');

Line 4311: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

4307: avalue => l_pdf_generation_type);
4308:
4309:
4310: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
4311: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
4312:
4313: EXCEPTION
4314: WHEN OTHERS THEN
4315: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'PO_CLOSEOUT_PVT.Generate_Closeout_PDF: Error: '||SQLERRM);

Line 4364: IF (PO_LOG.d_proc) THEN

4360: d_position NUMBER;
4361:
4362: BEGIN
4363: d_position := 0;
4364: IF (PO_LOG.d_proc) THEN
4365: PO_LOG.proc_begin(d_module);
4366: END IF;
4367:
4368: l_message_type := wf_engine.GetActivityAttrText (itemtype => itemtype, itemkey => itemkey, actid => actid, aname => 'MESSAGE_TYPE');

Line 4365: PO_LOG.proc_begin(d_module);

4361:
4362: BEGIN
4363: d_position := 0;
4364: IF (PO_LOG.d_proc) THEN
4365: PO_LOG.proc_begin(d_module);
4366: END IF;
4367:
4368: l_message_type := wf_engine.GetActivityAttrText (itemtype => itemtype, itemkey => itemkey, actid => actid, aname => 'MESSAGE_TYPE');
4369: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');

Line 4497: IF (PO_LOG.d_proc) THEN

4493:
4494: BEGIN
4495:
4496: d_position := 0;
4497: IF (PO_LOG.d_proc) THEN
4498: PO_LOG.proc_begin(d_module);
4499: END IF;
4500:
4501: l_firstcolon := instr(document_id, ':');

Line 4498: PO_LOG.proc_begin(d_module);

4494: BEGIN
4495:
4496: d_position := 0;
4497: IF (PO_LOG.d_proc) THEN
4498: PO_LOG.proc_begin(d_module);
4499: END IF;
4500:
4501: l_firstcolon := instr(document_id, ':');
4502: l_secondcolon := instr(document_id, ':', 1,2);

Line 4533: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

4529: dbms_lob.Copy(document, l_document, l_document_length, 1, 1);
4530:
4531: document_type := l_filecontent_type ||'; name=' || l_filename;
4532:
4533: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
4534:
4535: EXCEPTION
4536: WHEN OTHERS THEN
4537: wf_core.context('PO_CLOSEOUT_PVT', 'get_closeout_pdf', l_progress);

Line 4615: IF (PO_LOG.d_proc) THEN

4611: -- Context setting revamp
4612: BEGIN
4613:
4614: d_position := 0;
4615: IF (PO_LOG.d_proc) THEN
4616: PO_LOG.proc_begin(d_module);
4617: END IF;
4618:
4619: --Context setting revamp

Line 4616: PO_LOG.proc_begin(d_module);

4612: BEGIN
4613:
4614: d_position := 0;
4615: IF (PO_LOG.d_proc) THEN
4616: PO_LOG.proc_begin(d_module);
4617: END IF;
4618:
4619: --Context setting revamp
4620: --

Line 4742: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

4738: );
4739:
4740: END IF;
4741:
4742: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
4743:
4744: -- Context setting revamp
4745: EXCEPTION
4746: WHEN OTHERS THEN

Line 4797: IF (PO_LOG.d_proc) THEN

4793: d_position NUMBER;
4794:
4795: BEGIN
4796: d_position := 0;
4797: IF (PO_LOG.d_proc) THEN
4798: PO_LOG.proc_begin(d_module);
4799: END IF;
4800:
4801: IF (funcmode = 'RUN') THEN

Line 4798: PO_LOG.proc_begin(d_module);

4794:
4795: BEGIN
4796: d_position := 0;
4797: IF (PO_LOG.d_proc) THEN
4798: PO_LOG.proc_begin(d_module);
4799: END IF;
4800:
4801: IF (funcmode = 'RUN') THEN
4802:

Line 4814: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;

4810: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;
4811:
4812: END IF;
4813:
4814: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
4815:
4816: EXCEPTION
4817: WHEN OTHERS THEN
4818: wf_core.context('PO_CLOSEOUT_PVT', 'get_closeout_pdf', d_position);