DBA Data[Home] [Help]

APPS.WSM_JOBCOSTING_GRP dependencies on FND_MESSAGE

Line 62: fnd_message.set_name('WSM', 'WSM_ACCT_PERIOD_NOT_OPEN');

58:
59: EXCEPTION
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

Line 63: x_err_buf := FND_MESSAGE.GET;

59: EXCEPTION
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;

Line 74: fnd_message.set_name('WSM', 'WSM_ACCT_PERIOD_NOT_OPEN');

70: END;
71:
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:

Line 75: x_err_buf := FND_MESSAGE.GET;

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

Line 147: fnd_message.set_name('WSM', 'WSM_INS_TBL_FAILED');

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');
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;

Line 148: fnd_message.set_token('ELEMENT', 'mtl_material_transactions');

144:
145: IF (SQL%ROWCOUNT <> 1) THEN
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

Line 149: x_err_buf := FND_MESSAGE.GET;

145: IF (SQL%ROWCOUNT <> 1) THEN
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;