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 143: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('=============================================== '); END IF;

139:
140: BEGIN
141:
142: -- Standard Start of API savepoint
143: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('=============================================== '); END IF;
144: 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: Entering Status Change Package '); END IF;
145:
146: SAVEPOINT change_status;
147:

Line 144: 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: Entering Status Change Package '); END IF;

140: BEGIN
141:
142: -- Standard Start of API savepoint
143: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('=============================================== '); END IF;
144: 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: Entering Status Change Package '); END IF;
145:
146: SAVEPOINT change_status;
147:
148: -- Standard call to check for call compatibility.

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

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

Line 170: 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: Entering Status Change API body'); END IF;

166:
167: x_mesg_token_tbl := l_mesg_token_tbl;
168:
169:
170: 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: Entering Status Change API body'); END IF;
171:
172: /********************************************************************/
173: -- API body
174:

Line 187: 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: Validating Status'); END IF;

183: FROM wip_entities
184: WHERE wip_entity_id = p_wip_entity_id;
185:
186: -- Validate status_id
187: 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: Validating Status'); END IF;
188:
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

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

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

Line 245: 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: Current WO Status: '||l_current_status||' To Status: '||l_to_status_type); END IF;

241: l_firm_flag := 2;
242: END;
243: l_final_status := l_current_status;
244:
245: 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: Current WO Status: '||l_current_status||' To Status: '||l_to_status_type); END IF;
246:
247: -- Determine whether it is a rebuild work order
248: 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: Checking if this is a rebuild WO'); END IF;
249:

Line 248: 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: Checking if this is a rebuild WO'); END IF;

244:
245: 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: Current WO Status: '||l_current_status||' To Status: '||l_to_status_type); END IF;
246:
247: -- Determine whether it is a rebuild work order
248: 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: Checking if this is a rebuild WO'); END IF;
249:
250: IF(l_rebuild_item_id > 0) THEN
251: l_rebuild_flag := 'Y';
252: ELSIF (l_asset_group_id > 0) THEN

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

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:
260: -- Get WPS Parameters
261: -- WPS parameters
262: 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: Getting WPS parameters'); END IF;

Line 262: 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: Getting WPS parameters'); END IF;

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:
260: -- Get WPS Parameters
261: -- WPS parameters
262: 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: Getting WPS parameters'); END IF;
263:
264: IF(WPS_COMMON.Get_Install_Status = 'I') THEN
265: WPS_COMMON.GetParameters(
266: P_Org_Id => l_organization_id,

Line 282: 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: Checking if status change is allowed'); END IF;

278: -- Direct Change to Pending Bill Load, Failed Bill Load, Pending Routing Load,
279: -- Failed Routing Load, Pending - Mass Loaded, Pending Close, Failed Close
280: -- Pending Scheduling and Draft not Possible.
281:
282: 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: Checking if status change is allowed'); END IF;
283:
284: IF (l_to_status_type in (8,9,10,11,13,14,15,16,17)) THEN
285: IF l_current_status <> l_to_status_type AND l_current_status <> 0 THEN
286:

Line 297: 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: Changing to Unreleased Status'); END IF;

293: -- Change to Unreleased Status
294: /************************************************/
295: IF (l_to_status_type = 1) THEN
296:
297: 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: Changing to Unreleased Status'); END IF;
298:
299:
300: IF p_work_order_mode <> EAM_PROCESS_WO_PVT.G_OPR_CREATE and
301: p_to_status_type = wip_constants.unreleased

Line 370: 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: Changing to Released or On Hold Status'); END IF;

366:
367: IF (l_to_status_type in (3,6) ) THEN
368:
369:
370: 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: Changing to Released or On Hold Status'); END IF;
371:
372: IF (l_current_status in (1,17,3,6,7,9,11,15)) THEN
373:
374: IF (l_to_status_type = 3 ) THEN -- changed check for bug 3681752

Line 502: 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 osp req at release and po_creation_time correct'); END IF;

498: IF ((l_to_status_type in (3)) AND (l_current_status in (1,6,17))) THEN
499:
500: --IF po_creation_time for workorder is at_job_schedule_release then only create requisitions
501: IF (l_po_creation_time = WIP_CONSTANTS.AT_JOB_SCHEDULE_RELEASE) THEN
502: 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 osp req at release and po_creation_time correct'); END IF;
503: create_osp_req_at_rel(
504: p_wip_entity_id => l_wip_entity_id,
505: p_organization_id => l_organization_id); -- for Bug 8594830
506: END IF; --end of check for po_creation_time

Line 511: 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 default operation at released'); END IF;

507: END IF;
508:
509: -- End of Creating Requisitions
510:
511: 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 default operation at released'); END IF;
512:
513: -- Create Default Operation if none exists
514: IF (l_to_status_type = 3) THEN
515:

Line 623: 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: Check for Requisition creation'); END IF;

619: END IF;
620:
621: IF (l_to_status_type in (3) ) THEN -- Added the check for bug 13102446
622: -- create requisitions for direct items.
623: 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: Check for Requisition creation'); END IF;
624:
625: -- Bug # 4862404 : Replace eam_direct_item_recs_v by base table
626:
627: BEGIN

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

650: END;
651:
652: IF l_di_count > 0 THEN
653:
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

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

651:
652: IF l_di_count > 0 THEN
653:
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

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

669: END IF; -- end of check for l_di_count
670:
671: -- end create requisitions for direct items.
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;

Line 700: 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: Chaning to Cancel Status'); END IF;

696: /***********************************************************/
697:
698: IF (l_to_status_type = 7) THEN
699:
700: 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: Chaning to Cancel Status'); END IF;
701:
702: 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.
703: l_final_status := l_to_status_type;
704: ELSE

Line 728: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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'
730: , p_token_tbl => l_token_tbl
731: , p_mesg_token_tbl => l_mesg_token_tbl
732: , x_mesg_token_tbl => x_mesg_token_tbl

Line 743: 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: Chaning to Complete Status'); END IF;

739: /***********************************************************/
740: -- Change between Complete and Complete No Charge Status
741: /***********************************************************/
742: IF (l_to_status_type IN (4,5)) THEN
743: 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: Chaning to Complete Status'); END IF;
744:
745: IF (l_current_status in (4,5)) THEN
746: l_final_status := l_to_status_type;
747:

Line 765: 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: Chaning to Closed Status'); END IF;

761: -- Change to Closed Status
762: /***********************************************************/
763:
764: IF (l_to_status_type = 12) THEN
765: 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: Chaning to Closed Status'); END IF;
766: IF (l_current_status IN (4,5,7)) THEN
767: l_final_status := 14; --set l_final_status to 14(Pending close)
768:
769: BEGIN

Line 810: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

Line 824: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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

Line 833: 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: Selecting group_id'); END IF;

829: );
830: return;
831: END;
832: BEGIN
833: 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: Selecting group_id'); END IF;
834: SELECT wip_dj_close_temp_s.nextval
835: INTO l_gid
836: FROM dual;
837: EXCEPTION

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

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;
844: INSERT INTO WIP_DJ_CLOSE_TEMP
845: (WIP_ENTITY_ID,
846: ORGANIZATION_ID,
847: WIP_ENTITY_NAME,

Line 926: 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: Updating WO with status'); END IF;

922: /******************************************************/
923: -- Update WIP_DISCRETE_JOBS with the changed job status
924: /******************************************************/
925:
926: 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: Updating WO with status'); END IF;
927:
928: BEGIN
929:
930: UPDATE WIP_DISCRETE_JOBS

Line 946: 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: Unclosing WO'); END IF;

942: -- Unclose a Job
943: /*******************************************/
944:
945: IF (l_unclose = 1) THEN
946: 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: Unclosing WO'); END IF;
947:
948: IF WIP_CLOSE_UTILITIES.Unclose_Job(l_wip_entity_id,
949: l_organization_id,
950: l_class_code) = 1 THEN

Line 991: 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: Exiting Status Change API'); END IF;

987:
988: END IF; -- end of check for l_unclose
989:
990: /***********************************************************/
991: 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: Exiting Status Change API'); END IF;
992:
993: -- Standard call to get message count and if count is 1, get message info.
994: fnd_msg_pub.count_and_get(
995: p_count => x_msg_count

Line 998: 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: Schedule change request id '||l_request_id); END IF;

994: fnd_msg_pub.count_and_get(
995: p_count => x_msg_count
996: ,p_data => x_msg_data);
997:
998: 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: Schedule change request id '||l_request_id); END IF;
999:
1000: x_request_id := l_request_id;
1001:
1002: EXCEPTION

Line 1033: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1029: l_encoded_message := fnd_message.get_encoded();
1030: fnd_message.parse_encoded(l_encoded_message,
1031: l_application_name,
1032: l_mesg_name);
1033: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1034: ( p_message_name => l_mesg_name
1035: , p_token_tbl => l_token_tbl
1036: , p_mesg_token_tbl => l_mesg_token_tbl
1037: , x_mesg_token_tbl => x_mesg_token_tbl

Line 1094: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('===============EAM_WO_CHANGE_STATUS_PVT.create_osp_req_at_rel============= '); END IF;

1090: errbuf varchar2(2000);
1091: l_str_application_id VARCHAR2(30);
1092: l_req_import_group_by VARCHAR2(50);
1093: BEGIN
1094: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('===============EAM_WO_CHANGE_STATUS_PVT.create_osp_req_at_rel============= '); END IF;
1095: SAVEPOINT create_osp_req_at_rel;
1096:
1097: l_call_req_import := 'NO';
1098:

Line 1100: 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.create_osp_req_at_rel'); END IF;

1096:
1097: l_call_req_import := 'NO';
1098:
1099: FOR cdis_rec in Cdisc LOOP
1100: 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.create_osp_req_at_rel'); END IF;
1101: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' req for osp op : '||cdis_rec.OPERATION_SEQ_NUM||' osp resource : '||cdis_rec.RESOURCE_SEQ_NUM); END IF;
1102: --start for Bug 8594830
1103: --if requisitions are not already created then only create now
1104: IF ( NOT PO_REQ_EXISTS(

Line 1101: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' req for osp op : '||cdis_rec.OPERATION_SEQ_NUM||' osp resource : '||cdis_rec.RESOURCE_SEQ_NUM); END IF;

1097: l_call_req_import := 'NO';
1098:
1099: FOR cdis_rec in Cdisc LOOP
1100: 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.create_osp_req_at_rel'); END IF;
1101: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' req for osp op : '||cdis_rec.OPERATION_SEQ_NUM||' osp resource : '||cdis_rec.RESOURCE_SEQ_NUM); END IF;
1102: --start for Bug 8594830
1103: --if requisitions are not already created then only create now
1104: IF ( NOT PO_REQ_EXISTS(
1105: p_wip_entity_id => p_wip_entity_id,

Line 1113: 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.create_osp_req_at_rel: create req for osp resource now '); END IF;

1109: p_res_seq_num => cdis_rec.RESOURCE_SEQ_NUM,
1110: p_entity_type => 6)) THEN -- end for Bug 8594830
1111: l_call_req_import := 'YES'; --Do not call Req Import, if the status change is from hold to release and Requisition already exists
1112:
1113: 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.create_osp_req_at_rel: create req for osp resource now '); END IF;
1114: BEGIN
1115: WIP_OSP.CREATE_REQUISITION(
1116: P_Wip_Entity_Id => p_wip_entity_id,
1117: P_Organization_Id => p_organization_id,

Line 1127: EAM_ERROR_MESSAGE_PVT.Add_Message

1123: l_wip_error_flag :=1;
1124: l_message := SUBSTR(FND_MESSAGE.get,1,500);
1125: FND_MESSAGE.SET_NAME('WIP', 'WIP_RELEASE_PO_MOVE');
1126: fnd_msg_pub.add;
1127: EAM_ERROR_MESSAGE_PVT.Add_Message
1128: ( p_mesg_text => l_message
1129: , p_entity_id => 1
1130: , p_entity_index => 1
1131: , p_message_type => 'E'

Line 1139: 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.create_osp_req_at_rel: invoking req import program'); END IF;

1135: END IF; --end of check if reqs exist or not --for 8594830
1136: END LOOP;
1137:
1138: IF (l_call_req_import = 'YES') THEN -- if req import has to be callled
1139: 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.create_osp_req_at_rel: invoking req import program'); END IF;
1140:
1141: BEGIN
1142: select to_number(ho.ORG_INFORMATION3)
1143: into l_ou_id

Line 1150: 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.create_osp_req_at_rel: No operating unit found'); END IF;

1146: and ho.ORG_INFORMATION_CONTEXT = 'Accounting Information';
1147: EXCEPTION
1148: WHEN NO_DATA_FOUND THEN
1149: ROLLBACK TO create_osp_req_at_rel;
1150: 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.create_osp_req_at_rel: No operating unit found'); END IF;
1151: END;
1152:
1153: fnd_request.set_org_id(l_ou_id);
1154:

Line 1156: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.create_osp_req_at_rel: user_id:'||fnd_global.user_id || 'resp_id:'||fnd_global.resp_id||' appl id:'||FND_GLOBAL.PROG_APPL_ID);

1152:
1153: fnd_request.set_org_id(l_ou_id);
1154:
1155: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
1156: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.create_osp_req_at_rel: user_id:'||fnd_global.user_id || 'resp_id:'||fnd_global.resp_id||' appl id:'||FND_GLOBAL.PROG_APPL_ID);
1157: END IF;
1158:
1159: l_status := fnd_request.set_options(datagroup => 'Standard');
1160: 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.create_osp_req_at_rel: set_options is set '); END IF;

Line 1160: 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.create_osp_req_at_rel: set_options is set '); END IF;

1156: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.create_osp_req_at_rel: user_id:'||fnd_global.user_id || 'resp_id:'||fnd_global.resp_id||' appl id:'||FND_GLOBAL.PROG_APPL_ID);
1157: END IF;
1158:
1159: l_status := fnd_request.set_options(datagroup => 'Standard');
1160: 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.create_osp_req_at_rel: set_options is set '); END IF;
1161:
1162: l_str_application_id := fnd_profile.value('RESP_APPL_ID');
1163:
1164: if (fnd_global.user_id is not null and fnd_global.resp_id is not null and l_str_application_id is not null) then

Line 1166: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.create_osp_req_at_rel: calling FND_GLOBAL.APPS_INITIALIZE ');

1162: l_str_application_id := fnd_profile.value('RESP_APPL_ID');
1163:
1164: if (fnd_global.user_id is not null and fnd_global.resp_id is not null and l_str_application_id is not null) then
1165: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
1166: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.create_osp_req_at_rel: calling FND_GLOBAL.APPS_INITIALIZE ');
1167: END IF;
1168:
1169: FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id, fnd_global.resp_id, to_number(l_str_application_id),0);
1170: end if;

Line 1173: EAM_ERROR_MESSAGE_PVT.Write_Debug(' EAM_WO_CHANGE_STATUS_PVT.create_osp_req_at_rel: user_id:'||fnd_global.user_id || 'resp_id:'||fnd_global.resp_id||' appl id:'||FND_GLOBAL.PROG_APPL_ID||' Strappid:'||l_str_application_id);

1169: FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id, fnd_global.resp_id, to_number(l_str_application_id),0);
1170: end if;
1171:
1172: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
1173: EAM_ERROR_MESSAGE_PVT.Write_Debug(' EAM_WO_CHANGE_STATUS_PVT.create_osp_req_at_rel: user_id:'||fnd_global.user_id || 'resp_id:'||fnd_global.resp_id||' appl id:'||FND_GLOBAL.PROG_APPL_ID||' Strappid:'||l_str_application_id);
1174: END IF;
1175:
1176: SELECT REQIMPORT_GROUP_BY_CODE into l_req_import_group_by FROM PO_SYSTEM_PARAMETERS_ALL where ORG_ID=l_ou_id;
1177:

Line 1191: 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.create_osp_req_at_rel: Launced req import program for osp resource : request id : '||l_request_id); END IF;

1187: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1188: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1189: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
1190: ) ;
1191: 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.create_osp_req_at_rel: Launced req import program for osp resource : request id : '||l_request_id); END IF;
1192: errbuf := fnd_message.get;
1193: 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.create_osp_req_at_rel: Error msg: '||errbuf); END IF;
1194:
1195: END IF; --end of check for req import to be called or not

Line 1193: 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.create_osp_req_at_rel: Error msg: '||errbuf); END IF;

1189: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
1190: ) ;
1191: 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.create_osp_req_at_rel: Launced req import program for osp resource : request id : '||l_request_id); END IF;
1192: errbuf := fnd_message.get;
1193: 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.create_osp_req_at_rel: Error msg: '||errbuf); END IF;
1194:
1195: END IF; --end of check for req import to be called or not
1196:
1197: EXCEPTION

Line 1201: 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.create_osp_req_at_rel: error creating reqs for osp at rel '); END IF;

1197: EXCEPTION
1198:
1199: WHEN OTHERS THEN
1200: ROLLBACK TO create_osp_req_at_rel;
1201: 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.create_osp_req_at_rel: error creating reqs for osp at rel '); END IF;
1202: IF (l_wip_error_flag = 1) THEN /*Added for FP 6814440*/
1203: APP_EXCEPTION.RAISE_EXCEPTION;
1204: END IF;
1205: END create_osp_req_at_rel;

Line 1244: EAM_ERROR_MESSAGE_PVT.Write_Debug('===============EAM_WO_CHANGE_STATUS_PVT.PO_REQ_EXISTS ============= ');

1240: po_req_exist VARCHAR2(20);
1241:
1242: begin
1243: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
1244: EAM_ERROR_MESSAGE_PVT.Write_Debug('===============EAM_WO_CHANGE_STATUS_PVT.PO_REQ_EXISTS ============= ');
1245: END IF;
1246:
1247: /*FOR DISCRETE, OSFM, AND EAM*/
1248: OPEN disc_check_po_req_cur;

Line 1254: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.PO_REQ_EXISTS : Yes ');

1250:
1251: IF (disc_check_po_req_cur%FOUND) THEN
1252: CLOSE disc_check_po_req_cur;
1253: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
1254: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.PO_REQ_EXISTS : Yes ');
1255: END IF;
1256:
1257: return TRUE;
1258: ELSE

Line 1261: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.PO_REQ_EXISTS : No');

1257: return TRUE;
1258: ELSE
1259: CLOSE disc_check_po_req_cur;
1260: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
1261: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.PO_REQ_EXISTS : No');
1262: END IF;
1263: return FALSE;
1264: END IF;
1265: