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 561: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 586: IF NOT FND_API.Compatible_API_Call( l_api_version,

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

Line 590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 594: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 599: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 623: p_init_msg_list => FND_API.g_false,

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

Line 631: IF l_return_status <> FND_API.g_ret_sts_success THEN

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

Line 638: RAISE FND_API.g_exc_error;

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

Line 658: p_init_msg_list => FND_API.G_FALSE,

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

Line 659: p_commit => FND_API.G_FALSE,

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

Line 660: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

Line 668: IF l_return_status <> FND_API.g_ret_sts_success THEN

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

Line 675: RAISE FND_API.g_exc_error;

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

Line 697: IF l_return_status <> FND_API.g_ret_sts_success THEN

693: x_msg_data => l_msg_data,
694: p_entity_id_tab => l_entity_id_tab
695: );
696:
697: IF l_return_status <> FND_API.g_ret_sts_success THEN
698:
699: l_api_message := 'Error: CST_eamCost_PUB.Insert_tempEstimateDetails()';
700:
701: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('

Line 704: RAISE FND_API.g_exc_error;

700:
701: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('
702: ||TO_CHAR(l_stmt_num)
703: ||'): ', l_api_message);
704: RAISE FND_API.g_exc_error;
705:
706: END IF;
707:
708: l_stmt_num := 38;

Line 715: p_init_msg_list => FND_API.g_false,

711: l_stmt_num := 40;
712:
713: CST_EAMCOST_PUB.compute_job_estimate
714: (p_api_version => 1.0,
715: p_init_msg_list => FND_API.g_false,
716: p_debug => 'N',
717: p_wip_entity_id => l_entity_id_tab(1),
718: p_user_id => l_user_id,
719: p_request_id => l_request_id,

Line 727: IF l_return_status <> FND_API.g_ret_sts_success THEN

723: x_return_status => l_return_status,
724: x_msg_count => l_msg_count,
725: x_msg_data => l_msg_data);
726:
727: IF l_return_status <> FND_API.g_ret_sts_success THEN
728:
729: l_api_message := 'Error: CST_EAMCOST_PUB.compute_job_estimate()';
730:
731: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('

Line 734: RAISE FND_API.g_exc_error;

730:
731: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('
732: ||TO_CHAR(l_stmt_num)
733: ||'): ', l_api_message);
734: RAISE FND_API.g_exc_error;
735:
736: END IF;
737:
738: l_stmt_num := 50;

Line 754: IF FND_API.to_Boolean(p_commit) THEN

750:
751: END IF; -- p_delete_only check
752:
753: --- Standard check of p_commit
754: IF FND_API.to_Boolean(p_commit) THEN
755: COMMIT WORK;
756: END IF;
757:
758: -- Standard Call to get message count and if count = 1, get message info

Line 764: WHEN fnd_api.g_exc_error THEN

760: p_count => x_msg_count,
761: p_data => x_msg_data );
762:
763: EXCEPTION
764: WHEN fnd_api.g_exc_error THEN
765: ROLLBACK TO Estimate_WorkOrder_GRP;
766:
767: UPDATE wip_discrete_jobs
768: SET estimation_status = 3,

Line 775: IF FND_API.to_Boolean(p_commit) THEN

771: last_estimation_req_id = l_request_id
772: WHERE wip_entity_id = l_entity_id_tab(1);
773:
774: --- Standard check of p_commit
775: IF FND_API.to_Boolean(p_commit) THEN
776: COMMIT WORK;
777: END IF;
778:
779: x_return_status := fnd_api.g_ret_sts_error;

Line 779: x_return_status := fnd_api.g_ret_sts_error;

775: IF FND_API.to_Boolean(p_commit) THEN
776: COMMIT WORK;
777: END IF;
778:
779: x_return_status := fnd_api.g_ret_sts_error;
780:
781: -- Get message count and data
782: fnd_msg_pub.count_and_get
783: ( p_count => x_msg_count

Line 787: WHEN fnd_api.g_exc_unexpected_error THEN

783: ( p_count => x_msg_count
784: , p_data => x_msg_data
785: );
786: --
787: WHEN fnd_api.g_exc_unexpected_error THEN
788: ROLLBACK TO Estimate_WorkOrder_GRP;
789:
790: UPDATE wip_discrete_jobs
791: SET estimation_status = 3,

Line 798: IF FND_API.to_Boolean(p_commit) THEN

794: last_estimation_req_id = l_request_id
795: WHERE wip_entity_id = l_entity_id_tab(1);
796:
797: --- Standard check of p_commit
798: IF FND_API.to_Boolean(p_commit) THEN
799: COMMIT WORK;
800: END IF;
801:
802: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 802: x_return_status := fnd_api.g_ret_sts_unexp_error ;

798: IF FND_API.to_Boolean(p_commit) THEN
799: COMMIT WORK;
800: END IF;
801:
802: x_return_status := fnd_api.g_ret_sts_unexp_error ;
803:
804: -- Get message count and data
805: fnd_msg_pub.count_and_get
806: ( p_count => x_msg_count

Line 823: IF FND_API.to_Boolean(p_commit) THEN

819: last_estimation_req_id = l_request_id
820: WHERE wip_entity_id = l_entity_id_tab(1);
821:
822: --- Standard check of p_commit
823: IF FND_API.to_Boolean(p_commit) THEN
824: COMMIT WORK;
825: END IF;
826:
827: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 827: x_return_status := fnd_api.g_ret_sts_unexp_error ;

823: IF FND_API.to_Boolean(p_commit) THEN
824: COMMIT WORK;
825: END IF;
826:
827: x_return_status := fnd_api.g_ret_sts_unexp_error ;
828: --
829: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
830: THEN
831: fnd_msg_pub.add_exc_msg