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

Line 1026: -- fnd_file.put_line(fnd_file.log, 'SQLERRM = '||SQLERRM);

1022: SYSDATE);
1023: COMMIT;
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: -- fnd_file.put_line(fnd_file.log, 'SQLERRM = '||SQLERRM);
1027: RAISE;
1028: END log_message;
1029:
1030: /*

Line 1151: fnd_file.put_line(fnd_file.log, to_char(SQLCODE)||': '||err_msg);

1147: p_procedure_name => 'Delete_old_layers',
1148: p_parameters => err_num,
1149: p_message => 'Error deleting Old layer data for batch_id = '||p_batch_id||' '||err_msg,
1150: p_error_type => 'I');
1151: fnd_file.put_line(fnd_file.log, to_char(SQLCODE)||': '||err_msg);
1152: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1153: fnd_file.put_line(fnd_file.log, ' Error Deleting Old layer data. ');
1154: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1155: RAISE;

Line 1152: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');

1148: p_parameters => err_num,
1149: p_message => 'Error deleting Old layer data for batch_id = '||p_batch_id||' '||err_msg,
1150: p_error_type => 'I');
1151: fnd_file.put_line(fnd_file.log, to_char(SQLCODE)||': '||err_msg);
1152: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1153: fnd_file.put_line(fnd_file.log, ' Error Deleting Old layer data. ');
1154: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1155: RAISE;
1156:

Line 1153: fnd_file.put_line(fnd_file.log, ' Error Deleting Old layer data. ');

1149: p_message => 'Error deleting Old layer data for batch_id = '||p_batch_id||' '||err_msg,
1150: p_error_type => 'I');
1151: fnd_file.put_line(fnd_file.log, to_char(SQLCODE)||': '||err_msg);
1152: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1153: fnd_file.put_line(fnd_file.log, ' Error Deleting Old layer data. ');
1154: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1155: RAISE;
1156:
1157: END Delete_old_layers;

Line 1154: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');

1150: p_error_type => 'I');
1151: fnd_file.put_line(fnd_file.log, to_char(SQLCODE)||': '||err_msg);
1152: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1153: fnd_file.put_line(fnd_file.log, ' Error Deleting Old layer data. ');
1154: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1155: RAISE;
1156:
1157: END Delete_old_layers;
1158:

Line 1265: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');

1261: where layer_id = vib.CONSUME_LAYER_ID;
1262:
1263: ELSE
1264:
1265: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1266: fnd_file.put_line(fnd_file.log, ' ERROR in ELSE condition deleting period layers. ');
1267: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1268: RAISE e_baddata;
1269:

Line 1266: fnd_file.put_line(fnd_file.log, ' ERROR in ELSE condition deleting period layers. ');

1262:
1263: ELSE
1264:
1265: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1266: fnd_file.put_line(fnd_file.log, ' ERROR in ELSE condition deleting period layers. ');
1267: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1268: RAISE e_baddata;
1269:
1270: END IF;

Line 1267: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');

1263: ELSE
1264:
1265: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1266: fnd_file.put_line(fnd_file.log, ' ERROR in ELSE condition deleting period layers. ');
1267: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1268: RAISE e_baddata;
1269:
1270: END IF;
1271:

Line 1353: fnd_file.put_line(fnd_file.log, to_char(SQLCODE)||': '||err_msg);

1349: p_procedure_name => 'Delete_period_layers',
1350: p_parameters => err_num,
1351: p_message => 'Error deleting Old layer data for batch_id = '||p_batch_id||' Period id '||p_period_id||
1352: ' '||err_msg,p_error_type => 'I');
1353: fnd_file.put_line(fnd_file.log, to_char(SQLCODE)||': '||err_msg);
1354: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1355: fnd_file.put_line(fnd_file.log, ' Error Deleting Old layer data, Please ROLLBACK. ');
1356: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1357: RAISE;

Line 1354: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');

1350: p_parameters => err_num,
1351: p_message => 'Error deleting Old layer data for batch_id = '||p_batch_id||' Period id '||p_period_id||
1352: ' '||err_msg,p_error_type => 'I');
1353: fnd_file.put_line(fnd_file.log, to_char(SQLCODE)||': '||err_msg);
1354: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1355: fnd_file.put_line(fnd_file.log, ' Error Deleting Old layer data, Please ROLLBACK. ');
1356: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1357: RAISE;
1358:

Line 1355: fnd_file.put_line(fnd_file.log, ' Error Deleting Old layer data, Please ROLLBACK. ');

1351: p_message => 'Error deleting Old layer data for batch_id = '||p_batch_id||' Period id '||p_period_id||
1352: ' '||err_msg,p_error_type => 'I');
1353: fnd_file.put_line(fnd_file.log, to_char(SQLCODE)||': '||err_msg);
1354: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1355: fnd_file.put_line(fnd_file.log, ' Error Deleting Old layer data, Please ROLLBACK. ');
1356: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1357: RAISE;
1358:
1359: END Delete_period_layers;

Line 1356: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');

1352: ' '||err_msg,p_error_type => 'I');
1353: fnd_file.put_line(fnd_file.log, to_char(SQLCODE)||': '||err_msg);
1354: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1355: fnd_file.put_line(fnd_file.log, ' Error Deleting Old layer data, Please ROLLBACK. ');
1356: fnd_file.put_line(fnd_file.log, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
1357: RAISE;
1358:
1359: END Delete_period_layers;
1360:

Line 1564: -- fnd_file.put_line ('Error in UOM conversion');

1560: );
1561:
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: -- fnd_file.put_line ('Error in UOM conversion');
1565: -- fnd_file.put_line ('From UOM = '||mt.trans_um||', To UOM = '||t.doc_um);
1566: GMF_LAYERS.log_message (
1567: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1568: p_procedure_name => 'None',

Line 1565: -- fnd_file.put_line ('From UOM = '||mt.trans_um||', To UOM = '||t.doc_um);

1561:
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: -- fnd_file.put_line ('Error in UOM conversion');
1565: -- fnd_file.put_line ('From UOM = '||mt.trans_um||', To UOM = '||t.doc_um);
1566: GMF_LAYERS.log_message (
1567: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1568: p_procedure_name => 'None',
1569: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id)||

Line 1590: -- fnd_file.put_line ('Error creating outgoing layer : '||to_char (mt.trans_id));

1586: x_msg_data => x_msg_data);
1587:
1588: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1589: --
1590: -- fnd_file.put_line ('Error creating outgoing layer : '||to_char (mt.trans_id));
1591: GMF_LAYERS.log_message (
1592: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1593: p_procedure_name => 'None',
1594: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),

Line 1767: -- fnd_file.put_line ('Error creating resource layer : '||to_char (rt.poc_trans_id));

1763: x_msg_count,
1764: x_msg_data);
1765:
1766: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1767: -- fnd_file.put_line ('Error creating resource layer : '||to_char (rt.poc_trans_id));
1768: GMF_LAYERS.log_message (
1769: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1770: p_procedure_name => 'None',
1771: p_parameters => 'POC Trans ID = '||to_char(rt.poc_trans_id),

Line 2024: -- fnd_file.put_line ('Error in UOM conversion');

2020: );
2021:
2022: EXCEPTION
2023: WHEN OTHERS THEN
2024: -- fnd_file.put_line ('Error in UOM conversion');
2025: -- fnd_file.put_line ('From UOM = '||mt.trans_um||', To UOM = '||t.doc_um);
2026: GMF_LAYERS.log_message (
2027: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2028: p_procedure_name => 'None',

Line 2025: -- fnd_file.put_line ('From UOM = '||mt.trans_um||', To UOM = '||t.doc_um);

2021:
2022: EXCEPTION
2023: WHEN OTHERS THEN
2024: -- fnd_file.put_line ('Error in UOM conversion');
2025: -- fnd_file.put_line ('From UOM = '||mt.trans_um||', To UOM = '||t.doc_um);
2026: GMF_LAYERS.log_message (
2027: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2028: p_procedure_name => 'None',
2029: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id)||

Line 2062: -- fnd_file.put_line ('Error creating incoming layer : '||to_char (mt.trans_id));

2058:
2059: END IF;
2060:
2061: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2062: -- fnd_file.put_line ('Error creating incoming layer : '||to_char (mt.trans_id));
2063: GMF_LAYERS.log_message (
2064: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2065: p_procedure_name => 'None',
2066: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),

Line 2293: fnd_file.put_line(fnd_file.log, ' ========================================================' );

2289:
2290:
2291: BEGIN
2292:
2293: fnd_file.put_line(fnd_file.log, ' ========================================================' );
2294: fnd_file.put_line(fnd_file.log, ' Starting Migration of layer data at '|| to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2295: fnd_file.put_line(fnd_file.log, 'Request Parameters le id '||l_legal_entity_id||' Cost Calendar '||l_calendar||' Period '||
2296: l_period||' CostTypId ' ||l_cost_type||' Batch Org id '||l_org_id||' Batch id'||l_batch_id);
2297: fnd_file.put_line(fnd_file.log, ' ========================================================' );

Line 2294: fnd_file.put_line(fnd_file.log, ' Starting Migration of layer data at '|| to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

2290:
2291: BEGIN
2292:
2293: fnd_file.put_line(fnd_file.log, ' ========================================================' );
2294: fnd_file.put_line(fnd_file.log, ' Starting Migration of layer data at '|| to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2295: fnd_file.put_line(fnd_file.log, 'Request Parameters le id '||l_legal_entity_id||' Cost Calendar '||l_calendar||' Period '||
2296: l_period||' CostTypId ' ||l_cost_type||' Batch Org id '||l_org_id||' Batch id'||l_batch_id);
2297: fnd_file.put_line(fnd_file.log, ' ========================================================' );
2298:

Line 2295: fnd_file.put_line(fnd_file.log, 'Request Parameters le id '||l_legal_entity_id||' Cost Calendar '||l_calendar||' Period '||

2291: BEGIN
2292:
2293: fnd_file.put_line(fnd_file.log, ' ========================================================' );
2294: fnd_file.put_line(fnd_file.log, ' Starting Migration of layer data at '|| to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2295: fnd_file.put_line(fnd_file.log, 'Request Parameters le id '||l_legal_entity_id||' Cost Calendar '||l_calendar||' Period '||
2296: l_period||' CostTypId ' ||l_cost_type||' Batch Org id '||l_org_id||' Batch id'||l_batch_id);
2297: fnd_file.put_line(fnd_file.log, ' ========================================================' );
2298:
2299: l_debug_level := TO_NUMBER(FND_PROFILE.VALUE( 'GMF_CONC_DEBUG' )); -- B 10196137

Line 2297: fnd_file.put_line(fnd_file.log, ' ========================================================' );

2293: fnd_file.put_line(fnd_file.log, ' ========================================================' );
2294: fnd_file.put_line(fnd_file.log, ' Starting Migration of layer data at '|| to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2295: fnd_file.put_line(fnd_file.log, 'Request Parameters le id '||l_legal_entity_id||' Cost Calendar '||l_calendar||' Period '||
2296: l_period||' CostTypId ' ||l_cost_type||' Batch Org id '||l_org_id||' Batch id'||l_batch_id);
2297: fnd_file.put_line(fnd_file.log, ' ========================================================' );
2298:
2299: l_debug_level := TO_NUMBER(FND_PROFILE.VALUE( 'GMF_CONC_DEBUG' )); -- B 10196137
2300:
2301: OPEN cur_get_periodid;

Line 2305: fnd_file.put_line(fnd_file.log, 'Period ID '||l_periodid||' Period Start Date '||to_char(l_startdate,'DD-MON-YYYY HH24:MI:SS')

2301: OPEN cur_get_periodid;
2302: FETCH cur_get_periodid INTO l_periodid, l_startdate, l_enddate;
2303: CLOSE cur_get_periodid;
2304:
2305: fnd_file.put_line(fnd_file.log, 'Period ID '||l_periodid||' Period Start Date '||to_char(l_startdate,'DD-MON-YYYY HH24:MI:SS')
2306: ||' Period End Date '||to_char(l_enddate,'DD-MON-YYYY HH24:MI:SS'));
2307:
2308: IF l_periodid IS NULL THEN
2309: fnd_file.put_line(fnd_file.log, 'Period not found ');

Line 2309: fnd_file.put_line(fnd_file.log, 'Period not found ');

2305: fnd_file.put_line(fnd_file.log, 'Period ID '||l_periodid||' Period Start Date '||to_char(l_startdate,'DD-MON-YYYY HH24:MI:SS')
2306: ||' Period End Date '||to_char(l_enddate,'DD-MON-YYYY HH24:MI:SS'));
2307:
2308: IF l_periodid IS NULL THEN
2309: fnd_file.put_line(fnd_file.log, 'Period not found ');
2310: fnd_file.put_line
2311: (fnd_file.log,'Can not Continue. Returning without migrating data' );
2312:
2313: l_ret_status := fnd_concurrent.set_completion_status('ERROR','Error Period Not Found.');

Line 2310: fnd_file.put_line

2306: ||' Period End Date '||to_char(l_enddate,'DD-MON-YYYY HH24:MI:SS'));
2307:
2308: IF l_periodid IS NULL THEN
2309: fnd_file.put_line(fnd_file.log, 'Period not found ');
2310: fnd_file.put_line
2311: (fnd_file.log,'Can not Continue. Returning without migrating data' );
2312:
2313: l_ret_status := fnd_concurrent.set_completion_status('ERROR','Error Period Not Found.');
2314: RETURN;

Line 2311: (fnd_file.log,'Can not Continue. Returning without migrating data' );

2307:
2308: IF l_periodid IS NULL THEN
2309: fnd_file.put_line(fnd_file.log, 'Period not found ');
2310: fnd_file.put_line
2311: (fnd_file.log,'Can not Continue. Returning without migrating data' );
2312:
2313: l_ret_status := fnd_concurrent.set_completion_status('ERROR','Error Period Not Found.');
2314: RETURN;
2315: END IF;

Line 2339: fnd_file.put_line

2335: OPEN Cur_cost_type;
2336: FETCH Cur_cost_type INTO l_type;
2337: CLOSE Cur_cost_type;
2338:
2339: fnd_file.put_line
2340: (fnd_file.log,'Fiscal policy Cost Type (Alternate for Lot Costing) Actual=1 Standard=0 Is '||l_type );
2341:
2342: IF (l_type = 1) THEN
2343:

Line 2340: (fnd_file.log,'Fiscal policy Cost Type (Alternate for Lot Costing) Actual=1 Standard=0 Is '||l_type );

2336: FETCH Cur_cost_type INTO l_type;
2337: CLOSE Cur_cost_type;
2338:
2339: fnd_file.put_line
2340: (fnd_file.log,'Fiscal policy Cost Type (Alternate for Lot Costing) Actual=1 Standard=0 Is '||l_type );
2341:
2342: IF (l_type = 1) THEN
2343:
2344: OPEN Cur_OPM_costed;

Line 2348: fnd_file.put_line

2344: OPEN Cur_OPM_costed;
2345: FETCH Cur_OPM_costed INTO l_posted_cnt;
2346: CLOSE Cur_OPM_costed;
2347:
2348: fnd_file.put_line
2349: (fnd_file.log,'Posted Transaction Count '||l_posted_cnt );
2350:
2351: IF l_posted_cnt > 0 THEN
2352:

Line 2349: (fnd_file.log,'Posted Transaction Count '||l_posted_cnt );

2345: FETCH Cur_OPM_costed INTO l_posted_cnt;
2346: CLOSE Cur_OPM_costed;
2347:
2348: fnd_file.put_line
2349: (fnd_file.log,'Posted Transaction Count '||l_posted_cnt );
2350:
2351: IF l_posted_cnt > 0 THEN
2352:
2353: fnd_file.put_line

Line 2353: fnd_file.put_line

2349: (fnd_file.log,'Posted Transaction Count '||l_posted_cnt );
2350:
2351: IF l_posted_cnt > 0 THEN
2352:
2353: fnd_file.put_line
2354: (fnd_file.log,'Cost type Or Default Lot cost type is Actual Costing and '||l_posted_cnt||' Transactions are already posted.' );
2355: fnd_file.put_line
2356: (fnd_file.log,'Can not Continue. Returning without migrating data' );
2357:

Line 2354: (fnd_file.log,'Cost type Or Default Lot cost type is Actual Costing and '||l_posted_cnt||' Transactions are already posted.' );

2350:
2351: IF l_posted_cnt > 0 THEN
2352:
2353: fnd_file.put_line
2354: (fnd_file.log,'Cost type Or Default Lot cost type is Actual Costing and '||l_posted_cnt||' Transactions are already posted.' );
2355: fnd_file.put_line
2356: (fnd_file.log,'Can not Continue. Returning without migrating data' );
2357:
2358: l_ret_status := fnd_concurrent.set_completion_status('ERROR','Errors found during processing.'||

Line 2355: fnd_file.put_line

2351: IF l_posted_cnt > 0 THEN
2352:
2353: fnd_file.put_line
2354: (fnd_file.log,'Cost type Or Default Lot cost type is Actual Costing and '||l_posted_cnt||' Transactions are already posted.' );
2355: fnd_file.put_line
2356: (fnd_file.log,'Can not Continue. Returning without migrating data' );
2357:
2358: l_ret_status := fnd_concurrent.set_completion_status('ERROR','Errors found during processing.'||
2359: ' Please check the log file for details.');

Line 2356: (fnd_file.log,'Can not Continue. Returning without migrating data' );

2352:
2353: fnd_file.put_line
2354: (fnd_file.log,'Cost type Or Default Lot cost type is Actual Costing and '||l_posted_cnt||' Transactions are already posted.' );
2355: fnd_file.put_line
2356: (fnd_file.log,'Can not Continue. Returning without migrating data' );
2357:
2358: l_ret_status := fnd_concurrent.set_completion_status('ERROR','Errors found during processing.'||
2359: ' Please check the log file for details.');
2360:

Line 2378: fnd_file.put_line(fnd_file.log, 'Opening batch_id cursor case 1 for batch_id '||l_batch_id);

2374: */
2375:
2376: IF l_batch_id IS NOT NULL THEN
2377:
2378: fnd_file.put_line(fnd_file.log, 'Opening batch_id cursor case 1 for batch_id '||l_batch_id);
2379:
2380: OPEN cur_batches FOR
2381: SELECT batch_id, batch_no, batch_status , asd, batch_close_date
2382: FROM (

Line 2430: fnd_file.put_line(fnd_file.log, 'Opening org_id cursor case 2 for org_id '||l_org_id);

2426:
2427:
2428: ELSIF (l_batch_id IS NULL AND l_org_id IS NOT NULL) THEN
2429:
2430: fnd_file.put_line(fnd_file.log, 'Opening org_id cursor case 2 for org_id '||l_org_id);
2431:
2432: OPEN cur_batches FOR
2433: SELECT batch_id, batch_no, batch_status , asd, batch_close_date
2434: FROM (

Line 2482: fnd_file.put_line(fnd_file.log, 'Opening period cursor case 3 for start date '||to_char(l_startdate,'DD-MON-RRRR HH24:MI:SS')||' end date '||

2478: WHERE legal_entity_id = l_legal_entity_id);
2479:
2480: ELSIF (l_batch_id IS NULL AND l_org_id IS NULL) THEN
2481:
2482: fnd_file.put_line(fnd_file.log, 'Opening period cursor case 3 for start date '||to_char(l_startdate,'DD-MON-RRRR HH24:MI:SS')||' end date '||
2483: to_char(l_enddate,'DD-MON-RRRR HH24:MI:SS'));
2484:
2485: OPEN cur_batches FOR
2486: SELECT batch_id, batch_no, batch_status , asd, batch_close_date

Line 2538: fnd_file.put_line(fnd_file.log, 'In Loop Migrating layer data for Batch Number '||rec.batch_no);

2534: FETCH cur_batches INTO rec;
2535: WHILE cur_batches%FOUND LOOP
2536:
2537:
2538: fnd_file.put_line(fnd_file.log, 'In Loop Migrating layer data for Batch Number '||rec.batch_no);
2539:
2540: IF ((rec.actual_start_date >= l_startdate) AND (rec.actual_start_date <= l_enddate)) THEN
2541:
2542: fnd_file.put_line(fnd_file.log, ' Deleting Old layers for Batch_id '|| rec.batch_id||' Batch No '||rec.batch_no);

Line 2542: fnd_file.put_line(fnd_file.log, ' Deleting Old layers for Batch_id '|| rec.batch_id||' Batch No '||rec.batch_no);

2538: fnd_file.put_line(fnd_file.log, 'In Loop Migrating layer data for Batch Number '||rec.batch_no);
2539:
2540: IF ((rec.actual_start_date >= l_startdate) AND (rec.actual_start_date <= l_enddate)) THEN
2541:
2542: fnd_file.put_line(fnd_file.log, ' Deleting Old layers for Batch_id '|| rec.batch_id||' Batch No '||rec.batch_no);
2543: GMF_LAYERS.Delete_old_layers(rec.batch_id);
2544:
2545: ELSE
2546:

Line 2547: fnd_file.put_line(fnd_file.log, ' Deleting Period layers for Batch_id '|| rec.batch_id||' Batch No '||rec.batch_no||' Period id '||l_periodid);

2543: GMF_LAYERS.Delete_old_layers(rec.batch_id);
2544:
2545: ELSE
2546:
2547: fnd_file.put_line(fnd_file.log, ' Deleting Period layers for Batch_id '|| rec.batch_id||' Batch No '||rec.batch_no||' Period id '||l_periodid);
2548: GMF_LAYERS.Delete_period_layers(rec.batch_id, l_periodid);
2549:
2550: END IF;
2551:

Line 2552: fnd_file.put_line(fnd_file.log, ' END Deleting Old layers for Batch_id '|| rec.batch_id||' Batch No '||rec.batch_no||' Period id '||l_periodid);

2548: GMF_LAYERS.Delete_period_layers(rec.batch_id, l_periodid);
2549:
2550: END IF;
2551:
2552: fnd_file.put_line(fnd_file.log, ' END Deleting Old layers for Batch_id '|| rec.batch_id||' Batch No '||rec.batch_no||' Period id '||l_periodid);
2553: -- Moved Declaration to top
2554: fnd_file.put_line(fnd_file.log, ' Rebuilding outgoing layers data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);
2555:
2556: GMF_LAYERS.Recreate_outgoing_layers(rec.batch_id,l_periodid);

Line 2554: fnd_file.put_line(fnd_file.log, ' Rebuilding outgoing layers data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);

2550: END IF;
2551:
2552: fnd_file.put_line(fnd_file.log, ' END Deleting Old layers for Batch_id '|| rec.batch_id||' Batch No '||rec.batch_no||' Period id '||l_periodid);
2553: -- Moved Declaration to top
2554: fnd_file.put_line(fnd_file.log, ' Rebuilding outgoing layers data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);
2555:
2556: GMF_LAYERS.Recreate_outgoing_layers(rec.batch_id,l_periodid);
2557:
2558: fnd_file.put_line(fnd_file.log, ' Rebuilding Resource data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);

Line 2558: fnd_file.put_line(fnd_file.log, ' Rebuilding Resource data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);

2554: fnd_file.put_line(fnd_file.log, ' Rebuilding outgoing layers data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);
2555:
2556: GMF_LAYERS.Recreate_outgoing_layers(rec.batch_id,l_periodid);
2557:
2558: fnd_file.put_line(fnd_file.log, ' Rebuilding Resource data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);
2559:
2560: GMF_LAYERS.Recreate_resource_layers(rec.batch_id,l_periodid);
2561:
2562: fnd_file.put_line(fnd_file.log, ' Rebuilding incoming layers data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);

Line 2562: fnd_file.put_line(fnd_file.log, ' Rebuilding incoming layers data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);

2558: fnd_file.put_line(fnd_file.log, ' Rebuilding Resource data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);
2559:
2560: GMF_LAYERS.Recreate_resource_layers(rec.batch_id,l_periodid);
2561:
2562: fnd_file.put_line(fnd_file.log, ' Rebuilding incoming layers data for Batch_id '|| rec.batch_id||' Period id '||l_periodid);
2563:
2564: GMF_LAYERS.Recreate_incoming_layers(rec.batch_id,l_periodid);
2565:
2566: -- Or call if r=batch close date i in period being passed?

Line 2569: fnd_file.put_line(fnd_file.log, ' Finalizing layers data for Close Batch_id '|| rec.batch_id);

2565:
2566: -- Or call if r=batch close date i in period being passed?
2567: IF ((rec.batch_status = 4) AND (rec.batch_close_date >= l_startdate) AND (rec.batch_close_date <= l_enddate)) THEN
2568:
2569: fnd_file.put_line(fnd_file.log, ' Finalizing layers data for Close Batch_id '|| rec.batch_id);
2570:
2571: GMF_LAYERS.Finalize_batch (rec.batch_id,l_periodid);
2572:
2573: END IF;

Line 2579: fnd_file.put_line(fnd_file.log, ' After rebuild record count for Batch_id '|| rec.batch_id||' Batch No '||rec.batch_no);

2575: -- Bug 10196137 Perform these queries and log messages only if debug level is 3.
2576:
2577: IF l_debug_level > 2 THEN
2578:
2579: fnd_file.put_line(fnd_file.log, ' After rebuild record count for Batch_id '|| rec.batch_id||' Batch No '||rec.batch_no);
2580:
2581: SELECT count(*) INTO l_count
2582: FROM gmf_incoming_material_layers il
2583: WHERE il.PSEUDO_LAYER_ID IS NOT NULL

Line 2595: fnd_file.put_line(fnd_file.log, ' Psuedo Incoming layers count = '|| l_count);

2591: AND im.mmt_transaction_id = t.transaction_id
2592: AND im.mmt_organization_id = t.organization_id
2593: AND im.layer_id = il.PSEUDO_LAYER_ID
2594: );
2595: fnd_file.put_line(fnd_file.log, ' Psuedo Incoming layers count = '|| l_count);
2596: SELECT count(*) INTO l_count
2597: FROM gmf_incoming_material_layers il
2598: WHERE (il.mmt_organization_id, il.mmt_transaction_id) IN
2599: (SELECT DISTINCT t.organization_id, t.transaction_id

Line 2605: fnd_file.put_line(fnd_file.log, ' Incoming layers count = '|| l_count);

2601: WHERE h.batch_id = rec.batch_id
2602: AND h.batch_id = t.transaction_source_id
2603: AND t.transaction_source_type_id = 5
2604: );
2605: fnd_file.put_line(fnd_file.log, ' Incoming layers count = '|| l_count);
2606: SELECT count(*) INTO l_count
2607: FROM gmf_outgoing_material_layers ol
2608: WHERE (ol.mmt_organization_id, ol.mmt_transaction_id) IN
2609: (SELECT DISTINCT t.organization_id, t.transaction_id

Line 2615: fnd_file.put_line(fnd_file.log, ' Outgoing layers count = '|| l_count);

2611: WHERE h.batch_id = rec.batch_id
2612: AND h.batch_id = t.transaction_source_id
2613: AND t.transaction_source_type_id = 5
2614: );
2615: fnd_file.put_line(fnd_file.log, ' Outgoing layers count = '|| l_count);
2616: SELECT count(*) INTO l_count
2617: FROM gmf_batch_vib_details bvd
2618: WHERE bvd.requirement_id IN
2619: (SELECT br.requirement_id

Line 2624: fnd_file.put_line(fnd_file.log, ' Batch Vib details count = '|| l_count);

2620: FROM gmf_batch_requirements br, gme_batch_header h
2621: WHERE h.batch_id = rec.batch_id
2622: AND h.batch_id = br.batch_id
2623: );
2624: fnd_file.put_line(fnd_file.log, ' Batch Vib details count = '|| l_count);
2625: SELECT count(*) INTO l_count
2626: FROM gmf_batch_requirements br
2627: WHERE br.batch_id IN
2628: (SELECT batch_id

Line 2632: fnd_file.put_line(fnd_file.log, ' Batch requirements count = '|| l_count);

2628: (SELECT batch_id
2629: FROM gme_batch_header
2630: WHERE batch_id = rec.batch_id
2631: );
2632: fnd_file.put_line(fnd_file.log, ' Batch requirements count = '|| l_count);
2633:
2634: END IF; -- Bug 10196137 Perform these queries and log messages only if debug level is 3
2635:
2636: fnd_file.put_line(fnd_file.log, 'END rebuilding layers for Batch No = '|| rec.batch_no);

Line 2636: fnd_file.put_line(fnd_file.log, 'END rebuilding layers for Batch No = '|| rec.batch_no);

2632: fnd_file.put_line(fnd_file.log, ' Batch requirements count = '|| l_count);
2633:
2634: END IF; -- Bug 10196137 Perform these queries and log messages only if debug level is 3
2635:
2636: fnd_file.put_line(fnd_file.log, 'END rebuilding layers for Batch No = '|| rec.batch_no);
2637:
2638: COMMIT;
2639: FETCH cur_batches INTO rec;
2640:

Line 2643: fnd_file.put_line

2639: FETCH cur_batches INTO rec;
2640:
2641: END LOOP;
2642:
2643: fnd_file.put_line
2644: (fnd_file.log,'Layer Migration finished at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2645:
2646: l_ret_status := fnd_concurrent.set_completion_status('NORMAL','Process completed successfully.');
2647:

Line 2644: (fnd_file.log,'Layer Migration finished at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

2640:
2641: END LOOP;
2642:
2643: fnd_file.put_line
2644: (fnd_file.log,'Layer Migration finished at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2645:
2646: l_ret_status := fnd_concurrent.set_completion_status('NORMAL','Process completed successfully.');
2647:
2648:

Line 2651: fnd_file.put_line(fnd_file.log, ' *****************************************************' );

2647:
2648:
2649: EXCEPTION
2650: WHEN OTHERS THEN
2651: fnd_file.put_line(fnd_file.log, ' *****************************************************' );
2652: fnd_file.put_line(fnd_file.log, ' Error Running script for Batch_id '|| rec.batch_id);
2653: fnd_file.put_line(fnd_file.log, ' Please check table gme_temp_exceptions for details' );
2654: fnd_file.put_line(fnd_file.log, ' *****************************************************' );
2655: fnd_file.put_line(fnd_file.log,'ERROR: '||substr(sqlerrm,1,100) || ' While Remigrating layer data.');

Line 2652: fnd_file.put_line(fnd_file.log, ' Error Running script for Batch_id '|| rec.batch_id);

2648:
2649: EXCEPTION
2650: WHEN OTHERS THEN
2651: fnd_file.put_line(fnd_file.log, ' *****************************************************' );
2652: fnd_file.put_line(fnd_file.log, ' Error Running script for Batch_id '|| rec.batch_id);
2653: fnd_file.put_line(fnd_file.log, ' Please check table gme_temp_exceptions for details' );
2654: fnd_file.put_line(fnd_file.log, ' *****************************************************' );
2655: fnd_file.put_line(fnd_file.log,'ERROR: '||substr(sqlerrm,1,100) || ' While Remigrating layer data.');
2656: l_ret_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm || ' While Remigrating layer data.' );

Line 2653: fnd_file.put_line(fnd_file.log, ' Please check table gme_temp_exceptions for details' );

2649: EXCEPTION
2650: WHEN OTHERS THEN
2651: fnd_file.put_line(fnd_file.log, ' *****************************************************' );
2652: fnd_file.put_line(fnd_file.log, ' Error Running script for Batch_id '|| rec.batch_id);
2653: fnd_file.put_line(fnd_file.log, ' Please check table gme_temp_exceptions for details' );
2654: fnd_file.put_line(fnd_file.log, ' *****************************************************' );
2655: fnd_file.put_line(fnd_file.log,'ERROR: '||substr(sqlerrm,1,100) || ' While Remigrating layer data.');
2656: l_ret_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm || ' While Remigrating layer data.' );
2657:

Line 2654: fnd_file.put_line(fnd_file.log, ' *****************************************************' );

2650: WHEN OTHERS THEN
2651: fnd_file.put_line(fnd_file.log, ' *****************************************************' );
2652: fnd_file.put_line(fnd_file.log, ' Error Running script for Batch_id '|| rec.batch_id);
2653: fnd_file.put_line(fnd_file.log, ' Please check table gme_temp_exceptions for details' );
2654: fnd_file.put_line(fnd_file.log, ' *****************************************************' );
2655: fnd_file.put_line(fnd_file.log,'ERROR: '||substr(sqlerrm,1,100) || ' While Remigrating layer data.');
2656: l_ret_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm || ' While Remigrating layer data.' );
2657:
2658: ROLLBACK;

Line 2655: fnd_file.put_line(fnd_file.log,'ERROR: '||substr(sqlerrm,1,100) || ' While Remigrating layer data.');

2651: fnd_file.put_line(fnd_file.log, ' *****************************************************' );
2652: fnd_file.put_line(fnd_file.log, ' Error Running script for Batch_id '|| rec.batch_id);
2653: fnd_file.put_line(fnd_file.log, ' Please check table gme_temp_exceptions for details' );
2654: fnd_file.put_line(fnd_file.log, ' *****************************************************' );
2655: fnd_file.put_line(fnd_file.log,'ERROR: '||substr(sqlerrm,1,100) || ' While Remigrating layer data.');
2656: l_ret_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm || ' While Remigrating layer data.' );
2657:
2658: ROLLBACK;
2659: