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 91: IF NOT fnd_api.compatible_api_call(

87: SAVEPOINT create_requisition_pvt;
88:
89: l_stmt_num := 20;
90: -- Standard call to check for call compatibility.
91: IF NOT fnd_api.compatible_api_call(
92: l_api_version
93: ,p_api_version
94: ,l_api_name
95: ,g_pkg_name) THEN

Line 96: RAISE fnd_api.g_exc_unexpected_error;

92: l_api_version
93: ,p_api_version
94: ,l_api_name
95: ,g_pkg_name) THEN
96: RAISE fnd_api.g_exc_unexpected_error;
97: END IF;
98:
99: l_stmt_num := 30;
100: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 101: IF fnd_api.to_boolean(p_init_msg_list) THEN

97: END IF;
98:
99: l_stmt_num := 30;
100: -- Initialize message list if p_init_msg_list is set to TRUE.
101: IF fnd_api.to_boolean(p_init_msg_list) THEN
102: fnd_msg_pub.initialize;
103: END IF;
104:
105: l_stmt_num := 40;

Line 107: x_return_status := fnd_api.g_ret_sts_success;

103: END IF;
104:
105: l_stmt_num := 40;
106: -- Initialize API return status to success
107: x_return_status := fnd_api.g_ret_sts_success;
108:
109: l_stmt_num := 50;
110:
111: -- API body

Line 311: IF fnd_api.to_boolean(p_commit) THEN

307:
308:
309: -- End of API body.
310: -- Standard check of p_commit.
311: IF fnd_api.to_boolean(p_commit) THEN
312: COMMIT WORK;
313: END IF;
314:
315: l_stmt_num := 999;

Line 318: p_encoded => fnd_api.g_false

314:
315: l_stmt_num := 999;
316: -- Standard call to get message count and if count is 1, get message info.
317: fnd_msg_pub.count_and_get(
318: p_encoded => fnd_api.g_false
319: ,p_count => x_msg_count
320: ,p_data => x_msg_data);
321: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside create_requisitions. concurrent program finished ...'); END IF;
322:

Line 329: WHEN fnd_api.g_exc_error THEN

325:
326: EXCEPTION
327:
328:
329: WHEN fnd_api.g_exc_error THEN
330: ROLLBACK TO create_requisition_pvt;
331: x_return_status := fnd_api.g_ret_sts_error;
332: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
333: fnd_msg_pub.count_and_get(

Line 331: x_return_status := fnd_api.g_ret_sts_error;

327:
328:
329: WHEN fnd_api.g_exc_error THEN
330: ROLLBACK TO create_requisition_pvt;
331: x_return_status := fnd_api.g_ret_sts_error;
332: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
333: fnd_msg_pub.count_and_get(
334: p_encoded => fnd_api.g_false
335: ,p_count => x_msg_count

Line 334: p_encoded => fnd_api.g_false

330: ROLLBACK TO create_requisition_pvt;
331: x_return_status := fnd_api.g_ret_sts_error;
332: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
333: fnd_msg_pub.count_and_get(
334: p_encoded => fnd_api.g_false
335: ,p_count => x_msg_count
336: ,p_data => x_msg_data);
337: WHEN fnd_api.g_exc_unexpected_error THEN
338: ROLLBACK TO create_requisition_pvt;

Line 337: WHEN fnd_api.g_exc_unexpected_error THEN

333: fnd_msg_pub.count_and_get(
334: p_encoded => fnd_api.g_false
335: ,p_count => x_msg_count
336: ,p_data => x_msg_data);
337: WHEN fnd_api.g_exc_unexpected_error THEN
338: ROLLBACK TO create_requisition_pvt;
339: x_return_status := fnd_api.g_ret_sts_unexp_error;
340: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
341: fnd_msg_pub.count_and_get(

Line 339: x_return_status := fnd_api.g_ret_sts_unexp_error;

335: ,p_count => x_msg_count
336: ,p_data => x_msg_data);
337: WHEN fnd_api.g_exc_unexpected_error THEN
338: ROLLBACK TO create_requisition_pvt;
339: x_return_status := fnd_api.g_ret_sts_unexp_error;
340: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
341: fnd_msg_pub.count_and_get(
342: p_encoded => fnd_api.g_false
343: ,p_count => x_msg_count

Line 342: p_encoded => fnd_api.g_false

338: ROLLBACK TO create_requisition_pvt;
339: x_return_status := fnd_api.g_ret_sts_unexp_error;
340: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
341: fnd_msg_pub.count_and_get(
342: p_encoded => fnd_api.g_false
343: ,p_count => x_msg_count
344: ,p_data => x_msg_data);
345: WHEN OTHERS THEN
346: ROLLBACK TO create_requisition_pvt;

Line 347: x_return_status := fnd_api.g_ret_sts_unexp_error;

343: ,p_count => x_msg_count
344: ,p_data => x_msg_data);
345: WHEN OTHERS THEN
346: ROLLBACK TO create_requisition_pvt;
347: x_return_status := fnd_api.g_ret_sts_unexp_error;
348: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
349: IF fnd_msg_pub.check_msg_level(
350: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
351: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 355: p_encoded => fnd_api.g_false

351: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
352: END IF;
353:
354: fnd_msg_pub.count_and_get(
355: p_encoded => fnd_api.g_false
356: ,p_count => x_msg_count
357: ,p_data => x_msg_data);
358:
359:

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

366:
367:
368: PROCEDURE create_reqs_at_wo_rel
369: ( p_api_version IN NUMBER := 1.0
370: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
371: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
372: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
373: ,x_return_status OUT NOCOPY VARCHAR2
374: ,x_msg_count OUT NOCOPY NUMBER

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

367:
368: PROCEDURE create_reqs_at_wo_rel
369: ( p_api_version IN NUMBER := 1.0
370: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
371: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
372: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
373: ,x_return_status OUT NOCOPY VARCHAR2
374: ,x_msg_count OUT NOCOPY NUMBER
375: ,x_msg_data OUT NOCOPY VARCHAR2

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

368: PROCEDURE create_reqs_at_wo_rel
369: ( p_api_version IN NUMBER := 1.0
370: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
371: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
372: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
373: ,x_return_status OUT NOCOPY VARCHAR2
374: ,x_msg_count OUT NOCOPY NUMBER
375: ,x_msg_data OUT NOCOPY VARCHAR2
376: ,p_user_id IN NUMBER

Line 463: IF NOT fnd_api.compatible_api_call(

459: SAVEPOINT create_requisition_pvt;
460:
461: l_stmt_num := 20;
462: -- Standard call to check for call compatibility.
463: IF NOT fnd_api.compatible_api_call(
464: l_api_version
465: ,p_api_version
466: ,l_api_name
467: ,g_pkg_name) THEN

Line 468: RAISE fnd_api.g_exc_unexpected_error;

464: l_api_version
465: ,p_api_version
466: ,l_api_name
467: ,g_pkg_name) THEN
468: RAISE fnd_api.g_exc_unexpected_error;
469: END IF;
470:
471: l_stmt_num := 30;
472: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 473: IF fnd_api.to_boolean(p_init_msg_list) THEN

469: END IF;
470:
471: l_stmt_num := 30;
472: -- Initialize message list if p_init_msg_list is set to TRUE.
473: IF fnd_api.to_boolean(p_init_msg_list) THEN
474: fnd_msg_pub.initialize;
475: END IF;
476:
477: l_stmt_num := 40;

Line 479: x_return_status := fnd_api.g_ret_sts_success;

475: END IF;
476:
477: l_stmt_num := 40;
478: -- Initialize API return status to success
479: x_return_status := fnd_api.g_ret_sts_success;
480:
481: l_stmt_num := 50;
482:
483: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Start of create_reqs_at_wo_rel'); END IF;

Line 564: ,p_init_msg_list => FND_API.G_FALSE

560:
561:
562: create_requisition
563: ( p_api_version => 1.0
564: ,p_init_msg_list => FND_API.G_FALSE
565: ,p_commit => FND_API.G_FALSE
566: ,p_validate_only => FND_API.G_TRUE
567: ,x_return_status => l_api_return_status
568: ,x_msg_count => l_api_msg_count

Line 565: ,p_commit => FND_API.G_FALSE

561:
562: create_requisition
563: ( p_api_version => 1.0
564: ,p_init_msg_list => FND_API.G_FALSE
565: ,p_commit => FND_API.G_FALSE
566: ,p_validate_only => FND_API.G_TRUE
567: ,x_return_status => l_api_return_status
568: ,x_msg_count => l_api_msg_count
569: ,x_msg_data => l_api_msg_data

Line 566: ,p_validate_only => FND_API.G_TRUE

562: create_requisition
563: ( p_api_version => 1.0
564: ,p_init_msg_list => FND_API.G_FALSE
565: ,p_commit => FND_API.G_FALSE
566: ,p_validate_only => FND_API.G_TRUE
567: ,x_return_status => l_api_return_status
568: ,x_msg_count => l_api_msg_count
569: ,x_msg_data => l_api_msg_data
570: ,p_wip_entity_id => l_di_record.wip_entity_id

Line 593: x_return_status := fnd_api.g_ret_sts_error;

589:
590: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('creating reqs for di seq finished with status '||l_api_return_status); END IF;
591:
592: if nvl(l_api_return_status,'Q') <> 'S' then
593: x_return_status := fnd_api.g_ret_sts_error;
594: end if;
595:
596: end if;
597:

Line 607: x_return_status := fnd_api.g_ret_sts_error;

603: EXCEPTION
604:
605: when others then
606:
607: x_return_status := fnd_api.g_ret_sts_error;
608:
609: declare
610: l_text varchar2(1000);
611: begin

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

618:
619:
620: PROCEDURE create_reqs_at_di_upd
621: ( p_api_version IN NUMBER := 1.0
622: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
623: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
624: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
625: ,x_return_status OUT NOCOPY VARCHAR2
626: ,x_msg_count OUT NOCOPY NUMBER

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

619:
620: PROCEDURE create_reqs_at_di_upd
621: ( p_api_version IN NUMBER := 1.0
622: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
623: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
624: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
625: ,x_return_status OUT NOCOPY VARCHAR2
626: ,x_msg_count OUT NOCOPY NUMBER
627: ,x_msg_data OUT NOCOPY VARCHAR2

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

620: PROCEDURE create_reqs_at_di_upd
621: ( p_api_version IN NUMBER := 1.0
622: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
623: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
624: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
625: ,x_return_status OUT NOCOPY VARCHAR2
626: ,x_msg_count OUT NOCOPY NUMBER
627: ,x_msg_data OUT NOCOPY VARCHAR2
628: ,p_user_id IN NUMBER

Line 682: IF NOT fnd_api.compatible_api_call(

678: SAVEPOINT create_requisition_pvt;
679:
680: l_stmt_num := 20;
681: -- Standard call to check for call compatibility.
682: IF NOT fnd_api.compatible_api_call(
683: l_api_version
684: ,p_api_version
685: ,l_api_name
686: ,g_pkg_name) THEN

Line 687: RAISE fnd_api.g_exc_unexpected_error;

683: l_api_version
684: ,p_api_version
685: ,l_api_name
686: ,g_pkg_name) THEN
687: RAISE fnd_api.g_exc_unexpected_error;
688: END IF;
689:
690: l_stmt_num := 30;
691: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 692: IF fnd_api.to_boolean(p_init_msg_list) THEN

688: END IF;
689:
690: l_stmt_num := 30;
691: -- Initialize message list if p_init_msg_list is set to TRUE.
692: IF fnd_api.to_boolean(p_init_msg_list) THEN
693: fnd_msg_pub.initialize;
694: END IF;
695:
696: l_stmt_num := 40;

Line 698: x_return_status := fnd_api.g_ret_sts_success;

694: END IF;
695:
696: l_stmt_num := 40;
697: -- Initialize API return status to success
698: x_return_status := fnd_api.g_ret_sts_success;
699:
700: l_stmt_num := 50;
701:
702: -- API body

Line 778: ,p_init_msg_list => FND_API.G_FALSE

774: and l_di_record.auto_request_material = 'Y' then
775: --Bug4188160:pass description of item instead of item name
776: create_requisition
777: ( p_api_version => 1.0
778: ,p_init_msg_list => FND_API.G_FALSE
779: ,p_commit => FND_API.G_FALSE
780: ,p_validate_only => FND_API.G_TRUE
781: ,x_return_status => l_api_return_status
782: ,x_msg_count => l_api_msg_count

Line 779: ,p_commit => FND_API.G_FALSE

775: --Bug4188160:pass description of item instead of item name
776: create_requisition
777: ( p_api_version => 1.0
778: ,p_init_msg_list => FND_API.G_FALSE
779: ,p_commit => FND_API.G_FALSE
780: ,p_validate_only => FND_API.G_TRUE
781: ,x_return_status => l_api_return_status
782: ,x_msg_count => l_api_msg_count
783: ,x_msg_data => l_api_msg_data

Line 780: ,p_validate_only => FND_API.G_TRUE

776: create_requisition
777: ( p_api_version => 1.0
778: ,p_init_msg_list => FND_API.G_FALSE
779: ,p_commit => FND_API.G_FALSE
780: ,p_validate_only => FND_API.G_TRUE
781: ,x_return_status => l_api_return_status
782: ,x_msg_count => l_api_msg_count
783: ,x_msg_data => l_api_msg_data
784: ,p_wip_entity_id => l_di_record.wip_entity_id

Line 804: x_return_status := fnd_api.g_ret_sts_error;

800: ,p_suggested_vendor_phone => l_di_record.suggested_vendor_phone
801: ,p_suggested_vendor_item_num => l_di_record.suggested_vendor_item_num);
802:
803: if nvl(l_api_return_status,'Q') <> 'S' then
804: x_return_status := fnd_api.g_ret_sts_error;
805: end if;
806:
807: end if;
808:

Line 816: x_return_status := fnd_api.g_ret_sts_error;

812: EXCEPTION
813:
814: when others then
815:
816: x_return_status := fnd_api.g_ret_sts_error;
817:
818: END create_reqs_at_di_upd;
819:
820: