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 399: fnd_msg_pub.add;

395: l_jobType = WIP_CONSTANTS.STANDARD) then
396: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
397: fnd_message.set_token('ENTITY1', 'total txn qty-cap', true);
398: fnd_message.set_token('ENTITY2', 'job complete quantity', true);
399: fnd_msg_pub.add;
400: l_errMsg := 'not enough quantity to return';
401: raise fnd_api.g_exc_unexpected_error;
402: end if;
403: --return the so reservation to wip

Line 444: fnd_msg_pub.add;

440: for update of quantity_waiting_to_move nowait;
441:
442: if(l_toMoveQty - p_cplRec.priQty < 0) then
443: fnd_message.set_name('WIP', 'WIP_LESS_QTY');
444: fnd_msg_pub.add;
445: l_errMsg := 'not enough qty in to move of last op';
446: raise fnd_api.g_exc_unexpected_error;
447: end if;
448: update wip_operations --lower the quantity available to complete

Line 468: fnd_msg_pub.add;

464: oc_primary_qty := p_cplRec.overCplPriQty;
465: end if;
466: if p_cplRec.priQty - abs(l_qtyAvailToComplete) - oc_primary_qty > 0 then
467: fnd_message.set_name('WIP', 'WIP_LESS_QTY');
468: fnd_msg_pub.add;
469: l_errMsg := 'Quantity required to complete this transaction no longer available';
470: raise fnd_api.g_exc_unexpected_error;
471:
472: end if;

Line 503: fnd_msg_pub.add;

499: end if;
500: select WIP_ENTITY_NAME into l_job_name from wip_entities where WIP_ENTITY_ID = p_cplRec.wipEntityID;
501: fnd_message.set_name('WIP', 'WIP_WORK_ORDER_LOCKED');
502: fnd_message.set_token('JOBNAME', l_job_name);
503: fnd_msg_pub.add;
504: when others then
505: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
506: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
507: p_procedure_name => 'processDiscrete',

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

502: fnd_message.set_token('JOBNAME', l_job_name);
503: fnd_msg_pub.add;
504: when others then
505: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
506: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
507: p_procedure_name => 'processDiscrete',
508: p_error_text => SQLERRM);
509: if (l_logLevel <= wip_constants.trace_logging) then
510: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processDiscrete',

Line 652: fnd_msg_pub.add;

648:
649: if(l_newSchedQty < 0) then
650: --add check for pending txns here
651: fnd_message.set_name('WIP', 'WIP_LESS_QTY');
652: fnd_msg_pub.add;
653: l_errMsg := 'not enough qty in to move of last op';
654: raise fnd_api.g_exc_unexpected_error;
655: end if;
656: end if;

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

688: p_update_status => wip_constants.yes,
689: p_success_flag => l_rollFwdSuccess,
690: p_error_msg => l_errMsg);
691: if(l_rollFwdSuccess <> wip_constants.yes) then
692: -- fnd_msg_pub.add; --assume error message is still current
693: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
694: l_errMsg := 'roll forward failed for schedule ' || l_schedRec.repSchedID;
695: end if;
696: end if;

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

753: x_returnStatus => l_returnStatus); --discard logging return status
754: end if;
755: when others then
756: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
757: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
758: p_procedure_name => 'processRepetitive',
759: p_error_text => SQLERRM);
760: if (l_logLevel <= wip_constants.trace_logging) then
761: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processRepetitive',

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

818: x_first_sched_id => l_firstSchedID,
819: x_last_sched_id => l_lastSchedID,
820: x_error_mesg => l_errMsg);
821: if(l_errMsg <> null) then
822: fnd_msg_pub.add; --assume prev fn used the fnd_message pkg
823: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
824: l_errMsg := 'wip_repetitive_utilities.get_first_last_sched: ' || l_errMsg;
825: raise fnd_api.g_exc_unexpected_error;
826: end if;

Line 839: fnd_msg_pub.add;

835:
836: if(x_returnStatus = wip_constants.no) then
837: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
838: fnd_message.set_name('WIP', 'WIP_OC_TOLERANCE_FAIL');
839: fnd_msg_pub.add;
840: l_errMsg := 'cpl exceeded tolerances';
841: raise fnd_api.g_exc_unexpected_error;
842: else
843: x_returnStatus := fnd_api.g_ret_sts_success;

Line 867: fnd_msg_pub.add;

863:
864: --if insert failed
865: if(l_errMsg is not null) then
866: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
867: fnd_msg_pub.add;
868: l_errMsg := 'wip_overcompletion.insert_oc_move_txn: ' || l_errMsg;
869: raise fnd_api.g_exc_unexpected_error;
870: end if;
871:

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

925: x_returnStatus => l_returnStatus); --discard logging return status
926: end if;
927: when others then
928: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
929: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
930: p_procedure_name => 'processOverCpl',
931: p_error_text => SQLERRM);
932: if (l_logLevel <= wip_constants.trace_logging) then
933: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOverCpl',

Line 1201: fnd_msg_pub.add;

1197: --if the revisions don't match...
1198: if(l_schedRecTbl.bomRev(j) <> l_txnRecTbl.revision(i) and
1199: (l_schedRecTbl.bomRev(j) is not null or l_txnRecTbl.revision(i) is not null)) then
1200: fnd_message.set_name('WIP', 'WIP_SCHED_MULTIPLE_BILL_REV');
1201: fnd_msg_pub.add;
1202: l_errMsg := 'Schedules have different bill revisions.'; --set message in case it fails
1203: raise fnd_api.g_exc_unexpected_error;
1204: end if;
1205:

Line 1258: fnd_msg_pub.add;

1254: if(l_lastSchedID is null) then
1255: /* Fix for bug 5373061: Passed missing token */
1256: fnd_message.set_name('WIP', 'WIP_INT_ERROR_NO_SCHED');
1257: fnd_message.set_token('ROUTINE', 'wip_cplProc_priv.preAllocateSchedules');
1258: fnd_msg_pub.add;
1259: l_errMsg := 'did not find any schedules.';
1260: raise fnd_api.g_exc_unexpected_error; -- couldn't find any open schedules
1261: end if;
1262:

Line 1289: fnd_msg_pub.add;

1285: if(p_txnActionID <> wip_constants.retassy_action) then
1286: if(l_txnRecTbl.overCplQty(i) IS NULL) then
1287: fnd_message.set_name('WIP', 'WIP_INT_ERROR_NO_SCHED');
1288: fnd_message.set_token('ROUTINE', 'wip_cplProc_priv.preAllocateSchedules');
1289: fnd_msg_pub.add;
1290: l_errMsg := 'did not find any schedules.';
1291: raise fnd_api.g_exc_unexpected_error; -- couldn't find any open schedules
1292: end if;
1293: end if; /*Fix for Bug#6018877 - FP of bug#6004763*/

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

1355: x_returnStatus => l_returnStatus); --discard logging return status
1356: end if;
1357: when others then
1358: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1359: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
1360: p_procedure_name => 'preAllocateSchedules',
1361: p_error_text => SQLERRM);
1362: if (l_logLevel <= wip_constants.trace_logging) then
1363: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',

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

1613: end if;
1614: when others then
1615: rollback to wipcplpb40;
1616: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1617: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',
1618: p_procedure_name => 'preAllocateSchedules',
1619: p_error_text => SQLERRM);
1620: if (l_logLevel <= wip_constants.trace_logging) then
1621: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.preAllocateSchedules',

Line 1879: fnd_msg_pub.add;

1875: err_msg => l_error_msg);
1876: IF(l_ret_value <> 1) THEN
1877: fnd_message.set_name(application => 'CST',
1878: name => 'CST_SNAPSHOT_FAILED');
1879: fnd_msg_pub.add;
1880: raise fnd_api.g_exc_unexpected_error;
1881: END IF;
1882: END IF;
1883:

Line 1959: fnd_msg_pub.add;

1955:
1956: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1957: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1958: fnd_message.set_token('MESSAGE', l_error_msg);
1959: fnd_msg_pub.add;
1960: raise fnd_api.g_exc_unexpected_error;
1961: END IF;
1962:
1963: l_process_phase := '8';

Line 2037: fnd_msg_pub.add;

2033: SQLCODE;
2034:
2035: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2036: fnd_message.set_token('MESSAGE', l_error_msg);
2037: fnd_msg_pub.add;
2038:
2039: IF (l_log_level <= wip_constants.trace_logging) THEN
2040: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOATxn',
2041: p_procReturnStatus => x_returnStatus,