APPS.WSM_JOBCOSTING_GRP dependencies on WSM_JOBCOSTING_GRP

Line 1: PACKAGE BODY WSM_JobCosting_GRP as

1: PACKAGE BODY WSM_JobCosting_GRP as
2: /* $Header: WSMGCSTB.pls 115.2 2003/08/13 20:48:39 vjambhek ship $ */
3:
4: /*-------------------------------------------------------------+
5: | Name : Insert_MaterialTxn

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 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 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 168: x_err_buf := ' WSM_JobCosting_GRP.Insert_MaterialTxn('||l_stmt_num||'): '||x_err_buf;

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;
169: fnd_file.put_line(fnd_file.log,x_err_buf);
170:
171: WHEN OTHERS THEN
172: x_err_code := SQLCODE;

Line 173: x_err_buf := 'WSM_JobCosting_GRP.Insert_MaterialTxn('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);

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);
174: fnd_file.put_line(fnd_file.log, x_err_buf);
175:
176: END Insert_MaterialTxn;
177:

Line 321: x_err_buf := 'WSM_JobCosting_GRP.Update_QtyIssued('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);

317:
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:

Line 328: END WSM_JobCosting_GRP;

324: END Update_QtyIssued;
325:
326:
327:
328: END WSM_JobCosting_GRP;