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_WO_CHANGE_STATUS_PVT dependencies on FND_API

Line 49: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

45: ************************************************************************************/
46:
47: PROCEDURE change_status (
48: p_api_version IN NUMBER
49: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
50: ,p_commit IN VARCHAR2 := fnd_api.g_false
51: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
52: ,p_wip_entity_id IN NUMBER
53: ,p_organization_id IN NUMBER

Line 50: ,p_commit IN VARCHAR2 := fnd_api.g_false

46:
47: PROCEDURE change_status (
48: p_api_version IN NUMBER
49: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
50: ,p_commit IN VARCHAR2 := fnd_api.g_false
51: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
52: ,p_wip_entity_id IN NUMBER
53: ,p_organization_id IN NUMBER
54: ,p_to_status_type IN NUMBER := wip_constants.unreleased

Line 51: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

47: PROCEDURE change_status (
48: p_api_version IN NUMBER
49: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
50: ,p_commit IN VARCHAR2 := fnd_api.g_false
51: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
52: ,p_wip_entity_id IN NUMBER
53: ,p_organization_id IN NUMBER
54: ,p_to_status_type IN NUMBER := wip_constants.unreleased
55: ,p_user_id IN NUMBER := null

Line 147: IF NOT fnd_api.compatible_api_call(

143:
144: SAVEPOINT change_status;
145:
146: -- Standard call to check for call compatibility.
147: IF NOT fnd_api.compatible_api_call(
148: l_api_version
149: ,p_api_version
150: ,l_api_name
151: ,g_pkg_name) THEN

Line 152: RAISE fnd_api.g_exc_unexpected_error;

148: l_api_version
149: ,p_api_version
150: ,l_api_name
151: ,g_pkg_name) THEN
152: RAISE fnd_api.g_exc_unexpected_error;
153: END IF;
154:
155: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Initializing Message list for Status Change'); END IF;
156:

Line 158: IF fnd_api.to_boolean(p_init_msg_list) THEN

154:
155: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Initializing Message list for Status Change'); END IF;
156:
157: -- Initialize message list if p_init_msg_list is set to TRUE.
158: IF fnd_api.to_boolean(p_init_msg_list) THEN
159: fnd_msg_pub.initialize;
160: END IF;
161:
162: -- Initialize API return status to success

Line 163: x_return_status := fnd_api.g_ret_sts_success;

159: fnd_msg_pub.initialize;
160: END IF;
161:
162: -- Initialize API return status to success
163: x_return_status := fnd_api.g_ret_sts_success;
164:
165: x_mesg_token_tbl := l_mesg_token_tbl;
166:
167:

Line 191: raise fnd_api.g_exc_unexpected_error;

187: IF l_to_status_type NOT IN (WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG, WIP_CONSTANTS.CLOSED,
188: WIP_CONSTANTS.HOLD, WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.PEND_SCHED, WIP_CONSTANTS.DRAFT)
189: THEN
190:
191: raise fnd_api.g_exc_unexpected_error;
192:
193: END IF;
194:
195: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Find current work order status'); END IF;

Line 251: RAISE fnd_api.g_exc_unexpected_error;

247: l_rebuild_flag := 'Y';
248: ELSIF (l_asset_group_id > 0) THEN
249: l_rebuild_flag := 'N';
250: ELSE
251: RAISE fnd_api.g_exc_unexpected_error;
252: END IF;
253:
254:
255: -- Get WPS Parameters

Line 612: ,p_init_msg_list => FND_API.G_FALSE

608:
609: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Creating direct item requisitions at release'); END IF;
610: EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel
611: ( p_api_version => 1.0
612: ,p_init_msg_list => FND_API.G_FALSE
613: ,p_commit => FND_API.G_FALSE
614: ,p_validate_only => FND_API.G_TRUE
615: ,x_return_status => l_di_return_status
616: ,x_msg_count => l_di_msg_count

Line 613: ,p_commit => FND_API.G_FALSE

609: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Creating direct item requisitions at release'); END IF;
610: EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel
611: ( p_api_version => 1.0
612: ,p_init_msg_list => FND_API.G_FALSE
613: ,p_commit => FND_API.G_FALSE
614: ,p_validate_only => FND_API.G_TRUE
615: ,x_return_status => l_di_return_status
616: ,x_msg_count => l_di_msg_count
617: ,x_msg_data => l_di_msg_data

Line 614: ,p_validate_only => FND_API.G_TRUE

610: EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel
611: ( p_api_version => 1.0
612: ,p_init_msg_list => FND_API.G_FALSE
613: ,p_commit => FND_API.G_FALSE
614: ,p_validate_only => FND_API.G_TRUE
615: ,x_return_status => l_di_return_status
616: ,x_msg_count => l_di_msg_count
617: ,x_msg_data => l_di_msg_data
618: ,p_user_id => l_user_id

Line 630: x_return_status := fnd_api.g_ret_sts_error;

626:
627: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Creating direct item requisitions completed with status '||l_di_return_status); END IF;
628:
629: IF NVL(l_di_return_status,'S') <> 'S' THEN
630: x_return_status := fnd_api.g_ret_sts_error;
631: END IF;
632:
633:
634: l_final_status := l_to_status_type;

Line 679: x_return_status := fnd_api.g_ret_sts_error;

675: null;
676: END;
677:
678: IF(l_relations_count=1) THEN
679: x_return_status := fnd_api.g_ret_sts_error;
680: l_token_tbl(1).token_name := 'WORKORDER';
681: l_token_tbl(1).token_value := l_wip_entity_id;
682: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
683: ( p_message_name => 'EAM_DELINK_CANCELLED'

Line 762: x_return_status := fnd_api.g_ret_sts_error;

758: AND PRI.DESTINATION_ORGANIZATION_ID = l_organization_id
759: ) ;
760:
761: IF l_po_exists = 1 THEN
762: x_return_status := fnd_api.g_ret_sts_error;
763: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
764: ( p_message_name => 'WIP_CANCEL_JOB/SCHED_OPEN_PO'
765: , p_token_tbl => l_token_tbl
766: , p_mesg_token_tbl => l_mesg_token_tbl

Line 776: x_return_status := fnd_api.g_ret_sts_error;

772: EXCEPTION
773: WHEN No_Data_Found THEN
774: NULL;
775: WHEN TOO_MANY_ROWS THEN
776: x_return_status := fnd_api.g_ret_sts_error;
777: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
778: ( p_message_name => 'WIP_CANCEL_JOB/SCHED_OPEN_PO'
779: , p_token_tbl => l_token_tbl
780: , p_mesg_token_tbl => l_mesg_token_tbl

Line 792: raise fnd_api.g_exc_unexpected_error;

788: INTO l_gid
789: FROM dual;
790: EXCEPTION
791: WHEN OTHERS THEN
792: raise fnd_api.g_exc_unexpected_error;
793: END;
794:
795: BEGIN
796: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Insert into WIP_DJ_CLOSE_TEMP'); END IF;

Line 816: raise fnd_api.g_exc_unexpected_error;

812: l_gid);
813:
814: EXCEPTION
815: WHEN OTHERS THEN
816: raise fnd_api.g_exc_unexpected_error;
817: END;
818:
819: -- This call to fnd_global.apps_initialize is needed because this is
820: -- part of the WO API which can also be used as a standalone API

Line 890: raise fnd_api.g_exc_unexpected_error;

886: AND WIP_ENTITY_ID = l_wip_entity_id;
887:
888: EXCEPTION
889: WHEN OTHERS THEN
890: raise fnd_api.g_exc_unexpected_error;
891: END;
892:
893:
894: /*******************************************/

Line 922: raise fnd_api.g_exc_unexpected_error;

918:
919:
920: EXCEPTION
921: WHEN OTHERS THEN
922: raise fnd_api.g_exc_unexpected_error;
923: END;
924:
925: ELSE
926:

Line 936: raise fnd_api.g_exc_unexpected_error;

932: AND WIP_ENTITY_ID = l_wip_entity_id;
933:
934: EXCEPTION
935: WHEN OTHERS THEN
936: raise fnd_api.g_exc_unexpected_error;
937: END;
938:
939: END IF; -- end of check for WIP_CLOSE_UTILITIES.Unclose_Job
940:

Line 956: WHEN fnd_api.g_exc_error THEN

952:
953: x_request_id := l_request_id;
954:
955: EXCEPTION
956: WHEN fnd_api.g_exc_error THEN
957: ROLLBACK TO change_status;
958: x_return_status := fnd_api.g_ret_sts_error;
959: fnd_msg_pub.count_and_get(
960: p_count => x_msg_count

Line 958: x_return_status := fnd_api.g_ret_sts_error;

954:
955: EXCEPTION
956: WHEN fnd_api.g_exc_error THEN
957: ROLLBACK TO change_status;
958: x_return_status := fnd_api.g_ret_sts_error;
959: fnd_msg_pub.count_and_get(
960: p_count => x_msg_count
961: ,p_data => x_msg_data);
962:

Line 966: x_return_status := fnd_api.g_ret_sts_error;

962:
963: WHEN CHANGE_STATUS_NOT_POSSIBLE THEN
964: x_msg_count := 1;
965: x_msg_data := 'Change to ' || l_to_status_type || ' is not possible';
966: x_return_status := fnd_api.g_ret_sts_error;
967:
968: WHEN CHNGE_ST_FRM_TO_NOT_PSSBLE THEN
969:
970: x_msg_count := 1;

Line 972: x_return_status := fnd_api.g_ret_sts_error;

968: WHEN CHNGE_ST_FRM_TO_NOT_PSSBLE THEN
969:
970: x_msg_count := 1;
971: x_msg_data := 'Change from ' || l_current_status || ' to ' || l_to_status_type || ' is not possible';
972: x_return_status := fnd_api.g_ret_sts_error;
973:
974: WHEN INVALID_RELEASE THEN
975: x_msg_count := 1;
976: x_msg_data := 'Work Order Cannot be Released';

Line 977: x_return_status := fnd_api.g_ret_sts_error;

973:
974: WHEN INVALID_RELEASE THEN
975: x_msg_count := 1;
976: x_msg_data := 'Work Order Cannot be Released';
977: x_return_status := fnd_api.g_ret_sts_error;
978:
979: WHEN INVALID_UNRELEASE THEN
980: --Start of fix for 3357656.Get the message name from message stack and populate the token table
981: x_return_status := fnd_api.g_ret_sts_error;

Line 981: x_return_status := fnd_api.g_ret_sts_error;

977: x_return_status := fnd_api.g_ret_sts_error;
978:
979: WHEN INVALID_UNRELEASE THEN
980: --Start of fix for 3357656.Get the message name from message stack and populate the token table
981: x_return_status := fnd_api.g_ret_sts_error;
982: l_encoded_message := fnd_message.get_encoded();
983: fnd_message.parse_encoded(l_encoded_message,
984: l_application_name,
985: l_mesg_name);

Line 993: WHEN fnd_api.g_exc_unexpected_error THEN

989: , p_mesg_token_tbl => l_mesg_token_tbl
990: , x_mesg_token_tbl => x_mesg_token_tbl
991: );
992: --end of fix for 33575656
993: WHEN fnd_api.g_exc_unexpected_error THEN
994: ROLLBACK TO change_status;
995: x_return_status := fnd_api.g_ret_sts_unexp_error;
996:
997: fnd_msg_pub.count_and_get(

Line 995: x_return_status := fnd_api.g_ret_sts_unexp_error;

991: );
992: --end of fix for 33575656
993: WHEN fnd_api.g_exc_unexpected_error THEN
994: ROLLBACK TO change_status;
995: x_return_status := fnd_api.g_ret_sts_unexp_error;
996:
997: fnd_msg_pub.count_and_get(
998: p_count => x_msg_count
999: ,p_data => x_msg_data);

Line 1003: x_return_status := fnd_api.g_ret_sts_unexp_error;

999: ,p_data => x_msg_data);
1000:
1001: WHEN OTHERS THEN
1002: ROLLBACK TO change_status;
1003: x_return_status := fnd_api.g_ret_sts_unexp_error;
1004: IF fnd_msg_pub.check_msg_level(
1005: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1006: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1007: END IF;