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

Line 44: fnd_file.put_line(fnd_file.log, 'EXCEPTION: log_message: '||SQLERRM);

40: END IF;
41: EXCEPTION
42: WHEN OTHERS THEN
43: gLogError := TRUE;
44: fnd_file.put_line(fnd_file.log, 'EXCEPTION: log_message: '||SQLERRM);
45: fnd_file.put_line(fnd_file.log, 'Disabling FND Logging..');
46: END log_message;
47:
48: ------------------------------------------------------------------------------------

Line 45: fnd_file.put_line(fnd_file.log, 'Disabling FND Logging..');

41: EXCEPTION
42: WHEN OTHERS THEN
43: gLogError := TRUE;
44: fnd_file.put_line(fnd_file.log, 'EXCEPTION: log_message: '||SQLERRM);
45: fnd_file.put_line(fnd_file.log, 'Disabling FND Logging..');
46: END log_message;
47:
48: ------------------------------------------------------------------------------------
49: -- API name : handle_error

Line 84: fnd_file.put_line(fnd_file.log, X_module||' => '||X_message);

80:
81: l_stmt_num := 10;
82:
83: --Print the Error in Request Log File
84: fnd_file.put_line(fnd_file.log, X_module||' => '||X_message);
85:
86: l_stmt_num := 20;
87:
88: --Set the Concurrent Request as Error, depending upon the parameter

Line 167: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

163:
164: BEGIN
165:
166: IF l_Log THEN
167: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
168: ELSE
169: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
170: END IF;
171:

Line 169: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

165:
166: IF l_Log THEN
167: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
168: ELSE
169: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
170: END IF;
171:
172: l_stmt_num :=0;
173: IF l_Log THEN

Line 225: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> Upgrade Historical Inventory Transactions for Subledger Accounting [CSTUINVM] -> Request: '||l_inv_req_id);

221: argument3 => X_batch_size,
222: argument4 => X_Num_Workers,
223: argument5 => X_Ledger_Id);
224:
225: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> Upgrade Historical Inventory Transactions for Subledger Accounting [CSTUINVM] -> Request: '||l_inv_req_id);
226:
227: l_stmt_num :=15;
228: l_wip_req_id := FND_REQUEST.submit_request(
229: application => 'BOM',

Line 240: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> Upgrade Historical Work In Process Transactions for Subledger Accounting [CSTUWIPM] -> Request: '||l_wip_req_id );

236: argument3 => X_batch_size,
237: argument4 => X_Num_Workers,
238: argument5 => X_Ledger_Id);
239:
240: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> Upgrade Historical Work In Process Transactions for Subledger Accounting [CSTUWIPM] -> Request: '||l_wip_req_id );
241:
242: IF (l_inv_req_id = 0 AND l_wip_req_id = 0 ) THEN
243: X_errbuf := 'Failure in Sub-Request Submission';
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 262: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> Upgrade Historical Receiving Transactions for Subledger Accounting [CSTURCVM] -> Request: '||l_rcv_req_id);

258: argument3 => X_batch_size,
259: argument4 => X_Num_Workers,
260: argument5 => X_Ledger_Id);
261:
262: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> Upgrade Historical Receiving Transactions for Subledger Accounting [CSTURCVM] -> Request: '||l_rcv_req_id);
263:
264: IF (l_rcv_req_id = 0 ) THEN
265: X_errbuf := 'Failure in Sub-Request Submission';
266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 324: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Concurrent Request: '||l_sub_reqtab(i).request_id||' -> Status: '||l_sub_reqtab(i).dev_status);

320: /* Checking whether the child requests completed succesful */
321: x_retcode := FND_API.G_RET_STS_SUCCESS;
322: for i IN 1..l_sub_reqtab.COUNT() loop
323: if (l_sub_reqtab(i).dev_status <> 'NORMAL') then
324: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Concurrent Request: '||l_sub_reqtab(i).request_id||' -> Status: '||l_sub_reqtab(i).dev_status);
325: X_retcode := FND_API.g_ret_sts_unexp_error;
326: end if;
327: end loop;
328:

Line 330: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>All Concurrent Sub-Requests Successfull');

326: end if;
327: end loop;
328:
329: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then
330: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>All Concurrent Sub-Requests Successfull');
331: l_stmt_num :=50;
332: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Setting Migration Status Code in GPS as ''U'' for Application ID '||X_Application_Id);
333: l_ret_code := XLA_UPGRADE_PUB.set_migration_status_code(
334: p_application_id =>X_Application_Id,

Line 332: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Setting Migration Status Code in GPS as ''U'' for Application ID '||X_Application_Id);

328:
329: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then
330: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>All Concurrent Sub-Requests Successfull');
331: l_stmt_num :=50;
332: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Setting Migration Status Code in GPS as ''U'' for Application ID '||X_Application_Id);
333: l_ret_code := XLA_UPGRADE_PUB.set_migration_status_code(
334: p_application_id =>X_Application_Id,
335: p_set_of_books_id=>null,
336: p_period_name =>null,

Line 442: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

438:
439: BEGIN
440:
441: IF l_Log THEN
442: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
443: ELSE
444: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
445: END IF;
446:

Line 444: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

440:
441: IF l_Log THEN
442: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
443: ELSE
444: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
445: END IF;
446:
447: l_stmt_num :=0;
448: IF l_Log THEN

Line 466: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Upgrade Costing Subledgers to SLA Request: '||gRequestId);

462: );
463: END IF;
464:
465: if gRequestId > 0 then
466: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Upgrade Costing Subledgers to SLA Request: '||gRequestId);
467: else
468: raise_application_error(-20001, 'SUBMIT_SUBREQUESTS() must be called from a concurrent request');
469: end if;
470:

Line 517: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Submitting Concurrent Sub-Requests....');

513: IF FND_API.to_Boolean(X_init_msg_list) THEN
514: FND_MSG_PUB.initialize;
515: END IF;
516:
517: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Submitting Concurrent Sub-Requests....');
518:
519: x_retcode := FND_API.G_RET_STS_SUCCESS;
520:
521: l_stmt_num :=10;

Line 533: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> Upgrade Historical Inventory Transactions for Subledger Accounting [CSTUINVM] -> Request: '||l_inv_req_id);

529: argument2 => X_init_msg_list,
530: argument3 => X_batch_size,
531: argument4 => X_Num_Workers);
532:
533: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> Upgrade Historical Inventory Transactions for Subledger Accounting [CSTUINVM] -> Request: '||l_inv_req_id);
534:
535: l_stmt_num :=20;
536: l_wip_req_id := FND_REQUEST.submit_request(
537: application => 'BOM',

Line 547: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> Upgrade Historical Work In Process Transactions for Subledger Accounting [CSTUWIPM] -> Request: '||l_wip_req_id );

543: argument2 => X_init_msg_list,
544: argument3 => X_batch_size,
545: argument4 => X_Num_Workers);
546:
547: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> Upgrade Historical Work In Process Transactions for Subledger Accounting [CSTUWIPM] -> Request: '||l_wip_req_id );
548:
549: l_stmt_num :=30;
550: l_rcv_req_id := FND_REQUEST.submit_request(
551: application => 'BOM',

Line 561: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> Upgrade Historical Receiving Transactions for Subledger Accounting [CSTURCVM] -> Request: '||l_rcv_req_id);

557: argument2 => X_init_msg_list,
558: argument3 => X_batch_size,
559: argument4 => X_Num_Workers);
560:
561: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> Upgrade Historical Receiving Transactions for Subledger Accounting [CSTURCVM] -> Request: '||l_rcv_req_id);
562:
563: IF (l_inv_req_id = 0 AND l_wip_req_id = 0 AND l_rcv_req_id = 0) THEN
564: X_errbuf := 'Failure in Sub-Request Submission';
565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 572: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Waiting for Concurrent Sub-Requests to Complete....');

568: l_stmt_num :=40;
569: fnd_conc_global.set_req_globals(conc_status=>'PAUSED',
570: request_data=>3);
571:
572: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Waiting for Concurrent Sub-Requests to Complete....');
573:
574: X_errbuf := 'Submitted Sub-Requests';
575:
576: return;

Line 579: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Checking Status Of Concurrent Sub-Requests....');

575:
576: return;
577:
578: else
579: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Checking Status Of Concurrent Sub-Requests....');
580: --
581: -- restart case
582: --
583: l_stmt_num :=50;

Line 590: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Concurrent Request: '||l_sub_reqtab(i).request_id||' -> Status: '||l_sub_reqtab(i).dev_status);

586:
587: for i IN 1..l_sub_reqtab.COUNT()
588: loop
589: if (l_sub_reqtab(i).dev_status <> 'NORMAL') then
590: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Concurrent Request: '||l_sub_reqtab(i).request_id||' -> Status: '||l_sub_reqtab(i).dev_status);
591: X_retcode := FND_API.g_ret_sts_unexp_error;
592: end if;
593: end loop;
594:

Line 596: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>All Concurrent Sub-Requests Successfull');

592: end if;
593: end loop;
594:
595: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then
596: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>All Concurrent Sub-Requests Successfull');
597: else
598: X_errbuf := 'One or More of Upgrade Sub-Managers completed in Error';
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: end if;

Line 700: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

696:
697: BEGIN
698:
699: IF l_Log THEN
700: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
701: ELSE
702: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
703: END IF;
704:

Line 702: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

698:
699: IF l_Log THEN
700: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
701: ELSE
702: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
703: END IF;
704:
705: l_stmt_num :=0;
706: IF l_Log THEN

Line 724: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>INV Upgrade Manager Concurrent Request: '||gRequestId);

720: );
721: END IF;
722:
723: if gRequestId > 0 then
724: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>INV Upgrade Manager Concurrent Request: '||gRequestId);
725: else
726: raise_application_error(-20001, 'SUBMIT_SUBREQUESTS() must be called from a concurrent request');
727: end if;
728:

Line 776: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Submitting Workers for INV Upgrade [CSTUINVW]');

772: where ledger_id = nvl(X_Ledger_Id,ledger_id);
773:
774: l_stmt_num :=20;
775: if (l_argument4 is not null) then
776: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Submitting Workers for INV Upgrade [CSTUINVW]');
777: AD_CONC_UTILS_PKG.submit_subrequests(
778: X_errbuf=>X_errbuf,
779: X_retcode=>X_retcode,
780: X_WorkerConc_app_shortname=>'BOM',

Line 802: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> INV Worker [CSTUINVW] '||RPAD(i,2)||' - '||l_sub_reqtab(i).request_id);

798:
799: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);
800:
801: for i IN 1..l_sub_reqtab.COUNT() loop
802: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> INV Worker [CSTUINVW] '||RPAD(i,2)||' - '||l_sub_reqtab(i).request_id);
803: end loop;
804:
805: end if;
806: /* can not update migration_status_code until WIP upgrade is done, because they share the same period.*/

Line 809: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'No Data Found in XUD');

805: end if;
806: /* can not update migration_status_code until WIP upgrade is done, because they share the same period.*/
807: exception
808: when no_data_found then
809: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'No Data Found in XUD');
810: end;
811: else
812: X_errbuf := 'Cannot get schema name for product : '||l_product;
813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 819: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Checking Status Of Child Workers....');

815:
816: /* can not update migration_status_code until WIP upgrade is done, because they share the same period.*/
817:
818: else
819: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Checking Status Of Child Workers....');
820: --
821: -- restart case
822: --
823: l_stmt_num :=40;

Line 830: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Concurrent Request: '||l_sub_reqtab(i).request_id||' -> Status: '||l_sub_reqtab(i).dev_status);

826: x_retcode := FND_API.G_RET_STS_SUCCESS;
827: for i IN 1..l_sub_reqtab.COUNT()
828: loop
829: if (l_sub_reqtab(i).dev_status <> 'NORMAL') then
830: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Concurrent Request: '||l_sub_reqtab(i).request_id||' -> Status: '||l_sub_reqtab(i).dev_status);
831: X_retcode := FND_API.g_ret_sts_unexp_error;
832: end if;
833: end loop;
834:

Line 836: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>All Child Workers are Successfull');

832: end if;
833: end loop;
834:
835: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then
836: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>All Child Workers are Successfull');
837: else
838: X_errbuf := 'One or More of Child Workers completed in Error';
839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
840: end if;

Line 939: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

935:
936: BEGIN
937:
938: IF l_Log THEN
939: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
940: ELSE
941: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
942: END IF;
943:

Line 941: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

937:
938: IF l_Log THEN
939: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
940: ELSE
941: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
942: END IF;
943:
944: l_stmt_num :=0;
945: IF l_Log THEN

Line 963: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>WIP Upgrade Manager Concurrent Request: '||gRequestId);

959: );
960: END IF;
961:
962: if gRequestId > 0 then
963: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>WIP Upgrade Manager Concurrent Request: '||gRequestId);
964: else
965: raise_application_error(-20001, 'SUBMIT_SUBREQUESTS() must be called from a concurrent request');
966: end if;
967:

Line 1015: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Submitting Workers for WIP Upgrade [CSTUWIPW]');

1011: where ledger_id = nvl(X_Ledger_Id,ledger_id);
1012:
1013: l_stmt_num :=20;
1014: if (l_argument4 is not null) then
1015: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Submitting Workers for WIP Upgrade [CSTUWIPW]');
1016: AD_CONC_UTILS_PKG.submit_subrequests(
1017: X_errbuf=>X_errbuf,
1018: X_retcode=>X_retcode,
1019: X_WorkerConc_app_shortname=>'BOM',

Line 1041: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> WIP Worker [CSTUWIPW] '||RPAD(i,2)||' - '||l_sub_reqtab(i).request_id);

1037:
1038: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);
1039:
1040: for i IN 1..l_sub_reqtab.COUNT() loop
1041: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> WIP Worker [CSTUWIPW] '||RPAD(i,2)||' - '||l_sub_reqtab(i).request_id);
1042: end loop;
1043:
1044: end if;
1045: exception

Line 1047: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'No Data Found in XUD');

1043:
1044: end if;
1045: exception
1046: when no_data_found then
1047: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'No Data Found in XUD');
1048: end;
1049: else
1050: X_errbuf := 'Cannot get schema name for product : '||l_product;
1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1057: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Checking Status Of Child Workers....');

1053:
1054: /* can not update migration_status_code until Inventory upgrade is done, because they share the same period.*/
1055:
1056: else
1057: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Checking Status Of Child Workers....');
1058: --
1059: -- restart case
1060: --
1061: l_stmt_num :=40;

Line 1068: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Concurrent Request: '||l_sub_reqtab(i).request_id||' -> Status: '||l_sub_reqtab(i).dev_status);

1064: x_retcode := FND_API.G_RET_STS_SUCCESS;
1065: for i IN 1..l_sub_reqtab.COUNT()
1066: loop
1067: if (l_sub_reqtab(i).dev_status <> 'NORMAL') then
1068: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Concurrent Request: '||l_sub_reqtab(i).request_id||' -> Status: '||l_sub_reqtab(i).dev_status);
1069: X_retcode := FND_API.g_ret_sts_unexp_error;
1070: end if;
1071: end loop;
1072:

Line 1074: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>All Child Workers are Successfull');

1070: end if;
1071: end loop;
1072:
1073: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then
1074: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>All Child Workers are Successfull');
1075: else
1076: X_errbuf := 'One or More of Child Workers completed in Error';
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: end if;

Line 1177: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

1173:
1174: BEGIN
1175:
1176: IF l_Log THEN
1177: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1178: ELSE
1179: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1180: END IF;
1181:

Line 1179: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

1175:
1176: IF l_Log THEN
1177: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1178: ELSE
1179: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1180: END IF;
1181:
1182: l_stmt_num :=0;
1183: IF l_Log THEN

Line 1201: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>RCV Upgrade Manager Concurrent Request: '||gRequestId);

1197: );
1198: END IF;
1199:
1200: if gRequestId > 0 then
1201: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>RCV Upgrade Manager Concurrent Request: '||gRequestId);
1202: else
1203: raise_application_error(-20001, 'SUBMIT_SUBREQUESTS() must be called from a concurrent request');
1204: end if;
1205:

Line 1253: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Submitting Workers for RCV Upgrade [CSTURCVW]');

1249: where ledger_id = nvl(X_Ledger_Id,ledger_id);
1250:
1251: l_stmt_num :=20;
1252: if (l_argument4 is not null) then
1253: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Submitting Workers for RCV Upgrade [CSTURCVW]');
1254: AD_CONC_UTILS_PKG.submit_subrequests(
1255: X_errbuf=>X_errbuf,
1256: X_retcode=>X_retcode,
1257: X_WorkerConc_app_shortname=>'BOM',

Line 1279: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> RCV Worker [CSTURCVW] '||RPAD(i,2)||' - '||l_sub_reqtab(i).request_id);

1275:
1276: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);
1277:
1278: for i IN 1..l_sub_reqtab.COUNT() loop
1279: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> RCV Worker [CSTURCVW] '||RPAD(i,2)||' - '||l_sub_reqtab(i).request_id);
1280: end loop;
1281:
1282: end if;
1283: exception

Line 1285: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'No Data Found in XUD');

1281:
1282: end if;
1283: exception
1284: when no_data_found then
1285: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'No Data Found in XUD');
1286: end;
1287: else
1288: X_errbuf := 'Cannot get schema name for product : '||l_product;
1289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1295: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Checking Status Of Child Workers....');

1291:
1292: --update migration_status_code and je_from_sla_flag
1293:
1294: else
1295: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Checking Status Of Child Workers....');
1296: --
1297: -- restart case
1298: --
1299: l_stmt_num :=40;

Line 1306: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Concurrent Request: '||l_sub_reqtab(i).request_id||' -> Status: '||l_sub_reqtab(i).dev_status);

1302: x_retcode := FND_API.G_RET_STS_SUCCESS;
1303: for i IN 1..l_sub_reqtab.COUNT()
1304: loop
1305: if (l_sub_reqtab(i).dev_status <> 'NORMAL') then
1306: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>Concurrent Request: '||l_sub_reqtab(i).request_id||' -> Status: '||l_sub_reqtab(i).dev_status);
1307: X_retcode := FND_API.g_ret_sts_unexp_error;
1308: end if;
1309: end loop;
1310:

Line 1312: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>All Child Workers are Successfull');

1308: end if;
1309: end loop;
1310:
1311: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then
1312: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>All Child Workers are Successfull');
1313: else
1314: X_errbuf := 'One or More of Child Workers completed in Error';
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1316: end if;

Line 1420: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

1416:
1417: BEGIN
1418:
1419: IF l_Log THEN
1420: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1421: ELSE
1422: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1423: END IF;
1424:

Line 1422: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

1418:
1419: IF l_Log THEN
1420: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1421: ELSE
1422: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1423: END IF;
1424:
1425: l_stmt_num :=0;
1426:

Line 1508: fnd_file.put_line(fnd_file.LOG, 'RETCODE := ' || X_retcode || '. ' ||x_errbuf);

1504: X_max_id=>l_end_id);
1505:
1506: IF (X_retcode <> FND_API.G_RET_STS_SUCCESS) then
1507: X_errbuf := 'Failure while updating INV Subledger rows from '|| l_start_id || ' To ' || l_end_id;
1508: fnd_file.put_line(fnd_file.LOG, 'RETCODE := ' || X_retcode || '. ' ||x_errbuf);
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: ELSE
1511: fnd_file.put_line(fnd_file.LOG, 'Inventory upgrade completed successfully for Range : ' || l_start_id || ' To ' || l_end_id);
1512: END IF;

Line 1511: fnd_file.put_line(fnd_file.LOG, 'Inventory upgrade completed successfully for Range : ' || l_start_id || ' To ' || l_end_id);

1507: X_errbuf := 'Failure while updating INV Subledger rows from '|| l_start_id || ' To ' || l_end_id;
1508: fnd_file.put_line(fnd_file.LOG, 'RETCODE := ' || X_retcode || '. ' ||x_errbuf);
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: ELSE
1511: fnd_file.put_line(fnd_file.LOG, 'Inventory upgrade completed successfully for Range : ' || l_start_id || ' To ' || l_end_id);
1512: END IF;
1513:
1514: /*l_rows_processed := SQL%ROWCOUNT;*/
1515: l_rows_processed := l_end_id - l_start_id + 1;

Line 1535: fnd_file.put_line(fnd_file.LOG, 'Inventory upgrade worker completed successfully.... ');

1531:
1532: end loop;
1533:
1534: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
1535: fnd_file.put_line(fnd_file.LOG, 'Inventory upgrade worker completed successfully.... ');
1536:
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;

Line 1540: fnd_file.put_line(fnd_file.LOG, x_errbuf);

1536:
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1540: fnd_file.put_line(fnd_file.LOG, x_errbuf);
1541: raise;
1542: END;
1543:
1544: <>

Line 1560: fnd_file.put_line(fnd_file.LOG, 'Unexpected error encountered. RETCODE:= ' || x_retcode || '. ' || x_errbuf);

1556: EXCEPTION
1557:
1558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1559: ROLLBACK;
1560: fnd_file.put_line(fnd_file.LOG, 'Unexpected error encountered. RETCODE:= ' || x_retcode || '. ' || x_errbuf);
1561: X_retcode := FND_API.g_ret_sts_unexp_error;
1562: handle_error ( X_module => l_module||'.'||l_stmt_num,
1563: X_message => 'ERROR: '||X_errbuf,
1564: X_reqerror => TRUE,

Line 1568: fnd_file.put_line(fnd_file.LOG, 'Exception encountered. RETCODE:= ' || x_retcode || '. ' || x_errbuf);

1564: X_reqerror => TRUE,
1565: X_errbuf => X_errbuf );
1566:
1567: WHEN OTHERS THEN
1568: fnd_file.put_line(fnd_file.LOG, 'Exception encountered. RETCODE:= ' || x_retcode || '. ' || x_errbuf);
1569: ROLLBACK;
1570: X_retcode := FND_API.g_ret_sts_unexp_error;
1571: handle_error ( X_module => l_module||'.'||l_stmt_num,
1572: X_message => 'EXCEPTION: '||SQLERRM,

Line 1647: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

1643:
1644: BEGIN
1645:
1646: IF l_Log THEN
1647: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1648: ELSE
1649: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1650: END IF;
1651:

Line 1649: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

1645:
1646: IF l_Log THEN
1647: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1648: ELSE
1649: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1650: END IF;
1651:
1652: l_stmt_num :=0;
1653:

Line 1735: fnd_file.put_line(fnd_file.LOG, 'RETCODE := ' || X_retcode || '. ' ||x_errbuf);

1731: X_max_id=>l_end_id);
1732:
1733: IF (X_retcode <>FND_API.G_RET_STS_SUCCESS) then
1734: X_errbuf := 'Failure while updating WIP Subledger from '|| l_start_id || ' To ' || l_end_id;
1735: fnd_file.put_line(fnd_file.LOG, 'RETCODE := ' || X_retcode || '. ' ||x_errbuf);
1736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1737: ELSE
1738: fnd_file.put_line(fnd_file.LOG, 'WIP upgrade completed successfully for Range : ' || l_start_id || ' To ' || l_end_id);
1739: END IF;

Line 1738: fnd_file.put_line(fnd_file.LOG, 'WIP upgrade completed successfully for Range : ' || l_start_id || ' To ' || l_end_id);

1734: X_errbuf := 'Failure while updating WIP Subledger from '|| l_start_id || ' To ' || l_end_id;
1735: fnd_file.put_line(fnd_file.LOG, 'RETCODE := ' || X_retcode || '. ' ||x_errbuf);
1736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1737: ELSE
1738: fnd_file.put_line(fnd_file.LOG, 'WIP upgrade completed successfully for Range : ' || l_start_id || ' To ' || l_end_id);
1739: END IF;
1740:
1741: /*l_rows_processed := SQL%ROWCOUNT;*/
1742: l_rows_processed := l_end_id - l_start_id + 1;

Line 1761: fnd_file.put_line(fnd_file.LOG, 'WIP upgrade worker completed successfully.... ');

1757: FALSE);
1758:
1759: end loop;
1760: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
1761: fnd_file.put_line(fnd_file.LOG, 'WIP upgrade worker completed successfully.... ');
1762:
1763: EXCEPTION
1764: WHEN OTHERS THEN
1765: fnd_file.put_line(fnd_file.LOG, x_errbuf);

Line 1765: fnd_file.put_line(fnd_file.LOG, x_errbuf);

1761: fnd_file.put_line(fnd_file.LOG, 'WIP upgrade worker completed successfully.... ');
1762:
1763: EXCEPTION
1764: WHEN OTHERS THEN
1765: fnd_file.put_line(fnd_file.LOG, x_errbuf);
1766: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1767: raise;
1768: END;
1769:

Line 1785: fnd_file.put_line(fnd_file.LOG, 'Unexpected error encountered. RETCODE:= ' || x_retcode || '. ' || x_errbuf);

1781:
1782: EXCEPTION
1783:
1784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1785: fnd_file.put_line(fnd_file.LOG, 'Unexpected error encountered. RETCODE:= ' || x_retcode || '. ' || x_errbuf);
1786: ROLLBACK;
1787: X_retcode := FND_API.g_ret_sts_unexp_error;
1788: handle_error ( X_module => l_module||'.'||l_stmt_num,
1789: X_message => 'ERROR: '||X_errbuf,

Line 1795: fnd_file.put_line(fnd_file.LOG, 'Exception encountered. RETCODE:= ' || x_retcode || '. ' || x_errbuf);

1791: X_errbuf => X_errbuf );
1792:
1793: WHEN OTHERS THEN
1794: ROLLBACK;
1795: fnd_file.put_line(fnd_file.LOG, 'Exception encountered. RETCODE:= ' || x_retcode || '. ' || x_errbuf);
1796: X_retcode := FND_API.g_ret_sts_unexp_error;
1797: handle_error ( X_module => l_module||'.'||l_stmt_num,
1798: X_message => 'EXCEPTION: '||SQLERRM,
1799: X_reqerror => TRUE,

Line 1875: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

1871:
1872: BEGIN
1873:
1874: IF l_Log THEN
1875: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1876: ELSE
1877: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1878: END IF;
1879:

Line 1877: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

1873:
1874: IF l_Log THEN
1875: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1876: ELSE
1877: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1878: END IF;
1879:
1880: l_stmt_num :=0;
1881:

Line 1984: fnd_file.put_line(fnd_file.LOG, 'RETCODE := ' || X_retcode || '. ' ||x_errbuf);

1980: X_max_id=>l_end_id);
1981:
1982: IF (X_retcode <>FND_API.G_RET_STS_SUCCESS) then
1983: X_errbuf := 'Failure while updating RCV Subledger from '|| l_start_id || ' To ' || l_end_id;
1984: fnd_file.put_line(fnd_file.LOG, 'RETCODE := ' || X_retcode || '. ' ||x_errbuf);
1985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1986: ELSE
1987: fnd_file.put_line(fnd_file.LOG, 'Receiving upgrade completed successfully for Range : ' || l_start_id || ' To ' || l_end_id);
1988: END IF;

Line 1987: fnd_file.put_line(fnd_file.LOG, 'Receiving upgrade completed successfully for Range : ' || l_start_id || ' To ' || l_end_id);

1983: X_errbuf := 'Failure while updating RCV Subledger from '|| l_start_id || ' To ' || l_end_id;
1984: fnd_file.put_line(fnd_file.LOG, 'RETCODE := ' || X_retcode || '. ' ||x_errbuf);
1985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1986: ELSE
1987: fnd_file.put_line(fnd_file.LOG, 'Receiving upgrade completed successfully for Range : ' || l_start_id || ' To ' || l_end_id);
1988: END IF;
1989:
1990: /*l_rows_processed := SQL%ROWCOUNT;*/
1991: l_rows_processed := l_end_id - l_start_id + 1;

Line 2010: fnd_file.put_line(fnd_file.LOG, 'Receiving upgrade worker completed successfully.... ');

2006: FALSE);
2007:
2008: end loop;
2009: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
2010: fnd_file.put_line(fnd_file.LOG, 'Receiving upgrade worker completed successfully.... ');
2011:
2012: EXCEPTION
2013: WHEN OTHERS THEN
2014: fnd_file.put_line(fnd_file.LOG, x_errbuf);

Line 2014: fnd_file.put_line(fnd_file.LOG, x_errbuf);

2010: fnd_file.put_line(fnd_file.LOG, 'Receiving upgrade worker completed successfully.... ');
2011:
2012: EXCEPTION
2013: WHEN OTHERS THEN
2014: fnd_file.put_line(fnd_file.LOG, x_errbuf);
2015: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
2016: raise;
2017: END;
2018:

Line 2034: fnd_file.put_line(fnd_file.LOG, 'Unexpected error encountered. RETCODE:= ' || x_retcode || '. ' || x_errbuf);

2030:
2031: EXCEPTION
2032:
2033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2034: fnd_file.put_line(fnd_file.LOG, 'Unexpected error encountered. RETCODE:= ' || x_retcode || '. ' || x_errbuf);
2035: ROLLBACK;
2036: X_retcode := FND_API.g_ret_sts_unexp_error;
2037: handle_error ( X_module => l_module||'.'||l_stmt_num,
2038: X_message => 'ERROR: '||X_errbuf,

Line 2043: fnd_file.put_line(fnd_file.LOG, 'Exception encountered. RETCODE:= ' || x_retcode || '. ' || x_errbuf);

2039: X_reqerror => TRUE,
2040: X_errbuf => X_errbuf );
2041:
2042: WHEN OTHERS THEN
2043: fnd_file.put_line(fnd_file.LOG, 'Exception encountered. RETCODE:= ' || x_retcode || '. ' || x_errbuf);
2044: ROLLBACK;
2045: X_retcode := FND_API.g_ret_sts_unexp_error;
2046: handle_error ( X_module => l_module||'.'||l_stmt_num,
2047: X_message => 'EXCEPTION: '||SQLERRM,

Line 2211: fnd_file.put_line(fnd_file.LOG, 'Update_Inventory_Subledger.. Processed rows : ' || l_rows_processed);

2207: );
2208: END IF;
2209: return;
2210: ELSE
2211: fnd_file.put_line(fnd_file.LOG, 'Update_Inventory_Subledger.. Processed rows : ' || l_rows_processed);
2212: END IF;
2213:
2214: l_stmt_num :=20;
2215:

Line 2991: fnd_file.put_line(fnd_file.LOG, 'Update_WIP_Subledger.. Processed rows : ' || l_rows_processed);

2987: );
2988: END IF;
2989: return;
2990: ELSE
2991: fnd_file.put_line(fnd_file.LOG, 'Update_WIP_Subledger.. Processed rows : ' || l_rows_processed);
2992: END IF;
2993:
2994: l_stmt_num :=20;
2995:

Line 3582: fnd_file.put_line(fnd_file.LOG, 'Update_Receiving_Subledger.. Processed rows : ' || l_rows_processed);

3578: );
3579: END IF;
3580: return;
3581: ELSE
3582: fnd_file.put_line(fnd_file.LOG, 'Update_Receiving_Subledger.. Processed rows : ' || l_rows_processed);
3583: END IF;
3584:
3585: l_stmt_num :=20;
3586: /* Bug 6729184 Moved update of rcv_sub_ledger_id prior to XLA insert to avoid NULL into