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

Line 31: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

27:
28:
29: procedure create_requisition
30: ( p_api_version IN NUMBER := 1.0
31: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
32: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
33: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_count OUT NOCOPY NUMBER

Line 32: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

28:
29: procedure create_requisition
30: ( p_api_version IN NUMBER := 1.0
31: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
32: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
33: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_count OUT NOCOPY NUMBER
36: ,x_msg_data OUT NOCOPY VARCHAR2

Line 33: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

29: procedure create_requisition
30: ( p_api_version IN NUMBER := 1.0
31: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
32: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
33: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_count OUT NOCOPY NUMBER
36: ,x_msg_data OUT NOCOPY VARCHAR2
37: ,p_wip_entity_id IN NUMBER -- data

Line 101: IF NOT fnd_api.compatible_api_call(

97: SAVEPOINT create_requisition_pvt;
98:
99: l_stmt_num := 20;
100: -- Standard call to check for call compatibility.
101: IF NOT fnd_api.compatible_api_call(
102: l_api_version
103: ,p_api_version
104: ,l_api_name
105: ,g_pkg_name) THEN

Line 106: RAISE fnd_api.g_exc_unexpected_error;

102: l_api_version
103: ,p_api_version
104: ,l_api_name
105: ,g_pkg_name) THEN
106: RAISE fnd_api.g_exc_unexpected_error;
107: END IF;
108:
109: l_stmt_num := 30;
110: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 111: IF fnd_api.to_boolean(p_init_msg_list) THEN

107: END IF;
108:
109: l_stmt_num := 30;
110: -- Initialize message list if p_init_msg_list is set to TRUE.
111: IF fnd_api.to_boolean(p_init_msg_list) THEN
112: fnd_msg_pub.initialize;
113: END IF;
114:
115: l_stmt_num := 40;

Line 117: x_return_status := fnd_api.g_ret_sts_success;

113: END IF;
114:
115: l_stmt_num := 40;
116: -- Initialize API return status to success
117: x_return_status := fnd_api.g_ret_sts_success;
118:
119: l_stmt_num := 50;
120:
121: -- API body

Line 404: IF fnd_api.to_boolean(p_commit) THEN

400:
401:
402: -- End of API body.
403: -- Standard check of p_commit.
404: IF fnd_api.to_boolean(p_commit) THEN
405: COMMIT WORK;
406: END IF;
407:
408: l_stmt_num := 999;

Line 411: p_encoded => fnd_api.g_false

407:
408: l_stmt_num := 999;
409: -- Standard call to get message count and if count is 1, get message info.
410: fnd_msg_pub.count_and_get(
411: p_encoded => fnd_api.g_false
412: ,p_count => x_msg_count
413: ,p_data => x_msg_data);
414:
415: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

Line 424: WHEN fnd_api.g_exc_error THEN

420:
421: EXCEPTION
422:
423:
424: WHEN fnd_api.g_exc_error THEN
425: ROLLBACK TO create_requisition_pvt;
426: x_return_status := fnd_api.g_ret_sts_error;
427: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
428: fnd_msg_pub.count_and_get(

Line 426: x_return_status := fnd_api.g_ret_sts_error;

422:
423:
424: WHEN fnd_api.g_exc_error THEN
425: ROLLBACK TO create_requisition_pvt;
426: x_return_status := fnd_api.g_ret_sts_error;
427: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
428: fnd_msg_pub.count_and_get(
429: p_encoded => fnd_api.g_false
430: ,p_count => x_msg_count

Line 429: p_encoded => fnd_api.g_false

425: ROLLBACK TO create_requisition_pvt;
426: x_return_status := fnd_api.g_ret_sts_error;
427: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
428: fnd_msg_pub.count_and_get(
429: p_encoded => fnd_api.g_false
430: ,p_count => x_msg_count
431: ,p_data => x_msg_data);
432: WHEN fnd_api.g_exc_unexpected_error THEN
433: ROLLBACK TO create_requisition_pvt;

Line 432: WHEN fnd_api.g_exc_unexpected_error THEN

428: fnd_msg_pub.count_and_get(
429: p_encoded => fnd_api.g_false
430: ,p_count => x_msg_count
431: ,p_data => x_msg_data);
432: WHEN fnd_api.g_exc_unexpected_error THEN
433: ROLLBACK TO create_requisition_pvt;
434: x_return_status := fnd_api.g_ret_sts_unexp_error;
435: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
436: fnd_msg_pub.count_and_get(

Line 434: x_return_status := fnd_api.g_ret_sts_unexp_error;

430: ,p_count => x_msg_count
431: ,p_data => x_msg_data);
432: WHEN fnd_api.g_exc_unexpected_error THEN
433: ROLLBACK TO create_requisition_pvt;
434: x_return_status := fnd_api.g_ret_sts_unexp_error;
435: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
436: fnd_msg_pub.count_and_get(
437: p_encoded => fnd_api.g_false
438: ,p_count => x_msg_count

Line 437: p_encoded => fnd_api.g_false

433: ROLLBACK TO create_requisition_pvt;
434: x_return_status := fnd_api.g_ret_sts_unexp_error;
435: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
436: fnd_msg_pub.count_and_get(
437: p_encoded => fnd_api.g_false
438: ,p_count => x_msg_count
439: ,p_data => x_msg_data);
440: WHEN OTHERS THEN
441: ROLLBACK TO create_requisition_pvt;

Line 442: x_return_status := fnd_api.g_ret_sts_unexp_error;

438: ,p_count => x_msg_count
439: ,p_data => x_msg_data);
440: WHEN OTHERS THEN
441: ROLLBACK TO create_requisition_pvt;
442: x_return_status := fnd_api.g_ret_sts_unexp_error;
443: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
444: IF fnd_msg_pub.check_msg_level(
445: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
446: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 450: p_encoded => fnd_api.g_false

446: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
447: END IF;
448:
449: fnd_msg_pub.count_and_get(
450: p_encoded => fnd_api.g_false
451: ,p_count => x_msg_count
452: ,p_data => x_msg_data);
453:
454:

Line 465: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

461:
462:
463: PROCEDURE create_reqs_at_wo_rel
464: ( p_api_version IN NUMBER := 1.0
465: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
466: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
467: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
468: ,x_return_status OUT NOCOPY VARCHAR2
469: ,x_msg_count OUT NOCOPY NUMBER

Line 466: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

462:
463: PROCEDURE create_reqs_at_wo_rel
464: ( p_api_version IN NUMBER := 1.0
465: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
466: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
467: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
468: ,x_return_status OUT NOCOPY VARCHAR2
469: ,x_msg_count OUT NOCOPY NUMBER
470: ,x_msg_data OUT NOCOPY VARCHAR2

Line 467: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

463: PROCEDURE create_reqs_at_wo_rel
464: ( p_api_version IN NUMBER := 1.0
465: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
466: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
467: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
468: ,x_return_status OUT NOCOPY VARCHAR2
469: ,x_msg_count OUT NOCOPY NUMBER
470: ,x_msg_data OUT NOCOPY VARCHAR2
471: ,p_user_id IN NUMBER

Line 559: IF NOT fnd_api.compatible_api_call(

555: SAVEPOINT create_requisition_pvt;
556:
557: l_stmt_num := 20;
558: -- Standard call to check for call compatibility.
559: IF NOT fnd_api.compatible_api_call(
560: l_api_version
561: ,p_api_version
562: ,l_api_name
563: ,g_pkg_name) THEN

Line 564: RAISE fnd_api.g_exc_unexpected_error;

560: l_api_version
561: ,p_api_version
562: ,l_api_name
563: ,g_pkg_name) THEN
564: RAISE fnd_api.g_exc_unexpected_error;
565: END IF;
566:
567: l_stmt_num := 30;
568: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 569: IF fnd_api.to_boolean(p_init_msg_list) THEN

565: END IF;
566:
567: l_stmt_num := 30;
568: -- Initialize message list if p_init_msg_list is set to TRUE.
569: IF fnd_api.to_boolean(p_init_msg_list) THEN
570: fnd_msg_pub.initialize;
571: END IF;
572:
573: l_stmt_num := 40;

Line 575: x_return_status := fnd_api.g_ret_sts_success;

571: END IF;
572:
573: l_stmt_num := 40;
574: -- Initialize API return status to success
575: x_return_status := fnd_api.g_ret_sts_success;
576:
577: l_stmt_num := 50;
578:
579: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel : Start ==========================================================='); END IF;

Line 844: ,p_init_msg_list => FND_API.G_FALSE

840: END IF;
841:
842: create_requisition
843: ( p_api_version => 1.0
844: ,p_init_msg_list => FND_API.G_FALSE
845: ,p_commit => FND_API.G_FALSE
846: ,p_validate_only => FND_API.G_TRUE
847: ,x_return_status => l_api_return_status
848: ,x_msg_count => l_api_msg_count

Line 845: ,p_commit => FND_API.G_FALSE

841:
842: create_requisition
843: ( p_api_version => 1.0
844: ,p_init_msg_list => FND_API.G_FALSE
845: ,p_commit => FND_API.G_FALSE
846: ,p_validate_only => FND_API.G_TRUE
847: ,x_return_status => l_api_return_status
848: ,x_msg_count => l_api_msg_count
849: ,x_msg_data => l_api_msg_data

Line 846: ,p_validate_only => FND_API.G_TRUE

842: create_requisition
843: ( p_api_version => 1.0
844: ,p_init_msg_list => FND_API.G_FALSE
845: ,p_commit => FND_API.G_FALSE
846: ,p_validate_only => FND_API.G_TRUE
847: ,x_return_status => l_api_return_status
848: ,x_msg_count => l_api_msg_count
849: ,x_msg_data => l_api_msg_data
850: ,p_wip_entity_id => l_di_record.wip_entity_id

Line 872: x_return_status := fnd_api.g_ret_sts_error;

868:
869:
870:
871: if nvl(l_api_return_status,'Q') <> 'S' then
872: x_return_status := fnd_api.g_ret_sts_error;
873: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
874: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel : Creating reqs for the above direct item finished with status '||l_api_return_status);
875: END IF;
876:

Line 890: x_return_status := fnd_api.g_ret_sts_error;

886: EXCEPTION
887:
888: when others then
889:
890: x_return_status := fnd_api.g_ret_sts_error;
891:
892: declare
893: l_text varchar2(1000);
894: begin

Line 907: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

903:
904:
905: PROCEDURE create_reqs_at_di_upd
906: ( p_api_version IN NUMBER := 1.0
907: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
908: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
909: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
910: ,x_return_status OUT NOCOPY VARCHAR2
911: ,x_msg_count OUT NOCOPY NUMBER

Line 908: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

904:
905: PROCEDURE create_reqs_at_di_upd
906: ( p_api_version IN NUMBER := 1.0
907: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
908: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
909: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
910: ,x_return_status OUT NOCOPY VARCHAR2
911: ,x_msg_count OUT NOCOPY NUMBER
912: ,x_msg_data OUT NOCOPY VARCHAR2

Line 909: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

905: PROCEDURE create_reqs_at_di_upd
906: ( p_api_version IN NUMBER := 1.0
907: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
908: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
909: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
910: ,x_return_status OUT NOCOPY VARCHAR2
911: ,x_msg_count OUT NOCOPY NUMBER
912: ,x_msg_data OUT NOCOPY VARCHAR2
913: ,p_user_id IN NUMBER

Line 967: IF NOT fnd_api.compatible_api_call(

963: SAVEPOINT create_requisition_pvt;
964:
965: l_stmt_num := 20;
966: -- Standard call to check for call compatibility.
967: IF NOT fnd_api.compatible_api_call(
968: l_api_version
969: ,p_api_version
970: ,l_api_name
971: ,g_pkg_name) THEN

Line 972: RAISE fnd_api.g_exc_unexpected_error;

968: l_api_version
969: ,p_api_version
970: ,l_api_name
971: ,g_pkg_name) THEN
972: RAISE fnd_api.g_exc_unexpected_error;
973: END IF;
974:
975: l_stmt_num := 30;
976: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 977: IF fnd_api.to_boolean(p_init_msg_list) THEN

973: END IF;
974:
975: l_stmt_num := 30;
976: -- Initialize message list if p_init_msg_list is set to TRUE.
977: IF fnd_api.to_boolean(p_init_msg_list) THEN
978: fnd_msg_pub.initialize;
979: END IF;
980:
981: l_stmt_num := 40;

Line 983: x_return_status := fnd_api.g_ret_sts_success;

979: END IF;
980:
981: l_stmt_num := 40;
982: -- Initialize API return status to success
983: x_return_status := fnd_api.g_ret_sts_success;
984:
985: l_stmt_num := 50;
986:
987: -- API body

Line 1079: ,p_init_msg_list => FND_API.G_FALSE

1075:
1076: --Bug4188160:pass description of item instead of item name
1077: create_requisition
1078: ( p_api_version => 1.0
1079: ,p_init_msg_list => FND_API.G_FALSE
1080: ,p_commit => FND_API.G_FALSE
1081: ,p_validate_only => FND_API.G_TRUE
1082: ,x_return_status => l_api_return_status
1083: ,x_msg_count => l_api_msg_count

Line 1080: ,p_commit => FND_API.G_FALSE

1076: --Bug4188160:pass description of item instead of item name
1077: create_requisition
1078: ( p_api_version => 1.0
1079: ,p_init_msg_list => FND_API.G_FALSE
1080: ,p_commit => FND_API.G_FALSE
1081: ,p_validate_only => FND_API.G_TRUE
1082: ,x_return_status => l_api_return_status
1083: ,x_msg_count => l_api_msg_count
1084: ,x_msg_data => l_api_msg_data

Line 1081: ,p_validate_only => FND_API.G_TRUE

1077: create_requisition
1078: ( p_api_version => 1.0
1079: ,p_init_msg_list => FND_API.G_FALSE
1080: ,p_commit => FND_API.G_FALSE
1081: ,p_validate_only => FND_API.G_TRUE
1082: ,x_return_status => l_api_return_status
1083: ,x_msg_count => l_api_msg_count
1084: ,x_msg_data => l_api_msg_data
1085: ,p_wip_entity_id => l_di_record.wip_entity_id

Line 1106: x_return_status := fnd_api.g_ret_sts_error;

1102: ,p_suggested_vendor_item_num => l_di_record.suggested_vendor_item_num);
1103:
1104:
1105: if nvl(l_api_return_status,'Q') <> 'S' then
1106: x_return_status := fnd_api.g_ret_sts_error;
1107: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : create_requisition return status : '||l_api_return_status); END IF;
1108:
1109: end if;
1110:

Line 1122: x_return_status := fnd_api.g_ret_sts_error;

1118: EXCEPTION
1119:
1120: when others then
1121:
1122: x_return_status := fnd_api.g_ret_sts_error;
1123:
1124: declare
1125: l_text varchar2(1000);
1126: begin