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.IEX_COLLECTORS_TO_RESOURCE dependencies on FND_FILE

Line 32: fnd_file.put_line(FND_FILE.LOG,'Updating collector resources started ');

28: IF (p_debug = 'Y') THEN
29: dbms_session.set_sql_trace(TRUE);
30: END IF;
31:
32: fnd_file.put_line(FND_FILE.LOG,'Updating collector resources started ');
33: fnd_file.put_line(FND_FILE.LOG,'Parameter : p_debug := ' || P_debug);
34:
35: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 1 := '|| P_resp1);
36: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 2 := '|| p_resp2);

Line 33: fnd_file.put_line(FND_FILE.LOG,'Parameter : p_debug := ' || P_debug);

29: dbms_session.set_sql_trace(TRUE);
30: END IF;
31:
32: fnd_file.put_line(FND_FILE.LOG,'Updating collector resources started ');
33: fnd_file.put_line(FND_FILE.LOG,'Parameter : p_debug := ' || P_debug);
34:
35: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 1 := '|| P_resp1);
36: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 2 := '|| p_resp2);
37: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 3 := '|| p_resp3);

Line 35: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 1 := '|| P_resp1);

31:
32: fnd_file.put_line(FND_FILE.LOG,'Updating collector resources started ');
33: fnd_file.put_line(FND_FILE.LOG,'Parameter : p_debug := ' || P_debug);
34:
35: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 1 := '|| P_resp1);
36: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 2 := '|| p_resp2);
37: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 3 := '|| p_resp3);
38: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 4 := '|| p_resp4);
39: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 5 := '|| p_resp5);

Line 36: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 2 := '|| p_resp2);

32: fnd_file.put_line(FND_FILE.LOG,'Updating collector resources started ');
33: fnd_file.put_line(FND_FILE.LOG,'Parameter : p_debug := ' || P_debug);
34:
35: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 1 := '|| P_resp1);
36: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 2 := '|| p_resp2);
37: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 3 := '|| p_resp3);
38: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 4 := '|| p_resp4);
39: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 5 := '|| p_resp5);
40:

Line 37: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 3 := '|| p_resp3);

33: fnd_file.put_line(FND_FILE.LOG,'Parameter : p_debug := ' || P_debug);
34:
35: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 1 := '|| P_resp1);
36: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 2 := '|| p_resp2);
37: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 3 := '|| p_resp3);
38: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 4 := '|| p_resp4);
39: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 5 := '|| p_resp5);
40:
41: If (P_debug = 'Y') then

Line 38: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 4 := '|| p_resp4);

34:
35: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 1 := '|| P_resp1);
36: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 2 := '|| p_resp2);
37: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 3 := '|| p_resp3);
38: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 4 := '|| p_resp4);
39: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 5 := '|| p_resp5);
40:
41: If (P_debug = 'Y') then
42: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;

Line 39: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 5 := '|| p_resp5);

35: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 1 := '|| P_resp1);
36: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 2 := '|| p_resp2);
37: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 3 := '|| p_resp3);
38: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 4 := '|| p_resp4);
39: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 5 := '|| p_resp5);
40:
41: If (P_debug = 'Y') then
42: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
43: fnd_file.put_line(FND_FILE.LOG,'Date and Time Before starting the update on ar_collectors '|| l_date_time );

Line 43: fnd_file.put_line(FND_FILE.LOG,'Date and Time Before starting the update on ar_collectors '|| l_date_time );

39: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 5 := '|| p_resp5);
40:
41: If (P_debug = 'Y') then
42: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
43: fnd_file.put_line(FND_FILE.LOG,'Date and Time Before starting the update on ar_collectors '|| l_date_time );
44: End If;
45:
46: /* kasreeni 07/14/2005 Changed to Merge_Collectors as function */
47: /* kasreeni 07/14/2005 Missed a COMMIT, when no responsibility selected */

Line 71: fnd_file.put_line(FND_FILE.LOG,' Select atleast one responsibility in the parameters ');

67: UPDATE_COLLECTORS_PVT(p_resp => P_RESP5,p_debug => p_debug);
68: END IF;
69:
70: IF (P_RESP1 IS NULL AND P_RESP2 IS NULL AND P_RESP3 IS NULL AND P_RESP4 IS NULL AND P_RESP5 IS NULL) THEN
71: fnd_file.put_line(FND_FILE.LOG,' Select atleast one responsibility in the parameters ');
72: END IF;
73:
74: END;
75:

Line 84: fnd_file.put_line(FND_FILE.LOG,'Date and Time Before starting the update on ar_collectors '|| l_date_time );

80: l_date_time VARCHAR2(25);
81: BEGIN
82: If (P_debug = 'Y') then
83: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
84: fnd_file.put_line(FND_FILE.LOG,'Date and Time Before starting the update on ar_collectors '|| l_date_time );
85: End If;
86:
87: UPDATE ar_collectors ARC set
88: resource_type = 'RS_RESOURCE',

Line 102: fnd_file.put_line(FND_FILE.LOG, l_colcount || ' Record(s) updated in ar_collectors by merging Resource' ) ;

98: WHERE employee_id is not null
99: AND resource_id is null;
100:
101: l_colcount := sql%rowcount;
102: fnd_file.put_line(FND_FILE.LOG, l_colcount || ' Record(s) updated in ar_collectors by merging Resource' ) ;
103: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
104: If (P_debug = 'Y') then
105: fnd_file.put_line(FND_FILE.LOG,'Date and Time After finishing the update on ar_collectors'|| l_date_time );
106: End If;

Line 105: fnd_file.put_line(FND_FILE.LOG,'Date and Time After finishing the update on ar_collectors'|| l_date_time );

101: l_colcount := sql%rowcount;
102: fnd_file.put_line(FND_FILE.LOG, l_colcount || ' Record(s) updated in ar_collectors by merging Resource' ) ;
103: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
104: If (P_debug = 'Y') then
105: fnd_file.put_line(FND_FILE.LOG,'Date and Time After finishing the update on ar_collectors'|| l_date_time );
106: End If;
107: if (l_colcount > 0) then
108: COMMIT;
109: end if;

Line 112: fnd_file.put_line(FND_FILE.LOG, 'Error while update the ar_collectors' || sqlerrm);

108: COMMIT;
109: end if;
110:
111: Exception when others then
112: fnd_file.put_line(FND_FILE.LOG, 'Error while update the ar_collectors' || sqlerrm);
113: END;
114: /* END KASREENI 05/17/2005 MADE IT AS PROCEDURE TO NORMALIZE */
115:
116: PROCEDURE UPDATE_COLLECTORS_PVT

Line 170: fnd_file.put_line(FND_FILE.LOG,'Updating collector resource pvt started for Responsibility ' || P_RESP);

166: l_check NUMBER;
167:
168: BEGIN
169:
170: fnd_file.put_line(FND_FILE.LOG,'Updating collector resource pvt started for Responsibility ' || P_RESP);
171: --RETCODE := 'TRUE';
172: --Bug4930348. Use Responsibility Id. Fix by LKKUMAR on 16-Jan-2006. Start.
173: OPEN C_RESPONSIBILITY;
174: FETCH C_RESPONSIBILITY INTO l_responsibility_id;

Line 178: fnd_file.put_line(FND_FILE.LOG, 'Responsibility Id Fetched is ' || l_responsibility_id );

174: FETCH C_RESPONSIBILITY INTO l_responsibility_id;
175: CLOSE C_RESPONSIBILITY;
176:
177: If (P_debug = 'Y') then
178: fnd_file.put_line(FND_FILE.LOG, 'Responsibility Id Fetched is ' || l_responsibility_id );
179: End If;
180: --Bug4930348. Use Responsibility Id. Fix by LKKUMAR on 16-Jan-2006. End.
181:
182:

Line 185: fnd_file.put_line(FND_FILE.LOG,'Starting the conversion ' || l_date_time);

181:
182:
183:
184: SELECT to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
185: fnd_file.put_line(FND_FILE.LOG,'Starting the conversion ' || l_date_time);
186:
187:
188: -- Inserting in to AR_COLLECTORS
189:

Line 192: fnd_file.put_line(FND_FILE.LOG,'Date and Time After finishing the update '|| l_date_time );

188: -- Inserting in to AR_COLLECTORS
189:
190: If (P_debug = 'Y') then
191: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
192: fnd_file.put_line(FND_FILE.LOG,'Date and Time After finishing the update '|| l_date_time );
193: End If;
194:
195:
196: -- Inserting in to AR_COLLECTORS

Line 200: fnd_file.put_line(FND_FILE.LOG,'Date and Time Before starting the Insert '|| l_date_time );

196: -- Inserting in to AR_COLLECTORS
197: FOR I IN INSERT_RESOURCE LOOP
198: If (P_debug = 'Y') then
199: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
200: fnd_file.put_line(FND_FILE.LOG,'Date and Time Before starting the Insert '|| l_date_time );
201: End If;
202: BEGIN
203: SELECT AR_COLLECTORS_S.NEXTVAL
204: INTO L_COLLECTOR_ID

Line 208: fnd_file.put_line(FND_FILE.LOG,'Error while selecting the colector_id sequence ' || SQLERRM);

204: INTO L_COLLECTOR_ID
205: FROM DUAL;
206: Exception when others then
207: If (P_debug = 'Y') then
208: fnd_file.put_line(FND_FILE.LOG,'Error while selecting the colector_id sequence ' || SQLERRM);
209: End If;
210: END;
211: If (p_debug = 'Y') then
212: fnd_file.put_line(FND_FILE.LOG,'Before Starting to insert Resouce_id ' || i.resource_id || ' For Responsibility ' || p_resp);

Line 212: fnd_file.put_line(FND_FILE.LOG,'Before Starting to insert Resouce_id ' || i.resource_id || ' For Responsibility ' || p_resp);

208: fnd_file.put_line(FND_FILE.LOG,'Error while selecting the colector_id sequence ' || SQLERRM);
209: End If;
210: END;
211: If (p_debug = 'Y') then
212: fnd_file.put_line(FND_FILE.LOG,'Before Starting to insert Resouce_id ' || i.resource_id || ' For Responsibility ' || p_resp);
213: End If;
214:
215: BEGIN
216: INSERT INTO AR_COLLECTORS

Line 246: fnd_file.put_line(FND_FILE.LOG, 'Error while Inserting into AR_COLLECTORS' || SQLERRM);

242:
243: l_colcount := NVL(l_colcount,0) + 1;
244:
245: Exception When Others then
246: fnd_file.put_line(FND_FILE.LOG, 'Error while Inserting into AR_COLLECTORS' || SQLERRM);
247: END;
248: BEGIN
249: SELECT 1
250: INTO l_check

Line 262: fnd_file.put_line(FND_FILE.LOG,'Role found for resource id ' || i.resource_id);

258: AND jtfrs.source_id is not null
259: AND jtfrs.resource_id = i.resource_id;
260:
261: If (p_debug = 'Y') then
262: fnd_file.put_line(FND_FILE.LOG,'Role found for resource id ' || i.resource_id);
263: End If;
264:
265: Exception when no_data_found then
266: If (p_debug = 'Y') then

Line 267: fnd_file.put_line(FND_FILE.LOG,'Role not found for resource id ' || i.resource_id);

263: End If;
264:
265: Exception when no_data_found then
266: If (p_debug = 'Y') then
267: fnd_file.put_line(FND_FILE.LOG,'Role not found for resource id ' || i.resource_id);
268: fnd_file.put_line(FND_FILE.LOG,'Creating Role for resource id ' || i.resource_id);
269: End If;
270: OPEN C_ROLE_ID;
271: FETCH C_ROLE_ID into l_Role_id;

Line 268: fnd_file.put_line(FND_FILE.LOG,'Creating Role for resource id ' || i.resource_id);

264:
265: Exception when no_data_found then
266: If (p_debug = 'Y') then
267: fnd_file.put_line(FND_FILE.LOG,'Role not found for resource id ' || i.resource_id);
268: fnd_file.put_line(FND_FILE.LOG,'Creating Role for resource id ' || i.resource_id);
269: End If;
270: OPEN C_ROLE_ID;
271: FETCH C_ROLE_ID into l_Role_id;
272: CLOSE C_ROLE_ID;

Line 289: fnd_file.put_line(FND_FILE.LOG,'After Creating role for resource_id: ' || i.resource_id || ' Responsibility: ' ||

285: X_MSG_DATA => l_msg_data,
286: X_ROLE_RELATE_ID => l_role_relate_id
287: );
288: If (p_debug = 'Y') then
289: fnd_file.put_line(FND_FILE.LOG,'After Creating role for resource_id: ' || i.resource_id || ' Responsibility: ' ||
290: p_resp || ' Return Status ' || l_return_status || ' Role Relate id ' || l_role_relate_id);
291: End If;
292: Exception when others then
293: fnd_file.put_line(FND_FILE.LOG,'Error while creating the Role for the resource_id ' || i.resource_id || SQLERRM);

Line 293: fnd_file.put_line(FND_FILE.LOG,'Error while creating the Role for the resource_id ' || i.resource_id || SQLERRM);

289: fnd_file.put_line(FND_FILE.LOG,'After Creating role for resource_id: ' || i.resource_id || ' Responsibility: ' ||
290: p_resp || ' Return Status ' || l_return_status || ' Role Relate id ' || l_role_relate_id);
291: End If;
292: Exception when others then
293: fnd_file.put_line(FND_FILE.LOG,'Error while creating the Role for the resource_id ' || i.resource_id || SQLERRM);
294: END;
295: END;
296:
297: End Loop;

Line 302: fnd_file.put_line(FND_FILE.LOG,'Date and Time Finish '|| l_date_time );

298:
299: COMMIT;
300:
301: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
302: fnd_file.put_line(FND_FILE.LOG,'Date and Time Finish '|| l_date_time );
303: fnd_file.put_line(FND_FILE.LOG,'No. of Collector(s) Added '|| l_colcount);
304:
305:
306: EXCEPTION WHEN OTHERS THEN

Line 303: fnd_file.put_line(FND_FILE.LOG,'No. of Collector(s) Added '|| l_colcount);

299: COMMIT;
300:
301: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
302: fnd_file.put_line(FND_FILE.LOG,'Date and Time Finish '|| l_date_time );
303: fnd_file.put_line(FND_FILE.LOG,'No. of Collector(s) Added '|| l_colcount);
304:
305:
306: EXCEPTION WHEN OTHERS THEN
307: fnd_file.put_line(FND_FILE.LOG,'Error in update_colectors_pvt for Responsibility ' || P_RESP);

Line 307: fnd_file.put_line(FND_FILE.LOG,'Error in update_colectors_pvt for Responsibility ' || P_RESP);

303: fnd_file.put_line(FND_FILE.LOG,'No. of Collector(s) Added '|| l_colcount);
304:
305:
306: EXCEPTION WHEN OTHERS THEN
307: fnd_file.put_line(FND_FILE.LOG,'Error in update_colectors_pvt for Responsibility ' || P_RESP);
308: -- Begin - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
309: FND_FILE.put_line(FND_FILE.LOG, 'EXCEPTION!!!!! -> ' || SQLERRM );
310: -- End - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
311:

Line 309: FND_FILE.put_line(FND_FILE.LOG, 'EXCEPTION!!!!! -> ' || SQLERRM );

305:
306: EXCEPTION WHEN OTHERS THEN
307: fnd_file.put_line(FND_FILE.LOG,'Error in update_colectors_pvt for Responsibility ' || P_RESP);
308: -- Begin - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
309: FND_FILE.put_line(FND_FILE.LOG, 'EXCEPTION!!!!! -> ' || SQLERRM );
310: -- End - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
311:
312: END UPDATE_COLLECTORS_PVT;
313:

Line 456: fnd_file.put_line(FND_FILE.LOG,'Date and Time Start conversion '|| l_date_time );

452:
453:
454: BEGIN
455: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
456: fnd_file.put_line(FND_FILE.LOG,'Date and Time Start conversion '|| l_date_time );
457:
458: OPEN C_ROLE_ID;
459: FETCH C_ROLE_ID INTO l_Role_id;
460: CLOSE C_ROLE_ID;

Line 465: FND_FILE.put_line(FND_FILE.LOG, 'No COLLECTOR ROLE seeded in the system ' );

461:
462: l_colcount := 0;
463:
464: if l_Role_id is NULL then
465: FND_FILE.put_line(FND_FILE.LOG, 'No COLLECTOR ROLE seeded in the system ' );
466: FND_FILE.put_line(FND_FILE.LOG, ' ');
467: RETCODE := 'FALSE';
468: return;
469: end if;

Line 466: FND_FILE.put_line(FND_FILE.LOG, ' ');

462: l_colcount := 0;
463:
464: if l_Role_id is NULL then
465: FND_FILE.put_line(FND_FILE.LOG, 'No COLLECTOR ROLE seeded in the system ' );
466: FND_FILE.put_line(FND_FILE.LOG, ' ');
467: RETCODE := 'FALSE';
468: return;
469: end if;
470:

Line 502: FND_FILE.put_line(FND_FILE.LOG, 'EXCEPTION!!!!! -> ' || SQLERRM );

498: -- End - Bug#5383877 - Andre Araujo - 07/18/2006 - With this statement there will be no updates
499: EXCEPTION WHEN OTHERS THEN
500: -- Begin - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
501: --NULL;
502: FND_FILE.put_line(FND_FILE.LOG, 'EXCEPTION!!!!! -> ' || SQLERRM );
503: -- End - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
504: END;
505:
506: -- Check whether Collections Role Exists for the Resource and Create if Role does'nt exist.

Line 534: FND_FILE.put_line(FND_FILE.LOG, 'Error while creting roles' || l_msg_data );

530: );
531: COMMIT;
532: EXCEPTION
533: WHEN OTHERS THEN
534: FND_FILE.put_line(FND_FILE.LOG, 'Error while creting roles' || l_msg_data );
535: -- Begin - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
536: FND_FILE.put_line(FND_FILE.LOG, SQLERRM );
537: -- End - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
538: END;

Line 536: FND_FILE.put_line(FND_FILE.LOG, SQLERRM );

532: EXCEPTION
533: WHEN OTHERS THEN
534: FND_FILE.put_line(FND_FILE.LOG, 'Error while creting roles' || l_msg_data );
535: -- Begin - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
536: FND_FILE.put_line(FND_FILE.LOG, SQLERRM );
537: -- End - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
538: END;
539: WHEN OTHERS THEN --NULL;
540: -- Begin - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception

Line 541: FND_FILE.put_line(FND_FILE.LOG, 'EXCEPTION!!!!! -> ' || SQLERRM );

537: -- End - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
538: END;
539: WHEN OTHERS THEN --NULL;
540: -- Begin - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
541: FND_FILE.put_line(FND_FILE.LOG, 'EXCEPTION!!!!! -> ' || SQLERRM );
542: -- End - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
543: END;
544: END LOOP;
545: END LOOP;

Line 552: fnd_file.put_line(FND_FILE.LOG,'Role id ' || l_Role_ID);

548:
549:
550:
551: If (P_debug = 'Y') then
552: fnd_file.put_line(FND_FILE.LOG,'Role id ' || l_Role_ID);
553: end if;
554:
555: /* Begin Kasreeni 05/17/2004 Merge Existing Collectors */
556: MERGE_COLLECTORS(P_DEBUG);

Line 676: fnd_file.put_line(FND_FILE.LOG,'Error while creating resource ' || i.name || ' Status ' || l_return_status);

672: );
673: --Bug4929658. Fix By LKKUMAR on 12-Jan-2005. Include source phone, job title, email, addresses. End.
674:
675: IF (l_return_status <> 'S') then
676: fnd_file.put_line(FND_FILE.LOG,'Error while creating resource ' || i.name || ' Status ' || l_return_status);
677:
678: ELSE
679: l_colcount := l_colcount + 1;
680: If (P_debug = 'Y') then

Line 681: fnd_file.put_line(FND_FILE.LOG,'Successfully completed for employee id ' || i.employee_id ||

677:
678: ELSE
679: l_colcount := l_colcount + 1;
680: If (P_debug = 'Y') then
681: fnd_file.put_line(FND_FILE.LOG,'Successfully completed for employee id ' || i.employee_id ||
682: 'Status ' || l_return_status || ' ' || 'Resource id '
683: || l_resource_id || ' Resource Number ' || l_resource_number);
684: END IF;
685:

Line 692: fnd_file.put_line(FND_FILE.LOG,'After updating for AR_COLLECTORS with resource_id ' || i.employee_id || ' ' || i.resource_id);

688: SET resource_id = l_resource_id
689: WHERE collector_id = i.collector_id;
690:
691: If (p_debug = 'Y') then
692: fnd_file.put_line(FND_FILE.LOG,'After updating for AR_COLLECTORS with resource_id ' || i.employee_id || ' ' || i.resource_id);
693: End If;
694:
695: EXCEPTION WHEN OTHERS THEN
696: fnd_file.put_line(FND_FILE.LOG,'Error occured while updating AR_COLLECTORS '

Line 696: fnd_file.put_line(FND_FILE.LOG,'Error occured while updating AR_COLLECTORS '

692: fnd_file.put_line(FND_FILE.LOG,'After updating for AR_COLLECTORS with resource_id ' || i.employee_id || ' ' || i.resource_id);
693: End If;
694:
695: EXCEPTION WHEN OTHERS THEN
696: fnd_file.put_line(FND_FILE.LOG,'Error occured while updating AR_COLLECTORS '
697: || ' with employee id ' || i.employee_id );
698: FND_FILE.put_line(FND_FILE.log, ' ');
699: -- Begin - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
700: FND_FILE.put_line(FND_FILE.LOG, 'EXCEPTION!!!!! -> ' || SQLERRM );

Line 698: FND_FILE.put_line(FND_FILE.log, ' ');

694:
695: EXCEPTION WHEN OTHERS THEN
696: fnd_file.put_line(FND_FILE.LOG,'Error occured while updating AR_COLLECTORS '
697: || ' with employee id ' || i.employee_id );
698: FND_FILE.put_line(FND_FILE.log, ' ');
699: -- Begin - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
700: FND_FILE.put_line(FND_FILE.LOG, 'EXCEPTION!!!!! -> ' || SQLERRM );
701: -- End - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
702:

Line 700: FND_FILE.put_line(FND_FILE.LOG, 'EXCEPTION!!!!! -> ' || SQLERRM );

696: fnd_file.put_line(FND_FILE.LOG,'Error occured while updating AR_COLLECTORS '
697: || ' with employee id ' || i.employee_id );
698: FND_FILE.put_line(FND_FILE.log, ' ');
699: -- Begin - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
700: FND_FILE.put_line(FND_FILE.LOG, 'EXCEPTION!!!!! -> ' || SQLERRM );
701: -- End - Bug#5383877 - Andre Araujo - 07/18/2006 - Since I am here correcting the exception
702:
703: END;
704:

Line 720: fnd_file.put_line(FND_FILE.LOG,' Role API returns = ' || l_return_status ||

716: X_MSG_DATA => l_msg_data,
717: X_ROLE_RELATE_ID => l_role_relate_id
718: );
719: If (P_debug = 'Y') then
720: fnd_file.put_line(FND_FILE.LOG,' Role API returns = ' || l_return_status ||
721: ' ' || l_role_relate_id);
722: end if;
723: end if;
724:

Line 727: fnd_file.put_line(FND_FILE.LOG,'Error while creating resource ' || i.name || ' ' || SQLERRM);

723: end if;
724:
725:
726: EXCEPTION WHEN OTHERS THEN
727: fnd_file.put_line(FND_FILE.LOG,'Error while creating resource ' || i.name || ' ' || SQLERRM);
728: FND_FILE.put_line(FND_FILE.log, ' ');
729: END;
730:
731:

Line 728: FND_FILE.put_line(FND_FILE.log, ' ');

724:
725:
726: EXCEPTION WHEN OTHERS THEN
727: fnd_file.put_line(FND_FILE.LOG,'Error while creating resource ' || i.name || ' ' || SQLERRM);
728: FND_FILE.put_line(FND_FILE.log, ' ');
729: END;
730:
731:
732: l_resource_id := NULL;

Line 736: fnd_file.put_line(FND_FILE.LOG,'Date and Time Finish '|| l_date_time );

732: l_resource_id := NULL;
733: l_resource_number := NULL;
734: END LOOP;
735: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
736: fnd_file.put_line(FND_FILE.LOG,'Date and Time Finish '|| l_date_time );
737: FND_FILE.put_line(FND_FILE.LOG,'No. of. Resources Added := ' || l_colcount);
738:
739: COMMIT;
740:

Line 737: FND_FILE.put_line(FND_FILE.LOG,'No. of. Resources Added := ' || l_colcount);

733: l_resource_number := NULL;
734: END LOOP;
735: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
736: fnd_file.put_line(FND_FILE.LOG,'Date and Time Finish '|| l_date_time );
737: FND_FILE.put_line(FND_FILE.LOG,'No. of. Resources Added := ' || l_colcount);
738:
739: COMMIT;
740:
741: END;