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

Line 51: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

47: IS
48:
49: l_dummy NUMBER;
50: l_debug VARCHAR2(80);
51: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
52: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
53: l_msg_count NUMBER := 0;
54: l_msg_data VARCHAR2(8000) := '';
55:

Line 52: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

48:
49: l_dummy NUMBER;
50: l_debug VARCHAR2(80);
51: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
52: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
53: l_msg_count NUMBER := 0;
54: l_msg_data VARCHAR2(8000) := '';
55:
56: l_err_num NUMBER := 0;

Line 326: p_init_msg_list => FND_API.g_false,

322: -- The estimate may have been rolled up to asset
323:
324: CST_EAMCOST_PUB.delete_eamperbal(
325: p_api_version => 1.0,
326: p_init_msg_list => FND_API.g_false,
327: p_entity_id_tab => l_entity_id_tab,
328: p_org_id => l_maint_organization_id,
329: p_type => 1,
330: x_return_status => l_return_status,

Line 334: IF l_return_status <> FND_API.g_ret_sts_success THEN

330: x_return_status => l_return_status,
331: x_msg_count => l_msg_count,
332: x_msg_data => l_msg_data);
333:
334: IF l_return_status <> FND_API.g_ret_sts_success THEN
335:
336:
337: CST_UTILITY_PUB.writelogmessages
338: ( p_api_version => 1.0,

Line 366: p_init_msg_list => FND_API.G_FALSE,

362:
363: l_stmt_num := 35;
364: CST_eamCost_PUB.Delete_eamBalAcct(
365: p_api_version => 1.0,
366: p_init_msg_list => FND_API.G_FALSE,
367: p_commit => FND_API.G_FALSE,
368: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
369: x_return_status => l_return_status,
370: x_msg_count => l_msg_count,

Line 367: p_commit => FND_API.G_FALSE,

363: l_stmt_num := 35;
364: CST_eamCost_PUB.Delete_eamBalAcct(
365: p_api_version => 1.0,
366: p_init_msg_list => FND_API.G_FALSE,
367: p_commit => FND_API.G_FALSE,
368: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
369: x_return_status => l_return_status,
370: x_msg_count => l_msg_count,
371: x_msg_data => l_msg_data,

Line 368: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

364: CST_eamCost_PUB.Delete_eamBalAcct(
365: p_api_version => 1.0,
366: p_init_msg_list => FND_API.G_FALSE,
367: p_commit => FND_API.G_FALSE,
368: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
369: x_return_status => l_return_status,
370: x_msg_count => l_msg_count,
371: x_msg_data => l_msg_data,
372: p_entity_id_tab => l_entity_id_tab,

Line 376: IF l_return_status <> FND_API.g_ret_sts_success THEN

372: p_entity_id_tab => l_entity_id_tab,
373: p_org_id => l_maint_organization_id
374: ) ;
375:
376: IF l_return_status <> FND_API.g_ret_sts_success THEN
377:
378: CST_UTILITY_PUB.writelogmessages
379: ( p_api_version => 1.0,
380: p_msg_count => l_msg_count,

Line 390: IF l_return_status <> FND_API.g_ret_sts_success THEN

386: RAISE process_error;
387:
388: END IF;
389:
390: IF l_return_status <> FND_API.g_ret_sts_success THEN
391:
392: CST_UTILITY_PUB.writelogmessages
393: ( p_api_version => 1.0,
394: p_msg_count => l_msg_count,

Line 417: p_init_msg_list => FND_API.g_true,

413: l_stmt_num := 40;
414:
415: CST_EAMCOST_PUB.compute_job_estimate
416: ( p_api_version => 1.0,
417: p_init_msg_list => FND_API.g_true,
418: p_debug => l_debug,
419: p_wip_entity_id => l_entity_id_tab(l_index),
420: p_user_id => l_user_id,
421: p_request_id => l_request_id,

Line 429: IF l_return_status <> FND_API.g_ret_sts_success THEN

425: x_return_status => l_return_status,
426: x_msg_count => l_msg_count,
427: x_msg_data => l_msg_data);
428:
429: IF l_return_status <> FND_API.g_ret_sts_success THEN
430:
431: CST_UTILITY_PUB.writelogmessages
432: ( p_api_version => 1.0,
433: p_msg_count => l_msg_count,

Line 560: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

556:
557: l_api_name CONSTANT VARCHAR2(30) := 'Estimate_WorkOrder';
558: l_api_version CONSTANT NUMBER := 1.0;
559:
560: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
561: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
562: l_msg_count NUMBER := 0;
563: l_msg_data VARCHAR2(8000) := '';
564: l_api_message VARCHAR2(1000) := '';

Line 561: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

557: l_api_name CONSTANT VARCHAR2(30) := 'Estimate_WorkOrder';
558: l_api_version CONSTANT NUMBER := 1.0;
559:
560: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
561: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
562: l_msg_count NUMBER := 0;
563: l_msg_data VARCHAR2(8000) := '';
564: l_api_message VARCHAR2(1000) := '';
565:

Line 585: IF NOT FND_API.Compatible_API_Call( l_api_version,

581:
582: l_stmt_num := 5;
583:
584: -- Standard call to check for call compatibility
585: IF NOT FND_API.Compatible_API_Call( l_api_version,
586: p_api_version,
587: l_api_name,
588: G_PKG_NAME) THEN
589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

585: IF NOT FND_API.Compatible_API_Call( l_api_version,
586: p_api_version,
587: l_api_name,
588: G_PKG_NAME) THEN
589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
590: END IF;
591:
592: -- Initialize message list if p_init_msg_list is set to TRUE
593: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 593: IF FND_API.to_Boolean(p_init_msg_list) THEN

589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
590: END IF;
591:
592: -- Initialize message list if p_init_msg_list is set to TRUE
593: IF FND_API.to_Boolean(p_init_msg_list) THEN
594: FND_MSG_PUB.initialize;
595: END IF;
596:
597: -- Initialize API return status to success

Line 598: x_return_status := FND_API.G_RET_STS_SUCCESS;

594: FND_MSG_PUB.initialize;
595: END IF;
596:
597: -- Initialize API return status to success
598: x_return_status := FND_API.G_RET_STS_SUCCESS;
599:
600: l_entity_id_tab(1) := p_wip_entity_id; -- Bug#4239253 PL/SQL table to be used instead of p_wip_entity_id
601:
602:

Line 622: p_init_msg_list => FND_API.g_false,

618: -- The estimate may have been rolled up to asset
619:
620: CST_EAMCOST_PUB.delete_eamperbal(
621: p_api_version => 1.0,
622: p_init_msg_list => FND_API.g_false,
623: p_entity_id_tab => l_entity_id_tab,
624: p_org_id => p_organization_id,
625: p_type => 1,
626: x_return_status => l_return_status,

Line 630: IF l_return_status <> FND_API.g_ret_sts_success THEN

626: x_return_status => l_return_status,
627: x_msg_count => l_msg_count,
628: x_msg_data => l_msg_data);
629:
630: IF l_return_status <> FND_API.g_ret_sts_success THEN
631:
632: l_api_message := 'Error: CST_EAMCOST_PUB.delete_eamperbal()';
633:
634: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('

Line 637: RAISE FND_API.g_exc_error;

633:
634: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('
635: ||TO_CHAR(l_stmt_num)
636: ||'): ', l_api_message);
637: RAISE FND_API.g_exc_error;
638:
639: END IF;
640:
641: /* the following lines delete the rows for this wip entity ID from the table

Line 657: p_init_msg_list => FND_API.G_FALSE,

653:
654: l_stmt_num := 35;
655: CST_eamCost_PUB.Delete_eamBalAcct(
656: p_api_version => 1.0,
657: p_init_msg_list => FND_API.G_FALSE,
658: p_commit => FND_API.G_FALSE,
659: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
660: x_return_status => l_return_status,
661: x_msg_count => l_msg_count,

Line 658: p_commit => FND_API.G_FALSE,

654: l_stmt_num := 35;
655: CST_eamCost_PUB.Delete_eamBalAcct(
656: p_api_version => 1.0,
657: p_init_msg_list => FND_API.G_FALSE,
658: p_commit => FND_API.G_FALSE,
659: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
660: x_return_status => l_return_status,
661: x_msg_count => l_msg_count,
662: x_msg_data => l_msg_data,

Line 659: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

655: CST_eamCost_PUB.Delete_eamBalAcct(
656: p_api_version => 1.0,
657: p_init_msg_list => FND_API.G_FALSE,
658: p_commit => FND_API.G_FALSE,
659: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
660: x_return_status => l_return_status,
661: x_msg_count => l_msg_count,
662: x_msg_data => l_msg_data,
663: p_entity_id_tab => l_entity_id_tab,

Line 667: IF l_return_status <> FND_API.g_ret_sts_success THEN

663: p_entity_id_tab => l_entity_id_tab,
664: p_org_id => p_organization_id
665: ) ;
666:
667: IF l_return_status <> FND_API.g_ret_sts_success THEN
668:
669: l_api_message := 'Error: CST_EAMCOST_PUB.Delete_eamBalAcct()';
670:
671: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('

Line 674: RAISE FND_API.g_exc_error;

670:
671: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('
672: ||TO_CHAR(l_stmt_num)
673: ||'): ', l_api_message);
674: RAISE FND_API.g_exc_error;
675:
676: END IF;
677:
678:

Line 692: IF l_return_status <> FND_API.g_ret_sts_success THEN

688: x_msg_data => l_msg_data,
689: p_entity_id_tab => l_entity_id_tab
690: );
691:
692: IF l_return_status <> FND_API.g_ret_sts_success THEN
693:
694: l_api_message := 'Error: CST_eamCost_PUB.Insert_tempEstimateDetails()';
695:
696: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('

Line 699: RAISE FND_API.g_exc_error;

695:
696: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('
697: ||TO_CHAR(l_stmt_num)
698: ||'): ', l_api_message);
699: RAISE FND_API.g_exc_error;
700:
701: END IF;
702:
703: l_stmt_num := 38;

Line 710: p_init_msg_list => FND_API.g_false,

706: l_stmt_num := 40;
707:
708: CST_EAMCOST_PUB.compute_job_estimate
709: (p_api_version => 1.0,
710: p_init_msg_list => FND_API.g_false,
711: p_debug => 'N',
712: p_wip_entity_id => l_entity_id_tab(1),
713: p_user_id => l_user_id,
714: p_request_id => l_request_id,

Line 722: IF l_return_status <> FND_API.g_ret_sts_success THEN

718: x_return_status => l_return_status,
719: x_msg_count => l_msg_count,
720: x_msg_data => l_msg_data);
721:
722: IF l_return_status <> FND_API.g_ret_sts_success THEN
723:
724: l_api_message := 'Error: CST_EAMCOST_PUB.compute_job_estimate()';
725:
726: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('

Line 729: RAISE FND_API.g_exc_error;

725:
726: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('
727: ||TO_CHAR(l_stmt_num)
728: ||'): ', l_api_message);
729: RAISE FND_API.g_exc_error;
730:
731: END IF;
732:
733: l_stmt_num := 50;

Line 747: IF FND_API.to_Boolean(p_commit) THEN

743: last_update_date = SYSDATE
744: WHERE wdj.wip_entity_id = l_entity_id_tab(1);
745:
746: --- Standard check of p_commit
747: IF FND_API.to_Boolean(p_commit) THEN
748: COMMIT WORK;
749: END IF;
750:
751: -- Standard Call to get message count and if count = 1, get message info

Line 757: WHEN fnd_api.g_exc_error THEN

753: p_count => x_msg_count,
754: p_data => x_msg_data );
755:
756: EXCEPTION
757: WHEN fnd_api.g_exc_error THEN
758: ROLLBACK TO Estimate_WorkOrder_GRP;
759:
760: UPDATE wip_discrete_jobs
761: SET estimation_status = 3,

Line 768: IF FND_API.to_Boolean(p_commit) THEN

764: last_estimation_req_id = l_request_id
765: WHERE wip_entity_id = l_entity_id_tab(1);
766:
767: --- Standard check of p_commit
768: IF FND_API.to_Boolean(p_commit) THEN
769: COMMIT WORK;
770: END IF;
771:
772: x_return_status := fnd_api.g_ret_sts_error;

Line 772: x_return_status := fnd_api.g_ret_sts_error;

768: IF FND_API.to_Boolean(p_commit) THEN
769: COMMIT WORK;
770: END IF;
771:
772: x_return_status := fnd_api.g_ret_sts_error;
773:
774: -- Get message count and data
775: fnd_msg_pub.count_and_get
776: ( p_count => x_msg_count

Line 780: WHEN fnd_api.g_exc_unexpected_error THEN

776: ( p_count => x_msg_count
777: , p_data => x_msg_data
778: );
779: --
780: WHEN fnd_api.g_exc_unexpected_error THEN
781: ROLLBACK TO Estimate_WorkOrder_GRP;
782:
783: UPDATE wip_discrete_jobs
784: SET estimation_status = 3,

Line 791: IF FND_API.to_Boolean(p_commit) THEN

787: last_estimation_req_id = l_request_id
788: WHERE wip_entity_id = l_entity_id_tab(1);
789:
790: --- Standard check of p_commit
791: IF FND_API.to_Boolean(p_commit) THEN
792: COMMIT WORK;
793: END IF;
794:
795: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 795: x_return_status := fnd_api.g_ret_sts_unexp_error ;

791: IF FND_API.to_Boolean(p_commit) THEN
792: COMMIT WORK;
793: END IF;
794:
795: x_return_status := fnd_api.g_ret_sts_unexp_error ;
796:
797: -- Get message count and data
798: fnd_msg_pub.count_and_get
799: ( p_count => x_msg_count

Line 816: IF FND_API.to_Boolean(p_commit) THEN

812: last_estimation_req_id = l_request_id
813: WHERE wip_entity_id = l_entity_id_tab(1);
814:
815: --- Standard check of p_commit
816: IF FND_API.to_Boolean(p_commit) THEN
817: COMMIT WORK;
818: END IF;
819:
820: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 820: x_return_status := fnd_api.g_ret_sts_unexp_error ;

816: IF FND_API.to_Boolean(p_commit) THEN
817: COMMIT WORK;
818: END IF;
819:
820: x_return_status := fnd_api.g_ret_sts_unexp_error ;
821: --
822: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
823: THEN
824: fnd_msg_pub.add_exc_msg