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.16.12020000.3 2013/05/21 10:55:08 vkatakam 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 608: CSTPLVCP.sub_transfer(

604: if ((i_txn_action_id IN (2,5,28,55)) or
605: (i_txn_action_id = 21 and i_org_id = i_txn_org_id and i_fob_point = 2) or
606: (i_txn_action_id = 12 and i_org_id = i_txn_org_id and i_fob_point = 1)) then
607: l_stmt_num := 90;
608: CSTPLVCP.sub_transfer(
609: i_org_id,
610: i_txn_id,
611: i_layer_id,
612: i_cost_type,

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

741: o_err_msg := l_err_msg;
742: when OTHERS then
743: rollback;
744: o_err_num := SQLCODE;
745: o_err_msg := 'CSTPLVCP.Cost_Processor (' || to_char(l_stmt_num) || '): '
746: || substr(SQLERRM,1,200);
747: END cost_processor;
748:
749: -- PROCEDURE

Line 825: CSTPLVCP.sub_transfer(

821: -- 2. project sub to project job issue
822: -- insert a separate row in MCACD and call wip cost processor
823: -- and distribution processor
824:
825: CSTPLVCP.sub_transfer(
826: i_org_id,
827: i_txn_id,
828: i_layer_id,
829: i_cost_type,

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

921: o_err_msg := l_err_msg;
922: when others then
923: rollback;
924: o_err_num := SQLCODE;
925: o_err_msg := 'CSTPLVCP.common_issue_to_wip (' || to_char(l_stmt_num) ||
926: '): '
927: || substr(SQLERRM, 1,200);
928: END common_issue_to_wip;
929:

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

2259: o_err_msg := FND_MESSAGE.Get;
2260: when others then
2261: rollback;
2262: o_err_num := SQLCODE;
2263: o_err_msg := 'CSTPLVCP.interorg (' || to_char(l_stmt_num) ||
2264: '): '
2265: || substr(SQLERRM, 1,200);
2266:
2267: END interorg;

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

2386:
2387: when others then
2388: rollback;
2389: o_err_num := SQLCODE;
2390: o_err_msg := 'CSTPLVCP.get_snd_rcv_rate (' || to_char(l_stmt_num) ||
2391: '): '
2392: || substr(SQLERRM, 1,200);
2393:
2394: END get_snd_rcv_rate;

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

2433: EXCEPTION
2434: when others then
2435: rollback;
2436: o_err_num := SQLCODE;
2437: o_err_msg := 'CSTPLVCP.get_snd_rcv_uom (' || to_char(l_stmt_num) ||
2438: '): '
2439: || substr(SQLERRM, 1,200);
2440:
2441: END get_snd_rcv_uom;

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

2752: o_err_msg := l_err_msg;
2753: when others then
2754: rollback;
2755: o_err_num := SQLCODE;
2756: o_err_msg := 'CSTPLVCP.interorg_elemental_detail (' || to_char(l_stmt_num)
2757: || '): ' || substr(SQLERRM, 1,200);
2758:
2759:
2760: END interorg_elemental_detail;

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

2929: EXCEPTION
2930: when cst_no_hook_allowed then
2931: rollback;
2932: o_err_num := 24020;
2933: o_err_code := substr('CSTPLVCP.borrow_cost('
2934: ||to_char(l_stmt_num)
2935: || '): '
2936: || l_err_msg
2937: || '.',1,240);

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

2940: o_err_msg := substr(o_err_msg,1,240);
2941: when others then
2942: rollback;
2943: o_err_num := SQLCODE;
2944: o_err_msg := 'CSTPLVCP.borrow_cost (' || to_char(l_stmt_num) ||
2945: '): '
2946: || substr(SQLERRM, 1,200);
2947:
2948: END borrow_cost;

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

4023: EXCEPTION
4024: when cst_no_hook_allowed then
4025: rollback;
4026: o_err_num := 24030;
4027: o_err_code := substr('CSTPLVCP.sub_transfer('
4028: ||to_char(l_stmt_num)
4029: || '): '
4030: || l_err_msg
4031: || '.',1,240);

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

4040:
4041: when others then
4042: rollback;
4043: o_err_num := SQLCODE;
4044: o_err_msg := 'CSTPLVCP.sub_transfer (' || to_char(l_stmt_num)
4045: || '): '
4046: || substr(SQLERRM, 1,240);
4047: END sub_transfer;
4048:

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

4236: EXCEPTION
4237: when cst_no_hook_allowed then
4238: rollback;
4239: o_err_num := 24020;
4240: o_err_code := substr('CSTPLVCP.payback_variance('
4241: ||to_char(l_stmt_num)
4242: || '): '
4243: || l_err_msg
4244: || '.',1,240);

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

4247: o_err_msg := substr(o_err_msg,1,240);
4248: when others then
4249: rollback;
4250: o_err_num := SQLCODE;
4251: o_err_msg := 'CSTPLVCP.payback_variance (' || to_char(l_stmt_num) ||
4252: '): '
4253: || substr(SQLERRM, 1,200);
4254:
4255: END payback_variance;

Line 4743: END CSTPLVCP;

4739: '): ' || substr(SQLERRM, 1,200);
4740:
4741: END Cost_Logical_itr_receipt;
4742:
4743: END CSTPLVCP;