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

Line 142: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Receiving Transactions fact ...');

138: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
139: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
140: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
141:
142: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Receiving Transactions fact ...');
143:
144: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_RCV_TXNS_F name ...');
145:
146: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_RCV_TXNS_F;

Line 144: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_RCV_TXNS_F name ...');

140: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
141:
142: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Receiving Transactions fact ...');
143:
144: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_RCV_TXNS_F name ...');
145:
146: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_RCV_TXNS_F;
147:
148: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');

Line 148: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');

144: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_RCV_TXNS_F name ...');
145:
146: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_RCV_TXNS_F;
147:
148: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
149:
150: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_RCV_TXNS_F ...');
151:
152: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_RCV_TXNS_F');

Line 150: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_RCV_TXNS_F ...');

146: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_RCV_TXNS_F;
147:
148: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
149:
150: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_RCV_TXNS_F ...');
151:
152: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_RCV_TXNS_F');
153:
154: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');

Line 154: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');

150: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_RCV_TXNS_F ...');
151:
152: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_RCV_TXNS_F');
153:
154: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
155:
156: l_run_date := sysdate - 5 / (24 * 60);
157:
158: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_RCV_TXNS_F ...');

Line 158: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_RCV_TXNS_F ...');

154: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
155:
156: l_run_date := sysdate - 5 / (24 * 60);
157:
158: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_RCV_TXNS_F ...');
159:
160: INSERT INTO CSD_RETURNS_BI_RCV_TXNS_F
161: (
162: transaction_id,

Line 278: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');

274: and geo2.location_table_name(+) = 'HZ_LOCATIONS'
275: -- swai: 12.2 end
276: ;
277:
278: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
279:
280: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
281:
282: INSERT INTO CSD_FACT_DETAILS

Line 280: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');

276: ;
277:
278: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
279:
280: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
281:
282: INSERT INTO CSD_FACT_DETAILS
283: (fact_name,
284: last_run_date,

Line 307: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');

303: l_program_login_id,
304: l_program_application_id,
305: l_request_id);
306:
307: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
308:
309: commit;
310: retcode := C_OK;
311:

Line 312: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Leaving the initial refresh process for Receiving Transactions fact ...');

308:
309: commit;
310: retcode := C_OK;
311:
312: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Leaving the initial refresh process for Receiving Transactions fact ...');
313:
314: EXCEPTION
315:
316: WHEN OTHERS THEN

Line 318: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Unknown exception. SQLERRM = ' || SQLERRM);

314: EXCEPTION
315:
316: WHEN OTHERS THEN
317: retcode := C_ERROR;
318: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Unknown exception. SQLERRM = ' || SQLERRM);
319: ROLLBACK;
320: RAISE;
321:
322: END Initial_Load_RcvTxns_ETL;

Line 356: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Shipping Transactions fact ...');

352: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
353: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
354: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
355:
356: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Shipping Transactions fact ...');
357:
358: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_SHP_TXNS_F name ...');
359:
360: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_SHP_TXNS_F;

Line 358: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_SHP_TXNS_F name ...');

354: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
355:
356: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Shipping Transactions fact ...');
357:
358: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_SHP_TXNS_F name ...');
359:
360: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_SHP_TXNS_F;
361:
362: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');

Line 362: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');

358: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_SHP_TXNS_F name ...');
359:
360: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_SHP_TXNS_F;
361:
362: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
363:
364: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_SHP_TXNS_F ...');
365:
366: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_SHP_TXNS_F');

Line 364: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_SHP_TXNS_F ...');

360: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_SHP_TXNS_F;
361:
362: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
363:
364: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_SHP_TXNS_F ...');
365:
366: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_SHP_TXNS_F');
367:
368: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');

Line 368: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');

364: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_SHP_TXNS_F ...');
365:
366: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_SHP_TXNS_F');
367:
368: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
369:
370: l_run_date := sysdate - 5 / (24 * 60);
371:
372: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_SHP_TXNS_F ...');

Line 372: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_SHP_TXNS_F ...');

368: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
369:
370: l_run_date := sysdate - 5 / (24 * 60);
371:
372: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_SHP_TXNS_F ...');
373:
374: INSERT INTO CSD_RETURNS_BI_SHP_TXNS_F
375: (
376: transaction_id,

Line 459: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');

455: and oh.sold_to_org_id = hca.cust_account_id(+)
456: and hca.party_id = hp.party_id(+);
457:
458:
459: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
460:
461: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
462:
463: INSERT INTO CSD_FACT_DETAILS

Line 461: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');

457:
458:
459: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
460:
461: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
462:
463: INSERT INTO CSD_FACT_DETAILS
464: (fact_name,
465: last_run_date,

Line 488: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');

484: l_program_login_id,
485: l_program_application_id,
486: l_request_id);
487:
488: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
489:
490: commit;
491: retcode := C_OK;
492:

Line 493: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Leaving the initial refresh process for Shipping Transactions fact ...');

489:
490: commit;
491: retcode := C_OK;
492:
493: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Leaving the initial refresh process for Shipping Transactions fact ...');
494:
495: EXCEPTION
496:
497: WHEN OTHERS THEN

Line 499: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Unknown exception. SQLERRM = ' || SQLERRM);

495: EXCEPTION
496:
497: WHEN OTHERS THEN
498: retcode := C_ERROR;
499: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Unknown exception. SQLERRM = ' || SQLERRM);
500: ROLLBACK;
501: RAISE;
502:
503: END Initial_Load_SHPTxns_ETL;

Line 536: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Material Transactions fact ...');

532: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID, -1);
533: l_program_application_id := NVL(fnd_global.PROG_APPL_ID, -1);
534: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
535:
536: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Material Transactions fact ...');
537:
538: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_MTL_TXNS_F name ...');
539:
540: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_MTL_TXNS_F;

Line 538: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_MTL_TXNS_F name ...');

534: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
535:
536: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Material Transactions fact ...');
537:
538: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_MTL_TXNS_F name ...');
539:
540: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_MTL_TXNS_F;
541:
542: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');

Line 542: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');

538: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_MTL_TXNS_F name ...');
539:
540: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_MTL_TXNS_F;
541:
542: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
543:
544: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_MTL_TXNS_F ...');
545:
546: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_MTL_TXNS_F');

Line 544: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_MTL_TXNS_F ...');

540: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_MTL_TXNS_F;
541:
542: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
543:
544: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_MTL_TXNS_F ...');
545:
546: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_MTL_TXNS_F');
547:
548: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');

Line 548: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');

544: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_MTL_TXNS_F ...');
545:
546: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_MTL_TXNS_F');
547:
548: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
549:
550: l_run_date := sysdate - 5 / (24 * 60);
551:
552: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_MTL_TXNS_F ...');

Line 552: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_MTL_TXNS_F ...');

548: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
549:
550: l_run_date := sysdate - 5 / (24 * 60);
551:
552: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_MTL_TXNS_F ...');
553:
554: INSERT INTO CSD_RETURNS_BI_MTL_TXNS_F
555: (transaction_id,
556: operating_unit_id,

Line 707: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');

703: and cic.organization_id(+) = mtl.organization_id
704: and cic.cost_type_id(+) = 1;
705: -- swai: 12.2 end
706:
707: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
708:
709: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
710:
711: INSERT INTO CSD_FACT_DETAILS

Line 709: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');

705: -- swai: 12.2 end
706:
707: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
708:
709: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
710:
711: INSERT INTO CSD_FACT_DETAILS
712: (fact_name,
713: last_run_date,

Line 736: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');

732: l_program_login_id,
733: l_program_application_id,
734: l_request_id);
735:
736: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
737:
738: commit;
739: retcode := C_OK;
740:

Line 741: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Leaving the initial refresh process for Material Transactions fact ...');

737:
738: commit;
739: retcode := C_OK;
740:
741: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Leaving the initial refresh process for Material Transactions fact ...');
742:
743: EXCEPTION
744:
745: WHEN OTHERS THEN

Line 747: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Unknown exception. SQLERRM = ' || SQLERRM);

743: EXCEPTION
744:
745: WHEN OTHERS THEN
746: retcode := C_ERROR;
747: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Unknown exception. SQLERRM = ' || SQLERRM);
748: ROLLBACK;
749: RAISE;
750:
751: END Initial_Load_MtlTxns_ETL;

Line 770: FND_FILE.PUT_LINE(FND_FILE.LOG,

766: l_errbuf VARCHAR2(2000);
767: l_retcode VARCHAR2(1);
768:
769: BEGIN
770: FND_FILE.PUT_LINE(FND_FILE.LOG,
771: 'Entering the initial refresh process ...');
772:
773:
774: ---------------------------- RECEIVING TRANSACTIONS ----------------------------

Line 776: FND_FILE.PUT_LINE(FND_FILE.LOG,

772:
773:
774: ---------------------------- RECEIVING TRANSACTIONS ----------------------------
775: if (p_data_set in ('ALL', 'RETURNS', 'ECO_IMPACT', 'POM')) then
776: FND_FILE.PUT_LINE(FND_FILE.LOG,
777: 'Calling the initial refresh process for Receiving Transactions fact ...');
778:
779: -- Initializing to success.
780: retcode := c_OK;

Line 786: FND_FILE.PUT_LINE(FND_FILE.LOG,

782: CSD_RETURNS_BI_PVT.initial_load_RcvTxns_etl(errbuf => l_errbuf,
783: retcode => l_retcode);
784:
785: if (l_retcode = c_OK) then
786: FND_FILE.PUT_LINE(FND_FILE.LOG,
787: 'Initial refresh process for Receiving Transactions fact completed succesfully...');
788: else
789: FND_FILE.PUT_LINE(FND_FILE.LOG,
790: 'Initial refresh process for Receiving Transactions fact failed with following error: ' || l_errbuf);

Line 789: FND_FILE.PUT_LINE(FND_FILE.LOG,

785: if (l_retcode = c_OK) then
786: FND_FILE.PUT_LINE(FND_FILE.LOG,
787: 'Initial refresh process for Receiving Transactions fact completed succesfully...');
788: else
789: FND_FILE.PUT_LINE(FND_FILE.LOG,
790: 'Initial refresh process for Receiving Transactions fact failed with following error: ' || l_errbuf);
791: if (retcode < l_retcode) then
792: retcode := l_retcode;
793: errbuf := l_errbuf;

Line 799: FND_FILE.PUT_LINE(FND_FILE.LOG,

795: end if;
796: end if;
797: ---------------------------- SHIPPING TRANSACTIONS ----------------------------
798: if (p_data_set in ('ALL', 'POM')) then
799: FND_FILE.PUT_LINE(FND_FILE.LOG,
800: 'Calling the initial refresh process for Shipping Transactions fact ...');
801:
802: -- Initializing to success.
803: retcode := c_OK;

Line 809: FND_FILE.PUT_LINE(FND_FILE.LOG,

805: CSD_RETURNS_BI_PVT.initial_load_ShpTxns_etl(errbuf => l_errbuf,
806: retcode => l_retcode);
807:
808: if (l_retcode = c_OK) then
809: FND_FILE.PUT_LINE(FND_FILE.LOG,
810: 'Initial refresh process for Shipping Transactions fact completed succesfully...');
811: else
812: FND_FILE.PUT_LINE(FND_FILE.LOG,
813: 'Initial refresh process for Shipping Transactions fact failed with following error: ' || l_errbuf);

Line 812: FND_FILE.PUT_LINE(FND_FILE.LOG,

808: if (l_retcode = c_OK) then
809: FND_FILE.PUT_LINE(FND_FILE.LOG,
810: 'Initial refresh process for Shipping Transactions fact completed succesfully...');
811: else
812: FND_FILE.PUT_LINE(FND_FILE.LOG,
813: 'Initial refresh process for Shipping Transactions fact failed with following error: ' || l_errbuf);
814: if (retcode < l_retcode) then
815: retcode := l_retcode;
816: errbuf := l_errbuf;

Line 822: FND_FILE.PUT_LINE(FND_FILE.LOG,

818: end if;
819: end if;
820: ---------------------------- MATERIAL TRANSACTIONS ----------------------------
821: if (p_data_set in ('ALL', 'ECO_IMPACT', 'DISP_SUM')) then
822: FND_FILE.PUT_LINE(FND_FILE.LOG,
823: 'Calling the initial refresh process for Material Transactions fact ...');
824:
825: CSD_RETURNS_BI_PVT.initial_load_MtlTxns_etl(errbuf => l_errbuf,
826: retcode => l_retcode);

Line 829: FND_FILE.PUT_LINE(FND_FILE.LOG,

825: CSD_RETURNS_BI_PVT.initial_load_MtlTxns_etl(errbuf => l_errbuf,
826: retcode => l_retcode);
827:
828: if (l_retcode = c_OK) then
829: FND_FILE.PUT_LINE(FND_FILE.LOG,
830: 'Initial refresh process for Material Transactions fact completed succesfully...');
831: else
832: if (retcode < l_retcode) then
833: retcode := l_retcode;

Line 836: FND_FILE.PUT_LINE(FND_FILE.LOG,

832: if (retcode < l_retcode) then
833: retcode := l_retcode;
834: errbuf := l_errbuf;
835: end if;
836: FND_FILE.PUT_LINE(FND_FILE.LOG,
837: 'Initial refresh process for Material Transactions fact failed with following error: ' || l_errbuf);
838: end if;
839: end if;
840: -- commit;

Line 842: FND_FILE.PUT_LINE(FND_FILE.LOG,

838: end if;
839: end if;
840: -- commit;
841:
842: FND_FILE.PUT_LINE(FND_FILE.LOG,
843: 'Leaving the initial refresh process ...');
844:
845: EXCEPTION
846:

Line 849: FND_FILE.PUT_LINE(FND_FILE.LOG,

845: EXCEPTION
846:
847: WHEN OTHERS THEN
848: retcode := C_ERROR;
849: FND_FILE.PUT_LINE(FND_FILE.LOG,
850: 'Unknown exception. SQLERRM = ' || SQLERRM);
851: ROLLBACK;
852: RAISE;
853:

Line 870: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entering the concurrent program...');

866: l_refresh_method VARCHAR2(3);
867:
868: BEGIN
869:
870: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entering the concurrent program...');
871:
872: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling Initial_Load ...');
873: initial_load(errbuf, retcode, p_data_set);
874: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Returning from Initial_Load ...');

Line 872: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling Initial_Load ...');

868: BEGIN
869:
870: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entering the concurrent program...');
871:
872: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling Initial_Load ...');
873: initial_load(errbuf, retcode, p_data_set);
874: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Returning from Initial_Load ...');
875: l_refresh_method := 'C';
876:

Line 874: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Returning from Initial_Load ...');

870: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entering the concurrent program...');
871:
872: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling Initial_Load ...');
873: initial_load(errbuf, retcode, p_data_set);
874: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Returning from Initial_Load ...');
875: l_refresh_method := 'C';
876:
877: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling Refresh_Mviews...');
878: Refresh_Mviews(p_method => l_refresh_method,

Line 877: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling Refresh_Mviews...');

873: initial_load(errbuf, retcode, p_data_set);
874: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Returning from Initial_Load ...');
875: l_refresh_method := 'C';
876:
877: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling Refresh_Mviews...');
878: Refresh_Mviews(p_method => l_refresh_method,
879: p_data_set => p_data_set);
880: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Returning from Refresh_Mviews...');
881:

Line 880: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Returning from Refresh_Mviews...');

876:
877: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling Refresh_Mviews...');
878: Refresh_Mviews(p_method => l_refresh_method,
879: p_data_set => p_data_set);
880: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Returning from Refresh_Mviews...');
881:
882:
883: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Leaving the concurrent program...');
884:

Line 883: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Leaving the concurrent program...');

879: p_data_set => p_data_set);
880: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Returning from Refresh_Mviews...');
881:
882:
883: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Leaving the concurrent program...');
884:
885: EXCEPTION
886:
887: WHEN OTHERS THEN

Line 889: FND_FILE.PUT_LINE(FND_FILE.LOG,

885: EXCEPTION
886:
887: WHEN OTHERS THEN
888: retcode := C_ERROR;
889: FND_FILE.PUT_LINE(FND_FILE.LOG,
890: 'Unknown exception. SQLERRM = ' || SQLERRM);
891: ROLLBACK;
892: RAISE;
893: