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 AR_COLLECTORS

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 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 87: UPDATE ar_collectors ARC set

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',
89: resource_id =
90: ( SELECT max(jtfrs.resource_id)
91: FROM jtf_rs_resource_extns jtfrs

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 154: ar_collectors ac

150: -- AND fr.responsibility_name like P_RESP --Bug4930348.
151: AND fr.responsibility_id = l_responsibility_id --Bug4930348.
152: AND jtfrs.RESOURCE_ID NOT IN
153: (SELECT resource_id FROM
154: ar_collectors ac
155: WHERE employee_id is not null
156: AND ac.employee_id = jtfrs.source_id
157: AND ac.resource_id = jtfrs.resource_id
158: AND ac.resource_type = 'RS_RESOURCE' )

Line 188: -- Inserting in to AR_COLLECTORS

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

Line 196: -- Inserting in to AR_COLLECTORS

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
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 );

Line 203: SELECT AR_COLLECTORS_S.NEXTVAL

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
205: FROM DUAL;
206: Exception when others then
207: If (P_debug = 'Y') then

Line 216: INSERT INTO AR_COLLECTORS

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
217: (COLLECTOR_ID ,
218: LAST_UPDATED_BY ,
219: LAST_UPDATE_DATE ,
220: LAST_UPDATE_LOGIN ,

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 336: ar_collectors ac

332: /*
333:
334: CURSOR INSERT_RESOURCES IS
335: SELECT employee_id,inactive_date,description,name,resource_id FROM
336: ar_collectors ac
337: WHERE employee_id is not null
338: AND employee_id not in (SELECT jtr.source_id
339: FROM JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtv,
340: JTF_RS_RESOURCE_EXTNS jtr

Line 377: ar_collectors ac, FND_USER fuser, per_all_people_f pemp ,hz_parties hp

373: hp.county,
374: hp.country,
375: hp.email_address
376: FROM
377: ar_collectors ac, FND_USER fuser, per_all_people_f pemp ,hz_parties hp
378: WHERE ac.employee_id is not null
379: AND ac.employee_id not in (SELECT jtr.source_id from
380: jtf_rs_resource_extns jtr where source_id is not null)
381: AND ac.resource_id is null

Line 687: UPDATE AR_COLLECTORS

683: || l_resource_id || ' Resource Number ' || l_resource_number);
684: END IF;
685:
686: BEGIN
687: UPDATE AR_COLLECTORS
688: SET resource_id = l_resource_id
689: WHERE collector_id = i.collector_id;
690:
691: If (p_debug = 'Y') then

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 );