eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPLENG dependencies on CSTPLENG

Line 1: PACKAGE BODY CSTPLENG AS

1: PACKAGE BODY CSTPLENG AS
2: /* $Header: CSTLENGB.pls 120.22.12020000.3 2013/01/11 05:04:12 yuyun ship $ */
3:
4: ----------------------------------------------------------------------------
5: -- PROCEDURE --

Line 155: o_err_msg := 'CSTPLENG.compute_layer_actual_cost (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);

151: return l_ret_val;
152: when others then
153: rollback;
154: o_err_num := SQLCODE;
155: o_err_msg := 'CSTPLENG.compute_layer_actual_cost (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);
156: l_ret_val := 0;
157: return l_ret_val;
158: END compute_layer_actual_cost;
159:

Line 418: o_err_msg := 'CSTPLENG.consume_create_layers (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);

414:
415: when others then
416: rollback;
417: o_err_num := SQLCODE;
418: o_err_msg := 'CSTPLENG.consume_create_layers (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);
419:
420: End consume_create_layers;
421:
422: ----------------------------------------------------------------------------

Line 1297: o_err_msg := 'CSTPLENG.insert_mclacd (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);

1293: o_err_msg := l_err_msg;
1294: when others then
1295: rollback;
1296: o_err_num := SQLCODE;
1297: o_err_msg := 'CSTPLENG.insert_mclacd (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);
1298: End insert_mclacd;
1299:
1300: ----------------------------------------------------------------------------
1301: -- PROCEDURE --

Line 2249: o_err_msg := 'CSTPLENG.create_layers (' ||

2245:
2246: WHEN OTHERS THEN
2247: ROLLBACK;
2248: o_err_num := SQLCODE;
2249: o_err_msg := 'CSTPLENG.create_layers (' ||
2250: to_char(l_stmt_num) || '): ' ||
2251: substr(SQLERRM,1,200);
2252:
2253: END create_layers;

Line 2874: o_err_msg := 'CSTPLENG.consume_layers (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);

2870: o_err_msg := l_err_msg;
2871: when others then
2872: rollback;
2873: o_err_num := SQLCODE;
2874: o_err_msg := 'CSTPLENG.consume_layers (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);
2875:
2876: END consume_layers;
2877:
2878: ----------------------------------------------------------------------------

Line 3400: o_err_msg := 'CSTPLENG.get_layers_consumed (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);

3396: when others then
3397: rollback;
3398: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLCODE ||' ' ||to_char(l_stmt_num)||' '||substr(SQLERRM,1,200));
3399: o_err_num := SQLCODE;
3400: o_err_msg := 'CSTPLENG.get_layers_consumed (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);
3401: END get_layers_consumed;
3402:
3403: ----------------------------------------------------------------------------
3404: -- PROCEDURE --

Line 3470: o_err_msg := 'CSTPLENG.populate_layer_table (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);

3466: o_err_msg := l_err_msg;
3467: when others then
3468: rollback;
3469: o_err_num := SQLCODE;
3470: o_err_msg := 'CSTPLENG.populate_layer_table (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);
3471: END populate_layer_table;
3472:
3473: ----------------------------------------------------------------------------
3474: -- PROCEDURE --

Line 3525: o_err_msg := 'CSTPLENG.insert_record (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);

3521: o_err_msg := l_err_msg;
3522: when others then
3523: rollback;
3524: o_err_num := SQLCODE;
3525: o_err_msg := 'CSTPLENG.insert_record (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);
3526: END insert_record;
3527:
3528:
3529: ---------------------------------------------------------------------------

Line 4140: o_err_msg := 'CSTPLENG.apply_layer_material_ovhd (' || to_char(l_stmt_num) ||

4136: o_err_msg := FND_MESSAGE.Get;
4137: when others then
4138: rollback;
4139: o_err_num := SQLCODE;
4140: o_err_msg := 'CSTPLENG.apply_layer_material_ovhd (' || to_char(l_stmt_num) ||
4141: '): '
4142: || substr(SQLERRM, 1,200);
4143:
4144: END apply_layer_material_ovhd;

Line 4775: o_err_msg := 'CSTPLENG.calc_layer_average_cost (' || to_char(l_stmt_num) ||

4771: o_err_msg := l_err_msg;
4772: when others then
4773: rollback;
4774: o_err_num := SQLCODE;
4775: o_err_msg := 'CSTPLENG.calc_layer_average_cost (' || to_char(l_stmt_num) ||
4776: '): '
4777: || substr(SQLERRM, 1,200);
4778:
4779: END calc_layer_average_cost;

Line 5096: CSTPLENG.calc_layer_average_cost(

5092:
5093: FND_FILE.PUT_LINE(FND_FILE.LOG, 'layer qty = ' || to_char(l_layer_qty));
5094: l_stmt_num := 70;
5095:
5096: CSTPLENG.calc_layer_average_cost(
5097: i_org_id,
5098: i_txn_id,
5099: i_layer_id,
5100: i_cost_type,

Line 5155: o_err_msg := 'CSTPLENG.layer_cost_update (' || to_char(l_stmt_num) ||

5151:
5152: when others then
5153: rollback;
5154: o_err_num := SQLCODE;
5155: o_err_msg := 'CSTPLENG.layer_cost_update (' || to_char(l_stmt_num) ||
5156: '): '
5157: || substr(SQLERRM, 1,200);
5158: END layer_cost_update;
5159:

Line 5332: o_err_msg := 'CSTPLENG.get_current_layer:' || substrb(SQLERRM,1,150);

5328: EXCEPTION
5329:
5330: when others then
5331: o_err_num := SQLCODE;
5332: o_err_msg := 'CSTPLENG.get_current_layer:' || substrb(SQLERRM,1,150);
5333: return 0;
5334:
5335: END get_current_layer;
5336:

Line 5399: cstpleng.layer_cost_det_new_insert(i_txn_id, i_txn_action_id, i_org_id,

5395: * In this case, call cstpacit.cost_det_new_insert.
5396: */
5397:
5398: if (l_num_detail = 0) then
5399: cstpleng.layer_cost_det_new_insert(i_txn_id, i_txn_action_id, i_org_id,
5400: i_item_id, i_cost_group_id, i_inv_layer_id, i_txn_cost,
5401: i_new_avg_cost, i_per_change, i_val_change,
5402: i_mat_accnt, i_mat_ovhd_accnt, i_res_accnt,
5403: i_osp_accnt, i_ovhd_accnt,

Line 5541: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE:' || l_err_msg;

5537: EXCEPTION
5538: when cost_det_move_error then
5539: o_err_num := l_err_num;
5540: o_err_code := l_err_code;
5541: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE:' || l_err_msg;
5542: when cost_no_layer_error then
5543: o_err_num := l_err_num;
5544: o_err_code := l_err_code;
5545: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE: No layer exists' || l_err_msg;

Line 5545: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE: No layer exists' || l_err_msg;

5541: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE:' || l_err_msg;
5542: when cost_no_layer_error then
5543: o_err_num := l_err_num;
5544: o_err_code := l_err_code;
5545: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE: No layer exists' || l_err_msg;
5546: when OTHERS then
5547: o_err_num := SQLCODE;
5548: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE:' || substr(SQLERRM,1,150);
5549:

Line 5548: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE:' || substr(SQLERRM,1,150);

5544: o_err_code := l_err_code;
5545: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE: No layer exists' || l_err_msg;
5546: when OTHERS then
5547: o_err_num := SQLCODE;
5548: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE:' || substr(SQLERRM,1,150);
5549:
5550: end layer_cost_det_move;
5551:
5552: --------------------------------------------------------------------------

Line 5781: o_err_msg := 'CSTPLENG.LAYER_COST_DET_NEW_INSERT:' || l_err_msg;

5777: EXCEPTION
5778: when cost_det_new_insert_error then
5779: o_err_num := l_err_num;
5780: o_err_code := l_err_code;
5781: o_err_msg := 'CSTPLENG.LAYER_COST_DET_NEW_INSERT:' || l_err_msg;
5782: when OTHERS then
5783: o_err_num := SQLCODE;
5784: o_err_msg := 'CSTPLENG.LAYER_COST_DET_NEW_INSERT:' || substr(SQLERRM,1,150);
5785:

Line 5784: o_err_msg := 'CSTPLENG.LAYER_COST_DET_NEW_INSERT:' || substr(SQLERRM,1,150);

5780: o_err_code := l_err_code;
5781: o_err_msg := 'CSTPLENG.LAYER_COST_DET_NEW_INSERT:' || l_err_msg;
5782: when OTHERS then
5783: o_err_num := SQLCODE;
5784: o_err_msg := 'CSTPLENG.LAYER_COST_DET_NEW_INSERT:' || substr(SQLERRM,1,150);
5785:
5786: end layer_cost_det_new_insert;
5787:
5788: ----------------------------------------------------------------------------

Line 6253: O_error_message := 'CSTPLENG.layer_cost_update_dist' || to_char(l_stmt_num) ||

6249:
6250: when others then
6251: rollback;
6252: O_error_num := SQLCODE;
6253: O_error_message := 'CSTPLENG.layer_cost_update_dist' || to_char(l_stmt_num) ||
6254: substr(SQLERRM,1,180);
6255:
6256: END layer_cost_update_dist;
6257:

Line 6305: END CSTPLENG;

6301: when NO_DATA_FOUND then null;
6302: End update_inv_layer_cost;
6303:
6304:
6305: END CSTPLENG;