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_DRAFT_MERGE_PKG dependencies on PO_WF_DEBUG_PKG

Line 243: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

239: l_document_id Number := -1;
240: l_attach_count Number := 0;
241: Begin
242: x_progress := 'PO_DRAFT_MERGE_PKG.MANAGE_ATTACHMENTS_MERGE: Start: 01';
243: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
244: --Check if the modification has any attachments
245:
246: BEGIN
247: select 'Y'

Line 298: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

294:
295: --Merging header level attachments
296: merge_header_attachments(p_document_id, p_draft_id);
297: x_progress := 'Header attachment copied from Modification to header ';
298: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
299:
300: --Merging line level attachments
301: MERGE_LINE_ATTACHMENTS(p_draft_id);
302: x_progress := 'Line attachment copied from Modification to header ';

Line 303: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

299:
300: --Merging line level attachments
301: MERGE_LINE_ATTACHMENTS(p_draft_id);
302: x_progress := 'Line attachment copied from Modification to header ';
303: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
304:
305: --Merging shipment level attachments
306: MERGE_LINE_LOCATION_ATTACHMENT(p_draft_id);
307: x_progress := 'Line locations attachment copied from Modification to header ';

Line 308: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

304:
305: --Merging shipment level attachments
306: MERGE_LINE_LOCATION_ATTACHMENT(p_draft_id);
307: x_progress := 'Line locations attachment copied from Modification to header ';
308: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
309:
310: END IF;
311:
312: ELSE

Line 314: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

310: END IF;
311:
312: ELSE
313: x_progress := 'Attachments do not exist for the current modification ';
314: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
315: END IF;
316:
317: Exception
318: When Others Then

Line 320: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

316:
317: Exception
318: When Others Then
319: x_progress := 'PO_DRAFT_MERGE_PKG.MANAGE_ATTACHMENTS_MERGE: Exception';
320: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
321: raise;
322: End;
323:
324: procedure update_mod_approved_date(p_draft_id IN NUMBER,

Line 353: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

349: l_draft_id Number := -1;
350: Begin
351:
352: x_progress := 'PO_DRAFT_MERGE_PKG.INSERT_ACT_HIST_MERGE: Start: 01';
353: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
354: -- CLM Aprvl
355: l_draft_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
356: itemkey => itemkey,
357: aname => 'DRAFT_ID');

Line 371: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

367: funcmode,
368: resultout);
369:
370: x_progress := 'PO_DRAFT_MERGE_PKG.INSERT_ACT_HIST_MERGE: End';
371: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
372:
373: resultout := wf_engine.eng_completed || ':' || 'Y';
374: Exception
375: When Others Then

Line 377: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

373: resultout := wf_engine.eng_completed || ':' || 'Y';
374: Exception
375: When Others Then
376: x_progress := 'PO_DRAFT_MERGE_PKG.INSERT_ACT_HIST_MERGE: Exception';
377: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
378: resultout := wf_engine.eng_completed || ':' || 'N';
379: raise;
380: End;
381:

Line 394: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

390: l_draft_id Number := -1;
391: Begin
392:
393: x_progress := 'PO_DRAFT_MERGE_PKG.IS_PDF_COMM_ENABLED: Start: 01';
394: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
395: -- CLM Aprvl
396: l_draft_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
397: itemkey => itemkey,
398: aname => 'DRAFT_ID');

Line 405: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

401: l_draft_id := -1;
402: End If;
403: -- CLM Aprvl
404: x_progress := 'PO_DRAFT_MERGE_PKG.IS_PDF_COMM_ENABLED: End';
405: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
406:
407: resultout := wf_engine.eng_completed || ':' || 'Y';
408: Exception
409: When Others Then

Line 411: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

407: resultout := wf_engine.eng_completed || ':' || 'Y';
408: Exception
409: When Others Then
410: x_progress := 'PO_DRAFT_MERGE_PKG.IS_PDF_COMM_ENABLED: Exception';
411: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
412: resultout := wf_engine.eng_completed || ':' || 'N';
413: raise;
414: End;
415:

Line 428: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

424: l_draft_id Number := -1;
425: Begin
426:
427: x_progress := 'PO_DRAFT_MERGE_PKG.DELETE_PDF_ATTACHMENTS: Start: 01';
428: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
429: -- CLM Aprvl
430: l_draft_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
431: itemkey => itemkey,
432: aname => 'DRAFT_ID');

Line 439: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

435: l_draft_id := -1;
436: End If;
437: -- CLM Aprvl
438: x_progress := 'PO_DRAFT_MERGE_PKG.DELETE_PDF_ATTACHMENTS: End';
439: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
440:
441: resultout := wf_engine.eng_completed || ':' || 'Y';
442: Exception
443: When Others Then

Line 445: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

441: resultout := wf_engine.eng_completed || ':' || 'Y';
442: Exception
443: When Others Then
444: x_progress := 'PO_DRAFT_MERGE_PKG.DELETE_PDF_ATTACHMENTS: Exception';
445: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
446: resultout := wf_engine.eng_completed || ':' || 'N';
447: raise;
448: End;
449:

Line 462: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

458: l_draft_id Number := -1;
459: Begin
460:
461: x_progress := 'PO_DRAFT_MERGE_PKG.INSERT_ACT_HIST_REJECT: Start: 01';
462: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
463: -- CLM Aprvl
464: l_draft_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
465: itemkey => itemkey,
466: aname => 'DRAFT_ID');

Line 474: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

470: End If;
471: -- CLM Aprvl
472:
473: x_progress := 'PO_DRAFT_MERGE_PKG.INSERT_ACT_HIST_REJECT: calling POR_AME_REQ_WF_PVT.update_action_history_reject ';
474: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
475:
476: x_progress := 'PO_DRAFT_MERGE_PKG.INSERT_ACT_HIST_REJECT: calling PO_REQAPPROVAL_ACTION.reject_doc';
477: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
478: POR_AME_REQ_WF_PVT.update_action_history_reject(

Line 477: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

473: x_progress := 'PO_DRAFT_MERGE_PKG.INSERT_ACT_HIST_REJECT: calling POR_AME_REQ_WF_PVT.update_action_history_reject ';
474: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
475:
476: x_progress := 'PO_DRAFT_MERGE_PKG.INSERT_ACT_HIST_REJECT: calling PO_REQAPPROVAL_ACTION.reject_doc';
477: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
478: POR_AME_REQ_WF_PVT.update_action_history_reject(
479: itemtype,
480: itemkey,
481: actid,

Line 494: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

490: resultout);
491:
492: x_progress := 'PO_DRAFT_MERGE_PKG.INSERT_ACT_HIST_MERGE: End';
493: x_progress := 'PO_DRAFT_MERGE_PKG.INSERT_ACT_HIST_REJECT: End';
494: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
495:
496: resultout := wf_engine.eng_completed || ':' || 'Y';
497: Exception
498: When Others Then

Line 500: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

496: resultout := wf_engine.eng_completed || ':' || 'Y';
497: Exception
498: When Others Then
499: x_progress := 'PO_DRAFT_MERGE_PKG.INSERT_ACT_HIST_REJECT: Exception';
500: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
501: resultout := wf_engine.eng_completed || ':' || 'N';
502: raise;
503: End;
504:

Line 552: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

548:
549: savepoint UPDATE_AWARD_MOD_VALUES_SP; -- Bug 14046925 : Adding savepoint
550:
551: x_progress := 'PO_DRAFT_MERGE_PKG.UPDATE_AWARD_WITH_MOD_VALUES: Start: 01';
552: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
553:
554: l_draft_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,itemkey => itemkey,aname => 'DRAFT_ID');
555: l_document_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_ID');
556: l_document_type := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_TYPE');

Line 617: po_wf_debug_pkg.Insert_debug(itemtype,itemkey, x_progress );

613:
614: END IF;
615:
616: x_progress := 'Calling MergeReserve_Autonomous with Draft : '||l_draft_id ||' Document Id : ' || l_document_id;
617: po_wf_debug_pkg.Insert_debug(itemtype,itemkey, x_progress );
618:
619: MergeReserve_Autonomous(
620: itemtype => itemtype,
621: itemkey => itemkey,

Line 635: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,x_progress );

631: x_online_report_id => l_online_report_id,
632: x_return_status=> l_return_status);
633:
634: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous - Return Status: '|| l_return_status ;
635: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,x_progress );
636:
637: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR l_return_status IS NULL) THEN
638: -- copying message from po_online_report_text_gt
639: g_action:= 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : ';

Line 642: po_wf_debug_pkg.Insert_debug(itemtype,itemkey, g_action || g_error_message );

638: -- copying message from po_online_report_text_gt
639: g_action:= 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : ';
640: SELECT TEXT_LINE into g_error_message FROM po_online_report_text_gt WHERE online_report_id = l_online_report_id
641: and rownum =1;
642: po_wf_debug_pkg.Insert_debug(itemtype,itemkey, g_action || g_error_message );
643: g_result := l_return_status;
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645:
646: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 650: po_wf_debug_pkg.Insert_debug(itemtype,itemkey, x_progress );

646: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
647: IF (l_Encumbrance_on) AND (l_po_return_code NOT IN ( po_document_funds_pvt.g_return_success, PO_DOCUMENT_FUNDS_PVT.g_return_WARNING))
648: THEN
649: x_progress := 'MergeReserve_Autonomous - Po Return Code: '|| l_po_return_code;
650: po_wf_debug_pkg.Insert_debug(itemtype,itemkey, x_progress );
651: resultout := wf_engine.eng_completed || ':' || 'N';
652: RETURN;
653: END IF;
654: END IF;

Line 662: po_wf_debug_pkg.Insert_debug(itemtype,itemkey, x_progress );

658: THEN
659: -- Rebuild catalog search index.
660: BEGIN
661: x_progress := 'Calling ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index : ';
662: po_wf_debug_pkg.Insert_debug(itemtype,itemkey, x_progress );
663: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
664: EXCEPTION
665: WHEN OTHERS THEN
666: g_error_message := 'Exception for ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index and erorr encountered is ' ||SQLCODE||' -ERROR- '||SQLERRM ;

Line 668: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

664: EXCEPTION
665: WHEN OTHERS THEN
666: g_error_message := 'Exception for ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index and erorr encountered is ' ||SQLCODE||' -ERROR- '||SQLERRM ;
667: x_progress := 'PO_DRAFT_MERGE_PKG.UPDATE_AWARD_WITH_MOD_VALUES: ' || g_error_message;
668: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
669: END;
670: END IF;
671:
672: IF l_draft_id <> -1 THEN

Line 685: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

681: Exception
682: When Others Then
683: ROLLBACK to UPDATE_AWARD_MOD_VALUES_SP; -- Rolling back to savepoint in case of any errors
684: x_progress := 'PO_DRAFT_MERGE_PKG.UPDATE_AWARD_WITH_MOD_VALUES: Exception';
685: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
686: -- Bug14046925 : Setting workflow attributes with values
687: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
688: itemkey => itemkey,
689: aname => 'MERGE_RESERVE_ACTION',

Line 760: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

756:
757: BEGIN
758:
759: x_progress := 'PO_DRAFT_MERGE_PKG.PROCESS_CONTROL_ACTIONS: Start: 01';
760: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
761:
762: l_draft_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,itemkey => itemkey,aname => 'DRAFT_ID');
763: IF l_draft_id IS NOT NULL ANd l_draft_id <> -1 THEN
764: select phd.type_lookup_code,

Line 932: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

928: resultout := wf_engine.eng_completed || ':' || 'Y';
929: EXCEPTION
930: WHEN OTHERS THEN
931: x_progress := 'PO_DRAFT_MERGE_PKG.Process_control_actions: Exception';
932: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
933: resultout := wf_engine.eng_completed || ':' || 'N';
934: raise;
935: END PROCESS_CONTROL_ACTIONS;
936:

Line 953: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

949: l_is_clm_document varchar2(1);
950: Begin
951:
952: x_progress := 'PO_DRAFT_MERGE_PKG.IS_CLM_DOCUMENT: Start: 01';
953: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
954:
955: l_document_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
956: itemkey => itemkey,
957: aname => 'DOCUMENT_ID');

Line 969: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

965: AND poh.po_header_id = l_document_id;
966: EXCEPTION
967: WHEN no_data_found THEN
968: x_progress := 'PO_DRAFT_MERGE_PKG.IS_CLM_DOCUMENT: in no data found exception';
969: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
970: resultout := wf_engine.eng_completed || ':' || 'N';
971: END;
972:
973: x_progress := 'PO_DRAFT_MERGE_PKG.IS_CLM_DOCUMENT: l_is_clm_document: '||l_is_clm_document;

Line 974: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

970: resultout := wf_engine.eng_completed || ':' || 'N';
971: END;
972:
973: x_progress := 'PO_DRAFT_MERGE_PKG.IS_CLM_DOCUMENT: l_is_clm_document: '||l_is_clm_document;
974: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
975: resultout := wf_engine.eng_completed || ':' || l_is_clm_document;
976:
977:
978: Exception

Line 981: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

977:
978: Exception
979: When Others Then
980: x_progress := 'PO_DRAFT_MERGE_PKG.IS_CLM_DOCUMENT: Exception';
981: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
982: raise;
983: End;
984:
985: PROCEDURE MergeReserve_Autonomous(

Line 1018: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'MergeReserve_Autonomous : Start');

1014: resultout VARCHAR2(1);
1015: l_is_clm_document VARCHAR2(1);
1016: BEGIN
1017:
1018: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'MergeReserve_Autonomous : Start');
1019: SAVEPOINT MergeReserve_Autonomous_SP;
1020: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Savepoint MergeReserve_Autonomous_SP';
1021: /*fed fields : update IDV total_amt_ordered for header and line and total qty ordered for line*/
1022: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_DOCUMENT_ACTION_UTIL.upd_idv_qty_amt_hdr';

Line 1023: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

1019: SAVEPOINT MergeReserve_Autonomous_SP;
1020: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Savepoint MergeReserve_Autonomous_SP';
1021: /*fed fields : update IDV total_amt_ordered for header and line and total qty ordered for line*/
1022: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_DOCUMENT_ACTION_UTIL.upd_idv_qty_amt_hdr';
1023: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);
1024: PO_DOCUMENT_ACTION_UTIL.upd_idv_qty_amt_hdr(p_po_header_id => P_Document_Id
1025: , p_draft_id => p_draft_id
1026: , p_po_mode => PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE
1027: , x_return_status => x_return_status

Line 1031: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

1027: , x_return_status => x_return_status
1028: );
1029: IF p_draft_id <> -1 THEN
1030: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Draft Id: '||p_draft_id ||'. Merge with Award Id: '||P_Document_Id;
1031: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1032:
1033: -- Copying contract details to base document
1034: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_CONTERMS_UTL_GRP.copy_conterms_mod';
1035: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

Line 1035: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

1031: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1032:
1033: -- Copying contract details to base document
1034: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_CONTERMS_UTL_GRP.copy_conterms_mod';
1035: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);
1036: PO_CONTERMS_UTL_GRP.copy_conterms_mod(
1037: p_document_id => p_document_id,
1038: p_draft_id => p_draft_id,
1039: p_to_mod => 'N',

Line 1055: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

1051: x_return_status => l_return_status,
1052: p_caller => 'MERGE');
1053:
1054: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Merge Return Status: '||l_return_status;
1055: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1056:
1057: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1058: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Merge Successful';
1059: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);

Line 1059: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);

1055: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1056:
1057: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1058: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Merge Successful';
1059: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1060: ELSE
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062: END IF;
1063:

Line 1067: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

1063:
1064: -- Update the approved_date of the header draft
1065: -- which is used as the signed date of the modification
1066: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : update_mod_approved_date';
1067: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);
1068: update_mod_approved_date(p_draft_id => p_draft_id,
1069: p_document_id => p_document_id);
1070:
1071: --Mod Commercialization

Line 1079: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

1075: FROM po_headers_all
1076: WHERE PO_HEADER_ID = p_document_id;
1077:
1078: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_CLM_CLO_UTIL.Check_Uda_Enabled';
1079: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);
1080: PO_CLM_CLO_UTIL.Check_Uda_Enabled
1081: (
1082: p_functional_area_code => l_functional_area_code
1083: ,p_document_type_code => l_document_type_code

Line 1093: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);

1089: ,x_msg_data => l_msg_data
1090: );
1091:
1092: x_progress := 'After Check_Uda_Enabled with x_return_status : ' || l_return_status;
1093: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1094:
1095: x_progress := 'Check_Uda_Enabled with x_enabled_flag : ' || l_enabled_flag;
1096: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1097:

Line 1096: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);

1092: x_progress := 'After Check_Uda_Enabled with x_return_status : ' || l_return_status;
1093: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1094:
1095: x_progress := 'Check_Uda_Enabled with x_enabled_flag : ' || l_enabled_flag;
1096: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1097:
1098: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1099: THEN
1100: g_result := l_return_status;

Line 1102: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_error_message);

1098: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1099: THEN
1100: g_result := l_return_status;
1101: g_error_message := l_msg_data ;
1102: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_error_message);
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: END IF;
1105:
1106: IF l_enabled_flag = 'Y' THEN

Line 1109: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

1105:
1106: IF l_enabled_flag = 'Y' THEN
1107:
1108: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_DOC_UDA_UTIL.merge_mod_uda';
1109: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);
1110: PO_DOC_UDA_UTIL.merge_mod_uda(
1111: p_po_header_id => P_Document_Id,
1112: p_draft_id => p_draft_id,
1113: x_return_status => l_return_status );

Line 1116: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

1112: p_draft_id => p_draft_id,
1113: x_return_status => l_return_status );
1114:
1115: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Uda Merge Return Status: '||l_return_status;
1116: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1117:
1118: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END IF;

Line 1125: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);

1121:
1122: -- TODO : THIS CHECK IS IRRELAVENT AS TRANSFER TO DRAFT DOESN'T RETURN TRUE/FALSE
1123: If l_return_status <> FND_API.G_FALSE THEN
1124: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Merge Successful';
1125: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1126: End If;
1127:
1128: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_DRAFTS_PVT.update_revnum_headers_ext';
1129: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

Line 1129: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

1125: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1126: End If;
1127:
1128: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_DRAFTS_PVT.update_revnum_headers_ext';
1129: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);
1130: PO_DRAFTS_PVT.update_revnum_headers_ext(p_draft_id =>p_draft_id,
1131: p_po_header_id =>P_Document_Id);
1132:
1133: END IF;

Line 1137: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

1133: END IF;
1134: --End Mod Commercialization
1135: --
1136: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : delete_entity_locks';
1137: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);
1138: delete_entity_locks(p_draft_id => p_draft_id
1139: ,x_return_status => l_return_status);
1140:
1141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1143: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

1139: ,x_return_status => l_return_status);
1140:
1141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1142: x_progress := 'PO_DRAFT_MERGE_PKG.UPDATE_AWARD_WITH_MOD_VALUES: Deleting entity locks failed';
1143: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1145: END IF;
1146:
1147: x_progress := 'PO_DRAFT_MERGE_PKG.UPDATE_AWARD_WITH_MOD_VALUES: deleting entity locks successful';

Line 1148: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1145: END IF;
1146:
1147: x_progress := 'PO_DRAFT_MERGE_PKG.UPDATE_AWARD_WITH_MOD_VALUES: deleting entity locks successful';
1148: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1149: --end of concurrent
1150:
1151: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_DOCUMENT_ACTION_PVT.do_approve for Mod';
1152: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

Line 1152: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

1148: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1149: --end of concurrent
1150:
1151: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_DOCUMENT_ACTION_PVT.do_approve for Mod';
1152: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);
1153: PO_DOCUMENT_ACTION_PVT.do_approve(
1154: p_document_id => P_Document_Id
1155: , p_document_type => p_doc_type
1156: , p_document_subtype => p_doc_subtype

Line 1166: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_error_message);

1162: );
1163: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1164: g_result := l_return_status;
1165: g_error_message := x_exception_msg || 'Exception while call to PO_DOCUMENT_ACTION_PVT.do_approve failed';
1166: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_error_message);
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:
1170: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : MANAGE_ATTACHMENTS_MERGE';

Line 1171: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:
1170: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : MANAGE_ATTACHMENTS_MERGE';
1171: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);
1172: -- Copying the attachments
1173: MANAGE_ATTACHMENTS_MERGE(itemtype ,
1174: itemkey ,
1175: p_document_id => P_Document_Id,

Line 1194: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,' Skip Reserve Call, as Encumbrance is Not supported for CLM Agreements');

1190:
1191: --Encumbrance is Not Supported for CLM Agreements
1192: IF (p_doc_type = 'PA' AND
1193: Po_Partial_Funding_pkg.Is_clm_Document(p_doc_Type => 'PA', p_doc_level_id => p_document_id ) = 'Y') THEN
1194: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,' Skip Reserve Call, as Encumbrance is Not supported for CLM Agreements');
1195:
1196: ELSE
1197: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,'Calling do Reserve with doctype: '||p_doc_type||' - sub: '||p_doc_subtype||'- document id: '||p_document_id||' - Ovrride: '||p_override_funds||'- Emp: '||p_employee_id||'.');
1198: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : po_document_funds_pvt.Do_reserve';

Line 1197: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,'Calling do Reserve with doctype: '||p_doc_type||' - sub: '||p_doc_subtype||'- document id: '||p_document_id||' - Ovrride: '||p_override_funds||'- Emp: '||p_employee_id||'.');

1193: Po_Partial_Funding_pkg.Is_clm_Document(p_doc_Type => 'PA', p_doc_level_id => p_document_id ) = 'Y') THEN
1194: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,' Skip Reserve Call, as Encumbrance is Not supported for CLM Agreements');
1195:
1196: ELSE
1197: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,'Calling do Reserve with doctype: '||p_doc_type||' - sub: '||p_doc_subtype||'- document id: '||p_document_id||' - Ovrride: '||p_override_funds||'- Emp: '||p_employee_id||'.');
1198: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : po_document_funds_pvt.Do_reserve';
1199: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);
1200:
1201: G_RESERVE_FROM_MOD_MERGE := 'Y'; -- for bypassing co_validate_warrant chec

Line 1199: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

1195:
1196: ELSE
1197: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,'Calling do Reserve with doctype: '||p_doc_type||' - sub: '||p_doc_subtype||'- document id: '||p_document_id||' - Ovrride: '||p_override_funds||'- Emp: '||p_employee_id||'.');
1198: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : po_document_funds_pvt.Do_reserve';
1199: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);
1200:
1201: G_RESERVE_FROM_MOD_MERGE := 'Y'; -- for bypassing co_validate_warrant chec
1202: po_document_funds_pvt.Do_reserve(x_return_status => x_return_status,p_doc_type => p_doc_type,
1203: p_doc_subtype => p_doc_subtype,p_doc_level => po_document_funds_pvt.g_doc_level_header,

Line 1213: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,x_progress);

1209: x_po_return_code => x_po_return_code,x_online_report_id => x_online_report_id);
1210: G_RESERVE_FROM_MOD_MERGE := 'N';
1211:
1212: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Do Reserve Return Status: '||x_return_status;
1213: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,x_progress);
1214: -- bug 13709183 Autonomous transaction must rollback in case of any error (expected, unexpected)
1215: -- IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1216: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1217: -- fetch error message

Line 1227: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

1223: END IF;-- PA Check
1224: END IF; --Enc On Check
1225:
1226: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_DOCUMENT_ACTION_PVT.do_approve for base doc';
1227: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);
1228: PO_DOCUMENT_ACTION_PVT.do_approve(
1229: p_document_id => P_Document_Id
1230: , p_document_type => p_doc_type
1231: , p_document_subtype => p_doc_subtype

Line 1242: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_error_message);

1238: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1239: -- fetch error message
1240: g_result := x_return_status;
1241: g_error_message := x_exception_msg || 'Exception while call for base doc PO_DOCUMENT_ACTION_PVT.do_approve failed';
1242: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_error_message);
1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1244:
1245: END IF;
1246:

Line 1277: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

1273: END IF;
1274: END IF;
1275:
1276: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Approve Action Successful.';
1277: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1278: x_return_status := FND_API.G_RET_STS_SUCCESS;
1279: COMMIT;
1280: EXCEPTION
1281:

Line 1285: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

1281:
1282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1283: g_error_message := g_error_message || ' erorr encountered is ' ||SQLCODE||' -ERROR- '||SQLERRM ;
1284: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: in exception block with error ' || g_error_message;
1285: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1286: ROLLBACK TO MergeReserve_Autonomous_SP;
1287: wf_core.context('PO_REQAPPROVAL_ACTION','MergeReserve_Autonomous', x_progress);
1288: RAISE;
1289: WHEN OTHERS THEN

Line 1293: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

1289: WHEN OTHERS THEN
1290: wf_core.Context('PO_DRAFT_MERGE_PKG','MergeReserve_Autonomous', x_progress);
1291: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: in exception block (when others) with error ' || g_error_message;
1292: g_error_message := g_error_message || ' erorr encountered is ' ||SQLCODE||' -ERROR- '||SQLERRM ;
1293: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1294: ROLLBACK TO MergeReserve_Autonomous_SP;
1295: RAISE;
1296: END MergeReserve_Autonomous;
1297: --

Line 1314: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

1310: l_uda_template_id NUMBER;
1311: Begin
1312:
1313: x_progress := 'PO_DRAFT_MERGE_PKG.call_docnum_post_approval: Start: 01';
1314: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1315:
1316: l_draft_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
1317: itemkey => itemkey,
1318: aname => 'DRAFT_ID');

Line 1349: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

1345:
1346: Exception
1347: When Others Then
1348: x_progress := 'PO_DRAFT_MERGE_PKG.call_docnum_post_approval: Exception ' || SQLERRM;
1349: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1350: wf_core.context('PO_DRAFT_MERGE_PKG','call_docnum_post_approval', x_progress);
1351: raise;
1352: END call_docnum_post_approval;
1353:

Line 1403: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);

1399: aname => 'DRAFT_ID');
1400:
1401: x_progress := 'PO_DRAFT_MERGE_PKG.IS_MOD_DOCUMENT: Draft_id: '
1402: || l_draft_id;
1403: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
1404:
1405: BEGIN
1406: SELECT 'Y'
1407: INTO l_is_mod_document

Line 1414: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

1410: AND draft_type = 'MOD';
1411: EXCEPTION
1412: WHEN No_Data_Found THEN
1413: x_progress := 'PO_DRAFT_MERGE_PKG.IS_MOD_DOCUMENT: in no data found exception';
1414: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
1415: END;
1416:
1417: resultout := wf_engine.eng_completed || ':' || l_is_mod_document;
1418:

Line 1422: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);

1418:
1419: EXCEPTION
1420: WHEN OTHERS THEN
1421: x_progress := 'PO_DRAFT_MERGE_PKG.IS_MOD_DOCUMENT: Exception';
1422: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
1423: RAISE;
1424: END;
1425:
1426:

Line 1924: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,l_progress);

1920: l_document_subtype := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_SUBTYPE');
1921: l_employee_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'APPROVER_EMPID');
1922:
1923: IF (g_po_wf_debug = 'Y') THEN
1924: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,l_progress);
1925: END IF;
1926:
1927: PAR_APPROVE_AUTONOMOUS (po_po_header_id => l_document_id,
1928: p_draft_id => l_draft_id,

Line 1935: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,l_progress);

1931:
1932: l_progress := 'PO_DRAFT_MERGE_PKG.PAR_DOC_APPROVE: End: 02';
1933:
1934: IF (g_po_wf_debug = 'Y') THEN
1935: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,l_progress);
1936: END IF;
1937:
1938: END PAR_DOC_APPROVE;
1939:

Line 1959: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'update_par_line_status start');

1955: IS
1956: l_is_par_enabled VARCHAR2(1) := 'N';
1957: BEGIN
1958:
1959: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'update_par_line_status start');
1960:
1961: BEGIN
1962: SELECT par_enabled_flag
1963: INTO l_is_par_enabled

Line 1972: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'Exception in update_par_line_status - ' || sqlerrm);

1968: AND pha.draft_id = p_draft_id;
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: l_is_par_enabled := 'N';
1972: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'Exception in update_par_line_status - ' || sqlerrm);
1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1974: END;
1975:
1976: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'Is PAR Enabled : ' || l_is_par_enabled );

Line 1976: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'Is PAR Enabled : ' || l_is_par_enabled );

1972: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'Exception in update_par_line_status - ' || sqlerrm);
1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1974: END;
1975:
1976: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'Is PAR Enabled : ' || l_is_par_enabled );
1977:
1978: IF l_is_par_enabled = 'Y' THEN
1979:
1980: UPDATE po_lines_draft_all

Line 1985: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'No of PAR Lines updated : ' || SQL%ROWCOUNT);

1981: SET draft_line_status = 'PO_CREATED'
1982: WHERE po_header_id = p_document_id
1983: AND mod_draft_id = p_draft_id;
1984:
1985: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'No of PAR Lines updated : ' || SQL%ROWCOUNT);
1986:
1987: END IF;
1988:
1989: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'update_par_line_status successful');

Line 1989: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'update_par_line_status successful');

1985: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'No of PAR Lines updated : ' || SQL%ROWCOUNT);
1986:
1987: END IF;
1988:
1989: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'update_par_line_status successful');
1990:
1991: EXCEPTION
1992: WHEN OTHERS THEN
1993: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'Exception in update_par_line_status - ' || sqlerrm);

Line 1993: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'Exception in update_par_line_status - ' || sqlerrm);

1989: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'update_par_line_status successful');
1990:
1991: EXCEPTION
1992: WHEN OTHERS THEN
1993: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'Exception in update_par_line_status - ' || sqlerrm);
1994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1995: END update_par_line_status;
1996:
1997: /**

Line 2402: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

2398:
2399: SAVEPOINT docnum_post_apprvl_auto_SP;
2400:
2401: x_progress := 'PO_DRAFT_MERGE_PKG.docnum_post_apprvl_autonomous: Savepoint docnum_post_apprvl_autonomous_SP';
2402: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
2403:
2404: po_doc_numbering_pkg.process_dod_awd_mod_doc_num
2405: (
2406: p_po_header_id => p_document_id,

Line 2413: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

2409: p_ag_type => 'PO_HEADER_EXT_ATTRS'
2410: );
2411:
2412: x_progress := 'PO_DRAFT_MERGE_PKG.docnum_post_apprvl_autonomous: Completed process_dod_awd_mod_doc_num';
2413: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
2414:
2415: COMMIT;
2416:
2417: EXCEPTION

Line 2422: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

2418:
2419: When Others Then
2420:
2421: x_progress := 'PO_DRAFT_MERGE_PKG.docnum_post_apprvl_autonomous: Exception ' || SQLERRM;
2422: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
2423:
2424: ROLLBACK TO docnum_post_apprvl_auto_SP;
2425:
2426: wf_core.context('PO_DRAFT_MERGE_PKG','docnum_post_apprvl_autonomous', x_progress);