DBA Data[Home] [Help]

APPS.WIP_BFLPROC_PRIV dependencies on FND_MSG_PUB

Line 292: fnd_msg_pub.initialize;

288: l_created_by NUMBER ;/* Fix for #Bug 5444243 */
289: begin
290: savepoint wipbflpb20;
291: if(fnd_api.to_boolean(p_initMsgList)) then
292: fnd_msg_pub.initialize;
293: end if;
294:
295: if (l_logLevel <= wip_constants.trace_logging) then
296: l_params(1).paramName := 'p_wipEntityID';

Line 377: fnd_msg_pub.add;

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

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

830: end if;
831: when others then
832: rollback to wipbflpb20;
833: x_returnStatus := fnd_api.g_ret_sts_unexp_error;--unexpec error if exception occurs
834: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_bflProc_priv',
835: p_procedure_name => 'processRequirements',
836: p_error_text => SQLERRM);
837: if (l_logLevel <= wip_constants.trace_logging) then
838: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.processRequirements',

Line 998: fnd_msg_pub.initialize;

994: begin
995: savepoint wipbflpb30;
996:
997: if(fnd_api.to_boolean(p_initMsgList)) then
998: fnd_msg_pub.initialize;
999: end if;
1000:
1001: if (l_logLevel <= wip_constants.trace_logging) then
1002: l_params(1).paramName := 'p_itemID';

Line 1106: fnd_msg_pub.add;

1102: and msi.inventory_item_id = p_itemID;
1103: exception
1104: when no_data_found then --assume bom parameters not defined. the item_id should be valid.
1105: fnd_message.set_name('BOM', 'BOM_PARAMETER_SETUP');
1106: fnd_msg_pub.add;
1107: l_errMsg := 'no bom parameters';
1108: raise fnd_api.g_exc_unexpected_error;
1109: end;
1110:

Line 1155: fnd_msg_pub.add;

1151: end if;
1152: if(l_errCode <> 0) then
1153: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1154: fnd_message.set_token('MESSAGE', l_msgData);
1155: fnd_msg_pub.add;
1156: l_errMsg := 'BOM exploder failed';
1157: raise fnd_api.g_exc_unexpected_error;
1158: end if;
1159:

Line 1166: fnd_msg_pub.add;

1162: where group_id = l_grpID and loop_flag=1;
1163:
1164: if(l_errCode <> 0) then
1165: fnd_message.set_name('WIP', 'WIP_BOM_LOOP');
1166: fnd_msg_pub.add;
1167: l_errMsg := 'Loop In BOM Encountered';
1168: raise fnd_api.g_exc_unexpected_error;
1169: end if;
1170:

Line 1465: fnd_msg_pub.add;

1461: rollback to wipbflpb30;
1462: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1463: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1464: fnd_message.set_token('ERROR_TEXT', SQLERRM);
1465: fnd_msg_pub.add;
1466: if (l_logLevel <= wip_constants.trace_logging) then
1467: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',
1468: p_procReturnStatus => x_returnStatus,
1469: p_msg => 'unexpected error: ' || SQLERRM,

Line 1783: fnd_msg_pub.add;

1779: END IF;
1780:
1781: IF(l_proc_status = TVE_OVERCOMPLETION_MISMATCH) THEN
1782: fnd_message.set_name('WIP', 'WIP_OVERCOMPLETION_MISMATCH');
1783: fnd_msg_pub.add;
1784: l_errMsg := 'parent txn is not really overcompletion txn';
1785: raise fnd_api.g_exc_unexpected_error;
1786: ELSIF(l_proc_status = TVE_NO_MOVE_ALLOC) THEN
1787: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');

Line 1790: fnd_msg_pub.add;

1786: ELSIF(l_proc_status = TVE_NO_MOVE_ALLOC) THEN
1787: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1788: fnd_message.set_token('ENTITY1', 'transaction quantity');
1789: fnd_message.set_token('ENTITY2', 'quantity available to move');
1790: fnd_msg_pub.add;
1791: l_errMsg := 'available qty is not enough to fullfill move txn';
1792: raise fnd_api.g_exc_unexpected_error;
1793: ELSIF(l_proc_status = WIP_CONSTANTS.ERROR) THEN
1794: l_errMsg := 'wip_movProc_priv.schedule_alloc failed';

Line 1832: fnd_msg_pub.add;

1828: x_errMessage => l_errMsg);
1829: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
1830: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1831: fnd_message.set_token('MESSAGE', l_errMsg);
1832: fnd_msg_pub.add;
1833: raise fnd_api.g_exc_unexpected_error;
1834: END IF;
1835:
1836: IF(l_first_bf_op <> -1) THEN

Line 1907: fnd_msg_pub.add;

1903:
1904: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
1905: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1906: fnd_message.set_token('MESSAGE', l_errMsg);
1907: fnd_msg_pub.add;
1908: raise fnd_api.g_exc_unexpected_error;
1909: END IF;
1910:
1911: IF(l_first_bf_op <> -1) THEN

Line 2006: fnd_msg_pub.add;

2002: END IF;
2003:
2004: IF(l_proc_status = TVE_OVERCOMPLETION_MISMATCH) THEN
2005: fnd_message.set_name('WIP', 'WIP_OVERCOMPLETION_MISMATCH');
2006: fnd_msg_pub.add;
2007: l_errMsg := 'parent txn is not really overcompletion txn';
2008: raise fnd_api.g_exc_unexpected_error;
2009: ELSIF(l_proc_status = TVE_NO_MOVE_ALLOC) THEN
2010: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');

Line 2013: fnd_msg_pub.add;

2009: ELSIF(l_proc_status = TVE_NO_MOVE_ALLOC) THEN
2010: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
2011: fnd_message.set_token('ENTITY1', 'transaction quantity');
2012: fnd_message.set_token('ENTITY2', 'quantity available to move');
2013: fnd_msg_pub.add;
2014: l_errMsg := 'available qty is not enough to fullfill move txn';
2015: raise fnd_api.g_exc_unexpected_error;
2016: ELSIF(l_proc_status = WIP_CONSTANTS.ERROR) THEN
2017: l_errMsg := 'wip_movProc_priv.schedule_alloc failed';

Line 2139: fnd_msg_pub.add;

2135: END IF;
2136:
2137: IF(l_proc_status = TVE_OVERCOMPLETION_MISMATCH) THEN
2138: fnd_message.set_name('WIP', 'WIP_OVERCOMPLETION_MISMATCH');
2139: fnd_msg_pub.add;
2140: l_errMsg := 'parent txn is not really overcompletion txn';
2141: raise fnd_api.g_exc_unexpected_error;
2142: ELSIF(l_proc_status = TVE_NO_MOVE_ALLOC) THEN
2143: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');

Line 2146: fnd_msg_pub.add;

2142: ELSIF(l_proc_status = TVE_NO_MOVE_ALLOC) THEN
2143: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
2144: fnd_message.set_token('ENTITY1', 'transaction quantity');
2145: fnd_message.set_token('ENTITY2', 'quantity available to move');
2146: fnd_msg_pub.add;
2147: l_errMsg := 'available qty is not enough to fullfill move txn';
2148: raise fnd_api.g_exc_unexpected_error;
2149: ELSIF(l_proc_status = WIP_CONSTANTS.ERROR) THEN
2150: l_errMsg := 'wip_movProc_priv.schedule_alloc failed';

Line 2184: fnd_msg_pub.add;

2180: x_errMessage => l_errMsg);
2181: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2182: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2183: fnd_message.set_token('MESSAGE', l_errMsg);
2184: fnd_msg_pub.add;
2185: raise fnd_api.g_exc_unexpected_error;
2186: END IF;
2187: IF(l_first_bf_op <> -1) THEN
2188: -- check forward transactions

Line 2257: fnd_msg_pub.add;

2253:
2254: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2255: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2256: fnd_message.set_token('MESSAGE', l_errMsg);
2257: fnd_msg_pub.add;
2258: raise fnd_api.g_exc_unexpected_error;
2259: END IF;
2260:
2261: IF(l_first_bf_op <> -1) THEN

Line 2333: fnd_msg_pub.add;

2329: x_errMessage => l_errMsg);
2330: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2331: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2332: fnd_message.set_token('MESSAGE', l_errMsg);
2333: fnd_msg_pub.add;
2334: raise fnd_api.g_exc_unexpected_error;
2335: END IF;
2336: IF(l_first_bf_op <> -1) THEN
2337: wip_bflProc_priv.processRequirements

Line 2394: fnd_msg_pub.add;

2390:
2391: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2392: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2393: fnd_message.set_token('MESSAGE', l_errMsg);
2394: fnd_msg_pub.add;
2395: raise fnd_api.g_exc_unexpected_error;
2396: END IF;
2397: IF(l_first_bf_op <> -1) THEN
2398:

Line 2520: fnd_msg_pub.add;

2516: x_errMessage => l_errMsg);
2517: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2518: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2519: fnd_message.set_token('MESSAGE', l_errMsg);
2520: fnd_msg_pub.add;
2521: raise fnd_api.g_exc_unexpected_error;
2522: END IF;
2523: IF(l_first_bf_op <> -1) THEN
2524: /**

Line 2586: fnd_msg_pub.add;

2582:
2583: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2584: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2585: fnd_message.set_token('MESSAGE', l_errMsg);
2586: fnd_msg_pub.add;
2587: raise fnd_api.g_exc_unexpected_error;
2588: END IF;
2589: IF(l_first_bf_op <> -1) THEN
2590: /**

Line 3079: fnd_msg_pub.add;

3075: x_errMessage => l_errMsg);
3076: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
3077: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3078: fnd_message.set_token('MESSAGE', l_errMsg);
3079: fnd_msg_pub.add;
3080: raise fnd_api.g_exc_unexpected_error;
3081: END IF;
3082: IF(l_first_bf_op <> -1) THEN
3083: wip_bflProc_priv.processRequirements

Line 3133: fnd_msg_pub.add;

3129:
3130: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
3131: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3132: fnd_message.set_token('MESSAGE', l_errMsg);
3133: fnd_msg_pub.add;
3134: raise fnd_api.g_exc_unexpected_error;
3135: END IF;
3136: IF(l_first_bf_op <> -1) THEN
3137: wip_bflProc_priv.processRequirements

Line 3238: fnd_msg_pub.add;

3234: x_errMessage => l_errMsg);
3235: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
3236: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3237: fnd_message.set_token('MESSAGE', l_errMsg);
3238: fnd_msg_pub.add;
3239: raise fnd_api.g_exc_unexpected_error;
3240: END IF;
3241: IF(l_first_bf_op <> -1) THEN
3242: wip_bflProc_priv.processRequirements

Line 3292: fnd_msg_pub.add;

3288:
3289: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
3290: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3291: fnd_message.set_token('MESSAGE', l_errMsg);
3292: fnd_msg_pub.add;
3293: raise fnd_api.g_exc_unexpected_error;
3294: END IF;
3295: IF(l_first_bf_op <> -1) THEN
3296: wip_bflProc_priv.processRequirements