DBA Data[Home] [Help]

APPS.PO_AUTO_LINE_PROCESS_PVT dependencies on PO_MESSAGE_S

Line 1123: po_message_s.sql_error('SETUP_INTERFACE_DATA',l_progress,SQLCODE);

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;
1126: END setup_interface_data;
1127:

Line 1609: po_message_s.sql_error('FETCH_LINES',l_progress,SQLCODE);

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;
1612: END fetch_lines;
1613:

Line 1874: po_message_s.sql_error('CREATE_LINE',l_progress,SQLCODE);

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
1878: l_progress := '052';

Line 2048: po_message_s.sql_error('CREATE_LINE',l_progress,SQLCODE);

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;
2051: END;
2052:

Line 2164: po_message_s.sql_error('Get Item/Org defaults',l_progress,SQLCODE);

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:
2168: BEGIN

Line 2215: po_message_s.sql_error('Get Item/Master org defaults',l_progress,SQLCODE);

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
2219: /* this case will reach when the item_id is null */

Line 2263: po_message_s.sql_error('Get Line type default',l_progress,SQLCODE);

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;
2266:
2267: /* Select receipt required flag,inspection required flag

Line 2295: po_message_s.sql_error('Get vendor default',l_progress,SQLCODE);

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:
2299: l_progress := '200';

Line 2333: po_message_s.sql_error('Get po system default',l_progress,SQLCODE);

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:
2337: -- If not defined at po system option level also then

Line 3444: po_message_s.sql_error('DERIVE_AND_DEFAULT_LINES',l_progress,sqlcode);

3440: IF g_debug_unexp THEN
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:

Line 3454: po_message_s.sql_error('DERIVE_AND_DEFAULT_LINES',l_progress,sqlcode);

3450: IF g_debug_unexp THEN
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;

Line 3540: PO_MESSAGE_S.sql_error('PO_AUTO_LINE_PROCESS_PVT.merge_to_price_diff_draft', l_progress , SQLCODE);

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:
3543: END merge_to_price_diff_draft;
3544:

Line 4664: PO_MESSAGE_S.sql_error ( 'PO_AUTO_LINE_PROCESS_PVT.merge_to_attr_values_draft', l_progress , SQLCODE );

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:
4668: -------------------------------------------------------------------------------