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.8.12020000.2 2012/07/20 10:53:06 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 442: fnd_message.set_token ('FUNCTION', 'wma_completion.process');

438: when others then
439: rollback to wmapcmpb_proc1000;
440: status := -1;
441: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
442: fnd_message.set_token ('FUNCTION', 'wma_completion.process');
443: fnd_message.set_token ('ERROR', SQLERRM);
444: errMessage := fnd_message.get;
445:
446: END process;

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

486: -- get the job info
487: job := wma_derive.getJob(parameters.wipEntityID);
488: if (job.wipEntityID is null) then
489: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
490: fnd_message.set_token('INTERFACE', 'wma_completion.derive', TRUE);
491: errMessage := fnd_message.get;
492: return false;
493: end if;
494:

Line 577: if(NOT wma_completion.getRevision(

573: wip_logger.log('wmapcmpb.derive: about to call getRev', l_dummy);
574: end if;
575:
576: if (item.revQtyControlCode = WIP_CONSTANTS.REVISION_CONTROLLED) then
577: if(NOT wma_completion.getRevision(
578: wipEntityID => parameters.wipEntityID,
579: orgID => parameters.environment.orgID,
580: itemID => parameters.itemID,
581: revision => cmpRecord.revision)) then

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

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

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

756:
757: EXCEPTION
758: when others then
759: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
760: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');
761: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
762: errMessage := fnd_message.get;
763: return false;
764: END derive;

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

779: -- get the job info
780: job := wma_derive.getJob(parameters.wipEntityID);
781: if (job.wipEntityID is null) then
782: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
783: fnd_message.set_token('INTERFACE', 'wma_completion.derive', TRUE);
784: errMessage := fnd_message.get;
785: return false;
786: end if;
787:

Line 827: if(NOT wma_completion.getRevision(

823: end if;
824: -- get the item revision
825: LpnCmpRecord.row.bom_revision := null;
826: if (item.revQtyControlCode = WIP_CONSTANTS.REVISION_CONTROLLED) then
827: if(NOT wma_completion.getRevision(
828: wipEntityID => parameters.wipEntityID,
829: orgID => parameters.environment.orgID,
830: itemID => parameters.itemID,
831: revision => lpnCmpRecord.row.bom_revision)) then

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

918:
919: EXCEPTION
920: when others then
921: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
922: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');
923: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
924: errMessage := fnd_message.get;
925: return false;
926: END derive;

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

1008: BEGIN
1009: if (l_logLevel <= wip_constants.trace_logging) then
1010: l_params(1).paramName := 'not printing params';
1011: l_params(1).paramValue := ' ';
1012: wip_logger.entryPoint(p_procName => 'wma_completion.checkQuantity',
1013: p_params => l_params,
1014: x_returnStatus => l_returnStatus);
1015: end if;
1016:

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

1017: if (transactionQty <= 0) then
1018: fnd_message.set_name ('INV', 'INV_GREATER_THAN_ZERO');
1019: errMessage := fnd_message.get;
1020: if (l_logLevel <= wip_constants.trace_logging) then
1021: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1022: p_procReturnStatus => -1,
1023: p_msg => errMessage,
1024: x_returnStatus => l_returnStatus);
1025: end if;

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

1032: fnd_message.set_token('ENTITY1', 'TRANSACTION QUANTITY-CAP', TRUE);
1033: fnd_message.set_token('ENTITY2', 'QTY AVAIL TO COMPLETE', TRUE);
1034: errMessage := fnd_message.get;
1035: if (l_logLevel <= wip_constants.trace_logging) then
1036: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1037: p_procReturnStatus => -1,
1038: p_msg => errMessage,
1039: x_returnStatus => l_returnStatus);
1040: end if;

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

1054: if (result = wip_constants.no) then -- quantity exceeds tolerance
1055: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
1056: errMessage := fnd_message.get;
1057: if (l_logLevel <= wip_constants.trace_logging) then
1058: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1059: p_procReturnStatus => -1,
1060: p_msg => errMessage,
1061: x_returnStatus => l_returnStatus);
1062: end if;

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

1071: if (transactionQty > availableQty) then
1072: fnd_message.set_name ('INV', 'INV_QTY_LESS_OR_EQUAL');
1073: errMessage := fnd_message.get;
1074: if (l_logLevel <= wip_constants.trace_logging) then
1075: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1076: p_procReturnStatus => -1,
1077: p_msg => errMessage,
1078: x_returnStatus => l_returnStatus);
1079: end if;

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

1097: fnd_message.set_token('ENTITY1', 'TOTAL TXN QTY-CAP', TRUE);
1098: fnd_message.set_token('ENTITY2', 'JOB COMPLETE QUANTITY', TRUE);
1099: errMessage := fnd_message.get;
1100: if (l_logLevel <= wip_constants.trace_logging) then
1101: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1102: p_procReturnStatus => -1,
1103: p_msg => errMessage,
1104: x_returnStatus => l_returnStatus);
1105: end if;

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

1107: end if;
1108: end if;
1109: end if; -- quantity validation
1110: if (l_logLevel <= wip_constants.trace_logging) then
1111: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1112: p_procReturnStatus => 0,
1113: p_msg => 'success',
1114: x_returnStatus => l_returnStatus);
1115: end if;

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

1135: begin
1136: if (l_logLevel <= wip_constants.trace_logging) then
1137: l_params(1).paramName := 'not printing params';
1138: l_params(1).paramValue := ' ';
1139: wip_logger.entryPoint(p_procName => 'wma_completion.checkOverCpl',
1140: p_params => l_params,
1141: x_returnStatus => l_returnStatus);
1142: end if;
1143:

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

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

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

1166: EXCEPTION
1167: when others then
1168: x_returnStatus := fnd_api.g_ret_sts_error;
1169: if (l_logLevel <= wip_constants.trace_logging) then
1170: wip_logger.exitPoint(p_procName => 'wma_completion.checkOverCpl',
1171: p_procReturnStatus => -1,
1172: p_msg => x_errMessage,
1173: x_returnStatus => l_returnStatus);
1174: end if;

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

1415: if (l_logLevel <= wip_constants.full_logging) then
1416: wip_logger.log('put failed: ' || SQLERRM, l_dummy);
1417: end if;
1418: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1419: fnd_message.set_token ('FUNCTION', 'wma_completion.put');
1420: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1421: errMessage := fnd_message.get;
1422: return false;
1423: END put;

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

1490:
1491: EXCEPTION
1492: when others then
1493: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1494: fnd_message.set_token ('FUNCTION', 'wma_completion.put');
1495: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1496: errMessage := fnd_message.get;
1497: return false;
1498: END put;

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

1523: begin
1524: if (l_logLevel <= wip_constants.trace_logging) then
1525: l_params(1).paramName := 'not printing params';
1526: l_params(1).paramValue := ' ';
1527: wip_logger.entryPoint(p_procName => 'wma_completion.backflush',
1528: p_params => l_params,
1529: x_returnStatus => l_returnStatus);
1530: end if;
1531:

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

1643:
1644: if(l_txnMode = wip_constants.background) then
1645: x_returnStatus := fnd_api.g_ret_sts_success;
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 => x_errMessage,
1650: x_returnStatus => l_returnStatus);
1651: end if;

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

1652: return; --do nothing for now
1653: end if;
1654:
1655: if (l_logLevel <= wip_constants.trace_logging) then
1656: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',
1657: p_procReturnStatus => x_returnStatus,
1658: p_msg => 'success',
1659: x_returnStatus => l_returnStatus);
1660: end if;

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

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

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

1672: when others then
1673: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1674: x_errMessage := SQLERRM;
1675: if (l_logLevel <= wip_constants.trace_logging) then
1676: wip_logger.exitPoint(p_procName => 'wma_completion.backflush',
1677: p_procReturnStatus => x_returnStatus,
1678: p_msg => x_errMessage,
1679: x_returnStatus => l_returnStatus);
1680: end if;

Line 1732: end wma_completion;

1728: WHEN others THEN
1729: fnd_message.set_name('WIP', 'WIP_BOM_ITEM_REVISION');
1730: return false;
1731: END getRevision;
1732: end wma_completion;