DBA Data[Home] [Help]

APPS.CSTPPCIT dependencies on CSTPPCIT

Line 1: PACKAGE BODY CSTPPCIT AS

1: PACKAGE BODY CSTPPCIT AS
2: /* $Header: CSTPCITB.pls 115.4 2002/11/09 00:40:41 awwang ship $ */
3:
4: PROCEDURE periodic_cost_validate (
5: i_org_cost_group_id in number,

Line 270: o_err_msg := 'CSTPPCIT.PERIODIC_COST_VALIDATE:' || l_err_msg;

266: EXCEPTION
267: WHEN process_error THEN
268: o_err_num := l_err_num;
269: o_err_code := l_err_code;
270: o_err_msg := 'CSTPPCIT.PERIODIC_COST_VALIDATE:' || l_err_msg;
271: WHEN OTHERS THEN
272: o_err_num := SQLCODE;
273: o_err_msg := 'CSTPPCIT.PERIODIC_COST_VALIDATE: (' || to_char(l_stmt_num)
274: || '): ' || substr(SQLERRM,1,150);

Line 273: o_err_msg := 'CSTPPCIT.PERIODIC_COST_VALIDATE: (' || to_char(l_stmt_num)

269: o_err_code := l_err_code;
270: o_err_msg := 'CSTPPCIT.PERIODIC_COST_VALIDATE:' || l_err_msg;
271: WHEN OTHERS THEN
272: o_err_num := SQLCODE;
273: o_err_msg := 'CSTPPCIT.PERIODIC_COST_VALIDATE: (' || to_char(l_stmt_num)
274: || '): ' || substr(SQLERRM,1,150);
275:
276: END periodic_cost_validate;
277:

Line 371: cstppcit.periodic_cost_det_new_insert(l_pac_period_id, l_legal_entity,

367: * In this case, call cstpacit.cost_det_new_insert.
368: */
369:
370: IF (l_num_detail = 0) THEN
371: cstppcit.periodic_cost_det_new_insert(l_pac_period_id, l_legal_entity,
372: i_cost_type_id,
373: i_txn_id, i_txn_action_id, i_org_id,
374: i_item_id, i_org_cost_group_id, i_txn_cost,
375: i_new_avg_cost, i_per_change, i_val_change,

Line 437: o_err_msg := 'CSTPPCIT.PERIODIC_COST_DET_MOVE:' || l_err_msg;

433: EXCEPTION
434: WHEN process_error THEN
435: o_err_num := l_err_num;
436: o_err_code := l_err_code;
437: o_err_msg := 'CSTPPCIT.PERIODIC_COST_DET_MOVE:' || l_err_msg;
438: WHEN OTHERS THEN
439: o_err_num := SQLCODE;
440: o_err_msg := 'CSTPPCIT.PERIODIC_COST_DET_MOVE:' || substr(SQLERRM,1,150);
441:

Line 440: o_err_msg := 'CSTPPCIT.PERIODIC_COST_DET_MOVE:' || substr(SQLERRM,1,150);

436: o_err_code := l_err_code;
437: o_err_msg := 'CSTPPCIT.PERIODIC_COST_DET_MOVE:' || l_err_msg;
438: WHEN OTHERS THEN
439: o_err_num := SQLCODE;
440: o_err_msg := 'CSTPPCIT.PERIODIC_COST_DET_MOVE:' || substr(SQLERRM,1,150);
441:
442: END periodic_cost_det_move;
443:
444:

Line 672: o_err_msg := 'CSTPPCIT.PERIODIC_COST_DET_NEW_INSERT:' || l_err_msg;

668: EXCEPTION
669: WHEN process_error THEN
670: o_err_num := l_err_num;
671: o_err_code := l_err_code;
672: o_err_msg := 'CSTPPCIT.PERIODIC_COST_DET_NEW_INSERT:' || l_err_msg;
673: WHEN OTHERS THEN
674: o_err_num := SQLCODE;
675: o_err_msg := 'CSTPPCIT.PERIODIC_COST_DET_NEW_INSERT:' ||
676: substr(SQLERRM,1,150);

Line 675: o_err_msg := 'CSTPPCIT.PERIODIC_COST_DET_NEW_INSERT:' ||

671: o_err_code := l_err_code;
672: o_err_msg := 'CSTPPCIT.PERIODIC_COST_DET_NEW_INSERT:' || l_err_msg;
673: WHEN OTHERS THEN
674: o_err_num := SQLCODE;
675: o_err_msg := 'CSTPPCIT.PERIODIC_COST_DET_NEW_INSERT:' ||
676: substr(SQLERRM,1,150);
677:
678: END periodic_cost_det_new_insert;
679:

Line 680: END cstppcit;

676: substr(SQLERRM,1,150);
677:
678: END periodic_cost_det_new_insert;
679:
680: END cstppcit;