61:
62: EXCEPTION
63: when others then
64: status := -1;
65: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
66: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecord');
67: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
68: errMessage := fnd_message.get;
69: if (l_logLevel <= wip_constants.trace_logging) then
62: EXCEPTION
63: when others then
64: status := -1;
65: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
66: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecord');
67: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
68: errMessage := fnd_message.get;
69: if (l_logLevel <= wip_constants.trace_logging) then
70: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',
63: when others then
64: status := -1;
65: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
66: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecord');
67: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
68: errMessage := fnd_message.get;
69: if (l_logLevel <= wip_constants.trace_logging) then
70: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',
71: p_procReturnStatus => status,
64: status := -1;
65: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
66: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecord');
67: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
68: errMessage := fnd_message.get;
69: if (l_logLevel <= wip_constants.trace_logging) then
70: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',
71: p_procReturnStatus => status,
72: p_msg => errMessage,
132:
133: EXCEPTION
134: when others then
135: status := -1;
136: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
137: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecordintoMMTT');
138: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
139: errMessage := fnd_message.get;
140: if (l_logLevel <= wip_constants.trace_logging) then
133: EXCEPTION
134: when others then
135: status := -1;
136: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
137: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecordintoMMTT');
138: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
139: errMessage := fnd_message.get;
140: if (l_logLevel <= wip_constants.trace_logging) then
141: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
134: when others then
135: status := -1;
136: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
137: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecordintoMMTT');
138: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
139: errMessage := fnd_message.get;
140: if (l_logLevel <= wip_constants.trace_logging) then
141: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
142: p_procReturnStatus => status,
135: status := -1;
136: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
137: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecordintoMMTT');
138: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
139: errMessage := fnd_message.get;
140: if (l_logLevel <= wip_constants.trace_logging) then
141: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
142: p_procReturnStatus => status,
143: p_msg => errMessage,
196: errClass2);
197:
198: -- If there is no WIP defaulting accounting class, error out
199: if(accountingClass is null) then
200: fnd_message.set_name(
201: application => 'WIP',
202: name => 'WIP_NO_DEFAULT_CLASSES');
203: errMsg := fnd_message.get;
204: return false;
199: if(accountingClass is null) then
200: fnd_message.set_name(
201: application => 'WIP',
202: name => 'WIP_NO_DEFAULT_CLASSES');
203: errMsg := fnd_message.get;
204: return false;
205: end if;
206:
207: -- get the accounting period
211: period_id => periodID,
212: open_past_period => openPastPeriod);
213:
214: if (periodID = -1 or periodID = 0) then
215: fnd_message.set_name(
216: application => 'INV',
217: name => 'INV_NO_OPEN_PERIOD');
218: errMsg := fnd_message.get;
219: return false;
214: if (periodID = -1 or periodID = 0) then
215: fnd_message.set_name(
216: application => 'INV',
217: name => 'INV_NO_OPEN_PERIOD');
218: errMsg := fnd_message.get;
219: return false;
220: end if;
221:
222: -- default schedule number, it is the value read from profile option 'WIP_JOB_PREFIX'
495: return true;
496:
497: EXCEPTION
498: when others then
499: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
500: fnd_message.set_token ('FUNCTION', 'wma_flow.put');
501: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
502: errMsg := fnd_message.get;
503: return false;
496:
497: EXCEPTION
498: when others then
499: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
500: fnd_message.set_token ('FUNCTION', 'wma_flow.put');
501: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
502: errMsg := fnd_message.get;
503: return false;
504: End put;
497: EXCEPTION
498: when others then
499: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
500: fnd_message.set_token ('FUNCTION', 'wma_flow.put');
501: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
502: errMsg := fnd_message.get;
503: return false;
504: End put;
505:
498: when others then
499: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
500: fnd_message.set_token ('FUNCTION', 'wma_flow.put');
501: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
502: errMsg := fnd_message.get;
503: return false;
504: End put;
505:
506: Function putIntoMMTT(flowRec FlowRecord, errMsg OUT NOCOPY VARCHAR2) return boolean IS
970: return true;
971:
972: EXCEPTION
973: when others then
974: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
975: fnd_message.set_token ('FUNCTION', 'wma_flow.putIntoMMTT');
976: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
977: errMsg := fnd_message.get;
978: return false;
971:
972: EXCEPTION
973: when others then
974: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
975: fnd_message.set_token ('FUNCTION', 'wma_flow.putIntoMMTT');
976: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
977: errMsg := fnd_message.get;
978: return false;
979: End putIntoMMTT;
972: EXCEPTION
973: when others then
974: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
975: fnd_message.set_token ('FUNCTION', 'wma_flow.putIntoMMTT');
976: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
977: errMsg := fnd_message.get;
978: return false;
979: End putIntoMMTT;
980:
973: when others then
974: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
975: fnd_message.set_token ('FUNCTION', 'wma_flow.putIntoMMTT');
976: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
977: errMsg := fnd_message.get;
978: return false;
979: End putIntoMMTT;
980:
981: procedure explodeBOMAndDerive(p_assyID in number,