264: ELSE
265: IF(l_ls_required = WIP_CONSTANTS.YES) THEN
266: -- If we need to gather more lot/serial, error out because
267: -- we cannot gather lot/serial for background transaction.
268: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
269: fnd_msg_pub.add;
270: raise fnd_api.g_exc_unexpected_error;
271: END IF;
272: END IF; -- check return status
308: ELSE
309: IF(l_ls_required = WIP_CONSTANTS.YES) THEN
310: -- If we need to gather more lot/serial, error out because
311: -- we cannot gather lot/serial for background transaction.
312: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
313: fnd_msg_pub.add;
314: raise fnd_api.g_exc_unexpected_error;
315: END IF;
316: END IF; -- check return status
356: ELSE
357: IF(l_ls_required = WIP_CONSTANTS.YES) THEN
358: -- If we need to gather more lot/serial, error out because
359: -- we cannot gather lot/serial for background transaction.
360: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
361: fnd_msg_pub.add;
362: raise fnd_api.g_exc_unexpected_error;
363: END IF;
364: END IF; -- check return status
396: ELSE
397: IF(l_ls_required = WIP_CONSTANTS.YES) THEN
398: -- If we need to gather more lot/serial, error out because
399: -- we cannot gather lot/serial for background transaction.
400: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
401: fnd_msg_pub.add;
402: raise fnd_api.g_exc_unexpected_error;
403: END IF;
404: END IF; -- check return status
449: AND mti.move_transaction_id = wmti.transaction_id
450: AND mti.error_explanation IS NOT NULL);
451:
452: IF (l_logLevel <= wip_constants.full_logging) THEN
453: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
454: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
455: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
456: l_msg := fnd_message.get;
457: wip_logger.log(p_msg => l_msg,
450: AND mti.error_explanation IS NOT NULL);
451:
452: IF (l_logLevel <= wip_constants.full_logging) THEN
453: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
454: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
455: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
456: l_msg := fnd_message.get;
457: wip_logger.log(p_msg => l_msg,
458: x_returnStatus => l_returnStatus);
451:
452: IF (l_logLevel <= wip_constants.full_logging) THEN
453: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
454: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
455: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
456: l_msg := fnd_message.get;
457: wip_logger.log(p_msg => l_msg,
458: x_returnStatus => l_returnStatus);
459: END IF;
452: IF (l_logLevel <= wip_constants.full_logging) THEN
453: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
454: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
455: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
456: l_msg := fnd_message.get;
457: wip_logger.log(p_msg => l_msg,
458: x_returnStatus => l_returnStatus);
459: END IF;
460:
668: p_procReturnStatus => l_returnStatus,
669: p_msg => l_errMsg,
670: x_returnStatus => l_returnStatus);
671: END IF;
672: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
673: fnd_message.set_token('MESSAGE', l_errMsg);
674: fnd_msg_pub.add;
675: END write_mtl_errors;
676:
669: p_msg => l_errMsg,
670: x_returnStatus => l_returnStatus);
671: END IF;
672: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
673: fnd_message.set_token('MESSAGE', l_errMsg);
674: fnd_msg_pub.add;
675: END write_mtl_errors;
676:
677: /*****************************************************************************
757: p_procReturnStatus => x_returnStatus,
758: p_msg => l_errMsg,
759: x_returnStatus => l_returnStatus);
760: END IF;
761: fnd_message.set_name('INV','INV_WIP_WORK_ORDER_LOCKED');
762: fnd_msg_pub.add;
763:
764: WHEN others THEN
765: IF(c_wipops%ISOPEN) THEN
773: p_procReturnStatus => x_returnStatus,
774: p_msg => l_errMsg,
775: x_returnStatus => l_returnStatus);
776: END IF;
777: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
778: fnd_message.set_token('MESSAGE', l_errMsg);
779: fnd_msg_pub.add;
780: END lock_wipops;
781:
774: p_msg => l_errMsg,
775: x_returnStatus => l_returnStatus);
776: END IF;
777: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
778: fnd_message.set_token('MESSAGE', l_errMsg);
779: fnd_msg_pub.add;
780: END lock_wipops;
781:
782: /*****************************************************************************
1047: x_returnStatus => l_returnStatus);
1048: END IF;
1049:
1050: /* Fix for bug 5373061: Passed missing token */
1051: fnd_message.set_name('WIP','WIP_INT_ERROR_NO_SCHED');
1052: fnd_message.set_token('ROUTINE', 'wip_movProc_priv.schedule_alloc');
1053: fnd_msg_pub.add;
1054:
1055: WHEN others THEN
1048: END IF;
1049:
1050: /* Fix for bug 5373061: Passed missing token */
1051: fnd_message.set_name('WIP','WIP_INT_ERROR_NO_SCHED');
1052: fnd_message.set_token('ROUTINE', 'wip_movProc_priv.schedule_alloc');
1053: fnd_msg_pub.add;
1054:
1055: WHEN others THEN
1056: IF(c_rsa%ISOPEN) THEN
1065: p_procReturnStatus => x_returnStatus,
1066: p_msg => l_errMsg,
1067: x_returnStatus => l_returnStatus);
1068: END IF;
1069: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1070: fnd_message.set_token('MESSAGE', l_errMsg);
1071: fnd_msg_pub.add;
1072: END schedule_alloc;
1073:
1066: p_msg => l_errMsg,
1067: x_returnStatus => l_returnStatus);
1068: END IF;
1069: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1070: fnd_message.set_token('MESSAGE', l_errMsg);
1071: fnd_msg_pub.add;
1072: END schedule_alloc;
1073:
1074: /*****************************************************************************
1208: p_msg => l_errMsg,
1209: x_returnStatus => l_returnStatus);
1210: END IF;
1211:
1212: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1213: fnd_message.set_token('MESSAGE', l_msgData);
1214: fnd_msg_pub.add;
1215:
1216: WHEN others THEN
1209: x_returnStatus => l_returnStatus);
1210: END IF;
1211:
1212: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1213: fnd_message.set_token('MESSAGE', l_msgData);
1214: fnd_msg_pub.add;
1215:
1216: WHEN others THEN
1217: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1222: p_procReturnStatus => x_returnStatus,
1223: p_msg => l_errMsg,
1224: x_returnStatus => l_returnStatus);
1225: END IF;
1226: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1227: fnd_message.set_token('MESSAGE', l_errMsg);
1228: fnd_msg_pub.add;
1229: END insert_alloc_child;
1230:
1223: p_msg => l_errMsg,
1224: x_returnStatus => l_returnStatus);
1225: END IF;
1226: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1227: fnd_message.set_token('MESSAGE', l_errMsg);
1228: fnd_msg_pub.add;
1229: END insert_alloc_child;
1230:
1231: /*****************************************************************************
1424: p_procReturnStatus => x_returnStatus,
1425: p_msg => l_errMsg,
1426: x_returnStatus => l_returnStatus);
1427: END IF;
1428: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1429: fnd_message.set_token('MESSAGE', l_errMsg);
1430: fnd_msg_pub.add;
1431: END update_wo_rs;
1432:
1425: p_msg => l_errMsg,
1426: x_returnStatus => l_returnStatus);
1427: END IF;
1428: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1429: fnd_message.set_token('MESSAGE', l_errMsg);
1430: fnd_msg_pub.add;
1431: END update_wo_rs;
1432:
1433:
1536: p_procReturnStatus => x_returnStatus,
1537: p_msg => l_errMsg,
1538: x_returnStatus => l_returnStatus);
1539: END IF;
1540: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1541: fnd_message.set_token('MESSAGE', l_errMsg);
1542: fnd_msg_pub.add;
1543: END update_wipops;
1544:
1537: p_msg => l_errMsg,
1538: x_returnStatus => l_returnStatus);
1539: END IF;
1540: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1541: fnd_message.set_token('MESSAGE', l_errMsg);
1542: fnd_msg_pub.add;
1543: END update_wipops;
1544:
1545: /*****************************************************************************
1851: END IF; -- time out check
1852: END IF; -- BACKGROUND check
1853:
1854: IF(l_proc_status = TVE_OVERCOMPLETION_MISMATCH) THEN
1855: fnd_message.set_name('WIP', 'WIP_OVERCOMPLETION_MISMATCH');
1856: fnd_msg_pub.add;
1857: l_errMsg := 'parent txn is not really overcompletion txn';
1858: raise fnd_api.g_exc_unexpected_error;
1859: ELSE
1856: fnd_msg_pub.add;
1857: l_errMsg := 'parent txn is not really overcompletion txn';
1858: raise fnd_api.g_exc_unexpected_error;
1859: ELSE
1860: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1861: fnd_message.set_token('ENTITY1', 'transaction quantity');
1862: fnd_message.set_token('ENTITY2', 'quantity available to move');
1863: fnd_msg_pub.add;
1864: l_errMsg := 'available qty is not enough to fullfill move txn';
1857: l_errMsg := 'parent txn is not really overcompletion txn';
1858: raise fnd_api.g_exc_unexpected_error;
1859: ELSE
1860: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1861: fnd_message.set_token('ENTITY1', 'transaction quantity');
1862: fnd_message.set_token('ENTITY2', 'quantity available to move');
1863: fnd_msg_pub.add;
1864: l_errMsg := 'available qty is not enough to fullfill move txn';
1865: raise fnd_api.g_exc_unexpected_error;
1858: raise fnd_api.g_exc_unexpected_error;
1859: ELSE
1860: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1861: fnd_message.set_token('ENTITY1', 'transaction quantity');
1862: fnd_message.set_token('ENTITY2', 'quantity available to move');
1863: fnd_msg_pub.add;
1864: l_errMsg := 'available qty is not enough to fullfill move txn';
1865: raise fnd_api.g_exc_unexpected_error;
1866: END IF;
1904: wip_utilities.get_message_stack(p_msg =>l_msg);
1905: IF(l_msg IS NULL) THEN
1906: -- initialize message to something because we cannot insert
1907: -- null into WIP_TXN_INTERFACE_ERRORS
1908: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
1909: l_msg := fnd_message.get;
1910: END IF;
1911:
1912: INSERT INTO WIP_TXN_INTERFACE_ERRORS
1905: IF(l_msg IS NULL) THEN
1906: -- initialize message to something because we cannot insert
1907: -- null into WIP_TXN_INTERFACE_ERRORS
1908: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
1909: l_msg := fnd_message.get;
1910: END IF;
1911:
1912: INSERT INTO WIP_TXN_INTERFACE_ERRORS
1913: (transaction_id,
1992: p_procReturnStatus => x_returnStatus,
1993: p_msg => l_errMsg,
1994: x_returnStatus => l_returnStatus);
1995: END IF;
1996: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1997: fnd_message.set_token('MESSAGE', l_errMsg);
1998: fnd_msg_pub.add;
1999: END rep_move_alloc;
2000:
1993: p_msg => l_errMsg,
1994: x_returnStatus => l_returnStatus);
1995: END IF;
1996: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1997: fnd_message.set_token('MESSAGE', l_errMsg);
1998: fnd_msg_pub.add;
1999: END rep_move_alloc;
2000:
2001: /*****************************************************************************
2202: p_procReturnStatus => x_returnStatus,
2203: p_msg => l_errMsg,
2204: x_returnStatus => l_returnStatus);
2205: END IF;
2206: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2207: fnd_message.set_token('MESSAGE', l_errMsg);
2208: fnd_msg_pub.add;
2209: END update_wo_dj;
2210:
2203: p_msg => l_errMsg,
2204: x_returnStatus => l_returnStatus);
2205: END IF;
2206: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2207: fnd_message.set_token('MESSAGE', l_errMsg);
2208: fnd_msg_pub.add;
2209: END update_wo_dj;
2210:
2211: /*****************************************************************************
2353: IF(l_dj_txn.txn_type IN (WIP_CONSTANTS.COMP_TXN,
2354: WIP_CONSTANTS.MOVE_TXN) AND
2355: (l_ser_loc.sn_op <> l_dj_txn.fm_op OR
2356: l_ser_loc.sn_step <> l_dj_txn.fm_step)) THEN
2357: fnd_message.set_name('WIP', 'WIP_SERIAL_LOCATION_MISSMATCH');
2358: fnd_msg_pub.add;
2359: l_errMsg := 'current serial location missmatch';
2360: raise fnd_api.g_exc_unexpected_error;
2361: ELSE -- serial location is valid to move
2450: WHERE transaction_id = l_dj_txn.txn_id
2451: AND group_id = p_gib.group_id;
2452: END IF; -- time out check
2453: END IF; -- BACKGROUND check
2454: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
2455: fnd_message.set_token('ENTITY1', 'transaction quantity');
2456: fnd_message.set_token('ENTITY2', 'quantity available to move');
2457: fnd_msg_pub.add;
2458: l_errMsg := 'available qty is not enough to fullfill move txn';
2451: AND group_id = p_gib.group_id;
2452: END IF; -- time out check
2453: END IF; -- BACKGROUND check
2454: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
2455: fnd_message.set_token('ENTITY1', 'transaction quantity');
2456: fnd_message.set_token('ENTITY2', 'quantity available to move');
2457: fnd_msg_pub.add;
2458: l_errMsg := 'available qty is not enough to fullfill move txn';
2459: raise fnd_api.g_exc_unexpected_error;
2452: END IF; -- time out check
2453: END IF; -- BACKGROUND check
2454: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
2455: fnd_message.set_token('ENTITY1', 'transaction quantity');
2456: fnd_message.set_token('ENTITY2', 'quantity available to move');
2457: fnd_msg_pub.add;
2458: l_errMsg := 'available qty is not enough to fullfill move txn';
2459: raise fnd_api.g_exc_unexpected_error;
2460: ELSE -- enough qty to move
2590: wip_utilities.get_message_stack(p_msg =>l_msg);
2591: IF(l_msg IS NULL) THEN
2592: -- initialize message to something because we cannot insert
2593: -- null into WIP_TXN_INTERFACE_ERRORS
2594: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
2595: l_msg := fnd_message.get;
2596: END IF;
2597:
2598: INSERT INTO WIP_TXN_INTERFACE_ERRORS
2591: IF(l_msg IS NULL) THEN
2592: -- initialize message to something because we cannot insert
2593: -- null into WIP_TXN_INTERFACE_ERRORS
2594: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
2595: l_msg := fnd_message.get;
2596: END IF;
2597:
2598: INSERT INTO WIP_TXN_INTERFACE_ERRORS
2599: (transaction_id,
2672: p_procReturnStatus => x_returnStatus,
2673: p_msg => l_errMsg,
2674: x_returnStatus => l_returnStatus);
2675: END IF;
2676: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2677: fnd_message.set_token('MESSAGE', l_errMsg);
2678: fnd_msg_pub.add;
2679: END check_qty_dj;
2680:
2673: p_msg => l_errMsg,
2674: x_returnStatus => l_returnStatus);
2675: END IF;
2676: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2677: fnd_message.set_token('MESSAGE', l_errMsg);
2678: fnd_msg_pub.add;
2679: END check_qty_dj;
2680:
2681: /*****************************************************************************
2879: p_procReturnStatus => x_returnStatus,
2880: p_msg => l_errMsg,
2881: x_returnStatus => l_returnStatus);
2882: END IF;
2883: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2884: fnd_message.set_token('MESSAGE', l_errMsg);
2885: fnd_msg_pub.add;
2886: END get_move_profile;
2887:
2880: p_msg => l_errMsg,
2881: x_returnStatus => l_returnStatus);
2882: END IF;
2883: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2884: fnd_message.set_token('MESSAGE', l_errMsg);
2885: fnd_msg_pub.add;
2886: END get_move_profile;
2887:
2888: /*****************************************************************************
2953: AND wmti.process_status = WIP_CONSTANTS.RUNNING;
2954:
2955: -- IF debug message level = 2, write statement below to log file
2956: IF (l_logLevel <= wip_constants.full_logging) THEN
2957: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
2958: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
2959: fnd_message.set_token('ENTITY2', 'WIP_SERIAL_MOVE_TRANSACTIONS');
2960: l_msg := fnd_message.get;
2961: wip_logger.log(p_msg => l_msg,
2954:
2955: -- IF debug message level = 2, write statement below to log file
2956: IF (l_logLevel <= wip_constants.full_logging) THEN
2957: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
2958: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
2959: fnd_message.set_token('ENTITY2', 'WIP_SERIAL_MOVE_TRANSACTIONS');
2960: l_msg := fnd_message.get;
2961: wip_logger.log(p_msg => l_msg,
2962: x_returnStatus => l_returnStatus);
2955: -- IF debug message level = 2, write statement below to log file
2956: IF (l_logLevel <= wip_constants.full_logging) THEN
2957: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
2958: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
2959: fnd_message.set_token('ENTITY2', 'WIP_SERIAL_MOVE_TRANSACTIONS');
2960: l_msg := fnd_message.get;
2961: wip_logger.log(p_msg => l_msg,
2962: x_returnStatus => l_returnStatus);
2963: END IF;
2956: IF (l_logLevel <= wip_constants.full_logging) THEN
2957: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
2958: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
2959: fnd_message.set_token('ENTITY2', 'WIP_SERIAL_MOVE_TRANSACTIONS');
2960: l_msg := fnd_message.get;
2961: wip_logger.log(p_msg => l_msg,
2962: x_returnStatus => l_returnStatus);
2963: END IF;
2964:
3096: AND wdj.organization_id = wmti.organization_id;
3097:
3098: -- IF debug message level = 2, write statement below to log file
3099: IF (l_logLevel <= wip_constants.full_logging) THEN
3100: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3101: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3102: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
3103: l_msg := fnd_message.get;
3104: wip_logger.log(p_msg => l_msg,
3097:
3098: -- IF debug message level = 2, write statement below to log file
3099: IF (l_logLevel <= wip_constants.full_logging) THEN
3100: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3101: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3102: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
3103: l_msg := fnd_message.get;
3104: wip_logger.log(p_msg => l_msg,
3105: x_returnStatus => l_returnStatus);
3098: -- IF debug message level = 2, write statement below to log file
3099: IF (l_logLevel <= wip_constants.full_logging) THEN
3100: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3101: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3102: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
3103: l_msg := fnd_message.get;
3104: wip_logger.log(p_msg => l_msg,
3105: x_returnStatus => l_returnStatus);
3106: END IF;
3099: IF (l_logLevel <= wip_constants.full_logging) THEN
3100: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3101: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3102: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
3103: l_msg := fnd_message.get;
3104: wip_logger.log(p_msg => l_msg,
3105: x_returnStatus => l_returnStatus);
3106: END IF;
3107:
3226: AND wmti.entity_type = WIP_CONSTANTS.REPETITIVE;
3227:
3228: -- IF debug message level = 2, write statement below to log file
3229: IF (l_logLevel <= wip_constants.full_logging) THEN
3230: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3231: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3232: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
3233: l_msg := fnd_message.get;
3234: wip_logger.log(p_msg => l_msg,
3227:
3228: -- IF debug message level = 2, write statement below to log file
3229: IF (l_logLevel <= wip_constants.full_logging) THEN
3230: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3231: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3232: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
3233: l_msg := fnd_message.get;
3234: wip_logger.log(p_msg => l_msg,
3235: x_returnStatus => l_returnStatus);
3228: -- IF debug message level = 2, write statement below to log file
3229: IF (l_logLevel <= wip_constants.full_logging) THEN
3230: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3231: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3232: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
3233: l_msg := fnd_message.get;
3234: wip_logger.log(p_msg => l_msg,
3235: x_returnStatus => l_returnStatus);
3236: END IF;
3229: IF (l_logLevel <= wip_constants.full_logging) THEN
3230: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3231: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3232: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
3233: l_msg := fnd_message.get;
3234: wip_logger.log(p_msg => l_msg,
3235: x_returnStatus => l_returnStatus);
3236: END IF;
3237:
3255: p_procReturnStatus => x_returnStatus,
3256: p_msg => l_errMsg,
3257: x_returnStatus => l_returnStatus);
3258: END IF;
3259: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3260: fnd_message.set_token('MESSAGE', l_errMsg);
3261: fnd_msg_pub.add;
3262: END insert_txn_history;
3263:
3256: p_msg => l_errMsg,
3257: x_returnStatus => l_returnStatus);
3258: END IF;
3259: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3260: fnd_message.set_token('MESSAGE', l_errMsg);
3261: fnd_msg_pub.add;
3262: END insert_txn_history;
3263:
3264: /*****************************************************************************
3320: p_procReturnStatus => x_returnStatus,
3321: p_msg => l_errMsg,
3322: x_returnStatus => l_returnStatus);
3323: END IF;
3324: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3325: fnd_message.set_token('MESSAGE', l_errMsg);
3326: fnd_msg_pub.add;
3327: END delete_child_txn;
3328:
3321: p_msg => l_errMsg,
3322: x_returnStatus => l_returnStatus);
3323: END IF;
3324: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3325: fnd_message.set_token('MESSAGE', l_errMsg);
3326: fnd_msg_pub.add;
3327: END delete_child_txn;
3328:
3329: /*****************************************************************************
3593: );
3594:
3595: -- IF debug message level = 2, write statement below to log file
3596: IF (l_logLevel <= wip_constants.full_logging) THEN
3597: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3598: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3599: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3600: l_msg := fnd_message.get;
3601: wip_logger.log(p_msg => l_msg,
3594:
3595: -- IF debug message level = 2, write statement below to log file
3596: IF (l_logLevel <= wip_constants.full_logging) THEN
3597: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3598: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3599: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3600: l_msg := fnd_message.get;
3601: wip_logger.log(p_msg => l_msg,
3602: x_returnStatus => l_returnStatus);
3595: -- IF debug message level = 2, write statement below to log file
3596: IF (l_logLevel <= wip_constants.full_logging) THEN
3597: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3598: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3599: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3600: l_msg := fnd_message.get;
3601: wip_logger.log(p_msg => l_msg,
3602: x_returnStatus => l_returnStatus);
3603: END IF;
3596: IF (l_logLevel <= wip_constants.full_logging) THEN
3597: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3598: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3599: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3600: l_msg := fnd_message.get;
3601: wip_logger.log(p_msg => l_msg,
3602: x_returnStatus => l_returnStatus);
3603: END IF;
3604:
3813: wmti.transaction_id;
3814:
3815: -- IF debug message level = 2, write statement below to log file
3816: IF (l_logLevel <= wip_constants.full_logging) THEN
3817: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3818: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3819: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3820: l_msg := fnd_message.get;
3821: wip_logger.log(p_msg => l_msg,
3814:
3815: -- IF debug message level = 2, write statement below to log file
3816: IF (l_logLevel <= wip_constants.full_logging) THEN
3817: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3818: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3819: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3820: l_msg := fnd_message.get;
3821: wip_logger.log(p_msg => l_msg,
3822: x_returnStatus => l_returnStatus);
3815: -- IF debug message level = 2, write statement below to log file
3816: IF (l_logLevel <= wip_constants.full_logging) THEN
3817: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3818: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3819: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3820: l_msg := fnd_message.get;
3821: wip_logger.log(p_msg => l_msg,
3822: x_returnStatus => l_returnStatus);
3823: END IF;
3816: IF (l_logLevel <= wip_constants.full_logging) THEN
3817: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3818: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3819: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3820: l_msg := fnd_message.get;
3821: wip_logger.log(p_msg => l_msg,
3822: x_returnStatus => l_returnStatus);
3823: END IF;
3824:
4067: -1, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0));
4068:
4069: -- IF debug message level = 2, write statement below to log file
4070: IF (l_logLevel <= wip_constants.full_logging) THEN
4071: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4072: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4073: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4074: l_msg := fnd_message.get;
4075: wip_logger.log(p_msg => l_msg,
4068:
4069: -- IF debug message level = 2, write statement below to log file
4070: IF (l_logLevel <= wip_constants.full_logging) THEN
4071: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4072: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4073: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4074: l_msg := fnd_message.get;
4075: wip_logger.log(p_msg => l_msg,
4076: x_returnStatus => l_returnStatus);
4069: -- IF debug message level = 2, write statement below to log file
4070: IF (l_logLevel <= wip_constants.full_logging) THEN
4071: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4072: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4073: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4074: l_msg := fnd_message.get;
4075: wip_logger.log(p_msg => l_msg,
4076: x_returnStatus => l_returnStatus);
4077: END IF;
4070: IF (l_logLevel <= wip_constants.full_logging) THEN
4071: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4072: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4073: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4074: l_msg := fnd_message.get;
4075: wip_logger.log(p_msg => l_msg,
4076: x_returnStatus => l_returnStatus);
4077: END IF;
4078:
4283: -1, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0));
4284:
4285: -- IF debug message level = 2, write statement below to log file
4286: IF (l_logLevel <= wip_constants.full_logging) THEN
4287: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4288: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4289: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4290: l_msg := fnd_message.get;
4291: wip_logger.log(p_msg => l_msg,
4284:
4285: -- IF debug message level = 2, write statement below to log file
4286: IF (l_logLevel <= wip_constants.full_logging) THEN
4287: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4288: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4289: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4290: l_msg := fnd_message.get;
4291: wip_logger.log(p_msg => l_msg,
4292: x_returnStatus => l_returnStatus);
4285: -- IF debug message level = 2, write statement below to log file
4286: IF (l_logLevel <= wip_constants.full_logging) THEN
4287: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4288: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4289: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4290: l_msg := fnd_message.get;
4291: wip_logger.log(p_msg => l_msg,
4292: x_returnStatus => l_returnStatus);
4293: END IF;
4286: IF (l_logLevel <= wip_constants.full_logging) THEN
4287: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4288: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4289: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4290: l_msg := fnd_message.get;
4291: wip_logger.log(p_msg => l_msg,
4292: x_returnStatus => l_returnStatus);
4293: END IF;
4294:
4308: AND transaction_type = WIP_CONSTANTS.RES_TXN;
4309:
4310: -- IF debug message level = 2, write statement below to log file
4311: IF (l_logLevel <= wip_constants.full_logging) THEN
4312: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
4313: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4314: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4315: l_msg := fnd_message.get;
4316: wip_logger.log(p_msg => l_msg,
4309:
4310: -- IF debug message level = 2, write statement below to log file
4311: IF (l_logLevel <= wip_constants.full_logging) THEN
4312: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
4313: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4314: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4315: l_msg := fnd_message.get;
4316: wip_logger.log(p_msg => l_msg,
4317: x_returnStatus => l_returnStatus);
4310: -- IF debug message level = 2, write statement below to log file
4311: IF (l_logLevel <= wip_constants.full_logging) THEN
4312: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
4313: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4314: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4315: l_msg := fnd_message.get;
4316: wip_logger.log(p_msg => l_msg,
4317: x_returnStatus => l_returnStatus);
4318: END IF;
4311: IF (l_logLevel <= wip_constants.full_logging) THEN
4312: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
4313: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4314: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4315: l_msg := fnd_message.get;
4316: wip_logger.log(p_msg => l_msg,
4317: x_returnStatus => l_returnStatus);
4318: END IF;
4319:
4442: wma.repetitive_schedule_id;
4443:
4444: -- IF debug message level = 2, write statement below to log file
4445: IF (l_logLevel <= wip_constants.full_logging) THEN
4446: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4447: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4448: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4449: l_msg := fnd_message.get;
4450: wip_logger.log(p_msg => l_msg,
4443:
4444: -- IF debug message level = 2, write statement below to log file
4445: IF (l_logLevel <= wip_constants.full_logging) THEN
4446: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4447: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4448: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4449: l_msg := fnd_message.get;
4450: wip_logger.log(p_msg => l_msg,
4451: x_returnStatus => l_returnStatus);
4444: -- IF debug message level = 2, write statement below to log file
4445: IF (l_logLevel <= wip_constants.full_logging) THEN
4446: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4447: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4448: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4449: l_msg := fnd_message.get;
4450: wip_logger.log(p_msg => l_msg,
4451: x_returnStatus => l_returnStatus);
4452: END IF;
4445: IF (l_logLevel <= wip_constants.full_logging) THEN
4446: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4447: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4448: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4449: l_msg := fnd_message.get;
4450: wip_logger.log(p_msg => l_msg,
4451: x_returnStatus => l_returnStatus);
4452: END IF;
4453:
4473: p_procReturnStatus => x_returnStatus,
4474: p_msg => l_errMsg,
4475: x_returnStatus => l_returnStatus);
4476: END IF;
4477: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
4478: fnd_message.set_token('MESSAGE', l_errMsg);
4479: fnd_msg_pub.add;
4480: END insert_auto_resource;
4481:
4474: p_msg => l_errMsg,
4475: x_returnStatus => l_returnStatus);
4476: END IF;
4477: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
4478: fnd_message.set_token('MESSAGE', l_errMsg);
4479: fnd_msg_pub.add;
4480: END insert_auto_resource;
4481:
4482: /*****************************************************************************
4584: AND wor.usage_rate_or_amount = wcti.usage_rate_or_amount;
4585:
4586: -- IF debug message level = 2, write statement below to log file
4587: IF (l_logLevel <= wip_constants.full_logging) THEN
4588: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4589: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4590: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4591: l_msg := fnd_message.get;
4592: wip_logger.log(p_msg => l_msg,
4585:
4586: -- IF debug message level = 2, write statement below to log file
4587: IF (l_logLevel <= wip_constants.full_logging) THEN
4588: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4589: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4590: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4591: l_msg := fnd_message.get;
4592: wip_logger.log(p_msg => l_msg,
4593: x_returnStatus => l_returnStatus);
4586: -- IF debug message level = 2, write statement below to log file
4587: IF (l_logLevel <= wip_constants.full_logging) THEN
4588: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4589: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4590: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4591: l_msg := fnd_message.get;
4592: wip_logger.log(p_msg => l_msg,
4593: x_returnStatus => l_returnStatus);
4594: END IF;
4587: IF (l_logLevel <= wip_constants.full_logging) THEN
4588: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4589: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4590: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4591: l_msg := fnd_message.get;
4592: wip_logger.log(p_msg => l_msg,
4593: x_returnStatus => l_returnStatus);
4594: END IF;
4595:
4613: p_procReturnStatus => x_returnStatus,
4614: p_msg => l_errMsg,
4615: x_returnStatus => l_returnStatus);
4616: END IF;
4617: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
4618: fnd_message.set_token('MESSAGE', l_errMsg);
4619: fnd_msg_pub.add;
4620: END insert_txn_alloc;
4621:
4614: p_msg => l_errMsg,
4615: x_returnStatus => l_returnStatus);
4616: END IF;
4617: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
4618: fnd_message.set_token('MESSAGE', l_errMsg);
4619: fnd_msg_pub.add;
4620: END insert_txn_alloc;
4621:
4622: /*****************************************************************************
4895: wmti.transaction_id; /* 2821017 */
4896:
4897: -- IF debug message level = 2, write statement below to log file
4898: IF (l_logLevel <= wip_constants.full_logging) THEN
4899: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4900: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4901: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4902: l_msg := fnd_message.get;
4903: wip_logger.log(p_msg => l_msg,
4896:
4897: -- IF debug message level = 2, write statement below to log file
4898: IF (l_logLevel <= wip_constants.full_logging) THEN
4899: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4900: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4901: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4902: l_msg := fnd_message.get;
4903: wip_logger.log(p_msg => l_msg,
4904: x_returnStatus => l_returnStatus);
4897: -- IF debug message level = 2, write statement below to log file
4898: IF (l_logLevel <= wip_constants.full_logging) THEN
4899: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4900: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4901: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4902: l_msg := fnd_message.get;
4903: wip_logger.log(p_msg => l_msg,
4904: x_returnStatus => l_returnStatus);
4905: END IF;
4898: IF (l_logLevel <= wip_constants.full_logging) THEN
4899: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4900: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4901: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4902: l_msg := fnd_message.get;
4903: wip_logger.log(p_msg => l_msg,
4904: x_returnStatus => l_returnStatus);
4905: END IF;
4906:
5105: wor.phantom_op_seq_num;
5106:
5107: -- IF debug message level = 2, write statement below to log file
5108: IF (l_logLevel <= wip_constants.full_logging) THEN
5109: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5110: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5111: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5112: l_msg := fnd_message.get;
5113: wip_logger.log(p_msg => l_msg,
5106:
5107: -- IF debug message level = 2, write statement below to log file
5108: IF (l_logLevel <= wip_constants.full_logging) THEN
5109: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5110: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5111: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5112: l_msg := fnd_message.get;
5113: wip_logger.log(p_msg => l_msg,
5114: x_returnStatus => l_returnStatus);
5107: -- IF debug message level = 2, write statement below to log file
5108: IF (l_logLevel <= wip_constants.full_logging) THEN
5109: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5110: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5111: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5112: l_msg := fnd_message.get;
5113: wip_logger.log(p_msg => l_msg,
5114: x_returnStatus => l_returnStatus);
5115: END IF;
5108: IF (l_logLevel <= wip_constants.full_logging) THEN
5109: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5110: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5111: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5112: l_msg := fnd_message.get;
5113: wip_logger.log(p_msg => l_msg,
5114: x_returnStatus => l_returnStatus);
5115: END IF;
5116:
5369: -1, DECODE(sign(MAX(wop.quantity_completed)),1,-1,0));
5370:
5371: -- IF debug message level = 2, write statement below to log file
5372: IF (l_logLevel <= wip_constants.full_logging) THEN
5373: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5374: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5375: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5376: l_msg := fnd_message.get;
5377: wip_logger.log(p_msg => l_msg,
5370:
5371: -- IF debug message level = 2, write statement below to log file
5372: IF (l_logLevel <= wip_constants.full_logging) THEN
5373: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5374: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5375: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5376: l_msg := fnd_message.get;
5377: wip_logger.log(p_msg => l_msg,
5378: x_returnStatus => l_returnStatus);
5371: -- IF debug message level = 2, write statement below to log file
5372: IF (l_logLevel <= wip_constants.full_logging) THEN
5373: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5374: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5375: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5376: l_msg := fnd_message.get;
5377: wip_logger.log(p_msg => l_msg,
5378: x_returnStatus => l_returnStatus);
5379: END IF;
5372: IF (l_logLevel <= wip_constants.full_logging) THEN
5373: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5374: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5375: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5376: l_msg := fnd_message.get;
5377: wip_logger.log(p_msg => l_msg,
5378: x_returnStatus => l_returnStatus);
5379: END IF;
5380:
5575: -1, DECODE(sign(MAX(wop.quantity_completed)),1,-1,0));
5576:
5577: -- IF debug message level = 2, write statement below to log file
5578: IF (l_logLevel <= wip_constants.full_logging) THEN
5579: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5580: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5581: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5582: l_msg := fnd_message.get;
5583: wip_logger.log(p_msg => l_msg,
5576:
5577: -- IF debug message level = 2, write statement below to log file
5578: IF (l_logLevel <= wip_constants.full_logging) THEN
5579: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5580: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5581: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5582: l_msg := fnd_message.get;
5583: wip_logger.log(p_msg => l_msg,
5584: x_returnStatus => l_returnStatus);
5577: -- IF debug message level = 2, write statement below to log file
5578: IF (l_logLevel <= wip_constants.full_logging) THEN
5579: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5580: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5581: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5582: l_msg := fnd_message.get;
5583: wip_logger.log(p_msg => l_msg,
5584: x_returnStatus => l_returnStatus);
5585: END IF;
5578: IF (l_logLevel <= wip_constants.full_logging) THEN
5579: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5580: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5581: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5582: l_msg := fnd_message.get;
5583: wip_logger.log(p_msg => l_msg,
5584: x_returnStatus => l_returnStatus);
5585: END IF;
5586:
5597: AND transaction_type = WIP_CONSTANTS.OVHD_TXN;
5598:
5599: -- IF debug message level = 2, write statement below to log file
5600: IF (l_logLevel <= wip_constants.full_logging) THEN
5601: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5602: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5603: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5604: l_msg := fnd_message.get;
5605: wip_logger.log(p_msg => l_msg,
5598:
5599: -- IF debug message level = 2, write statement below to log file
5600: IF (l_logLevel <= wip_constants.full_logging) THEN
5601: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5602: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5603: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5604: l_msg := fnd_message.get;
5605: wip_logger.log(p_msg => l_msg,
5606: x_returnStatus => l_returnStatus);
5599: -- IF debug message level = 2, write statement below to log file
5600: IF (l_logLevel <= wip_constants.full_logging) THEN
5601: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5602: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5603: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5604: l_msg := fnd_message.get;
5605: wip_logger.log(p_msg => l_msg,
5606: x_returnStatus => l_returnStatus);
5607: END IF;
5600: IF (l_logLevel <= wip_constants.full_logging) THEN
5601: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5602: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5603: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5604: l_msg := fnd_message.get;
5605: wip_logger.log(p_msg => l_msg,
5606: x_returnStatus => l_returnStatus);
5607: END IF;
5608:
5713: wma.repetitive_schedule_id;
5714:
5715: -- IF debug message level = 2, write statement below to log file
5716: IF (l_logLevel <= wip_constants.full_logging) THEN
5717: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5718: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5719: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
5720: l_msg := fnd_message.get;
5721: wip_logger.log(p_msg => l_msg,
5714:
5715: -- IF debug message level = 2, write statement below to log file
5716: IF (l_logLevel <= wip_constants.full_logging) THEN
5717: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5718: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5719: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
5720: l_msg := fnd_message.get;
5721: wip_logger.log(p_msg => l_msg,
5722: x_returnStatus => l_returnStatus);
5715: -- IF debug message level = 2, write statement below to log file
5716: IF (l_logLevel <= wip_constants.full_logging) THEN
5717: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5718: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5719: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
5720: l_msg := fnd_message.get;
5721: wip_logger.log(p_msg => l_msg,
5722: x_returnStatus => l_returnStatus);
5723: END IF;
5716: IF (l_logLevel <= wip_constants.full_logging) THEN
5717: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5718: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5719: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
5720: l_msg := fnd_message.get;
5721: wip_logger.log(p_msg => l_msg,
5722: x_returnStatus => l_returnStatus);
5723: END IF;
5724:
5744: p_procReturnStatus => x_returnStatus,
5745: p_msg => l_errMsg,
5746: x_returnStatus => l_returnStatus);
5747: END IF;
5748: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
5749: fnd_message.set_token('MESSAGE', l_errMsg);
5750: fnd_msg_pub.add;
5751: END insert_dept_overhead;
5752:
5745: p_msg => l_errMsg,
5746: x_returnStatus => l_returnStatus);
5747: END IF;
5748: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
5749: fnd_message.set_token('MESSAGE', l_errMsg);
5750: fnd_msg_pub.add;
5751: END insert_dept_overhead;
5752:
5753: /*****************************************************************************
5782: AND TRUNC(transaction_date) = TRUNC(p_gib.txn_date);
5783:
5784: -- IF debug message level = 2, write statement below to log file
5785: IF (l_logLevel <= wip_constants.full_logging) THEN
5786: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5787: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5788: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5789: l_msg := fnd_message.get;
5790: wip_logger.log(p_msg => l_msg,
5783:
5784: -- IF debug message level = 2, write statement below to log file
5785: IF (l_logLevel <= wip_constants.full_logging) THEN
5786: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5787: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5788: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5789: l_msg := fnd_message.get;
5790: wip_logger.log(p_msg => l_msg,
5791: x_returnStatus => l_returnStatus);
5784: -- IF debug message level = 2, write statement below to log file
5785: IF (l_logLevel <= wip_constants.full_logging) THEN
5786: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5787: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5788: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5789: l_msg := fnd_message.get;
5790: wip_logger.log(p_msg => l_msg,
5791: x_returnStatus => l_returnStatus);
5792: END IF;
5785: IF (l_logLevel <= wip_constants.full_logging) THEN
5786: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5787: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5788: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5789: l_msg := fnd_message.get;
5790: wip_logger.log(p_msg => l_msg,
5791: x_returnStatus => l_returnStatus);
5792: END IF;
5793:
5811: p_procReturnStatus => x_returnStatus,
5812: p_msg => l_errMsg,
5813: x_returnStatus => l_returnStatus);
5814: END IF;
5815: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
5816: fnd_message.set_token('MESSAGE', l_errMsg);
5817: fnd_msg_pub.add;
5818: END release_cost_txn;
5819:
5812: p_msg => l_errMsg,
5813: x_returnStatus => l_returnStatus);
5814: END IF;
5815: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
5816: fnd_message.set_token('MESSAGE', l_errMsg);
5817: fnd_msg_pub.add;
5818: END release_cost_txn;
5819:
5820: /*****************************************************************************
6156: CEIL(NVL(msi.postprocessing_lead_time,0)))
6157: AND wp.organization_id = wmti.organization_id; /*ER 4276433*/
6158: -- IF debug message level = 2, write statement below to log file
6159: IF (l_logLevel <= wip_constants.full_logging) THEN
6160: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6161: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6162: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6163: l_msg := fnd_message.get;
6164: wip_logger.log(p_msg => l_msg,
6157: AND wp.organization_id = wmti.organization_id; /*ER 4276433*/
6158: -- IF debug message level = 2, write statement below to log file
6159: IF (l_logLevel <= wip_constants.full_logging) THEN
6160: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6161: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6162: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6163: l_msg := fnd_message.get;
6164: wip_logger.log(p_msg => l_msg,
6165: x_returnStatus => l_returnStatus);
6158: -- IF debug message level = 2, write statement below to log file
6159: IF (l_logLevel <= wip_constants.full_logging) THEN
6160: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6161: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6162: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6163: l_msg := fnd_message.get;
6164: wip_logger.log(p_msg => l_msg,
6165: x_returnStatus => l_returnStatus);
6166: END IF;
6159: IF (l_logLevel <= wip_constants.full_logging) THEN
6160: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6161: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6162: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6163: l_msg := fnd_message.get;
6164: wip_logger.log(p_msg => l_msg,
6165: x_returnStatus => l_returnStatus);
6166: END IF;
6167:
6356: AND wp.organization_id = wmti.organization_id; /*ER 4276433*/
6357:
6358: -- IF debug message level = 2, write statement below to log file
6359: IF (l_logLevel <= wip_constants.full_logging) THEN
6360: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6361: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6362: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6363: l_msg := fnd_message.get;
6364: wip_logger.log(p_msg => l_msg,
6357:
6358: -- IF debug message level = 2, write statement below to log file
6359: IF (l_logLevel <= wip_constants.full_logging) THEN
6360: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6361: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6362: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6363: l_msg := fnd_message.get;
6364: wip_logger.log(p_msg => l_msg,
6365: x_returnStatus => l_returnStatus);
6358: -- IF debug message level = 2, write statement below to log file
6359: IF (l_logLevel <= wip_constants.full_logging) THEN
6360: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6361: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6362: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6363: l_msg := fnd_message.get;
6364: wip_logger.log(p_msg => l_msg,
6365: x_returnStatus => l_returnStatus);
6366: END IF;
6359: IF (l_logLevel <= wip_constants.full_logging) THEN
6360: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6361: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6362: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6363: l_msg := fnd_message.get;
6364: wip_logger.log(p_msg => l_msg,
6365: x_returnStatus => l_returnStatus);
6366: END IF;
6367:
6598: 1, 0);
6599:
6600: -- IF debug message level = 2, write statement below to log file
6601: IF (l_logLevel <= wip_constants.full_logging) THEN
6602: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6603: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6604: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6605: l_msg := fnd_message.get;
6606: wip_logger.log(p_msg => l_msg,
6599:
6600: -- IF debug message level = 2, write statement below to log file
6601: IF (l_logLevel <= wip_constants.full_logging) THEN
6602: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6603: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6604: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6605: l_msg := fnd_message.get;
6606: wip_logger.log(p_msg => l_msg,
6607: x_returnStatus => l_returnStatus);
6600: -- IF debug message level = 2, write statement below to log file
6601: IF (l_logLevel <= wip_constants.full_logging) THEN
6602: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6603: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6604: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6605: l_msg := fnd_message.get;
6606: wip_logger.log(p_msg => l_msg,
6607: x_returnStatus => l_returnStatus);
6608: END IF;
6601: IF (l_logLevel <= wip_constants.full_logging) THEN
6602: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6603: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6604: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6605: l_msg := fnd_message.get;
6606: wip_logger.log(p_msg => l_msg,
6607: x_returnStatus => l_returnStatus);
6608: END IF;
6609:
6826: 1, 0);
6827:
6828: -- IF debug message level = 2, write statement below to log file
6829: IF (l_logLevel <= wip_constants.full_logging) THEN
6830: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6831: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6832: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6833: l_msg := fnd_message.get;
6834: wip_logger.log(p_msg => l_msg,
6827:
6828: -- IF debug message level = 2, write statement below to log file
6829: IF (l_logLevel <= wip_constants.full_logging) THEN
6830: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6831: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6832: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6833: l_msg := fnd_message.get;
6834: wip_logger.log(p_msg => l_msg,
6835: x_returnStatus => l_returnStatus);
6828: -- IF debug message level = 2, write statement below to log file
6829: IF (l_logLevel <= wip_constants.full_logging) THEN
6830: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6831: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6832: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6833: l_msg := fnd_message.get;
6834: wip_logger.log(p_msg => l_msg,
6835: x_returnStatus => l_returnStatus);
6836: END IF;
6829: IF (l_logLevel <= wip_constants.full_logging) THEN
6830: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6831: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6832: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6833: l_msg := fnd_message.get;
6834: wip_logger.log(p_msg => l_msg,
6835: x_returnStatus => l_returnStatus);
6836: END IF;
6837: END IF; -- po requisition per lot for schedule
6881: p_procReturnStatus => x_returnStatus,
6882: p_msg => l_errMsg,
6883: x_returnStatus => l_returnStatus);
6884: END IF;
6885: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
6886: fnd_message.set_token('MESSAGE', l_errMsg);
6887: fnd_msg_pub.add;
6888: END insert_po_req;
6889:
6882: p_msg => l_errMsg,
6883: x_returnStatus => l_returnStatus);
6884: END IF;
6885: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
6886: fnd_message.set_token('MESSAGE', l_errMsg);
6887: fnd_msg_pub.add;
6888: END insert_po_req;
6889:
6890: /*****************************************************************************
7119: p_procReturnStatus => x_returnStatus,
7120: p_msg => l_errMsg,
7121: x_returnStatus => l_returnStatus);
7122: END IF;
7123: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7124: fnd_message.set_token('MESSAGE', l_errMsg);
7125: fnd_msg_pub.add;
7126: END start_workflow;
7127:
7120: p_msg => l_errMsg,
7121: x_returnStatus => l_returnStatus);
7122: END IF;
7123: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7124: fnd_message.set_token('MESSAGE', l_errMsg);
7125: fnd_msg_pub.add;
7126: END start_workflow;
7127:
7128: /*****************************************************************************
7302: ));
7303:
7304: -- IF debug message level = 2, write statement below to log file
7305: IF (l_logLevel <= wip_constants.full_logging) THEN
7306: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
7307: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
7308: fnd_message.set_token('ENTITY2', 'WIP_OPERATIONS');
7309: l_msg := fnd_message.get;
7310: wip_logger.log(p_msg => l_msg,
7303:
7304: -- IF debug message level = 2, write statement below to log file
7305: IF (l_logLevel <= wip_constants.full_logging) THEN
7306: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
7307: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
7308: fnd_message.set_token('ENTITY2', 'WIP_OPERATIONS');
7309: l_msg := fnd_message.get;
7310: wip_logger.log(p_msg => l_msg,
7311: x_returnStatus => l_returnStatus);
7304: -- IF debug message level = 2, write statement below to log file
7305: IF (l_logLevel <= wip_constants.full_logging) THEN
7306: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
7307: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
7308: fnd_message.set_token('ENTITY2', 'WIP_OPERATIONS');
7309: l_msg := fnd_message.get;
7310: wip_logger.log(p_msg => l_msg,
7311: x_returnStatus => l_returnStatus);
7312: END IF;
7305: IF (l_logLevel <= wip_constants.full_logging) THEN
7306: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
7307: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
7308: fnd_message.set_token('ENTITY2', 'WIP_OPERATIONS');
7309: l_msg := fnd_message.get;
7310: wip_logger.log(p_msg => l_msg,
7311: x_returnStatus => l_returnStatus);
7312: END IF;
7313:
7331: p_procReturnStatus => x_returnStatus,
7332: p_msg => l_errMsg,
7333: x_returnStatus => l_returnStatus);
7334: END IF;
7335: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7336: fnd_message.set_token('MESSAGE', l_errMsg);
7337: fnd_msg_pub.add;
7338: END update_complete_qty;
7339:
7332: p_msg => l_errMsg,
7333: x_returnStatus => l_returnStatus);
7334: END IF;
7335: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7336: fnd_message.set_token('MESSAGE', l_errMsg);
7337: fnd_msg_pub.add;
7338: END update_complete_qty;
7339:
7340: /*****************************************************************************
7392: p_msg => l_errMsg,
7393: x_returnStatus => l_returnStatus);
7394: END IF;
7395:
7396: fnd_message.set_name('CST', l_errCode);
7397: fnd_msg_pub.add;
7398:
7399: WHEN others THEN
7400: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
7405: p_procReturnStatus => x_returnStatus,
7406: p_msg => l_errMsg,
7407: x_returnStatus => l_returnStatus);
7408: END IF;
7409: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7410: fnd_message.set_token('MESSAGE', l_errMsg);
7411: fnd_msg_pub.add;
7412: END op_snapshot;
7413:
7406: p_msg => l_errMsg,
7407: x_returnStatus => l_returnStatus);
7408: END IF;
7409: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7410: fnd_message.set_token('MESSAGE', l_errMsg);
7411: fnd_msg_pub.add;
7412: END op_snapshot;
7413:
7414: /*****************************************************************************
7534: p_procReturnStatus => x_returnStatus,
7535: p_msg => l_errMsg,
7536: x_returnStatus => l_returnStatus);
7537: END IF;
7538: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7539: fnd_message.set_token('MESSAGE', l_errMsg);
7540: fnd_msg_pub.add;
7541: END snapshot_online;
7542:
7535: p_msg => l_errMsg,
7536: x_returnStatus => l_returnStatus);
7537: END IF;
7538: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7539: fnd_message.set_token('MESSAGE', l_errMsg);
7540: fnd_msg_pub.add;
7541: END snapshot_online;
7542:
7543: /*****************************************************************************
7701: err_code => l_errCode,
7702: err_msg => l_errMsg);
7703:
7704: IF(l_returnValue <> 1) THEN
7705: fnd_message.set_name('CST', l_errCode);
7706: fnd_msg_pub.add;
7707: l_errMsg := 'CSTACOSN.validate_move_snap_to_temp failed';
7708: raise fnd_api.g_exc_unexpected_error;
7709: END IF; -- check return status
7749: p_procReturnStatus => x_returnStatus,
7750: p_msg => l_errMsg,
7751: x_returnStatus => l_returnStatus);
7752: END IF;
7753: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7754: fnd_message.set_token('MESSAGE', l_errMsg);
7755: fnd_msg_pub.add;
7756: END snapshot_background;
7757:
7750: p_msg => l_errMsg,
7751: x_returnStatus => l_returnStatus);
7752: END IF;
7753: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7754: fnd_message.set_token('MESSAGE', l_errMsg);
7755: fnd_msg_pub.add;
7756: END snapshot_background;
7757:
7758: /*****************************************************************************
7857: p_procReturnStatus => x_returnStatus,
7858: p_msg => l_errMsg,
7859: x_returnStatus => l_returnStatus);
7860: END IF;
7861: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7862: fnd_message.set_token('MESSAGE', l_errMsg);
7863: fnd_msg_pub.add;
7864: END update_wo_and_snapshot;
7865:
7858: p_msg => l_errMsg,
7859: x_returnStatus => l_returnStatus);
7860: END IF;
7861: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7862: fnd_message.set_token('MESSAGE', l_errMsg);
7863: fnd_msg_pub.add;
7864: END update_wo_and_snapshot;
7865:
7866: /*****************************************************************************
8160: wdj2.quantity_scrapped) > 0);
8161:
8162: -- IF debug message level = 2, write statement below to log file
8163: IF (l_logLevel <= wip_constants.full_logging) THEN
8164: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8165: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8166: fnd_message.set_token('ENTITY2', 'WIP_DISCRETE_JOBS');
8167: l_msg := fnd_message.get;
8168: wip_logger.log(p_msg => l_msg,
8161:
8162: -- IF debug message level = 2, write statement below to log file
8163: IF (l_logLevel <= wip_constants.full_logging) THEN
8164: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8165: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8166: fnd_message.set_token('ENTITY2', 'WIP_DISCRETE_JOBS');
8167: l_msg := fnd_message.get;
8168: wip_logger.log(p_msg => l_msg,
8169: x_returnStatus => l_returnStatus);
8162: -- IF debug message level = 2, write statement below to log file
8163: IF (l_logLevel <= wip_constants.full_logging) THEN
8164: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8165: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8166: fnd_message.set_token('ENTITY2', 'WIP_DISCRETE_JOBS');
8167: l_msg := fnd_message.get;
8168: wip_logger.log(p_msg => l_msg,
8169: x_returnStatus => l_returnStatus);
8170: END IF;
8163: IF (l_logLevel <= wip_constants.full_logging) THEN
8164: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8165: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8166: fnd_message.set_token('ENTITY2', 'WIP_DISCRETE_JOBS');
8167: l_msg := fnd_message.get;
8168: wip_logger.log(p_msg => l_msg,
8169: x_returnStatus => l_returnStatus);
8170: END IF;
8171: END IF; -- END job transactions
8208: OR wmti.to_intraoperation_step_type = WIP_CONSTANTS.SCRAP));
8209:
8210: -- IF debug message level = 2, write statement below to log file
8211: IF (l_logLevel <= wip_constants.full_logging) THEN
8212: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8213: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8214: fnd_message.set_token('ENTITY2', 'WIP_REPETITIVE_SCHEDULES');
8215: l_msg := fnd_message.get;
8216: wip_logger.log(p_msg => l_msg,
8209:
8210: -- IF debug message level = 2, write statement below to log file
8211: IF (l_logLevel <= wip_constants.full_logging) THEN
8212: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8213: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8214: fnd_message.set_token('ENTITY2', 'WIP_REPETITIVE_SCHEDULES');
8215: l_msg := fnd_message.get;
8216: wip_logger.log(p_msg => l_msg,
8217: x_returnStatus => l_returnStatus);
8210: -- IF debug message level = 2, write statement below to log file
8211: IF (l_logLevel <= wip_constants.full_logging) THEN
8212: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8213: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8214: fnd_message.set_token('ENTITY2', 'WIP_REPETITIVE_SCHEDULES');
8215: l_msg := fnd_message.get;
8216: wip_logger.log(p_msg => l_msg,
8217: x_returnStatus => l_returnStatus);
8218: END IF;
8211: IF (l_logLevel <= wip_constants.full_logging) THEN
8212: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8213: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8214: fnd_message.set_token('ENTITY2', 'WIP_REPETITIVE_SCHEDULES');
8215: l_msg := fnd_message.get;
8216: wip_logger.log(p_msg => l_msg,
8217: x_returnStatus => l_returnStatus);
8218: END IF;
8219: END IF; -- END repetitive schedule transactions
8362: AND msi.inventory_item_id = wmti.primary_item_id;
8363:
8364: -- IF debug message level = 2, write statement below to log file
8365: IF (l_logLevel <= wip_constants.full_logging) THEN
8366: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8367: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8368: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8369: l_msg := fnd_message.get;
8370: wip_logger.log(p_msg => l_msg,
8363:
8364: -- IF debug message level = 2, write statement below to log file
8365: IF (l_logLevel <= wip_constants.full_logging) THEN
8366: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8367: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8368: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8369: l_msg := fnd_message.get;
8370: wip_logger.log(p_msg => l_msg,
8371: x_returnStatus => l_returnStatus);
8364: -- IF debug message level = 2, write statement below to log file
8365: IF (l_logLevel <= wip_constants.full_logging) THEN
8366: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8367: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8368: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8369: l_msg := fnd_message.get;
8370: wip_logger.log(p_msg => l_msg,
8371: x_returnStatus => l_returnStatus);
8372: END IF;
8365: IF (l_logLevel <= wip_constants.full_logging) THEN
8366: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8367: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8368: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8369: l_msg := fnd_message.get;
8370: wip_logger.log(p_msg => l_msg,
8371: x_returnStatus => l_returnStatus);
8372: END IF;
8373:
8497: AND msi.inventory_item_id = wmti.primary_item_id;
8498:
8499: -- IF debug message level = 2, write statement below to log file
8500: IF (l_logLevel <= wip_constants.full_logging) THEN
8501: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8502: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8503: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8504: l_msg := fnd_message.get;
8505: wip_logger.log(p_msg => l_msg,
8498:
8499: -- IF debug message level = 2, write statement below to log file
8500: IF (l_logLevel <= wip_constants.full_logging) THEN
8501: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8502: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8503: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8504: l_msg := fnd_message.get;
8505: wip_logger.log(p_msg => l_msg,
8506: x_returnStatus => l_returnStatus);
8499: -- IF debug message level = 2, write statement below to log file
8500: IF (l_logLevel <= wip_constants.full_logging) THEN
8501: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8502: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8503: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8504: l_msg := fnd_message.get;
8505: wip_logger.log(p_msg => l_msg,
8506: x_returnStatus => l_returnStatus);
8507: END IF;
8500: IF (l_logLevel <= wip_constants.full_logging) THEN
8501: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8502: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8503: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8504: l_msg := fnd_message.get;
8505: wip_logger.log(p_msg => l_msg,
8506: x_returnStatus => l_returnStatus);
8507: END IF;
8508: END IF; -- Repetitive schedules
8611: p_procReturnStatus => x_returnStatus,
8612: p_msg => l_errMsg,
8613: x_returnStatus => l_returnStatus);
8614: END IF;
8615: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
8616: fnd_message.set_token('MESSAGE', l_errMsg);
8617: fnd_msg_pub.add;
8618: END scrap_txns;
8619:
8612: p_msg => l_errMsg,
8613: x_returnStatus => l_returnStatus);
8614: END IF;
8615: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
8616: fnd_message.set_token('MESSAGE', l_errMsg);
8617: fnd_msg_pub.add;
8618: END scrap_txns;
8619:
8620: /*****************************************************************************
9047: END IF; -- Repetitive schedules
9048:
9049: -- IF debug message level = 2, write statement below to log file
9050: IF (l_logLevel <= wip_constants.full_logging) THEN
9051: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9052: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9053: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTIONS_INTERFACE');
9054: l_msg := fnd_message.get;
9055: wip_logger.log(p_msg => l_msg,
9048:
9049: -- IF debug message level = 2, write statement below to log file
9050: IF (l_logLevel <= wip_constants.full_logging) THEN
9051: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9052: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9053: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTIONS_INTERFACE');
9054: l_msg := fnd_message.get;
9055: wip_logger.log(p_msg => l_msg,
9056: x_returnStatus => l_returnStatus);
9049: -- IF debug message level = 2, write statement below to log file
9050: IF (l_logLevel <= wip_constants.full_logging) THEN
9051: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9052: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9053: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTIONS_INTERFACE');
9054: l_msg := fnd_message.get;
9055: wip_logger.log(p_msg => l_msg,
9056: x_returnStatus => l_returnStatus);
9057: END IF;
9050: IF (l_logLevel <= wip_constants.full_logging) THEN
9051: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9052: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9053: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTIONS_INTERFACE');
9054: l_msg := fnd_message.get;
9055: wip_logger.log(p_msg => l_msg,
9056: x_returnStatus => l_returnStatus);
9057: END IF;
9058:
9151: mti.transaction_interface_id);
9152:
9153: -- IF debug message level = 2, write statement below to log file
9154: IF (l_logLevel <= wip_constants.full_logging) THEN
9155: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9156: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9157: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
9158: l_msg := fnd_message.get;
9159: wip_logger.log(p_msg => l_msg,
9152:
9153: -- IF debug message level = 2, write statement below to log file
9154: IF (l_logLevel <= wip_constants.full_logging) THEN
9155: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9156: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9157: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
9158: l_msg := fnd_message.get;
9159: wip_logger.log(p_msg => l_msg,
9160: x_returnStatus => l_returnStatus);
9153: -- IF debug message level = 2, write statement below to log file
9154: IF (l_logLevel <= wip_constants.full_logging) THEN
9155: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9156: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9157: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
9158: l_msg := fnd_message.get;
9159: wip_logger.log(p_msg => l_msg,
9160: x_returnStatus => l_returnStatus);
9161: END IF;
9154: IF (l_logLevel <= wip_constants.full_logging) THEN
9155: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9156: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9157: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
9158: l_msg := fnd_message.get;
9159: wip_logger.log(p_msg => l_msg,
9160: x_returnStatus => l_returnStatus);
9161: END IF;
9162:
9209: ));
9210:
9211: -- IF debug message level = 2, write statement below to log file
9212: IF (l_logLevel <= wip_constants.full_logging) THEN
9213: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
9214: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9215: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
9216: l_msg := fnd_message.get;
9217: wip_logger.log(p_msg => l_msg,
9210:
9211: -- IF debug message level = 2, write statement below to log file
9212: IF (l_logLevel <= wip_constants.full_logging) THEN
9213: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
9214: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9215: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
9216: l_msg := fnd_message.get;
9217: wip_logger.log(p_msg => l_msg,
9218: x_returnStatus => l_returnStatus);
9211: -- IF debug message level = 2, write statement below to log file
9212: IF (l_logLevel <= wip_constants.full_logging) THEN
9213: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
9214: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9215: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
9216: l_msg := fnd_message.get;
9217: wip_logger.log(p_msg => l_msg,
9218: x_returnStatus => l_returnStatus);
9219: END IF;
9212: IF (l_logLevel <= wip_constants.full_logging) THEN
9213: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
9214: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9215: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
9216: l_msg := fnd_message.get;
9217: wip_logger.log(p_msg => l_msg,
9218: x_returnStatus => l_returnStatus);
9219: END IF;
9220:
9255: AND msi.lot_control_code = WIP_CONSTANTS.LOT);
9256:
9257: -- IF debug message level = 2, write statement below to log file
9258: IF (l_logLevel <= wip_constants.full_logging) THEN
9259: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
9260: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9261: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
9262: l_msg := fnd_message.get;
9263: wip_logger.log(p_msg => l_msg,
9256:
9257: -- IF debug message level = 2, write statement below to log file
9258: IF (l_logLevel <= wip_constants.full_logging) THEN
9259: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
9260: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9261: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
9262: l_msg := fnd_message.get;
9263: wip_logger.log(p_msg => l_msg,
9264: x_returnStatus => l_returnStatus);
9257: -- IF debug message level = 2, write statement below to log file
9258: IF (l_logLevel <= wip_constants.full_logging) THEN
9259: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
9260: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9261: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
9262: l_msg := fnd_message.get;
9263: wip_logger.log(p_msg => l_msg,
9264: x_returnStatus => l_returnStatus);
9265: END IF;
9258: IF (l_logLevel <= wip_constants.full_logging) THEN
9259: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
9260: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9261: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
9262: l_msg := fnd_message.get;
9263: wip_logger.log(p_msg => l_msg,
9264: x_returnStatus => l_returnStatus);
9265: END IF;
9266:
9332: AND mti.move_transaction_id = wsmi.transaction_id;
9333:
9334: -- IF debug message level = 2, write statement below to log file
9335: IF (l_logLevel <= wip_constants.full_logging) THEN
9336: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9337: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9338: fnd_message.set_token('ENTITY2', 'MTL_SERIAL_NUMBERS_INTERFACE');
9339: l_msg := fnd_message.get;
9340: wip_logger.log(p_msg => l_msg,
9333:
9334: -- IF debug message level = 2, write statement below to log file
9335: IF (l_logLevel <= wip_constants.full_logging) THEN
9336: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9337: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9338: fnd_message.set_token('ENTITY2', 'MTL_SERIAL_NUMBERS_INTERFACE');
9339: l_msg := fnd_message.get;
9340: wip_logger.log(p_msg => l_msg,
9341: x_returnStatus => l_returnStatus);
9334: -- IF debug message level = 2, write statement below to log file
9335: IF (l_logLevel <= wip_constants.full_logging) THEN
9336: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9337: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9338: fnd_message.set_token('ENTITY2', 'MTL_SERIAL_NUMBERS_INTERFACE');
9339: l_msg := fnd_message.get;
9340: wip_logger.log(p_msg => l_msg,
9341: x_returnStatus => l_returnStatus);
9342: END IF;
9335: IF (l_logLevel <= wip_constants.full_logging) THEN
9336: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9337: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9338: fnd_message.set_token('ENTITY2', 'MTL_SERIAL_NUMBERS_INTERFACE');
9339: l_msg := fnd_message.get;
9340: wip_logger.log(p_msg => l_msg,
9341: x_returnStatus => l_returnStatus);
9342: END IF;
9343: END IF; -- Discrete or OSFM jobs
9442: p_procReturnStatus => x_returnStatus,
9443: p_msg => l_errMsg,
9444: x_returnStatus => l_returnStatus);
9445: END IF;
9446: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9447: fnd_message.set_token('MESSAGE', l_errMsg);
9448: fnd_msg_pub.add;
9449: END ez_completion;
9450:
9443: p_msg => l_errMsg,
9444: x_returnStatus => l_returnStatus);
9445: END IF;
9446: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9447: fnd_message.set_token('MESSAGE', l_errMsg);
9448: fnd_msg_pub.add;
9449: END ez_completion;
9450:
9451: /*****************************************************************************
9553: p_procReturnStatus => x_returnStatus,
9554: p_msg => l_errMsg,
9555: x_returnStatus => l_returnStatus);
9556: END IF;
9557: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9558: fnd_message.set_token('MESSAGE', l_errMsg);
9559: fnd_msg_pub.add;
9560: END update_wro;
9561:
9554: p_msg => l_errMsg,
9555: x_returnStatus => l_returnStatus);
9556: END IF;
9557: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9558: fnd_message.set_token('MESSAGE', l_errMsg);
9559: fnd_msg_pub.add;
9560: END update_wro;
9561:
9562: /*****************************************************************************
9833: p_procReturnStatus => x_returnStatus,
9834: p_msg => l_errMsg,
9835: x_returnStatus => l_returnStatus);
9836: END IF;
9837: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9838: fnd_message.set_token('MESSAGE', l_errMsg);
9839: fnd_msg_pub.add;
9840: END move_txns;
9841:
9834: p_msg => l_errMsg,
9835: x_returnStatus => l_returnStatus);
9836: END IF;
9837: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9838: fnd_message.set_token('MESSAGE', l_errMsg);
9839: fnd_msg_pub.add;
9840: END move_txns;
9841:
9842: /*****************************************************************************
10117: AND transaction_id = l_jobs.txn_id;
10118: wip_logger.log('Updated WMTI record to error', l_returnStatus);
10119:
10120: select WIP_ENTITY_NAME into l_job_name from wip_entities where WIP_ENTITY_ID = l_jobs.wip_entity_id;
10121: fnd_message.set_name('WIP', 'WIP_WORK_ORDER_LOCKED');
10122: fnd_message.set_token('JOBNAME', l_job_name);
10123: l_errMsg := fnd_message.get;
10124: wip_logger.log(l_errMsg, l_returnStatus);
10125: /* insert error messages */
10118: wip_logger.log('Updated WMTI record to error', l_returnStatus);
10119:
10120: select WIP_ENTITY_NAME into l_job_name from wip_entities where WIP_ENTITY_ID = l_jobs.wip_entity_id;
10121: fnd_message.set_name('WIP', 'WIP_WORK_ORDER_LOCKED');
10122: fnd_message.set_token('JOBNAME', l_job_name);
10123: l_errMsg := fnd_message.get;
10124: wip_logger.log(l_errMsg, l_returnStatus);
10125: /* insert error messages */
10126: INSERT INTO wip_txn_interface_errors
10119:
10120: select WIP_ENTITY_NAME into l_job_name from wip_entities where WIP_ENTITY_ID = l_jobs.wip_entity_id;
10121: fnd_message.set_name('WIP', 'WIP_WORK_ORDER_LOCKED');
10122: fnd_message.set_token('JOBNAME', l_job_name);
10123: l_errMsg := fnd_message.get;
10124: wip_logger.log(l_errMsg, l_returnStatus);
10125: /* insert error messages */
10126: INSERT INTO wip_txn_interface_errors
10127: (transaction_id,
10261: x_returnStatus => x_returnStatus,
10262: x_errorMsg => l_errMsg);
10263:
10264: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10265: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
10266: fnd_message.set_token('MESSAGE', l_errMsg);
10267: fnd_msg_pub.add;
10268: l_errMsg := 'wip_mtlTempProc_priv.processTemp failed' ;
10269: raise fnd_api.g_exc_unexpected_error;
10262: x_errorMsg => l_errMsg);
10263:
10264: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10265: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
10266: fnd_message.set_token('MESSAGE', l_errMsg);
10267: fnd_msg_pub.add;
10268: l_errMsg := 'wip_mtlTempProc_priv.processTemp failed' ;
10269: raise fnd_api.g_exc_unexpected_error;
10270: END IF;
10341: p_msg_count => l_msgCount,
10342: p_msg_data => l_errMsg);
10343:
10344: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10345: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
10346: fnd_message.set_token('MESSAGE', l_errMsg);
10347: fnd_msg_pub.add;
10348: l_errMsg := 'QA Failed. Collection ID:' || l_qa_collection_id;
10349: raise fnd_api.g_exc_unexpected_error;
10342: p_msg_data => l_errMsg);
10343:
10344: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10345: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
10346: fnd_message.set_token('MESSAGE', l_errMsg);
10347: fnd_msg_pub.add;
10348: l_errMsg := 'QA Failed. Collection ID:' || l_qa_collection_id;
10349: raise fnd_api.g_exc_unexpected_error;
10350: END IF;
10365: AND TRUNC(transaction_date) = TRUNC(l_gib.txn_date);
10366:
10367: -- IF debug message level = 2, write statement below to log file
10368: IF (l_logLevel <= wip_constants.full_logging) THEN
10369: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
10370: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
10371: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
10372: l_msg := fnd_message.get;
10373: wip_logger.log(p_msg => l_msg,
10366:
10367: -- IF debug message level = 2, write statement below to log file
10368: IF (l_logLevel <= wip_constants.full_logging) THEN
10369: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
10370: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
10371: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
10372: l_msg := fnd_message.get;
10373: wip_logger.log(p_msg => l_msg,
10374: x_returnStatus => l_returnStatus);
10367: -- IF debug message level = 2, write statement below to log file
10368: IF (l_logLevel <= wip_constants.full_logging) THEN
10369: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
10370: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
10371: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
10372: l_msg := fnd_message.get;
10373: wip_logger.log(p_msg => l_msg,
10374: x_returnStatus => l_returnStatus);
10375: END IF;
10368: IF (l_logLevel <= wip_constants.full_logging) THEN
10369: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
10370: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
10371: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
10372: l_msg := fnd_message.get;
10373: wip_logger.log(p_msg => l_msg,
10374: x_returnStatus => l_returnStatus);
10375: END IF;
10376:
10408: x_returnStatus => x_returnStatus,
10409: x_errorMsg => l_errMsg);
10410:
10411: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10412: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
10413: fnd_message.set_token('MESSAGE', l_errMsg);
10414: fnd_msg_pub.add;
10415: l_errMsg := 'wip_mtlTempProc_priv.processTemp failed' ;
10416: raise fnd_api.g_exc_unexpected_error;
10409: x_errorMsg => l_errMsg);
10410:
10411: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10412: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
10413: fnd_message.set_token('MESSAGE', l_errMsg);
10414: fnd_msg_pub.add;
10415: l_errMsg := 'wip_mtlTempProc_priv.processTemp failed' ;
10416: raise fnd_api.g_exc_unexpected_error;
10417: END IF;
10490: ELSE
10491: IF(l_ls_required = WIP_CONSTANTS.YES) THEN
10492: -- If we need to gather more lot/serial, error out because
10493: -- we cannot gather lot/serial for background transaction.
10494: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
10495: fnd_msg_pub.add;
10496: raise fnd_api.g_exc_unexpected_error;
10497: END IF;
10498: END IF; -- check return status
10529: ELSE
10530: IF(l_ls_required = WIP_CONSTANTS.YES) THEN
10531: -- If we need to gather more lot/serial, error out because
10532: -- we cannot gather lot/serial for background transaction.
10533: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
10534: fnd_msg_pub.add;
10535: raise fnd_api.g_exc_unexpected_error;
10536: END IF;
10537: END IF; -- check return status
10542: wip_utilities.get_message_stack(p_msg =>l_errMsg);
10543: IF(l_errMsg IS NULL) THEN
10544: -- initialize message to something because we cannot
10545: -- insert null into WIP_TXN_INTERFACE_ERRORS
10546: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10547: l_errMsg := fnd_message.get;
10548: END IF;
10549: IF(p_move_mode = WIP_CONSTANTS.BACKGROUND) THEN
10550: /* Update process status to error */
10543: IF(l_errMsg IS NULL) THEN
10544: -- initialize message to something because we cannot
10545: -- insert null into WIP_TXN_INTERFACE_ERRORS
10546: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10547: l_errMsg := fnd_message.get;
10548: END IF;
10549: IF(p_move_mode = WIP_CONSTANTS.BACKGROUND) THEN
10550: /* Update process status to error */
10551: UPDATE wip_move_txn_interface
10652: x_returnStatus => x_returnStatus,
10653: x_errorMsg => l_errMsg);
10654:
10655: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10656: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
10657: fnd_message.set_token('MESSAGE', l_errMsg);
10658: fnd_msg_pub.add;
10659: l_errMsg := 'wip_mtlTempProc_priv.processTemp failed' ;
10660: raise fnd_api.g_exc_unexpected_error;
10653: x_errorMsg => l_errMsg);
10654:
10655: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10656: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
10657: fnd_message.set_token('MESSAGE', l_errMsg);
10658: fnd_msg_pub.add;
10659: l_errMsg := 'wip_mtlTempProc_priv.processTemp failed' ;
10660: raise fnd_api.g_exc_unexpected_error;
10661: END IF;
10707: wip_utilities.get_message_stack(p_msg =>l_errMsg);
10708: IF(l_errMsg IS NULL) THEN
10709: -- initialize message to something because we cannot insert null
10710: -- into WIP_TXN_INTERFACE_ERRORS
10711: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10712: l_errMsg := fnd_message.get;
10713: END IF;
10714:
10715: /* insert error messages */
10708: IF(l_errMsg IS NULL) THEN
10709: -- initialize message to something because we cannot insert null
10710: -- into WIP_TXN_INTERFACE_ERRORS
10711: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10712: l_errMsg := fnd_message.get;
10713: END IF;
10714:
10715: /* insert error messages */
10716: INSERT INTO wip_txn_interface_errors
10888: -- Fixed bug 5355443. We should not always put WIP_SOME_RECORDS_ERROR in
10889: -- the message stack because this API will be called for both online and
10890: -- background transaction. However, WIP_SOME_RECORDS_ERROR is only
10891: -- applicable for background transaction.
10892: --fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10893: --fnd_msg_pub.add;
10894: IF (l_logLevel <= wip_constants.trace_logging) THEN
10895: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processIntf',
10896: p_procReturnStatus => x_returnStatus,
10984: -- Fixed bug 5355443. Since WIP_SOME_RECORDS_ERROR message is only
10985: -- applicable to background transaction, we should set error message here
10986: -- instead of wip_movProc_priv.processIntf().
10987: --wip_utilities.get_message_stack(p_msg =>errbuf);
10988: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10989: errbuf := fnd_message.get;
10990: END IF;
10991: COMMIT; -- To prevent Move Worker concurrent program rollback.
10992: EXCEPTION
10985: -- applicable to background transaction, we should set error message here
10986: -- instead of wip_movProc_priv.processIntf().
10987: --wip_utilities.get_message_stack(p_msg =>errbuf);
10988: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10989: errbuf := fnd_message.get;
10990: END IF;
10991: COMMIT; -- To prevent Move Worker concurrent program rollback.
10992: EXCEPTION
10993: WHEN others THEN
11056: AND mmtt.transaction_action_id = WIP_CONSTANTS.SCRASSY_ACTION;
11057:
11058: -- IF debug message level = 2, write statement below to log file
11059: IF (l_logLevel <= wip_constants.full_logging) THEN
11060: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
11061: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
11062: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TXN_ALLOCATIONS');
11063: l_msg := fnd_message.get;
11064: wip_logger.log(p_msg => l_msg,
11057:
11058: -- IF debug message level = 2, write statement below to log file
11059: IF (l_logLevel <= wip_constants.full_logging) THEN
11060: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
11061: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
11062: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TXN_ALLOCATIONS');
11063: l_msg := fnd_message.get;
11064: wip_logger.log(p_msg => l_msg,
11065: x_returnStatus => l_returnStatus);
11058: -- IF debug message level = 2, write statement below to log file
11059: IF (l_logLevel <= wip_constants.full_logging) THEN
11060: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
11061: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
11062: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TXN_ALLOCATIONS');
11063: l_msg := fnd_message.get;
11064: wip_logger.log(p_msg => l_msg,
11065: x_returnStatus => l_returnStatus);
11066: END IF;
11059: IF (l_logLevel <= wip_constants.full_logging) THEN
11060: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
11061: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
11062: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TXN_ALLOCATIONS');
11063: l_msg := fnd_message.get;
11064: wip_logger.log(p_msg => l_msg,
11065: x_returnStatus => l_returnStatus);
11066: END IF;
11067: x_returnStatus := fnd_api.g_ret_sts_success;
11076: p_procReturnStatus => x_returnStatus,
11077: p_msg => l_msg,
11078: x_returnStatus => l_returnStatus);
11079: END IF;
11080: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
11081: fnd_message.set_token('MESSAGE', l_msg);
11082: fnd_msg_pub.add;
11083: END repetitive_scrap;
11084:
11077: p_msg => l_msg,
11078: x_returnStatus => l_returnStatus);
11079: END IF;
11080: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
11081: fnd_message.set_token('MESSAGE', l_msg);
11082: fnd_msg_pub.add;
11083: END repetitive_scrap;
11084:
11085: /*****************************************************************************
11435: AND mtli.lot_expiration_date is null;
11436:
11437: -- IF debug message level = 2, write statement below to log file
11438: IF (l_log_level <= wip_constants.full_logging) THEN
11439: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
11440: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
11441: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
11442: l_msg := fnd_message.get;
11443: wip_logger.log(p_msg => l_msg,
11436:
11437: -- IF debug message level = 2, write statement below to log file
11438: IF (l_log_level <= wip_constants.full_logging) THEN
11439: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
11440: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
11441: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
11442: l_msg := fnd_message.get;
11443: wip_logger.log(p_msg => l_msg,
11444: x_returnStatus => l_return_status);
11437: -- IF debug message level = 2, write statement below to log file
11438: IF (l_log_level <= wip_constants.full_logging) THEN
11439: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
11440: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
11441: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
11442: l_msg := fnd_message.get;
11443: wip_logger.log(p_msg => l_msg,
11444: x_returnStatus => l_return_status);
11445: END IF;
11438: IF (l_log_level <= wip_constants.full_logging) THEN
11439: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
11440: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
11441: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
11442: l_msg := fnd_message.get;
11443: wip_logger.log(p_msg => l_msg,
11444: x_returnStatus => l_return_status);
11445: END IF;
11446:
11479: AND msi.lot_control_code = WIP_CONSTANTS.LOT);
11480:
11481: -- IF debug message level = 2, write statement below to log file
11482: IF (l_log_level <= wip_constants.full_logging) THEN
11483: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
11484: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
11485: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
11486: l_msg := fnd_message.get;
11487: wip_logger.log(p_msg => l_msg,
11480:
11481: -- IF debug message level = 2, write statement below to log file
11482: IF (l_log_level <= wip_constants.full_logging) THEN
11483: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
11484: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
11485: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
11486: l_msg := fnd_message.get;
11487: wip_logger.log(p_msg => l_msg,
11488: x_returnStatus => l_return_status);
11481: -- IF debug message level = 2, write statement below to log file
11482: IF (l_log_level <= wip_constants.full_logging) THEN
11483: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
11484: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
11485: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
11486: l_msg := fnd_message.get;
11487: wip_logger.log(p_msg => l_msg,
11488: x_returnStatus => l_return_status);
11489: END IF;
11482: IF (l_log_level <= wip_constants.full_logging) THEN
11483: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
11484: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
11485: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
11486: l_msg := fnd_message.get;
11487: wip_logger.log(p_msg => l_msg,
11488: x_returnStatus => l_return_status);
11489: END IF;
11490:
11607: -- If it fails inventory validation, no error will be recorded in WTIE.
11608: -- Instead, error message will be put in message stack.
11609: -- fnd_msg_pub.initialize;
11610: FOR l_errors IN c_errors LOOP
11611: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
11612: fnd_message.set_token('MESSAGE', l_errors.error_message);
11613: fnd_msg_pub.add;
11614: END LOOP;
11615: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
11608: -- Instead, error message will be put in message stack.
11609: -- fnd_msg_pub.initialize;
11610: FOR l_errors IN c_errors LOOP
11611: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
11612: fnd_message.set_token('MESSAGE', l_errors.error_message);
11613: fnd_msg_pub.add;
11614: END LOOP;
11615: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
11616: x_returnStatus := fnd_api.g_ret_sts_error;
11627: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
11628: x_returnStatus := fnd_api.g_ret_sts_error;
11629: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
11630:
11631: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
11632: fnd_message.set_token('MESSAGE', l_error_msg);
11633: fnd_msg_pub.add;
11634:
11635: IF (l_log_level <= wip_constants.trace_logging) THEN
11628: x_returnStatus := fnd_api.g_ret_sts_error;
11629: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
11630:
11631: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
11632: fnd_message.set_token('MESSAGE', l_error_msg);
11633: fnd_msg_pub.add;
11634:
11635: IF (l_log_level <= wip_constants.trace_logging) THEN
11636: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processOATxn',