APPS.WSMPLBTH dependencies on WSMPLBTH

Line 1: PACKAGE BODY WSMPLBTH AS

1: PACKAGE BODY WSMPLBTH AS
2: /* $Header: WSMLBTHB.pls 115.19 2003/10/08 18:29:51 zchen ship $ */
3:
4: FUNCTION Insert_Starting_Lot (
5: p_transaction_type IN NUMBER,

Line 102: x_err_msg := 'WSMPLBTH:INSERT_STARTING_LOT '||SUBSTR(SQLERRM, 1,60);

98:
99: EXCEPTION WHEN OTHERS THEN
100:
101: x_err_code := SQLCODE;
102: x_err_msg := 'WSMPLBTH:INSERT_STARTING_LOT '||SUBSTR(SQLERRM, 1,60);
103: RETURN -1;
104:
105:
106: END Insert_Starting_Lot;

Line 157: x_err_msg := 'WSMPLBTH:INSERT_RESULTING_LOT '||SUBSTR(SQLERRM, 1,60);

153:
154: EXCEPTION WHEN OTHERS THEN
155:
156: x_err_code := SQLCODE;
157: x_err_msg := 'WSMPLBTH:INSERT_RESULTING_LOT '||SUBSTR(SQLERRM, 1,60);
158:
159: END Insert_Resulting_Lot;
160:
161:

Line 217: x_err_msg := 'WSMPLBTH:INSERT_RESULTING_LOT '||SUBSTR(SQLERRM, 1,60);

213:
214: p_acct_period_id := '';
215: p_org_locator_control := '';
216: x_err_code := SQLCODE;
217: x_err_msg := 'WSMPLBTH:INSERT_RESULTING_LOT '||SUBSTR(SQLERRM, 1,60);
218:
219:
220: END get_org_values;
221:

Line 454: x_err_msg := 'WSMPLBTH:CREATE_NEW_LOT '||'(stmt_num='||l_st_num||')'||SUBSTR(SQLERRM, 1,60);

450: WHEN NO_DATA_FOUND THEN
451: NULL ;
452: WHEN OTHERS THEN
453: x_err_code := SQLCODE;
454: x_err_msg := 'WSMPLBTH:CREATE_NEW_LOT '||'(stmt_num='||l_st_num||')'||SUBSTR(SQLERRM, 1,60);
455: RETURN -1;
456:
457: END;
458:

Line 465: x_err_msg := 'WSMPLBTH:CREATE_NEW_LOT '||'(stmt_num='||l_st_num||')'||SUBSTR(SQLERRM, 1,60);

461: return 1;
462:
463: EXCEPTION WHEN OTHERS THEN
464: x_err_code := SQLCODE;
465: x_err_msg := 'WSMPLBTH:CREATE_NEW_LOT '||'(stmt_num='||l_st_num||')'||SUBSTR(SQLERRM, 1,60);
466: RETURN -1;
467: */
468:
469: END CREATE_NEW_LOT;

Line 489: x_err_msg := 'WSMPLBTH:UPDATE_WRO '||SUBSTR(SQLERRM, 1,60);

485: EXCEPTION
486:
487: WHEN OTHERS THEN
488: x_err_code := SQLCODE;
489: x_err_msg := 'WSMPLBTH:UPDATE_WRO '||SUBSTR(SQLERRM, 1,60);
490:
491: END;
492:
493: /*BA#2326548*/

Line 542: END WSMPLBTH;

538: END;
539: /*EA#2326548*/
540:
541:
542: END WSMPLBTH;