DBA Data[Home] [Help]

APPS.CSTPSMCW dependencies on FND_FILE

Line 90: FND_FILE.put_line(fnd_file.log, 'This program is no longer supported');

86: BEGIN
87:
88: /* For 11i9 and above, return */
89: IF WSMPVERS.GET_OSFM_RELEASE_VERSION >= '110509' THEN
90: FND_FILE.put_line(fnd_file.log, 'This program is no longer supported');
91: RETURN;
92: ELSE
93: /* Pre 11i.9 Processor */
94: IF l_debug_flag = 'Y' THEN

Line 95: FND_FILE.put_line(fnd_file.log, 'Pre 11i.9 OSFM');

91: RETURN;
92: ELSE
93: /* Pre 11i.9 Processor */
94: IF l_debug_flag = 'Y' THEN
95: FND_FILE.put_line(fnd_file.log, 'Pre 11i.9 OSFM');
96: END IF;
97:
98: l_user_id := FND_GLOBAL.USER_ID;
99: l_login_id := FND_GLOBAL.LOGIN_ID;

Line 202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserting Transaction into MMT');

198: /* If it doesn't, call API's to insert transaction into MMT
199: and update quantity */
200: IF l_txn_mmt_flag = 0 THEN
201: IF ( l_debug_flag = 'Y' ) THEN
202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserting Transaction into MMT');
203: END IF;
204:
205: -- Insert
206: WSM_JobCosting_GRP.Insert_MaterialTxn (

Line 222: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating Quantities');

218: WHERE transaction_id = c_uncost_rec.transaction_id;
219:
220: -- Update
221: IF ( l_debug_flag = 'Y' ) THEN
222: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating Quantities');
223: END IF;
224: WSM_JobCosting_GRP.Update_QtyIssued (
225: c_uncost_rec.transaction_id,
226: l_txn_type_id,

Line 233: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Check Material Transactions form to find if the transaction is costed');

229: IF l_error_code <> 0 THEN
230: RAISE UPDATE_QUANTITY_ISSUE_FAILURE;
231: END IF;
232: IF ( l_debug_flag = 'Y' ) THEN
233: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Check Material Transactions form to find if the transaction is costed');
234: END IF;
235: END IF;
236:
237: END LOOP;

Line 254: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code

250:
251: fnd_message.set_name('BOM', 'CST_CMCCCU_ORG_RUNNING');
252: l_err_msg := fnd_message.get;
253: l_err_msg := SUBSTR(l_err_msg,1,240);
254: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code
255: ||' '
256: ||l_err_msg,1,240));
257:
258: WHEN CST_CSTPSMCW_RUNNING THEN

Line 270: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code

266:
267: fnd_message.set_name('BOM', 'CST_CSTPSMCW_RUNNING');
268: l_err_msg := fnd_message.get;
269: l_err_msg := SUBSTR(l_err_msg,1,240);
270: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code
271: ||' '
272: ||l_err_msg,1,240));
273:
274: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);

Line 283: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);

279: || to_char(l_stmt_num)
280: || '): '
281: ||SQLERRM,1,240
282: ||': '||l_error_buf);
283: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
284:
285: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
286:
287: WHEN INSERT_MMT_FAILURE THEN

Line 294: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);

290: || to_char(l_stmt_num)
291: || '): '
292: ||SQLERRM,1,240
293: ||': '||l_error_buf);
294: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
295:
296: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
297:
298: WHEN OTHERS THEN

Line 306: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);

302: || to_char(l_stmt_num)
303: || '): '
304: ||SQLERRM,1,240);
305:
306: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
307:
308: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
309:
310: END lot_txn_cost_processor;

Line 716: FND_FILE.put_line(fnd_file.log, 'API Version Obsoleted'|| l_err_msg );

712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
713: x_err_num := -1;
714: x_err_code := 'Inconsistent API Version';--FND_API.G_RET_SYS_ERROR;
715: l_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'):' || l_err_msg || substr(SQLERRM, 1, 200);
716: FND_FILE.put_line(fnd_file.log, 'API Version Obsoleted'|| l_err_msg );
717: x_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num);
718: l_ret_update := UPDATE_WSMT_TXN_STATUS ( l_wsmt_transaction_id,
719: WIP_CONSTANTS.ERROR,
720: l_err_msg,

Line 728: FND_FILE.put_line(fnd_file.log, 'Unknown Transaction Type passed... Catastrophic Failure'|| l_err_msg );

724: WHEN UNKNOWN_TXN_ERROR THEN
725: x_err_num := -1;
726: x_err_code := 'Unknown Transaction Type passed... Catastrophic Failure';
727: l_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'):' || l_err_msg;
728: FND_FILE.put_line(fnd_file.log, 'Unknown Transaction Type passed... Catastrophic Failure'|| l_err_msg );
729: x_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num);
730:
731: l_ret_update := UPDATE_WSMT_TXN_STATUS ( l_wsmt_transaction_id,
732: WIP_CONSTANTS.ERROR,

Line 743: FND_FILE.put_line(fnd_file.log, 'MMT not populated with Transaction ID from WSMT'|| l_err_msg );

739: x_err_num := -1;
740: x_err_code := 'MMT not populated with Transaction ID from WSMT';
741: l_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'): ' || l_err_msg;
742: x_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'):';
743: FND_FILE.put_line(fnd_file.log, 'MMT not populated with Transaction ID from WSMT'|| l_err_msg );
744: l_ret_update := UPDATE_WSMT_TXN_STATUS ( l_wsmt_transaction_id,
745: WIP_CONSTANTS.ERROR,
746: l_err_msg,
747: p_request_id,

Line 754: FND_FILE.put_line(fnd_file.log, 'Transaction Costing Failed'|| l_err_msg );

750: WHEN COST_TXN_FAILURE THEN
751: x_err_num := -1;
752: x_err_code := 'Transaction Costing Failed';
753: l_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'): ' || l_err_msg;
754: FND_FILE.put_line(fnd_file.log, 'Transaction Costing Failed'|| l_err_msg );
755: l_ret_update := UPDATE_WSMT_TXN_STATUS ( l_wsmt_transaction_id,
756: WIP_CONSTANTS.ERROR,
757: l_err_msg,
758: p_request_id,

Line 766: FND_FILE.put_line(fnd_file.log, 'Failed to Update Job Info: Transaction Costing Failed'|| l_err_msg );

762: x_err_num := -1;
763: x_err_code := 'Failed to Update Job Info: Transaction Costing Failed';
764: l_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'): ' || l_err_msg;
765: x_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'):';
766: FND_FILE.put_line(fnd_file.log, 'Failed to Update Job Info: Transaction Costing Failed'|| l_err_msg );
767: l_ret_update := UPDATE_WSMT_TXN_STATUS ( l_wsmt_transaction_id,
768: WIP_CONSTANTS.ERROR,
769: l_err_msg,
770: p_request_id,

Line 778: FND_FILE.put_line(fnd_file.log, 'Update of Wip Operation Yields Failed'|| l_err_msg );

774: x_err_num := -1;
775: x_err_code := 'Update of Wip Operation Yields Failed';
776: l_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'): ' || l_err_msg;
777: x_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'):';
778: FND_FILE.put_line(fnd_file.log, 'Update of Wip Operation Yields Failed'|| l_err_msg );
779: l_ret_update := UPDATE_WSMT_TXN_STATUS ( l_wsmt_transaction_id,
780: WIP_CONSTANTS.ERROR,
781: l_err_msg,
782: p_request_id,

Line 790: FND_FILE.put_line(fnd_file.log, 'Operation Yield Costing Failed'|| l_err_msg );

786: x_err_num := -1;
787: x_err_code := 'Operation Yield Costing Failed';
788: l_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'): ' || l_err_msg;
789: x_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'):';
790: FND_FILE.put_line(fnd_file.log, 'Operation Yield Costing Failed'|| l_err_msg );
791: l_ret_update := UPDATE_WSMT_TXN_STATUS ( l_wsmt_transaction_id,
792: WIP_CONSTANTS.ERROR,
793: l_err_msg,
794: p_request_id,