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

Line 64: fnd_file.put_line(fnd_file.log, 'WSM_JobCosting_GRP.Insert_MaterialTxn('||l_stmt_num||'): '||x_err_buf);

60: WHEN NO_DATA_FOUND then
61: x_err_code := -1;
62: fnd_message.set_name('WSM', 'WSM_ACCT_PERIOD_NOT_OPEN');
63: x_err_buf := FND_MESSAGE.GET;
64: fnd_file.put_line(fnd_file.log, 'WSM_JobCosting_GRP.Insert_MaterialTxn('||l_stmt_num||'): '||x_err_buf);
65:
66: WHEN OTHERS THEN
67: x_err_code := SQLCODE;
68: x_err_buf := 'Insert_MaterialTxn('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);

Line 69: fnd_file.put_line(fnd_file.log, x_err_buf);

65:
66: WHEN OTHERS THEN
67: x_err_code := SQLCODE;
68: x_err_buf := 'Insert_MaterialTxn('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
69: fnd_file.put_line(fnd_file.log, x_err_buf);
70: END;
71:
72: IF (nvl(l_acct_period_id , -1) = -1) THEN
73: x_err_code := -1;

Line 76: fnd_file.put_line(fnd_file.log, 'WSM_JobCosting_GRP.Insert_MaterialTxn('||l_stmt_num||'): '||x_err_buf);

72: IF (nvl(l_acct_period_id , -1) = -1) THEN
73: x_err_code := -1;
74: fnd_message.set_name('WSM', 'WSM_ACCT_PERIOD_NOT_OPEN');
75: x_err_buf := FND_MESSAGE.GET;
76: fnd_file.put_line(fnd_file.log, 'WSM_JobCosting_GRP.Insert_MaterialTxn('||l_stmt_num||'): '||x_err_buf);
77: END IF;
78:
79: IF (x_err_code <> 0) THEN
80: GOTO L_ERROR; --x_err_code has errcode, x_err_buf has the error message

Line 143: fnd_file.put_line(fnd_file.log, 'Records inserted into MMT ='||SQL%ROWCOUNT);

139: WSMPCNST.UPDATE_QUANTITY, 43, 0))
140: AND MTT.transaction_source_type_id = 5
141: AND rownum = 1; --This picks up only 1 row for Split/Merge
142:
143: fnd_file.put_line(fnd_file.log, 'Records inserted into MMT ='||SQL%ROWCOUNT);
144:
145: IF (SQL%ROWCOUNT <> 1) THEN
146: x_err_code := -1;
147: fnd_message.set_name('WSM', 'WSM_INS_TBL_FAILED');

Line 150: fnd_file.put_line(fnd_file.log, 'WSM_JobCosting_GRP.Insert_MaterialTxn('||l_stmt_num||'): '||x_err_buf);

146: x_err_code := -1;
147: fnd_message.set_name('WSM', 'WSM_INS_TBL_FAILED');
148: fnd_message.set_token('ELEMENT', 'mtl_material_transactions');
149: x_err_buf := FND_MESSAGE.GET;
150: fnd_file.put_line(fnd_file.log, 'WSM_JobCosting_GRP.Insert_MaterialTxn('||l_stmt_num||'): '||x_err_buf);
151: GOTO L_ERROR;
152: ELSE
153: GOTO L_SUCCESS;
154: END IF;

Line 157: fnd_file.put_line(fnd_file.log, 'WSM_JobCosting_GRP.Insert_MaterialTxn: Rollback due to l_stmt_num = '||l_stmt_num);

153: GOTO L_SUCCESS;
154: END IF;
155:
156: <> --x_err_code has errcode, x_err_buf has the error message
157: fnd_file.put_line(fnd_file.log, 'WSM_JobCosting_GRP.Insert_MaterialTxn: Rollback due to l_stmt_num = '||l_stmt_num);
158: raise e_proc_error;
159:
160: <>
161: l_stmt_num := 40;

Line 164: fnd_file.put_line(fnd_file.log, 'WSM_JobCosting_GRP.Insert_MaterialTxn: Returned success');

160: <>
161: l_stmt_num := 40;
162: x_err_code := 0;
163: x_err_buf := NULL;
164: fnd_file.put_line(fnd_file.log, 'WSM_JobCosting_GRP.Insert_MaterialTxn: Returned success');
165:
166: EXCEPTION
167: WHEN e_proc_error THEN
168: x_err_buf := ' WSM_JobCosting_GRP.Insert_MaterialTxn('||l_stmt_num||'): '||x_err_buf;

Line 169: fnd_file.put_line(fnd_file.log,x_err_buf);

165:
166: EXCEPTION
167: WHEN e_proc_error THEN
168: x_err_buf := ' WSM_JobCosting_GRP.Insert_MaterialTxn('||l_stmt_num||'): '||x_err_buf;
169: fnd_file.put_line(fnd_file.log,x_err_buf);
170:
171: WHEN OTHERS THEN
172: x_err_code := SQLCODE;
173: x_err_buf := 'WSM_JobCosting_GRP.Insert_MaterialTxn('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);

Line 174: fnd_file.put_line(fnd_file.log, x_err_buf);

170:
171: WHEN OTHERS THEN
172: x_err_code := SQLCODE;
173: x_err_buf := 'WSM_JobCosting_GRP.Insert_MaterialTxn('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
174: fnd_file.put_line(fnd_file.log, x_err_buf);
175:
176: END Insert_MaterialTxn;
177:
178:

Line 322: fnd_file.put_line(fnd_file.log, x_err_buf);

318: EXCEPTION
319: WHEN OTHERS THEN
320: x_err_code := SQLCODE;
321: x_err_buf := 'WSM_JobCosting_GRP.Update_QtyIssued('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
322: fnd_file.put_line(fnd_file.log, x_err_buf);
323:
324: END Update_QtyIssued;
325:
326: