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

Line 95: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

91: tmp.processing_set_id = P_PROCESSING_SET_ID
92: )
93: and nvl(purge_status, 'S') <> 'E';
94:
95: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
96: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Validate_FieldServiceObjects() after first validation ');
97: END IF;
98: /* Step 2: Mark SRs (for the given p_processing_set_id) as NOT a delete candidate
99: IF the SR is linked to mobile FS tasks that CANNOT be deleted

Line 96: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Validate_FieldServiceObjects() after first validation ');

92: )
93: and nvl(purge_status, 'S') <> 'E';
94:
95: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
96: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Validate_FieldServiceObjects() after first validation ');
97: END IF;
98: /* Step 2: Mark SRs (for the given p_processing_set_id) as NOT a delete candidate
99: IF the SR is linked to mobile FS tasks that CANNOT be deleted
100: */

Line 117: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

113: X_MSG_COUNT => l_msg_count,
114: X_MSG_DATA => l_msg_data);
115:
116: IF l_return_status = fnd_api.g_ret_sts_error THEN
117: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
118: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'csm_sr_purge_pkg.Validate_MobileFSObjects returned error ');
119: END IF;
120: RAISE fnd_api.g_exc_error;
121: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 118: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'csm_sr_purge_pkg.Validate_MobileFSObjects returned error ');

114: X_MSG_DATA => l_msg_data);
115:
116: IF l_return_status = fnd_api.g_ret_sts_error THEN
117: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
118: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'csm_sr_purge_pkg.Validate_MobileFSObjects returned error ');
119: END IF;
120: RAISE fnd_api.g_exc_error;
121: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
122: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

Line 122: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

118: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'csm_sr_purge_pkg.Validate_MobileFSObjects returned error ');
119: END IF;
120: RAISE fnd_api.g_exc_error;
121: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
122: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
123: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'csm_sr_purge_pkg.Validate_MobileFSObjects returned unexpected error ');
124: END IF;
125: RAISE fnd_api.g_exc_unexpected_error;
126: END IF;

Line 123: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'csm_sr_purge_pkg.Validate_MobileFSObjects returned unexpected error ');

119: END IF;
120: RAISE fnd_api.g_exc_error;
121: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
122: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
123: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'csm_sr_purge_pkg.Validate_MobileFSObjects returned unexpected error ');
124: END IF;
125: RAISE fnd_api.g_exc_unexpected_error;
126: END IF;
127:

Line 162: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

158: tmp.processing_set_id = P_PROCESSING_SET_ID
159: )
160: and nvl(purge_status, 'S') <> 'E';
161:
162: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
163: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Validate_FieldServiceObjects() after third validation ');
164: END IF;
165:
166: -- Standard check of p_commit

Line 163: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Validate_FieldServiceObjects() after third validation ');

159: )
160: and nvl(purge_status, 'S') <> 'E';
161:
162: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
163: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Validate_FieldServiceObjects() after third validation ');
164: END IF;
165:
166: -- Standard check of p_commit
167: -- IF fnd_api.to_boolean(p_commit) THEN

Line 327: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

323: dbfh.debrief_header_id = jtfnb.source_object_id and
324: jtfnb.source_object_code = 'DF'
325: );
326:
327: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
328: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task notes and note related objs ');
329: END IF;
330:
331: /* Step 2 - Delete relevant debrief lines and debrief line related objects:

Line 328: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task notes and note related objs ');

324: jtfnb.source_object_code = 'DF'
325: );
326:
327: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
328: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task notes and note related objs ');
329: END IF;
330:
331: /* Step 2 - Delete relevant debrief lines and debrief line related objects:
332: 1) CSF_DEBRIEF_LINES

Line 357: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

353: tska.task_assignment_id = dbfh.task_assignment_id and
354: dbfh.debrief_header_id = dbfl.debrief_header_id
355: );
356:
357: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
358: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task debriefed line details ');
359: END IF;
360:
361:

Line 358: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task debriefed line details ');

354: dbfh.debrief_header_id = dbfl.debrief_header_id
355: );
356:
357: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
358: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task debriefed line details ');
359: END IF;
360:
361:
362: /* Step 3 - Delete relevant debrief headers*/

Line 383: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

379: tskt.task_id = tska.task_id and
380: tska.task_assignment_id = dbfh.task_assignment_id
381: );
382:
383: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
384: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task debrief header details ');
385: END IF;
386:
387: /* Step 4 - Delete relevant requirement line details */

Line 384: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task debrief header details ');

380: tska.task_assignment_id = dbfh.task_assignment_id
381: );
382:
383: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
384: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task debrief header details ');
385: END IF;
386:
387: /* Step 4 - Delete relevant requirement line details */
388: DELETE /*+ index(crld) */ FROM CSP_REQ_LINE_DETAILS crld

Line 454: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

450: tskt.task_id = csprh.task_id
451: );
452:
453:
454: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
455: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task requirement headers and lines ');
456: END IF;
457:
458: /* Step 7 - Delete relevant required skills */

Line 455: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task requirement headers and lines ');

451: );
452:
453:
454: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
455: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task requirement headers and lines ');
456: END IF;
457:
458: /* Step 7 - Delete relevant required skills */
459: DELETE /*+ index(crsb) */ FROM CSF_REQUIRED_SKILLS_B crsb

Line 478: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

474: tskt.task_id = csfsk.has_skill_id and
475: csfsk.has_skill_type = 'TASK'
476: );
477:
478: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
479: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task required skills ');
480: END IF;
481:
482: /* Step 8 - Delete Access Hours */

Line 479: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task required skills ');

475: csfsk.has_skill_type = 'TASK'
476: );
477:
478: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
479: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task required skills ');
480: END IF;
481:
482: /* Step 8 - Delete Access Hours */
483: DELETE /*+ index(cahb) */ FROM CSF_ACCESS_HOURS_B cahb

Line 520: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

516: tmp.object_type = tskt.source_object_type_code and
517: tskt.task_id = csacc.task_id
518: );
519:
520: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task access hours details ');
522: END IF;
523:
524:

Line 521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task access hours details ');

517: tskt.task_id = csacc.task_id
518: );
519:
520: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task access hours details ');
522: END IF;
523:
524:
525: /* Step 9 - Delete Plan Options */

Line 566: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

562: tskt.task_id = csacc.task_id
563: );
564:
565:
566: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
567: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task plan options ');
568: END IF;
569:
570: /* Step 10 - Delete Schedule Requests */

Line 567: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task plan options ');

563: );
564:
565:
566: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
567: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task plan options ');
568: END IF;
569:
570: /* Step 10 - Delete Schedule Requests */
571: DELETE /*+ index(crsr) */ FROM CSF_R_SCHED_REQUESTS crsr

Line 610: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

606: tmp.object_type = tskt.source_object_type_code and
607: tskt.task_id = csacc.REQUEST_TASK_ID
608: );
609:
610: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
611: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task scheduled requests ');
612: END IF;
613:
614: /* Step 11 - Delete Resource Results */

Line 611: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task scheduled requests ');

607: tskt.task_id = csacc.REQUEST_TASK_ID
608: );
609:
610: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
611: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task scheduled requests ');
612: END IF;
613:
614: /* Step 11 - Delete Resource Results */
615: DELETE /*+ index(crso) */ FROM CSF_R_SPARES_OPTIONS crso

Line 655: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

651: tskt.task_id = csacc.REQUEST_TASK_ID
652: );
653:
654:
655: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
656: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task resource results ');
657: END IF;
658:
659:

Line 656: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task resource results ');

652: );
653:
654:
655: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
656: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task resource results ');
657: END IF;
658:
659:
660: /* Step 12 - Delete Messages and Message Tokens */

Line 700: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

696: tmp.object_type = tskt.source_object_type_code and
697: tskt.task_id = csacc.REQUEST_TASK_ID
698: );
699:
700: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task messages and message tokens ');
702: END IF;
703:
704:

Line 701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task messages and message tokens ');

697: tskt.task_id = csacc.REQUEST_TASK_ID
698: );
699:
700: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task messages and message tokens ');
702: END IF;
703:
704:
705:

Line 772: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

768: (nvl(jtfts.closed_flag,'N') = 'Y' or
769: nvl(jtfts.completed_flag,'N') = 'Y' or
770: nvl(jtfts.cancelled_flag,'N') = 'Y'));
771:
772: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS capacities ');
774: END IF;
775:
776:

Line 773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS capacities ');

769: nvl(jtfts.completed_flag,'N') = 'Y' or
770: nvl(jtfts.cancelled_flag,'N') = 'Y'));
771:
772: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS capacities ');
774: END IF;
775:
776:
777: -- Standard check of p_commit