DBA Data[Home] [Help]

APPS.WIP_CPLPROC_PRIV dependencies on FND_MSG_PUB

Line 59: fnd_msg_pub.initialize;

55: begin
56: savepoint wipcplpb20;
57: x_returnStatus := fnd_api.g_ret_sts_success;
58: if(fnd_api.to_boolean(p_initMsgList)) then
59: fnd_msg_pub.initialize;
60: end if;
61:
62: if (l_logLevel <= wip_constants.trace_logging) then
63: l_params(1).paramName := 'p_txnTmpID';

Line 225: fnd_msg_pub.add;

221: if(fnd_api.to_boolean(p_endDebug)) then
222: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
223: end if;
224: fnd_message.set_name('WIP', 'INVALID_MMTT_TEMP_ID');
225: fnd_msg_pub.add;
226: if (l_logLevel <= wip_constants.full_logging) then
227: wip_logger.log(SQLERRM, l_returnStatus);
228: end if;
229: when fnd_api.g_exc_error then --could not derive all lot/serial info for components

Line 255: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',

251: end if;
252: when others then
253: rollback to wipcplpb20;
254: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
255: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
256: p_procedure_name => 'processTemp',
257: p_error_text => SQLERRM);
258: if (l_logLevel <= wip_constants.trace_logging) then
259: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processTemp',

Line 376: fnd_msg_pub.add;

372: l_jobType = WIP_CONSTANTS.STANDARD) then
373: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
374: fnd_message.set_token('ENTITY1', 'total txn qty-cap', true);
375: fnd_message.set_token('ENTITY2', 'job complete quantity', true);
376: fnd_msg_pub.add;
377: l_errMsg := 'not enough quantity to return';
378: raise fnd_api.g_exc_unexpected_error;
379: end if;
380: --return the so reservation to wip

Line 421: fnd_msg_pub.add;

417: for update of quantity_waiting_to_move nowait;
418:
419: if(l_toMoveQty - p_cplRec.priQty < 0) then
420: fnd_message.set_name('WIP', 'WIP_LESS_QTY');
421: fnd_msg_pub.add;
422: l_errMsg := 'not enough qty in to move of last op';
423: raise fnd_api.g_exc_unexpected_error;
424: end if;
425: update wip_operations --lower the quantity available to complete

Line 445: fnd_msg_pub.add;

441: oc_primary_qty := p_cplRec.overCplPriQty;
442: end if;
443: if p_cplRec.priQty - abs(l_qtyAvailToComplete) - oc_primary_qty > 0 then
444: fnd_message.set_name('WIP', 'WIP_LESS_QTY');
445: fnd_msg_pub.add;
446: l_errMsg := 'Quantity required to complete this transaction no longer available';
447: raise fnd_api.g_exc_unexpected_error;
448:
449: end if;

Line 478: fnd_msg_pub.add;

474: p_msg => 'records were locked',
475: x_returnStatus => l_returnStatus); --discard logging return status
476: end if;
477: fnd_message.set_name('INV', 'INV_WIP_WORK_ORDER_LOCKED');
478: fnd_msg_pub.add;
479: when others then
480: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
481: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
482: p_procedure_name => 'processDiscrete',

Line 481: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',

477: fnd_message.set_name('INV', 'INV_WIP_WORK_ORDER_LOCKED');
478: fnd_msg_pub.add;
479: when others then
480: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
481: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
482: p_procedure_name => 'processDiscrete',
483: p_error_text => SQLERRM);
484: if (l_logLevel <= wip_constants.trace_logging) then
485: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processDiscrete',

Line 627: fnd_msg_pub.add;

623:
624: if(l_newSchedQty < 0) then
625: --add check for pending txns here
626: fnd_message.set_name('WIP', 'WIP_LESS_QTY');
627: fnd_msg_pub.add;
628: l_errMsg := 'not enough qty in to move of last op';
629: raise fnd_api.g_exc_unexpected_error;
630: end if;
631: end if;

Line 667: -- fnd_msg_pub.add; --assume error message is still current

663: p_update_status => wip_constants.yes,
664: p_success_flag => l_rollFwdSuccess,
665: p_error_msg => l_errMsg);
666: if(l_rollFwdSuccess <> wip_constants.yes) then
667: -- fnd_msg_pub.add; --assume error message is still current
668: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
669: l_errMsg := 'roll forward failed for schedule ' || l_schedRec.repSchedID;
670: end if;
671: end if;

Line 731: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',

727: x_returnStatus => l_returnStatus); --discard logging return status
728: end if;
729: when others then
730: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
731: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
732: p_procedure_name => 'processRepetitive',
733: p_error_text => SQLERRM);
734: if (l_logLevel <= wip_constants.trace_logging) then
735: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processRepetitive',

Line 796: fnd_msg_pub.add; --assume prev fn used the fnd_message pkg

792: x_first_sched_id => l_firstSchedID,
793: x_last_sched_id => l_lastSchedID,
794: x_error_mesg => l_errMsg);
795: if(l_errMsg <> null) then
796: fnd_msg_pub.add; --assume prev fn used the fnd_message pkg
797: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
798: l_errMsg := 'wip_repetitive_utilities.get_first_last_sched: ' || l_errMsg;
799: raise fnd_api.g_exc_unexpected_error;
800: end if;

Line 813: fnd_msg_pub.add;

809:
810: if(x_returnStatus = wip_constants.no) then
811: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
812: fnd_message.set_name('WIP', 'WIP_OC_TOLERANCE_FAIL');
813: fnd_msg_pub.add;
814: l_errMsg := 'cpl exceeded tolerances';
815: raise fnd_api.g_exc_unexpected_error;
816: else
817: x_returnStatus := fnd_api.g_ret_sts_success;

Line 841: fnd_msg_pub.add;

837:
838: --if insert failed
839: if(l_errMsg is not null) then
840: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
841: fnd_msg_pub.add;
842: l_errMsg := 'wip_overcompletion.insert_oc_move_txn: ' || l_errMsg;
843: raise fnd_api.g_exc_unexpected_error;
844: end if;
845:

Line 903: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',

899: x_returnStatus => l_returnStatus); --discard logging return status
900: end if;
901: when others then
902: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
903: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
904: p_procedure_name => 'processOverCpl',
905: p_error_text => SQLERRM);
906: if (l_logLevel <= wip_constants.trace_logging) then
907: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOverCpl',

Line 1175: fnd_msg_pub.add;

1171: --if the revisions don't match...
1172: if(l_schedRecTbl.bomRev(j) <> l_txnRecTbl.revision(i) and
1173: (l_schedRecTbl.bomRev(j) is not null or l_txnRecTbl.revision(i) is not null)) then
1174: fnd_message.set_name('WIP', 'WIP_SCHED_MULTIPLE_BILL_REV');
1175: fnd_msg_pub.add;
1176: l_errMsg := 'Schedules have different bill revisions.'; --set message in case it fails
1177: raise fnd_api.g_exc_unexpected_error;
1178: end if;
1179:

Line 1232: fnd_msg_pub.add;

1228: if(l_lastSchedID is null) then
1229: /* Fix for bug 5373061: Passed missing token */
1230: fnd_message.set_name('WIP', 'WIP_INT_ERROR_NO_SCHED');
1231: fnd_message.set_token('ROUTINE', 'wip_cplProc_priv.preAllocateSchedules');
1232: fnd_msg_pub.add;
1233: l_errMsg := 'did not find any schedules.';
1234: raise fnd_api.g_exc_unexpected_error; -- couldn't find any open schedules
1235: end if;
1236:

Line 1263: fnd_msg_pub.add;

1259: if(p_txnActionID <> wip_constants.retassy_action) then
1260: if(l_txnRecTbl.overCplQty(i) IS NULL) then
1261: fnd_message.set_name('WIP', 'WIP_INT_ERROR_NO_SCHED');
1262: fnd_message.set_token('ROUTINE', 'wip_cplProc_priv.preAllocateSchedules');
1263: fnd_msg_pub.add;
1264: l_errMsg := 'did not find any schedules.';
1265: raise fnd_api.g_exc_unexpected_error; -- couldn't find any open schedules
1266: end if;
1267: end if; /*Fix for Bug#6018877 - FP of bug#6004763*/

Line 1333: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',

1329: x_returnStatus => l_returnStatus); --discard logging return status
1330: end if;
1331: when others then
1332: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1333: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
1334: p_procedure_name => 'preAllocateSchedules',
1335: p_error_text => SQLERRM);
1336: if (l_logLevel <= wip_constants.trace_logging) then
1337: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',

Line 1591: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',

1587: end if;
1588: when others then
1589: rollback to wipcplpb40;
1590: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1591: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
1592: p_procedure_name => 'preAllocateSchedules',
1593: p_error_text => SQLERRM);
1594: if (l_logLevel <= wip_constants.trace_logging) then
1595: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',

Line 1745: fnd_msg_pub.add;

1741: err_msg => l_error_msg);
1742: IF(l_ret_value <> 1) THEN
1743: fnd_message.set_name(application => 'CST',
1744: name => 'CST_SNAPSHOT_FAILED');
1745: fnd_msg_pub.add;
1746: raise fnd_api.g_exc_unexpected_error;
1747: END IF;
1748: END IF;
1749:

Line 1825: fnd_msg_pub.add;

1821:
1822: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1823: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1824: fnd_message.set_token('MESSAGE', l_error_msg);
1825: fnd_msg_pub.add;
1826: raise fnd_api.g_exc_unexpected_error;
1827: END IF;
1828:
1829: l_process_phase := '8';

Line 1903: fnd_msg_pub.add;

1899: SQLCODE;
1900:
1901: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1902: fnd_message.set_token('MESSAGE', l_error_msg);
1903: fnd_msg_pub.add;
1904:
1905: IF (l_log_level <= wip_constants.trace_logging) THEN
1906: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOATxn',
1907: p_procReturnStatus => x_returnStatus,