DBA Data[Home] [Help]

APPS.WIP_BFLPROC_PRIV dependencies on FND_MSG_PUB

Line 293: fnd_msg_pub.initialize;

289: l_batch_seq NUMBER := null; /*Fix bug 9968707 (FP of 9765009)*/
290: begin
291: savepoint wipbflpb20;
292: if(fnd_api.to_boolean(p_initMsgList)) then
293: fnd_msg_pub.initialize;
294: end if;
295:
296: if (l_logLevel <= wip_constants.trace_logging) then
297: l_params(1).paramName := 'p_wipEntityID';

Line 378: fnd_msg_pub.add;

374:
375: if(l_acctPeriodID is null or
376: l_acctPeriodID <= 0) then
377: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
378: fnd_msg_pub.add;
379: l_errMsg := 'acct period id could not be derived.';
380: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
381: raise fnd_api.g_exc_unexpected_error;
382: end if;

Line 844: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_bflProc_priv',

840: end if;
841: when others then
842: rollback to wipbflpb20;
843: x_returnStatus := fnd_api.g_ret_sts_unexp_error;--unexpec error if exception occurs
844: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_bflProc_priv',
845: p_procedure_name => 'processRequirements',
846: p_error_text => SQLERRM);
847: if (l_logLevel <= wip_constants.trace_logging) then
848: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.processRequirements',

Line 1018: fnd_msg_pub.initialize;

1014: begin
1015: savepoint wipbflpb30;
1016:
1017: if(fnd_api.to_boolean(p_initMsgList)) then
1018: fnd_msg_pub.initialize;
1019: end if;
1020:
1021: if (l_logLevel <= wip_constants.trace_logging) then
1022: l_params(1).paramName := 'p_itemID';

Line 1132: fnd_msg_pub.add;

1128: and msi.inventory_item_id = p_itemID;
1129: exception
1130: when no_data_found then --assume bom parameters not defined. the item_id should be valid.
1131: fnd_message.set_name('BOM', 'BOM_PARAMETER_SETUP');
1132: fnd_msg_pub.add;
1133: l_errMsg := 'no bom parameters';
1134: raise fnd_api.g_exc_unexpected_error;
1135: end;
1136:

Line 1191: fnd_msg_pub.add;

1187: end if;
1188: if(l_errCode <> 0) then
1189: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1190: fnd_message.set_token('MESSAGE', l_msgData);
1191: fnd_msg_pub.add;
1192: l_errMsg := 'BOM exploder failed';
1193: raise fnd_api.g_exc_unexpected_error;
1194: end if;
1195:

Line 1202: fnd_msg_pub.add;

1198: where group_id = l_grpID and loop_flag=1;
1199:
1200: if(l_errCode <> 0) then
1201: fnd_message.set_name('WIP', 'WIP_BOM_LOOP');
1202: fnd_msg_pub.add;
1203: l_errMsg := 'Loop In BOM Encountered';
1204: raise fnd_api.g_exc_unexpected_error;
1205: end if;
1206:

Line 1516: fnd_msg_pub.add;

1512: rollback to wipbflpb30;
1513: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1514: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1515: fnd_message.set_token('ERROR_TEXT', SQLERRM);
1516: fnd_msg_pub.add;
1517: if (l_logLevel <= wip_constants.trace_logging) then
1518: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',
1519: p_procReturnStatus => x_returnStatus,
1520: p_msg => 'unexpected error: ' || SQLERRM,

Line 1835: fnd_msg_pub.add;

1831: END IF;
1832:
1833: IF(l_proc_status = TVE_OVERCOMPLETION_MISMATCH) THEN
1834: fnd_message.set_name('WIP', 'WIP_OVERCOMPLETION_MISMATCH');
1835: fnd_msg_pub.add;
1836: l_errMsg := 'parent txn is not really overcompletion txn';
1837: raise fnd_api.g_exc_unexpected_error;
1838: ELSIF(l_proc_status = TVE_NO_MOVE_ALLOC) THEN
1839: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');

Line 1842: fnd_msg_pub.add;

1838: ELSIF(l_proc_status = TVE_NO_MOVE_ALLOC) THEN
1839: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1840: fnd_message.set_token('ENTITY1', 'transaction quantity');
1841: fnd_message.set_token('ENTITY2', 'quantity available to move');
1842: fnd_msg_pub.add;
1843: l_errMsg := 'available qty is not enough to fullfill move txn';
1844: raise fnd_api.g_exc_unexpected_error;
1845: ELSIF(l_proc_status = WIP_CONSTANTS.ERROR) THEN
1846: l_errMsg := 'wip_movProc_priv.schedule_alloc failed';

Line 1884: fnd_msg_pub.add;

1880: x_errMessage => l_errMsg);
1881: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
1882: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1883: fnd_message.set_token('MESSAGE', l_errMsg);
1884: fnd_msg_pub.add;
1885: raise fnd_api.g_exc_unexpected_error;
1886: END IF;
1887:
1888: IF(l_first_bf_op <> -1) THEN

Line 1959: fnd_msg_pub.add;

1955:
1956: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
1957: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1958: fnd_message.set_token('MESSAGE', l_errMsg);
1959: fnd_msg_pub.add;
1960: raise fnd_api.g_exc_unexpected_error;
1961: END IF;
1962:
1963: IF(l_first_bf_op <> -1) THEN

Line 2058: fnd_msg_pub.add;

2054: END IF;
2055:
2056: IF(l_proc_status = TVE_OVERCOMPLETION_MISMATCH) THEN
2057: fnd_message.set_name('WIP', 'WIP_OVERCOMPLETION_MISMATCH');
2058: fnd_msg_pub.add;
2059: l_errMsg := 'parent txn is not really overcompletion txn';
2060: raise fnd_api.g_exc_unexpected_error;
2061: ELSIF(l_proc_status = TVE_NO_MOVE_ALLOC) THEN
2062: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');

Line 2065: fnd_msg_pub.add;

2061: ELSIF(l_proc_status = TVE_NO_MOVE_ALLOC) THEN
2062: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
2063: fnd_message.set_token('ENTITY1', 'transaction quantity');
2064: fnd_message.set_token('ENTITY2', 'quantity available to move');
2065: fnd_msg_pub.add;
2066: l_errMsg := 'available qty is not enough to fullfill move txn';
2067: raise fnd_api.g_exc_unexpected_error;
2068: ELSIF(l_proc_status = WIP_CONSTANTS.ERROR) THEN
2069: l_errMsg := 'wip_movProc_priv.schedule_alloc failed';

Line 2191: fnd_msg_pub.add;

2187: END IF;
2188:
2189: IF(l_proc_status = TVE_OVERCOMPLETION_MISMATCH) THEN
2190: fnd_message.set_name('WIP', 'WIP_OVERCOMPLETION_MISMATCH');
2191: fnd_msg_pub.add;
2192: l_errMsg := 'parent txn is not really overcompletion txn';
2193: raise fnd_api.g_exc_unexpected_error;
2194: ELSIF(l_proc_status = TVE_NO_MOVE_ALLOC) THEN
2195: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');

Line 2198: fnd_msg_pub.add;

2194: ELSIF(l_proc_status = TVE_NO_MOVE_ALLOC) THEN
2195: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
2196: fnd_message.set_token('ENTITY1', 'transaction quantity');
2197: fnd_message.set_token('ENTITY2', 'quantity available to move');
2198: fnd_msg_pub.add;
2199: l_errMsg := 'available qty is not enough to fullfill move txn';
2200: raise fnd_api.g_exc_unexpected_error;
2201: ELSIF(l_proc_status = WIP_CONSTANTS.ERROR) THEN
2202: l_errMsg := 'wip_movProc_priv.schedule_alloc failed';

Line 2236: fnd_msg_pub.add;

2232: x_errMessage => l_errMsg);
2233: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2234: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2235: fnd_message.set_token('MESSAGE', l_errMsg);
2236: fnd_msg_pub.add;
2237: raise fnd_api.g_exc_unexpected_error;
2238: END IF;
2239: IF(l_first_bf_op <> -1) THEN
2240: -- check forward transactions

Line 2309: fnd_msg_pub.add;

2305:
2306: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2307: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2308: fnd_message.set_token('MESSAGE', l_errMsg);
2309: fnd_msg_pub.add;
2310: raise fnd_api.g_exc_unexpected_error;
2311: END IF;
2312:
2313: IF(l_first_bf_op <> -1) THEN

Line 2385: fnd_msg_pub.add;

2381: x_errMessage => l_errMsg);
2382: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2383: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2384: fnd_message.set_token('MESSAGE', l_errMsg);
2385: fnd_msg_pub.add;
2386: raise fnd_api.g_exc_unexpected_error;
2387: END IF;
2388: IF(l_first_bf_op <> -1) THEN
2389: wip_bflProc_priv.processRequirements

Line 2446: fnd_msg_pub.add;

2442:
2443: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2444: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2445: fnd_message.set_token('MESSAGE', l_errMsg);
2446: fnd_msg_pub.add;
2447: raise fnd_api.g_exc_unexpected_error;
2448: END IF;
2449: IF(l_first_bf_op <> -1) THEN
2450:

Line 2572: fnd_msg_pub.add;

2568: x_errMessage => l_errMsg);
2569: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2570: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2571: fnd_message.set_token('MESSAGE', l_errMsg);
2572: fnd_msg_pub.add;
2573: raise fnd_api.g_exc_unexpected_error;
2574: END IF;
2575: IF(l_first_bf_op <> -1) THEN
2576: /**

Line 2645: fnd_msg_pub.add;

2641:
2642: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2643: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2644: fnd_message.set_token('MESSAGE', l_errMsg);
2645: fnd_msg_pub.add;
2646: raise fnd_api.g_exc_unexpected_error;
2647: END IF;
2648: IF(l_first_bf_op <> -1) THEN
2649: /**

Line 3188: fnd_msg_pub.add;

3184: x_errMessage => l_errMsg);
3185: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
3186: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3187: fnd_message.set_token('MESSAGE', l_errMsg);
3188: fnd_msg_pub.add;
3189: raise fnd_api.g_exc_unexpected_error;
3190: END IF;
3191: IF(l_first_bf_op <> -1) THEN
3192: wip_bflProc_priv.processRequirements

Line 3242: fnd_msg_pub.add;

3238:
3239: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
3240: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3241: fnd_message.set_token('MESSAGE', l_errMsg);
3242: fnd_msg_pub.add;
3243: raise fnd_api.g_exc_unexpected_error;
3244: END IF;
3245: IF(l_first_bf_op <> -1) THEN
3246: wip_bflProc_priv.processRequirements

Line 3347: fnd_msg_pub.add;

3343: x_errMessage => l_errMsg);
3344: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
3345: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3346: fnd_message.set_token('MESSAGE', l_errMsg);
3347: fnd_msg_pub.add;
3348: raise fnd_api.g_exc_unexpected_error;
3349: END IF;
3350: IF(l_first_bf_op <> -1) THEN
3351: wip_bflProc_priv.processRequirements

Line 3401: fnd_msg_pub.add;

3397:
3398: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
3399: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3400: fnd_message.set_token('MESSAGE', l_errMsg);
3401: fnd_msg_pub.add;
3402: raise fnd_api.g_exc_unexpected_error;
3403: END IF;
3404: IF(l_first_bf_op <> -1) THEN
3405: wip_bflProc_priv.processRequirements