DBA Data[Home] [Help]

APPS.CSTPLVCP dependencies on CSTPLVCP

Line 1: PACKAGE BODY CSTPLVCP AS

1: PACKAGE BODY CSTPLVCP AS
2: /* $Header: CSTLVCPB.pls 120.15 2007/11/30 21:37:41 ipineda ship $ */
3:
4: -- PROCEDURE
5: -- cost_processor Costs inventory transactions for FIFO/LIFO

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSTPLVCP';

4: -- PROCEDURE
5: -- cost_processor Costs inventory transactions for FIFO/LIFO
6: --
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSTPLVCP';
9: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MRP_DEBUG'),'N');
10:
11: l_pd_txfr_ind NUMBER := 0; -- OPM INVCONV sschinch
12:

Line 110: CSTPLVCP.cost_logical_itr_receipt(

106: -- This is a new transaction type introduced for p-d xfers enh. only.
107: -- 2. Physical Intransit Receipt and
108: -- 3. Direct Xfer receipt.
109: --
110: CSTPLVCP.cost_logical_itr_receipt(
111: i_org_id,
112: i_txn_id,
113: i_cost_method,
114: i_layer_id,

Line 161: CSTPLVCP.interorg ( i_org_id,

157: else no processing */
158:
159: l_stmt_num := 10;
160:
161: CSTPLVCP.interorg ( i_org_id,
162: i_txn_id,
163: i_cost_method,
164: i_layer_id,
165: i_cost_type,

Line 226: CSTPLVCP.common_issue_to_wip(

222:
223: /* Call WIP processor for the component issue */
224: l_stmt_num := 30;
225:
226: CSTPLVCP.common_issue_to_wip(
227: i_org_id,
228: i_txn_id,
229: i_layer_id,
230: i_cost_type,

Line 337: CSTPLVCP.borrow_cost( i_org_id,

333: then populate MCTCD with the borrowed cost */
334:
335: l_stmt_num := 70;
336:
337: CSTPLVCP.borrow_cost( i_org_id,
338: i_txn_id,
339: i_user_id,
340: i_login_id,
341: i_req_id,

Line 542: CSTPLVCP.sub_transfer(

538: if ((i_txn_action_id IN (2,5,28,55)) or
539: (i_txn_action_id = 21 and i_org_id = i_txn_org_id and i_fob_point = 2) or
540: (i_txn_action_id = 12 and i_org_id = i_txn_org_id and i_fob_point = 1)) then
541: l_stmt_num := 90;
542: CSTPLVCP.sub_transfer(
543: i_org_id,
544: i_txn_id,
545: i_layer_id,
546: i_cost_type,

Line 679: o_err_msg := 'CSTPLVCP.Cost_Processor (' || to_char(l_stmt_num) || '): '

675: o_err_msg := l_err_msg;
676: when OTHERS then
677: rollback;
678: o_err_num := SQLCODE;
679: o_err_msg := 'CSTPLVCP.Cost_Processor (' || to_char(l_stmt_num) || '): '
680: || substr(SQLERRM,1,200);
681: END cost_processor;
682:
683: -- PROCEDURE

Line 759: CSTPLVCP.sub_transfer(

755: -- 2. project sub to project job issue
756: -- insert a separate row in MCACD and call wip cost processor
757: -- and distribution processor
758:
759: CSTPLVCP.sub_transfer(
760: i_org_id,
761: i_txn_id,
762: i_layer_id,
763: i_cost_type,

Line 859: o_err_msg := 'CSTPLVCP.common_issue_to_wip (' || to_char(l_stmt_num) ||

855: o_err_msg := l_err_msg;
856: when others then
857: rollback;
858: o_err_num := SQLCODE;
859: o_err_msg := 'CSTPLVCP.common_issue_to_wip (' || to_char(l_stmt_num) ||
860: '): '
861: || substr(SQLERRM, 1,200);
862: END common_issue_to_wip;
863:

Line 2197: o_err_msg := 'CSTPLVCP.interorg (' || to_char(l_stmt_num) ||

2193: o_err_msg := FND_MESSAGE.Get;
2194: when others then
2195: rollback;
2196: o_err_num := SQLCODE;
2197: o_err_msg := 'CSTPLVCP.interorg (' || to_char(l_stmt_num) ||
2198: '): '
2199: || substr(SQLERRM, 1,200);
2200:
2201: END interorg;

Line 2324: o_err_msg := 'CSTPLVCP.get_snd_rcv_rate (' || to_char(l_stmt_num) ||

2320:
2321: when others then
2322: rollback;
2323: o_err_num := SQLCODE;
2324: o_err_msg := 'CSTPLVCP.get_snd_rcv_rate (' || to_char(l_stmt_num) ||
2325: '): '
2326: || substr(SQLERRM, 1,200);
2327:
2328: END get_snd_rcv_rate;

Line 2371: o_err_msg := 'CSTPLVCP.get_snd_rcv_uom (' || to_char(l_stmt_num) ||

2367: EXCEPTION
2368: when others then
2369: rollback;
2370: o_err_num := SQLCODE;
2371: o_err_msg := 'CSTPLVCP.get_snd_rcv_uom (' || to_char(l_stmt_num) ||
2372: '): '
2373: || substr(SQLERRM, 1,200);
2374:
2375: END get_snd_rcv_uom;

Line 2690: o_err_msg := 'CSTPLVCP.interorg_elemental_detail (' || to_char(l_stmt_num)

2686: o_err_msg := l_err_msg;
2687: when others then
2688: rollback;
2689: o_err_num := SQLCODE;
2690: o_err_msg := 'CSTPLVCP.interorg_elemental_detail (' || to_char(l_stmt_num)
2691: || '): ' || substr(SQLERRM, 1,200);
2692:
2693:
2694: END interorg_elemental_detail;

Line 2867: o_err_code := substr('CSTPLVCP.borrow_cost('

2863: EXCEPTION
2864: when cst_no_hook_allowed then
2865: rollback;
2866: o_err_num := 24020;
2867: o_err_code := substr('CSTPLVCP.borrow_cost('
2868: ||to_char(l_stmt_num)
2869: || '): '
2870: || l_err_msg
2871: || '.',1,240);

Line 2878: o_err_msg := 'CSTPLVCP.borrow_cost (' || to_char(l_stmt_num) ||

2874: o_err_msg := substr(o_err_msg,1,240);
2875: when others then
2876: rollback;
2877: o_err_num := SQLCODE;
2878: o_err_msg := 'CSTPLVCP.borrow_cost (' || to_char(l_stmt_num) ||
2879: '): '
2880: || substr(SQLERRM, 1,200);
2881:
2882: END borrow_cost;

Line 3960: o_err_code := substr('CSTPLVCP.sub_transfer('

3956: EXCEPTION
3957: when cst_no_hook_allowed then
3958: rollback;
3959: o_err_num := 24030;
3960: o_err_code := substr('CSTPLVCP.sub_transfer('
3961: ||to_char(l_stmt_num)
3962: || '): '
3963: || l_err_msg
3964: || '.',1,240);

Line 3977: o_err_msg := 'CSTPLVCP.sub_transfer (' || to_char(l_stmt_num)

3973:
3974: when others then
3975: rollback;
3976: o_err_num := SQLCODE;
3977: o_err_msg := 'CSTPLVCP.sub_transfer (' || to_char(l_stmt_num)
3978: || '): '
3979: || substr(SQLERRM, 1,240);
3980: END sub_transfer;
3981:

Line 4173: o_err_code := substr('CSTPLVCP.payback_variance('

4169: EXCEPTION
4170: when cst_no_hook_allowed then
4171: rollback;
4172: o_err_num := 24020;
4173: o_err_code := substr('CSTPLVCP.payback_variance('
4174: ||to_char(l_stmt_num)
4175: || '): '
4176: || l_err_msg
4177: || '.',1,240);

Line 4184: o_err_msg := 'CSTPLVCP.payback_variance (' || to_char(l_stmt_num) ||

4180: o_err_msg := substr(o_err_msg,1,240);
4181: when others then
4182: rollback;
4183: o_err_num := SQLCODE;
4184: o_err_msg := 'CSTPLVCP.payback_variance (' || to_char(l_stmt_num) ||
4185: '): '
4186: || substr(SQLERRM, 1,200);
4187:
4188: END payback_variance;

Line 4676: END CSTPLVCP;

4672: '): ' || substr(SQLERRM, 1,200);
4673:
4674: END Cost_Logical_itr_receipt;
4675:
4676: END CSTPLVCP;