106: x_returnStatus => l_returnStatus);
107: end if;
108: when others then
109: status := -1;
110: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
111: fnd_message.set_token ('FUNCTION', 'wma_material.process');
112: fnd_message.set_token ('ERROR', SQLERRM);
113: errMessage := fnd_message.get;
114: if (l_logLevel <= wip_constants.trace_logging) then
107: end if;
108: when others then
109: status := -1;
110: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
111: fnd_message.set_token ('FUNCTION', 'wma_material.process');
112: fnd_message.set_token ('ERROR', SQLERRM);
113: errMessage := fnd_message.get;
114: if (l_logLevel <= wip_constants.trace_logging) then
115: wip_logger.exitPoint(p_procName => 'wma_material.process',
108: when others then
109: status := -1;
110: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
111: fnd_message.set_token ('FUNCTION', 'wma_material.process');
112: fnd_message.set_token ('ERROR', SQLERRM);
113: errMessage := fnd_message.get;
114: if (l_logLevel <= wip_constants.trace_logging) then
115: wip_logger.exitPoint(p_procName => 'wma_material.process',
116: p_procReturnStatus => status,
109: status := -1;
110: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
111: fnd_message.set_token ('FUNCTION', 'wma_material.process');
112: fnd_message.set_token ('ERROR', SQLERRM);
113: errMessage := fnd_message.get;
114: if (l_logLevel <= wip_constants.trace_logging) then
115: wip_logger.exitPoint(p_procName => 'wma_material.process',
116: p_procReturnStatus => status,
117: p_msg => errMessage,
140: Begin
141:
142: job := wma_derive.getJob(param.jobID);
143: if (job.wipEntityID is null) then
144: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
145: fnd_message.set_token('INTERFACE', 'wma_material.derive', TRUE);
146: errMsg := fnd_message.get;
147: return false;
148: end if;
141:
142: job := wma_derive.getJob(param.jobID);
143: if (job.wipEntityID is null) then
144: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
145: fnd_message.set_token('INTERFACE', 'wma_material.derive', TRUE);
146: errMsg := fnd_message.get;
147: return false;
148: end if;
149:
142: job := wma_derive.getJob(param.jobID);
143: if (job.wipEntityID is null) then
144: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
145: fnd_message.set_token('INTERFACE', 'wma_material.derive', TRUE);
146: errMsg := fnd_message.get;
147: return false;
148: end if;
149:
150: item := wma_derive.getItem(param.itemID,
165: 'SPECIFIC',
166: 'N',
167: job.projectID,
168: job.taskID) = false ) then
169: errMsg := FND_MESSAGE.get;
170: return false;
171: end if;
172:
173: --Bug12912518 Shouldn't allow Same Assembly item to be issued to itself as Component for standard WO
174: --which is consistent with Form/MES
175: if (job.primaryItemID is not null
176: AND job.primaryItemID = item.invItemID
177: AND job.jobType = 1) then -- for standard Job don't allow issue assembly as components
178: fnd_message.set_name ('WIP', 'WIP_NO_SAME_ASSEMBLY_ISSUE');
179: errMsg := fnd_message.get;
180: return false;
181: end if;
182:
175: if (job.primaryItemID is not null
176: AND job.primaryItemID = item.invItemID
177: AND job.jobType = 1) then -- for standard Job don't allow issue assembly as components
178: fnd_message.set_name ('WIP', 'WIP_NO_SAME_ASSEMBLY_ISSUE');
179: errMsg := fnd_message.get;
180: return false;
181: end if;
182:
183: -- get the accounting period
187: period_id => periodID,
188: open_past_period => openPastPeriod);
189:
190: if (periodID = -1 or periodID = 0) then
191: fnd_message.set_name(
192: application => 'INV',
193: name => 'INV_NO_OPEN_PERIOD');
194: errMsg := fnd_message.get;
195: return false;
190: if (periodID = -1 or periodID = 0) then
191: fnd_message.set_name(
192: application => 'INV',
193: name => 'INV_NO_OPEN_PERIOD');
194: errMsg := fnd_message.get;
195: return false;
196: end if;
197:
198: mtlRec.final_completion_flag := 'N';
421: return true;
422:
423: EXCEPTION
424: when others then
425: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
426: fnd_message.set_token ('FUNCTION', 'wma_material.derive');
427: fnd_message.set_token ('ERROR', SQLERRM);
428: errMsg := fnd_message.get;
429: return false;
422:
423: EXCEPTION
424: when others then
425: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
426: fnd_message.set_token ('FUNCTION', 'wma_material.derive');
427: fnd_message.set_token ('ERROR', SQLERRM);
428: errMsg := fnd_message.get;
429: return false;
430: End put;
423: EXCEPTION
424: when others then
425: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
426: fnd_message.set_token ('FUNCTION', 'wma_material.derive');
427: fnd_message.set_token ('ERROR', SQLERRM);
428: errMsg := fnd_message.get;
429: return false;
430: End put;
431:
424: when others then
425: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
426: fnd_message.set_token ('FUNCTION', 'wma_material.derive');
427: fnd_message.set_token ('ERROR', SQLERRM);
428: errMsg := fnd_message.get;
429: return false;
430: End put;
431:
432: /**
437: txnQty NUMBER,
438: errMessage OUT NOCOPY VARCHAR2) RETURN boolean IS
439: Begin
440: if ( txnQty <= 0 ) then
441: fnd_message.set_name('INV', 'INV_GREATER_THAN_ZERO');
442: errMessage := fnd_message.get;
443: return false;
444: end if;
445:
438: errMessage OUT NOCOPY VARCHAR2) RETURN boolean IS
439: Begin
440: if ( txnQty <= 0 ) then
441: fnd_message.set_name('INV', 'INV_GREATER_THAN_ZERO');
442: errMessage := fnd_message.get;
443: return false;
444: end if;
445:
446: return true;
507: x_projectID := null;
508: x_taskID := null;
509: x_projectNum := null;
510: x_taskNum := null;
511: fnd_message.set_name('WIP', 'JOB_NOT_PROJ_CNTL');
512: x_returnMsg := fnd_message.get;
513: return;
514: end if;
515:
508: x_taskID := null;
509: x_projectNum := null;
510: x_taskNum := null;
511: fnd_message.set_name('WIP', 'JOB_NOT_PROJ_CNTL');
512: x_returnMsg := fnd_message.get;
513: return;
514: end if;
515:
516:
547: x_projectID := null;
548: x_taskID := null;
549: x_projectNum := null;
550: x_taskNum := null;
551: fnd_message.set_name('WIP', 'INVALID_SER_PROJECT_TASK');
552: x_returnMsg := fnd_message.get;
553: end validateIssueProject;
554:
555:
548: x_taskID := null;
549: x_projectNum := null;
550: x_taskNum := null;
551: fnd_message.set_name('WIP', 'INVALID_SER_PROJECT_TASK');
552: x_returnMsg := fnd_message.get;
553: end validateIssueProject;
554:
555:
556: END wma_material;