[Home] [Help]
272: WHEN OTHERS THEN
273: IF g_debug_unexp THEN
274: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
275: END IF;
276: po_message_s.sql_error('CREATE_SHIPMENTS',l_progress,SQLCODE);
277:
278: --CLM Phase 2 changes : error handling
279: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_LOC_UOM_ERR',
280: x_token1_value => sqlerrm,
527: 'PO',
528: 'N',
529: x_return_code,
530: 'Y') THEN
531: po_message_s.sql_error('CLOSE_PO',l_progress,SQLCODE);
532: END IF;
533: END IF;
534: l_progress := '150';
535: IF g_debug_stmt THEN
546: 'PO',
547: 'N',
548: x_return_code,
549: 'Y') THEN
550: po_message_s.sql_error('CLOSE_PO',l_progress,SQLCODE);
551: END IF;
552: END IF;
553: END IF;
554: END IF;
576: 'N',
577: x_return_code,
578: 'N') THEN
579: l_progress := '170';
580: po_message_s.sql_error('CLOSE_PO',l_progress,SQLCODE);
581: END IF;
582: END IF;
583: l_progress := '180';
584: IF NOT po_actions.close_po(p_lines.po_header_id_tbl(i),
591: 'PO',
592: 'N',
593: x_return_code,
594: 'N') THEN
595: po_message_s.sql_error('CLOSE_PO',l_progress,SQLCODE);
596: END IF;
597: END IF;
598: END IF;
599:
1005: IF g_debug_unexp THEN
1006: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
1007: p_progress => l_progress);
1008: END IF;
1009: po_message_s.sql_error('CREATE_SHIPMENT_DRAFT',l_progress,sqlcode);
1010: PO_AUTOCREATE_PVT.wrapup();
1011: RAISE;
1012: --autocreate grouping end
1013: WHEN OTHERS THEN
1833: IF g_debug_unexp THEN
1834: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1835: END IF;
1836:
1837: po_message_s.sql_error('Exception of create_price_break()', l_progress,SQLCODE);
1838: FND_MSG_PUB.Add;
1839: RAISE unexpected_create_pb_err;
1840: END;
1841:
2180: IF g_debug_unexp THEN
2181: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2182: END IF;
2183:
2184: po_message_s.sql_error('Exception of create_price_break()', l_progress, SQLCODE);
2185: FND_MSG_PUB.Add;
2186: RAISE unexpected_create_pb_err;
2187: END;
2188: END IF; --