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

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

Line 154: RAISE fnd_api.g_exc_unexpected_error;

150: l_api_version
151: ,p_api_version
152: ,l_api_name
153: ,g_pkg_name) THEN
154: RAISE fnd_api.g_exc_unexpected_error;
155: END IF;
156:
157: 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_WO_CHANGE_STATUS_PVT.change_status: Initializing Message list for Status Change'); END IF;
158:

Line 160: IF fnd_api.to_boolean(p_init_msg_list) THEN

156:
157: 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_WO_CHANGE_STATUS_PVT.change_status: Initializing Message list for Status Change'); END IF;
158:
159: -- Initialize message list if p_init_msg_list is set to TRUE.
160: IF fnd_api.to_boolean(p_init_msg_list) THEN
161: fnd_msg_pub.initialize;
162: END IF;
163:
164: -- Initialize API return status to success

Line 165: x_return_status := fnd_api.g_ret_sts_success;

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

Line 193: raise fnd_api.g_exc_unexpected_error;

189: IF l_to_status_type NOT IN (WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG, WIP_CONSTANTS.CLOSED,
190: WIP_CONSTANTS.HOLD, WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.PEND_SCHED, WIP_CONSTANTS.DRAFT)
191: THEN
192:
193: raise fnd_api.g_exc_unexpected_error;
194:
195: END IF;
196:
197: 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_WO_CHANGE_STATUS_PVT.change_status: Find current work order status'); END IF;

Line 255: RAISE fnd_api.g_exc_unexpected_error;

251: l_rebuild_flag := 'Y';
252: ELSIF (l_asset_group_id > 0) THEN
253: l_rebuild_flag := 'N';
254: ELSE
255: RAISE fnd_api.g_exc_unexpected_error;
256: END IF;
257:
258: 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_WO_CHANGE_STATUS_PVT.change_status: Is this a rebuild WO : '||l_rebuild_flag ); END IF;
259:

Line 658: ,p_init_msg_list => FND_API.G_FALSE

654: 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_WO_CHANGE_STATUS_PVT.change_status: Creating direct item requisitions at release '); END IF;
655: 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_WO_CHANGE_STATUS_PVT.change_status: Calling EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel'); END IF;
656: EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel
657: ( p_api_version => 1.0
658: ,p_init_msg_list => FND_API.G_FALSE
659: ,p_commit => FND_API.G_FALSE
660: ,p_validate_only => FND_API.G_TRUE
661: ,x_return_status => l_di_return_status
662: ,x_msg_count => l_di_msg_count

Line 659: ,p_commit => FND_API.G_FALSE

655: 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_WO_CHANGE_STATUS_PVT.change_status: Calling EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel'); END IF;
656: EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel
657: ( p_api_version => 1.0
658: ,p_init_msg_list => FND_API.G_FALSE
659: ,p_commit => FND_API.G_FALSE
660: ,p_validate_only => FND_API.G_TRUE
661: ,x_return_status => l_di_return_status
662: ,x_msg_count => l_di_msg_count
663: ,x_msg_data => l_di_msg_data

Line 660: ,p_validate_only => FND_API.G_TRUE

656: EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel
657: ( p_api_version => 1.0
658: ,p_init_msg_list => FND_API.G_FALSE
659: ,p_commit => FND_API.G_FALSE
660: ,p_validate_only => FND_API.G_TRUE
661: ,x_return_status => l_di_return_status
662: ,x_msg_count => l_di_msg_count
663: ,x_msg_data => l_di_msg_data
664: ,p_user_id => l_user_id

Line 676: x_return_status := fnd_api.g_ret_sts_error;

672:
673: 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_WO_CHANGE_STATUS_PVT.change_status: Creating direct item requisitions completed with status '||l_di_return_status); END IF;
674:
675: IF NVL(l_di_return_status,'S') <> 'S' THEN
676: x_return_status := fnd_api.g_ret_sts_error;
677: END IF;
678: END IF; -- End of If (l_to_status_type in (3))
679:
680: l_final_status := l_to_status_type;

Line 725: x_return_status := fnd_api.g_ret_sts_error;

721: null;
722: END;
723:
724: IF(l_relations_count=1) THEN
725: x_return_status := fnd_api.g_ret_sts_error;
726: l_token_tbl(1).token_name := 'WORKORDER';
727: l_token_tbl(1).token_value := l_wip_entity_id;
728: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
729: ( p_message_name => 'EAM_DELINK_CANCELLED'

Line 809: x_return_status := fnd_api.g_ret_sts_error;

805: AND PRI.DESTINATION_ORGANIZATION_ID = l_organization_id
806: ) ;
807:
808: IF l_po_exists = 1 THEN
809: x_return_status := fnd_api.g_ret_sts_error;
810: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
811: ( p_message_name => 'WIP_CANCEL_JOB/SCHED_OPEN_PO'
812: , p_token_tbl => l_token_tbl
813: , p_mesg_token_tbl => l_mesg_token_tbl

Line 823: x_return_status := fnd_api.g_ret_sts_error;

819: EXCEPTION
820: WHEN No_Data_Found THEN
821: NULL;
822: WHEN TOO_MANY_ROWS THEN
823: x_return_status := fnd_api.g_ret_sts_error;
824: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
825: ( p_message_name => 'WIP_CANCEL_JOB/SCHED_OPEN_PO'
826: , p_token_tbl => l_token_tbl
827: , p_mesg_token_tbl => l_mesg_token_tbl

Line 839: raise fnd_api.g_exc_unexpected_error;

835: INTO l_gid
836: FROM dual;
837: EXCEPTION
838: WHEN OTHERS THEN
839: raise fnd_api.g_exc_unexpected_error;
840: END;
841:
842: BEGIN
843: 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_WO_CHANGE_STATUS_PVT.change_status: Insert into WIP_DJ_CLOSE_TEMP'); END IF;

Line 863: raise fnd_api.g_exc_unexpected_error;

859: l_gid);
860:
861: EXCEPTION
862: WHEN OTHERS THEN
863: raise fnd_api.g_exc_unexpected_error;
864: END;
865:
866: -- This call to fnd_global.apps_initialize is needed because this is
867: -- part of the WO API which can also be used as a standalone API

Line 937: raise fnd_api.g_exc_unexpected_error;

933: AND WIP_ENTITY_ID = l_wip_entity_id;
934:
935: EXCEPTION
936: WHEN OTHERS THEN
937: raise fnd_api.g_exc_unexpected_error;
938: END;
939:
940:
941: /*******************************************/

Line 969: raise fnd_api.g_exc_unexpected_error;

965:
966:
967: EXCEPTION
968: WHEN OTHERS THEN
969: raise fnd_api.g_exc_unexpected_error;
970: END;
971:
972: ELSE
973:

Line 983: raise fnd_api.g_exc_unexpected_error;

979: AND WIP_ENTITY_ID = l_wip_entity_id;
980:
981: EXCEPTION
982: WHEN OTHERS THEN
983: raise fnd_api.g_exc_unexpected_error;
984: END;
985:
986: END IF; -- end of check for WIP_CLOSE_UTILITIES.Unclose_Job
987:

Line 1003: WHEN fnd_api.g_exc_error THEN

999:
1000: x_request_id := l_request_id;
1001:
1002: EXCEPTION
1003: WHEN fnd_api.g_exc_error THEN
1004: ROLLBACK TO change_status;
1005: x_return_status := fnd_api.g_ret_sts_error;
1006: fnd_msg_pub.count_and_get(
1007: p_count => x_msg_count

Line 1005: x_return_status := fnd_api.g_ret_sts_error;

1001:
1002: EXCEPTION
1003: WHEN fnd_api.g_exc_error THEN
1004: ROLLBACK TO change_status;
1005: x_return_status := fnd_api.g_ret_sts_error;
1006: fnd_msg_pub.count_and_get(
1007: p_count => x_msg_count
1008: ,p_data => x_msg_data);
1009:

Line 1013: x_return_status := fnd_api.g_ret_sts_error;

1009:
1010: WHEN CHANGE_STATUS_NOT_POSSIBLE THEN
1011: x_msg_count := 1;
1012: x_msg_data := 'Change to ' || l_to_status_type || ' is not possible';
1013: x_return_status := fnd_api.g_ret_sts_error;
1014:
1015: WHEN CHNGE_ST_FRM_TO_NOT_PSSBLE THEN
1016:
1017: x_msg_count := 1;

Line 1019: x_return_status := fnd_api.g_ret_sts_error;

1015: WHEN CHNGE_ST_FRM_TO_NOT_PSSBLE THEN
1016:
1017: x_msg_count := 1;
1018: x_msg_data := 'Change from ' || l_current_status || ' to ' || l_to_status_type || ' is not possible';
1019: x_return_status := fnd_api.g_ret_sts_error;
1020:
1021: WHEN INVALID_RELEASE THEN
1022: x_msg_count := 1;
1023: x_msg_data := 'Work Order Cannot be Released';

Line 1024: x_return_status := fnd_api.g_ret_sts_error;

1020:
1021: WHEN INVALID_RELEASE THEN
1022: x_msg_count := 1;
1023: x_msg_data := 'Work Order Cannot be Released';
1024: x_return_status := fnd_api.g_ret_sts_error;
1025:
1026: WHEN INVALID_UNRELEASE THEN
1027: --Start of fix for 3357656.Get the message name from message stack and populate the token table
1028: x_return_status := fnd_api.g_ret_sts_error;

Line 1028: x_return_status := fnd_api.g_ret_sts_error;

1024: x_return_status := fnd_api.g_ret_sts_error;
1025:
1026: WHEN INVALID_UNRELEASE THEN
1027: --Start of fix for 3357656.Get the message name from message stack and populate the token table
1028: x_return_status := fnd_api.g_ret_sts_error;
1029: l_encoded_message := fnd_message.get_encoded();
1030: fnd_message.parse_encoded(l_encoded_message,
1031: l_application_name,
1032: l_mesg_name);

Line 1040: WHEN fnd_api.g_exc_unexpected_error THEN

1036: , p_mesg_token_tbl => l_mesg_token_tbl
1037: , x_mesg_token_tbl => x_mesg_token_tbl
1038: );
1039: --end of fix for 33575656
1040: WHEN fnd_api.g_exc_unexpected_error THEN
1041: ROLLBACK TO change_status;
1042: x_return_status := fnd_api.g_ret_sts_unexp_error;
1043:
1044: fnd_msg_pub.count_and_get(

Line 1042: x_return_status := fnd_api.g_ret_sts_unexp_error;

1038: );
1039: --end of fix for 33575656
1040: WHEN fnd_api.g_exc_unexpected_error THEN
1041: ROLLBACK TO change_status;
1042: x_return_status := fnd_api.g_ret_sts_unexp_error;
1043:
1044: fnd_msg_pub.count_and_get(
1045: p_count => x_msg_count
1046: ,p_data => x_msg_data);

Line 1050: x_return_status := fnd_api.g_ret_sts_unexp_error;

1046: ,p_data => x_msg_data);
1047:
1048: WHEN OTHERS THEN
1049: ROLLBACK TO change_status;
1050: x_return_status := fnd_api.g_ret_sts_unexp_error;
1051: IF fnd_msg_pub.check_msg_level(
1052: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1053: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1054: END IF;