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 EAM_ERROR_MESSAGE_PVT

Line 66: ,x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type)

62: ,x_request_id OUT NOCOPY NUMBER
63: ,x_return_status OUT NOCOPY VARCHAR2
64: ,x_msg_count OUT NOCOPY NUMBER
65: ,x_msg_data OUT NOCOPY VARCHAR2
66: ,x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type)
67: IS
68: l_api_name CONSTANT VARCHAR2(30) := 'change_status';
69: l_api_version CONSTANT NUMBER := 1.0;
70: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 104: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

100: l_di_msg_count NUMBER := 0;
101: l_di_msg_data VARCHAR2(80) := '';
102: l_di_return_status VARCHAR2(80) := '';
103: l_po_creation_time NUMBER;
104: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
105:
106: --fix for bug 3357656.Added following 4 parameters to get the message from eam_workutil_pkg.unrelease
107: l_encoded_message VARCHAR2(800);
108: l_application_name VARCHAR2(10);

Line 110: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

106: --fix for bug 3357656.Added following 4 parameters to get the message from eam_workutil_pkg.unrelease
107: l_encoded_message VARCHAR2(800);
108: l_application_name VARCHAR2(10);
109: l_mesg_name VARCHAR2(100);
110: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
111:
112: l_request_id NUMBER;
113: l_return_status VARCHAR2(80);
114: l_msg_count NUMBER := 0;

Line 142: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering Status Change Package'); END IF;

138:
139: BEGIN
140:
141: -- Standard Start of API savepoint
142: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering Status Change Package'); END IF;
143:
144: SAVEPOINT change_status;
145:
146: -- Standard call to check for call compatibility.

Line 155: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Initializing Message list for Status Change'); END IF;

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:
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;

Line 168: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering Status Change API body'); END IF;

164:
165: x_mesg_token_tbl := l_mesg_token_tbl;
166:
167:
168: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering Status Change API body'); END IF;
169:
170: /********************************************************************/
171: -- API body
172:

Line 185: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Status'); END IF;

181: FROM wip_entities
182: WHERE wip_entity_id = p_wip_entity_id;
183:
184: -- Validate status_id
185: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Status'); END IF;
186:
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

Line 195: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Find current work order status'); END IF;

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;
196:
197: -- Get current status of work order
198:
199: BEGIN

Line 244: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking if this is a rebuild WO'); END IF;

240: END;
241: l_final_status := l_current_status;
242:
243: -- Determine whether it is a rebuild work order
244: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking if this is a rebuild WO'); END IF;
245:
246: IF(l_rebuild_item_id > 0) THEN
247: l_rebuild_flag := 'Y';
248: ELSIF (l_asset_group_id > 0) THEN

Line 257: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Getting WPS parameters'); END IF;

253:
254:
255: -- Get WPS Parameters
256: -- WPS parameters
257: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Getting WPS parameters'); END IF;
258:
259: IF(WPS_COMMON.Get_Install_Status = 'I') THEN
260: WPS_COMMON.GetParameters(
261: P_Org_Id => l_organization_id,

Line 276: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking if status change is allowed'); END IF;

272:
273: -- Direct Change to Pending Bill Load, Failed Bill Load, Pending Routing Load,
274: -- Failed Routing Load, Pending - Mass Loaded, Pending Close, Failed Close
275: -- Pending Scheduling and Draft not Possible.
276: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking if status change is allowed'); END IF;
277:
278: IF (l_to_status_type in (8,9,10,11,13,14,15,16,17)) THEN
279: IF l_current_status <> l_to_status_type AND l_current_status <> 0 THEN
280:

Line 291: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Chaning to Unreleased Status'); END IF;

287: -- Change to Unreleased Status
288: /************************************************/
289: IF (l_to_status_type = 1) THEN
290:
291: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Chaning to Unreleased Status'); END IF;
292:
293:
294: IF p_work_order_mode <> EAM_PROCESS_WO_PVT.G_OPR_CREATE and
295: p_to_status_type = wip_constants.unreleased

Line 357: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Chaning to Released or On Hold Status'); END IF;

353:
354: IF (l_to_status_type in (3,6) ) THEN
355:
356:
357: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Chaning to Released or On Hold Status'); END IF;
358:
359: IF (l_current_status in (1,17,3,6,7,9,11,15)) THEN
360:
361: IF (l_to_status_type = 3 ) THEN -- changed check for bug 3681752

Line 460: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Creating osp req at release and po_creation_time correct'); END IF;

456: IF ((l_to_status_type in (3)) AND (l_current_status in (1,6,17))) THEN
457:
458: --IF po_creation_time for workorder is at_job_schedule_release then only create requisitions
459: IF (l_po_creation_time = WIP_CONSTANTS.AT_JOB_SCHEDULE_RELEASE) THEN
460: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Creating osp req at release and po_creation_time correct'); END IF;
461: create_osp_req_at_rel(
462: p_wip_entity_id => l_wip_entity_id,
463: p_organization_id => l_organization_id);
464: END IF; --end of check for po_creation_time

Line 469: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Creating default operation at released'); END IF;

465: END IF;
466:
467: -- End of Creating Requisitions
468:
469: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Creating default operation at released'); END IF;
470:
471: -- Create Default Operation if none exists
472: IF (l_to_status_type = 3) THEN
473:

Line 609: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Creating direct item requisitions at release'); END IF;

605: END;
606:
607: IF l_di_count > 0 THEN
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

Line 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;

623: END IF; -- end of check for l_di_count
624:
625: -- end create requisitions for direct items.
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;

Line 654: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Chaning to Cancel Status'); END IF;

650: /***********************************************************/
651:
652: IF (l_to_status_type = 7) THEN
653:
654: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Chaning to Cancel Status'); END IF;
655:
656: IF (l_current_status in (17,9,1,3,6,15,12)) THEN -- bug#3499973 included status 12(cancelled) for unclose closed work orders to cancelled.
657: l_final_status := l_to_status_type;
658: ELSE

Line 682: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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'
684: , p_token_tbl => l_token_tbl
685: , p_mesg_token_tbl => l_mesg_token_tbl
686: , x_mesg_token_tbl => x_mesg_token_tbl

Line 697: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Chaning to Complete Status'); END IF;

693: /***********************************************************/
694: -- Change between Complete and Complete No Charge Status
695: /***********************************************************/
696: IF (l_to_status_type IN (4,5)) THEN
697: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Chaning to Complete Status'); END IF;
698:
699: IF (l_current_status in (4,5)) THEN
700: l_final_status := l_to_status_type;
701:

Line 719: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Chaning to Closed Status'); END IF;

715: -- Change to Closed Status
716: /***********************************************************/
717:
718: IF (l_to_status_type = 12) THEN
719: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Chaning to Closed Status'); END IF;
720: IF (l_current_status IN (4,5,7)) THEN
721: l_final_status := 14; --set l_final_status to 14(Pending close)
722:
723: BEGIN

Line 763: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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
767: , x_mesg_token_tbl => x_mesg_token_tbl

Line 777: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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
781: , x_mesg_token_tbl => x_mesg_token_tbl

Line 786: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Selecting group_id'); END IF;

782: );
783: return;
784: END;
785: BEGIN
786: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Selecting group_id'); END IF;
787: SELECT wip_dj_close_temp_s.nextval
788: INTO l_gid
789: FROM dual;
790: EXCEPTION

Line 796: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Insert into WIP_DJ_CLOSE_TEMP'); END IF;

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;
797: INSERT INTO WIP_DJ_CLOSE_TEMP
798: (WIP_ENTITY_ID,
799: ORGANIZATION_ID,
800: WIP_ENTITY_NAME,

Line 879: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating WO with status'); END IF;

875: /******************************************************/
876: -- Update WIP_DISCRETE_JOBS with the changed job status
877: /******************************************************/
878:
879: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating WO with status'); END IF;
880:
881: BEGIN
882:
883: UPDATE WIP_DISCRETE_JOBS

Line 899: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Unclosing WO'); END IF;

895: -- Unclose a Job
896: /*******************************************/
897:
898: IF (l_unclose = 1) THEN
899: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Unclosing WO'); END IF;
900:
901: IF WIP_CLOSE_UTILITIES.Unclose_Job(l_wip_entity_id,
902: l_organization_id,
903: l_class_code) = 1 THEN

Line 944: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exiting Status Change API'); END IF;

940:
941: END IF; -- end of check for l_unclose
942:
943: /***********************************************************/
944: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exiting Status Change API'); END IF;
945:
946: -- Standard call to get message count and if count is 1, get message info.
947: fnd_msg_pub.count_and_get(
948: p_count => x_msg_count

Line 951: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Schedule change request id '||l_request_id); END IF;

947: fnd_msg_pub.count_and_get(
948: p_count => x_msg_count
949: ,p_data => x_msg_data);
950:
951: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Schedule change request id '||l_request_id); END IF;
952:
953: x_request_id := l_request_id;
954:
955: EXCEPTION

Line 986: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

982: l_encoded_message := fnd_message.get_encoded();
983: fnd_message.parse_encoded(l_encoded_message,
984: l_application_name,
985: l_mesg_name);
986: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
987: ( p_message_name => l_mesg_name
988: , p_token_tbl => l_token_tbl
989: , p_mesg_token_tbl => l_mesg_token_tbl
990: , x_mesg_token_tbl => x_mesg_token_tbl

Line 1049: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('req for osp op'||cdis_rec.OPERATION_SEQ_NUM); END IF;

1045:
1046: l_call_req_import := 'NO';
1047:
1048: FOR cdis_rec in Cdisc LOOP
1049: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('req for osp op'||cdis_rec.OPERATION_SEQ_NUM); END IF;
1050: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('req for osp resource'||cdis_rec.RESOURCE_SEQ_NUM); END IF;
1051:
1052: --if requisitions are not already created then only create now
1053: /* IF NOT (WIP_OSP.PO_REQ_EXISTS(

Line 1050: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('req for osp resource'||cdis_rec.RESOURCE_SEQ_NUM); END IF;

1046: l_call_req_import := 'NO';
1047:
1048: FOR cdis_rec in Cdisc LOOP
1049: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('req for osp op'||cdis_rec.OPERATION_SEQ_NUM); END IF;
1050: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('req for osp resource'||cdis_rec.RESOURCE_SEQ_NUM); END IF;
1051:
1052: --if requisitions are not already created then only create now
1053: /* IF NOT (WIP_OSP.PO_REQ_EXISTS(
1054: p_wip_entity_id => p_wip_entity_id,

Line 1062: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('create req for osp resource now '); END IF;

1058: p_entity_type => 6)
1059: ) THEN */
1060: l_call_req_import := 'YES'; --call req import later once
1061:
1062: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('create req for osp resource now '); END IF;
1063: BEGIN
1064: WIP_OSP.CREATE_REQUISITION(
1065: P_Wip_Entity_Id => p_wip_entity_id,
1066: P_Organization_Id => p_organization_id,

Line 1076: EAM_ERROR_MESSAGE_PVT.Add_Message

1072: l_wip_error_flag :=1;
1073: l_message := SUBSTR(FND_MESSAGE.get,1,500);
1074: FND_MESSAGE.SET_NAME('WIP', 'WIP_RELEASE_PO_MOVE');
1075: fnd_msg_pub.add;
1076: EAM_ERROR_MESSAGE_PVT.Add_Message
1077: ( p_mesg_text => l_message
1078: , p_entity_id => 1
1079: , p_entity_index => 1
1080: , p_message_type => 'E'

Line 1098: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('No operating unit found'); END IF;

1094: and ho.ORG_INFORMATION_CONTEXT = 'Accounting Information';
1095: EXCEPTION
1096: WHEN NO_DATA_FOUND THEN
1097: ROLLBACK TO create_osp_req_at_rel;
1098: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('No operating unit found'); END IF;
1099: END;
1100:
1101: fnd_request.set_org_id(l_ou_id);
1102:

Line 1116: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('invoke req import program for osp reqs '||l_request_id); END IF;

1112: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1113: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1114: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
1115: ) ;
1116: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('invoke req import program for osp reqs '||l_request_id); END IF;
1117: END IF; --end of check for req import to be called or not
1118:
1119: EXCEPTION
1120:

Line 1123: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('error creating reqs for osp at rel '); END IF;

1119: EXCEPTION
1120:
1121: WHEN OTHERS THEN
1122: ROLLBACK TO create_osp_req_at_rel;
1123: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('error creating reqs for osp at rel '); END IF;
1124: IF (l_wip_error_flag = 1) THEN /*Added for FP 6814440*/
1125: APP_EXCEPTION.RAISE_EXCEPTION;
1126: END IF;
1127: END create_osp_req_at_rel;