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.AHL_UMP_SR_PVT dependencies on CS_SERVICEREQUEST_PVT

Line 204: -- Uses CS_SERVICEREQUEST_PVT.USER_HOOKS_REC to get SR Details.

200: -- Start of Comments --
201: -- Procedure name : Create_SR_Unit_Effectivity
202: -- Type : Private
203: -- Function : Private API to create a SR type unit effectivity. Called by corresponding Public procedure.
204: -- Uses CS_SERVICEREQUEST_PVT.USER_HOOKS_REC to get SR Details.
205: -- Pre-reqs :
206: -- Parameters :
207: -- x_return_status OUT VARCHAR2 Required
208: --

Line 287: l_request_id := cs_servicerequest_pvt.user_hooks_rec.request_id;

283:
284: -- Begin Processing
285:
286: --Getting all the required values from the user hook record
287: l_request_id := cs_servicerequest_pvt.user_hooks_rec.request_id;
288: l_status_flag := cs_servicerequest_pvt.user_hooks_rec.status_flag;
289: l_old_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag;
290: l_new_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag;
291: l_customer_product_id := cs_servicerequest_pvt.user_hooks_rec.customer_product_id;

Line 288: l_status_flag := cs_servicerequest_pvt.user_hooks_rec.status_flag;

284: -- Begin Processing
285:
286: --Getting all the required values from the user hook record
287: l_request_id := cs_servicerequest_pvt.user_hooks_rec.request_id;
288: l_status_flag := cs_servicerequest_pvt.user_hooks_rec.status_flag;
289: l_old_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag;
290: l_new_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag;
291: l_customer_product_id := cs_servicerequest_pvt.user_hooks_rec.customer_product_id;
292: l_status_id := cs_servicerequest_pvt.user_hooks_rec.status_id;

Line 289: l_old_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag;

285:
286: --Getting all the required values from the user hook record
287: l_request_id := cs_servicerequest_pvt.user_hooks_rec.request_id;
288: l_status_flag := cs_servicerequest_pvt.user_hooks_rec.status_flag;
289: l_old_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag;
290: l_new_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag;
291: l_customer_product_id := cs_servicerequest_pvt.user_hooks_rec.customer_product_id;
292: l_status_id := cs_servicerequest_pvt.user_hooks_rec.status_id;
293: l_exp_resolution_date := cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date;

Line 290: l_new_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag;

286: --Getting all the required values from the user hook record
287: l_request_id := cs_servicerequest_pvt.user_hooks_rec.request_id;
288: l_status_flag := cs_servicerequest_pvt.user_hooks_rec.status_flag;
289: l_old_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag;
290: l_new_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag;
291: l_customer_product_id := cs_servicerequest_pvt.user_hooks_rec.customer_product_id;
292: l_status_id := cs_servicerequest_pvt.user_hooks_rec.status_id;
293: l_exp_resolution_date := cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date;
294:

Line 291: l_customer_product_id := cs_servicerequest_pvt.user_hooks_rec.customer_product_id;

287: l_request_id := cs_servicerequest_pvt.user_hooks_rec.request_id;
288: l_status_flag := cs_servicerequest_pvt.user_hooks_rec.status_flag;
289: l_old_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag;
290: l_new_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag;
291: l_customer_product_id := cs_servicerequest_pvt.user_hooks_rec.customer_product_id;
292: l_status_id := cs_servicerequest_pvt.user_hooks_rec.status_id;
293: l_exp_resolution_date := cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date;
294:
295: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 292: l_status_id := cs_servicerequest_pvt.user_hooks_rec.status_id;

288: l_status_flag := cs_servicerequest_pvt.user_hooks_rec.status_flag;
289: l_old_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag;
290: l_new_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag;
291: l_customer_product_id := cs_servicerequest_pvt.user_hooks_rec.customer_product_id;
292: l_status_id := cs_servicerequest_pvt.user_hooks_rec.status_id;
293: l_exp_resolution_date := cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date;
294:
295: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' input values:' );

Line 293: l_exp_resolution_date := cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date;

289: l_old_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag;
290: l_new_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag;
291: l_customer_product_id := cs_servicerequest_pvt.user_hooks_rec.customer_product_id;
292: l_status_id := cs_servicerequest_pvt.user_hooks_rec.status_id;
293: l_exp_resolution_date := cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date;
294:
295: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' input values:' );
297: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Request id::' || cs_servicerequest_pvt.user_hooks_rec.request_id);

Line 297: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Request id::' || cs_servicerequest_pvt.user_hooks_rec.request_id);

293: l_exp_resolution_date := cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date;
294:
295: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' input values:' );
297: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Request id::' || cs_servicerequest_pvt.user_hooks_rec.request_id);
298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Status flag:' || cs_servicerequest_pvt.user_hooks_rec.status_flag);
299: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag);
300: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);
301: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);

Line 298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Status flag:' || cs_servicerequest_pvt.user_hooks_rec.status_flag);

294:
295: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' input values:' );
297: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Request id::' || cs_servicerequest_pvt.user_hooks_rec.request_id);
298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Status flag:' || cs_servicerequest_pvt.user_hooks_rec.status_flag);
299: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag);
300: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);
301: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);
302: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'status id:' || cs_servicerequest_pvt.user_hooks_rec.status_id);

Line 299: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag);

295: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' input values:' );
297: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Request id::' || cs_servicerequest_pvt.user_hooks_rec.request_id);
298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Status flag:' || cs_servicerequest_pvt.user_hooks_rec.status_flag);
299: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag);
300: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);
301: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);
302: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'status id:' || cs_servicerequest_pvt.user_hooks_rec.status_id);
303: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'exp_resolution_date:' || cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date);

Line 300: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);

296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' input values:' );
297: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Request id::' || cs_servicerequest_pvt.user_hooks_rec.request_id);
298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Status flag:' || cs_servicerequest_pvt.user_hooks_rec.status_flag);
299: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag);
300: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);
301: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);
302: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'status id:' || cs_servicerequest_pvt.user_hooks_rec.status_id);
303: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'exp_resolution_date:' || cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date);
304: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'incident_occurred_date:' || cs_servicerequest_pvt.user_hooks_rec.incident_occurred_date);

Line 301: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);

297: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Request id::' || cs_servicerequest_pvt.user_hooks_rec.request_id);
298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Status flag:' || cs_servicerequest_pvt.user_hooks_rec.status_flag);
299: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag);
300: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);
301: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);
302: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'status id:' || cs_servicerequest_pvt.user_hooks_rec.status_id);
303: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'exp_resolution_date:' || cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date);
304: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'incident_occurred_date:' || cs_servicerequest_pvt.user_hooks_rec.incident_occurred_date);
305: END IF;

Line 302: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'status id:' || cs_servicerequest_pvt.user_hooks_rec.status_id);

298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Status flag:' || cs_servicerequest_pvt.user_hooks_rec.status_flag);
299: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag);
300: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);
301: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);
302: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'status id:' || cs_servicerequest_pvt.user_hooks_rec.status_id);
303: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'exp_resolution_date:' || cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date);
304: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'incident_occurred_date:' || cs_servicerequest_pvt.user_hooks_rec.incident_occurred_date);
305: END IF;
306:

Line 303: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'exp_resolution_date:' || cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date);

299: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag);
300: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);
301: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);
302: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'status id:' || cs_servicerequest_pvt.user_hooks_rec.status_id);
303: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'exp_resolution_date:' || cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date);
304: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'incident_occurred_date:' || cs_servicerequest_pvt.user_hooks_rec.incident_occurred_date);
305: END IF;
306:
307:

Line 304: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'incident_occurred_date:' || cs_servicerequest_pvt.user_hooks_rec.incident_occurred_date);

300: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);
301: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);
302: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'status id:' || cs_servicerequest_pvt.user_hooks_rec.status_id);
303: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'exp_resolution_date:' || cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date);
304: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'incident_occurred_date:' || cs_servicerequest_pvt.user_hooks_rec.incident_occurred_date);
305: END IF;
306:
307:
308: --******************************

Line 581: -- Uses CS_SERVICEREQUEST_PVT.USER_HOOKS_REC to get SR Details.

577: -- Type : Private
578: -- Function : Private API to process changes to a (current or former) CMRO type SR
579: -- by adding, removing or updating SR type unit effectivities.
580: -- Called by the corresponding public procedure.
581: -- Uses CS_SERVICEREQUEST_PVT.USER_HOOKS_REC to get SR Details.
582: -- Pre-reqs :
583: -- Parameters :
584: -- x_return_status OUT VARCHAR2 Required
585: --

Line 615: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag ||

611:
612: -- JR: Added the following log on 10/21/2003 to help in debugging
613: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
614: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Relevant User Hook Record (input) Values: ' );
615: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag ||
616: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag ||
617: ', request_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id ||
618: ', status_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id ||
619: ', status_flag = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag ||

Line 616: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag ||

612: -- JR: Added the following log on 10/21/2003 to help in debugging
613: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
614: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Relevant User Hook Record (input) Values: ' );
615: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag ||
616: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag ||
617: ', request_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id ||
618: ', status_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id ||
619: ', status_flag = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag ||
620: ', customer_product_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.customer_product_id ||

Line 617: ', request_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id ||

613: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
614: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Relevant User Hook Record (input) Values: ' );
615: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag ||
616: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag ||
617: ', request_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id ||
618: ', status_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id ||
619: ', status_flag = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag ||
620: ', customer_product_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.customer_product_id ||
621: ', exp_resolution_date = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.exp_resolution_date);

Line 618: ', status_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id ||

614: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Relevant User Hook Record (input) Values: ' );
615: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag ||
616: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag ||
617: ', request_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id ||
618: ', status_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id ||
619: ', status_flag = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag ||
620: ', customer_product_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.customer_product_id ||
621: ', exp_resolution_date = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.exp_resolution_date);
622: END IF;

Line 619: ', status_flag = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag ||

615: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag ||
616: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag ||
617: ', request_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id ||
618: ', status_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id ||
619: ', status_flag = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag ||
620: ', customer_product_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.customer_product_id ||
621: ', exp_resolution_date = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.exp_resolution_date);
622: END IF;
623:

Line 620: ', customer_product_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.customer_product_id ||

616: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag ||
617: ', request_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id ||
618: ', status_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id ||
619: ', status_flag = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag ||
620: ', customer_product_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.customer_product_id ||
621: ', exp_resolution_date = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.exp_resolution_date);
622: END IF;
623:
624: -- Initialize API return status to success

Line 621: ', exp_resolution_date = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.exp_resolution_date);

617: ', request_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id ||
618: ', status_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id ||
619: ', status_flag = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag ||
620: ', customer_product_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.customer_product_id ||
621: ', exp_resolution_date = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.exp_resolution_date);
622: END IF;
623:
624: -- Initialize API return status to success
625: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 632: IF NOT (NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag, G_NO_FLAG) = G_YES_FLAG OR

628: --AMSRINIV. Bug 5470730. Removing message initialization.
629: --FND_MSG_PUB.Initialize;
630:
631: -- Begin Processing
632: IF NOT (NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag, G_NO_FLAG) = G_YES_FLAG OR
633: NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag, G_NO_FLAG)= G_YES_FLAG) THEN
634: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Not a CMRO Type Service Request.');
636: END IF;

Line 633: NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag, G_NO_FLAG)= G_YES_FLAG) THEN

629: --FND_MSG_PUB.Initialize;
630:
631: -- Begin Processing
632: IF NOT (NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag, G_NO_FLAG) = G_YES_FLAG OR
633: NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag, G_NO_FLAG)= G_YES_FLAG) THEN
634: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Not a CMRO Type Service Request.');
636: END IF;
637: -- Not a CMRO Type Service Request

Line 642: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'From USER_HOOKS_REC: old_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag ||

638: -- Just return 'SUCCESS' without doing any processing.
639: l_skip_processing := true;
640: ELSE
641: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
642: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'From USER_HOOKS_REC: old_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag ||
643: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag);
644: END IF;
645: END IF;
646:

Line 643: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag);

639: l_skip_processing := true;
640: ELSE
641: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
642: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'From USER_HOOKS_REC: old_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag ||
643: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag);
644: END IF;
645: END IF;
646:
647: IF (l_skip_processing = false) THEN

Line 648: IF (NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag, G_NO_FLAG) = G_YES_FLAG) THEN

644: END IF;
645: END IF;
646:
647: IF (l_skip_processing = false) THEN
648: IF (NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag, G_NO_FLAG) = G_YES_FLAG) THEN
649: -- Since this is a CMRO type SR, ensure that the Application Usage profile option has been set to AHL
650: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,
651: x_return_status => x_return_status);
652:

Line 679: IF (NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag, G_NO_FLAG) <> NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag, G_NO_FLAG)) THEN

675: Validate_Request_For_Update(x_sr_ue_id => l_sr_ue_id,
676: x_sr_ue_ovn => l_sr_ue_ovn,
677: x_defer_from_ue_id => l_defer_from_ue_id);
678:
679: IF (NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag, G_NO_FLAG) <> NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag, G_NO_FLAG)) THEN
680: -- Handle Type Change
681: Handle_Type_Change(p_sr_ue_id => l_sr_ue_id,
682: p_defer_from_ue_id => l_defer_from_ue_id);
683:

Line 2541: WHERE INCIDENT_ID = CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id;

2537: x_defer_from_ue_id OUT NOCOPY NUMBER) IS
2538:
2539: CURSOR check_request_exists_csr IS
2540: SELECT 'x' FROM CS_INCIDENTS
2541: WHERE INCIDENT_ID = CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id;
2542:
2543: CURSOR get_ue_dtls_csr IS
2544: SELECT UNIT_EFFECTIVITY_ID, OBJECT_VERSION_NUMBER, DEFER_FROM_UE_ID
2545: FROM AHL_UNIT_EFFECTIVITIES_APP_V

Line 2546: WHERE CS_INCIDENT_ID = CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id

2542:
2543: CURSOR get_ue_dtls_csr IS
2544: SELECT UNIT_EFFECTIVITY_ID, OBJECT_VERSION_NUMBER, DEFER_FROM_UE_ID
2545: FROM AHL_UNIT_EFFECTIVITIES_APP_V
2546: WHERE CS_INCIDENT_ID = CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id
2547: AND (STATUS_CODE IS NULL OR STATUS_CODE NOT IN (G_UMP_DEFERRED_STATUS, G_UMP_EXCEPTION_STATUS));
2548:
2549: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Validate_Request_For_Update';
2550:

Line 2559: IF(CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id IS NULL) THEN

2555: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2556: END IF;
2557:
2558: -- Ensure that request id is not null
2559: IF(CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id IS NULL) THEN
2560: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_NULL');
2561: FND_MSG_PUB.ADD;
2562: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2563: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 2574: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);

2570: FETCH check_request_exists_csr INTO l_dummy;
2571: IF(check_request_exists_csr%NOTFOUND) THEN
2572: CLOSE check_request_exists_csr;
2573: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_INVALID');
2574: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);
2575: FND_MSG_PUB.ADD;
2576: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2577: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2578: END IF;

Line 2584: IF (NVL(CS_SERVICEREQUEST_PVT.user_hooks_rec.old_type_cmro_flag, G_NO_FLAG) = G_YES_FLAG) THEN

2580: END IF;
2581: CLOSE check_request_exists_csr;
2582:
2583: -- If already a CMRO SR, ensure that an unit effectivity exists for the SR
2584: IF (NVL(CS_SERVICEREQUEST_PVT.user_hooks_rec.old_type_cmro_flag, G_NO_FLAG) = G_YES_FLAG) THEN
2585: -- apattark added x_defer_from_ue_id for bug #9166304
2586: OPEN get_ue_dtls_csr;
2587: FETCH get_ue_dtls_csr INTO x_sr_ue_id, x_sr_ue_ovn, x_defer_from_ue_id;
2588: IF (get_ue_dtls_csr%NOTFOUND) THEN

Line 2591: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);

2587: FETCH get_ue_dtls_csr INTO x_sr_ue_id, x_sr_ue_ovn, x_defer_from_ue_id;
2588: IF (get_ue_dtls_csr%NOTFOUND) THEN
2589: CLOSE get_ue_dtls_csr;
2590: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_INVALID');
2591: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);
2592: FND_MSG_PUB.ADD;
2593: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2594: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2595: END IF;

Line 2597: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Could not find any valid Unit Effectivity for this CS_INCIDENT_ID: ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);

2593: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2594: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2595: END IF;
2596: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2597: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Could not find any valid Unit Effectivity for this CS_INCIDENT_ID: ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);
2598: END IF;
2599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2600: END IF; -- UE Not Found
2601: CLOSE get_ue_dtls_csr;

Line 2640: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag = G_SR_CLOSED_FLAG) THEN

2636: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2637: END IF;
2638:
2639: -- Ensure that the SR is not closed
2640: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag = G_SR_CLOSED_FLAG) THEN
2641: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_CLOSED');
2642: FND_MSG_PUB.ADD;
2643: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2644: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 2649: IF (NVL(CS_SERVICEREQUEST_PVT.user_hooks_rec.new_type_cmro_flag, G_NO_FLAG) = G_NO_FLAG) THEN

2645: END IF;
2646: RAISE FND_API.G_EXC_ERROR;
2647: END IF;
2648:
2649: IF (NVL(CS_SERVICEREQUEST_PVT.user_hooks_rec.new_type_cmro_flag, G_NO_FLAG) = G_NO_FLAG) THEN
2650: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2651: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'CMRO to Non-CMRO type conversion');
2652: END IF;
2653: -- CMRO to Non-CMRO type

Line 2665: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN

2661: RAISE FND_API.G_EXC_ERROR;
2662: END IF;
2663: -- apattark end changes for bug #9166304
2664: -- JR: Modified on 10/29/2003 (Using Status Id instead of Status Code)
2665: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
2666: OPEN get_tasks_for_ue_csr;
2667: FETCH get_tasks_for_ue_csr INTO l_dummy;
2668: IF (get_tasks_for_ue_csr%FOUND) THEN
2669: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_ASGND_TO_VISIT');

Line 2712: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN

2708: -- Non-CMRO to CMRO type
2709: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2710: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Non-CMRO to CMRO type conversion');
2711: END IF;
2712: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
2713: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_PLANNED');
2714: FND_MSG_PUB.ADD;
2715: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2716: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 2772: l_new_instance NUMBER := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.customer_product_id;

2768: l_old_instance NUMBER;
2769: l_old_due_date DATE;
2770: l_old_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2771: l_valid_flag BOOLEAN := true;
2772: l_new_instance NUMBER := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.customer_product_id;
2773: l_new_ue_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2774: l_new_due_date DATE := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.exp_resolution_date;
2775: l_assigned BOOLEAN;
2776: l_new_tolerance_flag VARCHAR2(1);

Line 2774: l_new_due_date DATE := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.exp_resolution_date;

2770: l_old_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2771: l_valid_flag BOOLEAN := true;
2772: l_new_instance NUMBER := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.customer_product_id;
2773: l_new_ue_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2774: l_new_due_date DATE := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.exp_resolution_date;
2775: l_assigned BOOLEAN;
2776: l_new_tolerance_flag VARCHAR2(1);
2777: --apattark added for bug #9166304
2778: l_defer_from_ue_id NUMBER;

Line 2919: l_new_instance_id NUMBER := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.customer_product_id;

2915:
2916: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Handle_Instance_Change';
2917:
2918: l_temp_count NUMBER := 0;
2919: l_new_instance_id NUMBER := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.customer_product_id;
2920:
2921: BEGIN
2922: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2923: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

Line 2950: IF (CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.status_flag = G_SR_CLOSED_FLAG) THEN

2946: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2947: END IF;
2948: END IF;
2949: --apattark end changes for bug #9166304
2950: IF (CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.status_flag = G_SR_CLOSED_FLAG) THEN
2951: p_x_valid_flag := false;
2952: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_CHG_CLOSED');
2953: FND_MSG_PUB.ADD;
2954: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2958: ELSIF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN

2954: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2955: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2956: END IF;
2957:
2958: ELSIF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
2959: p_x_valid_flag := false;
2960: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_CHG_PLANNED');
2961: FND_MSG_PUB.ADD;
2962: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3023: IF (CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.status_flag = G_SR_CLOSED_FLAG) THEN

3019: END IF;
3020: -- Initialize the Status Changed Flag to false
3021: x_status_changed := false;
3022:
3023: IF (CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.status_flag = G_SR_CLOSED_FLAG) THEN
3024: -- SR is or is being Closed
3025: OPEN get_tasks_for_ue_csr;
3026: FETCH get_tasks_for_ue_csr INTO l_dummy;
3027: IF(get_tasks_for_ue_csr%FOUND) THEN

Line 3087: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN

3083: ELSE
3084: l_assigned := false;
3085: END IF;
3086: CLOSE get_tasks_for_ue_csr;
3087: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
3088: IF (l_assigned = false) THEN
3089: -- SR is being moved to Planned status without assigning SR UE to any visit
3090: p_x_valid_flag := false;
3091: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_NOT_ASSND');

Line 3216: --l_sr_summary := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.summary;

3212: -- Manually fetching the SR Summary from UE table because SR doesnt
3213: OPEN c_get_SR_details(p_sr_ue_id);
3214: FETCH c_get_SR_details INTO l_sr_summary, l_sr_type;
3215: CLOSE c_get_SR_details;
3216: --l_sr_summary := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.summary;
3217: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3218:
3219: FND_LOG.STRING(
3220: FND_LOG.LEVEL_STATEMENT,