eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMA_COMPLETION dependencies on WMA_COMPLETION

Line 1: PACKAGE BODY wma_completion AS

1: PACKAGE BODY wma_completion AS
2: /* $Header: wmapcmpb.pls 120.4.12000000.3 2007/08/29 14:49:15 sisankar ship $ */
3:
4: /**
5: * This procedure is the entry point into the Completion and Return

Line 42: wip_logger.entryPoint(p_procName => 'wma_completion.process',

38: --logging not fully supported in this package.
39: l_paramTbl(1).paramName := 'not printing params';
40: l_paramTbl(1).paramValue := ' ';
41: --just skip
42: wip_logger.entryPoint(p_procName => 'wma_completion.process',
43: p_params => l_paramTbl,
44: x_returnStatus => errCode);
45: end if;
46:

Line 133: wip_logger.log('wma_completion.process: tmpID => ' || cmpRecord.transaction_interface_id, returnStatus);

129: end if;
130:
131:
132: if (l_logLevel <= wip_constants.full_logging) then
133: wip_logger.log('wma_completion.process: tmpID => ' || cmpRecord.transaction_interface_id, returnStatus);
134: end if;
135:
136: --if a return from the serialized page, re-populate the wip_entity_id,
137: --intraoperation_seq_num, and intraoperation_step_type columns in MSN.

Line 164: wip_logger.log('wma_completion.process: overcomplete retStatus => ' ||

160: wip_cplProc_priv.processOverCpl(p_cplRec => l_overCplRec,
161: x_returnStatus => returnStatus);
162:
163: if (l_logLevel <= wip_constants.full_logging) then
164: wip_logger.log('wma_completion.process: overcomplete retStatus => ' ||
165: returnStatus, dummy);
166: end if;
167:
168: if(returnStatus <> fnd_api.g_ret_sts_success) then

Line 189: wip_logger.log('wma_completion.process: retStatus => ' || returnStatus, dummy);

185: x_errorMsg => errMessage);
186: end if;
187:
188: if (l_logLevel <= wip_constants.full_logging) then
189: wip_logger.log('wma_completion.process: retStatus => ' || returnStatus, dummy);
190: end if;
191: if(returnStatus <> fnd_api.g_ret_sts_success) then
192: raise fnd_api.g_exc_unexpected_error;
193: end if;

Line 201: wip_logger.log('wma_completion.process: about to update serial', dummy);

197: --wip_entity_id, op_seq, and intra_op columns.
198: if (parameters.isFromSerializedPage = wip_constants.yes and
199: parameters.transactionType = wip_constants.retassy_type) then
200: if (l_logLevel <= wip_constants.full_logging) then
201: wip_logger.log('wma_completion.process: about to update serial', dummy);
202: end if;
203: if(cmpRecord.operation_seq_num = -1) then
204: wip_utilities.update_serial(p_serial_number => l_serialNum,
205: p_inventory_item_id => parameters.itemID,

Line 221: wip_logger.log('wma_completion.process: serialization op retStatus => ' || returnStatus, dummy);

217: p_intraoperation_step_type => wip_constants.toMove,
218: x_return_status => returnStatus);
219: end if;
220: if (l_logLevel <= wip_constants.full_logging) then
221: wip_logger.log('wma_completion.process: serialization op retStatus => ' || returnStatus, dummy);
222: end if;
223: if(returnStatus <> fnd_api.g_ret_sts_success) then
224: if (l_logLevel <= wip_constants.full_logging) then
225: wip_logger.log('wma_completion.process: retStatus of serial update failure ' || returnStatus, dummy);

Line 225: wip_logger.log('wma_completion.process: retStatus of serial update failure ' || returnStatus, dummy);

221: wip_logger.log('wma_completion.process: serialization op retStatus => ' || returnStatus, dummy);
222: end if;
223: if(returnStatus <> fnd_api.g_ret_sts_success) then
224: if (l_logLevel <= wip_constants.full_logging) then
225: wip_logger.log('wma_completion.process: retStatus of serial update failure ' || returnStatus, dummy);
226: end if;
227: wip_utilities.get_message_stack(p_msg => errMessage);
228: raise fnd_api.g_exc_unexpected_error;
229: end if;

Line 232: wip_logger.exitPoint(p_procName => 'wma_completion.process',

228: raise fnd_api.g_exc_unexpected_error;
229: end if;
230: end if;
231: if (l_logLevel <= wip_constants.trace_logging) then
232: wip_logger.exitPoint(p_procName => 'wma_completion.process',
233: p_procReturnStatus => status,
234: p_msg => 'success',
235: x_returnStatus => dummy);
236: end if;

Line 242: wip_logger.exitPoint(p_procName => 'wma_completion.process',

238: EXCEPTION
239: when fnd_api.g_exc_unexpected_error then
240: status := -1;
241: if (l_logLevel <= wip_constants.trace_logging) then
242: wip_logger.exitPoint(p_procName => 'wma_completion.process',
243: p_procReturnStatus => status,
244: p_msg => 'failure',
245: x_returnStatus => dummy);
246: wip_logger.cleanUp(dummy);

Line 252: wip_logger.exitPoint(p_procName => 'wma_completion.process',

248: rollback to wma_cmp_proc10;
249: when others then
250: status := -1;
251: if (l_logLevel <= wip_constants.trace_logging) then
252: wip_logger.exitPoint(p_procName => 'wma_completion.process',
253: p_procReturnStatus => status,
254: p_msg => 'exception',
255: x_returnStatus => dummy);
256: wip_logger.cleanUp(dummy);

Line 261: fnd_message.set_token ('FUNCTION', 'wma_completion.process');

257: end if;
258: rollback to wma_cmp_proc10;
259: returnStatus := fnd_api.g_ret_sts_unexp_error;
260: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
261: fnd_message.set_token ('FUNCTION', 'wma_completion.process');
262: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
263: errMessage := fnd_message.get;
264: END process;
265:

Line 437: fnd_message.set_token ('FUNCTION', 'wma_completion.process');

433: when others then
434: rollback to wmapcmpb_proc1000;
435: status := -1;
436: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
437: fnd_message.set_token ('FUNCTION', 'wma_completion.process');
438: fnd_message.set_token ('ERROR', SQLERRM);
439: errMessage := fnd_message.get;
440:
441: END process;

Line 485: fnd_message.set_token('INTERFACE', 'wma_completion.derive', TRUE);

481: -- get the job info
482: job := wma_derive.getJob(parameters.wipEntityID);
483: if (job.wipEntityID is null) then
484: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
485: fnd_message.set_token('INTERFACE', 'wma_completion.derive', TRUE);
486: errMessage := fnd_message.get;
487: return false;
488: end if;
489:

Line 572: if(NOT wma_completion.getRevision(

568: wip_logger.log('wmapcmpb.derive: about to call getRev', l_dummy);
569: end if;
570:
571: if (item.revQtyControlCode = WIP_CONSTANTS.REVISION_CONTROLLED) then
572: if(NOT wma_completion.getRevision(
573: wipEntityID => parameters.wipEntityID,
574: orgID => parameters.environment.orgID,
575: itemID => parameters.itemID,
576: revision => cmpRecord.revision)) then

Line 579: wip_logger.log('wmapcmpb.derive: wma_completion.getRevision returns false', l_dummy);

575: itemID => parameters.itemID,
576: revision => cmpRecord.revision)) then
577: errMessage := substr(fnd_message.get,1,241);
578: if (l_logLevel <= wip_constants.full_logging) then
579: wip_logger.log('wmapcmpb.derive: wma_completion.getRevision returns false', l_dummy);
580: end if;
581: return false;
582: end if; -- getRevision
583: end if; -- revQtyControlCode = WIP_CONSTANTS.REVISION_CONTROLLED

Line 755: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');

751:
752: EXCEPTION
753: when others then
754: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
755: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');
756: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
757: errMessage := fnd_message.get;
758: return false;
759: END derive;

Line 778: fnd_message.set_token('INTERFACE', 'wma_completion.derive', TRUE);

774: -- get the job info
775: job := wma_derive.getJob(parameters.wipEntityID);
776: if (job.wipEntityID is null) then
777: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
778: fnd_message.set_token('INTERFACE', 'wma_completion.derive', TRUE);
779: errMessage := fnd_message.get;
780: return false;
781: end if;
782:

Line 822: if(NOT wma_completion.getRevision(

818: end if;
819: -- get the item revision
820: LpnCmpRecord.row.bom_revision := null;
821: if (item.revQtyControlCode = WIP_CONSTANTS.REVISION_CONTROLLED) then
822: if(NOT wma_completion.getRevision(
823: wipEntityID => parameters.wipEntityID,
824: orgID => parameters.environment.orgID,
825: itemID => parameters.itemID,
826: revision => lpnCmpRecord.row.bom_revision)) then

Line 913: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');

909:
910: EXCEPTION
911: when others then
912: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
913: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');
914: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
915: errMessage := fnd_message.get;
916: return false;
917: END derive;

Line 1003: wip_logger.entryPoint(p_procName => 'wma_completion.checkQuantity',

999: BEGIN
1000: if (l_logLevel <= wip_constants.trace_logging) then
1001: l_params(1).paramName := 'not printing params';
1002: l_params(1).paramValue := ' ';
1003: wip_logger.entryPoint(p_procName => 'wma_completion.checkQuantity',
1004: p_params => l_params,
1005: x_returnStatus => l_returnStatus);
1006: end if;
1007:

Line 1012: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',

1008: if (transactionQty <= 0) then
1009: fnd_message.set_name ('INV', 'INV_GREATER_THAN_ZERO');
1010: errMessage := fnd_message.get;
1011: if (l_logLevel <= wip_constants.trace_logging) then
1012: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1013: p_procReturnStatus => -1,
1014: p_msg => errMessage,
1015: x_returnStatus => l_returnStatus);
1016: end if;

Line 1027: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',

1023: fnd_message.set_token('ENTITY1', 'TRANSACTION QUANTITY-CAP', TRUE);
1024: fnd_message.set_token('ENTITY2', 'QTY AVAIL TO COMPLETE', TRUE);
1025: errMessage := fnd_message.get;
1026: if (l_logLevel <= wip_constants.trace_logging) then
1027: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1028: p_procReturnStatus => -1,
1029: p_msg => errMessage,
1030: x_returnStatus => l_returnStatus);
1031: end if;

Line 1049: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',

1045: if (result = wip_constants.no) then -- quantity exceeds tolerance
1046: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
1047: errMessage := fnd_message.get;
1048: if (l_logLevel <= wip_constants.trace_logging) then
1049: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1050: p_procReturnStatus => -1,
1051: p_msg => errMessage,
1052: x_returnStatus => l_returnStatus);
1053: end if;

Line 1066: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',

1062: if (transactionQty > availableQty) then
1063: fnd_message.set_name ('INV', 'INV_QTY_LESS_OR_EQUAL');
1064: errMessage := fnd_message.get;
1065: if (l_logLevel <= wip_constants.trace_logging) then
1066: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1067: p_procReturnStatus => -1,
1068: p_msg => errMessage,
1069: x_returnStatus => l_returnStatus);
1070: end if;

Line 1092: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',

1088: fnd_message.set_token('ENTITY1', 'TOTAL TXN QTY-CAP', TRUE);
1089: fnd_message.set_token('ENTITY2', 'JOB COMPLETE QUANTITY', TRUE);
1090: errMessage := fnd_message.get;
1091: if (l_logLevel <= wip_constants.trace_logging) then
1092: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1093: p_procReturnStatus => -1,
1094: p_msg => errMessage,
1095: x_returnStatus => l_returnStatus);
1096: end if;

Line 1102: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',

1098: end if;
1099: end if;
1100: end if; -- quantity validation
1101: if (l_logLevel <= wip_constants.trace_logging) then
1102: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1103: p_procReturnStatus => 0,
1104: p_msg => 'success',
1105: x_returnStatus => l_returnStatus);
1106: end if;

Line 1130: wip_logger.entryPoint(p_procName => 'wma_completion.checkOverCpl',

1126: begin
1127: if (l_logLevel <= wip_constants.trace_logging) then
1128: l_params(1).paramName := 'not printing params';
1129: l_params(1).paramValue := ' ';
1130: wip_logger.entryPoint(p_procName => 'wma_completion.checkOverCpl',
1131: p_params => l_params,
1132: x_returnStatus => l_returnStatus);
1133: end if;
1134:

Line 1152: wip_logger.exitPoint(p_procName => 'wma_completion.checkOverCpl',

1148: end if;
1149: end if;
1150:
1151: if (l_logLevel <= wip_constants.trace_logging) then
1152: wip_logger.exitPoint(p_procName => 'wma_completion.checkOverCpl',
1153: p_procReturnStatus => 0,
1154: p_msg => x_errMessage,
1155: x_returnStatus => l_returnStatus);
1156: end if;

Line 1161: wip_logger.exitPoint(p_procName => 'wma_completion.checkOverCpl',

1157: EXCEPTION
1158: when others then
1159: x_returnStatus := fnd_api.g_ret_sts_error;
1160: if (l_logLevel <= wip_constants.trace_logging) then
1161: wip_logger.exitPoint(p_procName => 'wma_completion.checkOverCpl',
1162: p_procReturnStatus => -1,
1163: p_msg => x_errMessage,
1164: x_returnStatus => l_returnStatus);
1165: end if;

Line 1410: fnd_message.set_token ('FUNCTION', 'wma_completion.put');

1406: if (l_logLevel <= wip_constants.full_logging) then
1407: wip_logger.log('put failed: ' || SQLERRM, l_dummy);
1408: end if;
1409: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1410: fnd_message.set_token ('FUNCTION', 'wma_completion.put');
1411: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1412: errMessage := fnd_message.get;
1413: return false;
1414: END put;

Line 1485: fnd_message.set_token ('FUNCTION', 'wma_completion.put');

1481:
1482: EXCEPTION
1483: when others then
1484: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1485: fnd_message.set_token ('FUNCTION', 'wma_completion.put');
1486: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1487: errMessage := fnd_message.get;
1488: return false;
1489: END put;

Line 1518: wip_logger.entryPoint(p_procName => 'wma_completion.backflush',

1514: begin
1515: if (l_logLevel <= wip_constants.trace_logging) then
1516: l_params(1).paramName := 'not printing params';
1517: l_params(1).paramValue := ' ';
1518: wip_logger.entryPoint(p_procName => 'wma_completion.backflush',
1519: p_params => l_params,
1520: x_returnStatus => l_returnStatus);
1521: end if;
1522:

Line 1638: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',

1634:
1635: if(l_txnMode = wip_constants.background) then
1636: x_returnStatus := fnd_api.g_ret_sts_success;
1637: if (l_logLevel <= wip_constants.trace_logging) then
1638: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',
1639: p_procReturnStatus => x_returnStatus,
1640: p_msg => x_errMessage,
1641: x_returnStatus => l_returnStatus);
1642: end if;

Line 1647: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',

1643: return; --do nothing for now
1644: end if;
1645:
1646: if (l_logLevel <= wip_constants.trace_logging) then
1647: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',
1648: p_procReturnStatus => x_returnStatus,
1649: p_msg => 'success',
1650: x_returnStatus => l_returnStatus);
1651: end if;

Line 1657: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',

1653: when fnd_api.g_exc_unexpected_error then
1654: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1655: x_errMessage := fnd_msg_pub.get(p_encoded => 'F');
1656: if (l_logLevel <= wip_constants.trace_logging) then
1657: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',
1658: p_procReturnStatus => x_returnStatus,
1659: p_msg => x_errMessage,
1660: x_returnStatus => l_returnStatus);
1661: end if;

Line 1667: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',

1663: when others then
1664: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1665: x_errMessage := SQLERRM;
1666: if (l_logLevel <= wip_constants.trace_logging) then
1667: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',
1668: p_procReturnStatus => x_returnStatus,
1669: p_msg => x_errMessage,
1670: x_returnStatus => l_returnStatus);
1671: end if;

Line 1723: end wma_completion;

1719: WHEN others THEN
1720: fnd_message.set_name('WIP', 'WIP_BOM_ITEM_REVISION');
1721: return false;
1722: END getRevision;
1723: end wma_completion;