DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on PO_AUTOCREATE_PVT

Line 215: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MERGE_TO_DRAFTS_ERR',x_token1_value => sqlerrm);

211: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
212: END IF;
213:
214: --CLM Phase 2 changes : error handling
215: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MERGE_TO_DRAFTS_ERR',x_token1_value => sqlerrm);
216:
217: PO_AUTOCREATE_PVT.wrapup;
218: po_message_s.sql_error('MERGE TO DRAFTS',l_progress,SQLCODE);
219: RAISE;

Line 217: PO_AUTOCREATE_PVT.wrapup;

213:
214: --CLM Phase 2 changes : error handling
215: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MERGE_TO_DRAFTS_ERR',x_token1_value => sqlerrm);
216:
217: PO_AUTOCREATE_PVT.wrapup;
218: po_message_s.sql_error('MERGE TO DRAFTS',l_progress,SQLCODE);
219: RAISE;
220: END merge_to_drafts;
221:

Line 700: PO_AUTOCREATE_PVT.report_error('PO_AUTO_GET_SHIP_NUM_ERR',x_token1_value => sqlerrm);

696: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name, p_progress => l_progress);
697: END IF;
698:
699: --CLM Phase 2 changes : error handling
700: PO_AUTOCREATE_PVT.report_error('PO_AUTO_GET_SHIP_NUM_ERR',x_token1_value => sqlerrm);
701:
702: po_message_s.sql_error('get_shipment_num', l_progress, SQLCODE);
703: RAISE;
704:

Line 892: PO_AUTOCREATE_PVT.report_error('PO_AUTO_UPD_SHIP_NUM_ERR',x_token1_value => sqlerrm);

888: END IF;
889: po_message_s.sql_error ('update_shipment', l_progress, SQLCODE);
890:
891: --CLM Phase 2 changes : error handling
892: PO_AUTOCREATE_PVT.report_error('PO_AUTO_UPD_SHIP_NUM_ERR',x_token1_value => sqlerrm);
893:
894: RAISE;
895: END update_shipment;
896:

Line 954: PO_AUTOCREATE_PVT.calculate_local(PO_AUTOCREATE_PARAMS.g_document_subtype, 'HEADER', x_headers.po_header_id);

950:
951: l_progress := '060';
952:
953: IF (PO_AUTOCREATE_PARAMS.g_document_subtype IN ('STANDARD','PLANNED','BLANKET')) THEN
954: PO_AUTOCREATE_PVT.calculate_local(PO_AUTOCREATE_PARAMS.g_document_subtype, 'HEADER', x_headers.po_header_id);
955: END IF;
956:
957: IF g_debug_stmt THEN
958: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'End of Process');

Line 973: PO_AUTOCREATE_PVT.report_error('PO_AUTO_HEADER_ERR',x_token1_value => sqlerrm);

969: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
970: END IF;
971:
972: --CLM Phase 2 error reporting
973: PO_AUTOCREATE_PVT.report_error('PO_AUTO_HEADER_ERR',x_token1_value => sqlerrm);
974:
975: po_message_s.sql_error('PROCESS_HEADERS',l_progress,SQLCODE);
976: PO_AUTOCREATE_PVT.wrapup();
977: RAISE;

Line 976: PO_AUTOCREATE_PVT.wrapup();

972: --CLM Phase 2 error reporting
973: PO_AUTOCREATE_PVT.report_error('PO_AUTO_HEADER_ERR',x_token1_value => sqlerrm);
974:
975: po_message_s.sql_error('PROCESS_HEADERS',l_progress,SQLCODE);
976: PO_AUTOCREATE_PVT.wrapup();
977: RAISE;
978: END process_headers;
979:
980: /* ============================================================================

Line 1689: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MATCH_LINE_ERR',x_token1_value => sqlerrm);

1685: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress );
1686: END IF;
1687:
1688: --CLM Phase 2 changes : error handling
1689: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MATCH_LINE_ERR',x_token1_value => sqlerrm);
1690:
1691: RAISE;
1692: END;
1693: END IF;

Line 1869: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MATCH_LINE_ERR',x_token1_value => sqlerrm);

1865: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress );
1866: END IF;
1867: --wrapup(x_interface_header_id);
1868: --CLM Phase 2 changes : error handling
1869: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MATCH_LINE_ERR',x_token1_value => sqlerrm);
1870:
1871: RAISE;
1872: END;
1873: END IF; -- PO/PA

Line 1996: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MATCH_LINE_REQ_ERR',x_token1_value => sqlerrm);

1992: IF g_debug_unexp THEN
1993: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress );
1994: END IF;
1995: --CLM Phase 2 changes : error handling
1996: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MATCH_LINE_REQ_ERR',x_token1_value => sqlerrm);
1997: RAISE;
1998: END;
1999: END IF; -- PO/PA
2000: END IF; -- if x_po_line_num = -1 (interface table)

Line 2185: PO_AUTOCREATE_PVT.report_error('PO_AUTO_GRP_RECORDS_ERR',x_token1_value => sqlerrm);

2181: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress || '_main' );
2182: END IF;
2183:
2184: --CLM Phase 2 changes : error handling
2185: PO_AUTOCREATE_PVT.report_error('PO_AUTO_GRP_RECORDS_ERR',x_token1_value => sqlerrm);
2186:
2187: po_message_s.sql_error ('GROUP INTERFACE RECORDS', l_progress, SQLCODE);
2188: PO_AUTOCREATE_PVT.wrapup();
2189: RAISE;

Line 2188: PO_AUTOCREATE_PVT.wrapup();

2184: --CLM Phase 2 changes : error handling
2185: PO_AUTOCREATE_PVT.report_error('PO_AUTO_GRP_RECORDS_ERR',x_token1_value => sqlerrm);
2186:
2187: po_message_s.sql_error ('GROUP INTERFACE RECORDS', l_progress, SQLCODE);
2188: PO_AUTOCREATE_PVT.wrapup();
2189: RAISE;
2190: END group_interface_records;
2191:
2192: /* ============================================================================

Line 2284: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ERR',x_token1_value => sqlerrm);

2280: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2281: END IF;
2282:
2283: --CLM Phase 2 changes : error handling
2284: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ERR',x_token1_value => sqlerrm);
2285:
2286: po_message_s.sql_error('PROCESS_LINES',l_progress,SQLCODE);
2287: PO_AUTOCREATE_PVT.wrapup();
2288: RAISE;

Line 2287: PO_AUTOCREATE_PVT.wrapup();

2283: --CLM Phase 2 changes : error handling
2284: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ERR',x_token1_value => sqlerrm);
2285:
2286: po_message_s.sql_error('PROCESS_LINES',l_progress,SQLCODE);
2287: PO_AUTOCREATE_PVT.wrapup();
2288: RAISE;
2289:
2290: END process_lines;
2291:

Line 2358: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_LOC_ERR',x_token1_value => sqlerrm);

2354: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2355: END IF;
2356:
2357: --CLM Phase 2 changes : error handling
2358: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_LOC_ERR',x_token1_value => sqlerrm);
2359:
2360: po_message_s.sql_error('PROCESS_LINE_LOCATIONS',l_progress,SQLCODE);
2361: PO_AUTOCREATE_PVT.wrapup();
2362: RAISE;

Line 2361: PO_AUTOCREATE_PVT.wrapup();

2357: --CLM Phase 2 changes : error handling
2358: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_LOC_ERR',x_token1_value => sqlerrm);
2359:
2360: po_message_s.sql_error('PROCESS_LINE_LOCATIONS',l_progress,SQLCODE);
2361: PO_AUTOCREATE_PVT.wrapup();
2362: RAISE;
2363: END process_line_locations;
2364:
2365: /* ============================================================================

Line 2427: PO_AUTOCREATE_PVT.report_error('PO_AUTO_DIST_ERR',x_token1_value => sqlerrm);

2423: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2424: END IF;
2425:
2426: --CLM Phase 2 changes : error handling
2427: PO_AUTOCREATE_PVT.report_error('PO_AUTO_DIST_ERR',x_token1_value => sqlerrm);
2428:
2429: po_message_s.sql_error('process_distributions',l_progress,SQLCODE);
2430: PO_AUTOCREATE_PVT.wrapup();
2431: RAISE;

Line 2430: PO_AUTOCREATE_PVT.wrapup();

2426: --CLM Phase 2 changes : error handling
2427: PO_AUTOCREATE_PVT.report_error('PO_AUTO_DIST_ERR',x_token1_value => sqlerrm);
2428:
2429: po_message_s.sql_error('process_distributions',l_progress,SQLCODE);
2430: PO_AUTOCREATE_PVT.wrapup();
2431: RAISE;
2432: END process_distributions;
2433:
2434: /* ----------------------------------------------------

Line 2445: Caller : PO_AUTOCREATE_PVT.create_po

2441: - group_interface_records
2442: - process_lines
2443: - process_line_locations
2444: - process_distributions
2445: Caller : PO_AUTOCREATE_PVT.create_po
2446: ==============================================================================*/
2447: PROCEDURE process
2448: IS
2449:

Line 2485: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MAINPROC_ERR',x_token1_value => sqlerrm);

2481: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2482: END IF;
2483:
2484: -- CLM Phase 2 Changes : Error Handling
2485: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MAINPROC_ERR',x_token1_value => sqlerrm);
2486:
2487: po_message_s.sql_error('PROCESS',l_progress,SQLCODE);
2488: PO_AUTOCREATE_PVT.wrapup();
2489: RAISE;

Line 2488: PO_AUTOCREATE_PVT.wrapup();

2484: -- CLM Phase 2 Changes : Error Handling
2485: PO_AUTOCREATE_PVT.report_error('PO_AUTO_MAINPROC_ERR',x_token1_value => sqlerrm);
2486:
2487: po_message_s.sql_error('PROCESS',l_progress,SQLCODE);
2488: PO_AUTOCREATE_PVT.wrapup();
2489: RAISE;
2490:
2491: END process;
2492:

Line 2649: PO_AUTOCREATE_PVT.report_error('PO_AUTO_SHIP_TO_LOC_ERR',x_token1_value => sqlerrm);

2645: po_log.exc (d_module, d_progress, SQLCODE || SQLERRM);
2646: END IF;
2647:
2648: --CLM Phase 2 changes : error handling
2649: PO_AUTOCREATE_PVT.report_error('PO_AUTO_SHIP_TO_LOC_ERR',x_token1_value => sqlerrm);
2650:
2651: RAISE;
2652:
2653: END get_ship_to_loc;