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 WIP_LOGGER

Line 30: l_paramTbl wip_logger.param_tbl_t;

26: labelStatus VARCHAR2(1);
27: dummy VARCHAR2(1);
28: l_msg_stack VARCHAR2(2000);
29: l_serialNum VARCHAR2(30);
30: l_paramTbl wip_logger.param_tbl_t;
31: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
32: l_txnMode NUMBER;
33: l_overCplRec wip_cplProc_priv.completion_rec_t;
34: BEGIN

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 49: wip_logger.log('enter wmapcmpb.process. int id is ' || parameters.transactionIntID, errCode);

45: end if;
46:
47: status := 0;
48: if (l_logLevel <= wip_constants.full_logging) then
49: wip_logger.log('enter wmapcmpb.process. int id is ' || parameters.transactionIntID, errCode);
50: end if;
51:
52: --if the caller has chosen to override the wip parameter, use that value, otherwise use the
53: --value in wip_parameters

Line 63: wip_logger.log('error from derive', errCode);

59: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
60: fnd_message.set_token('MESSAGE', error);
61: fnd_msg_pub.add;
62: if (l_logLevel <= wip_constants.full_logging) then
63: wip_logger.log('error from derive', errCode);
64: end if;
65: raise fnd_api.g_exc_unexpected_error;
66: end if;
67: if (l_logLevel <= wip_constants.full_logging) then

Line 68: wip_logger.log('new tmp id is ' || cmpRecord.transaction_interface_id, errCode);

64: end if;
65: raise fnd_api.g_exc_unexpected_error;
66: end if;
67: if (l_logLevel <= wip_constants.full_logging) then
68: wip_logger.log('new tmp id is ' || cmpRecord.transaction_interface_id, errCode);
69: end if;
70:
71: -- insert into the interface table for background processing
72: if (put(cmpRecord, errMessage) = FALSE) then

Line 74: wip_logger.log('error from put', errCode);

70:
71: -- insert into the interface table for background processing
72: if (put(cmpRecord, errMessage) = FALSE) then
73: if (l_logLevel <= wip_constants.full_logging) then
74: wip_logger.log('error from put', errCode);
75: end if;
76: raise fnd_api.g_exc_unexpected_error;
77: end if;
78:

Line 100: wip_logger.log('error from cst', errMessage);

96: fnd_message.set_name(application => 'CST',
97: name => 'CST_SNAPSHOT_FAILED');
98: fnd_msg_pub.add;
99: if (l_logLevel <= wip_constants.full_logging) then
100: wip_logger.log('error from cst', errMessage);
101: end if;
102: raise fnd_api.g_exc_unexpected_error;
103: end if;
104: end if;

Line 117: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||

113: -- do not error out if label printing, only put warning message in log
114: if(returnStatus <> fnd_api.g_ret_sts_success) then
115: wip_utilities.get_message_stack(p_msg => l_msg_stack);
116: if (l_logLevel <= wip_constants.full_logging) then
117: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
118: 'The following error has occurred during ' ||
119: 'printing: ' || l_msg_stack || '\n' ||
120: 'Please check the Inventory log file for more ' ||
121: 'information.',

Line 126: wip_logger.log(p_msg => 'Label printing returned with status ' ||

122: x_returnStatus =>dummy);
123: end if;
124: end if;
125: if (l_logLevel <= wip_constants.full_logging) then
126: wip_logger.log(p_msg => 'Label printing returned with status ' ||
127: returnStatus,
128: x_returnStatus => dummy);
129: end if;
130:

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 237: wip_logger.cleanUp(dummy);

233: p_procReturnStatus => status,
234: p_msg => 'success',
235: x_returnStatus => dummy);
236: end if;
237: wip_logger.cleanUp(dummy);
238: EXCEPTION
239: when fnd_api.g_exc_unexpected_error then
240: status := -1;
241: if (l_logLevel <= wip_constants.trace_logging) then

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 246: wip_logger.cleanUp(dummy);

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);
247: end if;
248: rollback to wma_cmp_proc10;
249: when others then
250: status := -1;

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 256: wip_logger.cleanUp(dummy);

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);
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');

Line 389: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||

385: -- do not error out if label printing, only put warning message in log
386: if(l_retStatus <> fnd_api.g_ret_sts_success) then
387: wip_utilities.get_message_stack(p_msg => l_msg_stack);
388: if (l_logLevel <= wip_constants.full_logging) then
389: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
390: 'The following error has occurred during ' ||
391: 'printing: ' || l_msg_stack || '\n' ||
392: 'Please check the Inventory log file for more ' ||
393: 'information.',

Line 398: wip_logger.log(p_msg => 'Label printing returned with status ' ||

394: x_returnStatus =>dummy);
395: end if;
396: end if;
397: if (l_logLevel <= wip_constants.full_logging) then
398: wip_logger.log(p_msg => 'Label printing returned with status ' ||
399: l_retStatus,
400: x_returnStatus => dummy);
401: end if;
402: Assign value to out parameter and remove the label printing code.

Line 478: wip_logger.log('enter wmapcmpb.derive', l_dummy);

474: l_dummy VARCHAR2(1);
475: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
476: BEGIN
477: if (l_logLevel <= wip_constants.full_logging) then
478: wip_logger.log('enter wmapcmpb.derive', l_dummy);
479: end if;
480:
481: -- get the job info
482: job := wma_derive.getJob(parameters.wipEntityID);

Line 501: wip_logger.log('wmapcmpb.derive: selecting new int id', l_dummy);

497: --the conditional population is probably not necessary, need
498: --to check with inv
499: if(parameters.transactionIntID is null or parameters.transactionIntID <= 0) then
500: if (l_logLevel <= wip_constants.full_logging) then
501: wip_logger.log('wmapcmpb.derive: selecting new int id', l_dummy);
502: end if;
503: select mtl_material_transactions_s.nextval
504: into cmpRecord.transaction_interface_id
505: from dual;

Line 508: wip_logger.log('wmapcmpb.derive: using old int id', l_dummy);

504: into cmpRecord.transaction_interface_id
505: from dual;
506: else
507: if (l_logLevel <= wip_constants.full_logging) then
508: wip_logger.log('wmapcmpb.derive: using old int id', l_dummy);
509: end if;
510: cmpRecord.transaction_interface_id := parameters.transactionIntID;
511: end if;
512:

Line 518: wip_logger.log('wmapcmpb.derive: chkQty returns false', l_dummy);

514: if (parameters.transactionType = WIP_CONSTANTS.CPLASSY_TYPE) then
515: -- validate transaction quantity.
516: if (checkQuantity(parameters, job, errMessage) = false) then
517: if (l_logLevel <= wip_constants.full_logging) then
518: wip_logger.log('wmapcmpb.derive: chkQty returns false', l_dummy);
519: end if;
520: return false;
521: end if;
522: end if;

Line 525: wip_logger.log('wmapcmpb.derive: about to call pjm', l_dummy);

521: end if;
522: end if;
523:
524: if (l_logLevel <= wip_constants.full_logging) then
525: wip_logger.log('wmapcmpb.derive: about to call pjm', l_dummy);
526: wip_logger.log('org:' || parameters.environment.orgID, l_dummy);
527: wip_logger.log('loc:' || parameters.locatorID, l_dummy);
528: wip_logger.log('prj:' || job.projectID, l_dummy);
529: wip_logger.log('tsk:' || job.taskID, l_dummy);

Line 526: wip_logger.log('org:' || parameters.environment.orgID, l_dummy);

522: end if;
523:
524: if (l_logLevel <= wip_constants.full_logging) then
525: wip_logger.log('wmapcmpb.derive: about to call pjm', l_dummy);
526: wip_logger.log('org:' || parameters.environment.orgID, l_dummy);
527: wip_logger.log('loc:' || parameters.locatorID, l_dummy);
528: wip_logger.log('prj:' || job.projectID, l_dummy);
529: wip_logger.log('tsk:' || job.taskID, l_dummy);
530: end if;

Line 527: wip_logger.log('loc:' || parameters.locatorID, l_dummy);

523:
524: if (l_logLevel <= wip_constants.full_logging) then
525: wip_logger.log('wmapcmpb.derive: about to call pjm', l_dummy);
526: wip_logger.log('org:' || parameters.environment.orgID, l_dummy);
527: wip_logger.log('loc:' || parameters.locatorID, l_dummy);
528: wip_logger.log('prj:' || job.projectID, l_dummy);
529: wip_logger.log('tsk:' || job.taskID, l_dummy);
530: end if;
531:

Line 528: wip_logger.log('prj:' || job.projectID, l_dummy);

524: if (l_logLevel <= wip_constants.full_logging) then
525: wip_logger.log('wmapcmpb.derive: about to call pjm', l_dummy);
526: wip_logger.log('org:' || parameters.environment.orgID, l_dummy);
527: wip_logger.log('loc:' || parameters.locatorID, l_dummy);
528: wip_logger.log('prj:' || job.projectID, l_dummy);
529: wip_logger.log('tsk:' || job.taskID, l_dummy);
530: end if;
531:
532: -- check the project reference

Line 529: wip_logger.log('tsk:' || job.taskID, l_dummy);

525: wip_logger.log('wmapcmpb.derive: about to call pjm', l_dummy);
526: wip_logger.log('org:' || parameters.environment.orgID, l_dummy);
527: wip_logger.log('loc:' || parameters.locatorID, l_dummy);
528: wip_logger.log('prj:' || job.projectID, l_dummy);
529: wip_logger.log('tsk:' || job.taskID, l_dummy);
530: end if;
531:
532: -- check the project reference
533: if (pjm_project_locator.check_project_references(

Line 542: wip_logger.log('wmapcmpb.derive: pjm_project_locator returns false', l_dummy);

538: job.projectID,
539: job.taskID) = false) then
540: errMessage := fnd_message.get;
541: if (l_logLevel <= wip_constants.full_logging) then
542: wip_logger.log('wmapcmpb.derive: pjm_project_locator returns false', l_dummy);
543: end if;
544: return false;
545: end if;
546:

Line 548: wip_logger.log('wmapcmpb.derive: about to call getItem', l_dummy);

544: return false;
545: end if;
546:
547: if (l_logLevel <= wip_constants.full_logging) then
548: wip_logger.log('wmapcmpb.derive: about to call getItem', l_dummy);
549: end if;
550:
551: -- get the item info
552: item := wma_derive.getItem(parameters.itemID,

Line 559: wip_logger.log('wmapcmpb.derive: wma_derive.getItem returns false', l_dummy);

555: if (item.invItemID is null) then
556: fnd_message.set_name ('WIP', 'WIP_ITEM_DOES_NOT_EXIST');
557: errMessage := fnd_message.get;
558: if (l_logLevel <= wip_constants.full_logging) then
559: wip_logger.log('wmapcmpb.derive: wma_derive.getItem returns false', l_dummy);
560: end if;
561: return false;
562: end if;
563:

Line 568: wip_logger.log('wmapcmpb.derive: about to call getRev', l_dummy);

564: -- get the item revision
565: cmpRecord.revision := null;
566:
567: if (l_logLevel <= wip_constants.full_logging) then
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(

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 586: wip_logger.log('wmapcmpb.derive: about to call tdatechk', l_dummy);

582: end if; -- getRevision
583: end if; -- revQtyControlCode = WIP_CONSTANTS.REVISION_CONTROLLED
584:
585: if (l_logLevel <= wip_constants.full_logging) then
586: wip_logger.log('wmapcmpb.derive: about to call tdatechk', l_dummy);
587: end if;
588:
589: -- get the accounting period
590: invttmtx.tdatechk(

Line 602: wip_logger.log('wmapcmpb.derive: tdatechk returns false', l_dummy);

598: application => 'INV',
599: name => 'INV_NO_OPEN_PERIOD');
600: errMessage := fnd_message.get;
601: if (l_logLevel <= wip_constants.full_logging) then
602: wip_logger.log('wmapcmpb.derive: tdatechk returns false', l_dummy);
603: end if;
604: return false;
605: end if;
606:

Line 995: l_params wip_logger.param_tbl_t;

991: IS
992: result NUMBER;
993: ocQtyToCheck NUMBER;
994: l_returnStatus VARCHAR2(1);
995: l_params wip_logger.param_tbl_t;
996: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
997: /* Fixed bug 3693148 */
998: l_job_type NUMBER;
999: BEGIN

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 1124: l_params wip_logger.param_tbl_t;

1120: x_returnStatus out nocopy varchar2,
1121: x_errMessage out nocopy varchar2) is
1122: result number;
1123: l_returnStatus VARCHAR2(1);
1124: l_params wip_logger.param_tbl_t;
1125: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
1126: begin
1127: if (l_logLevel <= wip_constants.trace_logging) then
1128: l_params(1).paramName := 'not printing params';

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 1285: wip_logger.log('before insert', l_dummy);

1281: l_rowID rowid;
1282: l_retStatus VARCHAR2(1);
1283: BEGIN
1284: if (l_logLevel <= wip_constants.full_logging) then
1285: wip_logger.log('before insert', l_dummy);
1286: wip_logger.log('before insert item' || cmpRecord.inventory_item_id, l_dummy);
1287: wip_logger.log('before insert org' || cmpRecord.organization_id, l_dummy);
1288: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1289: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);

Line 1286: wip_logger.log('before insert item' || cmpRecord.inventory_item_id, l_dummy);

1282: l_retStatus VARCHAR2(1);
1283: BEGIN
1284: if (l_logLevel <= wip_constants.full_logging) then
1285: wip_logger.log('before insert', l_dummy);
1286: wip_logger.log('before insert item' || cmpRecord.inventory_item_id, l_dummy);
1287: wip_logger.log('before insert org' || cmpRecord.organization_id, l_dummy);
1288: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1289: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1290: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);

Line 1287: wip_logger.log('before insert org' || cmpRecord.organization_id, l_dummy);

1283: BEGIN
1284: if (l_logLevel <= wip_constants.full_logging) then
1285: wip_logger.log('before insert', l_dummy);
1286: wip_logger.log('before insert item' || cmpRecord.inventory_item_id, l_dummy);
1287: wip_logger.log('before insert org' || cmpRecord.organization_id, l_dummy);
1288: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1289: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1290: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);
1291: wip_logger.log('before insert movTxnID ' || cmpRecord.move_transaction_id, l_dummy);

Line 1288: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);

1284: if (l_logLevel <= wip_constants.full_logging) then
1285: wip_logger.log('before insert', l_dummy);
1286: wip_logger.log('before insert item' || cmpRecord.inventory_item_id, l_dummy);
1287: wip_logger.log('before insert org' || cmpRecord.organization_id, l_dummy);
1288: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1289: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1290: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);
1291: wip_logger.log('before insert movTxnID ' || cmpRecord.move_transaction_id, l_dummy);
1292: wip_logger.log('before insert demandsourceheaderID ' || cmpRecord.demand_source_header_id, l_dummy);

Line 1289: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);

1285: wip_logger.log('before insert', l_dummy);
1286: wip_logger.log('before insert item' || cmpRecord.inventory_item_id, l_dummy);
1287: wip_logger.log('before insert org' || cmpRecord.organization_id, l_dummy);
1288: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1289: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1290: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);
1291: wip_logger.log('before insert movTxnID ' || cmpRecord.move_transaction_id, l_dummy);
1292: wip_logger.log('before insert demandsourceheaderID ' || cmpRecord.demand_source_header_id, l_dummy);
1293: wip_logger.log('before insert demandsourcelineID ' || cmpRecord.demand_source_line_id, l_dummy);

Line 1290: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);

1286: wip_logger.log('before insert item' || cmpRecord.inventory_item_id, l_dummy);
1287: wip_logger.log('before insert org' || cmpRecord.organization_id, l_dummy);
1288: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1289: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1290: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);
1291: wip_logger.log('before insert movTxnID ' || cmpRecord.move_transaction_id, l_dummy);
1292: wip_logger.log('before insert demandsourceheaderID ' || cmpRecord.demand_source_header_id, l_dummy);
1293: wip_logger.log('before insert demandsourcelineID ' || cmpRecord.demand_source_line_id, l_dummy);
1294: end if;

Line 1291: wip_logger.log('before insert movTxnID ' || cmpRecord.move_transaction_id, l_dummy);

1287: wip_logger.log('before insert org' || cmpRecord.organization_id, l_dummy);
1288: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1289: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1290: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);
1291: wip_logger.log('before insert movTxnID ' || cmpRecord.move_transaction_id, l_dummy);
1292: wip_logger.log('before insert demandsourceheaderID ' || cmpRecord.demand_source_header_id, l_dummy);
1293: wip_logger.log('before insert demandsourcelineID ' || cmpRecord.demand_source_line_id, l_dummy);
1294: end if;
1295:

Line 1292: wip_logger.log('before insert demandsourceheaderID ' || cmpRecord.demand_source_header_id, l_dummy);

1288: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1289: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1290: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);
1291: wip_logger.log('before insert movTxnID ' || cmpRecord.move_transaction_id, l_dummy);
1292: wip_logger.log('before insert demandsourceheaderID ' || cmpRecord.demand_source_header_id, l_dummy);
1293: wip_logger.log('before insert demandsourcelineID ' || cmpRecord.demand_source_line_id, l_dummy);
1294: end if;
1295:
1296: insert into mtl_transactions_interface

Line 1293: wip_logger.log('before insert demandsourcelineID ' || cmpRecord.demand_source_line_id, l_dummy);

1289: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1290: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);
1291: wip_logger.log('before insert movTxnID ' || cmpRecord.move_transaction_id, l_dummy);
1292: wip_logger.log('before insert demandsourceheaderID ' || cmpRecord.demand_source_header_id, l_dummy);
1293: wip_logger.log('before insert demandsourcelineID ' || cmpRecord.demand_source_line_id, l_dummy);
1294: end if;
1295:
1296: insert into mtl_transactions_interface
1297: (transaction_header_id,

Line 1388: wip_logger.log('after insert', l_dummy);

1384: wip_constants.ASSY_BATCH_SEQ,
1385: cmpRecord.demand_source_header_id,
1386: cmpRecord.demand_source_line_id);
1387: if (l_logLevel <= wip_constants.full_logging) then
1388: wip_logger.log('after insert', l_dummy);
1389: end if;
1390:
1391:
1392: wip_mtlTempProc_priv.validateInterfaceTxns(p_txnHdrID => cmpRecord.transaction_header_id,

Line 1398: wip_logger.log('error from validateInterfaceTxns', l_retStatus);

1394: x_returnStatus => l_retStatus);
1395:
1396: if(l_retStatus <> fnd_api.g_ret_sts_success) then
1397: if (l_logLevel <= wip_constants.full_logging) then
1398: wip_logger.log('error from validateInterfaceTxns', l_retStatus);
1399: end if;
1400: wip_utilities.get_message_stack(p_msg => errMessage);
1401: return false;
1402: end if;

Line 1407: wip_logger.log('put failed: ' || SQLERRM, l_dummy);

1403: return true;
1404: EXCEPTION
1405: when others then
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);

Line 1512: l_params wip_logger.param_tbl_t;

1508: l_assyPullStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
1509: l_opPullStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
1510: l_compTbl system.wip_component_tbl_t;
1511: l_returnStatus VARCHAR2(1);
1512: l_params wip_logger.param_tbl_t;
1513: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
1514: begin
1515: if (l_logLevel <= wip_constants.trace_logging) then
1516: l_params(1).paramName := 'not printing params';

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;