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 394: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||

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

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

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

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

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

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

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

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

509: into cmpRecord.transaction_interface_id
510: from dual;
511: else
512: if (l_logLevel <= wip_constants.full_logging) then
513: wip_logger.log('wmapcmpb.derive: using old int id', l_dummy);
514: end if;
515: cmpRecord.transaction_interface_id := parameters.transactionIntID;
516: end if;
517:

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

519: if (parameters.transactionType = WIP_CONSTANTS.CPLASSY_TYPE) then
520: -- validate transaction quantity.
521: if (checkQuantity(parameters, job, errMessage) = false) then
522: if (l_logLevel <= wip_constants.full_logging) then
523: wip_logger.log('wmapcmpb.derive: chkQty returns false', l_dummy);
524: end if;
525: return false;
526: end if;
527: end if;

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

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

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

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

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

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

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

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

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

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

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

543: job.projectID,
544: job.taskID) = false) then
545: errMessage := fnd_message.get;
546: if (l_logLevel <= wip_constants.full_logging) then
547: wip_logger.log('wmapcmpb.derive: pjm_project_locator returns false', l_dummy);
548: end if;
549: return false;
550: end if;
551:

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

549: return false;
550: end if;
551:
552: if (l_logLevel <= wip_constants.full_logging) then
553: wip_logger.log('wmapcmpb.derive: about to call getItem', l_dummy);
554: end if;
555:
556: -- get the item info
557: item := wma_derive.getItem(parameters.itemID,

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

560: if (item.invItemID is null) then
561: fnd_message.set_name ('WIP', 'WIP_ITEM_DOES_NOT_EXIST');
562: errMessage := fnd_message.get;
563: if (l_logLevel <= wip_constants.full_logging) then
564: wip_logger.log('wmapcmpb.derive: wma_derive.getItem returns false', l_dummy);
565: end if;
566: return false;
567: end if;
568:

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

569: -- get the item revision
570: cmpRecord.revision := null;
571:
572: if (l_logLevel <= wip_constants.full_logging) then
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(

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

587: end if; -- getRevision
588: end if; -- revQtyControlCode = WIP_CONSTANTS.REVISION_CONTROLLED
589:
590: if (l_logLevel <= wip_constants.full_logging) then
591: wip_logger.log('wmapcmpb.derive: about to call tdatechk', l_dummy);
592: end if;
593:
594: -- get the accounting period
595: invttmtx.tdatechk(

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

603: application => 'INV',
604: name => 'INV_NO_OPEN_PERIOD');
605: errMessage := fnd_message.get;
606: if (l_logLevel <= wip_constants.full_logging) then
607: wip_logger.log('wmapcmpb.derive: tdatechk returns false', l_dummy);
608: end if;
609: return false;
610: end if;
611:

Line 1004: l_params wip_logger.param_tbl_t;

1000: IS
1001: result NUMBER;
1002: ocQtyToCheck NUMBER;
1003: l_returnStatus VARCHAR2(1);
1004: l_params wip_logger.param_tbl_t;
1005: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
1006: /* Fixed bug 3693148 */
1007: l_job_type NUMBER;
1008: BEGIN

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

1129: x_returnStatus out nocopy varchar2,
1130: x_errMessage out nocopy varchar2) is
1131: result number;
1132: l_returnStatus VARCHAR2(1);
1133: l_params wip_logger.param_tbl_t;
1134: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
1135: begin
1136: if (l_logLevel <= wip_constants.trace_logging) then
1137: l_params(1).paramName := 'not printing params';

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

1290: l_rowID rowid;
1291: l_retStatus VARCHAR2(1);
1292: BEGIN
1293: if (l_logLevel <= wip_constants.full_logging) then
1294: wip_logger.log('before insert', l_dummy);
1295: wip_logger.log('before insert item' || cmpRecord.inventory_item_id, l_dummy);
1296: wip_logger.log('before insert org' || cmpRecord.organization_id, l_dummy);
1297: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1298: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);

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

1291: l_retStatus VARCHAR2(1);
1292: BEGIN
1293: if (l_logLevel <= wip_constants.full_logging) then
1294: wip_logger.log('before insert', l_dummy);
1295: wip_logger.log('before insert item' || cmpRecord.inventory_item_id, l_dummy);
1296: wip_logger.log('before insert org' || cmpRecord.organization_id, l_dummy);
1297: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1298: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1299: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);

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

1292: BEGIN
1293: if (l_logLevel <= wip_constants.full_logging) then
1294: wip_logger.log('before insert', l_dummy);
1295: wip_logger.log('before insert item' || cmpRecord.inventory_item_id, l_dummy);
1296: wip_logger.log('before insert org' || cmpRecord.organization_id, l_dummy);
1297: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1298: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1299: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);
1300: wip_logger.log('before insert movTxnID ' || cmpRecord.move_transaction_id, l_dummy);

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

1293: if (l_logLevel <= wip_constants.full_logging) then
1294: wip_logger.log('before insert', l_dummy);
1295: wip_logger.log('before insert item' || cmpRecord.inventory_item_id, l_dummy);
1296: wip_logger.log('before insert org' || cmpRecord.organization_id, l_dummy);
1297: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1298: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1299: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);
1300: wip_logger.log('before insert movTxnID ' || cmpRecord.move_transaction_id, l_dummy);
1301: wip_logger.log('before insert demandsourceheaderID ' || cmpRecord.demand_source_header_id, l_dummy);

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

1294: wip_logger.log('before insert', l_dummy);
1295: wip_logger.log('before insert item' || cmpRecord.inventory_item_id, l_dummy);
1296: wip_logger.log('before insert org' || cmpRecord.organization_id, l_dummy);
1297: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1298: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1299: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);
1300: wip_logger.log('before insert movTxnID ' || cmpRecord.move_transaction_id, l_dummy);
1301: wip_logger.log('before insert demandsourceheaderID ' || cmpRecord.demand_source_header_id, l_dummy);
1302: wip_logger.log('before insert demandsourcelineID ' || cmpRecord.demand_source_line_id, l_dummy);

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

1295: wip_logger.log('before insert item' || cmpRecord.inventory_item_id, l_dummy);
1296: wip_logger.log('before insert org' || cmpRecord.organization_id, l_dummy);
1297: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1298: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1299: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);
1300: wip_logger.log('before insert movTxnID ' || cmpRecord.move_transaction_id, l_dummy);
1301: wip_logger.log('before insert demandsourceheaderID ' || cmpRecord.demand_source_header_id, l_dummy);
1302: wip_logger.log('before insert demandsourcelineID ' || cmpRecord.demand_source_line_id, l_dummy);
1303: end if;

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

1296: wip_logger.log('before insert org' || cmpRecord.organization_id, l_dummy);
1297: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1298: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1299: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);
1300: wip_logger.log('before insert movTxnID ' || cmpRecord.move_transaction_id, l_dummy);
1301: wip_logger.log('before insert demandsourceheaderID ' || cmpRecord.demand_source_header_id, l_dummy);
1302: wip_logger.log('before insert demandsourcelineID ' || cmpRecord.demand_source_line_id, l_dummy);
1303: end if;
1304:

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

1297: wip_logger.log('before insert subinv' || cmpRecord.subinventory_code, l_dummy);
1298: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1299: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);
1300: wip_logger.log('before insert movTxnID ' || cmpRecord.move_transaction_id, l_dummy);
1301: wip_logger.log('before insert demandsourceheaderID ' || cmpRecord.demand_source_header_id, l_dummy);
1302: wip_logger.log('before insert demandsourcelineID ' || cmpRecord.demand_source_line_id, l_dummy);
1303: end if;
1304:
1305: insert into mtl_transactions_interface

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

1298: wip_logger.log('before insert loc' || cmpRecord.locator_id, l_dummy);
1299: wip_logger.log('before insert action' || cmpRecord.transaction_action_id, l_dummy);
1300: wip_logger.log('before insert movTxnID ' || cmpRecord.move_transaction_id, l_dummy);
1301: wip_logger.log('before insert demandsourceheaderID ' || cmpRecord.demand_source_header_id, l_dummy);
1302: wip_logger.log('before insert demandsourcelineID ' || cmpRecord.demand_source_line_id, l_dummy);
1303: end if;
1304:
1305: insert into mtl_transactions_interface
1306: (transaction_header_id,

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

1393: wip_constants.ASSY_BATCH_SEQ,
1394: cmpRecord.demand_source_header_id,
1395: cmpRecord.demand_source_line_id);
1396: if (l_logLevel <= wip_constants.full_logging) then
1397: wip_logger.log('after insert', l_dummy);
1398: end if;
1399:
1400:
1401: wip_mtlTempProc_priv.validateInterfaceTxns(p_txnHdrID => cmpRecord.transaction_header_id,

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

1403: x_returnStatus => l_retStatus);
1404:
1405: if(l_retStatus <> fnd_api.g_ret_sts_success) then
1406: if (l_logLevel <= wip_constants.full_logging) then
1407: wip_logger.log('error from validateInterfaceTxns', l_retStatus);
1408: end if;
1409: wip_utilities.get_message_stack(p_msg => errMessage);
1410: return false;
1411: end if;

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

1412: return true;
1413: EXCEPTION
1414: when others then
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);

Line 1521: l_params wip_logger.param_tbl_t;

1517: l_assyPullStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
1518: l_opPullStatus VARCHAR2(1) := fnd_api.g_ret_sts_success;
1519: l_compTbl system.wip_component_tbl_t;
1520: l_returnStatus VARCHAR2(1);
1521: l_params wip_logger.param_tbl_t;
1522: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
1523: begin
1524: if (l_logLevel <= wip_constants.trace_logging) then
1525: l_params(1).paramName := 'not printing params';

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;