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 196: -- Uses CS_SERVICEREQUEST_PVT.USER_HOOKS_REC to get SR Details.

192: -- Start of Comments --
193: -- Procedure name : Create_SR_Unit_Effectivity
194: -- Type : Private
195: -- Function : Private API to create a SR type unit effectivity. Called by corresponding Public procedure.
196: -- Uses CS_SERVICEREQUEST_PVT.USER_HOOKS_REC to get SR Details.
197: -- Pre-reqs :
198: -- Parameters :
199: -- x_return_status OUT VARCHAR2 Required
200: --

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

266:
267: -- Begin Processing
268:
269: --Getting all the required values from the user hook record
270: l_request_id := cs_servicerequest_pvt.user_hooks_rec.request_id;
271: l_status_flag := cs_servicerequest_pvt.user_hooks_rec.status_flag;
272: l_old_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag;
273: l_new_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag;
274: l_customer_product_id := cs_servicerequest_pvt.user_hooks_rec.customer_product_id;

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

267: -- Begin Processing
268:
269: --Getting all the required values from the user hook record
270: l_request_id := cs_servicerequest_pvt.user_hooks_rec.request_id;
271: l_status_flag := cs_servicerequest_pvt.user_hooks_rec.status_flag;
272: l_old_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag;
273: l_new_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag;
274: l_customer_product_id := cs_servicerequest_pvt.user_hooks_rec.customer_product_id;
275: l_status_id := cs_servicerequest_pvt.user_hooks_rec.status_id;

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

268:
269: --Getting all the required values from the user hook record
270: l_request_id := cs_servicerequest_pvt.user_hooks_rec.request_id;
271: l_status_flag := cs_servicerequest_pvt.user_hooks_rec.status_flag;
272: l_old_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag;
273: l_new_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag;
274: l_customer_product_id := cs_servicerequest_pvt.user_hooks_rec.customer_product_id;
275: l_status_id := cs_servicerequest_pvt.user_hooks_rec.status_id;
276: l_exp_resolution_date := cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date;

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

269: --Getting all the required values from the user hook record
270: l_request_id := cs_servicerequest_pvt.user_hooks_rec.request_id;
271: l_status_flag := cs_servicerequest_pvt.user_hooks_rec.status_flag;
272: l_old_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag;
273: l_new_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag;
274: l_customer_product_id := cs_servicerequest_pvt.user_hooks_rec.customer_product_id;
275: l_status_id := cs_servicerequest_pvt.user_hooks_rec.status_id;
276: l_exp_resolution_date := cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date;
277:

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

270: l_request_id := cs_servicerequest_pvt.user_hooks_rec.request_id;
271: l_status_flag := cs_servicerequest_pvt.user_hooks_rec.status_flag;
272: l_old_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag;
273: l_new_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag;
274: l_customer_product_id := cs_servicerequest_pvt.user_hooks_rec.customer_product_id;
275: l_status_id := cs_servicerequest_pvt.user_hooks_rec.status_id;
276: l_exp_resolution_date := cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date;
277:
278: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

271: l_status_flag := cs_servicerequest_pvt.user_hooks_rec.status_flag;
272: l_old_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag;
273: l_new_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag;
274: l_customer_product_id := cs_servicerequest_pvt.user_hooks_rec.customer_product_id;
275: l_status_id := cs_servicerequest_pvt.user_hooks_rec.status_id;
276: l_exp_resolution_date := cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date;
277:
278: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' input values:' );

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

272: l_old_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag;
273: l_new_type_cmro_flag := cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag;
274: l_customer_product_id := cs_servicerequest_pvt.user_hooks_rec.customer_product_id;
275: l_status_id := cs_servicerequest_pvt.user_hooks_rec.status_id;
276: l_exp_resolution_date := cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date;
277:
278: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' input values:' );
280: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Request id::' || cs_servicerequest_pvt.user_hooks_rec.request_id);

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

276: l_exp_resolution_date := cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date;
277:
278: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' input values:' );
280: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Request id::' || cs_servicerequest_pvt.user_hooks_rec.request_id);
281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Status flag:' || cs_servicerequest_pvt.user_hooks_rec.status_flag);
282: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag);
283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);

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

277:
278: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' input values:' );
280: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Request id::' || cs_servicerequest_pvt.user_hooks_rec.request_id);
281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Status flag:' || cs_servicerequest_pvt.user_hooks_rec.status_flag);
282: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag);
283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'status id:' || cs_servicerequest_pvt.user_hooks_rec.status_id);

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

278: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' input values:' );
280: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Request id::' || cs_servicerequest_pvt.user_hooks_rec.request_id);
281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Status flag:' || cs_servicerequest_pvt.user_hooks_rec.status_flag);
282: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag);
283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'status id:' || cs_servicerequest_pvt.user_hooks_rec.status_id);
286: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'exp_resolution_date:' || cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date);

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

279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' input values:' );
280: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Request id::' || cs_servicerequest_pvt.user_hooks_rec.request_id);
281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Status flag:' || cs_servicerequest_pvt.user_hooks_rec.status_flag);
282: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag);
283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'status id:' || cs_servicerequest_pvt.user_hooks_rec.status_id);
286: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'exp_resolution_date:' || cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date);
287: END IF;

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

280: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Request id::' || cs_servicerequest_pvt.user_hooks_rec.request_id);
281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Status flag:' || cs_servicerequest_pvt.user_hooks_rec.status_flag);
282: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag);
283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'status id:' || cs_servicerequest_pvt.user_hooks_rec.status_id);
286: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'exp_resolution_date:' || cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date);
287: END IF;
288:

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

281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Status flag:' || cs_servicerequest_pvt.user_hooks_rec.status_flag);
282: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag);
283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'status id:' || cs_servicerequest_pvt.user_hooks_rec.status_id);
286: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'exp_resolution_date:' || cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date);
287: END IF;
288:
289:

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

282: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.old_type_cmro_flag);
283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'new_type_cmro_flag:' || cs_servicerequest_pvt.user_hooks_rec.new_type_cmro_flag);
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'customer_product_id:' || cs_servicerequest_pvt.user_hooks_rec.customer_product_id);
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'status id:' || cs_servicerequest_pvt.user_hooks_rec.status_id);
286: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'exp_resolution_date:' || cs_servicerequest_pvt.user_hooks_rec.exp_resolution_date);
287: END IF;
288:
289:
290: --******************************

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

546: -- Type : Private
547: -- Function : Private API to process changes to a (current or former) CMRO type SR
548: -- by adding, removing or updating SR type unit effectivities.
549: -- Called by the corresponding public procedure.
550: -- Uses CS_SERVICEREQUEST_PVT.USER_HOOKS_REC to get SR Details.
551: -- Pre-reqs :
552: -- Parameters :
553: -- x_return_status OUT VARCHAR2 Required
554: --

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

579:
580: -- JR: Added the following log on 10/21/2003 to help in debugging
581: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
582: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Relevant User Hook Record (input) Values: ' );
583: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag ||
584: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag ||
585: ', request_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id ||
586: ', status_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id ||
587: ', status_flag = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag ||

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

580: -- JR: Added the following log on 10/21/2003 to help in debugging
581: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
582: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Relevant User Hook Record (input) Values: ' );
583: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag ||
584: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag ||
585: ', request_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id ||
586: ', status_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id ||
587: ', status_flag = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag ||
588: ', customer_product_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.customer_product_id ||

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

581: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
582: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Relevant User Hook Record (input) Values: ' );
583: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag ||
584: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag ||
585: ', request_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id ||
586: ', status_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id ||
587: ', status_flag = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag ||
588: ', customer_product_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.customer_product_id ||
589: ', exp_resolution_date = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.exp_resolution_date);

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

582: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'Relevant User Hook Record (input) Values: ' );
583: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag ||
584: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag ||
585: ', request_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id ||
586: ', status_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id ||
587: ', status_flag = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag ||
588: ', customer_product_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.customer_product_id ||
589: ', exp_resolution_date = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.exp_resolution_date);
590: END IF;

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

583: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , 'old_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag ||
584: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag ||
585: ', request_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id ||
586: ', status_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id ||
587: ', status_flag = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag ||
588: ', customer_product_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.customer_product_id ||
589: ', exp_resolution_date = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.exp_resolution_date);
590: END IF;
591:

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

584: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag ||
585: ', request_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id ||
586: ', status_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id ||
587: ', status_flag = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag ||
588: ', customer_product_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.customer_product_id ||
589: ', exp_resolution_date = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.exp_resolution_date);
590: END IF;
591:
592: -- Initialize API return status to success

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

585: ', request_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id ||
586: ', status_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id ||
587: ', status_flag = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag ||
588: ', customer_product_id = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.customer_product_id ||
589: ', exp_resolution_date = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.exp_resolution_date);
590: END IF;
591:
592: -- Initialize API return status to success
593: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

596: --AMSRINIV. Bug 5470730. Removing message initialization.
597: --FND_MSG_PUB.Initialize;
598:
599: -- Begin Processing
600: IF NOT (NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag, G_NO_FLAG) = G_YES_FLAG OR
601: NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag, G_NO_FLAG)= G_YES_FLAG) THEN
602: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
603: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Not a CMRO Type Service Request.');
604: END IF;

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

597: --FND_MSG_PUB.Initialize;
598:
599: -- Begin Processing
600: IF NOT (NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag, G_NO_FLAG) = G_YES_FLAG OR
601: NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag, G_NO_FLAG)= G_YES_FLAG) THEN
602: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
603: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Not a CMRO Type Service Request.');
604: END IF;
605: -- Not a CMRO Type Service Request

Line 610: 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 ||

606: -- Just return 'SUCCESS' without doing any processing.
607: l_skip_processing := true;
608: ELSE
609: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
610: 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 ||
611: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag);
612: END IF;
613: END IF;
614:

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

607: l_skip_processing := true;
608: ELSE
609: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
610: 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 ||
611: ', new_type_cmro_flag = ' || CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag);
612: END IF;
613: END IF;
614:
615: IF (l_skip_processing = false) THEN

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

612: END IF;
613: END IF;
614:
615: IF (l_skip_processing = false) THEN
616: IF (NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag, G_NO_FLAG) = G_YES_FLAG) THEN
617: -- Since this is a CMRO type SR, ensure that the Application Usage profile option has been set to AHL
618: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,
619: x_return_status => x_return_status);
620:

Line 646: 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

642: -- First Validate the request
643: Validate_Request_For_Update(x_sr_ue_id => l_sr_ue_id,
644: x_sr_ue_ovn => l_sr_ue_ovn);
645:
646: 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
647: -- Handle Type Change
648: Handle_Type_Change(p_sr_ue_id => l_sr_ue_id);
649:
650: ELSE

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

2396: x_sr_ue_ovn OUT NOCOPY NUMBER) IS
2397:
2398: CURSOR check_request_exists_csr IS
2399: SELECT 'x' FROM CS_INCIDENTS
2400: WHERE INCIDENT_ID = CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id;
2401:
2402: CURSOR get_ue_dtls_csr IS
2403: SELECT UNIT_EFFECTIVITY_ID, OBJECT_VERSION_NUMBER
2404: FROM AHL_UNIT_EFFECTIVITIES_APP_V

Line 2405: WHERE CS_INCIDENT_ID = CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id

2401:
2402: CURSOR get_ue_dtls_csr IS
2403: SELECT UNIT_EFFECTIVITY_ID, OBJECT_VERSION_NUMBER
2404: FROM AHL_UNIT_EFFECTIVITIES_APP_V
2405: WHERE CS_INCIDENT_ID = CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id
2406: AND (STATUS_CODE IS NULL OR STATUS_CODE NOT IN (G_UMP_DEFERRED_STATUS, G_UMP_EXCEPTION_STATUS));
2407:
2408: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Validate_Request_For_Update';
2409:

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

2414: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2415: END IF;
2416:
2417: -- Ensure that request id is not null
2418: IF(CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id IS NULL) THEN
2419: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_NULL');
2420: FND_MSG_PUB.ADD;
2421: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2422: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

2429: FETCH check_request_exists_csr INTO l_dummy;
2430: IF(check_request_exists_csr%NOTFOUND) THEN
2431: CLOSE check_request_exists_csr;
2432: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_INVALID');
2433: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);
2434: FND_MSG_PUB.ADD;
2435: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2436: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2437: END IF;

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

2439: END IF;
2440: CLOSE check_request_exists_csr;
2441:
2442: -- If already a CMRO SR, ensure that an unit effectivity exists for the SR
2443: IF (NVL(CS_SERVICEREQUEST_PVT.user_hooks_rec.old_type_cmro_flag, G_NO_FLAG) = G_YES_FLAG) THEN
2444: OPEN get_ue_dtls_csr;
2445: FETCH get_ue_dtls_csr INTO x_sr_ue_id, x_sr_ue_ovn;
2446: IF (get_ue_dtls_csr%NOTFOUND) THEN
2447: CLOSE get_ue_dtls_csr;

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

2445: FETCH get_ue_dtls_csr INTO x_sr_ue_id, x_sr_ue_ovn;
2446: IF (get_ue_dtls_csr%NOTFOUND) THEN
2447: CLOSE get_ue_dtls_csr;
2448: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_INVALID');
2449: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);
2450: FND_MSG_PUB.ADD;
2451: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2452: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2453: END IF;

Line 2455: 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);

2451: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2452: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2453: END IF;
2454: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2455: 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);
2456: END IF;
2457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2458: END IF; -- UE Not Found
2459: CLOSE get_ue_dtls_csr;

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

2493: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2494: END IF;
2495:
2496: -- Ensure that the SR is not closed
2497: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag = G_SR_CLOSED_FLAG) THEN
2498: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_CLOSED');
2499: FND_MSG_PUB.ADD;
2500: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2501: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

2502: END IF;
2503: RAISE FND_API.G_EXC_ERROR;
2504: END IF;
2505:
2506: IF (NVL(CS_SERVICEREQUEST_PVT.user_hooks_rec.new_type_cmro_flag, G_NO_FLAG) = G_NO_FLAG) THEN
2507: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'CMRO to Non-CMRO type conversion');
2509: END IF;
2510: -- CMRO to Non-CMRO type

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

2508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'CMRO to Non-CMRO type conversion');
2509: END IF;
2510: -- CMRO to Non-CMRO type
2511: -- JR: Modified on 10/29/2003 (Using Status Id instead of Status Code)
2512: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
2513: OPEN get_tasks_for_ue_csr;
2514: FETCH get_tasks_for_ue_csr INTO l_dummy;
2515: IF (get_tasks_for_ue_csr%FOUND) THEN
2516: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_ASGND_TO_VISIT');

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

2555: -- Non-CMRO to CMRO type
2556: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2557: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Non-CMRO to CMRO type conversion');
2558: END IF;
2559: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
2560: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_PLANNED');
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 2619: l_new_instance NUMBER := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.customer_product_id;

2615: l_old_instance NUMBER;
2616: l_old_due_date DATE;
2617: l_old_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2618: l_valid_flag BOOLEAN := true;
2619: l_new_instance NUMBER := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.customer_product_id;
2620: l_new_ue_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2621: l_new_due_date DATE := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.exp_resolution_date;
2622: l_assigned BOOLEAN;
2623: l_new_tolerance_flag VARCHAR2(1);

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

2617: l_old_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2618: l_valid_flag BOOLEAN := true;
2619: l_new_instance NUMBER := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.customer_product_id;
2620: l_new_ue_status AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE;
2621: l_new_due_date DATE := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.exp_resolution_date;
2622: l_assigned BOOLEAN;
2623: l_new_tolerance_flag VARCHAR2(1);
2624:
2625: BEGIN

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

2734:
2735: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Handle_Instance_Change';
2736:
2737: l_temp_count NUMBER := 0;
2738: l_new_instance_id NUMBER := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.customer_product_id;
2739:
2740: BEGIN
2741: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2742: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

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

2755: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2756: END IF;
2757: ELSIF (l_new_instance_id <> p_old_instance_id) THEN
2758: -- Instance has changed: Validate
2759: IF (CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.status_flag = G_SR_CLOSED_FLAG) THEN
2760: p_x_valid_flag := false;
2761: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_CHG_CLOSED');
2762: FND_MSG_PUB.ADD;
2763: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2762: FND_MSG_PUB.ADD;
2763: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2764: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2765: END IF;
2766: ELSIF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
2767: p_x_valid_flag := false;
2768: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_CHG_PLANNED');
2769: FND_MSG_PUB.ADD;
2770: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2827: END IF;
2828: -- Initialize the Status Changed Flag to false
2829: x_status_changed := false;
2830:
2831: IF (CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.status_flag = G_SR_CLOSED_FLAG) THEN
2832: -- SR is or is being Closed
2833: OPEN get_tasks_for_ue_csr;
2834: FETCH get_tasks_for_ue_csr INTO l_dummy;
2835: IF(get_tasks_for_ue_csr%FOUND) THEN

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

2891: ELSE
2892: l_assigned := false;
2893: END IF;
2894: CLOSE get_tasks_for_ue_csr;
2895: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
2896: IF (l_assigned = false) THEN
2897: -- SR is being moved to Planned status without assigning SR UE to any visit
2898: p_x_valid_flag := false;
2899: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_NOT_ASSND');

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

3020: -- Manually fetching the SR Summary from UE table because SR doesnt
3021: OPEN c_get_SR_details(p_sr_ue_id);
3022: FETCH c_get_SR_details INTO l_sr_summary, l_sr_type;
3023: CLOSE c_get_SR_details;
3024: --l_sr_summary := CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.summary;
3025: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3026:
3027: FND_LOG.STRING(
3028: FND_LOG.LEVEL_STATEMENT,