DBA Data[Home] [Help]

APPS.CST_COSTPROCVALIDATION_PVT dependencies on FND_MESSAGE

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

141:
142: l_stmt_num := 50;
143: /* VALIDATION 7,10: Interorg txns should not be from and to the same org. */
144: l_error_code := 'CST_INVALID_INTERORG';
145: FND_MESSAGE.set_name('BOM', l_error_code);
146: l_error_expl := FND_MESSAGE.Get;
147: UPDATE mtl_material_transactions mmt
148: SET costed_flag = 'E',
149: error_code = l_error_code,

Line 146: l_error_expl := FND_MESSAGE.Get;

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

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

161:
162: l_stmt_num := 60;
163: /* VALIDATION 3,4,5: Txfr txns should have all txfr columns populated. */
164: l_error_code := 'CST_INVALID_TXFR';
165: FND_MESSAGE.set_name('BOM', l_error_code);
166: l_error_expl := FND_MESSAGE.Get;
167: UPDATE mtl_material_transactions mmt
168: SET costed_flag = 'E',
169: error_code = l_error_code,

Line 166: l_error_expl := FND_MESSAGE.Get;

162: l_stmt_num := 60;
163: /* VALIDATION 3,4,5: Txfr txns should have all txfr columns populated. */
164: l_error_code := 'CST_INVALID_TXFR';
165: FND_MESSAGE.set_name('BOM', l_error_code);
166: l_error_expl := FND_MESSAGE.Get;
167: UPDATE mtl_material_transactions mmt
168: SET costed_flag = 'E',
169: error_code = l_error_code,
170: error_explanation = l_error_expl,

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

191:
192: l_stmt_num := 70;
193: /* VALIDATION 1: Acct_period_id should match txn date. */
194: l_error_code := 'CST_MATCH_DATE_PERIOD';
195: FND_MESSAGE.set_name('BOM', l_error_code);
196: l_error_expl := FND_MESSAGE.Get;
197:
198: OPEN orgs_to_process;
199:

Line 196: l_error_expl := FND_MESSAGE.Get;

192: l_stmt_num := 70;
193: /* VALIDATION 1: Acct_period_id should match txn date. */
194: l_error_code := 'CST_MATCH_DATE_PERIOD';
195: FND_MESSAGE.set_name('BOM', l_error_code);
196: l_error_expl := FND_MESSAGE.Get;
197:
198: OPEN orgs_to_process;
199:
200: LOOP

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

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

Line 247: l_error_expl := FND_MESSAGE.Get;

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

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

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

Line 277: l_error_expl := FND_MESSAGE.Get;

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

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

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

Line 310: l_error_expl := FND_MESSAGE.Get;

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

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

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

Line 343: l_error_expl := FND_MESSAGE.Get;

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

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

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

Line 368: l_error_expl := FND_MESSAGE.Get;

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

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

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

Line 392: l_error_expl := FND_MESSAGE.Get;

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

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

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

Line 422: l_error_expl := FND_MESSAGE.Get;

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

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

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

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

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

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

469: FETCH orgs_with_error INTO l_org_code, l_count;
470: EXIT WHEN orgs_with_error%NOTFOUND;
471: FND_MESSAGE.SET_NAME ('BOM','CST_MTL_COSTING_ERROR');
472: FND_MESSAGE.SET_TOKEN ('COUNT', l_count);
473: FND_MESSAGE.SET_TOKEN ('ORG_CODE', l_org_code);
474: FND_LOG.MESSAGE (FND_LOG.LEVEL_UNEXPECTED, l_module || '.validation_failure', FALSE);
475: END LOOP;
476: END IF;
477: