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.POS_WC_VIEW_CANCEL_PVT dependencies on FND_LOG

Line 75: /* Taken from Package FND_LOG

71: )
72: IS
73: l_module varchar2(2000);
74: BEGIN
75: /* Taken from Package FND_LOG
76: LEVEL_UNEXPECTED CONSTANT NUMBER := 6;
77: LEVEL_ERROR CONSTANT NUMBER := 5;
78: LEVEL_EXCEPTION CONSTANT NUMBER := 4;
79: LEVEL_EVENT CONSTANT NUMBER := 3;

Line 83: IF( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

79: LEVEL_EVENT CONSTANT NUMBER := 3;
80: LEVEL_PROCEDURE CONSTANT NUMBER := 2;
81: LEVEL_STATEMENT CONSTANT NUMBER := 1;
82: */
83: IF( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
84: IF(l_fnd_debug = 'Y')THEN
85: l_module := 'pos.plsql.pos_wc_view_cancel_pvt.'||p_api_name;
86: FND_LOG.string( LOG_LEVEL => p_level,
87: MODULE => l_module,

Line 86: FND_LOG.string( LOG_LEVEL => p_level,

82: */
83: IF( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
84: IF(l_fnd_debug = 'Y')THEN
85: l_module := 'pos.plsql.pos_wc_view_cancel_pvt.'||p_api_name;
86: FND_LOG.string( LOG_LEVEL => p_level,
87: MODULE => l_module,
88: MESSAGE => p_msg);
89: END IF;
90: END IF;

Line 149: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_po_header_info',

145: EXCEPTION
146:
147: WHEN OTHERS THEN
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_po_header_info',
150: 'Unexpected error when calling PO API');
151:
152:
153: END GET_PO_HEADER_INFO;

Line 322: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',

318:
319: WHEN FND_API.G_EXC_ERROR THEN
320: x_return_status := FND_API.G_RET_STS_ERROR;
321: x_return_msg := l_api_return_msg;
322: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',
323: 'Expected error at stage: '|| l_progress);
324: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',
325: 'Error: '|| l_api_return_msg);
326:

Line 324: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',

320: x_return_status := FND_API.G_RET_STS_ERROR;
321: x_return_msg := l_api_return_msg;
322: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',
323: 'Expected error at stage: '|| l_progress);
324: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',
325: 'Error: '|| l_api_return_msg);
326:
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 331: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',

327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: x_return_msg := 'Unexpected error at stage: '||l_progress||
330: ' '||l_api_return_msg;
331: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',
332: 'Unexpected error at stage: '|| l_progress);
333:
334: WHEN OTHERS THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 337: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',

333:
334: WHEN OTHERS THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: x_return_msg := 'Unexpected error in get_wc_info at stage: '|| l_progress;
337: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',
338: 'Unexpected error at stage: '|| l_progress);
339:
340: END GET_WC_INFO;
341:

Line 458: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_summary_info',

454:
455: IF (x_po_ordered is null) THEN x_po_ordered := 0; END IF;
456: IF (x_po_lines_ordered is null) THEN x_po_lines_ordered := 0; END IF;
457:
458: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_summary_info',
459: 'x_po_ordered: '|| x_po_ordered);
460: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_summary_info',
461: 'x_po_lines_ordered: '|| x_po_lines_ordered);
462:

Line 460: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_summary_info',

456: IF (x_po_lines_ordered is null) THEN x_po_lines_ordered := 0; END IF;
457:
458: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_summary_info',
459: 'x_po_ordered: '|| x_po_ordered);
460: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_summary_info',
461: 'x_po_lines_ordered: '|| x_po_lines_ordered);
462:
463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464:

Line 474: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_prev_submitted',

470: x_return_msg := 'Error in get_po_summary_info: No po_header_id';
471:
472: WHEN OTHERS THEN
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_prev_submitted',
475: 'Unexpected error occurred');
476:
477: END GET_PO_SUMMARY_INFO;
478:

Line 577: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_info',

573: CLOSE l_amt_approved_csr;
574:
575: x_po_approved := NVL(l_amt_approved, 0);
576:
577: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_info',
578: 'x_po_ordered: '|| l_amount_total);
579: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_info',
580: 'x_po_approved: '|| l_amount_received);
581:

Line 579: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_info',

575: x_po_approved := NVL(l_amt_approved, 0);
576:
577: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_info',
578: 'x_po_ordered: '|| l_amount_total);
579: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_info',
580: 'x_po_approved: '|| l_amount_received);
581:
582:
583: EXCEPTION

Line 586: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_summary_info',

582:
583: EXCEPTION
584:
585: WHEN OTHERS THEN NULL;
586: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_summary_info',
587: 'Call to PO_DOCUMENT_TOTALS_PVT.get_order_totals not successful');
588: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589:
590: END GET_PO_INFO;

Line 672: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_prev_submitted',

668: IF(l_wc_intf_prev_submitted is NULL) THEN
669: l_wc_intf_prev_submitted := 0;
670: END IF;
671:
672: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_prev_submitted',
673: 'l_wc_intf_prev_submitted: '|| l_wc_intf_prev_submitted);
674:
675: /*
676: Rolls up all previously submitted delivery pay items

Line 698: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_prev_submitted',

694: IF(l_wc_intf_prev_delivered is NULL) THEN
695: l_wc_intf_prev_delivered := 0;
696: END IF;
697:
698: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_prev_submitted',
699: 'l_wc_intf_prev_delivered: '|| l_wc_intf_prev_delivered);
700:
701: -------------
702: --Shipment

Line 729: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_prev_submitted',

725: IF(l_wc_ship_prev_submitted is NULL) THEN
726: l_wc_ship_prev_submitted := 0;
727: END IF;
728:
729: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_prev_submitted',
730: 'l_wc_ship_prev_submitted: '|| l_wc_ship_prev_submitted);
731:
732: /*Rolls up all previously submitted delivery pay items
733: that are in SHIPMENT tables

Line 758: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_prev_submitted',

754:
755: x_wc_prev_submitted := l_wc_intf_prev_submitted + l_wc_ship_prev_submitted;
756: x_wc_prev_delivered := l_wc_intf_prev_delivered + l_wc_ship_prev_delivered;
757:
758: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_prev_submitted',
759: 'x_wc_prev_submitted: '|| x_wc_prev_submitted);
760: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_prev_submitted',
761: 'x_wc_prev_delivered: '|| x_wc_prev_delivered);
762:

Line 760: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_prev_submitted',

756: x_wc_prev_delivered := l_wc_intf_prev_delivered + l_wc_ship_prev_delivered;
757:
758: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_prev_submitted',
759: 'x_wc_prev_submitted: '|| x_wc_prev_submitted);
760: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_prev_submitted',
761: 'x_wc_prev_delivered: '|| x_wc_prev_delivered);
762:
763: x_return_status := FND_API.G_RET_STS_SUCCESS;
764:

Line 769: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_prev_submitted',

765: EXCEPTION
766:
767: WHEN OTHERS THEN
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_prev_submitted',
770: 'Unexpected error occurred');
771:
772: END GET_WC_PREV_SUBMITTED;
773:

Line 880: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_requested_and_material',

876: EXCEPTION
877:
878: WHEN OTHERS THEN
879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
880: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_requested_and_material',
881: 'Unexpected error occurred');
882:
883: END GET_WC_REQUESTED_AND_MATERIAL;
884:

Line 1038: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',

1034: WHERE transaction_type = 'CORRECT' AND
1035: shipment_header_id = p_wc_id;
1036:
1037:
1038: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',
1039: 'Number of correction transactions: '||l_wc_lines_corrected);
1040:
1041: -- end of coded added for wc correction ER
1042: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',

Line 1042: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',

1038: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',
1039: 'Number of correction transactions: '||l_wc_lines_corrected);
1040:
1041: -- end of coded added for wc correction ER
1042: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',
1043: 'Number of Shipment lines: '||l_wc_total_lines);
1044: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',
1045: 'Number of processed Shipment Lines: '||l_wc_lines_processed);
1046: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',

Line 1044: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',

1040:
1041: -- end of coded added for wc correction ER
1042: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',
1043: 'Number of Shipment lines: '||l_wc_total_lines);
1044: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',
1045: 'Number of processed Shipment Lines: '||l_wc_lines_processed);
1046: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',
1047: 'Number of errored Shipment Lines: '||l_wc_lines_errored);
1048:

Line 1046: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',

1042: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',
1043: 'Number of Shipment lines: '||l_wc_total_lines);
1044: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',
1045: 'Number of processed Shipment Lines: '||l_wc_lines_processed);
1046: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_status',
1047: 'Number of errored Shipment Lines: '||l_wc_lines_errored);
1048:
1049: IF(l_wc_lines_processed = 0 and l_wc_lines_errored = 0) THEN
1050:

Line 1127: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_status',

1123: EXCEPTION
1124:
1125: WHEN OTHERS THEN
1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1127: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_status',
1128: 'Unexpected error occurred');
1129:
1130: END GET_WC_STATUS;
1131:

Line 1184: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_cancellation_status',

1180: where rti.transaction_type = 'CANCEL'
1181: and rti.shipment_header_id = rsh.shipment_header_id
1182: and rsh.shipment_header_id = p_wc_id;
1183:
1184: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_cancellation_status',
1185: 'Total Number of lines: '||x_total_lines);
1186: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_cancellation_status',
1187: 'Total Number of canceled lines: '||x_cancelled_lines);
1188: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_cancellation_status',

Line 1186: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_cancellation_status',

1182: and rsh.shipment_header_id = p_wc_id;
1183:
1184: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_cancellation_status',
1185: 'Total Number of lines: '||x_total_lines);
1186: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_cancellation_status',
1187: 'Total Number of canceled lines: '||x_cancelled_lines);
1188: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_cancellation_status',
1189: 'Total Number of lines pending cancelation: '||x_pending_cancel);
1190:

Line 1188: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_cancellation_status',

1184: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_cancellation_status',
1185: 'Total Number of lines: '||x_total_lines);
1186: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_cancellation_status',
1187: 'Total Number of canceled lines: '||x_cancelled_lines);
1188: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_cancellation_status',
1189: 'Total Number of lines pending cancelation: '||x_pending_cancel);
1190:
1191: if (x_total_lines = x_cancelled_lines) then
1192: return 'CANCELED';

Line 1204: LOG(FND_LOG.LEVEL_UNEXPECTED,'GET_WC_CANCELLATION_STATUS',

1200: end if;
1201:
1202: EXCEPTION
1203: WHEN OTHERS THEN
1204: LOG(FND_LOG.LEVEL_UNEXPECTED,'GET_WC_CANCELLATION_STATUS',
1205: 'Unexpected error occurred');
1206:
1207: END GET_WC_CANCELLATION_STATUS;
1208:

Line 1328: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','Cancellation Notif parameters:');

1324: FROM PO_HEADERS_ALL POH
1325: WHERE POH.PO_HEADER_ID = p_po_header_id;
1326:
1327: --Debug Information
1328: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','Cancellation Notif parameters:');
1329: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC Num:'||p_wc_num);
1330: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC ID:'||p_wc_id);
1331: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC Status:'||p_wc_status);
1332: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','PO Header ID:'||p_po_header_id);

Line 1329: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC Num:'||p_wc_num);

1325: WHERE POH.PO_HEADER_ID = p_po_header_id;
1326:
1327: --Debug Information
1328: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','Cancellation Notif parameters:');
1329: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC Num:'||p_wc_num);
1330: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC ID:'||p_wc_id);
1331: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC Status:'||p_wc_status);
1332: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','PO Header ID:'||p_po_header_id);
1333: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','Buyer ID:'||l_buyer_id);

Line 1330: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC ID:'||p_wc_id);

1326:
1327: --Debug Information
1328: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','Cancellation Notif parameters:');
1329: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC Num:'||p_wc_num);
1330: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC ID:'||p_wc_id);
1331: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC Status:'||p_wc_status);
1332: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','PO Header ID:'||p_po_header_id);
1333: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','Buyer ID:'||l_buyer_id);
1334: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','User ID:'||fnd_global.user_id);

Line 1331: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC Status:'||p_wc_status);

1327: --Debug Information
1328: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','Cancellation Notif parameters:');
1329: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC Num:'||p_wc_num);
1330: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC ID:'||p_wc_id);
1331: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC Status:'||p_wc_status);
1332: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','PO Header ID:'||p_po_header_id);
1333: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','Buyer ID:'||l_buyer_id);
1334: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','User ID:'||fnd_global.user_id);
1335:

Line 1332: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','PO Header ID:'||p_po_header_id);

1328: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','Cancellation Notif parameters:');
1329: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC Num:'||p_wc_num);
1330: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC ID:'||p_wc_id);
1331: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC Status:'||p_wc_status);
1332: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','PO Header ID:'||p_po_header_id);
1333: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','Buyer ID:'||l_buyer_id);
1334: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','User ID:'||fnd_global.user_id);
1335:
1336: --Close previous 'requires approval' notif sent to buyer

Line 1333: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','Buyer ID:'||l_buyer_id);

1329: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC Num:'||p_wc_num);
1330: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC ID:'||p_wc_id);
1331: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC Status:'||p_wc_status);
1332: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','PO Header ID:'||p_po_header_id);
1333: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','Buyer ID:'||l_buyer_id);
1334: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','User ID:'||fnd_global.user_id);
1335:
1336: --Close previous 'requires approval' notif sent to buyer
1337: open ship_header_cursor(p_wc_id);

Line 1334: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','User ID:'||fnd_global.user_id);

1330: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC ID:'||p_wc_id);
1331: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','WC Status:'||p_wc_status);
1332: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','PO Header ID:'||p_po_header_id);
1333: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','Buyer ID:'||l_buyer_id);
1334: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','User ID:'||fnd_global.user_id);
1335:
1336: --Close previous 'requires approval' notif sent to buyer
1337: open ship_header_cursor(p_wc_id);
1338: fetch ship_header_cursor into l_wf_itemtype, l_wf_itemkey;

Line 1345: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','l_wf_itemtype:'||l_wf_itemtype);

1341: /* Bug 7668094 - Start
1342: Complete Activity Throws Exception if the process is not open.
1343: Hence catched the exception to complete the normal flow.
1344: */
1345: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','l_wf_itemtype:'||l_wf_itemtype);
1346: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','l_wf_itemkey:'||l_wf_itemkey);
1347: BEGIN
1348: WF_ENGINE.CompleteActivity(l_wf_itemtype, l_wf_itemkey,'WC_APPROVE', 'Cancel');
1349: EXCEPTION WHEN OTHERS THEN

Line 1346: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','l_wf_itemkey:'||l_wf_itemkey);

1342: Complete Activity Throws Exception if the process is not open.
1343: Hence catched the exception to complete the normal flow.
1344: */
1345: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','l_wf_itemtype:'||l_wf_itemtype);
1346: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','l_wf_itemkey:'||l_wf_itemkey);
1347: BEGIN
1348: WF_ENGINE.CompleteActivity(l_wf_itemtype, l_wf_itemkey,'WC_APPROVE', 'Cancel');
1349: EXCEPTION WHEN OTHERS THEN
1350: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc','Could Not Completing activity');

Line 1350: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc','Could Not Completing activity');

1346: LOG(FND_LOG.LEVEL_PROCEDURE,'cancel_wc','l_wf_itemkey:'||l_wf_itemkey);
1347: BEGIN
1348: WF_ENGINE.CompleteActivity(l_wf_itemtype, l_wf_itemkey,'WC_APPROVE', 'Cancel');
1349: EXCEPTION WHEN OTHERS THEN
1350: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc','Could Not Completing activity');
1351: END;
1352: -- Bug 7668094 - Start
1353:
1354: POS_ASN_NOTIF.GENERATE_WC_NOTIF

Line 1380: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',

1376: EXCEPTION
1377:
1378: WHEN CANCEL_PAY_ITEM_ERROR THEN
1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1380: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1381: 'Unexpected error occurred when cancelling pay item');
1382: WHEN NOTIF_ERROR THEN
1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1384: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',

Line 1384: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',

1380: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1381: 'Unexpected error occurred when cancelling pay item');
1382: WHEN NOTIF_ERROR THEN
1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1384: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1385: 'Unexpected error occurred when sending buyer a cancellation notification');
1386: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1387: 'Error Message: '||l_api_return_msg);
1388:

Line 1386: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',

1382: WHEN NOTIF_ERROR THEN
1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1384: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1385: 'Unexpected error occurred when sending buyer a cancellation notification');
1386: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1387: 'Error Message: '||l_api_return_msg);
1388:
1389: WHEN OTHERS THEN
1390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1391: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',

1387: 'Error Message: '||l_api_return_msg);
1388:
1389: WHEN OTHERS THEN
1390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1391: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1392: 'Unexpected error occurred');
1393:
1394:
1395: END CANCEL_WC;

Line 1886: LOG(FND_LOG.LEVEL_UNEXPECTED,'delete_wc',

1882: EXCEPTION
1883:
1884: WHEN OTHERS THEN
1885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1886: LOG(FND_LOG.LEVEL_UNEXPECTED,'delete_wc',
1887: 'Unexpected error occurred');
1888:
1889: END DELETE_WC;
1890:

Line 1959: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_approvers',

1955:
1956: WHEN OTHERS THEN
1957:
1958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1959: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_approvers',
1960: 'Unexpected error occurred');
1961:
1962: END GET_WC_APPROVERS;
1963: