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

Line 60: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time = '|| to_char(sysdate,'HH:MI:SS'));

56: l_Txn_Date Date;
57: l_get_uom varchar2(2000); /* Bug 3817950 */
58: Begin
59:
60: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time = '|| to_char(sysdate,'HH:MI:SS'));
61: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Validated parameters are as follows:');
62: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Num_Of_Processes = ' || p_num_of_processes);
63: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_worker_id = ' || p_worker_id);
64: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_org_id = ' || p_org_id);

Line 61: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Validated parameters are as follows:');

57: l_get_uom varchar2(2000); /* Bug 3817950 */
58: Begin
59:
60: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time = '|| to_char(sysdate,'HH:MI:SS'));
61: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Validated parameters are as follows:');
62: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Num_Of_Processes = ' || p_num_of_processes);
63: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_worker_id = ' || p_worker_id);
64: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_org_id = ' || p_org_id);
65: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Date = ' || P_Txn_Date);

Line 62: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Num_Of_Processes = ' || p_num_of_processes);

58: Begin
59:
60: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time = '|| to_char(sysdate,'HH:MI:SS'));
61: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Validated parameters are as follows:');
62: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Num_Of_Processes = ' || p_num_of_processes);
63: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_worker_id = ' || p_worker_id);
64: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_org_id = ' || p_org_id);
65: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Date = ' || P_Txn_Date);
66: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Type = ' || P_Txn_Type);

Line 63: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_worker_id = ' || p_worker_id);

59:
60: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time = '|| to_char(sysdate,'HH:MI:SS'));
61: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Validated parameters are as follows:');
62: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Num_Of_Processes = ' || p_num_of_processes);
63: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_worker_id = ' || p_worker_id);
64: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_org_id = ' || p_org_id);
65: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Date = ' || P_Txn_Date);
66: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Type = ' || P_Txn_Type);
67: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TXN_SRC = ' || P_TXN_SRC);

Line 64: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_org_id = ' || p_org_id);

60: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time = '|| to_char(sysdate,'HH:MI:SS'));
61: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Validated parameters are as follows:');
62: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Num_Of_Processes = ' || p_num_of_processes);
63: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_worker_id = ' || p_worker_id);
64: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_org_id = ' || p_org_id);
65: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Date = ' || P_Txn_Date);
66: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Type = ' || P_Txn_Type);
67: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TXN_SRC = ' || P_TXN_SRC);
68: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Min_Project_Id = ' || P_Min_Project_Id);

Line 65: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Date = ' || P_Txn_Date);

61: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Validated parameters are as follows:');
62: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Num_Of_Processes = ' || p_num_of_processes);
63: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_worker_id = ' || p_worker_id);
64: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_org_id = ' || p_org_id);
65: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Date = ' || P_Txn_Date);
66: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Type = ' || P_Txn_Type);
67: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TXN_SRC = ' || P_TXN_SRC);
68: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Min_Project_Id = ' || P_Min_Project_Id);
69: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Max_Project_Id = ' || P_Max_Project_Id);

Line 66: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Type = ' || P_Txn_Type);

62: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Num_Of_Processes = ' || p_num_of_processes);
63: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_worker_id = ' || p_worker_id);
64: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_org_id = ' || p_org_id);
65: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Date = ' || P_Txn_Date);
66: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Type = ' || P_Txn_Type);
67: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TXN_SRC = ' || P_TXN_SRC);
68: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Min_Project_Id = ' || P_Min_Project_Id);
69: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Max_Project_Id = ' || P_Max_Project_Id);
70:

Line 67: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TXN_SRC = ' || P_TXN_SRC);

63: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_worker_id = ' || p_worker_id);
64: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_org_id = ' || p_org_id);
65: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Date = ' || P_Txn_Date);
66: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Type = ' || P_Txn_Type);
67: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TXN_SRC = ' || P_TXN_SRC);
68: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Min_Project_Id = ' || P_Min_Project_Id);
69: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Max_Project_Id = ' || P_Max_Project_Id);
70:
71: l_Txn_Date := fnd_date.canonical_to_date(P_Txn_Date);

Line 68: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Min_Project_Id = ' || P_Min_Project_Id);

64: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_org_id = ' || p_org_id);
65: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Date = ' || P_Txn_Date);
66: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Type = ' || P_Txn_Type);
67: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TXN_SRC = ' || P_TXN_SRC);
68: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Min_Project_Id = ' || P_Min_Project_Id);
69: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Max_Project_Id = ' || P_Max_Project_Id);
70:
71: l_Txn_Date := fnd_date.canonical_to_date(P_Txn_Date);
72:

Line 69: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Max_Project_Id = ' || P_Max_Project_Id);

65: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Date = ' || P_Txn_Date);
66: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Txn_Type = ' || P_Txn_Type);
67: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TXN_SRC = ' || P_TXN_SRC);
68: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Min_Project_Id = ' || P_Min_Project_Id);
69: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_Max_Project_Id = ' || P_Max_Project_Id);
70:
71: l_Txn_Date := fnd_date.canonical_to_date(P_Txn_Date);
72:
73: -- Update only projects and tasks for the given project type in the given OU

Line 150: FND_FILE.PUT_LINE(FND_FILE.LOG,'....................');

146: --Code Changes for Bug No.2984871 start
147: l_rowcount:=sql%rowcount;
148: --Code Changes for Bug No.2984871 end
149:
150: FND_FILE.PUT_LINE(FND_FILE.LOG,'....................');
151:
152: -- Commented for Bug 2984871
153: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'No of Project Records updated = '||SQL%ROWCOUNT);
154:

Line 153: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'No of Project Records updated = '||SQL%ROWCOUNT);

149:
150: FND_FILE.PUT_LINE(FND_FILE.LOG,'....................');
151:
152: -- Commented for Bug 2984871
153: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'No of Project Records updated = '||SQL%ROWCOUNT);
154:
155: --Code Changes for Bug No.2984871 start
156: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of Project Records updated = '||l_rowcount);
157: --dbms_output.PUT_LINE('No of Project Records updated = '||l_rowcount);

Line 156: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of Project Records updated = '||l_rowcount);

152: -- Commented for Bug 2984871
153: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'No of Project Records updated = '||SQL%ROWCOUNT);
154:
155: --Code Changes for Bug No.2984871 start
156: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of Project Records updated = '||l_rowcount);
157: --dbms_output.PUT_LINE('No of Project Records updated = '||l_rowcount);
158: --Code Changes for Bug No.2984871 end
159:
160: FORALL i in l_PrjIdTab.first .. l_PrjIdTab.last

Line 168: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of Task Records updated = '||l_rowcount);

164: and work_type_id is null;
165:
166: l_rowcount:=sql%rowcount;
167:
168: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of Task Records updated = '||l_rowcount);
169: --dbms_output.PUT_LINE('No of Task Records updated = '||l_rowcount);
170:
171: commit;
172:

Line 183: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start EI Upgrade Process'|| to_char(sysdate, 'HH:MI:SS'));

179: END IF; -- P_TXN_TYPE = 'WORK TYPE' -- PJM Changes
180:
181: IF P_Txn_Type = 'SUPPLIER TYPE' THEN -- R12 changes
182:
183: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start EI Upgrade Process'|| to_char(sysdate, 'HH:MI:SS'));
184:
185: -- Get the project range if not supplied
186: IF P_Min_Project_Id IS NULL THEN
187: SELECT Min(P.Project_Id), Max(P.Project_Id)

Line 198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Min_Project_Id = ' || Min_Project_Id);

194: END IF;
195:
196: l_remainder := MOD((Max_Project_Id-Min_Project_Id),p_num_of_processes);
197:
198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Min_Project_Id = ' || Min_Project_Id);
199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Max_Project_Id = ' || Max_Project_Id);
200:
201: l_Max := MIN_Project_Id ;
202:

Line 199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Max_Project_Id = ' || Max_Project_Id);

195:
196: l_remainder := MOD((Max_Project_Id-Min_Project_Id),p_num_of_processes);
197:
198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Min_Project_Id = ' || Min_Project_Id);
199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Max_Project_Id = ' || Max_Project_Id);
200:
201: l_Max := MIN_Project_Id ;
202:
203: IF Min_Project_Id = Max_Project_Id THEN

Line 205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '.....................');

201: l_Max := MIN_Project_Id ;
202:
203: IF Min_Project_Id = Max_Project_Id THEN
204:
205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '.....................');
206: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project_Id = ' || Min_Project_Id);
207:
208: -- Call FND API to submit the same request for the EI update
209: l_child_req_id := FND_REQUEST.SUBMIT_REQUEST('PA',

Line 206: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project_Id = ' || Min_Project_Id);

202:
203: IF Min_Project_Id = Max_Project_Id THEN
204:
205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '.....................');
206: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project_Id = ' || Min_Project_Id);
207:
208: -- Call FND API to submit the same request for the EI update
209: l_child_req_id := FND_REQUEST.SUBMIT_REQUEST('PA',
210: 'PAWKTPUP',

Line 233: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '.....................');

229: IF i = P_Num_Of_Processes THEN
230: l_max := l_max + l_remainder;
231: END IF;
232:
233: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '.....................');
234: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Min Project_Id = ' || l_Min);
235: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Max Project_Id = ' || l_Max);
236:
237: -- Call FND API to submit the same request for the EI update

Line 234: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Min Project_Id = ' || l_Min);

230: l_max := l_max + l_remainder;
231: END IF;
232:
233: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '.....................');
234: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Min Project_Id = ' || l_Min);
235: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Max Project_Id = ' || l_Max);
236:
237: -- Call FND API to submit the same request for the EI update
238: l_child_req_id := FND_REQUEST.SUBMIT_REQUEST('PA',

Line 235: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Max Project_Id = ' || l_Max);

231: END IF;
232:
233: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '.....................');
234: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Min Project_Id = ' || l_Min);
235: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Max Project_Id = ' || l_Max);
236:
237: -- Call FND API to submit the same request for the EI update
238: l_child_req_id := FND_REQUEST.SUBMIT_REQUEST('PA',
239: 'PAWKTPUP',

Line 252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

248: fnd_date.date_to_canonical(l_TXN_DATE),
249: l_min,
250: l_max);
251: IF (l_child_req_id = 0) THEN
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
253: '...An attempt to submit the upgrade request has failed.');
254: FND_FILE.PUT_LINE(FND_FILE.LOG,
255: '...An attempt to submit the upgrade request has failed.');
256: ELSE

Line 254: FND_FILE.PUT_LINE(FND_FILE.LOG,

250: l_max);
251: IF (l_child_req_id = 0) THEN
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
253: '...An attempt to submit the upgrade request has failed.');
254: FND_FILE.PUT_LINE(FND_FILE.LOG,
255: '...An attempt to submit the upgrade request has failed.');
256: ELSE
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
258: 'The process to upgrade the records has been submitted.

Line 257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

253: '...An attempt to submit the upgrade request has failed.');
254: FND_FILE.PUT_LINE(FND_FILE.LOG,
255: '...An attempt to submit the upgrade request has failed.');
256: ELSE
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
258: 'The process to upgrade the records has been submitted.
259: Please check Request ID: '|| to_char(l_child_req_id));
260: FND_FILE.PUT_LINE(FND_FILE.LOG,
261: 'The process to upgrade the records has been submitted.

Line 260: FND_FILE.PUT_LINE(FND_FILE.LOG,

256: ELSE
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
258: 'The process to upgrade the records has been submitted.
259: Please check Request ID: '|| to_char(l_child_req_id));
260: FND_FILE.PUT_LINE(FND_FILE.LOG,
261: 'The process to upgrade the records has been submitted.
262: Please check Request ID: '|| to_char(l_child_req_id));
263: END IF;
264:

Line 271: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Insert into Temp Table '|| to_char(sysdate, 'HH:MI:SS'));

267:
268: END IF; -- P_TXN_TYPE = 'SUPPLIER TYPE' -- R12 changes
269:
270:
271: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Insert into Temp Table '|| to_char(sysdate, 'HH:MI:SS'));
272:
273: IF P_TXN_TYPE <> 'SUPPLIER TYPE' THEN -- R12 changes
274: execute immediate 'alter session enable parallel dml';
275: END IF;

Line 293: FND_FILE.PUT_LINE(FND_FILE.LOG, l_ins_rowcount||' Records inserted for WORK TYPE '|| to_char(sysdate, 'HH:MI:SS'));

289: and work_type_id is null;
290:
291: l_ins_rowcount := SQL%ROWCOUNT;
292:
293: FND_FILE.PUT_LINE(FND_FILE.LOG, l_ins_rowcount||' Records inserted for WORK TYPE '|| to_char(sysdate, 'HH:MI:SS'));
294:
295: ELSIF P_Txn_Type = 'PJM' THEN
296:
297: /* 3968368: Added two unions to handle the PJM invoice charges upgrade. For such txns,

Line 375: FND_FILE.PUT_LINE(FND_FILE.LOG, l_ins_rowcount || ' Records inserted for PJM '|| to_char(sysdate, 'HH:MI:SS'));

371: AND CDL.line_num = 1;
372:
373: l_ins_rowcount := SQL%ROWCOUNT;
374:
375: FND_FILE.PUT_LINE(FND_FILE.LOG, l_ins_rowcount || ' Records inserted for PJM '|| to_char(sysdate, 'HH:MI:SS'));
376:
377: END IF;
378:
379: commit;

Line 392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '.....................');

388: l_ReqStsTab.delete; -- PJM Changes
389:
390: For i in 1..P_Num_Of_Processes Loop
391:
392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '.....................');
393:
394: -- Call FND API to submit the same request for the EI update
395: l_child_req_id := FND_REQUEST.SUBMIT_REQUEST('PA',
396: 'PAWKTPUP',

Line 408: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

404: p_org_id,
405: fnd_date.date_to_canonical(l_TXN_DATE) );
406:
407: IF (l_child_req_id = 0) THEN
408: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
409: '...An attempt to submit the upgrade request has failed.');
410: FND_FILE.PUT_LINE(FND_FILE.LOG,
411: '...An attempt to submit the upgrade request has failed.');
412: ELSE

Line 410: FND_FILE.PUT_LINE(FND_FILE.LOG,

406:
407: IF (l_child_req_id = 0) THEN
408: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
409: '...An attempt to submit the upgrade request has failed.');
410: FND_FILE.PUT_LINE(FND_FILE.LOG,
411: '...An attempt to submit the upgrade request has failed.');
412: ELSE
413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
414: 'The process to upgrade the records has been submitted.

Line 413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

409: '...An attempt to submit the upgrade request has failed.');
410: FND_FILE.PUT_LINE(FND_FILE.LOG,
411: '...An attempt to submit the upgrade request has failed.');
412: ELSE
413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
414: 'The process to upgrade the records has been submitted.
415: Please check Request ID: '|| to_char(l_child_req_id));
416: FND_FILE.PUT_LINE(FND_FILE.LOG,
417: 'The process to upgrade the records has been submitted.

Line 416: FND_FILE.PUT_LINE(FND_FILE.LOG,

412: ELSE
413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
414: 'The process to upgrade the records has been submitted.
415: Please check Request ID: '|| to_char(l_child_req_id));
416: FND_FILE.PUT_LINE(FND_FILE.LOG,
417: 'The process to upgrade the records has been submitted.
418: Please check Request ID: '|| to_char(l_child_req_id));
419: END IF;
420:

Line 439: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Req = ' || l_ReqStsTab(i).Request_Id || ' Sts = ' || l_ReqStsTab(i).Status);

435: end if;
436:
437: l_ReqStsTab(i).Status := l_dev_phase;
438:
439: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Req = ' || l_ReqStsTab(i).Request_Id || ' Sts = ' || l_ReqStsTab(i).Status);
440:
441: End Loop;
442:
443: commit;

Line 449: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Loop forever '|| to_char(sysdate,'HH:MI:SS') );

445: While NOTCOMPLETE Loop
446:
447: dbms_lock.sleep(60); /* changed sleep seconds from 300 to 60 for 4130368 */
448:
449: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Loop forever '|| to_char(sysdate,'HH:MI:SS') );
450:
451: NOTCOMPLETE := FALSE;
452:
453: FOR j in l_ReqStsTab.first..l_ReqStsTab.LAST LOOP

Line 472: FND_FILE.PUT_LINE(FND_FILE.LOG,'Loop Again'|| to_char(sysdate,'HH:MI:SS'));

468:
469: l_ReqStsTab(j).Status := l_dev_phase;
470:
471: If l_dev_phase <> 'COMPLETE' Then
472: FND_FILE.PUT_LINE(FND_FILE.LOG,'Loop Again'|| to_char(sysdate,'HH:MI:SS'));
473: NOTCOMPLETE := TRUE;
474: exit;
475: End If;
476:

Line 485: FND_FILE.PUT_LINE(FND_FILE.LOG,'Truncating Table '|| l_pa_schema || '.pa_txn_upgrade_temp '||

481: IF (NOT FND_INSTALLATION.GET_APP_INFO('PA', l_inssts, l_industry, l_pa_schema)) THEN
482: raise_application_error(-20001,SQLERRM);
483: END IF;
484:
485: FND_FILE.PUT_LINE(FND_FILE.LOG,'Truncating Table '|| l_pa_schema || '.pa_txn_upgrade_temp '||
486: to_char(sysdate,'HH:MI:SS') );
487:
488: execute immediate ('Truncate table ' || l_pa_schema || '.pa_txn_upgrade_temp');
489:

Line 490: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling pa_uom.get_uom for updating UOM Meaning '|| to_char(sysdate,'HH:MI:SS') );

486: to_char(sysdate,'HH:MI:SS') );
487:
488: execute immediate ('Truncate table ' || l_pa_schema || '.pa_txn_upgrade_temp');
489:
490: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling pa_uom.get_uom for updating UOM Meaning '|| to_char(sysdate,'HH:MI:SS') );
491:
492: l_get_uom := 'F';
493:
494: l_get_uom := pa_uom.get_uom(fnd_global.USER_ID);

Line 498: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Successfully Updated UOM Meanings in PA '|| to_char(sysdate,'HH:MI:SS'));

494: l_get_uom := pa_uom.get_uom(fnd_global.USER_ID);
495:
496: IF (l_get_uom = 'S') THEN
497:
498: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Successfully Updated UOM Meanings in PA '|| to_char(sysdate,'HH:MI:SS'));
499:
500: ELSE
501:
502: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error While Updating UOM Meanings in PA '||l_get_uom);

Line 502: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error While Updating UOM Meanings in PA '||l_get_uom);

498: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Successfully Updated UOM Meanings in PA '|| to_char(sysdate,'HH:MI:SS'));
499:
500: ELSE
501:
502: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error While Updating UOM Meanings in PA '||l_get_uom);
503: raise_application_error(-20001,SQLERRM);
504:
505: END IF;
506:

Line 516: FND_FILE.PUT_LINE(FND_FILE.LOG, p_worker_id|| ' is the worker_id '|| to_char(sysdate,'HH:MI:SS'));

512: End If; -- p_worker_id
513:
514: If (p_worker_id <> 0) Then
515:
516: FND_FILE.PUT_LINE(FND_FILE.LOG, p_worker_id|| ' is the worker_id '|| to_char(sysdate,'HH:MI:SS'));
517:
518: Declare
519:
520: Cursor C_Ei Is

Line 730: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of EI Records updated = '||l_rowcount);

726: where Expenditure_Item_Id = l_EIIdTab(i);
727:
728: l_rowcount:=sql%rowcount;
729:
730: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of EI Records updated = '||l_rowcount);
731: commit;
732:
733: FORALL j in l_EIIdTab.first .. l_EIIdTab.last
734: update pa_cost_distribution_lines_all

Line 741: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of CDL Records updated = '||l_rowcount);

737: and line_type = 'R';
738:
739: l_rowcount:=sql%rowcount;
740:
741: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of CDL Records updated = '||l_rowcount);
742: commit;
743:
744: FORALL k in l_EIIdTab.first .. l_EIIdTab.last
745: update pa_cc_dist_lines_all

Line 752: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of CCDL Records updated = '||l_rowcount);

748: and tp_amt_type_code is null;
749:
750: l_rowcount:=sql%rowcount;
751:
752: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of CCDL Records updated = '||l_rowcount);
753: commit;
754:
755: FORALL l in l_EIIdTab.first .. l_EIIdTab.last
756: update pa_draft_invoice_details_all

Line 763: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of DID Records updated = '||l_rowcount);

759: and tp_amt_type_code is null;
760:
761: l_rowcount:=sql%rowcount;
762:
763: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of DID Records updated = '||l_rowcount);
764: commit;
765:
766: End Loop;
767:

Line 804: FND_FILE.PUT_LINE(FND_FILE.LOG, l_rowcount || ' EI Records updated '||to_char(sysdate,'HH:MI:SS'));

800: where Expenditure_Item_Id = l_EIIdTab(i);
801:
802: l_rowcount:=sql%rowcount;
803:
804: FND_FILE.PUT_LINE(FND_FILE.LOG, l_rowcount || ' EI Records updated '||to_char(sysdate,'HH:MI:SS'));
805: commit;
806:
807: End Loop;
808:

Line 813: FND_FILE.PUT_LINE(FND_FILE.LOG,'Initializing variables for cur_ap_po_ei');

809: Close Cur_PJM_Attr;
810:
811: ELSIF P_Txn_Type = 'SUPPLIER TYPE' THEN --R12 changes
812:
813: FND_FILE.PUT_LINE(FND_FILE.LOG,'Initializing variables for cur_ap_po_ei');
814:
815: l_ei_rowid_tbl := rowid_typ(null);
816: l_exp_item_id_tbl := exp_item_id_typ(null);
817: l_vendor_id_tbl := vendor_id_typ(null);

Line 825: FND_FILE.PUT_LINE(FND_FILE.LOG,'Opening cursor cur_upg_proj');

821: l_doc_payment_id_tbl := doc_payment_id_typ(null);
822: l_document_tbl := document_typ(null);
823: l_document_dist_tbl := document_dist_typ(null);
824:
825: FND_FILE.PUT_LINE(FND_FILE.LOG,'Opening cursor cur_upg_proj');
826:
827: FOR upg_proj in cur_upg_project LOOP
828:
829: FND_FILE.PUT_LINE(FND_FILE.LOG,'Opening cursor cur_ap_po_ei');

Line 829: FND_FILE.PUT_LINE(FND_FILE.LOG,'Opening cursor cur_ap_po_ei');

825: FND_FILE.PUT_LINE(FND_FILE.LOG,'Opening cursor cur_upg_proj');
826:
827: FOR upg_proj in cur_upg_project LOOP
828:
829: FND_FILE.PUT_LINE(FND_FILE.LOG,'Opening cursor cur_ap_po_ei');
830:
831: OPEN cur_ap_po_ei(upg_proj.project_id);
832: LOOP
833:

Line 845: FND_FILE.PUT_LINE(FND_FILE.LOG,'Fetching Cusor cur_ap_po_ei');

841: l_doc_payment_id_tbl.delete;
842: l_document_tbl.delete;
843: l_document_dist_tbl.delete;
844:
845: FND_FILE.PUT_LINE(FND_FILE.LOG,'Fetching Cusor cur_ap_po_ei');
846:
847: FETCH cur_ap_po_ei BULK COLLECT INTO
848: l_ei_rowid_tbl,
849: l_exp_item_id_tbl,

Line 859: FND_FILE.PUT_LINE(FND_FILE.LOG,'After Bulk Collecting Cusor cur_ap_po_ei');

855: l_document_tbl,
856: l_document_dist_tbl
857: limit l_plsql_max_array_size;
858:
859: FND_FILE.PUT_LINE(FND_FILE.LOG,'After Bulk Collecting Cusor cur_ap_po_ei');
860:
861: If l_ei_rowid_tbl.count = 0 Then
862: Exit;
863: End If;

Line 865: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating EI columns -R12 ');

861: If l_ei_rowid_tbl.count = 0 Then
862: Exit;
863: End If;
864:
865: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating EI columns -R12 ');
866:
867: FORALL i in l_ei_rowid_tbl.first..l_ei_rowid_tbl.last
868: UPDATE pa_expenditure_items_all ei
869: SET ei.vendor_id = l_vendor_id_tbl(i),

Line 883: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commit in Loop');

879:
880: l_rowcount := nvl(l_rowcount, 0) + SQL%ROWCOUNT;
881:
882: -- commit transaction here
883: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commit in Loop');
884: commit;
885:
886: END LOOP;
887: CLOSE cur_ap_po_ei;

Line 889: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating uncosted EI columns ');

885:
886: END LOOP;
887: CLOSE cur_ap_po_ei;
888:
889: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating uncosted EI columns ');
890: -- Update the adjusted and uncosted expenditures. Bug#5381198.
891: FOR uncosted_ei in cur_uncosted_ei(upg_proj.project_id) LOOP
892:
893: UPDATE pa_expenditure_items_all ei

Line 921: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commit in Loop - Uncosted Expenditures ');

917:
918: END LOOP;
919:
920: -- commit transaction here
921: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commit in Loop - Uncosted Expenditures ');
922: commit;
923: END LOOP;
924:
925: END IF;