1: PACKAGE BODY CSTPLCIR AS
2: /* $Header: CSTLCIRB.pls 120.1.12020000.2 2012/07/11 13:04:53 vkatakam ship $ */
3:
4:
5:
254:
255: EXCEPTION
256: WHEN bad_inv_consume_exception THEN
257: o_err_num := 1007;
258: o_err_msg := 'CSTPLCIR.component_issue():' ||
259: to_char(l_stmt_num) || ':' ||
260: 'Inventory total txn qty was ' || l_total_txn_qty || '; ' ||
261: ' expected ' || i_txn_qty;
262:
261: ' expected ' || i_txn_qty;
262:
263: WHEN OTHERS THEN
264: o_err_num := SQLCODE;
265: o_err_msg := 'CSTPLCIR.component_issue():' ||
266: to_char(l_stmt_num) || ':' ||
267: substr(SQLERRM,1,150);
268:
269: END component_issue;
519:
520: EXCEPTION
521: WHEN OTHERS THEN
522: o_err_num := SQLCODE;
523: o_err_msg := 'CSTPLCIR.component_return():' ||
524: to_char(l_stmt_num) || ':' ||
525: substr(SQLERRM,1,150);
526:
527: END component_return;
529:
530:
531:
532:
533: END CSTPLCIR;