DBA Data[Home] [Help]

APPS.CST_COSTPROCVALIDATION_PVT dependencies on FND_MESSAGE

Line 151: FND_MESSAGE.set_name('BOM', l_error_code);

147:
148: l_stmt_num := 50;
149: /* VALIDATION 7,10: Interorg txns should not be from and to the same org. */
150: l_error_code := 'CST_INVALID_INTERORG';
151: FND_MESSAGE.set_name('BOM', l_error_code);
152: l_error_expl := FND_MESSAGE.Get;
153: UPDATE mtl_material_transactions mmt
154: SET costed_flag = 'E',
155: error_code = l_error_code,

Line 152: l_error_expl := FND_MESSAGE.Get;

148: l_stmt_num := 50;
149: /* VALIDATION 7,10: Interorg txns should not be from and to the same org. */
150: l_error_code := 'CST_INVALID_INTERORG';
151: FND_MESSAGE.set_name('BOM', l_error_code);
152: l_error_expl := FND_MESSAGE.Get;
153: UPDATE mtl_material_transactions mmt
154: SET costed_flag = 'E',
155: error_code = l_error_code,
156: error_explanation = l_error_expl,

Line 171: FND_MESSAGE.set_name('BOM', l_error_code);

167:
168: l_stmt_num := 60;
169: /* VALIDATION 3,4,5: Txfr txns should have all txfr columns populated. */
170: l_error_code := 'CST_INVALID_TXFR';
171: FND_MESSAGE.set_name('BOM', l_error_code);
172: l_error_expl := FND_MESSAGE.Get;
173: UPDATE mtl_material_transactions mmt
174: SET costed_flag = 'E',
175: error_code = l_error_code,

Line 172: l_error_expl := FND_MESSAGE.Get;

168: l_stmt_num := 60;
169: /* VALIDATION 3,4,5: Txfr txns should have all txfr columns populated. */
170: l_error_code := 'CST_INVALID_TXFR';
171: FND_MESSAGE.set_name('BOM', l_error_code);
172: l_error_expl := FND_MESSAGE.Get;
173: UPDATE mtl_material_transactions mmt
174: SET costed_flag = 'E',
175: error_code = l_error_code,
176: error_explanation = l_error_expl,

Line 201: FND_MESSAGE.set_name('BOM', l_error_code);

197:
198: l_stmt_num := 70;
199: /* VALIDATION 1: Acct_period_id should match txn date. */
200: l_error_code := 'CST_MATCH_DATE_PERIOD';
201: FND_MESSAGE.set_name('BOM', l_error_code);
202: l_error_expl := FND_MESSAGE.Get;
203:
204: l_stmt_num := 72;
205:

Line 202: l_error_expl := FND_MESSAGE.Get;

198: l_stmt_num := 70;
199: /* VALIDATION 1: Acct_period_id should match txn date. */
200: l_error_code := 'CST_MATCH_DATE_PERIOD';
201: FND_MESSAGE.set_name('BOM', l_error_code);
202: l_error_expl := FND_MESSAGE.Get;
203:
204: l_stmt_num := 72;
205:
206: UPDATE /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */ mtl_material_transactions mmt

Line 241: FND_MESSAGE.set_name('BOM', l_error_code);

237: l_stmt_num := 80;
238: /* VALIDATION 2,6,8,9,11,12: Cost group validation (non null, must be in ccga or default). */
239: /* ignore scrap, wip/inv lot transactions, periodic cost update, pack/unpack, container */
240: l_error_code := 'CST_INVALID_CG';
241: FND_MESSAGE.set_name('BOM', l_error_code);
242: l_error_expl := FND_MESSAGE.Get;
243: UPDATE mtl_material_transactions mmt
244: SET costed_flag = 'E',
245: error_code = l_error_code,

Line 242: l_error_expl := FND_MESSAGE.Get;

238: /* VALIDATION 2,6,8,9,11,12: Cost group validation (non null, must be in ccga or default). */
239: /* ignore scrap, wip/inv lot transactions, periodic cost update, pack/unpack, container */
240: l_error_code := 'CST_INVALID_CG';
241: FND_MESSAGE.set_name('BOM', l_error_code);
242: l_error_expl := FND_MESSAGE.Get;
243: UPDATE mtl_material_transactions mmt
244: SET costed_flag = 'E',
245: error_code = l_error_code,
246: error_explanation = l_error_expl,

Line 271: FND_MESSAGE.set_name('BOM', l_error_code);

267:
268: l_stmt_num := 90;
269: /* VALIDATION 6,9,12: Txfr CG validation in org (non null, must be in ccga or default). */
270: l_error_code := 'CST_MATCH_TXFR_CG_ORG';
271: FND_MESSAGE.set_name('BOM', l_error_code);
272: l_error_expl := FND_MESSAGE.Get;
273: UPDATE mtl_material_transactions mmt
274: SET costed_flag = 'E',
275: error_code = l_error_code,

Line 272: l_error_expl := FND_MESSAGE.Get;

268: l_stmt_num := 90;
269: /* VALIDATION 6,9,12: Txfr CG validation in org (non null, must be in ccga or default). */
270: l_error_code := 'CST_MATCH_TXFR_CG_ORG';
271: FND_MESSAGE.set_name('BOM', l_error_code);
272: l_error_expl := FND_MESSAGE.Get;
273: UPDATE mtl_material_transactions mmt
274: SET costed_flag = 'E',
275: error_code = l_error_code,
276: error_explanation = l_error_expl,

Line 304: FND_MESSAGE.set_name('BOM', l_error_code);

300:
301: l_stmt_num := 100;
302: /* VALIDATION 8,11: Txfr CG validation in txfr org (non null, must be in ccga or default). */
303: l_error_code := 'CST_MATCH_TXFR_CG_TXFR_ORG';
304: FND_MESSAGE.set_name('BOM', l_error_code);
305: l_error_expl := FND_MESSAGE.Get;
306: UPDATE mtl_material_transactions mmt
307: SET costed_flag = 'E',
308: error_code = l_error_code,

Line 305: l_error_expl := FND_MESSAGE.Get;

301: l_stmt_num := 100;
302: /* VALIDATION 8,11: Txfr CG validation in txfr org (non null, must be in ccga or default). */
303: l_error_code := 'CST_MATCH_TXFR_CG_TXFR_ORG';
304: FND_MESSAGE.set_name('BOM', l_error_code);
305: l_error_expl := FND_MESSAGE.Get;
306: UPDATE mtl_material_transactions mmt
307: SET costed_flag = 'E',
308: error_code = l_error_code,
309: error_explanation = l_error_expl,

Line 337: FND_MESSAGE.set_name('BOM', l_error_code);

333:
334: l_stmt_num := 110;
335: /* VALIDATION 13: make sure that acct alias is valid */
336: l_error_code := 'CST_INVALID_ACCT_ALIAS';
337: FND_MESSAGE.set_name('BOM', l_error_code);
338: l_error_expl := FND_MESSAGE.Get;
339: UPDATE mtl_material_transactions mmt
340: SET costed_flag = 'E',
341: error_code = l_error_code,

Line 338: l_error_expl := FND_MESSAGE.Get;

334: l_stmt_num := 110;
335: /* VALIDATION 13: make sure that acct alias is valid */
336: l_error_code := 'CST_INVALID_ACCT_ALIAS';
337: FND_MESSAGE.set_name('BOM', l_error_code);
338: l_error_expl := FND_MESSAGE.Get;
339: UPDATE mtl_material_transactions mmt
340: SET costed_flag = 'E',
341: error_code = l_error_code,
342: error_explanation = l_error_expl,

Line 362: FND_MESSAGE.set_name('BOM', l_error_code);

358:
359: l_stmt_num := 120;
360: /* VALIDATION 14: Issues and receipts should have valid subinventories. */
361: l_error_code := 'CST_INVALID_SUB';
362: FND_MESSAGE.set_name('BOM', l_error_code);
363: l_error_expl := FND_MESSAGE.Get;
364: UPDATE mtl_material_transactions mmt
365: SET costed_flag = 'E',
366: error_code = l_error_code,

Line 363: l_error_expl := FND_MESSAGE.Get;

359: l_stmt_num := 120;
360: /* VALIDATION 14: Issues and receipts should have valid subinventories. */
361: l_error_code := 'CST_INVALID_SUB';
362: FND_MESSAGE.set_name('BOM', l_error_code);
363: l_error_expl := FND_MESSAGE.Get;
364: UPDATE mtl_material_transactions mmt
365: SET costed_flag = 'E',
366: error_code = l_error_code,
367: error_explanation = l_error_expl,

Line 386: FND_MESSAGE.set_name('BOM', l_error_code);

382:
383: l_stmt_num := 130;
384: /* VALIDATION 15, 16: WIP transactions should refer to valid wip entity and be in wpb. */
385: l_error_code := 'CST_INVALID_WIP';
386: FND_MESSAGE.set_name('BOM', l_error_code);
387: l_error_expl := FND_MESSAGE.Get;
388: UPDATE mtl_material_transactions mmt
389: SET costed_flag = 'E',
390: error_code = l_error_code,

Line 387: l_error_expl := FND_MESSAGE.Get;

383: l_stmt_num := 130;
384: /* VALIDATION 15, 16: WIP transactions should refer to valid wip entity and be in wpb. */
385: l_error_code := 'CST_INVALID_WIP';
386: FND_MESSAGE.set_name('BOM', l_error_code);
387: l_error_expl := FND_MESSAGE.Get;
388: UPDATE mtl_material_transactions mmt
389: SET costed_flag = 'E',
390: error_code = l_error_code,
391: error_explanation = l_error_expl,

Line 416: FND_MESSAGE.set_name('BOM', l_error_code);

412:
413: l_stmt_num := 140;
414: /* VALIDATION 17: txn date not less than job/schedule release date */
415: l_error_code := 'CST_INVALID_JOB_DATE';
416: FND_MESSAGE.set_name('BOM', l_error_code);
417: l_error_expl := FND_MESSAGE.Get;
418: UPDATE mtl_material_transactions mmt
419: SET costed_flag = 'E',
420: error_code = l_error_code,

Line 417: l_error_expl := FND_MESSAGE.Get;

413: l_stmt_num := 140;
414: /* VALIDATION 17: txn date not less than job/schedule release date */
415: l_error_code := 'CST_INVALID_JOB_DATE';
416: FND_MESSAGE.set_name('BOM', l_error_code);
417: l_error_expl := FND_MESSAGE.Get;
418: UPDATE mtl_material_transactions mmt
419: SET costed_flag = 'E',
420: error_code = l_error_code,
421: error_explanation = l_error_expl,

Line 466: FND_MESSAGE.SET_NAME ('BOM','CST_MTL_COSTING_ERROR');

462: OPEN orgs_with_error;
463: LOOP
464: FETCH orgs_with_error INTO l_org_code, l_count;
465: EXIT WHEN orgs_with_error%NOTFOUND;
466: FND_MESSAGE.SET_NAME ('BOM','CST_MTL_COSTING_ERROR');
467: FND_MESSAGE.SET_TOKEN ('COUNT', l_count);
468: FND_MESSAGE.SET_TOKEN ('ORG_CODE', l_org_code);
469: FND_LOG.MESSAGE (FND_LOG.LEVEL_UNEXPECTED, l_module || '.validation_failure', FALSE);
470: END LOOP;

Line 467: FND_MESSAGE.SET_TOKEN ('COUNT', l_count);

463: LOOP
464: FETCH orgs_with_error INTO l_org_code, l_count;
465: EXIT WHEN orgs_with_error%NOTFOUND;
466: FND_MESSAGE.SET_NAME ('BOM','CST_MTL_COSTING_ERROR');
467: FND_MESSAGE.SET_TOKEN ('COUNT', l_count);
468: FND_MESSAGE.SET_TOKEN ('ORG_CODE', l_org_code);
469: FND_LOG.MESSAGE (FND_LOG.LEVEL_UNEXPECTED, l_module || '.validation_failure', FALSE);
470: END LOOP;
471: END IF;

Line 468: FND_MESSAGE.SET_TOKEN ('ORG_CODE', l_org_code);

464: FETCH orgs_with_error INTO l_org_code, l_count;
465: EXIT WHEN orgs_with_error%NOTFOUND;
466: FND_MESSAGE.SET_NAME ('BOM','CST_MTL_COSTING_ERROR');
467: FND_MESSAGE.SET_TOKEN ('COUNT', l_count);
468: FND_MESSAGE.SET_TOKEN ('ORG_CODE', l_org_code);
469: FND_LOG.MESSAGE (FND_LOG.LEVEL_UNEXPECTED, l_module || '.validation_failure', FALSE);
470: END LOOP;
471: END IF;
472: