DBA Data[Home] [Help]

APPS.WMA_MOVE dependencies on WMA_MOVE

Line 1: PACKAGE BODY wma_move AS

1: PACKAGE BODY wma_move AS
2: /* $Header: wmapmovb.pls 120.3 2007/09/17 21:26:29 kboonyap ship $ */
3:
4: /**
5: * This procedure is the entry point into the Move Processing code

Line 27: wip_logger.entryPoint(p_procName => 'wma_move.process',

23: BEGIN
24: if (l_logLevel <= wip_constants.trace_logging) then
25: l_params(1).paramName := 'not printing params';
26: l_params(1).paramValue := ' ';
27: wip_logger.entryPoint(p_procName => 'wma_move.process',
28: p_params => l_params,
29: x_returnStatus => l_returnStatus);
30: end if;
31:

Line 74: wip_logger.exitPoint(p_procName => 'wma_move.process',

70: status => status,
71: errMessage => errMessage);
72: IF(status <> 0) THEN
73: if (l_logLevel <= wip_constants.trace_logging) then
74: wip_logger.exitPoint(p_procName => 'wma_move.process',
75: p_procReturnStatus => status,
76: p_msg => errMessage,
77: x_returnStatus => l_returnStatus);
78: end if;

Line 92: wip_logger.exitPoint(p_procName => 'wma_move.process',

88: -- process error
89: status := -1;
90: errMessage := error;
91: if (l_logLevel <= wip_constants.trace_logging) then
92: wip_logger.exitPoint(p_procName => 'wma_move.process',
93: p_procReturnStatus => status,
94: p_msg => errMessage,
95: x_returnStatus => l_returnStatus);
96: end if;

Line 107: wip_logger.exitPoint(p_procName => 'wma_move.process',

103: -- process error
104: status := -1;
105: errMessage := error;
106: if (l_logLevel <= wip_constants.trace_logging) then
107: wip_logger.exitPoint(p_procName => 'wma_move.process',
108: p_procReturnStatus => status,
109: p_msg => errMessage,
110: x_returnStatus => l_returnStatus);
111: end if;

Line 126: wip_logger.exitPoint(p_procName => 'wma_move.process',

122: -- process error
123: status := -1;
124: errMessage := error;
125: if (l_logLevel <= wip_constants.trace_logging) then
126: wip_logger.exitPoint(p_procName => 'wma_move.process',
127: p_procReturnStatus => status,
128: p_msg => errMessage,
129: x_returnStatus => l_returnStatus);
130: end if;

Line 213: wip_logger.exitPoint(p_procName => 'wma_move.process',

209: status => status,
210: errMessage => errMessage);
211: IF(status <> 0) THEN
212: if (l_logLevel <= wip_constants.trace_logging) then
213: wip_logger.exitPoint(p_procName => 'wma_move.process',
214: p_procReturnStatus => status,
215: p_msg => errMessage,
216: x_returnStatus => l_returnStatus);
217: end if;

Line 223: wip_logger.exitPoint(p_procName => 'wma_move.process',

219: END IF;
220: END IF; -- Easy Complete
221:
222: if (l_logLevel <= wip_constants.trace_logging) then
223: wip_logger.exitPoint(p_procName => 'wma_move.process',
224: p_procReturnStatus => status,
225: p_msg => 'success',
226: x_returnStatus => l_returnStatus);
227: end if;

Line 234: wip_logger.exitPoint(p_procName => 'wma_move.process',

230: WHEN fnd_api.g_exc_unexpected_error THEN
231: status := -1;
232: wip_utilities.get_message_stack(p_msg => errMessage);
233: if (l_logLevel <= wip_constants.trace_logging) then
234: wip_logger.exitPoint(p_procName => 'wma_move.process',
235: p_procReturnStatus => status,
236: p_msg => errMessage,
237: x_returnStatus => l_returnStatus);
238: end if;

Line 242: fnd_message.set_token ('FUNCTION', 'wma_move.process');

238: end if;
239: WHEN others THEN
240: status := -1;
241: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
242: fnd_message.set_token ('FUNCTION', 'wma_move.process');
243: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
244: errMessage := fnd_message.get;
245: if (l_logLevel <= wip_constants.trace_logging) then
246: wip_logger.exitPoint(p_procName => 'wma_move.process',

Line 246: wip_logger.exitPoint(p_procName => 'wma_move.process',

242: fnd_message.set_token ('FUNCTION', 'wma_move.process');
243: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
244: errMessage := fnd_message.get;
245: if (l_logLevel <= wip_constants.trace_logging) then
246: wip_logger.exitPoint(p_procName => 'wma_move.process',
247: p_procReturnStatus => status,
248: p_msg => errMessage,
249: x_returnStatus => l_returnStatus);
250: end if;

Line 319: wip_logger.entryPoint(p_procName =>'wma_move.backflush',

315: l_params(12).paramValue := p_to_step;
316: l_params(13).paramName := 'p_moveQty';
317: l_params(13).paramValue := p_moveQty;
318: -- write parameter value to log file
319: wip_logger.entryPoint(p_procName =>'wma_move.backflush',
320: p_params => l_params,
321: x_returnStatus => l_returnStatus);
322: end if;
323:

Line 666: wip_logger.exitPoint(p_procName => 'wma_move.backflush',

662: END IF;
663: END IF;
664: x_returnStatus := fnd_api.g_ret_sts_success;
665: if (l_logLevel <= wip_constants.trace_logging) then
666: wip_logger.exitPoint(p_procName => 'wma_move.backflush',
667: p_procReturnStatus => x_returnStatus,
668: p_msg => 'procedure complete',
669: x_returnStatus => l_returnStatus);
670: end if;

Line 676: wip_logger.exitPoint(p_procName => 'wma_move.backflush',

672: WHEN fnd_api.g_exc_unexpected_error THEN
673: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
674: x_errMessage := fnd_msg_pub.get(p_encoded => 'F');
675: if (l_logLevel <= wip_constants.trace_logging) then
676: wip_logger.exitPoint(p_procName => 'wma_move.backflush',
677: p_procReturnStatus => x_returnStatus,
678: p_msg => x_errMessage,
679: x_returnStatus => l_returnStatus);
680: end if;

Line 685: wip_logger.exitPoint(p_procName => 'wma_move.backflush',

681: WHEN others THEN
682: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
683: x_errMessage := 'unexpected error: ' || SQLERRM;
684: if (l_logLevel <= wip_constants.trace_logging) then
685: wip_logger.exitPoint(p_procName => 'wma_move.backflush',
686: p_procReturnStatus => x_returnStatus,
687: p_msg => x_errMessage,
688: x_returnStatus => l_returnStatus);
689: end if;

Line 736: fnd_message.set_token('INTERFACE', 'wma_move.derive', TRUE);

732: job := wma_derive.getJob(parameters.wipEntityID);
733:
734: if (job.wipEntityID is null) then
735: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
736: fnd_message.set_token('INTERFACE', 'wma_move.derive', TRUE);
737: errMessage := fnd_message.get;
738: return false;
739: end if;
740:

Line 885: fnd_message.set_token ('FUNCTION', 'wma_move.derive');

881:
882: EXCEPTION
883: when others then
884: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
885: fnd_message.set_token ('FUNCTION', 'wma_move.derive');
886: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
887: errMessage := fnd_message.get;
888: return false;
889: END derive;

Line 978: wip_logger.entryPoint(p_procName =>'wma_move.assy_pull_bf',

974: l_params(5).paramValue := p_to_step;
975: l_params(6).paramName := 'p_moveQty';
976: l_params(6).paramValue := p_moveQty;
977: -- write parameter value to log file
978: wip_logger.entryPoint(p_procName =>'wma_move.assy_pull_bf',
979: p_params => l_params,
980: x_returnStatus => l_returnStatus);
981: end if;
982:

Line 1007: wip_logger.exitPoint(p_procName => 'wma_move.assy_pull_bf',

1003: -- we don't need to set anything
1004:
1005: x_returnStatus := fnd_api.g_ret_sts_success;
1006: if (l_logLevel <= wip_constants.trace_logging) then
1007: wip_logger.exitPoint(p_procName => 'wma_move.assy_pull_bf',
1008: p_procReturnStatus => x_returnStatus,
1009: p_msg => 'procedure complete',
1010: x_returnStatus => l_returnStatus);
1011: end if;

Line 1031: wip_logger.exitPoint(p_procName => 'wma_move.assy_pull_bf',

1027: END IF;
1028: x_errMessage := 'unexpected error: ' || SQLERRM;
1029: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1030: if (l_logLevel <= wip_constants.trace_logging) then
1031: wip_logger.exitPoint(p_procName => 'wma_move.assy_pull_bf',
1032: p_procReturnStatus => x_returnStatus,
1033: p_msg => x_errMessage,
1034: x_returnStatus => l_returnStatus);
1035: end if;

Line 1173: wip_logger.entryPoint(p_procName =>'wma_move.bf_require',

1169: l_params(6).paramValue := p_moveQty;
1170:
1171: -- write parameter value to log file
1172: if (l_logLevel <= wip_constants.trace_logging) then
1173: wip_logger.entryPoint(p_procName =>'wma_move.bf_require',
1174: p_params => l_params,
1175: x_returnStatus => l_returnStatus);
1176: end if;
1177:

Line 1219: wip_logger.exitPoint(p_procName => 'wma_move.bf_require',

1215: -- we don't need to set anything
1216:
1217: x_returnStatus := fnd_api.g_ret_sts_success;
1218: if (l_logLevel <= wip_constants.trace_logging) then
1219: wip_logger.exitPoint(p_procName => 'wma_move.bf_require',
1220: p_procReturnStatus => x_returnStatus,
1221: p_msg => 'procedure complete',
1222: x_returnStatus => l_returnStatus);
1223: end if;

Line 1249: wip_logger.exitPoint(p_procName => 'wma_move.bf_require',

1245: END IF;
1246: x_errMessage := 'unexpected error: ' || SQLERRM;
1247: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1248: if (l_logLevel <= wip_constants.trace_logging) then
1249: wip_logger.exitPoint(p_procName => 'wma_move.bf_require',
1250: p_procReturnStatus => x_returnStatus,
1251: p_msg => x_errMessage,
1252: x_returnStatus => l_returnStatus);
1253: end if;

Line 1286: wip_logger.entryPoint(p_procName => 'wma_move.validate',

1282: BEGIN
1283: if (l_logLevel <= wip_constants.trace_logging) then
1284: l_params(1).paramName := 'not printing params';
1285: l_params(1).paramValue := ' ';
1286: wip_logger.entryPoint(p_procName => 'wma_move.validate',
1287: p_params => l_params,
1288: x_returnStatus => l_returnStatus);
1289: end if;
1290:

Line 1305: wip_logger.exitPoint(p_procName => 'wma_move.validate',

1301: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
1302: x_errMessage := fnd_message.get;
1303: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1304: if (l_logLevel <= wip_constants.trace_logging) then
1305: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1306: p_procReturnStatus => x_returnStatus,
1307: p_msg => x_errMessage,
1308: x_returnStatus => l_returnStatus);
1309: end if;

Line 1334: wip_logger.exitPoint(p_procName => 'wma_move.validate',

1330: fnd_message.set_name ('WIP', 'WIP_STATUS_NO_TXN1');
1331: x_errMessage := fnd_message.get;
1332: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1333: if (l_logLevel <= wip_constants.trace_logging) then
1334: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1335: p_procReturnStatus => x_returnStatus,
1336: p_msg => x_errMessage,
1337: x_returnStatus => l_returnStatus);
1338: end if;

Line 1358: wip_logger.exitPoint(p_procName => 'wma_move.validate',

1354: fnd_message.set_name ('WIP', 'WIP_NO_MOVE_SF_STATUS_BETWEEN');
1355: x_errMessage := fnd_message.get;
1356: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1357: if (l_logLevel <= wip_constants.trace_logging) then
1358: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1359: p_procReturnStatus => x_returnStatus,
1360: p_msg => x_errMessage,
1361: x_returnStatus => l_returnStatus);
1362: end if;

Line 1380: wip_logger.exitPoint(p_procName => 'wma_move.validate',

1376: x_msg => message,
1377: x_error => x_errMessage) = false) THEN
1378: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1379: if (l_logLevel <= wip_constants.trace_logging) then
1380: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1381: p_procReturnStatus => x_returnStatus,
1382: p_msg => x_errMessage,
1383: x_returnStatus => l_returnStatus);
1384: end if;

Line 1390: wip_logger.exitPoint(p_procName => 'wma_move.validate',

1386: END IF;
1387: END IF;
1388: x_returnStatus := fnd_api.g_ret_sts_success;
1389: if (l_logLevel <= wip_constants.trace_logging) then
1390: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1391: p_procReturnStatus => x_returnStatus,
1392: p_msg => 'success',
1393: x_returnStatus => l_returnStatus);
1394: end if;

Line 1400: wip_logger.exitPoint(p_procName => 'wma_move.validate',

1396: WHEN others THEN
1397: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1398: x_errMessage := 'unexpected error: ' || SQLERRM;
1399: if (l_logLevel <= wip_constants.trace_logging) then
1400: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1401: p_procReturnStatus => x_returnStatus,
1402: p_msg => x_errMessage,
1403: x_returnStatus => l_returnStatus);
1404: end if;

Line 1510: fnd_message.set_token ('FUNCTION', 'wma_move.put');

1506:
1507: EXCEPTION
1508: when others then
1509: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1510: fnd_message.set_token ('FUNCTION', 'wma_move.put');
1511: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1512: errMessage := fnd_message.get;
1513: return false;
1514: END put;

Line 1568: fnd_message.set_token ('FUNCTION', 'wma_move.insertSerial');

1564:
1565: EXCEPTION
1566: when others then
1567: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1568: fnd_message.set_token ('FUNCTION', 'wma_move.insertSerial');
1569: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1570: errMessage := fnd_message.get;
1571: return false;
1572: END insertSerial;

Line 1573: END wma_move;

1569: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1570: errMessage := fnd_message.get;
1571: return false;
1572: END insertSerial;
1573: END wma_move;