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

Line 532: PO_WF_DEBUG_PKG.debug_begin(d_module);

528:
529: d_progress := '000';
530:
531: IF (g_po_wf_debug = 'Y') THEN
532: PO_WF_DEBUG_PKG.debug_begin(d_module);
533: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_type', p_doc_type);
534: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
535: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
536: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);

Line 533: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_type', p_doc_type);

529: d_progress := '000';
530:
531: IF (g_po_wf_debug = 'Y') THEN
532: PO_WF_DEBUG_PKG.debug_begin(d_module);
533: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_type', p_doc_type);
534: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
535: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
536: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
537: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_action', p_action);

Line 534: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);

530:
531: IF (g_po_wf_debug = 'Y') THEN
532: PO_WF_DEBUG_PKG.debug_begin(d_module);
533: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_type', p_doc_type);
534: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
535: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
536: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
537: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_action', p_action);
538: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);

Line 535: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);

531: IF (g_po_wf_debug = 'Y') THEN
532: PO_WF_DEBUG_PKG.debug_begin(d_module);
533: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_type', p_doc_type);
534: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
535: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
536: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
537: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_action', p_action);
538: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
539: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);

Line 536: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);

532: PO_WF_DEBUG_PKG.debug_begin(d_module);
533: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_type', p_doc_type);
534: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
535: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
536: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
537: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_action', p_action);
538: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
539: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
540: END IF;

Line 537: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_action', p_action);

533: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_type', p_doc_type);
534: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
535: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
536: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
537: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_action', p_action);
538: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
539: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
540: END IF;
541:

Line 538: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);

534: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
535: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
536: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
537: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_action', p_action);
538: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
539: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
540: END IF;
541:
542: d_progress := '100';

Line 539: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);

535: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
536: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
537: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_action', p_action);
538: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
539: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
540: END IF;
541:
542: d_progress := '100';
543:

Line 658: PO_WF_DEBUG_PKG.debug_end(d_module);

654: RAISE g_OTM_INTEGRATION_EXC;
655: END IF;
656:
657: IF (g_po_wf_debug = 'Y') THEN
658: PO_WF_DEBUG_PKG.debug_end(d_module);
659: END IF;
660:
661: EXCEPTION
662: WHEN OTHERS THEN

Line 664: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, d_log_msg);

660:
661: EXCEPTION
662: WHEN OTHERS THEN
663: IF (g_po_wf_debug = 'Y') THEN
664: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, d_log_msg);
665: END IF;
666:
667: END get_otm_document;
668:

Line 683: PO_WF_DEBUG_PKG.debug_begin(d_module);

679:
680: d_progress := '000';
681:
682: IF (g_po_wf_debug = 'Y') THEN
683: PO_WF_DEBUG_PKG.debug_begin(d_module);
684: END IF;
685:
686: x_otm_doc.otm_domain := FND_PROFILE.value('WSH_OTM_DOMAIN_NAME');
687: x_otm_doc.otm_user := FND_PROFILE.value('WSH_OTM_USER_ID');

Line 701: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.otm_domain', x_otm_doc.otm_domain);

697:
698: d_progress := '100';
699:
700: IF (g_po_wf_debug = 'Y') THEN
701: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.otm_domain', x_otm_doc.otm_domain);
702: PO_WF_DEBUG_PKG.debug_end(d_module);
703: END IF;
704:
705: EXCEPTION

Line 702: PO_WF_DEBUG_PKG.debug_end(d_module);

698: d_progress := '100';
699:
700: IF (g_po_wf_debug = 'Y') THEN
701: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.otm_domain', x_otm_doc.otm_domain);
702: PO_WF_DEBUG_PKG.debug_end(d_module);
703: END IF;
704:
705: EXCEPTION
706: WHEN OTHERS THEN

Line 708: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Unexpected exception');

704:
705: EXCEPTION
706: WHEN OTHERS THEN
707: IF (g_po_wf_debug = 'Y') THEN
708: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Unexpected exception');
709: END IF;
710: RAISE;
711:
712: END populate_otm_info;

Line 812: PO_WF_DEBUG_PKG.debug_begin(d_module);

808:
809: d_progress := '000';
810:
811: IF (g_po_wf_debug = 'Y') THEN
812: PO_WF_DEBUG_PKG.debug_begin(d_module);
813: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
814: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
815: END IF;
816:

Line 813: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);

809: d_progress := '000';
810:
811: IF (g_po_wf_debug = 'Y') THEN
812: PO_WF_DEBUG_PKG.debug_begin(d_module);
813: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
814: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
815: END IF;
816:
817: d_progress := '010';

Line 814: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);

810:
811: IF (g_po_wf_debug = 'Y') THEN
812: PO_WF_DEBUG_PKG.debug_begin(d_module);
813: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
814: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
815: END IF;
816:
817: d_progress := '010';
818:

Line 1064: PO_WF_DEBUG_PKG.debug_stmt(d_module, d_progress, 'Got schedule line. line_location_id=' || TO_CHAR(l_otm_schedule_line.line_location_id));

1060:
1061: d_progress := '120';
1062:
1063: IF (g_po_wf_debug = 'Y') THEN
1064: PO_WF_DEBUG_PKG.debug_stmt(d_module, d_progress, 'Got schedule line. line_location_id=' || TO_CHAR(l_otm_schedule_line.line_location_id));
1065: END IF;
1066:
1067: -- Populate ship-to address info (including drop-ship info)
1068: d_progress := '150';

Line 1091: PO_WF_DEBUG_PKG.debug_end(d_module);

1087:
1088: d_progress := '070';
1089:
1090: IF (g_po_wf_debug = 'Y') THEN
1091: PO_WF_DEBUG_PKG.debug_end(d_module);
1092: END IF;
1093:
1094: EXCEPTION
1095: WHEN NO_DATA_FOUND THEN

Line 1097: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'No document header found. This probably means that archive-on-approval is not set');

1093:
1094: EXCEPTION
1095: WHEN NO_DATA_FOUND THEN
1096: IF (g_po_wf_debug = 'Y') THEN
1097: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'No document header found. This probably means that archive-on-approval is not set');
1098: END IF;
1099: RAISE;
1100: WHEN OTHERS THEN
1101: IF (g_po_wf_debug = 'Y') THEN

Line 1102: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');

1098: END IF;
1099: RAISE;
1100: WHEN OTHERS THEN
1101: IF (g_po_wf_debug = 'Y') THEN
1102: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');
1103: END IF;
1104: RAISE;
1105:
1106: END get_approved_po;

Line 1125: PO_WF_DEBUG_PKG.debug_begin(d_module);

1121:
1122: d_progress := '000';
1123:
1124: IF (g_po_wf_debug = 'Y') THEN
1125: PO_WF_DEBUG_PKG.debug_begin(d_module);
1126: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1127: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1128: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1129: END IF;

Line 1126: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);

1122: d_progress := '000';
1123:
1124: IF (g_po_wf_debug = 'Y') THEN
1125: PO_WF_DEBUG_PKG.debug_begin(d_module);
1126: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1127: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1128: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1129: END IF;
1130:

Line 1127: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);

1123:
1124: IF (g_po_wf_debug = 'Y') THEN
1125: PO_WF_DEBUG_PKG.debug_begin(d_module);
1126: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1127: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1128: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1129: END IF;
1130:
1131: d_progress := '020';

Line 1128: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);

1124: IF (g_po_wf_debug = 'Y') THEN
1125: PO_WF_DEBUG_PKG.debug_begin(d_module);
1126: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1127: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1128: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1129: END IF;
1130:
1131: d_progress := '020';
1132:

Line 1143: PO_WF_DEBUG_PKG.debug_end(d_module);

1139:
1140: d_progress := '030';
1141:
1142: IF (g_po_wf_debug = 'Y') THEN
1143: PO_WF_DEBUG_PKG.debug_end(d_module);
1144: END IF;
1145:
1146: EXCEPTION
1147: WHEN OTHERS THEN

Line 1149: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');

1145:
1146: EXCEPTION
1147: WHEN OTHERS THEN
1148: IF (g_po_wf_debug = 'Y') THEN
1149: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');
1150: END IF;
1151: RAISE;
1152:
1153: END get_canceled_po;

Line 1172: PO_WF_DEBUG_PKG.debug_begin(d_module);

1168:
1169: d_progress := '000';
1170:
1171: IF (g_po_wf_debug = 'Y') THEN
1172: PO_WF_DEBUG_PKG.debug_begin(d_module);
1173: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1174: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1175: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1176: END IF;

Line 1173: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);

1169: d_progress := '000';
1170:
1171: IF (g_po_wf_debug = 'Y') THEN
1172: PO_WF_DEBUG_PKG.debug_begin(d_module);
1173: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1174: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1175: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1176: END IF;
1177:

Line 1174: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);

1170:
1171: IF (g_po_wf_debug = 'Y') THEN
1172: PO_WF_DEBUG_PKG.debug_begin(d_module);
1173: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1174: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1175: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1176: END IF;
1177:
1178: d_progress := '020';

Line 1175: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);

1171: IF (g_po_wf_debug = 'Y') THEN
1172: PO_WF_DEBUG_PKG.debug_begin(d_module);
1173: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1174: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1175: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1176: END IF;
1177:
1178: d_progress := '020';
1179:

Line 1190: PO_WF_DEBUG_PKG.debug_end(d_module);

1186:
1187: d_progress := '030';
1188:
1189: IF (g_po_wf_debug = 'Y') THEN
1190: PO_WF_DEBUG_PKG.debug_end(d_module);
1191: END IF;
1192:
1193: EXCEPTION
1194: WHEN OTHERS THEN

Line 1196: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');

1192:
1193: EXCEPTION
1194: WHEN OTHERS THEN
1195: IF (g_po_wf_debug = 'Y') THEN
1196: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');
1197: END IF;
1198: RAISE;
1199:
1200: END get_closed_po;

Line 1219: PO_WF_DEBUG_PKG.debug_begin(d_module);

1215:
1216: d_progress := '000';
1217:
1218: IF (g_po_wf_debug = 'Y') THEN
1219: PO_WF_DEBUG_PKG.debug_begin(d_module);
1220: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1221: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1222: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1223: END IF;

Line 1220: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);

1216: d_progress := '000';
1217:
1218: IF (g_po_wf_debug = 'Y') THEN
1219: PO_WF_DEBUG_PKG.debug_begin(d_module);
1220: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1221: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1222: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1223: END IF;
1224:

Line 1221: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);

1217:
1218: IF (g_po_wf_debug = 'Y') THEN
1219: PO_WF_DEBUG_PKG.debug_begin(d_module);
1220: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1221: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1222: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1223: END IF;
1224:
1225: d_progress := '020';

Line 1222: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);

1218: IF (g_po_wf_debug = 'Y') THEN
1219: PO_WF_DEBUG_PKG.debug_begin(d_module);
1220: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1221: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1222: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1223: END IF;
1224:
1225: d_progress := '020';
1226:

Line 1237: PO_WF_DEBUG_PKG.debug_end(d_module);

1233:
1234: d_progress := '030';
1235:
1236: IF (g_po_wf_debug = 'Y') THEN
1237: PO_WF_DEBUG_PKG.debug_end(d_module);
1238: END IF;
1239:
1240: EXCEPTION
1241: WHEN OTHERS THEN

Line 1243: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');

1239:
1240: EXCEPTION
1241: WHEN OTHERS THEN
1242: IF (g_po_wf_debug = 'Y') THEN
1243: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');
1244: END IF;
1245: RAISE;
1246:
1247: END get_opened_po;

Line 1309: PO_WF_DEBUG_PKG.debug_begin(d_module);

1305:
1306: d_progress := '000';
1307:
1308: IF (g_po_wf_debug = 'Y') THEN
1309: PO_WF_DEBUG_PKG.debug_begin(d_module);
1310: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1311: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1312: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1313: END IF;

Line 1310: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);

1306: d_progress := '000';
1307:
1308: IF (g_po_wf_debug = 'Y') THEN
1309: PO_WF_DEBUG_PKG.debug_begin(d_module);
1310: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1311: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1312: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1313: END IF;
1314:

Line 1311: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);

1307:
1308: IF (g_po_wf_debug = 'Y') THEN
1309: PO_WF_DEBUG_PKG.debug_begin(d_module);
1310: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1311: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1312: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1313: END IF;
1314:
1315: d_progress := '020';

Line 1312: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);

1308: IF (g_po_wf_debug = 'Y') THEN
1309: PO_WF_DEBUG_PKG.debug_begin(d_module);
1310: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1311: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
1312: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1313: END IF;
1314:
1315: d_progress := '020';
1316:

Line 1372: PO_WF_DEBUG_PKG.debug_stmt(d_module, d_progress, 'Got schedule line. line_location_id=' || TO_CHAR(l_otm_schedule_line.line_location_id));

1368:
1369: d_progress := '120';
1370:
1371: IF (g_po_wf_debug = 'Y') THEN
1372: PO_WF_DEBUG_PKG.debug_stmt(d_module, d_progress, 'Got schedule line. line_location_id=' || TO_CHAR(l_otm_schedule_line.line_location_id));
1373: END IF;
1374:
1375: x_otm_doc.schedule_lines.extend;
1376: x_otm_doc.schedule_lines(l_count) := l_otm_schedule_line;

Line 1391: PO_WF_DEBUG_PKG.debug_end(d_module);

1387:
1388: d_progress := '070';
1389:
1390: IF (g_po_wf_debug = 'Y') THEN
1391: PO_WF_DEBUG_PKG.debug_end(d_module);
1392: END IF;
1393:
1394: EXCEPTION
1395: WHEN OTHERS THEN

Line 1397: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');

1393:
1394: EXCEPTION
1395: WHEN OTHERS THEN
1396: IF (g_po_wf_debug = 'Y') THEN
1397: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');
1398: END IF;
1399: RAISE;
1400:
1401: END get_po_for_status_change;

Line 1421: PO_WF_DEBUG_PKG.debug_begin(d_module);

1417:
1418: d_progress := '000';
1419:
1420: IF (g_po_wf_debug = 'Y') THEN
1421: PO_WF_DEBUG_PKG.debug_begin(d_module);
1422: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1423: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
1424: END IF;
1425:

Line 1422: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);

1418: d_progress := '000';
1419:
1420: IF (g_po_wf_debug = 'Y') THEN
1421: PO_WF_DEBUG_PKG.debug_begin(d_module);
1422: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1423: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
1424: END IF;
1425:
1426: d_progress := '020';

Line 1423: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);

1419:
1420: IF (g_po_wf_debug = 'Y') THEN
1421: PO_WF_DEBUG_PKG.debug_begin(d_module);
1422: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1423: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
1424: END IF;
1425:
1426: d_progress := '020';
1427:

Line 1446: PO_WF_DEBUG_PKG.debug_end(d_module);

1442:
1443: d_progress := '030';
1444:
1445: IF (g_po_wf_debug = 'Y') THEN
1446: PO_WF_DEBUG_PKG.debug_end(d_module);
1447: END IF;
1448:
1449: EXCEPTION
1450: WHEN NO_DATA_FOUND THEN

Line 1452: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'No data found. This probably means that archive-on-approve is off.');

1448:
1449: EXCEPTION
1450: WHEN NO_DATA_FOUND THEN
1451: IF (g_po_wf_debug = 'Y') THEN
1452: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'No data found. This probably means that archive-on-approve is off.');
1453: END IF;
1454: RAISE;
1455:
1456: WHEN OTHERS THEN

Line 1458: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');

1454: RAISE;
1455:
1456: WHEN OTHERS THEN
1457: IF (g_po_wf_debug = 'Y') THEN
1458: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');
1459: END IF;
1460: RAISE;
1461:
1462: END get_held_po;

Line 1569: PO_WF_DEBUG_PKG.debug_begin(d_module);

1565:
1566: d_progress := '000';
1567:
1568: IF (g_po_wf_debug = 'Y') THEN
1569: PO_WF_DEBUG_PKG.debug_begin(d_module);
1570: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1571: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
1572: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1573: END IF;

Line 1570: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);

1566: d_progress := '000';
1567:
1568: IF (g_po_wf_debug = 'Y') THEN
1569: PO_WF_DEBUG_PKG.debug_begin(d_module);
1570: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1571: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
1572: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1573: END IF;
1574:

Line 1571: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);

1567:
1568: IF (g_po_wf_debug = 'Y') THEN
1569: PO_WF_DEBUG_PKG.debug_begin(d_module);
1570: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1571: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
1572: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1573: END IF;
1574:
1575: d_progress := '010';

Line 1572: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);

1568: IF (g_po_wf_debug = 'Y') THEN
1569: PO_WF_DEBUG_PKG.debug_begin(d_module);
1570: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1571: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
1572: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1573: END IF;
1574:
1575: d_progress := '010';
1576:

Line 1830: PO_WF_DEBUG_PKG.debug_stmt(d_module, d_progress, 'Got schedule line. line_location_id=' || TO_CHAR(l_otm_schedule_line.line_location_id));

1826:
1827: d_progress := '120';
1828:
1829: IF (g_po_wf_debug = 'Y') THEN
1830: PO_WF_DEBUG_PKG.debug_stmt(d_module, d_progress, 'Got schedule line. line_location_id=' || TO_CHAR(l_otm_schedule_line.line_location_id));
1831: END IF;
1832:
1833: -- populate shipment address info
1834: d_progress := '150';

Line 1857: PO_WF_DEBUG_PKG.debug_end(d_module);

1853:
1854: d_progress := '070';
1855:
1856: IF (g_po_wf_debug = 'Y') THEN
1857: PO_WF_DEBUG_PKG.debug_end(d_module);
1858: END IF;
1859:
1860: EXCEPTION
1861: WHEN NO_DATA_FOUND THEN

Line 1863: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'No document header found. This probably means that archive-on-approval is not set');

1859:
1860: EXCEPTION
1861: WHEN NO_DATA_FOUND THEN
1862: IF (g_po_wf_debug = 'Y') THEN
1863: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'No document header found. This probably means that archive-on-approval is not set');
1864: END IF;
1865: RAISE;
1866: WHEN OTHERS THEN
1867: IF (g_po_wf_debug = 'Y') THEN

Line 1868: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');

1864: END IF;
1865: RAISE;
1866: WHEN OTHERS THEN
1867: IF (g_po_wf_debug = 'Y') THEN
1868: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');
1869: END IF;
1870: RAISE;
1871:
1872: END get_approved_release;

Line 1891: PO_WF_DEBUG_PKG.debug_begin(d_module);

1887:
1888: d_progress := '000';
1889:
1890: IF (g_po_wf_debug = 'Y') THEN
1891: PO_WF_DEBUG_PKG.debug_begin(d_module);
1892: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1893: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1894: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1895: END IF;

Line 1892: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);

1888: d_progress := '000';
1889:
1890: IF (g_po_wf_debug = 'Y') THEN
1891: PO_WF_DEBUG_PKG.debug_begin(d_module);
1892: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1893: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1894: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1895: END IF;
1896:

Line 1893: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);

1889:
1890: IF (g_po_wf_debug = 'Y') THEN
1891: PO_WF_DEBUG_PKG.debug_begin(d_module);
1892: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1893: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1894: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1895: END IF;
1896:
1897: d_progress := '020';

Line 1894: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);

1890: IF (g_po_wf_debug = 'Y') THEN
1891: PO_WF_DEBUG_PKG.debug_begin(d_module);
1892: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1893: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1894: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1895: END IF;
1896:
1897: d_progress := '020';
1898:

Line 1909: PO_WF_DEBUG_PKG.debug_end(d_module);

1905:
1906: d_progress := '030';
1907:
1908: IF (g_po_wf_debug = 'Y') THEN
1909: PO_WF_DEBUG_PKG.debug_end(d_module);
1910: END IF;
1911:
1912: EXCEPTION
1913: WHEN OTHERS THEN

Line 1915: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');

1911:
1912: EXCEPTION
1913: WHEN OTHERS THEN
1914: IF (g_po_wf_debug = 'Y') THEN
1915: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');
1916: END IF;
1917: RAISE;
1918:
1919: END get_canceled_release;

Line 1938: PO_WF_DEBUG_PKG.debug_begin(d_module);

1934:
1935: d_progress := '000';
1936:
1937: IF (g_po_wf_debug = 'Y') THEN
1938: PO_WF_DEBUG_PKG.debug_begin(d_module);
1939: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1940: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1941: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1942: END IF;

Line 1939: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);

1935: d_progress := '000';
1936:
1937: IF (g_po_wf_debug = 'Y') THEN
1938: PO_WF_DEBUG_PKG.debug_begin(d_module);
1939: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1940: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1941: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1942: END IF;
1943:

Line 1940: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);

1936:
1937: IF (g_po_wf_debug = 'Y') THEN
1938: PO_WF_DEBUG_PKG.debug_begin(d_module);
1939: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1940: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1941: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1942: END IF;
1943:
1944: d_progress := '020';

Line 1941: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);

1937: IF (g_po_wf_debug = 'Y') THEN
1938: PO_WF_DEBUG_PKG.debug_begin(d_module);
1939: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1940: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1941: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1942: END IF;
1943:
1944: d_progress := '020';
1945:

Line 1956: PO_WF_DEBUG_PKG.debug_end(d_module);

1952:
1953: d_progress := '030';
1954:
1955: IF (g_po_wf_debug = 'Y') THEN
1956: PO_WF_DEBUG_PKG.debug_end(d_module);
1957: END IF;
1958:
1959: EXCEPTION
1960: WHEN OTHERS THEN

Line 1962: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');

1958:
1959: EXCEPTION
1960: WHEN OTHERS THEN
1961: IF (g_po_wf_debug = 'Y') THEN
1962: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');
1963: END IF;
1964: RAISE;
1965:
1966: END get_closed_release;

Line 1985: PO_WF_DEBUG_PKG.debug_begin(d_module);

1981:
1982: d_progress := '000';
1983:
1984: IF (g_po_wf_debug = 'Y') THEN
1985: PO_WF_DEBUG_PKG.debug_begin(d_module);
1986: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1987: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1988: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1989: END IF;

Line 1986: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);

1982: d_progress := '000';
1983:
1984: IF (g_po_wf_debug = 'Y') THEN
1985: PO_WF_DEBUG_PKG.debug_begin(d_module);
1986: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1987: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1988: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1989: END IF;
1990:

Line 1987: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);

1983:
1984: IF (g_po_wf_debug = 'Y') THEN
1985: PO_WF_DEBUG_PKG.debug_begin(d_module);
1986: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1987: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1988: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1989: END IF;
1990:
1991: d_progress := '020';

Line 1988: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);

1984: IF (g_po_wf_debug = 'Y') THEN
1985: PO_WF_DEBUG_PKG.debug_begin(d_module);
1986: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
1987: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
1988: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
1989: END IF;
1990:
1991: d_progress := '020';
1992:

Line 2003: PO_WF_DEBUG_PKG.debug_end(d_module);

1999:
2000: d_progress := '030';
2001:
2002: IF (g_po_wf_debug = 'Y') THEN
2003: PO_WF_DEBUG_PKG.debug_end(d_module);
2004: END IF;
2005:
2006: EXCEPTION
2007: WHEN OTHERS THEN

Line 2009: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');

2005:
2006: EXCEPTION
2007: WHEN OTHERS THEN
2008: IF (g_po_wf_debug = 'Y') THEN
2009: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');
2010: END IF;
2011: RAISE;
2012:
2013: END get_opened_release;

Line 2080: PO_WF_DEBUG_PKG.debug_begin(d_module);

2076:
2077: d_progress := '000';
2078:
2079: IF (g_po_wf_debug = 'Y') THEN
2080: PO_WF_DEBUG_PKG.debug_begin(d_module);
2081: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
2082: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
2083: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
2084: END IF;

Line 2081: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);

2077: d_progress := '000';
2078:
2079: IF (g_po_wf_debug = 'Y') THEN
2080: PO_WF_DEBUG_PKG.debug_begin(d_module);
2081: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
2082: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
2083: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
2084: END IF;
2085:

Line 2082: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);

2078:
2079: IF (g_po_wf_debug = 'Y') THEN
2080: PO_WF_DEBUG_PKG.debug_begin(d_module);
2081: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
2082: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
2083: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
2084: END IF;
2085:
2086: d_progress := '020';

Line 2083: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);

2079: IF (g_po_wf_debug = 'Y') THEN
2080: PO_WF_DEBUG_PKG.debug_begin(d_module);
2081: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
2082: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
2083: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
2084: END IF;
2085:
2086: d_progress := '020';
2087:

Line 2147: PO_WF_DEBUG_PKG.debug_stmt(d_module, d_progress, 'Got schedule line. line_location_id=' || TO_CHAR(l_otm_schedule_line.line_location_id));

2143:
2144: d_progress := '120';
2145:
2146: IF (g_po_wf_debug = 'Y') THEN
2147: PO_WF_DEBUG_PKG.debug_stmt(d_module, d_progress, 'Got schedule line. line_location_id=' || TO_CHAR(l_otm_schedule_line.line_location_id));
2148: END IF;
2149:
2150: x_otm_doc.schedule_lines.extend;
2151: x_otm_doc.schedule_lines(l_count) := l_otm_schedule_line;

Line 2167: PO_WF_DEBUG_PKG.debug_end(d_module);

2163:
2164: d_progress := '070';
2165:
2166: IF (g_po_wf_debug = 'Y') THEN
2167: PO_WF_DEBUG_PKG.debug_end(d_module);
2168: END IF;
2169:
2170: EXCEPTION
2171: WHEN OTHERS THEN

Line 2173: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');

2169:
2170: EXCEPTION
2171: WHEN OTHERS THEN
2172: IF (g_po_wf_debug = 'Y') THEN
2173: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');
2174: END IF;
2175: RAISE;
2176:
2177: END get_release_for_status_change;

Line 2196: PO_WF_DEBUG_PKG.debug_begin(d_module);

2192:
2193: d_progress := '000';
2194:
2195: IF (g_po_wf_debug = 'Y') THEN
2196: PO_WF_DEBUG_PKG.debug_begin(d_module);
2197: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
2198: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
2199: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
2200: END IF;

Line 2197: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);

2193: d_progress := '000';
2194:
2195: IF (g_po_wf_debug = 'Y') THEN
2196: PO_WF_DEBUG_PKG.debug_begin(d_module);
2197: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
2198: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
2199: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
2200: END IF;
2201:

Line 2198: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);

2194:
2195: IF (g_po_wf_debug = 'Y') THEN
2196: PO_WF_DEBUG_PKG.debug_begin(d_module);
2197: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
2198: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
2199: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
2200: END IF;
2201:
2202: d_progress := '020';

Line 2199: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);

2195: IF (g_po_wf_debug = 'Y') THEN
2196: PO_WF_DEBUG_PKG.debug_begin(d_module);
2197: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
2198: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_doc_revision', p_doc_revision);
2199: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'p_blanket_revision', p_blanket_revision);
2200: END IF;
2201:
2202: d_progress := '020';
2203:

Line 2228: PO_WF_DEBUG_PKG.debug_end(d_module);

2224:
2225: d_progress := '030';
2226:
2227: IF (g_po_wf_debug = 'Y') THEN
2228: PO_WF_DEBUG_PKG.debug_end(d_module);
2229: END IF;
2230:
2231: EXCEPTION
2232: WHEN NO_DATA_FOUND THEN

Line 2234: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'No data found. This probably means that archive-on-approve is off.');

2230:
2231: EXCEPTION
2232: WHEN NO_DATA_FOUND THEN
2233: IF (g_po_wf_debug = 'Y') THEN
2234: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'No data found. This probably means that archive-on-approve is off.');
2235: END IF;
2236: RAISE;
2237:
2238: WHEN OTHERS THEN

Line 2240: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');

2236: RAISE;
2237:
2238: WHEN OTHERS THEN
2239: IF (g_po_wf_debug = 'Y') THEN
2240: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Exception retrieving document');
2241: END IF;
2242: RAISE;
2243:
2244: END get_held_release;

Line 2261: PO_WF_DEBUG_PKG.debug_begin(d_module);

2257:
2258: d_progress := '000';
2259:
2260: IF (g_po_wf_debug = 'Y') THEN
2261: PO_WF_DEBUG_PKG.debug_begin(d_module);
2262: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.po_header_id', x_otm_doc.po_header_id);
2263: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.org_location_id', x_otm_doc.org_location_id);
2264: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.bill_to_location_id', x_otm_doc.bill_to_location_id);
2265: END IF;

Line 2262: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.po_header_id', x_otm_doc.po_header_id);

2258: d_progress := '000';
2259:
2260: IF (g_po_wf_debug = 'Y') THEN
2261: PO_WF_DEBUG_PKG.debug_begin(d_module);
2262: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.po_header_id', x_otm_doc.po_header_id);
2263: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.org_location_id', x_otm_doc.org_location_id);
2264: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.bill_to_location_id', x_otm_doc.bill_to_location_id);
2265: END IF;
2266:

Line 2263: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.org_location_id', x_otm_doc.org_location_id);

2259:
2260: IF (g_po_wf_debug = 'Y') THEN
2261: PO_WF_DEBUG_PKG.debug_begin(d_module);
2262: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.po_header_id', x_otm_doc.po_header_id);
2263: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.org_location_id', x_otm_doc.org_location_id);
2264: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.bill_to_location_id', x_otm_doc.bill_to_location_id);
2265: END IF;
2266:
2267: d_progress := '100';

Line 2264: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.bill_to_location_id', x_otm_doc.bill_to_location_id);

2260: IF (g_po_wf_debug = 'Y') THEN
2261: PO_WF_DEBUG_PKG.debug_begin(d_module);
2262: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.po_header_id', x_otm_doc.po_header_id);
2263: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.org_location_id', x_otm_doc.org_location_id);
2264: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.bill_to_location_id', x_otm_doc.bill_to_location_id);
2265: END IF;
2266:
2267: d_progress := '100';
2268:

Line 2318: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.org_loc_addr_line_1', x_otm_doc.org_loc_addr_line_1);

2314:
2315: d_progress := '200';
2316:
2317: IF (g_po_wf_debug = 'Y') THEN
2318: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.org_loc_addr_line_1', x_otm_doc.org_loc_addr_line_1);
2319: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.bill_to_addr_line_1', x_otm_doc.bill_to_addr_line_1);
2320: PO_WF_DEBUG_PKG.debug_end(d_module);
2321: END IF;
2322:

Line 2319: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.bill_to_addr_line_1', x_otm_doc.bill_to_addr_line_1);

2315: d_progress := '200';
2316:
2317: IF (g_po_wf_debug = 'Y') THEN
2318: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.org_loc_addr_line_1', x_otm_doc.org_loc_addr_line_1);
2319: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.bill_to_addr_line_1', x_otm_doc.bill_to_addr_line_1);
2320: PO_WF_DEBUG_PKG.debug_end(d_module);
2321: END IF;
2322:
2323: EXCEPTION

Line 2320: PO_WF_DEBUG_PKG.debug_end(d_module);

2316:
2317: IF (g_po_wf_debug = 'Y') THEN
2318: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.org_loc_addr_line_1', x_otm_doc.org_loc_addr_line_1);
2319: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.bill_to_addr_line_1', x_otm_doc.bill_to_addr_line_1);
2320: PO_WF_DEBUG_PKG.debug_end(d_module);
2321: END IF;
2322:
2323: EXCEPTION
2324: WHEN OTHERS THEN

Line 2326: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Unexpected exception');

2322:
2323: EXCEPTION
2324: WHEN OTHERS THEN
2325: IF (g_po_wf_debug = 'Y') THEN
2326: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Unexpected exception');
2327: END IF;
2328:
2329: END populate_address_info;
2330:

Line 2347: PO_WF_DEBUG_PKG.debug_begin(d_module);

2343:
2344: d_progress := '000';
2345:
2346: IF (g_po_wf_debug = 'Y') THEN
2347: PO_WF_DEBUG_PKG.debug_begin(d_module);
2348: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.po_header_id', x_otm_doc.po_header_id);
2349: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.line_location_id', x_otm_sched_line.line_location_id);
2350: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_location_id', x_otm_sched_line.ship_to_location_id);
2351: END IF;

Line 2348: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.po_header_id', x_otm_doc.po_header_id);

2344: d_progress := '000';
2345:
2346: IF (g_po_wf_debug = 'Y') THEN
2347: PO_WF_DEBUG_PKG.debug_begin(d_module);
2348: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.po_header_id', x_otm_doc.po_header_id);
2349: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.line_location_id', x_otm_sched_line.line_location_id);
2350: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_location_id', x_otm_sched_line.ship_to_location_id);
2351: END IF;
2352:

Line 2349: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.line_location_id', x_otm_sched_line.line_location_id);

2345:
2346: IF (g_po_wf_debug = 'Y') THEN
2347: PO_WF_DEBUG_PKG.debug_begin(d_module);
2348: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.po_header_id', x_otm_doc.po_header_id);
2349: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.line_location_id', x_otm_sched_line.line_location_id);
2350: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_location_id', x_otm_sched_line.ship_to_location_id);
2351: END IF;
2352:
2353: d_progress := '100';

Line 2350: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_location_id', x_otm_sched_line.ship_to_location_id);

2346: IF (g_po_wf_debug = 'Y') THEN
2347: PO_WF_DEBUG_PKG.debug_begin(d_module);
2348: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_doc.po_header_id', x_otm_doc.po_header_id);
2349: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.line_location_id', x_otm_sched_line.line_location_id);
2350: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_location_id', x_otm_sched_line.ship_to_location_id);
2351: END IF;
2352:
2353: d_progress := '100';
2354:

Line 2414: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_loc_addr_line_1', x_otm_sched_line.ship_to_loc_addr_line_1);

2410: d_progress := '220';
2411: END IF;
2412:
2413: IF (g_po_wf_debug = 'Y') THEN
2414: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_loc_addr_line_1', x_otm_sched_line.ship_to_loc_addr_line_1);
2415: PO_WF_DEBUG_PKG.debug_end(d_module);
2416: END IF;
2417:
2418: EXCEPTION

Line 2415: PO_WF_DEBUG_PKG.debug_end(d_module);

2411: END IF;
2412:
2413: IF (g_po_wf_debug = 'Y') THEN
2414: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_loc_addr_line_1', x_otm_sched_line.ship_to_loc_addr_line_1);
2415: PO_WF_DEBUG_PKG.debug_end(d_module);
2416: END IF;
2417:
2418: EXCEPTION
2419: WHEN OTHERS THEN

Line 2421: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Unexpected exception');

2417:
2418: EXCEPTION
2419: WHEN OTHERS THEN
2420: IF (g_po_wf_debug = 'Y') THEN
2421: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, 'Unexpected exception');
2422: END IF;
2423:
2424: END populate_address_info;
2425:

Line 2445: PO_WF_DEBUG_PKG.debug_begin(d_module);

2441:
2442: d_progress := '000';
2443:
2444: IF (g_po_wf_debug = 'Y') THEN
2445: PO_WF_DEBUG_PKG.debug_begin(d_module);
2446: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.line_location_id', x_otm_sched_line.line_location_id);
2447: END IF;
2448:
2449: d_progress := '010';

Line 2446: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.line_location_id', x_otm_sched_line.line_location_id);

2442: d_progress := '000';
2443:
2444: IF (g_po_wf_debug = 'Y') THEN
2445: PO_WF_DEBUG_PKG.debug_begin(d_module);
2446: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.line_location_id', x_otm_sched_line.line_location_id);
2447: END IF;
2448:
2449: d_progress := '010';
2450:

Line 2486: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_location_code', x_otm_sched_line.ship_to_location_code);

2482:
2483: d_progress := '130';
2484:
2485: IF (g_po_wf_debug = 'Y') THEN
2486: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_location_code', x_otm_sched_line.ship_to_location_code);
2487: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_name', x_otm_sched_line.ship_to_contact_name);
2488: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_email', x_otm_sched_line.ship_to_contact_email);
2489: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_phone', x_otm_sched_line.ship_to_contact_phone);
2490: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_fax', x_otm_sched_line.ship_to_contact_fax);

Line 2487: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_name', x_otm_sched_line.ship_to_contact_name);

2483: d_progress := '130';
2484:
2485: IF (g_po_wf_debug = 'Y') THEN
2486: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_location_code', x_otm_sched_line.ship_to_location_code);
2487: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_name', x_otm_sched_line.ship_to_contact_name);
2488: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_email', x_otm_sched_line.ship_to_contact_email);
2489: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_phone', x_otm_sched_line.ship_to_contact_phone);
2490: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_fax', x_otm_sched_line.ship_to_contact_fax);
2491: PO_WF_DEBUG_PKG.debug_end(d_module);

Line 2488: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_email', x_otm_sched_line.ship_to_contact_email);

2484:
2485: IF (g_po_wf_debug = 'Y') THEN
2486: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_location_code', x_otm_sched_line.ship_to_location_code);
2487: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_name', x_otm_sched_line.ship_to_contact_name);
2488: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_email', x_otm_sched_line.ship_to_contact_email);
2489: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_phone', x_otm_sched_line.ship_to_contact_phone);
2490: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_fax', x_otm_sched_line.ship_to_contact_fax);
2491: PO_WF_DEBUG_PKG.debug_end(d_module);
2492: END IF;

Line 2489: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_phone', x_otm_sched_line.ship_to_contact_phone);

2485: IF (g_po_wf_debug = 'Y') THEN
2486: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_location_code', x_otm_sched_line.ship_to_location_code);
2487: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_name', x_otm_sched_line.ship_to_contact_name);
2488: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_email', x_otm_sched_line.ship_to_contact_email);
2489: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_phone', x_otm_sched_line.ship_to_contact_phone);
2490: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_fax', x_otm_sched_line.ship_to_contact_fax);
2491: PO_WF_DEBUG_PKG.debug_end(d_module);
2492: END IF;
2493:

Line 2490: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_fax', x_otm_sched_line.ship_to_contact_fax);

2486: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_location_code', x_otm_sched_line.ship_to_location_code);
2487: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_name', x_otm_sched_line.ship_to_contact_name);
2488: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_email', x_otm_sched_line.ship_to_contact_email);
2489: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_phone', x_otm_sched_line.ship_to_contact_phone);
2490: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_fax', x_otm_sched_line.ship_to_contact_fax);
2491: PO_WF_DEBUG_PKG.debug_end(d_module);
2492: END IF;
2493:
2494: d_progress := '140';

Line 2491: PO_WF_DEBUG_PKG.debug_end(d_module);

2487: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_name', x_otm_sched_line.ship_to_contact_name);
2488: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_email', x_otm_sched_line.ship_to_contact_email);
2489: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_phone', x_otm_sched_line.ship_to_contact_phone);
2490: PO_WF_DEBUG_PKG.debug_var(d_module, d_progress, 'x_otm_sched_line.ship_to_contact_fax', x_otm_sched_line.ship_to_contact_fax);
2491: PO_WF_DEBUG_PKG.debug_end(d_module);
2492: END IF;
2493:
2494: d_progress := '140';
2495:

Line 2499: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, d_log_msg);

2495:
2496: EXCEPTION
2497: WHEN OTHERS THEN
2498: IF (g_po_wf_debug = 'Y') THEN
2499: PO_WF_DEBUG_PKG.debug_unexp(d_module, d_progress, d_log_msg);
2500: END IF;
2501: RAISE;
2502:
2503: END populate_drop_ship_info;