28:
29: EXCEPTION
30: when others then
31: status := -1;
32: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
33: fnd_message.set_token ('FUNCTION', 'wma_cfm.process');
34: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
35: errMessage := fnd_message.get;
36: End process;
29: EXCEPTION
30: when others then
31: status := -1;
32: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
33: fnd_message.set_token ('FUNCTION', 'wma_cfm.process');
34: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
35: errMessage := fnd_message.get;
36: End process;
37:
30: when others then
31: status := -1;
32: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
33: fnd_message.set_token ('FUNCTION', 'wma_cfm.process');
34: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
35: errMessage := fnd_message.get;
36: End process;
37:
38: PROCEDURE process(lpnParam IN LpnCfmParam,
31: status := -1;
32: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
33: fnd_message.set_token ('FUNCTION', 'wma_cfm.process');
34: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
35: errMessage := fnd_message.get;
36: End process;
37:
38: PROCEDURE process(lpnParam IN LpnCfmParam,
39: status OUT NOCOPY NUMBER,
55:
56: EXCEPTION
57: when others then
58: status := -1;
59: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
60: fnd_message.set_token ('FUNCTION', 'wma_cfm.process');
61: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
62: errMessage := fnd_message.get;
63: End process;
56: EXCEPTION
57: when others then
58: status := -1;
59: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
60: fnd_message.set_token ('FUNCTION', 'wma_cfm.process');
61: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
62: errMessage := fnd_message.get;
63: End process;
64:
57: when others then
58: status := -1;
59: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
60: fnd_message.set_token ('FUNCTION', 'wma_cfm.process');
61: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
62: errMessage := fnd_message.get;
63: End process;
64:
65: /**
58: status := -1;
59: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
60: fnd_message.set_token ('FUNCTION', 'wma_cfm.process');
61: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
62: errMessage := fnd_message.get;
63: End process;
64:
65: /**
66: * This function is used to derive the neccessary information to filled out
126: period_id => periodID,
127: open_past_period => openPastPeriod);
128:
129: if (periodID = -1 or periodID = 0) then
130: fnd_message.set_name(
131: application => 'INV',
132: name => 'INV_NO_OPEN_PERIOD');
133: errMsg := fnd_message.get;
134: return false;
129: if (periodID = -1 or periodID = 0) then
130: fnd_message.set_name(
131: application => 'INV',
132: name => 'INV_NO_OPEN_PERIOD');
133: errMsg := fnd_message.get;
134: return false;
135: end if;
136:
137: -- default schedule number, it is the value read from profile option 'WIP_JOB_PREFIX'
306: Begin
307:
308: -- validate the qty to make sure it is greater than zero.
309: if ( lpnParam.transactionQty <= 0 ) then
310: fnd_message.set_name('INV', 'INV_GREATER_THAN_ZERO');
311: errMsg := fnd_message.get;
312: return false;
313: end if;
314:
307:
308: -- validate the qty to make sure it is greater than zero.
309: if ( lpnParam.transactionQty <= 0 ) then
310: fnd_message.set_name('INV', 'INV_GREATER_THAN_ZERO');
311: errMsg := fnd_message.get;
312: return false;
313: end if;
314:
315: assembly := wma_derive.getItem(lpnParam.assemblyID,
350: period_id => periodID,
351: open_past_period => openPastPeriod);
352:
353: if (periodID = -1 or periodID = 0) then
354: fnd_message.set_name(
355: application => 'INV',
356: name => 'INV_NO_OPEN_PERIOD');
357: errMsg := fnd_message.get;
358: return false;
353: if (periodID = -1 or periodID = 0) then
354: fnd_message.set_name(
355: application => 'INV',
356: name => 'INV_NO_OPEN_PERIOD');
357: errMsg := fnd_message.get;
358: return false;
359: end if;
360:
361: -- default schedule number, it is the value read from profile option 'WIP_JOB_PREFIX'
560: return true;
561:
562: EXCEPTION
563: when others then
564: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
565: fnd_message.set_token ('FUNCTION', 'wma_work_order_less.derive');
566: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
567: errMsg := fnd_message.get;
568: return false;
561:
562: EXCEPTION
563: when others then
564: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
565: fnd_message.set_token ('FUNCTION', 'wma_work_order_less.derive');
566: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
567: errMsg := fnd_message.get;
568: return false;
569: End put;
562: EXCEPTION
563: when others then
564: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
565: fnd_message.set_token ('FUNCTION', 'wma_work_order_less.derive');
566: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
567: errMsg := fnd_message.get;
568: return false;
569: End put;
570:
563: when others then
564: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
565: fnd_message.set_token ('FUNCTION', 'wma_work_order_less.derive');
566: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
567: errMsg := fnd_message.get;
568: return false;
569: End put;
570:
571: Function put(lpnCfmRec LpnCfmRecord, errMsg OUT NOCOPY VARCHAR2) return boolean
646: return true;
647:
648: EXCEPTION
649: when others then
650: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
651: fnd_message.set_token ('FUNCTION', 'wma_work_order_less.derive');
652: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
653: errMsg := fnd_message.get;
654: return false;
647:
648: EXCEPTION
649: when others then
650: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
651: fnd_message.set_token ('FUNCTION', 'wma_work_order_less.derive');
652: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
653: errMsg := fnd_message.get;
654: return false;
655: End put;
648: EXCEPTION
649: when others then
650: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
651: fnd_message.set_token ('FUNCTION', 'wma_work_order_less.derive');
652: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
653: errMsg := fnd_message.get;
654: return false;
655: End put;
656:
649: when others then
650: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
651: fnd_message.set_token ('FUNCTION', 'wma_work_order_less.derive');
652: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
653: errMsg := fnd_message.get;
654: return false;
655: End put;
656:
657: END wma_cfm;