DBA Data[Home] [Help]

APPS.PO_AUTO_LINE_PROCESS_PVT dependencies on PO_AUTOCREATE_PVT

Line 98: PO_AUTOCREATE_PVT.report_error('PO_AUTO_SHIPTO_ERR',

94: WHEN OTHERS THEN
95: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);
96:
97: --CLM Phase 2 changes : error handling
98: PO_AUTOCREATE_PVT.report_error('PO_AUTO_SHIPTO_ERR',
99: x_token1_value => sqlerrm);
100:
101: RAISE;
102: END get_interface_shipto_info;

Line 1121: PO_AUTOCREATE_PVT.report_error('PO_AUTO_SETUP_INTF_DATA_ERR',x_token1_value => sqlerrm);

1117: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1118: END IF;
1119:
1120: --CLM Phase 2 changes : error handling
1121: PO_AUTOCREATE_PVT.report_error('PO_AUTO_SETUP_INTF_DATA_ERR',x_token1_value => sqlerrm);
1122:
1123: po_message_s.sql_error('SETUP_INTERFACE_DATA',l_progress,SQLCODE);
1124: PO_AUTOCREATE_PVT.wrapup();
1125: RAISE;

Line 1124: PO_AUTOCREATE_PVT.wrapup();

1120: --CLM Phase 2 changes : error handling
1121: PO_AUTOCREATE_PVT.report_error('PO_AUTO_SETUP_INTF_DATA_ERR',x_token1_value => sqlerrm);
1122:
1123: po_message_s.sql_error('SETUP_INTERFACE_DATA',l_progress,SQLCODE);
1124: PO_AUTOCREATE_PVT.wrapup();
1125: RAISE;
1126: END setup_interface_data;
1127:
1128: /* ============================================================================

Line 1607: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_FETCH_ERR',x_token1_value => sqlerrm);

1603: IF g_debug_unexp THEN
1604: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1605: END IF;
1606: --CLM Phase 2 changes : error handling
1607: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_FETCH_ERR',x_token1_value => sqlerrm);
1608:
1609: po_message_s.sql_error('FETCH_LINES',l_progress,SQLCODE);
1610: PO_AUTOCREATE_PVT.wrapup();
1611: RAISE;

Line 1610: PO_AUTOCREATE_PVT.wrapup();

1606: --CLM Phase 2 changes : error handling
1607: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_FETCH_ERR',x_token1_value => sqlerrm);
1608:
1609: po_message_s.sql_error('FETCH_LINES',l_progress,SQLCODE);
1610: PO_AUTOCREATE_PVT.wrapup();
1611: RAISE;
1612: END fetch_lines;
1613:
1614: /* ============================================================================

Line 1873: PO_AUTOCREATE_PVT.wrapup();

1869: WHEN OTHERS THEN
1870: IF g_debug_unexp THEN
1871: po_debug.debug_exc (p_log_head => g_log_head || l_api_name, p_progress => l_progress );
1872: END IF;
1873: PO_AUTOCREATE_PVT.wrapup();
1874: po_message_s.sql_error('CREATE_LINE',l_progress,SQLCODE);
1875: RAISE;
1876: END;
1877: ELSE

Line 2044: PO_AUTOCREATE_PVT.report_error('PO_AUTO_SRC_DOC_ERR',

2040: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2041: END IF;
2042:
2043: --CLM Phase 2 changes : error handling
2044: PO_AUTOCREATE_PVT.report_error('PO_AUTO_SRC_DOC_ERR',
2045: x_token1_value => sqlerrm,
2046: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2047:
2048: po_message_s.sql_error('CREATE_LINE',l_progress,SQLCODE);

Line 2046: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));

2042:
2043: --CLM Phase 2 changes : error handling
2044: PO_AUTOCREATE_PVT.report_error('PO_AUTO_SRC_DOC_ERR',
2045: x_token1_value => sqlerrm,
2046: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2047:
2048: po_message_s.sql_error('CREATE_LINE',l_progress,SQLCODE);
2049: PO_AUTOCREATE_PVT.wrapup();
2050: raise;

Line 2049: PO_AUTOCREATE_PVT.wrapup();

2045: x_token1_value => sqlerrm,
2046: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2047:
2048: po_message_s.sql_error('CREATE_LINE',l_progress,SQLCODE);
2049: PO_AUTOCREATE_PVT.wrapup();
2050: raise;
2051: END;
2052:
2053: l_progress := '120';

Line 2159: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ITEM_ERR',

2155: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2156: END IF;
2157:
2158: --CLM Phase 2 changes : error handling
2159: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ITEM_ERR',
2160: x_token1_value => sqlerrm,
2161: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2162:
2163: PO_AUTOCREATE_PVT.wrapup();

Line 2161: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));

2157:
2158: --CLM Phase 2 changes : error handling
2159: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ITEM_ERR',
2160: x_token1_value => sqlerrm,
2161: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2162:
2163: PO_AUTOCREATE_PVT.wrapup();
2164: po_message_s.sql_error('Get Item/Org defaults',l_progress,SQLCODE);
2165: raise;

Line 2163: PO_AUTOCREATE_PVT.wrapup();

2159: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ITEM_ERR',
2160: x_token1_value => sqlerrm,
2161: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2162:
2163: PO_AUTOCREATE_PVT.wrapup();
2164: po_message_s.sql_error('Get Item/Org defaults',l_progress,SQLCODE);
2165: raise;
2166: END;
2167:

Line 2211: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ITEM_ERR',

2207: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2208: END IF;
2209:
2210: --CLM Phase 2 changes : error handling
2211: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ITEM_ERR',
2212: x_token1_value => sqlerrm,
2213: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2214: PO_AUTOCREATE_PVT.wrapup();
2215: po_message_s.sql_error('Get Item/Master org defaults',l_progress,SQLCODE);

Line 2213: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));

2209:
2210: --CLM Phase 2 changes : error handling
2211: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ITEM_ERR',
2212: x_token1_value => sqlerrm,
2213: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2214: PO_AUTOCREATE_PVT.wrapup();
2215: po_message_s.sql_error('Get Item/Master org defaults',l_progress,SQLCODE);
2216: raise;
2217: END;

Line 2214: PO_AUTOCREATE_PVT.wrapup();

2210: --CLM Phase 2 changes : error handling
2211: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ITEM_ERR',
2212: x_token1_value => sqlerrm,
2213: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2214: PO_AUTOCREATE_PVT.wrapup();
2215: po_message_s.sql_error('Get Item/Master org defaults',l_progress,SQLCODE);
2216: raise;
2217: END;
2218: ELSE

Line 2257: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ONE_TIME_ITEM_ERR',

2253: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2254: END IF;
2255:
2256: --CLM Phase 2 changes : error handling
2257: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ONE_TIME_ITEM_ERR',
2258: x_token1_value => sqlerrm,
2259: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2260:
2261: PO_AUTOCREATE_PVT.wrapup();

Line 2259: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));

2255:
2256: --CLM Phase 2 changes : error handling
2257: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ONE_TIME_ITEM_ERR',
2258: x_token1_value => sqlerrm,
2259: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2260:
2261: PO_AUTOCREATE_PVT.wrapup();
2262:
2263: po_message_s.sql_error('Get Line type default',l_progress,SQLCODE);

Line 2261: PO_AUTOCREATE_PVT.wrapup();

2257: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_ONE_TIME_ITEM_ERR',
2258: x_token1_value => sqlerrm,
2259: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2260:
2261: PO_AUTOCREATE_PVT.wrapup();
2262:
2263: po_message_s.sql_error('Get Line type default',l_progress,SQLCODE);
2264: raise;
2265: END;

Line 2290: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_VENDOR_ERR',

2286: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2287: END IF;
2288:
2289: --CLM Phase 2 changes : error handling
2290: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_VENDOR_ERR',
2291: x_token1_value => sqlerrm,
2292: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2293:
2294: PO_AUTOCREATE_PVT.wrapup();

Line 2292: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));

2288:
2289: --CLM Phase 2 changes : error handling
2290: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_VENDOR_ERR',
2291: x_token1_value => sqlerrm,
2292: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2293:
2294: PO_AUTOCREATE_PVT.wrapup();
2295: po_message_s.sql_error('Get vendor default',l_progress,SQLCODE);
2296: raise;

Line 2294: PO_AUTOCREATE_PVT.wrapup();

2290: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_VENDOR_ERR',
2291: x_token1_value => sqlerrm,
2292: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2293:
2294: PO_AUTOCREATE_PVT.wrapup();
2295: po_message_s.sql_error('Get vendor default',l_progress,SQLCODE);
2296: raise;
2297: END;
2298:

Line 2328: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_SYTEM_ERR',

2324: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2325: END IF;
2326:
2327: --CLM Phase 2 changes : error handling
2328: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_SYTEM_ERR',
2329: x_token1_value => sqlerrm,
2330: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2331:
2332: PO_AUTOCREATE_PVT.wrapup();

Line 2330: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));

2326:
2327: --CLM Phase 2 changes : error handling
2328: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_SYTEM_ERR',
2329: x_token1_value => sqlerrm,
2330: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2331:
2332: PO_AUTOCREATE_PVT.wrapup();
2333: po_message_s.sql_error('Get po system default',l_progress,SQLCODE);
2334: raise;

Line 2332: PO_AUTOCREATE_PVT.wrapup();

2328: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_SYTEM_ERR',
2329: x_token1_value => sqlerrm,
2330: x_token2_value => PO_AUTOCREATE_PVT.get_requisition_line_num(p_lines.requisition_line_id_tbl(i)));
2331:
2332: PO_AUTOCREATE_PVT.wrapup();
2333: po_message_s.sql_error('Get po system default',l_progress,SQLCODE);
2334: raise;
2335: END;
2336:

Line 3086: PO_AUTOCREATE_PVT.calculate_local( PO_AUTOCREATE_PARAMS.g_document_subtype, 'LINE', p_lines.po_line_id_tbl(i));

3082: p_lines.clm_delivery_event_code_tbl(i)
3083: );
3084:
3085: IF( PO_AUTOCREATE_PARAMS.g_document_subtype IN ('STANDARD','PLANNED','BLANKET') ) THEN
3086: PO_AUTOCREATE_PVT.calculate_local( PO_AUTOCREATE_PARAMS.g_document_subtype, 'LINE', p_lines.po_line_id_tbl(i));
3087: END IF;
3088:
3089: END IF;
3090:

Line 3445: PO_AUTOCREATE_PVT.wrapup();

3441: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3442: p_progress => l_progress);
3443: END IF;
3444: po_message_s.sql_error('DERIVE_AND_DEFAULT_LINES',l_progress,sqlcode);
3445: PO_AUTOCREATE_PVT.wrapup();
3446: RAISE;
3447: --autocreate grouping end
3448:
3449: WHEN OTHERS THEN

Line 3455: PO_AUTOCREATE_PVT.wrapup();

3451: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3452: p_progress => l_progress);
3453: END IF;
3454: po_message_s.sql_error('DERIVE_AND_DEFAULT_LINES',l_progress,sqlcode);
3455: PO_AUTOCREATE_PVT.wrapup();
3456: RAISE;
3457:
3458: END derive_and_default_lines;
3459:

Line 3538: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_MERGE_DIFF_ERR',x_token1_value => sqlerrm);

3534: PO_DEBUG.debug_exc( p_log_head => g_log_head||l_api_name, p_progress => l_progress);
3535: END IF;
3536:
3537: --CLM Phase 2 changes : error handling
3538: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_MERGE_DIFF_ERR',x_token1_value => sqlerrm);
3539:
3540: PO_MESSAGE_S.sql_error('PO_AUTO_LINE_PROCESS_PVT.merge_to_price_diff_draft', l_progress , SQLCODE);
3541: RAISE;
3542:

Line 4661: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_MERGE_ATTR_ERR',x_token1_value => sqlerrm);

4657: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
4658: END IF;
4659:
4660: --CLM Phase 2 changes : error handling
4661: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_MERGE_ATTR_ERR',x_token1_value => sqlerrm);
4662:
4663: po_autocreate_pvt.wrapup;
4664: PO_MESSAGE_S.sql_error ( 'PO_AUTO_LINE_PROCESS_PVT.merge_to_attr_values_draft', l_progress , SQLCODE );
4665: RAISE;

Line 4663: po_autocreate_pvt.wrapup;

4659:
4660: --CLM Phase 2 changes : error handling
4661: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_MERGE_ATTR_ERR',x_token1_value => sqlerrm);
4662:
4663: po_autocreate_pvt.wrapup;
4664: PO_MESSAGE_S.sql_error ( 'PO_AUTO_LINE_PROCESS_PVT.merge_to_attr_values_draft', l_progress , SQLCODE );
4665: RAISE;
4666: END merge_to_attr_values_draft;
4667:

Line 4880: PO_AUTOCREATE_PVT.report_error('PO_AUTO_CURRENCY_CONV_ERR',x_token1_value => sqlerrm);

4876: WHEN OTHERS THEN
4877: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);
4878: RAISE;
4879: --CLM Phase 2 changes : error handling
4880: PO_AUTOCREATE_PVT.report_error('PO_AUTO_CURRENCY_CONV_ERR',x_token1_value => sqlerrm);
4881:
4882: END do_currency_conversion;
4883:
4884:

Line 5075: PO_AUTOCREATE_PVT.report_error('create_pon_back_req_dist',x_token1_value => sqlerrm);

5071: WHEN OTHERS THEN
5072: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);
5073: RAISE;
5074: --CLM Phase 2 changes : error handling
5075: PO_AUTOCREATE_PVT.report_error('create_pon_back_req_dist',x_token1_value => sqlerrm);
5076:
5077: END create_pon_back_req_dist;
5078: END PO_AUTO_LINE_PROCESS_PVT;