DBA Data[Home] [Help]

APPS.CSTPOYLD dependencies on FND_FILE

Line 175: FND_FILE.put_line(fnd_file.log, 'PROCESS_OP_YIELD <<< ');

171: x_program_id := fnd_global.conc_program_id;
172: x_sysdate := SYSDATE;
173:
174: IF(l_debug = 'Y') THEN
175: FND_FILE.put_line(fnd_file.log, 'PROCESS_OP_YIELD <<< ');
176: FND_FILE.put_line(FND_FILE.LOG,'P_ENTITY_ID : '||to_char(i_entity_id));
177: FND_FILE.put_line(FND_FILE.LOG,'P_ORGANIZATION_ID: '|| to_char(i_organization_id));
178: END IF;
179:

Line 176: FND_FILE.put_line(FND_FILE.LOG,'P_ENTITY_ID : '||to_char(i_entity_id));

172: x_sysdate := SYSDATE;
173:
174: IF(l_debug = 'Y') THEN
175: FND_FILE.put_line(fnd_file.log, 'PROCESS_OP_YIELD <<< ');
176: FND_FILE.put_line(FND_FILE.LOG,'P_ENTITY_ID : '||to_char(i_entity_id));
177: FND_FILE.put_line(FND_FILE.LOG,'P_ORGANIZATION_ID: '|| to_char(i_organization_id));
178: END IF;
179:
180: ---------------------------------------------------------

Line 177: FND_FILE.put_line(FND_FILE.LOG,'P_ORGANIZATION_ID: '|| to_char(i_organization_id));

173:
174: IF(l_debug = 'Y') THEN
175: FND_FILE.put_line(fnd_file.log, 'PROCESS_OP_YIELD <<< ');
176: FND_FILE.put_line(FND_FILE.LOG,'P_ENTITY_ID : '||to_char(i_entity_id));
177: FND_FILE.put_line(FND_FILE.LOG,'P_ORGANIZATION_ID: '|| to_char(i_organization_id));
178: END IF;
179:
180: ---------------------------------------------------------
181: -- Open wip_entity_id Cursor --

Line 187: FND_FILE.put_line(FND_FILE.LOG, 'REC_WIP_ENTITY.WIP_ENTITY_ID: '|| to_char(rec_wip_entity.wip_entity_id));

183: <>
184:
185: FOR rec_wip_entity IN c_wip_entity LOOP
186: IF(l_debug = 'Y') THEN
187: FND_FILE.put_line(FND_FILE.LOG, 'REC_WIP_ENTITY.WIP_ENTITY_ID: '|| to_char(rec_wip_entity.wip_entity_id));
188: END IF;
189:
190: /* Initialize Absorptions */
191: x_tl_scrap_in := 0;

Line 205: fnd_file.put_line(fnd_file.log, 'WIP ENTITY ID : '||to_char(rec_wip_entity.wip_entity_id));

201:
202: /* Do Operation Yield Accounting only if ESA is enabled */
203: IF x_est_scrap_acct_flag = 1 THEN
204: if (l_debug = 'Y') then
205: fnd_file.put_line(fnd_file.log, 'WIP ENTITY ID : '||to_char(rec_wip_entity.wip_entity_id));
206: fnd_file.put_line(fnd_file.log, 'ORG ID : '||to_char(rec_wip_entity.organization_id));
207: end if;
208:
209: ---------------------------------------------------------

Line 206: fnd_file.put_line(fnd_file.log, 'ORG ID : '||to_char(rec_wip_entity.organization_id));

202: /* Do Operation Yield Accounting only if ESA is enabled */
203: IF x_est_scrap_acct_flag = 1 THEN
204: if (l_debug = 'Y') then
205: fnd_file.put_line(fnd_file.log, 'WIP ENTITY ID : '||to_char(rec_wip_entity.wip_entity_id));
206: fnd_file.put_line(fnd_file.log, 'ORG ID : '||to_char(rec_wip_entity.organization_id));
207: end if;
208:
209: ---------------------------------------------------------
210: -- Get Currency Information --

Line 250: fnd_file.put_line(fnd_file.log,'Accounting period is not open for the organization: ' || to_char(x_organization_id));

246: WHERE organization_id = x_organization_id
247: AND l_legal_entity_date BETWEEN period_start_date AND schedule_close_date;
248: EXCEPTION
249: when NO_DATA_FOUND then
250: fnd_file.put_line(fnd_file.log,'Accounting period is not open for the organization: ' || to_char(x_organization_id));
251: END;
252:
253: if (l_debug = 'Y') then
254: fnd_file.put_line(fnd_file.log, 'ACCT PERIOD ID : '||to_char( x_acct_period_id ));

Line 254: fnd_file.put_line(fnd_file.log, 'ACCT PERIOD ID : '||to_char( x_acct_period_id ));

250: fnd_file.put_line(fnd_file.log,'Accounting period is not open for the organization: ' || to_char(x_organization_id));
251: END;
252:
253: if (l_debug = 'Y') then
254: fnd_file.put_line(fnd_file.log, 'ACCT PERIOD ID : '||to_char( x_acct_period_id ));
255: end if;
256:
257: END IF; /* (x_organization_id <> rec_wip_entity.organization_id) */
258:

Line 328: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_ACCOUNT : '||to_char(REC_WIP_ENTITY.EST_SCRAP_ACCOUNT ));

324: l_scrap_rev_acct := l_scrap_acct;
325: end if;
326:
327: if (l_debug = 'Y') then
328: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_ACCOUNT : '||to_char(REC_WIP_ENTITY.EST_SCRAP_ACCOUNT ));
329: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_VAR_ACCOUNT : '||to_char(REC_WIP_ENTITY.EST_SCRAP_VAR_ACCOUNT ));
330: fnd_file.put_line(fnd_file.log, 'OPERATION_SEQ_NUM : '||to_char(REC_OPSEQ.OPERATION_SEQ_NUM ));
331: fnd_file.put_line(fnd_file.log, 'OPERATION_COST : '||to_char(REC_OPSEQ.OPERATION_COST ));
332: fnd_file.put_line(fnd_file.log, 'OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.OPERATION_UNIT_COST ));

Line 329: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_VAR_ACCOUNT : '||to_char(REC_WIP_ENTITY.EST_SCRAP_VAR_ACCOUNT ));

325: end if;
326:
327: if (l_debug = 'Y') then
328: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_ACCOUNT : '||to_char(REC_WIP_ENTITY.EST_SCRAP_ACCOUNT ));
329: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_VAR_ACCOUNT : '||to_char(REC_WIP_ENTITY.EST_SCRAP_VAR_ACCOUNT ));
330: fnd_file.put_line(fnd_file.log, 'OPERATION_SEQ_NUM : '||to_char(REC_OPSEQ.OPERATION_SEQ_NUM ));
331: fnd_file.put_line(fnd_file.log, 'OPERATION_COST : '||to_char(REC_OPSEQ.OPERATION_COST ));
332: fnd_file.put_line(fnd_file.log, 'OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.OPERATION_UNIT_COST ));
333: fnd_file.put_line(fnd_file.log, 'CUM_OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.CUM_OPERATION_UNIT_COST ));

Line 330: fnd_file.put_line(fnd_file.log, 'OPERATION_SEQ_NUM : '||to_char(REC_OPSEQ.OPERATION_SEQ_NUM ));

326:
327: if (l_debug = 'Y') then
328: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_ACCOUNT : '||to_char(REC_WIP_ENTITY.EST_SCRAP_ACCOUNT ));
329: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_VAR_ACCOUNT : '||to_char(REC_WIP_ENTITY.EST_SCRAP_VAR_ACCOUNT ));
330: fnd_file.put_line(fnd_file.log, 'OPERATION_SEQ_NUM : '||to_char(REC_OPSEQ.OPERATION_SEQ_NUM ));
331: fnd_file.put_line(fnd_file.log, 'OPERATION_COST : '||to_char(REC_OPSEQ.OPERATION_COST ));
332: fnd_file.put_line(fnd_file.log, 'OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.OPERATION_UNIT_COST ));
333: fnd_file.put_line(fnd_file.log, 'CUM_OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.CUM_OPERATION_UNIT_COST ));
334: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_UNIT_COST : '||to_char(REC_OPSEQ.EST_SCRAP_UNIT_COST ));

Line 331: fnd_file.put_line(fnd_file.log, 'OPERATION_COST : '||to_char(REC_OPSEQ.OPERATION_COST ));

327: if (l_debug = 'Y') then
328: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_ACCOUNT : '||to_char(REC_WIP_ENTITY.EST_SCRAP_ACCOUNT ));
329: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_VAR_ACCOUNT : '||to_char(REC_WIP_ENTITY.EST_SCRAP_VAR_ACCOUNT ));
330: fnd_file.put_line(fnd_file.log, 'OPERATION_SEQ_NUM : '||to_char(REC_OPSEQ.OPERATION_SEQ_NUM ));
331: fnd_file.put_line(fnd_file.log, 'OPERATION_COST : '||to_char(REC_OPSEQ.OPERATION_COST ));
332: fnd_file.put_line(fnd_file.log, 'OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.OPERATION_UNIT_COST ));
333: fnd_file.put_line(fnd_file.log, 'CUM_OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.CUM_OPERATION_UNIT_COST ));
334: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_UNIT_COST : '||to_char(REC_OPSEQ.EST_SCRAP_UNIT_COST ));
335: fnd_file.put_line(fnd_file.log, 'CUM_EST_PRIOR_UNIT_COST : '||to_char(REC_OPSEQ.CUM_EST_PRIOR_UNIT_COST ));

Line 332: fnd_file.put_line(fnd_file.log, 'OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.OPERATION_UNIT_COST ));

328: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_ACCOUNT : '||to_char(REC_WIP_ENTITY.EST_SCRAP_ACCOUNT ));
329: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_VAR_ACCOUNT : '||to_char(REC_WIP_ENTITY.EST_SCRAP_VAR_ACCOUNT ));
330: fnd_file.put_line(fnd_file.log, 'OPERATION_SEQ_NUM : '||to_char(REC_OPSEQ.OPERATION_SEQ_NUM ));
331: fnd_file.put_line(fnd_file.log, 'OPERATION_COST : '||to_char(REC_OPSEQ.OPERATION_COST ));
332: fnd_file.put_line(fnd_file.log, 'OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.OPERATION_UNIT_COST ));
333: fnd_file.put_line(fnd_file.log, 'CUM_OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.CUM_OPERATION_UNIT_COST ));
334: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_UNIT_COST : '||to_char(REC_OPSEQ.EST_SCRAP_UNIT_COST ));
335: fnd_file.put_line(fnd_file.log, 'CUM_EST_PRIOR_UNIT_COST : '||to_char(REC_OPSEQ.CUM_EST_PRIOR_UNIT_COST ));
336: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_COMPLETED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_COMPLETED ));

Line 333: fnd_file.put_line(fnd_file.log, 'CUM_OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.CUM_OPERATION_UNIT_COST ));

329: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_VAR_ACCOUNT : '||to_char(REC_WIP_ENTITY.EST_SCRAP_VAR_ACCOUNT ));
330: fnd_file.put_line(fnd_file.log, 'OPERATION_SEQ_NUM : '||to_char(REC_OPSEQ.OPERATION_SEQ_NUM ));
331: fnd_file.put_line(fnd_file.log, 'OPERATION_COST : '||to_char(REC_OPSEQ.OPERATION_COST ));
332: fnd_file.put_line(fnd_file.log, 'OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.OPERATION_UNIT_COST ));
333: fnd_file.put_line(fnd_file.log, 'CUM_OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.CUM_OPERATION_UNIT_COST ));
334: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_UNIT_COST : '||to_char(REC_OPSEQ.EST_SCRAP_UNIT_COST ));
335: fnd_file.put_line(fnd_file.log, 'CUM_EST_PRIOR_UNIT_COST : '||to_char(REC_OPSEQ.CUM_EST_PRIOR_UNIT_COST ));
336: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_COMPLETED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_COMPLETED ));
337: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_SCRAPED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_SCRAPED ));

Line 334: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_UNIT_COST : '||to_char(REC_OPSEQ.EST_SCRAP_UNIT_COST ));

330: fnd_file.put_line(fnd_file.log, 'OPERATION_SEQ_NUM : '||to_char(REC_OPSEQ.OPERATION_SEQ_NUM ));
331: fnd_file.put_line(fnd_file.log, 'OPERATION_COST : '||to_char(REC_OPSEQ.OPERATION_COST ));
332: fnd_file.put_line(fnd_file.log, 'OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.OPERATION_UNIT_COST ));
333: fnd_file.put_line(fnd_file.log, 'CUM_OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.CUM_OPERATION_UNIT_COST ));
334: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_UNIT_COST : '||to_char(REC_OPSEQ.EST_SCRAP_UNIT_COST ));
335: fnd_file.put_line(fnd_file.log, 'CUM_EST_PRIOR_UNIT_COST : '||to_char(REC_OPSEQ.CUM_EST_PRIOR_UNIT_COST ));
336: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_COMPLETED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_COMPLETED ));
337: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_SCRAPED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_SCRAPED ));
338: fnd_file.put_line(fnd_file.log, 'SCRAP_ACCOUNT : '||to_char(l_scrap_acct ));

Line 335: fnd_file.put_line(fnd_file.log, 'CUM_EST_PRIOR_UNIT_COST : '||to_char(REC_OPSEQ.CUM_EST_PRIOR_UNIT_COST ));

331: fnd_file.put_line(fnd_file.log, 'OPERATION_COST : '||to_char(REC_OPSEQ.OPERATION_COST ));
332: fnd_file.put_line(fnd_file.log, 'OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.OPERATION_UNIT_COST ));
333: fnd_file.put_line(fnd_file.log, 'CUM_OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.CUM_OPERATION_UNIT_COST ));
334: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_UNIT_COST : '||to_char(REC_OPSEQ.EST_SCRAP_UNIT_COST ));
335: fnd_file.put_line(fnd_file.log, 'CUM_EST_PRIOR_UNIT_COST : '||to_char(REC_OPSEQ.CUM_EST_PRIOR_UNIT_COST ));
336: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_COMPLETED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_COMPLETED ));
337: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_SCRAPED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_SCRAPED ));
338: fnd_file.put_line(fnd_file.log, 'SCRAP_ACCOUNT : '||to_char(l_scrap_acct ));
339: fnd_file.put_line(fnd_file.log, 'NET_REV_ACCT : '||to_char(l_scrap_rev_acct ));

Line 336: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_COMPLETED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_COMPLETED ));

332: fnd_file.put_line(fnd_file.log, 'OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.OPERATION_UNIT_COST ));
333: fnd_file.put_line(fnd_file.log, 'CUM_OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.CUM_OPERATION_UNIT_COST ));
334: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_UNIT_COST : '||to_char(REC_OPSEQ.EST_SCRAP_UNIT_COST ));
335: fnd_file.put_line(fnd_file.log, 'CUM_EST_PRIOR_UNIT_COST : '||to_char(REC_OPSEQ.CUM_EST_PRIOR_UNIT_COST ));
336: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_COMPLETED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_COMPLETED ));
337: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_SCRAPED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_SCRAPED ));
338: fnd_file.put_line(fnd_file.log, 'SCRAP_ACCOUNT : '||to_char(l_scrap_acct ));
339: fnd_file.put_line(fnd_file.log, 'NET_REV_ACCT : '||to_char(l_scrap_rev_acct ));
340:

Line 337: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_SCRAPED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_SCRAPED ));

333: fnd_file.put_line(fnd_file.log, 'CUM_OPERATION_UNIT_COST : '||to_char(REC_OPSEQ.CUM_OPERATION_UNIT_COST ));
334: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_UNIT_COST : '||to_char(REC_OPSEQ.EST_SCRAP_UNIT_COST ));
335: fnd_file.put_line(fnd_file.log, 'CUM_EST_PRIOR_UNIT_COST : '||to_char(REC_OPSEQ.CUM_EST_PRIOR_UNIT_COST ));
336: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_COMPLETED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_COMPLETED ));
337: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_SCRAPED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_SCRAPED ));
338: fnd_file.put_line(fnd_file.log, 'SCRAP_ACCOUNT : '||to_char(l_scrap_acct ));
339: fnd_file.put_line(fnd_file.log, 'NET_REV_ACCT : '||to_char(l_scrap_rev_acct ));
340:
341: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_ABSORB_ACCOUNT : '||to_char(l_est_scrap_abs_acct ));

Line 338: fnd_file.put_line(fnd_file.log, 'SCRAP_ACCOUNT : '||to_char(l_scrap_acct ));

334: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_UNIT_COST : '||to_char(REC_OPSEQ.EST_SCRAP_UNIT_COST ));
335: fnd_file.put_line(fnd_file.log, 'CUM_EST_PRIOR_UNIT_COST : '||to_char(REC_OPSEQ.CUM_EST_PRIOR_UNIT_COST ));
336: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_COMPLETED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_COMPLETED ));
337: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_SCRAPED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_SCRAPED ));
338: fnd_file.put_line(fnd_file.log, 'SCRAP_ACCOUNT : '||to_char(l_scrap_acct ));
339: fnd_file.put_line(fnd_file.log, 'NET_REV_ACCT : '||to_char(l_scrap_rev_acct ));
340:
341: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_ABSORB_ACCOUNT : '||to_char(l_est_scrap_abs_acct ));
342: fnd_file.put_line(fnd_file.log, 'STATUS : '||to_char(REC_OPSEQ.STATUS ));

Line 339: fnd_file.put_line(fnd_file.log, 'NET_REV_ACCT : '||to_char(l_scrap_rev_acct ));

335: fnd_file.put_line(fnd_file.log, 'CUM_EST_PRIOR_UNIT_COST : '||to_char(REC_OPSEQ.CUM_EST_PRIOR_UNIT_COST ));
336: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_COMPLETED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_COMPLETED ));
337: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_SCRAPED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_SCRAPED ));
338: fnd_file.put_line(fnd_file.log, 'SCRAP_ACCOUNT : '||to_char(l_scrap_acct ));
339: fnd_file.put_line(fnd_file.log, 'NET_REV_ACCT : '||to_char(l_scrap_rev_acct ));
340:
341: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_ABSORB_ACCOUNT : '||to_char(l_est_scrap_abs_acct ));
342: fnd_file.put_line(fnd_file.log, 'STATUS : '||to_char(REC_OPSEQ.STATUS ));
343: fnd_file.put_line(fnd_file.log, 'QUANTITY_COMPLETED : '||to_char(REC_OPSEQ.QUANTITY_COMPLETED ));

Line 341: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_ABSORB_ACCOUNT : '||to_char(l_est_scrap_abs_acct ));

337: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_QTY_SCRAPED : '||to_char(REC_OPSEQ.EST_SCRAP_QTY_SCRAPED ));
338: fnd_file.put_line(fnd_file.log, 'SCRAP_ACCOUNT : '||to_char(l_scrap_acct ));
339: fnd_file.put_line(fnd_file.log, 'NET_REV_ACCT : '||to_char(l_scrap_rev_acct ));
340:
341: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_ABSORB_ACCOUNT : '||to_char(l_est_scrap_abs_acct ));
342: fnd_file.put_line(fnd_file.log, 'STATUS : '||to_char(REC_OPSEQ.STATUS ));
343: fnd_file.put_line(fnd_file.log, 'QUANTITY_COMPLETED : '||to_char(REC_OPSEQ.QUANTITY_COMPLETED ));
344: fnd_file.put_line(fnd_file.log, 'QUANTITY_SCRAPPED : '||to_char(REC_OPSEQ.QUANTITY_SCRAPPED ));
345: fnd_file.put_line(fnd_file.log, 'OPERATION_YIELD : '||to_char(REC_OPSEQ.OPERATION_YIELD ));

Line 342: fnd_file.put_line(fnd_file.log, 'STATUS : '||to_char(REC_OPSEQ.STATUS ));

338: fnd_file.put_line(fnd_file.log, 'SCRAP_ACCOUNT : '||to_char(l_scrap_acct ));
339: fnd_file.put_line(fnd_file.log, 'NET_REV_ACCT : '||to_char(l_scrap_rev_acct ));
340:
341: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_ABSORB_ACCOUNT : '||to_char(l_est_scrap_abs_acct ));
342: fnd_file.put_line(fnd_file.log, 'STATUS : '||to_char(REC_OPSEQ.STATUS ));
343: fnd_file.put_line(fnd_file.log, 'QUANTITY_COMPLETED : '||to_char(REC_OPSEQ.QUANTITY_COMPLETED ));
344: fnd_file.put_line(fnd_file.log, 'QUANTITY_SCRAPPED : '||to_char(REC_OPSEQ.QUANTITY_SCRAPPED ));
345: fnd_file.put_line(fnd_file.log, 'OPERATION_YIELD : '||to_char(REC_OPSEQ.OPERATION_YIELD ));
346: fnd_file.put_line(fnd_file.log, 'DEPARTMENT_ID : '||to_char(REC_OPSEQ.DEPARTMENT_ID ));

Line 343: fnd_file.put_line(fnd_file.log, 'QUANTITY_COMPLETED : '||to_char(REC_OPSEQ.QUANTITY_COMPLETED ));

339: fnd_file.put_line(fnd_file.log, 'NET_REV_ACCT : '||to_char(l_scrap_rev_acct ));
340:
341: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_ABSORB_ACCOUNT : '||to_char(l_est_scrap_abs_acct ));
342: fnd_file.put_line(fnd_file.log, 'STATUS : '||to_char(REC_OPSEQ.STATUS ));
343: fnd_file.put_line(fnd_file.log, 'QUANTITY_COMPLETED : '||to_char(REC_OPSEQ.QUANTITY_COMPLETED ));
344: fnd_file.put_line(fnd_file.log, 'QUANTITY_SCRAPPED : '||to_char(REC_OPSEQ.QUANTITY_SCRAPPED ));
345: fnd_file.put_line(fnd_file.log, 'OPERATION_YIELD : '||to_char(REC_OPSEQ.OPERATION_YIELD ));
346: fnd_file.put_line(fnd_file.log, 'DEPARTMENT_ID : '||to_char(REC_OPSEQ.DEPARTMENT_ID ));
347: end if;

Line 344: fnd_file.put_line(fnd_file.log, 'QUANTITY_SCRAPPED : '||to_char(REC_OPSEQ.QUANTITY_SCRAPPED ));

340:
341: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_ABSORB_ACCOUNT : '||to_char(l_est_scrap_abs_acct ));
342: fnd_file.put_line(fnd_file.log, 'STATUS : '||to_char(REC_OPSEQ.STATUS ));
343: fnd_file.put_line(fnd_file.log, 'QUANTITY_COMPLETED : '||to_char(REC_OPSEQ.QUANTITY_COMPLETED ));
344: fnd_file.put_line(fnd_file.log, 'QUANTITY_SCRAPPED : '||to_char(REC_OPSEQ.QUANTITY_SCRAPPED ));
345: fnd_file.put_line(fnd_file.log, 'OPERATION_YIELD : '||to_char(REC_OPSEQ.OPERATION_YIELD ));
346: fnd_file.put_line(fnd_file.log, 'DEPARTMENT_ID : '||to_char(REC_OPSEQ.DEPARTMENT_ID ));
347: end if;
348: ---------------------------------------------------------

Line 345: fnd_file.put_line(fnd_file.log, 'OPERATION_YIELD : '||to_char(REC_OPSEQ.OPERATION_YIELD ));

341: fnd_file.put_line(fnd_file.log, 'EST_SCRAP_ABSORB_ACCOUNT : '||to_char(l_est_scrap_abs_acct ));
342: fnd_file.put_line(fnd_file.log, 'STATUS : '||to_char(REC_OPSEQ.STATUS ));
343: fnd_file.put_line(fnd_file.log, 'QUANTITY_COMPLETED : '||to_char(REC_OPSEQ.QUANTITY_COMPLETED ));
344: fnd_file.put_line(fnd_file.log, 'QUANTITY_SCRAPPED : '||to_char(REC_OPSEQ.QUANTITY_SCRAPPED ));
345: fnd_file.put_line(fnd_file.log, 'OPERATION_YIELD : '||to_char(REC_OPSEQ.OPERATION_YIELD ));
346: fnd_file.put_line(fnd_file.log, 'DEPARTMENT_ID : '||to_char(REC_OPSEQ.DEPARTMENT_ID ));
347: end if;
348: ---------------------------------------------------------
349: -- Initialize Parameters if first operation of job --

Line 346: fnd_file.put_line(fnd_file.log, 'DEPARTMENT_ID : '||to_char(REC_OPSEQ.DEPARTMENT_ID ));

342: fnd_file.put_line(fnd_file.log, 'STATUS : '||to_char(REC_OPSEQ.STATUS ));
343: fnd_file.put_line(fnd_file.log, 'QUANTITY_COMPLETED : '||to_char(REC_OPSEQ.QUANTITY_COMPLETED ));
344: fnd_file.put_line(fnd_file.log, 'QUANTITY_SCRAPPED : '||to_char(REC_OPSEQ.QUANTITY_SCRAPPED ));
345: fnd_file.put_line(fnd_file.log, 'OPERATION_YIELD : '||to_char(REC_OPSEQ.OPERATION_YIELD ));
346: fnd_file.put_line(fnd_file.log, 'DEPARTMENT_ID : '||to_char(REC_OPSEQ.DEPARTMENT_ID ));
347: end if;
348: ---------------------------------------------------------
349: -- Initialize Parameters if first operation of job --
350: ---------------------------------------------------------

Line 436: fnd_file.put_line(fnd_file.log,'Disable_date : '||rec_opseq.disable_date);

432: ---------------------------------------------------------
433: -- Calculate Net Absorption --
434: ---------------------------------------------------------
435: if (l_debug = 'Y') then
436: fnd_file.put_line(fnd_file.log,'Disable_date : '||rec_opseq.disable_date);
437: fnd_file.put_line(fnd_file.log,'Cumulative Est Prior Scrap: '||x_cum_pr_est_scp_per_unit);
438: end if;
439:
440: IF (rec_opseq.quantity_completed <> 0 and rec_opseq.disable_date IS NULL) THEN

Line 437: fnd_file.put_line(fnd_file.log,'Cumulative Est Prior Scrap: '||x_cum_pr_est_scp_per_unit);

433: -- Calculate Net Absorption --
434: ---------------------------------------------------------
435: if (l_debug = 'Y') then
436: fnd_file.put_line(fnd_file.log,'Disable_date : '||rec_opseq.disable_date);
437: fnd_file.put_line(fnd_file.log,'Cumulative Est Prior Scrap: '||x_cum_pr_est_scp_per_unit);
438: end if;
439:
440: IF (rec_opseq.quantity_completed <> 0 and rec_opseq.disable_date IS NULL) THEN
441: x_op_unit_cost := rec_opseq.operation_cost / rec_opseq.quantity_completed ;

Line 470: fnd_file.put_line(fnd_file.log,'Est scrap per unit cost : ' || to_char(x_est_scrap_per_unit));

466: end if;
467: end if; /* x_wsm_enabled_flag = 'Y' */
468:
469: if (l_debug = 'Y') then
470: fnd_file.put_line(fnd_file.log,'Est scrap per unit cost : ' || to_char(x_est_scrap_per_unit));
471: end if;
472:
473: x_unit_cost := x_unit_cost + x_est_scrap_per_unit;
474:

Line 487: fnd_file.put_line(fnd_file.log,'x_net_absorption : ' || to_char(x_net_absorption));

483:
484: END If; /* i_run_option = 2 */
485:
486: if (l_debug = 'Y') then
487: fnd_file.put_line(fnd_file.log,'x_net_absorption : ' || to_char(x_net_absorption));
488: end if;
489:
490: ---------------------------------------------------------
491: -- Perform Accounting for Net Absorption: --

Line 522: fnd_file.put_line(fnd_file.log,'Inserting into WT transaction : '||to_char(x_transaction_id));

518: INTO x_transaction_id
519: FROM dual;
520:
521: if (l_debug = 'Y') then
522: fnd_file.put_line(fnd_file.log,'Inserting into WT transaction : '||to_char(x_transaction_id));
523: end if;
524:
525: l_transaction_date := sysdate; /* Bug 4757384 */
526:

Line 570: fnd_file.put_line(fnd_file.log,'Inserting into WTA transaction : '||to_char(x_transaction_id));

566: -- Debit EST_SCRAP_ACCOUNT --
567: ---------------------------------------------------------
568:
569: if (l_debug = 'Y') then
570: fnd_file.put_line(fnd_file.log,'Inserting into WTA transaction : '||to_char(x_transaction_id));
571: end if;
572:
573: x_statement := 70;
574:

Line 681: FND_FILE.put_line(FND_FILE.log, 'Event Creation Failed: '||l_msg_data );

677: x_msg_data => l_msg_data,
678: p_trx_info => l_trx_info);
679:
680: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
681: FND_FILE.put_line(FND_FILE.log, 'Event Creation Failed: '||l_msg_data );
682: RAISE FND_API.g_exc_unexpected_error;
683: END IF;
684:
685: END IF; /* x_net_absorption <> 0 */

Line 703: fnd_file.put_line(fnd_file.log,'x_net_reversal : '||to_char(x_net_reversal));

699: rec_opseq.cum_est_prior_unit_cost * rec_opseq.est_scrap_qty_scraped;
700: END If;
701:
702: if (l_debug = 'Y') then
703: fnd_file.put_line(fnd_file.log,'x_net_reversal : '||to_char(x_net_reversal));
704: end if;
705:
706: ---------------------------------------------------------
707: -- Perform Accounting for Net Reversal: --

Line 738: fnd_file.put_line(fnd_file.log,'Inserting into MMT transaction : '||to_char(x_transaction_id));

734: AND msi.primary_unit_of_measure = muom.unit_of_measure;
735:
736:
737: if (l_debug = 'Y') then
738: fnd_file.put_line(fnd_file.log,'Inserting into MMT transaction : '||to_char(x_transaction_id));
739: end if;
740:
741: l_transaction_date := sysdate; /* Bug 4757384 */
742:

Line 922: FND_FILE.put_line(FND_FILE.log, 'Event creation failed: CSTPOYLD.process_op_yield('||x_statement||')');

918: x_msg_data => l_msg_data,
919: p_trx_info => l_inv_trx_info
920: );
921: IF l_return_status <> 'S' THEN
922: FND_FILE.put_line(FND_FILE.log, 'Event creation failed: CSTPOYLD.process_op_yield('||x_statement||')');
923: RAISE FND_API.g_exc_unexpected_error;
924: END IF;
925:
926: END IF; /* x_net_reversal <> 0 */

Line 929: fnd_file.put_line(fnd_file.log,'Updating WOY ');

925:
926: END IF; /* x_net_reversal <> 0 */
927:
928: if (l_debug = 'Y') then
929: fnd_file.put_line(fnd_file.log,'Updating WOY ');
930: end if;
931:
932:
933: ---------------------------------------------------------

Line 987: fnd_file.put_line(FND_FILE.LOG,'BOM department does not have scrap account '||

983: WHERE organization_id = x_organization_id
984: AND wip_entity_id = rec_wip_entity.wip_entity_id
985: AND operation_seq_num = rec_opseq.operation_seq_num;
986:
987: fnd_file.put_line(FND_FILE.LOG,'BOM department does not have scrap account '||
988: 'or estimated scrap absortion account defined');
989: fnd_message.set_name('BOM', 'CST_OP_YLD_NOT_PROCESSED');
990: fnd_message.set_token('ENTITY_ID', to_char(rec_wip_entity.wip_entity_id));
991: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 991: fnd_file.put_line(fnd_file.log, fnd_message.get);

987: fnd_file.put_line(FND_FILE.LOG,'BOM department does not have scrap account '||
988: 'or estimated scrap absortion account defined');
989: fnd_message.set_name('BOM', 'CST_OP_YLD_NOT_PROCESSED');
990: fnd_message.set_token('ENTITY_ID', to_char(rec_wip_entity.wip_entity_id));
991: fnd_file.put_line(fnd_file.log, fnd_message.get);
992:
993: fnd_message.set_name('BOM', 'CST_OP_YLD_GENERAL_ERROR');
994: fnd_message.set_token('NUMBER', to_char(x_statement));
995: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 995: fnd_file.put_line(fnd_file.log, fnd_message.get);

991: fnd_file.put_line(fnd_file.log, fnd_message.get);
992:
993: fnd_message.set_name('BOM', 'CST_OP_YLD_GENERAL_ERROR');
994: fnd_message.set_token('NUMBER', to_char(x_statement));
995: fnd_file.put_line(fnd_file.log, fnd_message.get);
996:
997:
998: x_err_num := SQLCODE;
999: x_err_msg := substr(SQLERRM, 1, 200);

Line 1001: fnd_file.put_line(fnd_file.log, 'x_err_num' || ' : ' || x_err_msg);

997:
998: x_err_num := SQLCODE;
999: x_err_msg := substr(SQLERRM, 1, 200);
1000: ERRBUF := x_err_msg;
1001: fnd_file.put_line(fnd_file.log, 'x_err_num' || ' : ' || x_err_msg);
1002: x_status := fnd_concurrent.set_completion_status( status => 'WARNING',
1003: message => '');
1004:
1005: EXIT opseq;

Line 1027: fnd_file.put_line(fnd_file.log, fnd_message.get);

1023:
1024:
1025: fnd_message.set_name('BOM', 'CST_OP_YLD_NOT_PROCESSED');
1026: fnd_message.set_token('ENTITY_ID', to_char(rec_wip_entity.wip_entity_id));
1027: fnd_file.put_line(fnd_file.log, fnd_message.get);
1028:
1029: fnd_message.set_name('BOM', 'CST_OP_YLD_GENERAL_ERROR');
1030: fnd_message.set_token('NUMBER', to_char(x_statement));
1031: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1031: fnd_file.put_line(fnd_file.log, fnd_message.get);

1027: fnd_file.put_line(fnd_file.log, fnd_message.get);
1028:
1029: fnd_message.set_name('BOM', 'CST_OP_YLD_GENERAL_ERROR');
1030: fnd_message.set_token('NUMBER', to_char(x_statement));
1031: fnd_file.put_line(fnd_file.log, fnd_message.get);
1032:
1033:
1034: x_err_num := SQLCODE;
1035: x_err_msg := substr(SQLERRM, 1, 200);

Line 1037: fnd_file.put_line(fnd_file.log, 'x_err_num' || ' : ' || x_err_msg);

1033:
1034: x_err_num := SQLCODE;
1035: x_err_msg := substr(SQLERRM, 1, 200);
1036: ERRBUF := x_err_msg;
1037: fnd_file.put_line(fnd_file.log, 'x_err_num' || ' : ' || x_err_msg);
1038: x_status := fnd_concurrent.set_completion_status( status => 'WARNING',
1039: message => '');
1040:
1041: EXIT opseq;

Line 1076: fnd_file.put_line(fnd_file.log, 'PROCESS_OP_YIELD >>>');

1072: END IF; /* If ESA is enabled */
1073:
1074: END LOOP wip_entity;
1075: IF(l_debug = 'Y') THEN
1076: fnd_file.put_line(fnd_file.log, 'PROCESS_OP_YIELD >>>');
1077: END IF;
1078:
1079: EXCEPTION
1080: WHEN WSM_ESA_PKG_ERROR THEN

Line 1081: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in WSM_ESA_ENABLED : '||

1077: END IF;
1078:
1079: EXCEPTION
1080: WHEN WSM_ESA_PKG_ERROR THEN
1081: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in WSM_ESA_ENABLED : '||
1082: ' wip_entity_id '|| to_char(temp_wip_entity_id) ||
1083: x_err_num ||' : '|| x_err_msg);
1084: ERRBUF := 'CSTPOYLD.process_op_yield:' || x_statement || ':' ||
1085: substr(x_err_msg,1,200);

Line 1090: fnd_file.put_line(fnd_file.log, fnd_message.get);

1086: RAISE_APPLICATION_ERROR( -20001, x_err_msg);
1087: WHEN OTHERS THEN
1088: fnd_message.set_name('BOM', 'CST_OP_YLD_GENERAL_ERROR');
1089: fnd_message.set_token('NUMBER', 'x_statement');
1090: fnd_file.put_line(fnd_file.log, fnd_message.get);
1091: x_err_num := SQLCODE;
1092: x_err_msg := 'CSTPOYLD.process_op_yield:' || x_statement || ':' ||
1093: substr(SQLERRM, 1, 200);
1094: fnd_file.put_line(fnd_file.log,x_err_msg);

Line 1094: fnd_file.put_line(fnd_file.log,x_err_msg);

1090: fnd_file.put_line(fnd_file.log, fnd_message.get);
1091: x_err_num := SQLCODE;
1092: x_err_msg := 'CSTPOYLD.process_op_yield:' || x_statement || ':' ||
1093: substr(SQLERRM, 1, 200);
1094: fnd_file.put_line(fnd_file.log,x_err_msg);
1095: ERRBUF := x_err_msg;
1096: RAISE_APPLICATION_ERROR( -20001, x_err_msg);
1097:
1098: END process_op_yield;

Line 1194: FND_FILE.put_line(FND_FILE.log,'transact_op:x_est_scrap_acct_flag : '|| to_char(x_est_scrap_acct_flag));

1190: IF (x_est_scrap_acct_flag = 0) THEN
1191: RAISE WSM_ESA_PKG_ERROR;
1192: END IF;
1193: IF (l_debug = 'Y') THEN
1194: FND_FILE.put_line(FND_FILE.log,'transact_op:x_est_scrap_acct_flag : '|| to_char(x_est_scrap_acct_flag));
1195: END IF;
1196:
1197: /* Do Operation Yield Accounting only if ESA is enabled */
1198: IF x_est_scrap_acct_flag = 1 THEN

Line 1471: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in WSM_ESA_ENABLED : '||

1467: return 1;
1468:
1469: EXCEPTION
1470: WHEN WSM_ESA_PKG_ERROR THEN
1471: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in WSM_ESA_ENABLED : '||
1472: x_err_num ||' : '|| x_err_msg);
1473: o_err_num := x_err_num;
1474: o_err_msg := 'CSTPOYLD.transact_op_yield_var:' || substr(x_err_msg,1,150);
1475: return 0;

Line 1624: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PROCESS_SM_OP_YIELD <<< ');

1620:
1621: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
1622:
1623: IF(l_debug = 'Y') THEN
1624: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PROCESS_SM_OP_YIELD <<< ');
1625: END IF;
1626:
1627:
1628: ---------------------------------------------------------

Line 1648: fnd_file.put_line(fnd_file.log,'WIP_ENTITY_ID : ' || to_char(rec_wip_entity.wip_entity_id));

1644: x_op_seq_num := rec_wip_entity.op_seq_num;
1645:
1646: <>
1647: if (l_debug = 'Y') then
1648: fnd_file.put_line(fnd_file.log,'WIP_ENTITY_ID : ' || to_char(rec_wip_entity.wip_entity_id));
1649: fnd_file.put_line(fnd_file.log,'X_OP_SEQ_NUM: ' || to_char(x_op_seq_num));
1650: end if;
1651:
1652: FOR rec_opseq IN c_operation (rec_wip_entity.wip_entity_id,

Line 1649: fnd_file.put_line(fnd_file.log,'X_OP_SEQ_NUM: ' || to_char(x_op_seq_num));

1645:
1646: <>
1647: if (l_debug = 'Y') then
1648: fnd_file.put_line(fnd_file.log,'WIP_ENTITY_ID : ' || to_char(rec_wip_entity.wip_entity_id));
1649: fnd_file.put_line(fnd_file.log,'X_OP_SEQ_NUM: ' || to_char(x_op_seq_num));
1650: end if;
1651:
1652: FOR rec_opseq IN c_operation (rec_wip_entity.wip_entity_id,
1653: x_op_seq_num,

Line 1657: fnd_file.put_line(fnd_file.log,'OP_SEQ: ' || to_char(rec_opseq.operation_seq_num));

1653: x_op_seq_num,
1654: rec_wip_entity.organization_id) LOOP
1655:
1656: if (l_debug = 'Y') then
1657: fnd_file.put_line(fnd_file.log,'OP_SEQ: ' || to_char(rec_opseq.operation_seq_num));
1658: end if;
1659: l_stmt_num := 20;
1660:
1661: ---------------------------------------------------------

Line 1741: fnd_file.put_line(fnd_file.log,'PL cost : ' || to_char(x_pl_cost));

1737: x_tl_res_cost +
1738: x_tl_osp_cost +
1739: x_ovhd_cost;
1740: if (l_debug = 'Y') then
1741: fnd_file.put_line(fnd_file.log,'PL cost : ' || to_char(x_pl_cost));
1742: fnd_file.put_line(fnd_file.log,'TL res cost: ' || to_char(x_tl_res_cost));
1743: fnd_file.put_line(fnd_file.log,'TL osp cost: ' || to_char(x_tl_osp_cost));
1744: fnd_file.put_line(fnd_file.log,'TL ovh cost: ' || to_char(x_ovhd_cost));
1745: end if;

Line 1742: fnd_file.put_line(fnd_file.log,'TL res cost: ' || to_char(x_tl_res_cost));

1738: x_tl_osp_cost +
1739: x_ovhd_cost;
1740: if (l_debug = 'Y') then
1741: fnd_file.put_line(fnd_file.log,'PL cost : ' || to_char(x_pl_cost));
1742: fnd_file.put_line(fnd_file.log,'TL res cost: ' || to_char(x_tl_res_cost));
1743: fnd_file.put_line(fnd_file.log,'TL osp cost: ' || to_char(x_tl_osp_cost));
1744: fnd_file.put_line(fnd_file.log,'TL ovh cost: ' || to_char(x_ovhd_cost));
1745: end if;
1746:

Line 1743: fnd_file.put_line(fnd_file.log,'TL osp cost: ' || to_char(x_tl_osp_cost));

1739: x_ovhd_cost;
1740: if (l_debug = 'Y') then
1741: fnd_file.put_line(fnd_file.log,'PL cost : ' || to_char(x_pl_cost));
1742: fnd_file.put_line(fnd_file.log,'TL res cost: ' || to_char(x_tl_res_cost));
1743: fnd_file.put_line(fnd_file.log,'TL osp cost: ' || to_char(x_tl_osp_cost));
1744: fnd_file.put_line(fnd_file.log,'TL ovh cost: ' || to_char(x_ovhd_cost));
1745: end if;
1746:
1747: l_stmt_num := 50;

Line 1744: fnd_file.put_line(fnd_file.log,'TL ovh cost: ' || to_char(x_ovhd_cost));

1740: if (l_debug = 'Y') then
1741: fnd_file.put_line(fnd_file.log,'PL cost : ' || to_char(x_pl_cost));
1742: fnd_file.put_line(fnd_file.log,'TL res cost: ' || to_char(x_tl_res_cost));
1743: fnd_file.put_line(fnd_file.log,'TL osp cost: ' || to_char(x_tl_osp_cost));
1744: fnd_file.put_line(fnd_file.log,'TL ovh cost: ' || to_char(x_ovhd_cost));
1745: end if;
1746:
1747: l_stmt_num := 50;
1748:

Line 1764: fnd_file.put_line(fnd_file.log,'TOTAL OPN COST: ' || to_char(x_operation_cost));

1760: AND operation_seq_num = rec_opseq.operation_seq_num
1761: AND organization_id = rec_wip_entity.organization_id;
1762:
1763: if (l_debug = 'Y') then
1764: fnd_file.put_line(fnd_file.log,'TOTAL OPN COST: ' || to_char(x_operation_cost));
1765: end if;
1766:
1767: END LOOP opseq;
1768:

Line 1772: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PROCESS_SM_OP_YIELD >>> ');

1768:
1769: END IF; /* If ESA is enabled */
1770: END LOOP wip_entity;
1771: IF(l_debug = 'Y') THEN
1772: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PROCESS_SM_OP_YIELD >>> ');
1773: END IF;
1774:
1775:
1776: RETURN 1;

Line 1779: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in WSM_ESA_ENABLED : '||

1775:
1776: RETURN 1;
1777: EXCEPTION
1778: WHEN WSM_ESA_PKG_ERROR THEN
1779: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in WSM_ESA_ENABLED : '||
1780: x_err_num ||' : '|| x_err_msg);
1781: o_err_num := x_err_num;
1782: o_err_msg := 'CSTPOYLD.transact_op_yield_var:' ||substr(x_err_msg,1,150);
1783: return 0;