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.CSD_SC_WORK_ENTITIES_PVT dependencies on FND_LOG

Line 30: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

26: x_sc_work_entity_id OUT NOCOPY NUMBER
27: ) IS
28:
29: -- CONSTANTS --
30: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
32: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 31: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

27: ) IS
28:
29: -- CONSTANTS --
30: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
32: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
35: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

Line 32: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

28:
29: -- CONSTANTS --
30: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
32: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
35: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 33: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

29: -- CONSTANTS --
30: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
32: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
35: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
37: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.create_sc_work_entity';

Line 34: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

30: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
32: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
35: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
37: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.create_sc_work_entity';
38: lc_api_name CONSTANT VARCHAR2(30) := 'Create_SC_Work_Entity';

Line 35: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

31: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
32: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
35: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
37: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.create_sc_work_entity';
38: lc_api_name CONSTANT VARCHAR2(30) := 'Create_SC_Work_Entity';
39: lc_api_version CONSTANT NUMBER := 1.0;

Line 36: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

32: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
35: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
37: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.create_sc_work_entity';
38: lc_api_name CONSTANT VARCHAR2(30) := 'Create_SC_Work_Entity';
39: lc_api_version CONSTANT NUMBER := 1.0;
40:

Line 74: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

70: FND_MSG_PUB.initialize;
71: END IF;
72:
73: IF (lc_proc_level >= lc_debug_level) THEN
74: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
75: 'Entered Create_SC_Work_Entity');
76: END IF;
77:
78: -- log parameters

Line 91: FND_LOG.STRING(lc_proc_level, lc_mod_name,

87: -- Api body starts
88:
89: -- Check the required parameters
90: if (lc_proc_level >= lc_debug_level) then
91: FND_LOG.STRING(lc_proc_level, lc_mod_name,
92: 'Checking required parameters');
93: end if;
94:
95: -- Check the required parameter

Line 109: FND_LOG.STRING(lc_proc_level, lc_mod_name,

105: p_api_name => lc_api_name);
106:
107: -- Validate the work entity for service code
108: if (lc_proc_level >= lc_debug_level) then
109: FND_LOG.STRING(lc_proc_level, lc_mod_name,
110: 'Validate if the service code work entity already exists');
111: end if;
112:
113: -- Validate the work entity for service code

Line 141: FND_LOG.STRING(lc_stat_level, lc_mod_name,

137: IF (l_dummy = 'X') then
138: RAISE CSD_SCW_ENTITY_EXISTS;
139: ELSE
140: if (lc_stat_level >= lc_debug_level) then
141: FND_LOG.STRING(lc_stat_level, lc_mod_name,
142: 'Service code work entity does not exist');
143: end if;
144: END IF;
145:

Line 148: FND_LOG.STRING(lc_proc_level, lc_mod_name,

144: END IF;
145:
146: -- Validate the organization id
147: if (lc_proc_level >= lc_debug_level) then
148: FND_LOG.STRING(lc_proc_level, lc_mod_name,
149: 'Validate the organization id');
150: end if;
151:
152: -- Validate the organization id

Line 177: FND_LOG.STRING(lc_stat_level, lc_mod_name,

173: IF (l_dummy <> 'X') then
174: RAISE CSD_SCW_INVALID_ORGANIZATION;
175: ELSE
176: if (lc_stat_level >= lc_debug_level) then
177: FND_LOG.STRING(lc_stat_level, lc_mod_name,
178: 'Org for service code work entity is valid');
179: end if;
180: END IF;
181:

Line 184: FND_LOG.STRING(lc_proc_level, lc_mod_name,

180: END IF;
181:
182: -- Validate the bill sequence id
183: if (lc_proc_level >= lc_debug_level) then
184: FND_LOG.STRING(lc_proc_level, lc_mod_name,
185: 'Validate the bill sequence id');
186: end if;
187:
188: -- Validate the bill sequence id

Line 213: FND_LOG.STRING(lc_stat_level, lc_mod_name,

209: IF (l_dummy <> 'X') then
210: RAISE CSD_SCW_INVALID_BILL_SEQUENCE;
211: ELSE
212: if (lc_stat_level >= lc_debug_level) then
213: FND_LOG.STRING(lc_stat_level, lc_mod_name,
214: 'Bill reference for service code work entity is valid');
215: end if;
216: END IF;
217:

Line 220: FND_LOG.STRING(lc_proc_level, lc_mod_name,

216: END IF;
217:
218: -- Validate the routing sequence id
219: if (lc_proc_level >= lc_debug_level) then
220: FND_LOG.STRING(lc_proc_level, lc_mod_name,
221: 'Validate the routing sequence id');
222: end if;
223:
224: -- Validate the routing sequence id

Line 249: FND_LOG.STRING(lc_stat_level, lc_mod_name,

245: IF (l_dummy <> 'X') then
246: RAISE CSD_SCW_INVALID_ROUTE_SEQUENCE;
247: ELSE
248: if (lc_stat_level >= lc_debug_level) then
249: FND_LOG.STRING(lc_stat_level, lc_mod_name,
250: 'Routing reference for service code work entity is valid');
251: end if;
252: END IF;
253:

Line 256: FND_LOG.STRING(lc_proc_level, lc_mod_name,

252: END IF;
253:
254: -- Validate the task template group id
255: if (lc_proc_level >= lc_debug_level) then
256: FND_LOG.STRING(lc_proc_level, lc_mod_name,
257: 'Validate the task template group id');
258: end if;
259:
260: -- Validate the task template group id

Line 285: FND_LOG.STRING(lc_stat_level, lc_mod_name,

281: IF (l_dummy <> 'X') then
282: RAISE CSD_SCW_INVALID_TASK_TEMP_GRP;
283: ELSE
284: if (lc_stat_level >= lc_debug_level) then
285: FND_LOG.STRING(lc_stat_level, lc_mod_name,
286: 'Task template group for service code work entity is valid');
287: end if;
288: END IF;
289:

Line 292: FND_LOG.STRING(lc_proc_level, lc_mod_name,

288: END IF;
289:
290: -- Insert row
291: if (lc_proc_level >= lc_debug_level) then
292: FND_LOG.STRING(lc_proc_level, lc_mod_name,
293: 'Calling Insert_Row table handler');
294: end if;
295:
296: BEGIN

Line 333: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_WORK_ENTITIES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

329:
330: EXCEPTION
331: WHEN OTHERS THEN
332: IF ( lc_excep_level >= lc_debug_level) THEN
333: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_WORK_ENTITIES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
334: END IF;
335: x_return_status := FND_API.G_RET_STS_ERROR;
336: END;
337:

Line 343: FND_LOG.STRING(lc_proc_level, lc_mod_name,

339: RAISE FND_API.G_EXC_ERROR;
340: END IF;
341:
342: if (lc_proc_level >= lc_debug_level) then
343: FND_LOG.STRING(lc_proc_level, lc_mod_name,
344: 'Returned from Insert_Row table handler');
345: end if;
346:
347: -- Api body ends here

Line 360: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',

356: (p_count => x_msg_count,
357: p_data => x_msg_data );
358:
359: IF (lc_proc_level >= lc_debug_level) THEN
360: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
361: 'Leaving Create_SC_Work_Entity');
362: END IF;
363:
364: EXCEPTION

Line 373: FND_LOG.STRING(lc_stat_level, lc_mod_name,

369: x_return_status := FND_API.G_RET_STS_ERROR ;
370:
371: -- save message in fnd stack
372: if (lc_stat_level >= lc_debug_level) then
373: FND_LOG.STRING(lc_stat_level, lc_mod_name,
374: 'Adding message CSD_SCW_ENTITY_EXISTS to FND_MSG stack');
375: end if;
376: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_ENTITY_EXISTS');
377: FND_MESSAGE.SET_TOKEN('SERVICE_CODE_ID',p_sc_work_entity_rec.service_code_id);

Line 386: FND_LOG.STRING(lc_excep_level, lc_mod_name,

382: p_data => x_msg_data );
383:
384: -- save message in debug log
385: IF (lc_excep_level >= lc_debug_level) THEN
386: FND_LOG.STRING(lc_excep_level, lc_mod_name,
387: 'Service code work entity already exists');
388: END IF;
389:
390: WHEN CSD_SCW_INVALID_ORGANIZATION THEN

Line 398: FND_LOG.STRING(lc_stat_level, lc_mod_name,

394: x_return_status := FND_API.G_RET_STS_ERROR ;
395:
396: -- save message in fnd stack
397: if (lc_stat_level >= lc_debug_level) then
398: FND_LOG.STRING(lc_stat_level, lc_mod_name,
399: 'Adding message CSD_SCW_INVALID_ORGANIZATION to FND_MSG stack');
400: end if;
401: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_ORGANIZATION');
402: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_sc_work_entity_rec.work_entity_id3);

Line 411: FND_LOG.STRING(lc_excep_level, lc_mod_name,

407: p_data => x_msg_data );
408:
409: -- save message in debug log
410: IF (lc_excep_level >= lc_debug_level) THEN
411: FND_LOG.STRING(lc_excep_level, lc_mod_name,
412: 'Service code work entity organization is invalid');
413: END IF;
414:
415: WHEN CSD_SCW_INVALID_BILL_SEQUENCE THEN

Line 423: FND_LOG.STRING(lc_stat_level, lc_mod_name,

419: x_return_status := FND_API.G_RET_STS_ERROR ;
420:
421: -- save message in fnd stack
422: if (lc_stat_level >= lc_debug_level) then
423: FND_LOG.STRING(lc_stat_level, lc_mod_name,
424: 'Adding message CSD_SCW_INVALID_BILL_SEQUENCE to FND_MSG stack');
425: end if;
426: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_BILL_SEQUENCE');
427: FND_MESSAGE.SET_TOKEN('BILL_SEQUENCE_ID',p_sc_work_entity_rec.work_entity_id1);

Line 436: FND_LOG.STRING(lc_excep_level, lc_mod_name,

432: p_data => x_msg_data );
433:
434: -- save message in debug log
435: IF (lc_excep_level >= lc_debug_level) THEN
436: FND_LOG.STRING(lc_excep_level, lc_mod_name,
437: 'Service code work entity bill reference is invalid');
438: END IF;
439:
440: WHEN CSD_SCW_INVALID_ROUTE_SEQUENCE THEN

Line 448: FND_LOG.STRING(lc_stat_level, lc_mod_name,

444: x_return_status := FND_API.G_RET_STS_ERROR ;
445:
446: -- save message in fnd stack
447: if (lc_stat_level >= lc_debug_level) then
448: FND_LOG.STRING(lc_stat_level, lc_mod_name,
449: 'Adding message CSD_SCW_INVALID_ROUTE_SEQUENCE to FND_MSG stack');
450: end if;
451: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_ROUTE_SEQUENCE');
452: FND_MESSAGE.SET_TOKEN('ROUTING_SEQUENCE_ID',p_sc_work_entity_rec.work_entity_id2);

Line 461: FND_LOG.STRING(lc_excep_level, lc_mod_name,

457: p_data => x_msg_data );
458:
459: -- save message in debug log
460: IF (lc_excep_level >= lc_debug_level) THEN
461: FND_LOG.STRING(lc_excep_level, lc_mod_name,
462: 'Service code work entity routing reference is invalid');
463: END IF;
464:
465: WHEN CSD_SCW_INVALID_TASK_TEMP_GRP THEN

Line 473: FND_LOG.STRING(lc_stat_level, lc_mod_name,

469: x_return_status := FND_API.G_RET_STS_ERROR ;
470:
471: -- save message in fnd stack
472: if (lc_stat_level >= lc_debug_level) then
473: FND_LOG.STRING(lc_stat_level, lc_mod_name,
474: 'Adding message CSD_SCW_INVALID_TASK_TEMP_GRP to FND_MSG stack');
475: end if;
476: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_TASK_TEMP_GRP');
477: FND_MESSAGE.SET_TOKEN('TASK_TEMP_GROUP_ID',p_sc_work_entity_rec.work_entity_id1);

Line 486: FND_LOG.STRING(lc_excep_level, lc_mod_name,

482: p_data => x_msg_data );
483:
484: -- save message in debug log
485: IF (lc_excep_level >= lc_debug_level) THEN
486: FND_LOG.STRING(lc_excep_level, lc_mod_name,
487: 'Service code work entity task template group is invalid');
488: END IF;
489:
490: WHEN FND_API.G_EXC_ERROR THEN

Line 501: FND_LOG.STRING(lc_excep_level, lc_mod_name,

497: p_data => x_msg_data );
498:
499: -- save message in debug log
500: IF (lc_excep_level >= lc_debug_level) THEN
501: FND_LOG.STRING(lc_excep_level, lc_mod_name,
502: 'EXC_ERROR['||x_msg_data||']');
503: END IF;
504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 514: FND_LOG.STRING(lc_stat_level, lc_mod_name,

510: IF FND_MSG_PUB.Check_Msg_Level
511: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
512: THEN
513: if (lc_stat_level >= lc_debug_level) then
514: FND_LOG.STRING(lc_stat_level, lc_mod_name,
515: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
516: end if;
517: FND_MSG_PUB.Add_Exc_Msg
518: (G_PKG_NAME ,

Line 528: FND_LOG.STRING(lc_excep_level, lc_mod_name,

524: p_data => x_msg_data );
525:
526: -- save message in debug log
527: IF (lc_excep_level >= lc_debug_level) THEN
528: FND_LOG.STRING(lc_excep_level, lc_mod_name,
529: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
530: END IF;
531:
532: WHEN OTHERS THEN

Line 542: FND_LOG.STRING(lc_stat_level, lc_mod_name,

538: IF FND_MSG_PUB.Check_Msg_Level
539: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
540: THEN
541: if (lc_stat_level >= lc_debug_level) then
542: FND_LOG.STRING(lc_stat_level, lc_mod_name,
543: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
544: end if;
545: FND_MSG_PUB.Add_Exc_Msg
546: (G_PKG_NAME ,

Line 557: FND_LOG.STRING(lc_excep_level, lc_mod_name,

553:
554: -- save message in debug log
555: IF (lc_excep_level >= lc_debug_level) THEN
556: -- create a seeded message
557: FND_LOG.STRING(lc_excep_level, lc_mod_name,
558: 'SQL Message['||sqlerrm||']' );
559: END IF;
560:
561: END Create_SC_Work_Entity;

Line 584: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

580: x_obj_ver_number OUT NOCOPY NUMBER
581: ) IS
582:
583: -- CONSTANTS --
584: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
585: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
586: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
587: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
588: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 585: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

581: ) IS
582:
583: -- CONSTANTS --
584: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
585: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
586: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
587: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
588: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
589: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

Line 586: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

582:
583: -- CONSTANTS --
584: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
585: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
586: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
587: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
588: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
589: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
590: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 587: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

583: -- CONSTANTS --
584: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
585: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
586: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
587: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
588: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
589: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
590: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
591: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.update_sc_work_entity';

Line 588: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

584: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
585: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
586: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
587: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
588: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
589: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
590: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
591: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.update_sc_work_entity';
592: lc_api_name CONSTANT VARCHAR2(30) := 'Update_SC_Work_Entity';

Line 589: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

585: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
586: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
587: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
588: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
589: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
590: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
591: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.update_sc_work_entity';
592: lc_api_name CONSTANT VARCHAR2(30) := 'Update_SC_Work_Entity';
593: lc_api_version CONSTANT NUMBER := 1.0;

Line 590: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

586: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
587: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
588: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
589: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
590: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
591: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.update_sc_work_entity';
592: lc_api_name CONSTANT VARCHAR2(30) := 'Update_SC_Work_Entity';
593: lc_api_version CONSTANT NUMBER := 1.0;
594:

Line 635: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

631: FND_MSG_PUB.initialize;
632: END IF;
633:
634: IF (lc_proc_level >= lc_debug_level) THEN
635: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
636: 'Entered Update_SC_Work_Entity');
637: END IF;
638:
639: -- log parameters

Line 652: FND_LOG.STRING(lc_proc_level, lc_mod_name,

648: -- Api body starts
649:
650: -- Check the required parameters
651: if (lc_proc_level >= lc_debug_level) then
652: FND_LOG.STRING(lc_proc_level, lc_mod_name,
653: 'Checking required parameters');
654: end if;
655:
656: -- Check the required parameter

Line 664: FND_LOG.STRING(lc_proc_level, lc_mod_name,

660: p_api_name => lc_api_name);
661:
662: -- Check if required parameter is passed in as G_MISS
663: if (lc_proc_level >= lc_debug_level) then
664: FND_LOG.STRING(lc_proc_level, lc_mod_name,
665: 'Checking if required parameters are passed in as G_MISS');
666: end if;
667:
668: -- Check if required parameter is passed in as G_MISS

Line 680: FND_LOG.STRING(lc_proc_level, lc_mod_name,

676: END IF;
677:
678: -- Validate the work entity for service code
679: if (lc_proc_level >= lc_debug_level) then
680: FND_LOG.STRING(lc_proc_level, lc_mod_name,
681: 'Validate the id for service code work entity');
682: end if;
683:
684: -- Validate the id for service code work entity

Line 705: FND_LOG.STRING(lc_stat_level, lc_mod_name,

701: IF (l_dummy <> 'X') then
702: RAISE CSD_SCW_INVALID_ID;
703: ELSE
704: if (lc_stat_level >= lc_debug_level) then
705: FND_LOG.STRING(lc_stat_level, lc_mod_name,
706: 'Service code work entity is valid');
707: end if;
708: END IF;
709:

Line 712: FND_LOG.STRING(lc_proc_level, lc_mod_name,

708: END IF;
709:
710: -- Get the object version number for service code
711: if (lc_proc_level >= lc_debug_level) then
712: FND_LOG.STRING(lc_proc_level, lc_mod_name,
713: 'Get object version number for service code work entity');
714: end if;
715:
716: -- Get object version number for service code work_entity

Line 735: FND_LOG.STRING(lc_stat_level, lc_mod_name,

731: IF (l_obj_ver_num is null) then
732: RAISE CSD_SCW_GET_OVN_ERROR;
733: ELSE
734: if (lc_stat_level >= lc_debug_level) then
735: FND_LOG.STRING(lc_stat_level, lc_mod_name,
736: 'Retrieved object version number');
737: end if;
738: END IF;
739:

Line 742: FND_LOG.STRING(lc_proc_level, lc_mod_name,

738: END IF;
739:
740: -- Validate the object version number for service code work entity
741: if (lc_proc_level >= lc_debug_level) then
742: FND_LOG.STRING(lc_proc_level, lc_mod_name,
743: 'Validate object version number for service code work entity');
744: end if;
745:
746: -- Validate if object version number for service code work_entity is same as the one passed in

Line 751: FND_LOG.STRING(lc_stat_level, lc_mod_name,

747: IF NVL(p_sc_work_entity_rec.object_version_number,FND_API.G_MISS_NUM) <> l_obj_ver_num THEN
748: RAISE CSD_SCW_OVN_MISMATCH;
749: ELSE
750: if (lc_stat_level >= lc_debug_level) then
751: FND_LOG.STRING(lc_stat_level, lc_mod_name,
752: 'Object version number is valid');
753: end if;
754: END IF;
755:

Line 758: FND_LOG.STRING(lc_proc_level, lc_mod_name,

754: END IF;
755:
756: -- Validate the work entity for service code
757: if (lc_proc_level >= lc_debug_level) then
758: FND_LOG.STRING(lc_proc_level, lc_mod_name,
759: 'Validate if the service code work entity already exists');
760: end if;
761:
762: -- Validate the work entity for service code

Line 792: FND_LOG.STRING(lc_stat_level, lc_mod_name,

788: IF (l_dummy = 'X') then
789: RAISE CSD_SCW_ENTITY_EXISTS;
790: ELSE
791: if (lc_stat_level >= lc_debug_level) then
792: FND_LOG.STRING(lc_stat_level, lc_mod_name,
793: 'Service code work entity does not exist');
794: end if;
795: END IF;
796:

Line 799: FND_LOG.STRING(lc_proc_level, lc_mod_name,

795: END IF;
796:
797: -- Validate the organization id
798: if (lc_proc_level >= lc_debug_level) then
799: FND_LOG.STRING(lc_proc_level, lc_mod_name,
800: 'Validate the organization id');
801: end if;
802:
803: -- Validate the organization id

Line 828: FND_LOG.STRING(lc_stat_level, lc_mod_name,

824: IF (l_dummy <> 'X') then
825: RAISE CSD_SCW_INVALID_ORGANIZATION;
826: ELSE
827: if (lc_stat_level >= lc_debug_level) then
828: FND_LOG.STRING(lc_stat_level, lc_mod_name,
829: 'Org for service code work entity is valid');
830: end if;
831: END IF;
832:

Line 835: FND_LOG.STRING(lc_proc_level, lc_mod_name,

831: END IF;
832:
833: -- Validate the bill sequence id
834: if (lc_proc_level >= lc_debug_level) then
835: FND_LOG.STRING(lc_proc_level, lc_mod_name,
836: 'Validate the bill sequence id');
837: end if;
838:
839: -- Validate the bill sequence id

Line 864: FND_LOG.STRING(lc_stat_level, lc_mod_name,

860: IF (l_dummy <> 'X') then
861: RAISE CSD_SCW_INVALID_BILL_SEQUENCE;
862: ELSE
863: if (lc_stat_level >= lc_debug_level) then
864: FND_LOG.STRING(lc_stat_level, lc_mod_name,
865: 'Bill reference for service code work entity is valid');
866: end if;
867: END IF;
868:

Line 871: FND_LOG.STRING(lc_proc_level, lc_mod_name,

867: END IF;
868:
869: -- Validate the routing sequence id
870: if (lc_proc_level >= lc_debug_level) then
871: FND_LOG.STRING(lc_proc_level, lc_mod_name,
872: 'Validate the routing sequence id');
873: end if;
874:
875: -- Validate the routing sequence id

Line 900: FND_LOG.STRING(lc_stat_level, lc_mod_name,

896: IF (l_dummy <> 'X') then
897: RAISE CSD_SCW_INVALID_ROUTE_SEQUENCE;
898: ELSE
899: if (lc_stat_level >= lc_debug_level) then
900: FND_LOG.STRING(lc_stat_level, lc_mod_name,
901: 'Routing reference for service code work entity is valid');
902: end if;
903: END IF;
904:

Line 907: FND_LOG.STRING(lc_proc_level, lc_mod_name,

903: END IF;
904:
905: -- Validate the task template group id
906: if (lc_proc_level >= lc_debug_level) then
907: FND_LOG.STRING(lc_proc_level, lc_mod_name,
908: 'Validate the task template group id');
909: end if;
910:
911: -- Validate the task template group id

Line 936: FND_LOG.STRING(lc_stat_level, lc_mod_name,

932: IF (l_dummy <> 'X') then
933: RAISE CSD_SCW_INVALID_TASK_TEMP_GRP;
934: ELSE
935: if (lc_stat_level >= lc_debug_level) then
936: FND_LOG.STRING(lc_stat_level, lc_mod_name,
937: 'Task template group for service code work entity is valid');
938: end if;
939: END IF;
940:

Line 943: FND_LOG.STRING(lc_proc_level, lc_mod_name,

939: END IF;
940:
941: -- Update row
942: if (lc_proc_level >= lc_debug_level) then
943: FND_LOG.STRING(lc_proc_level, lc_mod_name,
944: 'Calling Update_Row table handler');
945: end if;
946:
947: BEGIN

Line 986: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_WORK_ENTITIES_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

982:
983: EXCEPTION
984: WHEN OTHERS THEN
985: IF ( lc_excep_level >= lc_debug_level) THEN
986: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_WORK_ENTITIES_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
987: END IF;
988: x_return_status := FND_API.G_RET_STS_ERROR;
989: END;
990:

Line 996: FND_LOG.STRING(lc_proc_level, lc_mod_name,

992: RAISE FND_API.G_EXC_ERROR;
993: END IF;
994:
995: if (lc_proc_level >= lc_debug_level) then
996: FND_LOG.STRING(lc_proc_level, lc_mod_name,
997: 'Returned from Update_Row table handler');
998: end if;
999:
1000: -- Api body ends here

Line 1013: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',

1009: (p_count => x_msg_count,
1010: p_data => x_msg_data );
1011:
1012: IF (lc_proc_level >= lc_debug_level) THEN
1013: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
1014: 'Leaving Update_SC_Work_Entity');
1015: END IF;
1016:
1017: EXCEPTION

Line 1026: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1022: x_return_status := FND_API.G_RET_STS_ERROR ;
1023:
1024: -- save message in fnd stack
1025: if (lc_stat_level >= lc_debug_level) then
1026: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1027: 'Adding message CSD_SCW_SC_ID_MISSING to FND_MSG stack');
1028: end if;
1029: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
1030: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);

Line 1040: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1036: p_data => x_msg_data );
1037:
1038: -- save message in debug log
1039: IF (lc_excep_level >= lc_debug_level) THEN
1040: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1041: 'Service code id is missing');
1042: END IF;
1043:
1044: WHEN CSD_SCW_ENTITY_TYPE_MISSING THEN

Line 1052: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1048: x_return_status := FND_API.G_RET_STS_ERROR ;
1049:
1050: -- save message in fnd stack
1051: if (lc_stat_level >= lc_debug_level) then
1052: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1053: 'Adding message CSD_SCW_ENTITY_TYPE_MISSING to FND_MSG stack');
1054: end if;
1055: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
1056: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);

Line 1066: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1062: p_data => x_msg_data );
1063:
1064: -- save message in debug log
1065: IF (lc_excep_level >= lc_debug_level) THEN
1066: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1067: 'Service code work entity type is missing');
1068: END IF;
1069:
1070: WHEN CSD_SCW_INVALID_ID THEN

Line 1078: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1074: x_return_status := FND_API.G_RET_STS_ERROR ;
1075:
1076: -- save message in fnd stack
1077: if (lc_stat_level >= lc_debug_level) then
1078: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1079: 'Adding message CSD_SCW_INVALID_ID to FND_MSG stack');
1080: end if;
1081: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_ID');
1082: FND_MESSAGE.SET_TOKEN('SC_WORK_ENTITY_ID',p_sc_work_entity_rec.sc_work_entity_id);

Line 1091: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1087: p_data => x_msg_data );
1088:
1089: -- save message in debug log
1090: IF (lc_excep_level >= lc_debug_level) THEN
1091: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1092: 'Service code work entity id is invalid');
1093: END IF;
1094:
1095: WHEN CSD_SCW_GET_OVN_ERROR THEN

Line 1103: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1099: x_return_status := FND_API.G_RET_STS_ERROR ;
1100:
1101: -- save message in fnd stack
1102: if (lc_stat_level >= lc_debug_level) then
1103: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1104: 'Adding message CSD_SCW_GET_OVN_ERROR to FND_MSG stack');
1105: end if;
1106: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_GET_OVN_ERROR');
1107: FND_MESSAGE.SET_TOKEN('SC_WORK_ENTITY_ID',p_sc_work_entity_rec.sc_work_entity_id);

Line 1116: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1112: p_data => x_msg_data );
1113:
1114: -- save message in debug log
1115: IF (lc_excep_level >= lc_debug_level) THEN
1116: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1117: 'Service code work entity get object version number error');
1118: END IF;
1119:
1120: WHEN CSD_SCW_OVN_MISMATCH THEN

Line 1128: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1124: x_return_status := FND_API.G_RET_STS_ERROR ;
1125:
1126: -- save message in fnd stack
1127: if (lc_stat_level >= lc_debug_level) then
1128: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1129: 'Adding message CSD_SCW_OVN_MISMATCH to FND_MSG stack');
1130: end if;
1131: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_OVN_MISMATCH');
1132: FND_MESSAGE.SET_TOKEN('SC_WORK_ENTITY_ID',p_sc_work_entity_rec.sc_work_entity_id);

Line 1141: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1137: p_data => x_msg_data );
1138:
1139: -- save message in debug log
1140: IF (lc_excep_level >= lc_debug_level) THEN
1141: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1142: 'Service code work entity object version number mismatch');
1143: END IF;
1144:
1145: WHEN CSD_SCW_ENTITY_EXISTS THEN

Line 1153: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1149: x_return_status := FND_API.G_RET_STS_ERROR ;
1150:
1151: -- save message in fnd stack
1152: if (lc_stat_level >= lc_debug_level) then
1153: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1154: 'Adding message CSD_SCW_ENTITY_EXISTS to FND_MSG stack');
1155: end if;
1156: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_ENTITY_EXISTS');
1157: FND_MESSAGE.SET_TOKEN('SERVICE_CODE_ID',p_sc_work_entity_rec.service_code_id);

Line 1166: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1162: p_data => x_msg_data );
1163:
1164: -- save message in debug log
1165: IF (lc_excep_level >= lc_debug_level) THEN
1166: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1167: 'Service code work entity already exists');
1168: END IF;
1169:
1170: WHEN CSD_SCW_INVALID_ORGANIZATION THEN

Line 1178: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1174: x_return_status := FND_API.G_RET_STS_ERROR ;
1175:
1176: -- save message in fnd stack
1177: if (lc_stat_level >= lc_debug_level) then
1178: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1179: 'Adding message CSD_SCW_INVALID_ORGANIZATION to FND_MSG stack');
1180: end if;
1181: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_ORGANIZATION');
1182: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_sc_work_entity_rec.work_entity_id3);

Line 1191: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1187: p_data => x_msg_data );
1188:
1189: -- save message in debug log
1190: IF (lc_excep_level >= lc_debug_level) THEN
1191: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1192: 'Service code work entity organization is invalid');
1193: END IF;
1194:
1195: WHEN CSD_SCW_INVALID_BILL_SEQUENCE THEN

Line 1203: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1199: x_return_status := FND_API.G_RET_STS_ERROR ;
1200:
1201: -- save message in fnd stack
1202: if (lc_stat_level >= lc_debug_level) then
1203: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1204: 'Adding message CSD_SCW_INVALID_BILL_SEQUENCE to FND_MSG stack');
1205: end if;
1206: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_BILL_SEQUENCE');
1207: FND_MESSAGE.SET_TOKEN('BILL_SEQUENCE_ID',p_sc_work_entity_rec.work_entity_id1);

Line 1216: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1212: p_data => x_msg_data );
1213:
1214: -- save message in debug log
1215: IF (lc_excep_level >= lc_debug_level) THEN
1216: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1217: 'Service code work entity bill reference is invalid');
1218: END IF;
1219:
1220: WHEN CSD_SCW_INVALID_ROUTE_SEQUENCE THEN

Line 1228: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1224: x_return_status := FND_API.G_RET_STS_ERROR ;
1225:
1226: -- save message in fnd stack
1227: if (lc_stat_level >= lc_debug_level) then
1228: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1229: 'Adding message CSD_SCW_INVALID_ROUTE_SEQUENCE to FND_MSG stack');
1230: end if;
1231: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_ROUTE_SEQUENCE');
1232: FND_MESSAGE.SET_TOKEN('ROUTING_SEQUENCE_ID',p_sc_work_entity_rec.work_entity_id2);

Line 1241: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1237: p_data => x_msg_data );
1238:
1239: -- save message in debug log
1240: IF (lc_excep_level >= lc_debug_level) THEN
1241: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1242: 'Service code work entity routing reference is invalid');
1243: END IF;
1244:
1245: WHEN CSD_SCW_INVALID_TASK_TEMP_GRP THEN

Line 1253: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1249: x_return_status := FND_API.G_RET_STS_ERROR ;
1250:
1251: -- save message in fnd stack
1252: if (lc_stat_level >= lc_debug_level) then
1253: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1254: 'Adding message CSD_SCW_INVALID_TASK_TEMP_GRP to FND_MSG stack');
1255: end if;
1256: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_TASK_TEMP_GRP');
1257: FND_MESSAGE.SET_TOKEN('TASK_TEMP_GROUP_ID',p_sc_work_entity_rec.work_entity_id1);

Line 1266: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1262: p_data => x_msg_data );
1263:
1264: -- save message in debug log
1265: IF (lc_excep_level >= lc_debug_level) THEN
1266: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1267: 'Service code work entity task template group is invalid');
1268: END IF;
1269:
1270: WHEN FND_API.G_EXC_ERROR THEN

Line 1281: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1277: p_data => x_msg_data );
1278:
1279: -- save message in debug log
1280: IF (lc_excep_level >= lc_debug_level) THEN
1281: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1282: 'EXC_ERROR['||x_msg_data||']');
1283: END IF;
1284:
1285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1294: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1290: IF FND_MSG_PUB.Check_Msg_Level
1291: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1292: THEN
1293: if (lc_stat_level >= lc_debug_level) then
1294: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1295: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1296: end if;
1297: FND_MSG_PUB.Add_Exc_Msg
1298: (G_PKG_NAME ,

Line 1308: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1304: p_data => x_msg_data );
1305:
1306: -- save message in debug log
1307: IF (lc_excep_level >= lc_debug_level) THEN
1308: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1309: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
1310: END IF;
1311:
1312: WHEN OTHERS THEN

Line 1322: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1318: IF FND_MSG_PUB.Check_Msg_Level
1319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1320: THEN
1321: if (lc_stat_level >= lc_debug_level) then
1322: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1323: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1324: end if;
1325: FND_MSG_PUB.Add_Exc_Msg
1326: (G_PKG_NAME ,

Line 1337: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1333:
1334: -- save message in debug log
1335: IF (lc_excep_level >= lc_debug_level) THEN
1336: -- create a seeded message
1337: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1338: 'SQL Message['||sqlerrm||']' );
1339: END IF;
1340:
1341: END Update_SC_Work_Entity;

Line 1362: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1358: p_sc_work_entity_id IN NUMBER
1359: ) IS
1360:
1361: -- CONSTANTS --
1362: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1363: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1364: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1365: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1366: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 1363: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

1359: ) IS
1360:
1361: -- CONSTANTS --
1362: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1363: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1364: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1365: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1366: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1367: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

Line 1364: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

1360:
1361: -- CONSTANTS --
1362: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1363: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1364: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1365: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1366: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1367: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1368: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 1365: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

1361: -- CONSTANTS --
1362: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1363: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1364: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1365: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1366: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1367: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1368: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1369: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.delete_sc_work_entity';

Line 1366: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

1362: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1363: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1364: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1365: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1366: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1367: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1368: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1369: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.delete_sc_work_entity';
1370: lc_api_name CONSTANT VARCHAR2(30) := 'Delete_SC_Work_Entity';

Line 1367: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

1363: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1364: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1365: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1366: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1367: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1368: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1369: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.delete_sc_work_entity';
1370: lc_api_name CONSTANT VARCHAR2(30) := 'Delete_SC_Work_Entity';
1371: lc_api_version CONSTANT NUMBER := 1.0;

Line 1368: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

1364: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1365: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1366: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1367: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1368: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1369: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.delete_sc_work_entity';
1370: lc_api_name CONSTANT VARCHAR2(30) := 'Delete_SC_Work_Entity';
1371: lc_api_version CONSTANT NUMBER := 1.0;
1372:

Line 1397: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

1393: FND_MSG_PUB.initialize;
1394: END IF;
1395:
1396: IF (lc_proc_level >= lc_debug_level) THEN
1397: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
1398: 'Entered Delete_SC_Work_Entity');
1399: END IF;
1400:
1401: -- Initialize API return status to success

Line 1408: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1404: -- Api body starts
1405:
1406: -- Check the required parameters
1407: if (lc_proc_level >= lc_debug_level) then
1408: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1409: 'Checking required parameter');
1410: end if;
1411:
1412: -- Check the required parameter

Line 1420: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1416: p_api_name => lc_api_name);
1417:
1418: -- Delete row
1419: if (lc_proc_level >= lc_debug_level) then
1420: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1421: 'Calling Delete_Row table handler');
1422: end if;
1423:
1424: BEGIN

Line 1433: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_WORK_ENTITIES_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

1429:
1430: EXCEPTION
1431: WHEN OTHERS THEN
1432: IF ( lc_excep_level >= lc_debug_level) THEN
1433: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_WORK_ENTITIES_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1434: END IF;
1435: x_return_status := FND_API.G_RET_STS_ERROR;
1436: END;
1437:

Line 1443: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1439: RAISE FND_API.G_EXC_ERROR;
1440: END IF;
1441:
1442: if (lc_proc_level >= lc_debug_level) then
1443: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1444: 'Returned from Delete_Row table handler');
1445: end if;
1446:
1447: -- Api body ends here

Line 1460: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',

1456: (p_count => x_msg_count,
1457: p_data => x_msg_data );
1458:
1459: IF (lc_proc_level >= lc_debug_level) THEN
1460: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
1461: 'Leaving Delete_SC_Work_Entity');
1462: END IF;
1463:
1464: EXCEPTION

Line 1477: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1473: p_data => x_msg_data );
1474:
1475: -- save message in debug log
1476: IF (lc_excep_level >= lc_debug_level) THEN
1477: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1478: 'EXC_ERROR['||x_msg_data||']');
1479: END IF;
1480:
1481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1490: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1486: IF FND_MSG_PUB.Check_Msg_Level
1487: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1488: THEN
1489: if (lc_stat_level >= lc_debug_level) then
1490: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1491: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1492: end if;
1493: FND_MSG_PUB.Add_Exc_Msg
1494: (G_PKG_NAME ,

Line 1504: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1500: p_data => x_msg_data );
1501:
1502: -- save message in debug log
1503: IF (lc_excep_level >= lc_debug_level) THEN
1504: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1505: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
1506: END IF;
1507:
1508: WHEN OTHERS THEN

Line 1518: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1514: IF FND_MSG_PUB.Check_Msg_Level
1515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1516: THEN
1517: if (lc_stat_level >= lc_debug_level) then
1518: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1519: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1520: end if;
1521: FND_MSG_PUB.Add_Exc_Msg
1522: (G_PKG_NAME ,

Line 1533: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1529:
1530: -- save message in debug log
1531: IF (lc_excep_level >= lc_debug_level) THEN
1532: -- create a seeded message
1533: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1534: 'SQL Message['||sqlerrm||']' );
1535: END IF;
1536:
1537: END Delete_SC_Work_Entity;

Line 1558: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1554: p_sc_work_entity_rec IN SC_WORK_ENTITY_REC_TYPE
1555: )IS
1556:
1557: -- CONSTANTS --
1558: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1559: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1560: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1561: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1562: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 1559: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

1555: )IS
1556:
1557: -- CONSTANTS --
1558: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1559: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1560: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1561: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1562: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1563: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

Line 1560: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

1556:
1557: -- CONSTANTS --
1558: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1559: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1560: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1561: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1562: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1563: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1564: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 1561: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

1557: -- CONSTANTS --
1558: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1559: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1560: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1561: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1562: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1563: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1564: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1565: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.lock_sc_work_entity';

Line 1562: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

1558: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1559: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1560: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1561: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1562: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1563: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1564: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1565: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.lock_sc_work_entity';
1566: lc_api_name CONSTANT VARCHAR2(30) := 'Lock_SC_Work_Entity';

Line 1563: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

1559: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1560: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1561: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1562: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1563: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1564: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1565: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.lock_sc_work_entity';
1566: lc_api_name CONSTANT VARCHAR2(30) := 'Lock_SC_Work_Entity';
1567: lc_api_version CONSTANT NUMBER := 1.0;

Line 1564: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

1560: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1561: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1562: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1563: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1564: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1565: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_sc_work_entities_pvt.lock_sc_work_entity';
1566: lc_api_name CONSTANT VARCHAR2(30) := 'Lock_SC_Work_Entity';
1567: lc_api_version CONSTANT NUMBER := 1.0;
1568:

Line 1593: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

1589: FND_MSG_PUB.initialize;
1590: END IF;
1591:
1592: IF (lc_proc_level >= lc_debug_level) THEN
1593: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
1594: 'Entered Lock_SC_Work_Entity');
1595: END IF;
1596:
1597: -- Initialize API return status to success

Line 1604: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1600: -- Api body starts
1601:
1602: -- Check the required parameters
1603: if (lc_proc_level >= lc_debug_level) then
1604: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1605: 'Checking required parameters');
1606: end if;
1607:
1608: -- Check the required parameter

Line 1622: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1618: p_api_name => lc_api_name);
1619:
1620: -- Lock row
1621: if (lc_proc_level >= lc_debug_level) then
1622: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1623: 'Calling Lock_Row table handler');
1624: end if;
1625:
1626: BEGIN

Line 1668: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_WORK_ENTITIES_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

1664:
1665: EXCEPTION
1666: WHEN OTHERS THEN
1667: IF ( lc_excep_level >= lc_debug_level) THEN
1668: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SC_WORK_ENTITIES_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1669: END IF;
1670: x_return_status := FND_API.G_RET_STS_ERROR;
1671: END;
1672:

Line 1678: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1674: RAISE FND_API.G_EXC_ERROR;
1675: END IF;
1676:
1677: if (lc_proc_level >= lc_debug_level) then
1678: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1679: 'Returned from Lock_Row table handler');
1680: end if;
1681:
1682: -- Api body ends here

Line 1695: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',

1691: (p_count => x_msg_count,
1692: p_data => x_msg_data );
1693:
1694: IF (lc_proc_level >= lc_debug_level) THEN
1695: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
1696: 'Leaving Lock_SC_Domain');
1697: END IF;
1698:
1699: EXCEPTION

Line 1712: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1708: p_data => x_msg_data );
1709:
1710: -- save message in debug log
1711: IF (lc_excep_level >= lc_debug_level) THEN
1712: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1713: 'EXC_ERROR['||x_msg_data||']');
1714: END IF;
1715:
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1725: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1721: IF FND_MSG_PUB.Check_Msg_Level
1722: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1723: THEN
1724: if (lc_stat_level >= lc_debug_level) then
1725: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1726: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1727: end if;
1728: FND_MSG_PUB.Add_Exc_Msg
1729: (G_PKG_NAME ,

Line 1739: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1735: p_data => x_msg_data );
1736:
1737: -- save message in debug log
1738: IF (lc_excep_level >= lc_debug_level) THEN
1739: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1740: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
1741: END IF;
1742:
1743: WHEN OTHERS THEN

Line 1753: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1749: IF FND_MSG_PUB.Check_Msg_Level
1750: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1751: THEN
1752: if (lc_stat_level >= lc_debug_level) then
1753: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1754: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1755: end if;
1756: FND_MSG_PUB.Add_Exc_Msg
1757: (G_PKG_NAME ,

Line 1768: FND_LOG.STRING(lc_excep_level, lc_mod_name,

1764:
1765: -- save message in debug log
1766: IF (lc_excep_level >= lc_debug_level) THEN
1767: -- create a seeded message
1768: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1769: 'SQL Message['||sqlerrm||']' );
1770: END IF;
1771:
1772: END Lock_SC_Work_Entity;