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

Line 42: * 1 and 6 corresponding to FND_LOG's

38: * p_message Message you want to put in log.
39: * p_prefix Prefix of the message. Default value is
40: * DEBUG.
41: * p_msg_level Message Level.Default value is 1 and the value should be between
42: * 1 and 6 corresponding to FND_LOG's
43: * LEVEL_UNEXPECTED CONSTANT NUMBER := 6;
44: * LEVEL_ERROR CONSTANT NUMBER := 5;
45: * LEVEL_EXCEPTION CONSTANT NUMBER := 4;
46: * LEVEL_EVENT CONSTANT NUMBER := 3;

Line 70: p_msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,

66:
67: PROCEDURE debug (
68: p_message IN VARCHAR2,
69: p_prefix IN VARCHAR2 DEFAULT 'DEBUG',
70: p_msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
71: p_module_prefix IN VARCHAR2 DEFAULT 'JTF_RS_Package',
72: p_module IN VARCHAR2 DEFAULT 'JTF_RS_Module'
73: ) IS
74:

Line 88: if( p_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

84: ELSE
85: l_message :=SUBSTRB(p_message,1,4000);
86: END IF;
87:
88: if( p_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
89: FND_LOG.STRING(p_msg_level,l_module,l_message);
90: end if;
91:
92: END debug;

Line 89: FND_LOG.STRING(p_msg_level,l_module,l_message);

85: l_message :=SUBSTRB(p_message,1,4000);
86: END IF;
87:
88: if( p_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
89: FND_LOG.STRING(p_msg_level,l_module,l_message);
90: end if;
91:
92: END debug;
93:

Line 218: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

214:
215: l_api_name := 'DO_CREATE_RESOURCE';
216:
217: -- Debug info.
218: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
219: debug(p_message=>'do_create_resource (+)',
220: p_prefix =>l_debug_prefix,
221: p_msg_level=>fnd_log.level_statement);
222: END IF;

Line 221: p_msg_level=>fnd_log.level_statement);

217: -- Debug info.
218: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
219: debug(p_message=>'do_create_resource (+)',
220: p_prefix =>l_debug_prefix,
221: p_msg_level=>fnd_log.level_statement);
222: END IF;
223:
224: -- initialize variables
225: x_return_status := fnd_api.g_ret_sts_success;

Line 232: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

228: l_commit_count := 0;
229: l_batch_id := p_batch_id;
230:
231: -- Debug info.
232: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
233: debug(p_message=>'Batch Id : '||l_batch_id,
234: p_prefix =>l_debug_prefix,
235: p_msg_level=>fnd_log.level_statement);
236: END IF;

Line 235: p_msg_level=>fnd_log.level_statement);

231: -- Debug info.
232: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
233: debug(p_message=>'Batch Id : '||l_batch_id,
234: p_prefix =>l_debug_prefix,
235: p_msg_level=>fnd_log.level_statement);
236: END IF;
237:
238: -- Debug info.
239: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 239: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

235: p_msg_level=>fnd_log.level_statement);
236: END IF;
237:
238: -- Debug info.
239: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
240: debug(p_message=>'Validating Start date active ',
241: p_prefix =>l_debug_prefix,
242: p_msg_level=>fnd_log.level_statement);
243: END IF;

Line 242: p_msg_level=>fnd_log.level_statement);

238: -- Debug info.
239: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
240: debug(p_message=>'Validating Start date active ',
241: p_prefix =>l_debug_prefix,
242: p_msg_level=>fnd_log.level_statement);
243: END IF;
244:
245: --validate Start Date Active value.
246: -- Get translated value for 'Start Date Active cannot be null'

Line 263: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

259: -- Get the number of rows updated
260: l_commit_count := SQL%ROWCOUNT ;
261:
262: -- Debug info.
263: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
264: DEBUG(p_message=>'Records having Start date null in CREATE mode:'||
265: to_char(l_commit_count),
266: p_prefix =>l_debug_prefix,
267: p_msg_level=>fnd_log.level_statement);

Line 267: p_msg_level=>fnd_log.level_statement);

263: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
264: DEBUG(p_message=>'Records having Start date null in CREATE mode:'||
265: to_char(l_commit_count),
266: p_prefix =>l_debug_prefix,
267: p_msg_level=>fnd_log.level_statement);
268: END IF;
269:
270: IF l_commit_count >= 1000 THEN -- Commit if more than 1000 records.
271: COMMIT;

Line 276: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

272: l_commit_count := 0 ; -- reset the counter
273: END IF;
274:
275: -- Debug info.
276: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
277: debug(p_message=>'Validating Resource Name ',
278: p_prefix =>l_debug_prefix,
279: p_msg_level=>fnd_log.level_statement);
280: END IF;

Line 279: p_msg_level=>fnd_log.level_statement);

275: -- Debug info.
276: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
277: debug(p_message=>'Validating Resource Name ',
278: p_prefix =>l_debug_prefix,
279: p_msg_level=>fnd_log.level_statement);
280: END IF;
281:
282: --validate Resource Name value.
283: --Get traslated Resource Name to set prompts.

Line 307: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

303: -- Get the number of rows updated
304: l_commit_count := l_commit_count + SQL%ROWCOUNT ;
305:
306: -- Debug info.
307: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
308: DEBUG(p_message=>'Records having Resource Name NULL in CREATE mode:'||
309: to_char(SQL%ROWCOUNT),
310: p_prefix =>l_debug_prefix,
311: p_msg_level=>fnd_log.level_statement);

Line 311: p_msg_level=>fnd_log.level_statement);

307: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
308: DEBUG(p_message=>'Records having Resource Name NULL in CREATE mode:'||
309: to_char(SQL%ROWCOUNT),
310: p_prefix =>l_debug_prefix,
311: p_msg_level=>fnd_log.level_statement);
312: END IF;
313:
314: IF l_commit_count >= 1000 THEN -- Commit if more than 1000 records.
315: COMMIT;

Line 340: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

336:
337: BEGIN
338: SAVEPOINT do_create_resource_loop;
339: -- Debug info.
340: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
341: debug(p_message=>'Before Create Resource call for Interface ID :'
342: ||l_interface_id,
343: p_prefix =>l_debug_prefix,
344: p_msg_level=>fnd_log.level_statement);

Line 344: p_msg_level=>fnd_log.level_statement);

340: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
341: debug(p_message=>'Before Create Resource call for Interface ID :'
342: ||l_interface_id,
343: p_prefix =>l_debug_prefix,
344: p_msg_level=>fnd_log.level_statement);
345: END IF;
346:
347: --Call the Public procedure to Create Resource.
348: JTF_RS_RESOURCE_PUB.CREATE_RESOURCE(

Line 404: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

400: x_resource_number => x_resource_number
401: );
402:
403: -- Debug info.
404: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
405: debug(p_message=>'After Create Reource call Return Status : '
406: ||l_return_status,
407: p_prefix =>l_debug_prefix,
408: p_msg_level=>fnd_log.level_statement);

Line 408: p_msg_level=>fnd_log.level_statement);

404: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
405: debug(p_message=>'After Create Reource call Return Status : '
406: ||l_return_status,
407: p_prefix =>l_debug_prefix,
408: p_msg_level=>fnd_log.level_statement);
409: END IF;
410:
411: -- Message data reading logic
412: IF (l_return_status <> l_status_success

Line 421: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

417: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';
418: END LOOP;
419:
420:
421: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
422: debug(p_message=>'Message Count:'||l_msg_count,
423: p_prefix =>l_debug_prefix,
424: p_msg_level=>fnd_log.level_statement);
425: END IF;

Line 424: p_msg_level=>fnd_log.level_statement);

420:
421: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
422: debug(p_message=>'Message Count:'||l_msg_count,
423: p_prefix =>l_debug_prefix,
424: p_msg_level=>fnd_log.level_statement);
425: END IF;
426: -- Debug info.
427: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
428: debug(p_message=>'Message:'||l_msg_data1,

Line 427: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

423: p_prefix =>l_debug_prefix,
424: p_msg_level=>fnd_log.level_statement);
425: END IF;
426: -- Debug info.
427: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
428: debug(p_message=>'Message:'||l_msg_data1,
429: p_prefix =>l_debug_prefix,
430: p_msg_level=>fnd_log.level_statement);
431: END IF;

Line 430: p_msg_level=>fnd_log.level_statement);

426: -- Debug info.
427: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
428: debug(p_message=>'Message:'||l_msg_data1,
429: p_prefix =>l_debug_prefix,
430: p_msg_level=>fnd_log.level_statement);
431: END IF;
432: END IF;
433: ---- End of Message data reading logic
434:

Line 461: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

457: l_msg_data1 := SQLERRM;
458: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
459:
460: -- Debug info.
461: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
462: debug(p_message=>'Unexpected Error in Create Resource loop at'
463: ||' Batch Id :'||l_batch_id
464: ||' Interface Id :'||l_interface_id,
465: p_prefix =>l_debug_prefix,

Line 466: p_msg_level=>fnd_log.level_statement);

462: debug(p_message=>'Unexpected Error in Create Resource loop at'
463: ||' Batch Id :'||l_batch_id
464: ||' Interface Id :'||l_interface_id,
465: p_prefix =>l_debug_prefix,
466: p_msg_level=>fnd_log.level_statement);
467: END IF;
468:
469: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
470: debug(p_message=>'Error is : '||l_msg_data1,

Line 469: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

465: p_prefix =>l_debug_prefix,
466: p_msg_level=>fnd_log.level_statement);
467: END IF;
468:
469: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
470: debug(p_message=>'Error is : '||l_msg_data1,
471: p_prefix =>l_debug_prefix,
472: p_msg_level=>fnd_log.level_statement);
473: END IF;

Line 472: p_msg_level=>fnd_log.level_statement);

468:
469: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
470: debug(p_message=>'Error is : '||l_msg_data1,
471: p_prefix =>l_debug_prefix,
472: p_msg_level=>fnd_log.level_statement);
473: END IF;
474:
475: ROLLBACK TO do_create_resource_loop;
476:

Line 499: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

495:
496: COMMIT;
497:
498: -- Debug info.
499: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
500: debug(p_message =>' do_create_resource (-)',
501: p_prefix =>l_debug_prefix,
502: p_msg_level=>fnd_log.level_statement);
503: END IF;

Line 502: p_msg_level=>fnd_log.level_statement);

498: -- Debug info.
499: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
500: debug(p_message =>' do_create_resource (-)',
501: p_prefix =>l_debug_prefix,
502: p_msg_level=>fnd_log.level_statement);
503: END IF;
504: EXCEPTION
505: WHEN OTHERS THEN
506: -- Debug info.

Line 507: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

503: END IF;
504: EXCEPTION
505: WHEN OTHERS THEN
506: -- Debug info.
507: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
508: debug(p_message=>'Unexpected Error at do_create_resource procedure:'
509: ||SQLERRM,
510: p_prefix =>l_debug_prefix,
511: p_msg_level=>fnd_log.level_statement);

Line 511: p_msg_level=>fnd_log.level_statement);

507: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
508: debug(p_message=>'Unexpected Error at do_create_resource procedure:'
509: ||SQLERRM,
510: p_prefix =>l_debug_prefix,
511: p_msg_level=>fnd_log.level_statement);
512: END IF;
513:
514: -- if commit is there after 1000 recs and in update stmt, savepoint will
515: -- not be established.

Line 700: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

696: BEGIN
697:
698: SAVEPOINT do_update_resource;
699: -- Debug info.
700: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
701: debug(p_message=>' do_update_resource (+)',
702: p_prefix =>l_debug_prefix,
703: p_msg_level=>fnd_log.level_statement);
704: END IF;

Line 703: p_msg_level=>fnd_log.level_statement);

699: -- Debug info.
700: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
701: debug(p_message=>' do_update_resource (+)',
702: p_prefix =>l_debug_prefix,
703: p_msg_level=>fnd_log.level_statement);
704: END IF;
705:
706: -- initialize variables
707: l_api_name := 'DO_UPDATE_RESOURCE';

Line 716: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

712: l_commit_count := 0;
713: l_batch_id := p_batch_id;
714:
715: -- Debug info.
716: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
717: debug(p_message=>'Batch Id : '||l_batch_id,
718: p_prefix =>l_debug_prefix,
719: p_msg_level=>fnd_log.level_statement);
720: END IF;

Line 719: p_msg_level=>fnd_log.level_statement);

715: -- Debug info.
716: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
717: debug(p_message=>'Batch Id : '||l_batch_id,
718: p_prefix =>l_debug_prefix,
719: p_msg_level=>fnd_log.level_statement);
720: END IF;
721:
722:
723: -- Debug info.

Line 724: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

720: END IF;
721:
722:
723: -- Debug info.
724: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
725: debug(p_message=>'Validating Resource Id ',
726: p_prefix =>l_debug_prefix,
727: p_msg_level=>fnd_log.level_statement);
728: END IF;

Line 727: p_msg_level=>fnd_log.level_statement);

723: -- Debug info.
724: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
725: debug(p_message=>'Validating Resource Id ',
726: p_prefix =>l_debug_prefix,
727: p_msg_level=>fnd_log.level_statement);
728: END IF;
729:
730: --Validate if Resource Id value is NULL.
731: -- Get translated value for 'Resource Id cannot be null in Update mode.'

Line 748: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

744: -- Get the number of rows updated
745: l_commit_count := SQL%ROWCOUNT ;
746:
747: -- Debug info.
748: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
749: DEBUG(p_message=>'Resource Id cannot be null in UPDATE mode:'||
750: to_char(l_commit_count),
751: p_prefix =>l_debug_prefix,
752: p_msg_level=>fnd_log.level_statement);

Line 752: p_msg_level=>fnd_log.level_statement);

748: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
749: DEBUG(p_message=>'Resource Id cannot be null in UPDATE mode:'||
750: to_char(l_commit_count),
751: p_prefix =>l_debug_prefix,
752: p_msg_level=>fnd_log.level_statement);
753: END IF;
754:
755: IF l_commit_count >= 1000 THEN -- Commit if more than 1000 records.
756: COMMIT;

Line 781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

777: -- Get the number of rows updated
778: l_commit_count := l_commit_count + SQL%ROWCOUNT ;
779:
780: -- Debug info.
781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
782: DEBUG(p_message=>'Resource Id is not valid:'||
783: to_char(SQL%ROWCOUNT),
784: p_prefix =>l_debug_prefix,
785: p_msg_level=>fnd_log.level_statement);

Line 785: p_msg_level=>fnd_log.level_statement);

781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
782: DEBUG(p_message=>'Resource Id is not valid:'||
783: to_char(SQL%ROWCOUNT),
784: p_prefix =>l_debug_prefix,
785: p_msg_level=>fnd_log.level_statement);
786: END IF;
787:
788: IF l_commit_count >= 1000 THEN -- Commit if more than 1000 records.
789: COMMIT;

Line 821: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

817: -- Get the number of rows updated
818: l_commit_count := l_commit_count + SQL%ROWCOUNT ;
819:
820: -- Debug info.
821: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
822: DEBUG(p_message=>'Resource Id is not of OTHER category.'||
823: to_char(SQL%ROWCOUNT),
824: p_prefix =>l_debug_prefix,
825: p_msg_level=>fnd_log.level_statement);

Line 825: p_msg_level=>fnd_log.level_statement);

821: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
822: DEBUG(p_message=>'Resource Id is not of OTHER category.'||
823: to_char(SQL%ROWCOUNT),
824: p_prefix =>l_debug_prefix,
825: p_msg_level=>fnd_log.level_statement);
826: END IF;
827:
828: IF l_commit_count >= 1000 THEN -- Commit if more than 1000 records.
829: COMMIT;

Line 835: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

831: END IF;
832:
833:
834: -- Debug info.
835: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
836: debug(p_message=>'Validating - Resource Name cannot be updated to null ',
837: p_prefix =>l_debug_prefix,
838: p_msg_level=>fnd_log.level_statement);
839: END IF;

Line 838: p_msg_level=>fnd_log.level_statement);

834: -- Debug info.
835: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
836: debug(p_message=>'Validating - Resource Name cannot be updated to null ',
837: p_prefix =>l_debug_prefix,
838: p_msg_level=>fnd_log.level_statement);
839: END IF;
840:
841: --Validate if Resource Id value is NULL.
842: --'Resource Name should not be updated to NULL.'

Line 867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

863: -- Get the number of rows updated
864: l_commit_count := SQL%ROWCOUNT ;
865:
866: -- Debug info.
867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
868: DEBUG(p_message=>'Resource Name should not be updated to NULL:'||
869: to_char(l_commit_count),
870: p_prefix =>l_debug_prefix,
871: p_msg_level=>fnd_log.level_statement);

Line 871: p_msg_level=>fnd_log.level_statement);

867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
868: DEBUG(p_message=>'Resource Name should not be updated to NULL:'||
869: to_char(l_commit_count),
870: p_prefix =>l_debug_prefix,
871: p_msg_level=>fnd_log.level_statement);
872: END IF;
873:
874: IF l_commit_count >= 1000 THEN -- Commit if more than 1000 records.
875: COMMIT;

Line 880: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

876: l_commit_count := 0 ; -- reset the counter
877: END IF;
878:
879: -- Debug info.
880: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
881: debug(p_message=>'Validating - Active Start Date cannot be updated to null ',
882: p_prefix =>l_debug_prefix,
883: p_msg_level=>fnd_log.level_statement);
884: END IF;

Line 883: p_msg_level=>fnd_log.level_statement);

879: -- Debug info.
880: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
881: debug(p_message=>'Validating - Active Start Date cannot be updated to null ',
882: p_prefix =>l_debug_prefix,
883: p_msg_level=>fnd_log.level_statement);
884: END IF;
885:
886: --Validate if Resource Id value is NULL.
887: -- Get translated value for 'Start Date Active cannot be null'

Line 904: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

900: -- Get the number of rows updated
901: l_commit_count := SQL%ROWCOUNT ;
902:
903: -- Debug info.
904: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
905: DEBUG(p_message=>'Active Start Date should not be updated to NULL:'||
906: to_char(l_commit_count),
907: p_prefix =>l_debug_prefix,
908: p_msg_level=>fnd_log.level_statement);

Line 908: p_msg_level=>fnd_log.level_statement);

904: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
905: DEBUG(p_message=>'Active Start Date should not be updated to NULL:'||
906: to_char(l_commit_count),
907: p_prefix =>l_debug_prefix,
908: p_msg_level=>fnd_log.level_statement);
909: END IF;
910:
911: IF l_commit_count >= 1000 THEN -- Commit if more than 1000 records.
912: COMMIT;

Line 938: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

934: BEGIN
935: SAVEPOINT do_update_resource_loop;
936:
937: -- Debug info.
938: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
939: debug(p_message=>'Update Resource mode Interface Id :'||
940: l_interface_id ||' Resource Id :'||l_resource_id ,
941: p_prefix =>l_debug_prefix,
942: p_msg_level=>fnd_log.level_statement);

Line 942: p_msg_level=>fnd_log.level_statement);

938: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
939: debug(p_message=>'Update Resource mode Interface Id :'||
940: l_interface_id ||' Resource Id :'||l_resource_id ,
941: p_prefix =>l_debug_prefix,
942: p_msg_level=>fnd_log.level_statement);
943: END IF;
944:
945: --Get Object Version Number and End Date Active.
946: SELECT object_version_number,end_date_active,start_date_active

Line 979: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

975: fnd_profile.value('JTF_RS_INTF_END_DATE_CHILD') <> 'N'
976: )
977: THEN
978: -- Debug info.
979: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
980: debug(p_message=>'End date active is having value. '||
981: 'l_end_date_active:'||TO_CHAR(l_end_date_active,'dd-MM-RRRR hh24:mi:ss')||
982: 'l_end_date_active_db:'||TO_CHAR(l_end_date_active_db,'dd-MM-RRRR hh24:mi:ss'),
983: p_prefix =>l_debug_prefix,

Line 984: p_msg_level=>fnd_log.level_statement);

980: debug(p_message=>'End date active is having value. '||
981: 'l_end_date_active:'||TO_CHAR(l_end_date_active,'dd-MM-RRRR hh24:mi:ss')||
982: 'l_end_date_active_db:'||TO_CHAR(l_end_date_active_db,'dd-MM-RRRR hh24:mi:ss'),
983: p_prefix =>l_debug_prefix,
984: p_msg_level=>fnd_log.level_statement);
985: END IF;
986: JTF_RESOURCE_UTL.validate_input_dates
987: (p_start_date_active => l_start_date_active,
988: p_end_date_active => l_end_date_active,

Line 992: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

988: p_end_date_active => l_end_date_active,
989: x_return_status => l_return_status
990: );
991: -- Debug info.
992: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
993: debug(p_message=>'After Validating Date values Return Status : '||l_return_status,
994: p_prefix =>l_debug_prefix,
995: p_msg_level=>fnd_log.level_statement);
996: END IF;

Line 995: p_msg_level=>fnd_log.level_statement);

991: -- Debug info.
992: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
993: debug(p_message=>'After Validating Date values Return Status : '||l_return_status,
994: p_prefix =>l_debug_prefix,
995: p_msg_level=>fnd_log.level_statement);
996: END IF;
997:
998: IF l_return_status <> l_status_success THEN
999: -- l_start_date_active cannot be null so if this API returns error status means

Line 1013: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1009: WHERE interface_id = l_interface_id;
1010:
1011: -- When return status is NOT success then update Error details to Interface Table.
1012: -- Debug info.
1013: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1014: debug(p_message=>'Error in Update Resource loop at Resource Id,Batch Id, Interface Id : '||l_resource_id||' '||l_batch_id||' '||l_interface_id,
1015: p_prefix =>l_debug_prefix,
1016: p_msg_level=>fnd_log.level_statement);
1017: END IF;

Line 1016: p_msg_level=>fnd_log.level_statement);

1012: -- Debug info.
1013: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1014: debug(p_message=>'Error in Update Resource loop at Resource Id,Batch Id, Interface Id : '||l_resource_id||' '||l_batch_id||' '||l_interface_id,
1015: p_prefix =>l_debug_prefix,
1016: p_msg_level=>fnd_log.level_statement);
1017: END IF;
1018: -- Debug info.
1019: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1020: debug(p_message=>'Message:'||l_trans_message,

Line 1019: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1015: p_prefix =>l_debug_prefix,
1016: p_msg_level=>fnd_log.level_statement);
1017: END IF;
1018: -- Debug info.
1019: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1020: debug(p_message=>'Message:'||l_trans_message,
1021: p_prefix =>l_debug_prefix,
1022: p_msg_level=>fnd_log.level_statement);
1023: END IF;

Line 1022: p_msg_level=>fnd_log.level_statement);

1018: -- Debug info.
1019: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1020: debug(p_message=>'Message:'||l_trans_message,
1021: p_prefix =>l_debug_prefix,
1022: p_msg_level=>fnd_log.level_statement);
1023: END IF;
1024: END IF;
1025:
1026: IF l_return_status = l_status_success THEN

Line 1057: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1053: l_attribute14 <> l_miss_char OR l_attribute15 <> l_miss_char
1054: THEN
1055: l_other_value := TRUE; -- Other_value flag set to True.
1056: -- Debug info.
1057: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1058: debug(p_message=>'l_other_value set to TRUE',
1059: p_prefix =>l_debug_prefix,
1060: p_msg_level=>fnd_log.level_statement);
1061: END IF;

Line 1060: p_msg_level=>fnd_log.level_statement);

1056: -- Debug info.
1057: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1058: debug(p_message=>'l_other_value set to TRUE',
1059: p_prefix =>l_debug_prefix,
1060: p_msg_level=>fnd_log.level_statement);
1061: END IF;
1062:
1063: ELSE
1064: -- Other_value flag set to False. No value other than end date to be updated.

Line 1067: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1063: ELSE
1064: -- Other_value flag set to False. No value other than end date to be updated.
1065: l_other_value := FALSE;
1066: -- Debug info.
1067: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1068: debug(p_message=>'l_other_value set to FALSE',
1069: p_prefix =>l_debug_prefix,
1070: p_msg_level=>fnd_log.level_statement);
1071: END IF;

Line 1070: p_msg_level=>fnd_log.level_statement);

1066: -- Debug info.
1067: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1068: debug(p_message=>'l_other_value set to FALSE',
1069: p_prefix =>l_debug_prefix,
1070: p_msg_level=>fnd_log.level_statement);
1071: END IF;
1072:
1073: END IF;
1074:

Line 1078: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1074:
1075: IF NOT l_other_value THEN
1076:
1077: -- Debug info.
1078: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1079: debug(p_message=>'No value other than end date to be updated. ',
1080: p_prefix =>l_debug_prefix,
1081: p_msg_level=>fnd_log.level_statement);
1082: END IF;

Line 1081: p_msg_level=>fnd_log.level_statement);

1077: -- Debug info.
1078: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1079: debug(p_message=>'No value other than end date to be updated. ',
1080: p_prefix =>l_debug_prefix,
1081: p_msg_level=>fnd_log.level_statement);
1082: END IF;
1083:
1084: -- Other_value flag value is False. No value other than end date to be updated.
1085: -- Call only end_date_employee and move to next record.

Line 1098: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1094: x_msg_count => l_msg_count,
1095: x_msg_data => l_msg_data );
1096:
1097: -- Debug info.
1098: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1099: debug(p_message=>'After end_date_employee call Return Status : '||l_return_status,
1100: p_prefix =>l_debug_prefix,
1101: p_msg_level=>fnd_log.level_statement);
1102: END IF;

Line 1101: p_msg_level=>fnd_log.level_statement);

1097: -- Debug info.
1098: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1099: debug(p_message=>'After end_date_employee call Return Status : '||l_return_status,
1100: p_prefix =>l_debug_prefix,
1101: p_msg_level=>fnd_log.level_statement);
1102: END IF;
1103:
1104: ---- Message data reading logic
1105: IF (l_return_status <> l_status_success

Line 1113: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1109: FOR i IN 1..l_msg_count LOOP
1110: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';
1111: END LOOP;
1112:
1113: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1114: debug(p_message=>'Message Count:'||l_msg_count,
1115: p_prefix =>l_debug_prefix,
1116: p_msg_level=>fnd_log.level_statement);
1117: END IF;

Line 1116: p_msg_level=>fnd_log.level_statement);

1112:
1113: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1114: debug(p_message=>'Message Count:'||l_msg_count,
1115: p_prefix =>l_debug_prefix,
1116: p_msg_level=>fnd_log.level_statement);
1117: END IF;
1118: -- Debug info.
1119: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1120: debug(p_message=>'Message:'||l_msg_data1,

Line 1119: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1115: p_prefix =>l_debug_prefix,
1116: p_msg_level=>fnd_log.level_statement);
1117: END IF;
1118: -- Debug info.
1119: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1120: debug(p_message=>'Message:'||l_msg_data1,
1121: p_prefix =>l_debug_prefix,
1122: p_msg_level=>fnd_log.level_statement);
1123: END IF;

Line 1122: p_msg_level=>fnd_log.level_statement);

1118: -- Debug info.
1119: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1120: debug(p_message=>'Message:'||l_msg_data1,
1121: p_prefix =>l_debug_prefix,
1122: p_msg_level=>fnd_log.level_statement);
1123: END IF;
1124: END IF;
1125: ---- End of Message data reading logic
1126:

Line 1146: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1142: -- Other_value flag value is True.
1143: -- Call update_resource with end_date_active value and then
1144: -- call end_date_employee before moving to next record.
1145: -- Debug info.
1146: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1147: debug(p_message=>'Having other than end date to be updated. ',
1148: p_prefix =>l_debug_prefix,
1149: p_msg_level=>fnd_log.level_statement);
1150: END IF;

Line 1149: p_msg_level=>fnd_log.level_statement);

1145: -- Debug info.
1146: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1147: debug(p_message=>'Having other than end date to be updated. ',
1148: p_prefix =>l_debug_prefix,
1149: p_msg_level=>fnd_log.level_statement);
1150: END IF;
1151: jtf_rs_resource_pub.update_resource(
1152: p_api_version => l_api_version,
1153: p_init_msg_list => l_init_msg_list,

Line 1201: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1197: p_hold_reason_code => l_hold_reason_code,
1198: p_hold_payment => l_hold_payment
1199: );
1200: -- Debug info.
1201: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1202: debug(p_message=>'After Update Resource (without end date) call Return Status : '||l_return_status,
1203: p_prefix =>l_debug_prefix,
1204: p_msg_level=>fnd_log.level_statement);
1205: END IF;

Line 1204: p_msg_level=>fnd_log.level_statement);

1200: -- Debug info.
1201: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1202: debug(p_message=>'After Update Resource (without end date) call Return Status : '||l_return_status,
1203: p_prefix =>l_debug_prefix,
1204: p_msg_level=>fnd_log.level_statement);
1205: END IF;
1206:
1207: ---- Message data reading logic
1208: IF (l_return_status <> l_status_success

Line 1218: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1214: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';
1215: END LOOP;
1216:
1217: -- Debug info.
1218: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1219: debug(p_message=>'Message:'||l_msg_data1,
1220: p_prefix =>l_debug_prefix,
1221: p_msg_level=>fnd_log.level_statement);
1222: END IF;

Line 1221: p_msg_level=>fnd_log.level_statement);

1217: -- Debug info.
1218: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1219: debug(p_message=>'Message:'||l_msg_data1,
1220: p_prefix =>l_debug_prefix,
1221: p_msg_level=>fnd_log.level_statement);
1222: END IF;
1223: END IF;
1224: ---- End of Message data reading logic
1225:

Line 1235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1231: operation_process_date = SYSDATE
1232: WHERE interface_id = l_interface_id;
1233: ELSE-- When return status is NOT success then update Error details to Interface Table.
1234: -- Debug info.
1235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1236: debug(p_message=>'Error in Update Resource loop at Resource Id,Batch Id, Interface Id : '||l_resource_id||' '||l_batch_id||' '||l_interface_id,
1237: p_prefix =>l_debug_prefix,
1238: p_msg_level=>fnd_log.level_statement);
1239: END IF;

Line 1238: p_msg_level=>fnd_log.level_statement);

1234: -- Debug info.
1235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1236: debug(p_message=>'Error in Update Resource loop at Resource Id,Batch Id, Interface Id : '||l_resource_id||' '||l_batch_id||' '||l_interface_id,
1237: p_prefix =>l_debug_prefix,
1238: p_msg_level=>fnd_log.level_statement);
1239: END IF;
1240: UPDATE jtf_rs_resource_extns_int
1241: SET operation_status = l_return_status,
1242: operation_message = l_msg_data1,

Line 1253: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1249: --If update_resource without end_date value returns success
1250: --then only proceed further with end_date_employee call for current record.
1251: IF l_return_status = l_status_success THEN
1252: -- Debug info.
1253: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1254: debug(p_message=>'Before calling end_date_employee and after Update Resource (without end date) call.',
1255: p_prefix =>l_debug_prefix,
1256: p_msg_level=>fnd_log.level_statement);
1257: END IF;

Line 1256: p_msg_level=>fnd_log.level_statement);

1252: -- Debug info.
1253: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1254: debug(p_message=>'Before calling end_date_employee and after Update Resource (without end date) call.',
1255: p_prefix =>l_debug_prefix,
1256: p_msg_level=>fnd_log.level_statement);
1257: END IF;
1258:
1259: jtf_rs_resource_utl_pub.end_date_employee(
1260: p_api_version => 1.0,

Line 1271: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1267: x_msg_count => l_msg_count,
1268: x_msg_data => l_msg_data );
1269:
1270: -- Debug info.
1271: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1272: debug(p_message=>'After end_date_employee call Return Status : '||l_return_status,
1273: p_prefix =>l_debug_prefix,
1274: p_msg_level=>fnd_log.level_statement);
1275: END IF;

Line 1274: p_msg_level=>fnd_log.level_statement);

1270: -- Debug info.
1271: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1272: debug(p_message=>'After end_date_employee call Return Status : '||l_return_status,
1273: p_prefix =>l_debug_prefix,
1274: p_msg_level=>fnd_log.level_statement);
1275: END IF;
1276:
1277: ---- Message data reading logic
1278: IF (l_return_status <> l_status_success

Line 1286: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1282: FOR i IN 1..l_msg_count LOOP
1283: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';
1284: END LOOP;
1285:
1286: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1287: debug(p_message=>'Message Count:'||l_msg_count,
1288: p_prefix =>l_debug_prefix,
1289: p_msg_level=>fnd_log.level_statement);
1290: END IF;

Line 1289: p_msg_level=>fnd_log.level_statement);

1285:
1286: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1287: debug(p_message=>'Message Count:'||l_msg_count,
1288: p_prefix =>l_debug_prefix,
1289: p_msg_level=>fnd_log.level_statement);
1290: END IF;
1291: -- Debug info.
1292: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1293: debug(p_message=>'Message:'||l_msg_data1,

Line 1292: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1288: p_prefix =>l_debug_prefix,
1289: p_msg_level=>fnd_log.level_statement);
1290: END IF;
1291: -- Debug info.
1292: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1293: debug(p_message=>'Message:'||l_msg_data1,
1294: p_prefix =>l_debug_prefix,
1295: p_msg_level=>fnd_log.level_statement);
1296: END IF;

Line 1295: p_msg_level=>fnd_log.level_statement);

1291: -- Debug info.
1292: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1293: debug(p_message=>'Message:'||l_msg_data1,
1294: p_prefix =>l_debug_prefix,
1295: p_msg_level=>fnd_log.level_statement);
1296: END IF;
1297: END IF;
1298: ---- End of Message data reading logic
1299:

Line 1371: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1367: p_hold_reason_code => l_hold_reason_code,
1368: p_hold_payment => l_hold_payment
1369: );
1370: -- Debug info.
1371: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1372: debug(p_message=>'After Update Resource call Return Status : '||l_return_status,
1373: p_prefix =>l_debug_prefix,
1374: p_msg_level=>fnd_log.level_statement);
1375: END IF;

Line 1374: p_msg_level=>fnd_log.level_statement);

1370: -- Debug info.
1371: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1372: debug(p_message=>'After Update Resource call Return Status : '||l_return_status,
1373: p_prefix =>l_debug_prefix,
1374: p_msg_level=>fnd_log.level_statement);
1375: END IF;
1376:
1377: ---- Message data reading logic
1378: IF (l_return_status <> l_status_success

Line 1386: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1382: FOR i IN 1..l_msg_count LOOP
1383: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';
1384: END LOOP;
1385:
1386: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1387: debug(p_message=>'Message Count:'||l_msg_count,
1388: p_prefix =>l_debug_prefix,
1389: p_msg_level=>fnd_log.level_statement);
1390: END IF;

Line 1389: p_msg_level=>fnd_log.level_statement);

1385:
1386: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1387: debug(p_message=>'Message Count:'||l_msg_count,
1388: p_prefix =>l_debug_prefix,
1389: p_msg_level=>fnd_log.level_statement);
1390: END IF;
1391: -- Debug info.
1392: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1393: debug(p_message=>'Message:'||l_msg_data1,

Line 1392: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1388: p_prefix =>l_debug_prefix,
1389: p_msg_level=>fnd_log.level_statement);
1390: END IF;
1391: -- Debug info.
1392: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1393: debug(p_message=>'Message:'||l_msg_data1,
1394: p_prefix =>l_debug_prefix,
1395: p_msg_level=>fnd_log.level_statement);
1396: END IF;

Line 1395: p_msg_level=>fnd_log.level_statement);

1391: -- Debug info.
1392: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1393: debug(p_message=>'Message:'||l_msg_data1,
1394: p_prefix =>l_debug_prefix,
1395: p_msg_level=>fnd_log.level_statement);
1396: END IF;
1397: END IF;
1398: ---- End of Message data reading logic
1399:

Line 1426: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1422: l_msg_data1 := SQLERRM;
1423: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424:
1425: -- Debug info.
1426: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1427: debug(p_message=>'Unexpected Error in Update Resource loop at'
1428: ||' Batch Id :'||l_batch_id
1429: ||' Interface Id :'||l_interface_id,
1430: p_prefix =>l_debug_prefix,

Line 1431: p_msg_level=>fnd_log.level_statement);

1427: debug(p_message=>'Unexpected Error in Update Resource loop at'
1428: ||' Batch Id :'||l_batch_id
1429: ||' Interface Id :'||l_interface_id,
1430: p_prefix =>l_debug_prefix,
1431: p_msg_level=>fnd_log.level_statement);
1432: END IF;
1433:
1434: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1435: debug(p_message=>'Error is : '||l_msg_data1,

Line 1434: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1430: p_prefix =>l_debug_prefix,
1431: p_msg_level=>fnd_log.level_statement);
1432: END IF;
1433:
1434: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1435: debug(p_message=>'Error is : '||l_msg_data1,
1436: p_prefix =>l_debug_prefix,
1437: p_msg_level=>fnd_log.level_statement);
1438: END IF;

Line 1437: p_msg_level=>fnd_log.level_statement);

1433:
1434: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1435: debug(p_message=>'Error is : '||l_msg_data1,
1436: p_prefix =>l_debug_prefix,
1437: p_msg_level=>fnd_log.level_statement);
1438: END IF;
1439:
1440: ROLLBACK TO do_create_resource_loop;
1441:

Line 1463: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1459: CLOSE c_resource_int;
1460:
1461: COMMIT;
1462: -- Debug info.
1463: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1464: debug(p_message=>' do_update_resource (-)',
1465: p_prefix =>l_debug_prefix,
1466: p_msg_level=>fnd_log.level_statement);
1467: END IF;

Line 1466: p_msg_level=>fnd_log.level_statement);

1462: -- Debug info.
1463: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1464: debug(p_message=>' do_update_resource (-)',
1465: p_prefix =>l_debug_prefix,
1466: p_msg_level=>fnd_log.level_statement);
1467: END IF;
1468:
1469: EXCEPTION
1470: WHEN fnd_api.g_exc_error THEN

Line 1482: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1478: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1479: p_data => x_msg_data);
1480: WHEN OTHERS THEN
1481: -- Debug info.
1482: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1483: debug(p_message=>'Unexpected Error at do_update_resource procedure '||SQLERRM,
1484: p_prefix =>l_debug_prefix,
1485: p_msg_level=>fnd_log.level_statement);
1486: END IF;

Line 1485: p_msg_level=>fnd_log.level_statement);

1481: -- Debug info.
1482: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1483: debug(p_message=>'Unexpected Error at do_update_resource procedure '||SQLERRM,
1484: p_prefix =>l_debug_prefix,
1485: p_msg_level=>fnd_log.level_statement);
1486: END IF;
1487: ROLLBACK TO do_update_resource;
1488: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1489: fnd_message.set_token('P_SQLCODE',SQLCODE);

Line 1578: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1574: SAVEPOINT do_create_salesrep;
1575:
1576: l_api_name := 'DO_CREATE_SALESREP';
1577: -- Debug info.
1578: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1579: debug(p_message=>'do_create_salesrep (+)',
1580: p_prefix =>l_debug_prefix,
1581: p_msg_level=>fnd_log.level_statement);
1582: END IF;

Line 1581: p_msg_level=>fnd_log.level_statement);

1577: -- Debug info.
1578: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1579: debug(p_message=>'do_create_salesrep (+)',
1580: p_prefix =>l_debug_prefix,
1581: p_msg_level=>fnd_log.level_statement);
1582: END IF;
1583:
1584: -- initialize variables
1585: x_return_status := fnd_api.g_ret_sts_success;

Line 1592: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1588: l_commit_count := 0;
1589: l_batch_id := p_batch_id;
1590:
1591: -- Debug info.
1592: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1593: debug(p_message=>'Batch Id : '||l_batch_id,
1594: p_prefix =>l_debug_prefix,
1595: p_msg_level=>fnd_log.level_statement);
1596: END IF;

Line 1595: p_msg_level=>fnd_log.level_statement);

1591: -- Debug info.
1592: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1593: debug(p_message=>'Batch Id : '||l_batch_id,
1594: p_prefix =>l_debug_prefix,
1595: p_msg_level=>fnd_log.level_statement);
1596: END IF;
1597:
1598:
1599:

Line 1601: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1597:
1598:
1599:
1600: -- Debug info.
1601: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1602: debug(p_message=>'Validating Resource Id ',
1603: p_prefix =>l_debug_prefix,
1604: p_msg_level=>fnd_log.level_statement);
1605: END IF;

Line 1604: p_msg_level=>fnd_log.level_statement);

1600: -- Debug info.
1601: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1602: debug(p_message=>'Validating Resource Id ',
1603: p_prefix =>l_debug_prefix,
1604: p_msg_level=>fnd_log.level_statement);
1605: END IF;
1606:
1607: --validate Resource Id value.
1608: --Getting Translated 'Resource Id cannot be null'.

Line 1624: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1620: -- Get the number of rows updated
1621: l_commit_count := SQL%ROWCOUNT ;
1622:
1623: -- Debug info.
1624: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1625: DEBUG(p_message=>'Records having Resource Id null in CREATE mode:'||
1626: to_char(l_commit_count),
1627: p_prefix =>l_debug_prefix,
1628: p_msg_level=>fnd_log.level_statement);

Line 1628: p_msg_level=>fnd_log.level_statement);

1624: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1625: DEBUG(p_message=>'Records having Resource Id null in CREATE mode:'||
1626: to_char(l_commit_count),
1627: p_prefix =>l_debug_prefix,
1628: p_msg_level=>fnd_log.level_statement);
1629: END IF;
1630:
1631: IF l_commit_count >= 1000 THEN -- Commit if more than 1000 records.
1632: COMMIT;

Line 1636: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1632: COMMIT;
1633: l_commit_count := 0 ; -- reset the counter
1634: END IF;
1635: -- Debug info.
1636: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1637: debug(p_message=>'Validating Salesperson number ',
1638: p_prefix =>l_debug_prefix,
1639: p_msg_level=>fnd_log.level_statement);
1640: END IF;

Line 1639: p_msg_level=>fnd_log.level_statement);

1635: -- Debug info.
1636: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1637: debug(p_message=>'Validating Salesperson number ',
1638: p_prefix =>l_debug_prefix,
1639: p_msg_level=>fnd_log.level_statement);
1640: END IF;
1641:
1642:
1643: --validate Sales Number value.

Line 1660: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1656: -- Get the number of rows updated
1657: l_commit_count := SQL%ROWCOUNT ;
1658:
1659: -- Debug info.
1660: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1661: DEBUG(p_message=>'Records having Sales Person Number null in CREATE mode:'||
1662: to_char(l_commit_count),
1663: p_prefix =>l_debug_prefix,
1664: p_msg_level=>fnd_log.level_statement);

Line 1664: p_msg_level=>fnd_log.level_statement);

1660: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1661: DEBUG(p_message=>'Records having Sales Person Number null in CREATE mode:'||
1662: to_char(l_commit_count),
1663: p_prefix =>l_debug_prefix,
1664: p_msg_level=>fnd_log.level_statement);
1665: END IF;
1666:
1667: IF l_commit_count >= 1000 THEN -- Commit if more than 1000 records.
1668: COMMIT;

Line 1688: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1684: BEGIN
1685: SAVEPOINT do_create_salesrep_loop;
1686:
1687: -- Debug info.
1688: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1689: debug(p_message=>'Before Create Salesrep call for Interface ID : '||l_interface_id,
1690: p_prefix =>l_debug_prefix,
1691: p_msg_level=>fnd_log.level_statement);
1692: END IF;

Line 1691: p_msg_level=>fnd_log.level_statement);

1687: -- Debug info.
1688: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1689: debug(p_message=>'Before Create Salesrep call for Interface ID : '||l_interface_id,
1690: p_prefix =>l_debug_prefix,
1691: p_msg_level=>fnd_log.level_statement);
1692: END IF;
1693:
1694: --Call the Public procedure to Create Salesrep.
1695: JTF_RS_SALESREPS_PUB.create_salesrep

Line 1720: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1716: x_salesrep_id => x_salesrep_id
1717: );
1718:
1719: -- Debug info.
1720: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1721: debug(p_message=>'After Create Salesrep call Return Status : '||l_return_status,
1722: p_prefix =>l_debug_prefix,
1723: p_msg_level=>fnd_log.level_statement);
1724: END IF;

Line 1723: p_msg_level=>fnd_log.level_statement);

1719: -- Debug info.
1720: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1721: debug(p_message=>'After Create Salesrep call Return Status : '||l_return_status,
1722: p_prefix =>l_debug_prefix,
1723: p_msg_level=>fnd_log.level_statement);
1724: END IF;
1725:
1726: -- Message data reading logic
1727: IF (l_return_status <> l_status_success AND l_msg_count > 0)

Line 1734: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1730: FOR i IN 1..l_msg_count LOOP
1731: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';
1732: END LOOP;
1733:
1734: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1735: debug(p_message=>'Message Count:'||l_msg_count,
1736: p_prefix =>l_debug_prefix,
1737: p_msg_level=>fnd_log.level_statement);
1738: END IF;

Line 1737: p_msg_level=>fnd_log.level_statement);

1733:
1734: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1735: debug(p_message=>'Message Count:'||l_msg_count,
1736: p_prefix =>l_debug_prefix,
1737: p_msg_level=>fnd_log.level_statement);
1738: END IF;
1739: -- Debug info.
1740: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1741: debug(p_message=>'Message:'||l_msg_data1,

Line 1740: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1736: p_prefix =>l_debug_prefix,
1737: p_msg_level=>fnd_log.level_statement);
1738: END IF;
1739: -- Debug info.
1740: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1741: debug(p_message=>'Message:'||l_msg_data1,
1742: p_prefix =>l_debug_prefix,
1743: p_msg_level=>fnd_log.level_statement);
1744: END IF;

Line 1743: p_msg_level=>fnd_log.level_statement);

1739: -- Debug info.
1740: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1741: debug(p_message=>'Message:'||l_msg_data1,
1742: p_prefix =>l_debug_prefix,
1743: p_msg_level=>fnd_log.level_statement);
1744: END IF;
1745: END IF;
1746: ---- End of Message data reading logic
1747:

Line 1775: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1771: -- When any other unexpected error then try to capture it
1772: l_msg_data1 := SQLERRM;
1773: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1774: -- Debug info.
1775: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1776: debug(p_message=>'Unexpected Error in Create Salesrep loop at '||
1777: 'Batch Id ' ||l_batch_id||' Interface Id : '||l_interface_id,
1778: p_prefix =>l_debug_prefix,
1779: p_msg_level=>fnd_log.level_statement);

Line 1779: p_msg_level=>fnd_log.level_statement);

1775: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1776: debug(p_message=>'Unexpected Error in Create Salesrep loop at '||
1777: 'Batch Id ' ||l_batch_id||' Interface Id : '||l_interface_id,
1778: p_prefix =>l_debug_prefix,
1779: p_msg_level=>fnd_log.level_statement);
1780: END IF;
1781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1782: debug(p_message=>'Error is : '||l_msg_data1,
1783: p_prefix =>l_debug_prefix,

Line 1781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1777: 'Batch Id ' ||l_batch_id||' Interface Id : '||l_interface_id,
1778: p_prefix =>l_debug_prefix,
1779: p_msg_level=>fnd_log.level_statement);
1780: END IF;
1781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1782: debug(p_message=>'Error is : '||l_msg_data1,
1783: p_prefix =>l_debug_prefix,
1784: p_msg_level=>fnd_log.level_statement);
1785: END IF;

Line 1784: p_msg_level=>fnd_log.level_statement);

1780: END IF;
1781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1782: debug(p_message=>'Error is : '||l_msg_data1,
1783: p_prefix =>l_debug_prefix,
1784: p_msg_level=>fnd_log.level_statement);
1785: END IF;
1786:
1787: ROLLBACK TO do_create_salesrep_loop;
1788:

Line 1811: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1807:
1808: COMMIT;
1809:
1810: -- Debug info.
1811: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1812: debug(p_message=>' do_create_salesrep (-)',
1813: p_prefix =>l_debug_prefix,
1814: p_msg_level=>fnd_log.level_statement);
1815: END IF;

Line 1814: p_msg_level=>fnd_log.level_statement);

1810: -- Debug info.
1811: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1812: debug(p_message=>' do_create_salesrep (-)',
1813: p_prefix =>l_debug_prefix,
1814: p_msg_level=>fnd_log.level_statement);
1815: END IF;
1816:
1817: EXCEPTION
1818: WHEN OTHERS THEN

Line 1820: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1816:
1817: EXCEPTION
1818: WHEN OTHERS THEN
1819: -- Debug info.
1820: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1821: debug(p_message=>'Unexpected Error at do_create_salesrep procedure '||SQLERRM,
1822: p_prefix =>l_debug_prefix,
1823: p_msg_level=>fnd_log.level_statement);
1824: END IF;

Line 1823: p_msg_level=>fnd_log.level_statement);

1819: -- Debug info.
1820: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1821: debug(p_message=>'Unexpected Error at do_create_salesrep procedure '||SQLERRM,
1822: p_prefix =>l_debug_prefix,
1823: p_msg_level=>fnd_log.level_statement);
1824: END IF;
1825: -- if commit is there after 1000 recs and in update stmt, savepoint will
1826: -- not be established.
1827: -- ROLLBACK TO do_create_salesrep;

Line 1925: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1921:
1922: SAVEPOINT do_update_salesrep;
1923:
1924: -- Debug info.
1925: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1926: debug(p_message=>'do_update_salesrep (+)',
1927: p_prefix =>l_debug_prefix,
1928: p_msg_level=>fnd_log.level_statement);
1929: END IF;

Line 1928: p_msg_level=>fnd_log.level_statement);

1924: -- Debug info.
1925: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1926: debug(p_message=>'do_update_salesrep (+)',
1927: p_prefix =>l_debug_prefix,
1928: p_msg_level=>fnd_log.level_statement);
1929: END IF;
1930: -- initialize variables
1931: l_miss_date := FND_API.G_MISS_DATE;
1932: l_init_msg_list := fnd_api.g_true;

Line 1941: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1937: x_return_status := fnd_api.g_ret_sts_success;
1938: l_batch_id := p_batch_id;
1939:
1940: -- Debug info.
1941: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1942: debug(p_message=>'Batch Id : '||l_batch_id,
1943: p_prefix =>l_debug_prefix,
1944: p_msg_level=>fnd_log.level_statement);
1945: END IF;

Line 1944: p_msg_level=>fnd_log.level_statement);

1940: -- Debug info.
1941: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1942: debug(p_message=>'Batch Id : '||l_batch_id,
1943: p_prefix =>l_debug_prefix,
1944: p_msg_level=>fnd_log.level_statement);
1945: END IF;
1946:
1947: -- Debug info.
1948: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1948: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1944: p_msg_level=>fnd_log.level_statement);
1945: END IF;
1946:
1947: -- Debug info.
1948: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1949: debug(p_message=>'Validating SalesRep Id ',
1950: p_prefix =>l_debug_prefix,
1951: p_msg_level=>fnd_log.level_statement);
1952: END IF;

Line 1951: p_msg_level=>fnd_log.level_statement);

1947: -- Debug info.
1948: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1949: debug(p_message=>'Validating SalesRep Id ',
1950: p_prefix =>l_debug_prefix,
1951: p_msg_level=>fnd_log.level_statement);
1952: END IF;
1953:
1954: --validate SalesRep Id value.
1955: --Getting Translated 'Salesrep Id cannot be null.'.

Line 1972: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1968: -- Get the number of rows updated
1969: l_commit_count := SQL%ROWCOUNT ;
1970:
1971: -- Debug info.
1972: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1973: DEBUG(p_message=>'Records having Salesrep Id null in Update mode:'||
1974: to_char(l_commit_count),
1975: p_prefix =>l_debug_prefix,
1976: p_msg_level=>fnd_log.level_statement);

Line 1976: p_msg_level=>fnd_log.level_statement);

1972: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1973: DEBUG(p_message=>'Records having Salesrep Id null in Update mode:'||
1974: to_char(l_commit_count),
1975: p_prefix =>l_debug_prefix,
1976: p_msg_level=>fnd_log.level_statement);
1977: END IF;
1978:
1979: IF l_commit_count >= 1000 THEN -- Commit if more than 1000 records.
1980: COMMIT;

Line 2006: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2002: -- Get the number of rows updated
2003: l_commit_count := SQL%ROWCOUNT ;
2004:
2005: -- Debug info.
2006: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2007: DEBUG(p_message=>'Records having Invalid Salesrep Id in Update mode:'||
2008: to_char(l_commit_count),
2009: p_prefix =>l_debug_prefix,
2010: p_msg_level=>fnd_log.level_statement);

Line 2010: p_msg_level=>fnd_log.level_statement);

2006: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2007: DEBUG(p_message=>'Records having Invalid Salesrep Id in Update mode:'||
2008: to_char(l_commit_count),
2009: p_prefix =>l_debug_prefix,
2010: p_msg_level=>fnd_log.level_statement);
2011: END IF;
2012:
2013: IF l_commit_count >= 1000 THEN -- Commit if more than 1000 records.
2014: COMMIT;

Line 2042: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2038: FROM JTF_RS_SALESREPS
2039: WHERE salesrep_id = l_salesrep_id;
2040:
2041: -- Debug info.
2042: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2043: debug(p_message=>'Before Update Salesrep call for Interface ID : '
2044: ||l_interface_id||' SalesRep Id : '||l_salesrep_id,
2045: p_prefix =>l_debug_prefix,
2046: p_msg_level=>fnd_log.level_statement);

Line 2046: p_msg_level=>fnd_log.level_statement);

2042: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2043: debug(p_message=>'Before Update Salesrep call for Interface ID : '
2044: ||l_interface_id||' SalesRep Id : '||l_salesrep_id,
2045: p_prefix =>l_debug_prefix,
2046: p_msg_level=>fnd_log.level_statement);
2047: END IF;
2048:
2049: --Call the Public procedure to Update Salesrep.
2050: JTF_RS_SALESREPS_PUB.update_salesrep

Line 2076: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2072: );
2073:
2074:
2075: -- Debug info.
2076: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2077: debug(p_message=>'After Update Salesrep call Return Status : '||l_return_status,
2078: p_prefix =>l_debug_prefix,
2079: p_msg_level=>fnd_log.level_statement);
2080: END IF;

Line 2079: p_msg_level=>fnd_log.level_statement);

2075: -- Debug info.
2076: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2077: debug(p_message=>'After Update Salesrep call Return Status : '||l_return_status,
2078: p_prefix =>l_debug_prefix,
2079: p_msg_level=>fnd_log.level_statement);
2080: END IF;
2081:
2082: -- Message data reading logic
2083: IF (l_return_status <> l_status_success AND l_msg_count > 0)

Line 2090: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2086: FOR i IN 1..l_msg_count LOOP
2087: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';
2088: END LOOP;
2089:
2090: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2091: debug(p_message=>'Message Count:'||l_msg_count,
2092: p_prefix =>l_debug_prefix,
2093: p_msg_level=>fnd_log.level_statement);
2094: END IF;

Line 2093: p_msg_level=>fnd_log.level_statement);

2089:
2090: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2091: debug(p_message=>'Message Count:'||l_msg_count,
2092: p_prefix =>l_debug_prefix,
2093: p_msg_level=>fnd_log.level_statement);
2094: END IF;
2095: -- Debug info.
2096: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2097: debug(p_message=>'Message:'||l_msg_data1,

Line 2096: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2092: p_prefix =>l_debug_prefix,
2093: p_msg_level=>fnd_log.level_statement);
2094: END IF;
2095: -- Debug info.
2096: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2097: debug(p_message=>'Message:'||l_msg_data1,
2098: p_prefix =>l_debug_prefix,
2099: p_msg_level=>fnd_log.level_statement);
2100: END IF;

Line 2099: p_msg_level=>fnd_log.level_statement);

2095: -- Debug info.
2096: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2097: debug(p_message=>'Message:'||l_msg_data1,
2098: p_prefix =>l_debug_prefix,
2099: p_msg_level=>fnd_log.level_statement);
2100: END IF;
2101: END IF;
2102: ---- End of Message data reading logic
2103:

Line 2128: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2124: l_msg_data1 := SQLERRM;
2125: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2126:
2127: -- Debug info.
2128: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2129: debug(p_message=>'Unexpected Error in Update Salesrep loop at'
2130: ||' Batch Id :'||l_batch_id
2131: ||' Interface Id :'||l_interface_id,
2132: p_prefix =>l_debug_prefix,

Line 2133: p_msg_level=>fnd_log.level_statement);

2129: debug(p_message=>'Unexpected Error in Update Salesrep loop at'
2130: ||' Batch Id :'||l_batch_id
2131: ||' Interface Id :'||l_interface_id,
2132: p_prefix =>l_debug_prefix,
2133: p_msg_level=>fnd_log.level_statement);
2134: END IF;
2135:
2136: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2137: debug(p_message=>'Error is : '||l_msg_data1,

Line 2136: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2132: p_prefix =>l_debug_prefix,
2133: p_msg_level=>fnd_log.level_statement);
2134: END IF;
2135:
2136: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2137: debug(p_message=>'Error is : '||l_msg_data1,
2138: p_prefix =>l_debug_prefix,
2139: p_msg_level=>fnd_log.level_statement);
2140: END IF;

Line 2139: p_msg_level=>fnd_log.level_statement);

2135:
2136: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2137: debug(p_message=>'Error is : '||l_msg_data1,
2138: p_prefix =>l_debug_prefix,
2139: p_msg_level=>fnd_log.level_statement);
2140: END IF;
2141:
2142: ROLLBACK TO do_update_salesrep_loop;
2143:

Line 2166: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2162:
2163: COMMIT;
2164:
2165: -- Debug info.
2166: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2167: debug(p_message =>' do_create_salesrep (-)',
2168: p_prefix =>l_debug_prefix,
2169: p_msg_level=>fnd_log.level_statement);
2170: END IF;

Line 2169: p_msg_level=>fnd_log.level_statement);

2165: -- Debug info.
2166: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2167: debug(p_message =>' do_create_salesrep (-)',
2168: p_prefix =>l_debug_prefix,
2169: p_msg_level=>fnd_log.level_statement);
2170: END IF;
2171: EXCEPTION
2172: WHEN OTHERS THEN
2173: -- Debug info.

Line 2174: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2170: END IF;
2171: EXCEPTION
2172: WHEN OTHERS THEN
2173: -- Debug info.
2174: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2175: debug(p_message=>'Unexpected Error at do_update_salesrep procedure:'
2176: ||SQLERRM,
2177: p_prefix =>l_debug_prefix,
2178: p_msg_level=>fnd_log.level_statement);

Line 2178: p_msg_level=>fnd_log.level_statement);

2174: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2175: debug(p_message=>'Unexpected Error at do_update_salesrep procedure:'
2176: ||SQLERRM,
2177: p_prefix =>l_debug_prefix,
2178: p_msg_level=>fnd_log.level_statement);
2179: END IF;
2180:
2181: -- if commit is there after 1000 recs and in update stmt, savepoint will
2182: -- not be established.

Line 2241: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2237: x_msg_data => x_msg_data
2238: );
2239:
2240: -- Debug Info
2241: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2242: debug(p_message=> 'Create Resource API Return Values:'||
2243: ' p_batch_id :'||p_batch_id||
2244: ' x_return_status :'||x_return_status||
2245: ' x_msg_count :'||x_msg_count||

Line 2248: p_msg_level=>fnd_log.level_statement);

2244: ' x_return_status :'||x_return_status||
2245: ' x_msg_count :'||x_msg_count||
2246: ' x_msg_data :'||x_msg_data,
2247: p_prefix =>l_debug_prefix,
2248: p_msg_level=>fnd_log.level_statement);
2249: END IF;
2250:
2251: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN
2252: /* Call Update Resource */

Line 2259: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2255: x_msg_count => x_msg_count,
2256: x_msg_data => x_msg_data
2257: );
2258:
2259: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2260: debug(p_message=> 'Update Resource API Return Values:'||
2261: ' p_batch_id :'||p_batch_id||
2262: ' x_return_status :'||x_return_status||
2263: ' x_msg_count :'||x_msg_count||

Line 2266: p_msg_level=>fnd_log.level_statement);

2262: ' x_return_status :'||x_return_status||
2263: ' x_msg_count :'||x_msg_count||
2264: ' x_msg_data :'||x_msg_data,
2265: p_prefix =>l_debug_prefix,
2266: p_msg_level=>fnd_log.level_statement);
2267: END IF;
2268: ELSE
2269: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2270: debug(p_message=> 'Create Resource API Failed. Update Resource not executed.',

Line 2269: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2265: p_prefix =>l_debug_prefix,
2266: p_msg_level=>fnd_log.level_statement);
2267: END IF;
2268: ELSE
2269: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2270: debug(p_message=> 'Create Resource API Failed. Update Resource not executed.',
2271: p_prefix =>l_debug_prefix,
2272: p_msg_level=>fnd_log.level_statement);
2273: END IF;

Line 2272: p_msg_level=>fnd_log.level_statement);

2268: ELSE
2269: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2270: debug(p_message=> 'Create Resource API Failed. Update Resource not executed.',
2271: p_prefix =>l_debug_prefix,
2272: p_msg_level=>fnd_log.level_statement);
2273: END IF;
2274: END IF ;
2275:
2276: EXCEPTION WHEN OTHERS THEN

Line 2287: IF fnd_log.LEVEL_UNEXPECTED >=fnd_log.g_current_runtime_level THEN

2283: x_return_status := fnd_api.g_ret_sts_unexp_error;
2284: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2285: p_data => x_msg_data);
2286:
2287: IF fnd_log.LEVEL_UNEXPECTED >=fnd_log.g_current_runtime_level THEN
2288: debug(p_message=> 'Import Resource API raised EXCEPTION:'||
2289: ' p_batch_id :'||p_batch_id||
2290: ' Error :'||SQLERRM,
2291: p_prefix => l_debug_prefix,

Line 2292: p_msg_level=> fnd_log.LEVEL_UNEXPECTED);

2288: debug(p_message=> 'Import Resource API raised EXCEPTION:'||
2289: ' p_batch_id :'||p_batch_id||
2290: ' Error :'||SQLERRM,
2291: p_prefix => l_debug_prefix,
2292: p_msg_level=> fnd_log.LEVEL_UNEXPECTED);
2293: END IF;
2294:
2295: END import_resource;
2296: /**

Line 2342: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2338: x_msg_data => x_msg_data
2339: );
2340:
2341: -- Debug Info
2342: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2343: debug(p_message=> 'Create Salesrep API Return Values:'||
2344: ' p_batch_id :'||p_batch_id||
2345: ' x_return_status :'||x_return_status||
2346: ' x_msg_count :'||x_msg_count||

Line 2349: p_msg_level=>fnd_log.level_statement);

2345: ' x_return_status :'||x_return_status||
2346: ' x_msg_count :'||x_msg_count||
2347: ' x_msg_data :'||x_msg_data,
2348: p_prefix =>l_debug_prefix,
2349: p_msg_level=>fnd_log.level_statement);
2350: END IF;
2351:
2352: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN
2353: /* Call Update Salesrep */

Line 2360: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2356: x_msg_count => x_msg_count,
2357: x_msg_data => x_msg_data
2358: );
2359:
2360: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2361: debug(p_message=> 'Update Salesrep API Return Values:'||
2362: ' p_batch_id :'||p_batch_id||
2363: ' x_return_status :'||x_return_status||
2364: ' x_msg_count :'||x_msg_count||

Line 2367: p_msg_level=>fnd_log.level_statement);

2363: ' x_return_status :'||x_return_status||
2364: ' x_msg_count :'||x_msg_count||
2365: ' x_msg_data :'||x_msg_data,
2366: p_prefix =>l_debug_prefix,
2367: p_msg_level=>fnd_log.level_statement);
2368: END IF;
2369: ELSE
2370: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2371: debug(p_message=> 'Create Salesrep API Failed. Update Salesrep not executed.',

Line 2370: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2366: p_prefix =>l_debug_prefix,
2367: p_msg_level=>fnd_log.level_statement);
2368: END IF;
2369: ELSE
2370: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2371: debug(p_message=> 'Create Salesrep API Failed. Update Salesrep not executed.',
2372: p_prefix =>l_debug_prefix,
2373: p_msg_level=>fnd_log.level_statement);
2374: END IF;

Line 2373: p_msg_level=>fnd_log.level_statement);

2369: ELSE
2370: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2371: debug(p_message=> 'Create Salesrep API Failed. Update Salesrep not executed.',
2372: p_prefix =>l_debug_prefix,
2373: p_msg_level=>fnd_log.level_statement);
2374: END IF;
2375: END IF ;
2376:
2377: EXCEPTION WHEN OTHERS THEN

Line 2388: IF fnd_log.LEVEL_UNEXPECTED >=fnd_log.g_current_runtime_level THEN

2384: x_return_status := fnd_api.g_ret_sts_unexp_error;
2385: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2386: p_data => x_msg_data);
2387:
2388: IF fnd_log.LEVEL_UNEXPECTED >=fnd_log.g_current_runtime_level THEN
2389: debug(p_message=> 'Import Salesrep API raised EXCEPTION:'||
2390: ' p_batch_id :'||p_batch_id||
2391: ' Error :'||SQLERRM,
2392: p_prefix => l_debug_prefix,

Line 2393: p_msg_level=> fnd_log.LEVEL_UNEXPECTED);

2389: debug(p_message=> 'Import Salesrep API raised EXCEPTION:'||
2390: ' p_batch_id :'||p_batch_id||
2391: ' Error :'||SQLERRM,
2392: p_prefix => l_debug_prefix,
2393: p_msg_level=> fnd_log.LEVEL_UNEXPECTED);
2394: END IF;
2395:
2396:
2397: END import_salesreps;