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.16.12010000.4 2008/11/19 05:02:09 anjha 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 2857: o_err_msg := 'CSTPLENG.consume_layers (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);

2853: o_err_msg := l_err_msg;
2854: when others then
2855: rollback;
2856: o_err_num := SQLCODE;
2857: o_err_msg := 'CSTPLENG.consume_layers (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);
2858:
2859: END consume_layers;
2860:
2861: ----------------------------------------------------------------------------

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

3379: when others then
3380: rollback;
3381: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLCODE ||' ' ||to_char(l_stmt_num)||' '||substr(SQLERRM,1,200));
3382: o_err_num := SQLCODE;
3383: o_err_msg := 'CSTPLENG.get_layers_consumed (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);
3384: END get_layers_consumed;
3385:
3386: ----------------------------------------------------------------------------
3387: -- PROCEDURE --

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

3449: o_err_msg := l_err_msg;
3450: when others then
3451: rollback;
3452: o_err_num := SQLCODE;
3453: o_err_msg := 'CSTPLENG.populate_layer_table (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);
3454: END populate_layer_table;
3455:
3456: ----------------------------------------------------------------------------
3457: -- PROCEDURE --

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

3504: o_err_msg := l_err_msg;
3505: when others then
3506: rollback;
3507: o_err_num := SQLCODE;
3508: o_err_msg := 'CSTPLENG.insert_record (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);
3509: END insert_record;
3510:
3511:
3512: ---------------------------------------------------------------------------

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

4115: o_err_msg := FND_MESSAGE.Get;
4116: when others then
4117: rollback;
4118: o_err_num := SQLCODE;
4119: o_err_msg := 'CSTPLENG.apply_layer_material_ovhd (' || to_char(l_stmt_num) ||
4120: '): '
4121: || substr(SQLERRM, 1,200);
4122:
4123: END apply_layer_material_ovhd;

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

4667: o_err_msg := l_err_msg;
4668: when others then
4669: rollback;
4670: o_err_num := SQLCODE;
4671: o_err_msg := 'CSTPLENG.calc_layer_average_cost (' || to_char(l_stmt_num) ||
4672: '): '
4673: || substr(SQLERRM, 1,200);
4674:
4675: END calc_layer_average_cost;

Line 4992: CSTPLENG.calc_layer_average_cost(

4988:
4989: FND_FILE.PUT_LINE(FND_FILE.LOG, 'layer qty = ' || to_char(l_layer_qty));
4990: l_stmt_num := 70;
4991:
4992: CSTPLENG.calc_layer_average_cost(
4993: i_org_id,
4994: i_txn_id,
4995: i_layer_id,
4996: i_cost_type,

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

5047:
5048: when others then
5049: rollback;
5050: o_err_num := SQLCODE;
5051: o_err_msg := 'CSTPLENG.layer_cost_update (' || to_char(l_stmt_num) ||
5052: '): '
5053: || substr(SQLERRM, 1,200);
5054: END layer_cost_update;
5055:

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

5224: EXCEPTION
5225:
5226: when others then
5227: o_err_num := SQLCODE;
5228: o_err_msg := 'CSTPLENG.get_current_layer:' || substrb(SQLERRM,1,150);
5229: return 0;
5230:
5231: END get_current_layer;
5232:

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

5291: * In this case, call cstpacit.cost_det_new_insert.
5292: */
5293:
5294: if (l_num_detail = 0) then
5295: cstpleng.layer_cost_det_new_insert(i_txn_id, i_txn_action_id, i_org_id,
5296: i_item_id, i_cost_group_id, i_inv_layer_id, i_txn_cost,
5297: i_new_avg_cost, i_per_change, i_val_change,
5298: i_mat_accnt, i_mat_ovhd_accnt, i_res_accnt,
5299: i_osp_accnt, i_ovhd_accnt,

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

5433: EXCEPTION
5434: when cost_det_move_error then
5435: o_err_num := l_err_num;
5436: o_err_code := l_err_code;
5437: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE:' || l_err_msg;
5438: when cost_no_layer_error then
5439: o_err_num := l_err_num;
5440: o_err_code := l_err_code;
5441: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE: No layer exists' || l_err_msg;

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

5437: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE:' || l_err_msg;
5438: when cost_no_layer_error then
5439: o_err_num := l_err_num;
5440: o_err_code := l_err_code;
5441: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE: No layer exists' || l_err_msg;
5442: when OTHERS then
5443: o_err_num := SQLCODE;
5444: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE:' || substr(SQLERRM,1,150);
5445:

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

5440: o_err_code := l_err_code;
5441: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE: No layer exists' || l_err_msg;
5442: when OTHERS then
5443: o_err_num := SQLCODE;
5444: o_err_msg := 'CSTPLENG.LAYER_COST_DET_MOVE:' || substr(SQLERRM,1,150);
5445:
5446: end layer_cost_det_move;
5447:
5448: --------------------------------------------------------------------------

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

5673: EXCEPTION
5674: when cost_det_new_insert_error then
5675: o_err_num := l_err_num;
5676: o_err_code := l_err_code;
5677: o_err_msg := 'CSTPLENG.LAYER_COST_DET_NEW_INSERT:' || l_err_msg;
5678: when OTHERS then
5679: o_err_num := SQLCODE;
5680: o_err_msg := 'CSTPLENG.LAYER_COST_DET_NEW_INSERT:' || substr(SQLERRM,1,150);
5681:

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

5676: o_err_code := l_err_code;
5677: o_err_msg := 'CSTPLENG.LAYER_COST_DET_NEW_INSERT:' || l_err_msg;
5678: when OTHERS then
5679: o_err_num := SQLCODE;
5680: o_err_msg := 'CSTPLENG.LAYER_COST_DET_NEW_INSERT:' || substr(SQLERRM,1,150);
5681:
5682: end layer_cost_det_new_insert;
5683:
5684: ----------------------------------------------------------------------------

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

6137:
6138: when others then
6139: rollback;
6140: O_error_num := SQLCODE;
6141: O_error_message := 'CSTPLENG.layer_cost_update_dist' || to_char(l_stmt_num) ||
6142: substr(SQLERRM,1,180);
6143:
6144: END layer_cost_update_dist;
6145:

Line 6193: END CSTPLENG;

6189: when NO_DATA_FOUND then null;
6190: End update_inv_layer_cost;
6191:
6192:
6193: END CSTPLENG;