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.CSTPCGUT dependencies on FND_API

Line 27: p_material_account IN NUMBER default FND_API.G_MISS_NUM,

23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2,
25: x_cost_group_id_tbl OUT NOCOPY CSTPCGUT.cost_group_tbl,
26: x_count OUT NOCOPY NUMBER,
27: p_material_account IN NUMBER default FND_API.G_MISS_NUM,
28: p_material_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
29: p_resource_account IN NUMBER default FND_API.G_MISS_NUM,
30: p_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
31: p_outside_processing_account IN NUMBER default FND_API.G_MISS_NUM,

Line 28: p_material_overhead_account IN NUMBER default FND_API.G_MISS_NUM,

24: x_msg_data OUT NOCOPY VARCHAR2,
25: x_cost_group_id_tbl OUT NOCOPY CSTPCGUT.cost_group_tbl,
26: x_count OUT NOCOPY NUMBER,
27: p_material_account IN NUMBER default FND_API.G_MISS_NUM,
28: p_material_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
29: p_resource_account IN NUMBER default FND_API.G_MISS_NUM,
30: p_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
31: p_outside_processing_account IN NUMBER default FND_API.G_MISS_NUM,
32: p_expense_account IN NUMBER default FND_API.G_MISS_NUM,

Line 29: p_resource_account IN NUMBER default FND_API.G_MISS_NUM,

25: x_cost_group_id_tbl OUT NOCOPY CSTPCGUT.cost_group_tbl,
26: x_count OUT NOCOPY NUMBER,
27: p_material_account IN NUMBER default FND_API.G_MISS_NUM,
28: p_material_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
29: p_resource_account IN NUMBER default FND_API.G_MISS_NUM,
30: p_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
31: p_outside_processing_account IN NUMBER default FND_API.G_MISS_NUM,
32: p_expense_account IN NUMBER default FND_API.G_MISS_NUM,
33: p_encumbrance_account IN NUMBER default FND_API.G_MISS_NUM,

Line 30: p_overhead_account IN NUMBER default FND_API.G_MISS_NUM,

26: x_count OUT NOCOPY NUMBER,
27: p_material_account IN NUMBER default FND_API.G_MISS_NUM,
28: p_material_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
29: p_resource_account IN NUMBER default FND_API.G_MISS_NUM,
30: p_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
31: p_outside_processing_account IN NUMBER default FND_API.G_MISS_NUM,
32: p_expense_account IN NUMBER default FND_API.G_MISS_NUM,
33: p_encumbrance_account IN NUMBER default FND_API.G_MISS_NUM,
34: p_average_cost_var_account IN NUMBER default FND_API.G_MISS_NUM,

Line 31: p_outside_processing_account IN NUMBER default FND_API.G_MISS_NUM,

27: p_material_account IN NUMBER default FND_API.G_MISS_NUM,
28: p_material_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
29: p_resource_account IN NUMBER default FND_API.G_MISS_NUM,
30: p_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
31: p_outside_processing_account IN NUMBER default FND_API.G_MISS_NUM,
32: p_expense_account IN NUMBER default FND_API.G_MISS_NUM,
33: p_encumbrance_account IN NUMBER default FND_API.G_MISS_NUM,
34: p_average_cost_var_account IN NUMBER default FND_API.G_MISS_NUM,
35: p_payback_mat_var_account IN NUMBER default FND_API.G_MISS_NUM,

Line 32: p_expense_account IN NUMBER default FND_API.G_MISS_NUM,

28: p_material_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
29: p_resource_account IN NUMBER default FND_API.G_MISS_NUM,
30: p_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
31: p_outside_processing_account IN NUMBER default FND_API.G_MISS_NUM,
32: p_expense_account IN NUMBER default FND_API.G_MISS_NUM,
33: p_encumbrance_account IN NUMBER default FND_API.G_MISS_NUM,
34: p_average_cost_var_account IN NUMBER default FND_API.G_MISS_NUM,
35: p_payback_mat_var_account IN NUMBER default FND_API.G_MISS_NUM,
36: p_payback_res_var_account IN NUMBER default FND_API.G_MISS_NUM,

Line 33: p_encumbrance_account IN NUMBER default FND_API.G_MISS_NUM,

29: p_resource_account IN NUMBER default FND_API.G_MISS_NUM,
30: p_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
31: p_outside_processing_account IN NUMBER default FND_API.G_MISS_NUM,
32: p_expense_account IN NUMBER default FND_API.G_MISS_NUM,
33: p_encumbrance_account IN NUMBER default FND_API.G_MISS_NUM,
34: p_average_cost_var_account IN NUMBER default FND_API.G_MISS_NUM,
35: p_payback_mat_var_account IN NUMBER default FND_API.G_MISS_NUM,
36: p_payback_res_var_account IN NUMBER default FND_API.G_MISS_NUM,
37: p_payback_osp_var_account IN NUMBER default FND_API.G_MISS_NUM,

Line 34: p_average_cost_var_account IN NUMBER default FND_API.G_MISS_NUM,

30: p_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
31: p_outside_processing_account IN NUMBER default FND_API.G_MISS_NUM,
32: p_expense_account IN NUMBER default FND_API.G_MISS_NUM,
33: p_encumbrance_account IN NUMBER default FND_API.G_MISS_NUM,
34: p_average_cost_var_account IN NUMBER default FND_API.G_MISS_NUM,
35: p_payback_mat_var_account IN NUMBER default FND_API.G_MISS_NUM,
36: p_payback_res_var_account IN NUMBER default FND_API.G_MISS_NUM,
37: p_payback_osp_var_account IN NUMBER default FND_API.G_MISS_NUM,
38: p_payback_moh_var_account IN NUMBER default FND_API.G_MISS_NUM,

Line 35: p_payback_mat_var_account IN NUMBER default FND_API.G_MISS_NUM,

31: p_outside_processing_account IN NUMBER default FND_API.G_MISS_NUM,
32: p_expense_account IN NUMBER default FND_API.G_MISS_NUM,
33: p_encumbrance_account IN NUMBER default FND_API.G_MISS_NUM,
34: p_average_cost_var_account IN NUMBER default FND_API.G_MISS_NUM,
35: p_payback_mat_var_account IN NUMBER default FND_API.G_MISS_NUM,
36: p_payback_res_var_account IN NUMBER default FND_API.G_MISS_NUM,
37: p_payback_osp_var_account IN NUMBER default FND_API.G_MISS_NUM,
38: p_payback_moh_var_account IN NUMBER default FND_API.G_MISS_NUM,
39: p_payback_ovh_var_account IN NUMBER default FND_API.G_MISS_NUM,

Line 36: p_payback_res_var_account IN NUMBER default FND_API.G_MISS_NUM,

32: p_expense_account IN NUMBER default FND_API.G_MISS_NUM,
33: p_encumbrance_account IN NUMBER default FND_API.G_MISS_NUM,
34: p_average_cost_var_account IN NUMBER default FND_API.G_MISS_NUM,
35: p_payback_mat_var_account IN NUMBER default FND_API.G_MISS_NUM,
36: p_payback_res_var_account IN NUMBER default FND_API.G_MISS_NUM,
37: p_payback_osp_var_account IN NUMBER default FND_API.G_MISS_NUM,
38: p_payback_moh_var_account IN NUMBER default FND_API.G_MISS_NUM,
39: p_payback_ovh_var_account IN NUMBER default FND_API.G_MISS_NUM,
40: p_organization_id IN NUMBER ,

Line 37: p_payback_osp_var_account IN NUMBER default FND_API.G_MISS_NUM,

33: p_encumbrance_account IN NUMBER default FND_API.G_MISS_NUM,
34: p_average_cost_var_account IN NUMBER default FND_API.G_MISS_NUM,
35: p_payback_mat_var_account IN NUMBER default FND_API.G_MISS_NUM,
36: p_payback_res_var_account IN NUMBER default FND_API.G_MISS_NUM,
37: p_payback_osp_var_account IN NUMBER default FND_API.G_MISS_NUM,
38: p_payback_moh_var_account IN NUMBER default FND_API.G_MISS_NUM,
39: p_payback_ovh_var_account IN NUMBER default FND_API.G_MISS_NUM,
40: p_organization_id IN NUMBER ,
41: p_cost_group_type_id IN NUMBER) IS

Line 38: p_payback_moh_var_account IN NUMBER default FND_API.G_MISS_NUM,

34: p_average_cost_var_account IN NUMBER default FND_API.G_MISS_NUM,
35: p_payback_mat_var_account IN NUMBER default FND_API.G_MISS_NUM,
36: p_payback_res_var_account IN NUMBER default FND_API.G_MISS_NUM,
37: p_payback_osp_var_account IN NUMBER default FND_API.G_MISS_NUM,
38: p_payback_moh_var_account IN NUMBER default FND_API.G_MISS_NUM,
39: p_payback_ovh_var_account IN NUMBER default FND_API.G_MISS_NUM,
40: p_organization_id IN NUMBER ,
41: p_cost_group_type_id IN NUMBER) IS
42:

Line 39: p_payback_ovh_var_account IN NUMBER default FND_API.G_MISS_NUM,

35: p_payback_mat_var_account IN NUMBER default FND_API.G_MISS_NUM,
36: p_payback_res_var_account IN NUMBER default FND_API.G_MISS_NUM,
37: p_payback_osp_var_account IN NUMBER default FND_API.G_MISS_NUM,
38: p_payback_moh_var_account IN NUMBER default FND_API.G_MISS_NUM,
39: p_payback_ovh_var_account IN NUMBER default FND_API.G_MISS_NUM,
40: p_organization_id IN NUMBER ,
41: p_cost_group_type_id IN NUMBER) IS
42:
43: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 43: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

39: p_payback_ovh_var_account IN NUMBER default FND_API.G_MISS_NUM,
40: p_organization_id IN NUMBER ,
41: p_cost_group_type_id IN NUMBER) IS
42:
43: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
44: l_counter INTEGER := 0;
45: l_statement NUMBER;
46: l_miss_num NUMBER := FND_API.G_MISS_NUM;
47:

Line 46: l_miss_num NUMBER := FND_API.G_MISS_NUM;

42:
43: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
44: l_counter INTEGER := 0;
45: l_statement NUMBER;
46: l_miss_num NUMBER := FND_API.G_MISS_NUM;
47:
48:
49: CURSOR c_cost_group is SELECT ccg.cost_group_id
50: FROM cst_cost_groups ccg,

Line 119: RAISE fnd_api.g_exc_error;

115: BEGIN
116:
117: IF p_organization_id IS NULL THEN
118:
119: RAISE fnd_api.g_exc_error;
120: END IF;
121:
122: FOR rec_cost_group IN c_cost_group LOOP
123:

Line 134: WHEN fnd_api.g_exc_error THEN

130: x_count := l_counter;
131: x_return_status := l_return_status;
132:
133: EXCEPTION
134: WHEN fnd_api.g_exc_error THEN
135: x_return_status := fnd_api.g_ret_sts_error;
136:
137: -- Get message count and data
138: fnd_msg_pub.count_and_get

Line 135: x_return_status := fnd_api.g_ret_sts_error;

131: x_return_status := l_return_status;
132:
133: EXCEPTION
134: WHEN fnd_api.g_exc_error THEN
135: x_return_status := fnd_api.g_ret_sts_error;
136:
137: -- Get message count and data
138: fnd_msg_pub.count_and_get
139: ( p_count => x_msg_count

Line 143: WHEN fnd_api.g_exc_unexpected_error THEN

139: ( p_count => x_msg_count
140: , p_data => x_msg_data
141: );
142: --
143: WHEN fnd_api.g_exc_unexpected_error THEN
144: x_return_status := fnd_api.g_ret_sts_unexp_error ;
145:
146: -- Get message count and data
147: fnd_msg_pub.count_and_get

Line 144: x_return_status := fnd_api.g_ret_sts_unexp_error ;

140: , p_data => x_msg_data
141: );
142: --
143: WHEN fnd_api.g_exc_unexpected_error THEN
144: x_return_status := fnd_api.g_ret_sts_unexp_error ;
145:
146: -- Get message count and data
147: fnd_msg_pub.count_and_get
148: ( p_count => x_msg_count

Line 153: x_return_status := fnd_api.g_ret_sts_unexp_error ;

149: , p_data => x_msg_data
150: );
151: --
152: WHEN OTHERS THEN
153: x_return_status := fnd_api.g_ret_sts_unexp_error ;
154: --
155: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
156: THEN
157: fnd_msg_pub.add_exc_msg

Line 216: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

212: l_request_id NUMBER := fnd_global.conc_request_id;
213: l_program_application_id NUMBER := fnd_global.prog_appl_id;
214: l_program_id NUMBER := fnd_global.conc_program_id;
215: l_sysdate DATE := SYSDATE;
216: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
217: l_cost_group_id NUMBER;
218: l_statement NUMBER;
219: l_count NUMBER;
220: l_cost_group VARCHAR2(15);

Line 234: RAISE fnd_api.g_exc_error;

230: FROM CST_COST_GROUPS
231: WHERE COST_GROUP = p_cost_group;
232:
233: IF l_count <> 0 THEN
234: RAISE fnd_api.g_exc_error;
235: END IF;
236: END IF;
237:
238: IF p_organization_id IS NULL THEN

Line 240: RAISE fnd_api.g_exc_error;

236: END IF;
237:
238: IF p_organization_id IS NULL THEN
239:
240: RAISE fnd_api.g_exc_error;
241: END IF;
242:
243: l_statement := 20;
244:

Line 340: WHEN fnd_api.g_exc_error THEN

336: x_cost_group_id := l_cost_group_id;
337: x_return_status := l_return_status;
338:
339: EXCEPTION
340: WHEN fnd_api.g_exc_error THEN
341: x_return_status := fnd_api.g_ret_sts_error;
342:
343: fnd_msg_pub.count_and_get
344: ( p_count => x_msg_count

Line 341: x_return_status := fnd_api.g_ret_sts_error;

337: x_return_status := l_return_status;
338:
339: EXCEPTION
340: WHEN fnd_api.g_exc_error THEN
341: x_return_status := fnd_api.g_ret_sts_error;
342:
343: fnd_msg_pub.count_and_get
344: ( p_count => x_msg_count
345: , p_data => x_msg_data

Line 350: WHEN fnd_api.g_exc_unexpected_error THEN

346: );
347:
348: ROLLBACK WORK TO SAVEPOINT create_CG;
349: --
350: WHEN fnd_api.g_exc_unexpected_error THEN
351: x_return_status := fnd_api.g_ret_sts_unexp_error ;
352:
353: fnd_msg_pub.count_and_get
354: ( p_count => x_msg_count

Line 351: x_return_status := fnd_api.g_ret_sts_unexp_error ;

347:
348: ROLLBACK WORK TO SAVEPOINT create_CG;
349: --
350: WHEN fnd_api.g_exc_unexpected_error THEN
351: x_return_status := fnd_api.g_ret_sts_unexp_error ;
352:
353: fnd_msg_pub.count_and_get
354: ( p_count => x_msg_count
355: , p_data => x_msg_data

Line 361: x_return_status := fnd_api.g_ret_sts_unexp_error ;

357:
358: ROLLBACK WORK TO SAVEPOINT create_CG;
359: --
360: WHEN OTHERS THEN
361: x_return_status := fnd_api.g_ret_sts_unexp_error ;
362: --
363: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
364: THEN
365: fnd_msg_pub.add_exc_msg

Line 420: RAISE fnd_api.g_exc_error;

416:
417: IF p_organization_id IS NULL OR
418: p_cost_group_id IS NULL THEN
419:
420: RAISE fnd_api.g_exc_error;
421: END IF;
422:
423:
424: l_statement := 10;

Line 457: x_return_status := fnd_api.g_ret_sts_success;

453: FROM CST_COST_GROUP_ACCOUNTS
454: WHERE COST_GROUP_ID = p_cost_group_id
455: AND ORGANIZATION_ID = p_organization_id ;
456:
457: x_return_status := fnd_api.g_ret_sts_success;
458:
459: EXCEPTION
460: WHEN fnd_api.g_exc_error THEN
461: x_return_status := fnd_api.g_ret_sts_error;

Line 460: WHEN fnd_api.g_exc_error THEN

456:
457: x_return_status := fnd_api.g_ret_sts_success;
458:
459: EXCEPTION
460: WHEN fnd_api.g_exc_error THEN
461: x_return_status := fnd_api.g_ret_sts_error;
462:
463: fnd_msg_pub.count_and_get
464: ( p_count => x_msg_count

Line 461: x_return_status := fnd_api.g_ret_sts_error;

457: x_return_status := fnd_api.g_ret_sts_success;
458:
459: EXCEPTION
460: WHEN fnd_api.g_exc_error THEN
461: x_return_status := fnd_api.g_ret_sts_error;
462:
463: fnd_msg_pub.count_and_get
464: ( p_count => x_msg_count
465: , p_data => x_msg_data

Line 468: WHEN fnd_api.g_exc_unexpected_error THEN

464: ( p_count => x_msg_count
465: , p_data => x_msg_data
466: );
467: --
468: WHEN fnd_api.g_exc_unexpected_error THEN
469: x_return_status := fnd_api.g_ret_sts_unexp_error ;
470:
471: fnd_msg_pub.count_and_get
472: ( p_count => x_msg_count

Line 469: x_return_status := fnd_api.g_ret_sts_unexp_error ;

465: , p_data => x_msg_data
466: );
467: --
468: WHEN fnd_api.g_exc_unexpected_error THEN
469: x_return_status := fnd_api.g_ret_sts_unexp_error ;
470:
471: fnd_msg_pub.count_and_get
472: ( p_count => x_msg_count
473: , p_data => x_msg_data

Line 477: x_return_status := fnd_api.g_ret_sts_unexp_error ;

473: , p_data => x_msg_data
474: );
475: --
476: WHEN OTHERS THEN
477: x_return_status := fnd_api.g_ret_sts_unexp_error ;
478: --
479: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
480: THEN
481: fnd_msg_pub.add_exc_msg

Line 533: x_return_status := fnd_api.g_ret_sts_success;

529: AND cost_group_id = p_cost_group_id
530: AND rownum = 1;
531:
532: IF x_change_allowed = 1 THEN
533: x_return_status := fnd_api.g_ret_sts_success;
534: RETURN;
535: END IF;
536:
537: l_statement := 20;

Line 554: x_return_status := fnd_api.g_ret_sts_success;

550: AND layer_quantity <> 0
551: AND rownum = 1;
552:
553: IF x_change_allowed = 1 THEN
554: x_return_status := fnd_api.g_ret_sts_success;
555: RETURN;
556: END IF;
557: END IF;
558:

Line 576: x_return_status := fnd_api.g_ret_sts_success;

572: )
573: AND rownum = 1;
574:
575: IF x_change_allowed = 1 THEN
576: x_return_status := fnd_api.g_ret_sts_success;
577: RETURN;
578: END IF;
579:
580: l_statement := 40;

Line 598: x_return_status := fnd_api.g_ret_sts_success;

594: )
595: AND rownum = 1;
596:
597: IF x_change_allowed = 1 THEN
598: x_return_status := fnd_api.g_ret_sts_success;
599: RETURN;
600: END IF;
601:
602: x_return_status := fnd_api.g_ret_sts_success;

Line 602: x_return_status := fnd_api.g_ret_sts_success;

598: x_return_status := fnd_api.g_ret_sts_success;
599: RETURN;
600: END IF;
601:
602: x_return_status := fnd_api.g_ret_sts_success;
603:
604: EXCEPTION
605: WHEN fnd_api.g_exc_error THEN
606: x_return_status := fnd_api.g_ret_sts_error;

Line 605: WHEN fnd_api.g_exc_error THEN

601:
602: x_return_status := fnd_api.g_ret_sts_success;
603:
604: EXCEPTION
605: WHEN fnd_api.g_exc_error THEN
606: x_return_status := fnd_api.g_ret_sts_error;
607:
608: fnd_msg_pub.count_and_get
609: ( p_count => x_msg_count

Line 606: x_return_status := fnd_api.g_ret_sts_error;

602: x_return_status := fnd_api.g_ret_sts_success;
603:
604: EXCEPTION
605: WHEN fnd_api.g_exc_error THEN
606: x_return_status := fnd_api.g_ret_sts_error;
607:
608: fnd_msg_pub.count_and_get
609: ( p_count => x_msg_count
610: , p_data => x_msg_data

Line 613: WHEN fnd_api.g_exc_unexpected_error THEN

609: ( p_count => x_msg_count
610: , p_data => x_msg_data
611: );
612:
613: WHEN fnd_api.g_exc_unexpected_error THEN
614: x_return_status := fnd_api.g_ret_sts_unexp_error ;
615:
616: fnd_msg_pub.count_and_get
617: ( p_count => x_msg_count

Line 614: x_return_status := fnd_api.g_ret_sts_unexp_error ;

610: , p_data => x_msg_data
611: );
612:
613: WHEN fnd_api.g_exc_unexpected_error THEN
614: x_return_status := fnd_api.g_ret_sts_unexp_error ;
615:
616: fnd_msg_pub.count_and_get
617: ( p_count => x_msg_count
618: , p_data => x_msg_data

Line 622: x_return_status := fnd_api.g_ret_sts_unexp_error ;

618: , p_data => x_msg_data
619: );
620:
621: WHEN OTHERS THEN
622: x_return_status := fnd_api.g_ret_sts_unexp_error ;
623:
624: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
625: THEN
626: fnd_msg_pub.add_exc_msg