eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_MOVPROC_PRIV dependencies on FND_MESSAGE

Line 235: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');

231: ELSE
232: IF(l_ls_required = WIP_CONSTANTS.YES) THEN
233: -- If we need to gather more lot/serial, error out because
234: -- we cannot gather lot/serial for background transaction.
235: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
236: fnd_msg_pub.add;
237: raise fnd_api.g_exc_unexpected_error;
238: END IF;
239: END IF; -- check return status

Line 278: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');

274: ELSE
275: IF(l_ls_required = WIP_CONSTANTS.YES) THEN
276: -- If we need to gather more lot/serial, error out because
277: -- we cannot gather lot/serial for background transaction.
278: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
279: fnd_msg_pub.add;
280: raise fnd_api.g_exc_unexpected_error;
281: END IF;
282: END IF; -- check return status

Line 318: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');

314: ELSE
315: IF(l_ls_required = WIP_CONSTANTS.YES) THEN
316: -- If we need to gather more lot/serial, error out because
317: -- we cannot gather lot/serial for background transaction.
318: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
319: fnd_msg_pub.add;
320: raise fnd_api.g_exc_unexpected_error;
321: END IF;
322: END IF; -- check return status

Line 371: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');

367: AND mti.move_transaction_id = wmti.transaction_id
368: AND mti.error_explanation IS NOT NULL);
369:
370: IF (l_logLevel <= wip_constants.full_logging) THEN
371: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
372: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
373: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
374: l_msg := fnd_message.get;
375: wip_logger.log(p_msg => l_msg,

Line 372: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

368: AND mti.error_explanation IS NOT NULL);
369:
370: IF (l_logLevel <= wip_constants.full_logging) THEN
371: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
372: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
373: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
374: l_msg := fnd_message.get;
375: wip_logger.log(p_msg => l_msg,
376: x_returnStatus => l_returnStatus);

Line 373: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');

369:
370: IF (l_logLevel <= wip_constants.full_logging) THEN
371: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
372: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
373: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
374: l_msg := fnd_message.get;
375: wip_logger.log(p_msg => l_msg,
376: x_returnStatus => l_returnStatus);
377: END IF;

Line 374: l_msg := fnd_message.get;

370: IF (l_logLevel <= wip_constants.full_logging) THEN
371: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
372: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
373: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
374: l_msg := fnd_message.get;
375: wip_logger.log(p_msg => l_msg,
376: x_returnStatus => l_returnStatus);
377: END IF;
378:

Line 551: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

547: p_procReturnStatus => l_returnStatus,
548: p_msg => l_errMsg,
549: x_returnStatus => l_returnStatus);
550: END IF;
551: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
552: fnd_message.set_token('MESSAGE', l_errMsg);
553: fnd_msg_pub.add;
554: END write_mtl_errors;
555:

Line 552: fnd_message.set_token('MESSAGE', l_errMsg);

548: p_msg => l_errMsg,
549: x_returnStatus => l_returnStatus);
550: END IF;
551: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
552: fnd_message.set_token('MESSAGE', l_errMsg);
553: fnd_msg_pub.add;
554: END write_mtl_errors;
555:
556: /*****************************************************************************

Line 640: fnd_message.set_name('INV','INV_WIP_WORK_ORDER_LOCKED');

636: p_procReturnStatus => x_returnStatus,
637: p_msg => l_errMsg,
638: x_returnStatus => l_returnStatus);
639: END IF;
640: fnd_message.set_name('INV','INV_WIP_WORK_ORDER_LOCKED');
641: fnd_msg_pub.add;
642:
643: WHEN others THEN
644: IF(c_wipops%ISOPEN) THEN

Line 656: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

652: p_procReturnStatus => x_returnStatus,
653: p_msg => l_errMsg,
654: x_returnStatus => l_returnStatus);
655: END IF;
656: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
657: fnd_message.set_token('MESSAGE', l_errMsg);
658: fnd_msg_pub.add;
659: END lock_wipops;
660:

Line 657: fnd_message.set_token('MESSAGE', l_errMsg);

653: p_msg => l_errMsg,
654: x_returnStatus => l_returnStatus);
655: END IF;
656: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
657: fnd_message.set_token('MESSAGE', l_errMsg);
658: fnd_msg_pub.add;
659: END lock_wipops;
660:
661: /*****************************************************************************

Line 930: fnd_message.set_name('WIP','WIP_INT_ERROR_NO_SCHED');

926: x_returnStatus => l_returnStatus);
927: END IF;
928:
929: /* Fix for bug 5373061: Passed missing token */
930: fnd_message.set_name('WIP','WIP_INT_ERROR_NO_SCHED');
931: fnd_message.set_token('ROUTINE', 'wip_movProc_priv.schedule_alloc');
932: fnd_msg_pub.add;
933:
934: WHEN others THEN

Line 931: fnd_message.set_token('ROUTINE', 'wip_movProc_priv.schedule_alloc');

927: END IF;
928:
929: /* Fix for bug 5373061: Passed missing token */
930: fnd_message.set_name('WIP','WIP_INT_ERROR_NO_SCHED');
931: fnd_message.set_token('ROUTINE', 'wip_movProc_priv.schedule_alloc');
932: fnd_msg_pub.add;
933:
934: WHEN others THEN
935: IF(c_rsa%ISOPEN) THEN

Line 948: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

944: p_procReturnStatus => x_returnStatus,
945: p_msg => l_errMsg,
946: x_returnStatus => l_returnStatus);
947: END IF;
948: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
949: fnd_message.set_token('MESSAGE', l_errMsg);
950: fnd_msg_pub.add;
951: END schedule_alloc;
952:

Line 949: fnd_message.set_token('MESSAGE', l_errMsg);

945: p_msg => l_errMsg,
946: x_returnStatus => l_returnStatus);
947: END IF;
948: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
949: fnd_message.set_token('MESSAGE', l_errMsg);
950: fnd_msg_pub.add;
951: END schedule_alloc;
952:
953: /*****************************************************************************

Line 1091: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1087: p_msg => l_errMsg,
1088: x_returnStatus => l_returnStatus);
1089: END IF;
1090:
1091: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1092: fnd_message.set_token('MESSAGE', l_msgData);
1093: fnd_msg_pub.add;
1094:
1095: WHEN others THEN

Line 1092: fnd_message.set_token('MESSAGE', l_msgData);

1088: x_returnStatus => l_returnStatus);
1089: END IF;
1090:
1091: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1092: fnd_message.set_token('MESSAGE', l_msgData);
1093: fnd_msg_pub.add;
1094:
1095: WHEN others THEN
1096: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

Line 1105: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1101: p_procReturnStatus => x_returnStatus,
1102: p_msg => l_errMsg,
1103: x_returnStatus => l_returnStatus);
1104: END IF;
1105: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1106: fnd_message.set_token('MESSAGE', l_errMsg);
1107: fnd_msg_pub.add;
1108: END insert_alloc_child;
1109:

Line 1106: fnd_message.set_token('MESSAGE', l_errMsg);

1102: p_msg => l_errMsg,
1103: x_returnStatus => l_returnStatus);
1104: END IF;
1105: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1106: fnd_message.set_token('MESSAGE', l_errMsg);
1107: fnd_msg_pub.add;
1108: END insert_alloc_child;
1109:
1110: /*****************************************************************************

Line 1307: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1303: p_procReturnStatus => x_returnStatus,
1304: p_msg => l_errMsg,
1305: x_returnStatus => l_returnStatus);
1306: END IF;
1307: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1308: fnd_message.set_token('MESSAGE', l_errMsg);
1309: fnd_msg_pub.add;
1310: END update_wo_rs;
1311:

Line 1308: fnd_message.set_token('MESSAGE', l_errMsg);

1304: p_msg => l_errMsg,
1305: x_returnStatus => l_returnStatus);
1306: END IF;
1307: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1308: fnd_message.set_token('MESSAGE', l_errMsg);
1309: fnd_msg_pub.add;
1310: END update_wo_rs;
1311:
1312:

Line 1419: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1415: p_procReturnStatus => x_returnStatus,
1416: p_msg => l_errMsg,
1417: x_returnStatus => l_returnStatus);
1418: END IF;
1419: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1420: fnd_message.set_token('MESSAGE', l_errMsg);
1421: fnd_msg_pub.add;
1422: END update_wipops;
1423:

Line 1420: fnd_message.set_token('MESSAGE', l_errMsg);

1416: p_msg => l_errMsg,
1417: x_returnStatus => l_returnStatus);
1418: END IF;
1419: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1420: fnd_message.set_token('MESSAGE', l_errMsg);
1421: fnd_msg_pub.add;
1422: END update_wipops;
1423:
1424: /*****************************************************************************

Line 1734: fnd_message.set_name('WIP', 'WIP_OVERCOMPLETION_MISMATCH');

1730: END IF; -- time out check
1731: END IF; -- BACKGROUND check
1732:
1733: IF(l_proc_status = TVE_OVERCOMPLETION_MISMATCH) THEN
1734: fnd_message.set_name('WIP', 'WIP_OVERCOMPLETION_MISMATCH');
1735: fnd_msg_pub.add;
1736: l_errMsg := 'parent txn is not really overcompletion txn';
1737: raise fnd_api.g_exc_unexpected_error;
1738: ELSE

Line 1739: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');

1735: fnd_msg_pub.add;
1736: l_errMsg := 'parent txn is not really overcompletion txn';
1737: raise fnd_api.g_exc_unexpected_error;
1738: ELSE
1739: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1740: fnd_message.set_token('ENTITY1', 'transaction quantity');
1741: fnd_message.set_token('ENTITY2', 'quantity available to move');
1742: fnd_msg_pub.add;
1743: l_errMsg := 'available qty is not enough to fullfill move txn';

Line 1740: fnd_message.set_token('ENTITY1', 'transaction quantity');

1736: l_errMsg := 'parent txn is not really overcompletion txn';
1737: raise fnd_api.g_exc_unexpected_error;
1738: ELSE
1739: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1740: fnd_message.set_token('ENTITY1', 'transaction quantity');
1741: fnd_message.set_token('ENTITY2', 'quantity available to move');
1742: fnd_msg_pub.add;
1743: l_errMsg := 'available qty is not enough to fullfill move txn';
1744: raise fnd_api.g_exc_unexpected_error;

Line 1741: fnd_message.set_token('ENTITY2', 'quantity available to move');

1737: raise fnd_api.g_exc_unexpected_error;
1738: ELSE
1739: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1740: fnd_message.set_token('ENTITY1', 'transaction quantity');
1741: fnd_message.set_token('ENTITY2', 'quantity available to move');
1742: fnd_msg_pub.add;
1743: l_errMsg := 'available qty is not enough to fullfill move txn';
1744: raise fnd_api.g_exc_unexpected_error;
1745: END IF;

Line 1787: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');

1783: wip_utilities.get_message_stack(p_msg =>l_msg);
1784: IF(l_msg IS NULL) THEN
1785: -- initialize message to something because we cannot insert
1786: -- null into WIP_TXN_INTERFACE_ERRORS
1787: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
1788: l_msg := fnd_message.get;
1789: END IF;
1790:
1791: INSERT INTO WIP_TXN_INTERFACE_ERRORS

Line 1788: l_msg := fnd_message.get;

1784: IF(l_msg IS NULL) THEN
1785: -- initialize message to something because we cannot insert
1786: -- null into WIP_TXN_INTERFACE_ERRORS
1787: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
1788: l_msg := fnd_message.get;
1789: END IF;
1790:
1791: INSERT INTO WIP_TXN_INTERFACE_ERRORS
1792: (transaction_id,

Line 1875: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1871: p_procReturnStatus => x_returnStatus,
1872: p_msg => l_errMsg,
1873: x_returnStatus => l_returnStatus);
1874: END IF;
1875: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1876: fnd_message.set_token('MESSAGE', l_errMsg);
1877: fnd_msg_pub.add;
1878: END rep_move_alloc;
1879:

Line 1876: fnd_message.set_token('MESSAGE', l_errMsg);

1872: p_msg => l_errMsg,
1873: x_returnStatus => l_returnStatus);
1874: END IF;
1875: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1876: fnd_message.set_token('MESSAGE', l_errMsg);
1877: fnd_msg_pub.add;
1878: END rep_move_alloc;
1879:
1880: /*****************************************************************************

Line 2085: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

2081: p_procReturnStatus => x_returnStatus,
2082: p_msg => l_errMsg,
2083: x_returnStatus => l_returnStatus);
2084: END IF;
2085: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2086: fnd_message.set_token('MESSAGE', l_errMsg);
2087: fnd_msg_pub.add;
2088: END update_wo_dj;
2089:

Line 2086: fnd_message.set_token('MESSAGE', l_errMsg);

2082: p_msg => l_errMsg,
2083: x_returnStatus => l_returnStatus);
2084: END IF;
2085: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2086: fnd_message.set_token('MESSAGE', l_errMsg);
2087: fnd_msg_pub.add;
2088: END update_wo_dj;
2089:
2090: /*****************************************************************************

Line 2232: fnd_message.set_name('WIP', 'WIP_SERIAL_LOCATION_MISSMATCH');

2228: IF(l_dj_txn.txn_type IN (WIP_CONSTANTS.COMP_TXN,
2229: WIP_CONSTANTS.MOVE_TXN) AND
2230: (l_ser_loc.sn_op <> l_dj_txn.fm_op OR
2231: l_ser_loc.sn_step <> l_dj_txn.fm_step)) THEN
2232: fnd_message.set_name('WIP', 'WIP_SERIAL_LOCATION_MISSMATCH');
2233: fnd_msg_pub.add;
2234: l_errMsg := 'current serial location missmatch';
2235: raise fnd_api.g_exc_unexpected_error;
2236: ELSE -- serial location is valid to move

Line 2329: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');

2325: WHERE transaction_id = l_dj_txn.txn_id
2326: AND group_id = p_gib.group_id;
2327: END IF; -- time out check
2328: END IF; -- BACKGROUND check
2329: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
2330: fnd_message.set_token('ENTITY1', 'transaction quantity');
2331: fnd_message.set_token('ENTITY2', 'quantity available to move');
2332: fnd_msg_pub.add;
2333: l_errMsg := 'available qty is not enough to fullfill move txn';

Line 2330: fnd_message.set_token('ENTITY1', 'transaction quantity');

2326: AND group_id = p_gib.group_id;
2327: END IF; -- time out check
2328: END IF; -- BACKGROUND check
2329: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
2330: fnd_message.set_token('ENTITY1', 'transaction quantity');
2331: fnd_message.set_token('ENTITY2', 'quantity available to move');
2332: fnd_msg_pub.add;
2333: l_errMsg := 'available qty is not enough to fullfill move txn';
2334: raise fnd_api.g_exc_unexpected_error;

Line 2331: fnd_message.set_token('ENTITY2', 'quantity available to move');

2327: END IF; -- time out check
2328: END IF; -- BACKGROUND check
2329: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
2330: fnd_message.set_token('ENTITY1', 'transaction quantity');
2331: fnd_message.set_token('ENTITY2', 'quantity available to move');
2332: fnd_msg_pub.add;
2333: l_errMsg := 'available qty is not enough to fullfill move txn';
2334: raise fnd_api.g_exc_unexpected_error;
2335: ELSE -- enough qty to move

Line 2465: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');

2461: wip_utilities.get_message_stack(p_msg =>l_msg);
2462: IF(l_msg IS NULL) THEN
2463: -- initialize message to something because we cannot insert
2464: -- null into WIP_TXN_INTERFACE_ERRORS
2465: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
2466: l_msg := fnd_message.get;
2467: END IF;
2468:
2469: INSERT INTO WIP_TXN_INTERFACE_ERRORS

Line 2466: l_msg := fnd_message.get;

2462: IF(l_msg IS NULL) THEN
2463: -- initialize message to something because we cannot insert
2464: -- null into WIP_TXN_INTERFACE_ERRORS
2465: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
2466: l_msg := fnd_message.get;
2467: END IF;
2468:
2469: INSERT INTO WIP_TXN_INTERFACE_ERRORS
2470: (transaction_id,

Line 2547: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

2543: p_procReturnStatus => x_returnStatus,
2544: p_msg => l_errMsg,
2545: x_returnStatus => l_returnStatus);
2546: END IF;
2547: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2548: fnd_message.set_token('MESSAGE', l_errMsg);
2549: fnd_msg_pub.add;
2550: END check_qty_dj;
2551:

Line 2548: fnd_message.set_token('MESSAGE', l_errMsg);

2544: p_msg => l_errMsg,
2545: x_returnStatus => l_returnStatus);
2546: END IF;
2547: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2548: fnd_message.set_token('MESSAGE', l_errMsg);
2549: fnd_msg_pub.add;
2550: END check_qty_dj;
2551:
2552: /*****************************************************************************

Line 2754: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

2750: p_procReturnStatus => x_returnStatus,
2751: p_msg => l_errMsg,
2752: x_returnStatus => l_returnStatus);
2753: END IF;
2754: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2755: fnd_message.set_token('MESSAGE', l_errMsg);
2756: fnd_msg_pub.add;
2757: END get_move_profile;
2758:

Line 2755: fnd_message.set_token('MESSAGE', l_errMsg);

2751: p_msg => l_errMsg,
2752: x_returnStatus => l_returnStatus);
2753: END IF;
2754: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2755: fnd_message.set_token('MESSAGE', l_errMsg);
2756: fnd_msg_pub.add;
2757: END get_move_profile;
2758:
2759: /*****************************************************************************

Line 2828: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

2824: AND wmti.process_status = WIP_CONSTANTS.RUNNING;
2825:
2826: -- IF debug message level = 2, write statement below to log file
2827: IF (l_logLevel <= wip_constants.full_logging) THEN
2828: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
2829: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
2830: fnd_message.set_token('ENTITY2', 'WIP_SERIAL_MOVE_TRANSACTIONS');
2831: l_msg := fnd_message.get;
2832: wip_logger.log(p_msg => l_msg,

Line 2829: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

2825:
2826: -- IF debug message level = 2, write statement below to log file
2827: IF (l_logLevel <= wip_constants.full_logging) THEN
2828: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
2829: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
2830: fnd_message.set_token('ENTITY2', 'WIP_SERIAL_MOVE_TRANSACTIONS');
2831: l_msg := fnd_message.get;
2832: wip_logger.log(p_msg => l_msg,
2833: x_returnStatus => l_returnStatus);

Line 2830: fnd_message.set_token('ENTITY2', 'WIP_SERIAL_MOVE_TRANSACTIONS');

2826: -- IF debug message level = 2, write statement below to log file
2827: IF (l_logLevel <= wip_constants.full_logging) THEN
2828: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
2829: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
2830: fnd_message.set_token('ENTITY2', 'WIP_SERIAL_MOVE_TRANSACTIONS');
2831: l_msg := fnd_message.get;
2832: wip_logger.log(p_msg => l_msg,
2833: x_returnStatus => l_returnStatus);
2834: END IF;

Line 2831: l_msg := fnd_message.get;

2827: IF (l_logLevel <= wip_constants.full_logging) THEN
2828: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
2829: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
2830: fnd_message.set_token('ENTITY2', 'WIP_SERIAL_MOVE_TRANSACTIONS');
2831: l_msg := fnd_message.get;
2832: wip_logger.log(p_msg => l_msg,
2833: x_returnStatus => l_returnStatus);
2834: END IF;
2835:

Line 2971: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

2967: AND wdj.organization_id = wmti.organization_id;
2968:
2969: -- IF debug message level = 2, write statement below to log file
2970: IF (l_logLevel <= wip_constants.full_logging) THEN
2971: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
2972: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
2973: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
2974: l_msg := fnd_message.get;
2975: wip_logger.log(p_msg => l_msg,

Line 2972: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

2968:
2969: -- IF debug message level = 2, write statement below to log file
2970: IF (l_logLevel <= wip_constants.full_logging) THEN
2971: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
2972: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
2973: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
2974: l_msg := fnd_message.get;
2975: wip_logger.log(p_msg => l_msg,
2976: x_returnStatus => l_returnStatus);

Line 2973: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');

2969: -- IF debug message level = 2, write statement below to log file
2970: IF (l_logLevel <= wip_constants.full_logging) THEN
2971: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
2972: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
2973: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
2974: l_msg := fnd_message.get;
2975: wip_logger.log(p_msg => l_msg,
2976: x_returnStatus => l_returnStatus);
2977: END IF;

Line 2974: l_msg := fnd_message.get;

2970: IF (l_logLevel <= wip_constants.full_logging) THEN
2971: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
2972: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
2973: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
2974: l_msg := fnd_message.get;
2975: wip_logger.log(p_msg => l_msg,
2976: x_returnStatus => l_returnStatus);
2977: END IF;
2978:

Line 3101: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

3097: AND wmti.entity_type = WIP_CONSTANTS.REPETITIVE;
3098:
3099: -- IF debug message level = 2, write statement below to log file
3100: IF (l_logLevel <= wip_constants.full_logging) THEN
3101: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3102: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3103: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
3104: l_msg := fnd_message.get;
3105: wip_logger.log(p_msg => l_msg,

Line 3102: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

3098:
3099: -- IF debug message level = 2, write statement below to log file
3100: IF (l_logLevel <= wip_constants.full_logging) THEN
3101: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3102: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3103: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
3104: l_msg := fnd_message.get;
3105: wip_logger.log(p_msg => l_msg,
3106: x_returnStatus => l_returnStatus);

Line 3103: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');

3099: -- IF debug message level = 2, write statement below to log file
3100: IF (l_logLevel <= wip_constants.full_logging) THEN
3101: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3102: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3103: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
3104: l_msg := fnd_message.get;
3105: wip_logger.log(p_msg => l_msg,
3106: x_returnStatus => l_returnStatus);
3107: END IF;

Line 3104: l_msg := fnd_message.get;

3100: IF (l_logLevel <= wip_constants.full_logging) THEN
3101: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3102: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3103: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TRANSACTIONS');
3104: l_msg := fnd_message.get;
3105: wip_logger.log(p_msg => l_msg,
3106: x_returnStatus => l_returnStatus);
3107: END IF;
3108:

Line 3130: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

3126: p_procReturnStatus => x_returnStatus,
3127: p_msg => l_errMsg,
3128: x_returnStatus => l_returnStatus);
3129: END IF;
3130: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3131: fnd_message.set_token('MESSAGE', l_errMsg);
3132: fnd_msg_pub.add;
3133: END insert_txn_history;
3134:

Line 3131: fnd_message.set_token('MESSAGE', l_errMsg);

3127: p_msg => l_errMsg,
3128: x_returnStatus => l_returnStatus);
3129: END IF;
3130: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3131: fnd_message.set_token('MESSAGE', l_errMsg);
3132: fnd_msg_pub.add;
3133: END insert_txn_history;
3134:
3135: /*****************************************************************************

Line 3195: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

3191: p_procReturnStatus => x_returnStatus,
3192: p_msg => l_errMsg,
3193: x_returnStatus => l_returnStatus);
3194: END IF;
3195: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3196: fnd_message.set_token('MESSAGE', l_errMsg);
3197: fnd_msg_pub.add;
3198: END delete_child_txn;
3199:

Line 3196: fnd_message.set_token('MESSAGE', l_errMsg);

3192: p_msg => l_errMsg,
3193: x_returnStatus => l_returnStatus);
3194: END IF;
3195: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
3196: fnd_message.set_token('MESSAGE', l_errMsg);
3197: fnd_msg_pub.add;
3198: END delete_child_txn;
3199:
3200: /*****************************************************************************

Line 3468: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

3464: );
3465:
3466: -- IF debug message level = 2, write statement below to log file
3467: IF (l_logLevel <= wip_constants.full_logging) THEN
3468: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3469: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3470: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3471: l_msg := fnd_message.get;
3472: wip_logger.log(p_msg => l_msg,

Line 3469: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

3465:
3466: -- IF debug message level = 2, write statement below to log file
3467: IF (l_logLevel <= wip_constants.full_logging) THEN
3468: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3469: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3470: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3471: l_msg := fnd_message.get;
3472: wip_logger.log(p_msg => l_msg,
3473: x_returnStatus => l_returnStatus);

Line 3470: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');

3466: -- IF debug message level = 2, write statement below to log file
3467: IF (l_logLevel <= wip_constants.full_logging) THEN
3468: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3469: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3470: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3471: l_msg := fnd_message.get;
3472: wip_logger.log(p_msg => l_msg,
3473: x_returnStatus => l_returnStatus);
3474: END IF;

Line 3471: l_msg := fnd_message.get;

3467: IF (l_logLevel <= wip_constants.full_logging) THEN
3468: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3469: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3470: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3471: l_msg := fnd_message.get;
3472: wip_logger.log(p_msg => l_msg,
3473: x_returnStatus => l_returnStatus);
3474: END IF;
3475:

Line 3688: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

3684: wmti.transaction_id;
3685:
3686: -- IF debug message level = 2, write statement below to log file
3687: IF (l_logLevel <= wip_constants.full_logging) THEN
3688: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3689: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3690: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3691: l_msg := fnd_message.get;
3692: wip_logger.log(p_msg => l_msg,

Line 3689: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

3685:
3686: -- IF debug message level = 2, write statement below to log file
3687: IF (l_logLevel <= wip_constants.full_logging) THEN
3688: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3689: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3690: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3691: l_msg := fnd_message.get;
3692: wip_logger.log(p_msg => l_msg,
3693: x_returnStatus => l_returnStatus);

Line 3690: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');

3686: -- IF debug message level = 2, write statement below to log file
3687: IF (l_logLevel <= wip_constants.full_logging) THEN
3688: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3689: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3690: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3691: l_msg := fnd_message.get;
3692: wip_logger.log(p_msg => l_msg,
3693: x_returnStatus => l_returnStatus);
3694: END IF;

Line 3691: l_msg := fnd_message.get;

3687: IF (l_logLevel <= wip_constants.full_logging) THEN
3688: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3689: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3690: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3691: l_msg := fnd_message.get;
3692: wip_logger.log(p_msg => l_msg,
3693: x_returnStatus => l_returnStatus);
3694: END IF;
3695:

Line 3942: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

3938: -1, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0));
3939:
3940: -- IF debug message level = 2, write statement below to log file
3941: IF (l_logLevel <= wip_constants.full_logging) THEN
3942: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3943: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3944: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3945: l_msg := fnd_message.get;
3946: wip_logger.log(p_msg => l_msg,

Line 3943: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

3939:
3940: -- IF debug message level = 2, write statement below to log file
3941: IF (l_logLevel <= wip_constants.full_logging) THEN
3942: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3943: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3944: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3945: l_msg := fnd_message.get;
3946: wip_logger.log(p_msg => l_msg,
3947: x_returnStatus => l_returnStatus);

Line 3944: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');

3940: -- IF debug message level = 2, write statement below to log file
3941: IF (l_logLevel <= wip_constants.full_logging) THEN
3942: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3943: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3944: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3945: l_msg := fnd_message.get;
3946: wip_logger.log(p_msg => l_msg,
3947: x_returnStatus => l_returnStatus);
3948: END IF;

Line 3945: l_msg := fnd_message.get;

3941: IF (l_logLevel <= wip_constants.full_logging) THEN
3942: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
3943: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
3944: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
3945: l_msg := fnd_message.get;
3946: wip_logger.log(p_msg => l_msg,
3947: x_returnStatus => l_returnStatus);
3948: END IF;
3949:

Line 4158: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

4154: -1, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0));
4155:
4156: -- IF debug message level = 2, write statement below to log file
4157: IF (l_logLevel <= wip_constants.full_logging) THEN
4158: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4159: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4160: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4161: l_msg := fnd_message.get;
4162: wip_logger.log(p_msg => l_msg,

Line 4159: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

4155:
4156: -- IF debug message level = 2, write statement below to log file
4157: IF (l_logLevel <= wip_constants.full_logging) THEN
4158: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4159: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4160: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4161: l_msg := fnd_message.get;
4162: wip_logger.log(p_msg => l_msg,
4163: x_returnStatus => l_returnStatus);

Line 4160: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');

4156: -- IF debug message level = 2, write statement below to log file
4157: IF (l_logLevel <= wip_constants.full_logging) THEN
4158: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4159: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4160: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4161: l_msg := fnd_message.get;
4162: wip_logger.log(p_msg => l_msg,
4163: x_returnStatus => l_returnStatus);
4164: END IF;

Line 4161: l_msg := fnd_message.get;

4157: IF (l_logLevel <= wip_constants.full_logging) THEN
4158: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4159: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4160: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4161: l_msg := fnd_message.get;
4162: wip_logger.log(p_msg => l_msg,
4163: x_returnStatus => l_returnStatus);
4164: END IF;
4165:

Line 4183: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');

4179: AND transaction_type = WIP_CONSTANTS.RES_TXN;
4180:
4181: -- IF debug message level = 2, write statement below to log file
4182: IF (l_logLevel <= wip_constants.full_logging) THEN
4183: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
4184: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4185: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4186: l_msg := fnd_message.get;
4187: wip_logger.log(p_msg => l_msg,

Line 4184: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

4180:
4181: -- IF debug message level = 2, write statement below to log file
4182: IF (l_logLevel <= wip_constants.full_logging) THEN
4183: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
4184: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4185: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4186: l_msg := fnd_message.get;
4187: wip_logger.log(p_msg => l_msg,
4188: x_returnStatus => l_returnStatus);

Line 4185: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');

4181: -- IF debug message level = 2, write statement below to log file
4182: IF (l_logLevel <= wip_constants.full_logging) THEN
4183: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
4184: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4185: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4186: l_msg := fnd_message.get;
4187: wip_logger.log(p_msg => l_msg,
4188: x_returnStatus => l_returnStatus);
4189: END IF;

Line 4186: l_msg := fnd_message.get;

4182: IF (l_logLevel <= wip_constants.full_logging) THEN
4183: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
4184: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4185: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4186: l_msg := fnd_message.get;
4187: wip_logger.log(p_msg => l_msg,
4188: x_returnStatus => l_returnStatus);
4189: END IF;
4190:

Line 4317: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

4313: wma.repetitive_schedule_id;
4314:
4315: -- IF debug message level = 2, write statement below to log file
4316: IF (l_logLevel <= wip_constants.full_logging) THEN
4317: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4318: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4319: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4320: l_msg := fnd_message.get;
4321: wip_logger.log(p_msg => l_msg,

Line 4318: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

4314:
4315: -- IF debug message level = 2, write statement below to log file
4316: IF (l_logLevel <= wip_constants.full_logging) THEN
4317: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4318: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4319: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4320: l_msg := fnd_message.get;
4321: wip_logger.log(p_msg => l_msg,
4322: x_returnStatus => l_returnStatus);

Line 4319: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');

4315: -- IF debug message level = 2, write statement below to log file
4316: IF (l_logLevel <= wip_constants.full_logging) THEN
4317: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4318: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4319: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4320: l_msg := fnd_message.get;
4321: wip_logger.log(p_msg => l_msg,
4322: x_returnStatus => l_returnStatus);
4323: END IF;

Line 4320: l_msg := fnd_message.get;

4316: IF (l_logLevel <= wip_constants.full_logging) THEN
4317: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4318: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4319: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4320: l_msg := fnd_message.get;
4321: wip_logger.log(p_msg => l_msg,
4322: x_returnStatus => l_returnStatus);
4323: END IF;
4324:

Line 4348: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

4344: p_procReturnStatus => x_returnStatus,
4345: p_msg => l_errMsg,
4346: x_returnStatus => l_returnStatus);
4347: END IF;
4348: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
4349: fnd_message.set_token('MESSAGE', l_errMsg);
4350: fnd_msg_pub.add;
4351: END insert_auto_resource;
4352:

Line 4349: fnd_message.set_token('MESSAGE', l_errMsg);

4345: p_msg => l_errMsg,
4346: x_returnStatus => l_returnStatus);
4347: END IF;
4348: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
4349: fnd_message.set_token('MESSAGE', l_errMsg);
4350: fnd_msg_pub.add;
4351: END insert_auto_resource;
4352:
4353: /*****************************************************************************

Line 4459: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

4455: AND wor.usage_rate_or_amount = wcti.usage_rate_or_amount;
4456:
4457: -- IF debug message level = 2, write statement below to log file
4458: IF (l_logLevel <= wip_constants.full_logging) THEN
4459: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4460: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4461: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4462: l_msg := fnd_message.get;
4463: wip_logger.log(p_msg => l_msg,

Line 4460: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

4456:
4457: -- IF debug message level = 2, write statement below to log file
4458: IF (l_logLevel <= wip_constants.full_logging) THEN
4459: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4460: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4461: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4462: l_msg := fnd_message.get;
4463: wip_logger.log(p_msg => l_msg,
4464: x_returnStatus => l_returnStatus);

Line 4461: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');

4457: -- IF debug message level = 2, write statement below to log file
4458: IF (l_logLevel <= wip_constants.full_logging) THEN
4459: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4460: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4461: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4462: l_msg := fnd_message.get;
4463: wip_logger.log(p_msg => l_msg,
4464: x_returnStatus => l_returnStatus);
4465: END IF;

Line 4462: l_msg := fnd_message.get;

4458: IF (l_logLevel <= wip_constants.full_logging) THEN
4459: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4460: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4461: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
4462: l_msg := fnd_message.get;
4463: wip_logger.log(p_msg => l_msg,
4464: x_returnStatus => l_returnStatus);
4465: END IF;
4466:

Line 4488: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

4484: p_procReturnStatus => x_returnStatus,
4485: p_msg => l_errMsg,
4486: x_returnStatus => l_returnStatus);
4487: END IF;
4488: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
4489: fnd_message.set_token('MESSAGE', l_errMsg);
4490: fnd_msg_pub.add;
4491: END insert_txn_alloc;
4492:

Line 4489: fnd_message.set_token('MESSAGE', l_errMsg);

4485: p_msg => l_errMsg,
4486: x_returnStatus => l_returnStatus);
4487: END IF;
4488: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
4489: fnd_message.set_token('MESSAGE', l_errMsg);
4490: fnd_msg_pub.add;
4491: END insert_txn_alloc;
4492:
4493: /*****************************************************************************

Line 4770: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

4766: wmti.transaction_id; /* 2821017 */
4767:
4768: -- IF debug message level = 2, write statement below to log file
4769: IF (l_logLevel <= wip_constants.full_logging) THEN
4770: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4771: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4772: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4773: l_msg := fnd_message.get;
4774: wip_logger.log(p_msg => l_msg,

Line 4771: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

4767:
4768: -- IF debug message level = 2, write statement below to log file
4769: IF (l_logLevel <= wip_constants.full_logging) THEN
4770: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4771: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4772: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4773: l_msg := fnd_message.get;
4774: wip_logger.log(p_msg => l_msg,
4775: x_returnStatus => l_returnStatus);

Line 4772: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');

4768: -- IF debug message level = 2, write statement below to log file
4769: IF (l_logLevel <= wip_constants.full_logging) THEN
4770: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4771: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4772: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4773: l_msg := fnd_message.get;
4774: wip_logger.log(p_msg => l_msg,
4775: x_returnStatus => l_returnStatus);
4776: END IF;

Line 4773: l_msg := fnd_message.get;

4769: IF (l_logLevel <= wip_constants.full_logging) THEN
4770: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4771: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4772: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4773: l_msg := fnd_message.get;
4774: wip_logger.log(p_msg => l_msg,
4775: x_returnStatus => l_returnStatus);
4776: END IF;
4777:

Line 4980: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

4976: wor.phantom_op_seq_num;
4977:
4978: -- IF debug message level = 2, write statement below to log file
4979: IF (l_logLevel <= wip_constants.full_logging) THEN
4980: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4981: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4982: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4983: l_msg := fnd_message.get;
4984: wip_logger.log(p_msg => l_msg,

Line 4981: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

4977:
4978: -- IF debug message level = 2, write statement below to log file
4979: IF (l_logLevel <= wip_constants.full_logging) THEN
4980: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4981: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4982: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4983: l_msg := fnd_message.get;
4984: wip_logger.log(p_msg => l_msg,
4985: x_returnStatus => l_returnStatus);

Line 4982: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');

4978: -- IF debug message level = 2, write statement below to log file
4979: IF (l_logLevel <= wip_constants.full_logging) THEN
4980: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4981: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4982: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4983: l_msg := fnd_message.get;
4984: wip_logger.log(p_msg => l_msg,
4985: x_returnStatus => l_returnStatus);
4986: END IF;

Line 4983: l_msg := fnd_message.get;

4979: IF (l_logLevel <= wip_constants.full_logging) THEN
4980: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
4981: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
4982: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
4983: l_msg := fnd_message.get;
4984: wip_logger.log(p_msg => l_msg,
4985: x_returnStatus => l_returnStatus);
4986: END IF;
4987:

Line 5244: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

5240: -1, DECODE(sign(MAX(wop.quantity_completed)),1,-1,0));
5241:
5242: -- IF debug message level = 2, write statement below to log file
5243: IF (l_logLevel <= wip_constants.full_logging) THEN
5244: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5245: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5246: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5247: l_msg := fnd_message.get;
5248: wip_logger.log(p_msg => l_msg,

Line 5245: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

5241:
5242: -- IF debug message level = 2, write statement below to log file
5243: IF (l_logLevel <= wip_constants.full_logging) THEN
5244: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5245: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5246: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5247: l_msg := fnd_message.get;
5248: wip_logger.log(p_msg => l_msg,
5249: x_returnStatus => l_returnStatus);

Line 5246: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');

5242: -- IF debug message level = 2, write statement below to log file
5243: IF (l_logLevel <= wip_constants.full_logging) THEN
5244: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5245: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5246: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5247: l_msg := fnd_message.get;
5248: wip_logger.log(p_msg => l_msg,
5249: x_returnStatus => l_returnStatus);
5250: END IF;

Line 5247: l_msg := fnd_message.get;

5243: IF (l_logLevel <= wip_constants.full_logging) THEN
5244: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5245: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5246: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5247: l_msg := fnd_message.get;
5248: wip_logger.log(p_msg => l_msg,
5249: x_returnStatus => l_returnStatus);
5250: END IF;
5251:

Line 5450: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

5446: -1, DECODE(sign(MAX(wop.quantity_completed)),1,-1,0));
5447:
5448: -- IF debug message level = 2, write statement below to log file
5449: IF (l_logLevel <= wip_constants.full_logging) THEN
5450: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5451: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5452: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5453: l_msg := fnd_message.get;
5454: wip_logger.log(p_msg => l_msg,

Line 5451: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

5447:
5448: -- IF debug message level = 2, write statement below to log file
5449: IF (l_logLevel <= wip_constants.full_logging) THEN
5450: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5451: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5452: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5453: l_msg := fnd_message.get;
5454: wip_logger.log(p_msg => l_msg,
5455: x_returnStatus => l_returnStatus);

Line 5452: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');

5448: -- IF debug message level = 2, write statement below to log file
5449: IF (l_logLevel <= wip_constants.full_logging) THEN
5450: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5451: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5452: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5453: l_msg := fnd_message.get;
5454: wip_logger.log(p_msg => l_msg,
5455: x_returnStatus => l_returnStatus);
5456: END IF;

Line 5453: l_msg := fnd_message.get;

5449: IF (l_logLevel <= wip_constants.full_logging) THEN
5450: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5451: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5452: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5453: l_msg := fnd_message.get;
5454: wip_logger.log(p_msg => l_msg,
5455: x_returnStatus => l_returnStatus);
5456: END IF;
5457:

Line 5472: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');

5468: AND transaction_type = WIP_CONSTANTS.OVHD_TXN;
5469:
5470: -- IF debug message level = 2, write statement below to log file
5471: IF (l_logLevel <= wip_constants.full_logging) THEN
5472: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5473: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5474: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5475: l_msg := fnd_message.get;
5476: wip_logger.log(p_msg => l_msg,

Line 5473: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

5469:
5470: -- IF debug message level = 2, write statement below to log file
5471: IF (l_logLevel <= wip_constants.full_logging) THEN
5472: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5473: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5474: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5475: l_msg := fnd_message.get;
5476: wip_logger.log(p_msg => l_msg,
5477: x_returnStatus => l_returnStatus);

Line 5474: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');

5470: -- IF debug message level = 2, write statement below to log file
5471: IF (l_logLevel <= wip_constants.full_logging) THEN
5472: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5473: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5474: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5475: l_msg := fnd_message.get;
5476: wip_logger.log(p_msg => l_msg,
5477: x_returnStatus => l_returnStatus);
5478: END IF;

Line 5475: l_msg := fnd_message.get;

5471: IF (l_logLevel <= wip_constants.full_logging) THEN
5472: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5473: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5474: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5475: l_msg := fnd_message.get;
5476: wip_logger.log(p_msg => l_msg,
5477: x_returnStatus => l_returnStatus);
5478: END IF;
5479:

Line 5588: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

5584: wma.repetitive_schedule_id;
5585:
5586: -- IF debug message level = 2, write statement below to log file
5587: IF (l_logLevel <= wip_constants.full_logging) THEN
5588: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5589: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5590: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
5591: l_msg := fnd_message.get;
5592: wip_logger.log(p_msg => l_msg,

Line 5589: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

5585:
5586: -- IF debug message level = 2, write statement below to log file
5587: IF (l_logLevel <= wip_constants.full_logging) THEN
5588: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5589: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5590: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
5591: l_msg := fnd_message.get;
5592: wip_logger.log(p_msg => l_msg,
5593: x_returnStatus => l_returnStatus);

Line 5590: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');

5586: -- IF debug message level = 2, write statement below to log file
5587: IF (l_logLevel <= wip_constants.full_logging) THEN
5588: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5589: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5590: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
5591: l_msg := fnd_message.get;
5592: wip_logger.log(p_msg => l_msg,
5593: x_returnStatus => l_returnStatus);
5594: END IF;

Line 5591: l_msg := fnd_message.get;

5587: IF (l_logLevel <= wip_constants.full_logging) THEN
5588: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
5589: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5590: fnd_message.set_token('ENTITY2', 'WIP_TXN_ALLOCATIONS');
5591: l_msg := fnd_message.get;
5592: wip_logger.log(p_msg => l_msg,
5593: x_returnStatus => l_returnStatus);
5594: END IF;
5595:

Line 5619: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

5615: p_procReturnStatus => x_returnStatus,
5616: p_msg => l_errMsg,
5617: x_returnStatus => l_returnStatus);
5618: END IF;
5619: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
5620: fnd_message.set_token('MESSAGE', l_errMsg);
5621: fnd_msg_pub.add;
5622: END insert_dept_overhead;
5623:

Line 5620: fnd_message.set_token('MESSAGE', l_errMsg);

5616: p_msg => l_errMsg,
5617: x_returnStatus => l_returnStatus);
5618: END IF;
5619: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
5620: fnd_message.set_token('MESSAGE', l_errMsg);
5621: fnd_msg_pub.add;
5622: END insert_dept_overhead;
5623:
5624: /*****************************************************************************

Line 5657: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');

5653: AND TRUNC(transaction_date) = TRUNC(p_gib.txn_date);
5654:
5655: -- IF debug message level = 2, write statement below to log file
5656: IF (l_logLevel <= wip_constants.full_logging) THEN
5657: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5658: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5659: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5660: l_msg := fnd_message.get;
5661: wip_logger.log(p_msg => l_msg,

Line 5658: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

5654:
5655: -- IF debug message level = 2, write statement below to log file
5656: IF (l_logLevel <= wip_constants.full_logging) THEN
5657: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5658: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5659: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5660: l_msg := fnd_message.get;
5661: wip_logger.log(p_msg => l_msg,
5662: x_returnStatus => l_returnStatus);

Line 5659: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');

5655: -- IF debug message level = 2, write statement below to log file
5656: IF (l_logLevel <= wip_constants.full_logging) THEN
5657: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5658: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5659: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5660: l_msg := fnd_message.get;
5661: wip_logger.log(p_msg => l_msg,
5662: x_returnStatus => l_returnStatus);
5663: END IF;

Line 5660: l_msg := fnd_message.get;

5656: IF (l_logLevel <= wip_constants.full_logging) THEN
5657: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
5658: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
5659: fnd_message.set_token('ENTITY2', 'WIP_COST_TXN_INTERFACE');
5660: l_msg := fnd_message.get;
5661: wip_logger.log(p_msg => l_msg,
5662: x_returnStatus => l_returnStatus);
5663: END IF;
5664:

Line 5686: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

5682: p_procReturnStatus => x_returnStatus,
5683: p_msg => l_errMsg,
5684: x_returnStatus => l_returnStatus);
5685: END IF;
5686: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
5687: fnd_message.set_token('MESSAGE', l_errMsg);
5688: fnd_msg_pub.add;
5689: END release_cost_txn;
5690:

Line 5687: fnd_message.set_token('MESSAGE', l_errMsg);

5683: p_msg => l_errMsg,
5684: x_returnStatus => l_returnStatus);
5685: END IF;
5686: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
5687: fnd_message.set_token('MESSAGE', l_errMsg);
5688: fnd_msg_pub.add;
5689: END release_cost_txn;
5690:
5691: /*****************************************************************************

Line 6024: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

6020: AND bcd3.seq_num = (bcd4.next_seq_num -
6021: CEIL(NVL(msi.postprocessing_lead_time,0)));
6022: -- IF debug message level = 2, write statement below to log file
6023: IF (l_logLevel <= wip_constants.full_logging) THEN
6024: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6025: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6026: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6027: l_msg := fnd_message.get;
6028: wip_logger.log(p_msg => l_msg,

Line 6025: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

6021: CEIL(NVL(msi.postprocessing_lead_time,0)));
6022: -- IF debug message level = 2, write statement below to log file
6023: IF (l_logLevel <= wip_constants.full_logging) THEN
6024: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6025: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6026: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6027: l_msg := fnd_message.get;
6028: wip_logger.log(p_msg => l_msg,
6029: x_returnStatus => l_returnStatus);

Line 6026: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');

6022: -- IF debug message level = 2, write statement below to log file
6023: IF (l_logLevel <= wip_constants.full_logging) THEN
6024: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6025: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6026: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6027: l_msg := fnd_message.get;
6028: wip_logger.log(p_msg => l_msg,
6029: x_returnStatus => l_returnStatus);
6030: END IF;

Line 6027: l_msg := fnd_message.get;

6023: IF (l_logLevel <= wip_constants.full_logging) THEN
6024: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6025: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6026: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6027: l_msg := fnd_message.get;
6028: wip_logger.log(p_msg => l_msg,
6029: x_returnStatus => l_returnStatus);
6030: END IF;
6031:

Line 6217: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

6213: CEIL(NVL(msi.postprocessing_lead_time,0)));
6214:
6215: -- IF debug message level = 2, write statement below to log file
6216: IF (l_logLevel <= wip_constants.full_logging) THEN
6217: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6218: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6219: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6220: l_msg := fnd_message.get;
6221: wip_logger.log(p_msg => l_msg,

Line 6218: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

6214:
6215: -- IF debug message level = 2, write statement below to log file
6216: IF (l_logLevel <= wip_constants.full_logging) THEN
6217: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6218: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6219: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6220: l_msg := fnd_message.get;
6221: wip_logger.log(p_msg => l_msg,
6222: x_returnStatus => l_returnStatus);

Line 6219: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');

6215: -- IF debug message level = 2, write statement below to log file
6216: IF (l_logLevel <= wip_constants.full_logging) THEN
6217: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6218: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6219: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6220: l_msg := fnd_message.get;
6221: wip_logger.log(p_msg => l_msg,
6222: x_returnStatus => l_returnStatus);
6223: END IF;

Line 6220: l_msg := fnd_message.get;

6216: IF (l_logLevel <= wip_constants.full_logging) THEN
6217: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6218: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6219: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6220: l_msg := fnd_message.get;
6221: wip_logger.log(p_msg => l_msg,
6222: x_returnStatus => l_returnStatus);
6223: END IF;
6224:

Line 6452: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

6448: 1, 0);
6449:
6450: -- IF debug message level = 2, write statement below to log file
6451: IF (l_logLevel <= wip_constants.full_logging) THEN
6452: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6453: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6454: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6455: l_msg := fnd_message.get;
6456: wip_logger.log(p_msg => l_msg,

Line 6453: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

6449:
6450: -- IF debug message level = 2, write statement below to log file
6451: IF (l_logLevel <= wip_constants.full_logging) THEN
6452: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6453: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6454: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6455: l_msg := fnd_message.get;
6456: wip_logger.log(p_msg => l_msg,
6457: x_returnStatus => l_returnStatus);

Line 6454: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');

6450: -- IF debug message level = 2, write statement below to log file
6451: IF (l_logLevel <= wip_constants.full_logging) THEN
6452: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6453: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6454: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6455: l_msg := fnd_message.get;
6456: wip_logger.log(p_msg => l_msg,
6457: x_returnStatus => l_returnStatus);
6458: END IF;

Line 6455: l_msg := fnd_message.get;

6451: IF (l_logLevel <= wip_constants.full_logging) THEN
6452: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6453: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6454: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6455: l_msg := fnd_message.get;
6456: wip_logger.log(p_msg => l_msg,
6457: x_returnStatus => l_returnStatus);
6458: END IF;
6459:

Line 6673: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

6669: 1, 0);
6670:
6671: -- IF debug message level = 2, write statement below to log file
6672: IF (l_logLevel <= wip_constants.full_logging) THEN
6673: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6674: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6675: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6676: l_msg := fnd_message.get;
6677: wip_logger.log(p_msg => l_msg,

Line 6674: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

6670:
6671: -- IF debug message level = 2, write statement below to log file
6672: IF (l_logLevel <= wip_constants.full_logging) THEN
6673: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6674: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6675: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6676: l_msg := fnd_message.get;
6677: wip_logger.log(p_msg => l_msg,
6678: x_returnStatus => l_returnStatus);

Line 6675: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');

6671: -- IF debug message level = 2, write statement below to log file
6672: IF (l_logLevel <= wip_constants.full_logging) THEN
6673: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6674: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6675: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6676: l_msg := fnd_message.get;
6677: wip_logger.log(p_msg => l_msg,
6678: x_returnStatus => l_returnStatus);
6679: END IF;

Line 6676: l_msg := fnd_message.get;

6672: IF (l_logLevel <= wip_constants.full_logging) THEN
6673: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6674: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6675: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6676: l_msg := fnd_message.get;
6677: wip_logger.log(p_msg => l_msg,
6678: x_returnStatus => l_returnStatus);
6679: END IF;
6680: END IF; -- po requisition per lot for schedule

Line 6728: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

6724: p_procReturnStatus => x_returnStatus,
6725: p_msg => l_errMsg,
6726: x_returnStatus => l_returnStatus);
6727: END IF;
6728: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
6729: fnd_message.set_token('MESSAGE', l_errMsg);
6730: fnd_msg_pub.add;
6731: END insert_po_req;
6732:

Line 6729: fnd_message.set_token('MESSAGE', l_errMsg);

6725: p_msg => l_errMsg,
6726: x_returnStatus => l_returnStatus);
6727: END IF;
6728: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
6729: fnd_message.set_token('MESSAGE', l_errMsg);
6730: fnd_msg_pub.add;
6731: END insert_po_req;
6732:
6733: /*****************************************************************************

Line 6924: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

6920: p_procReturnStatus => x_returnStatus,
6921: p_msg => l_errMsg,
6922: x_returnStatus => l_returnStatus);
6923: END IF;
6924: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
6925: fnd_message.set_token('MESSAGE', l_errMsg);
6926: fnd_msg_pub.add;
6927: END start_workflow;
6928:

Line 6925: fnd_message.set_token('MESSAGE', l_errMsg);

6921: p_msg => l_errMsg,
6922: x_returnStatus => l_returnStatus);
6923: END IF;
6924: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
6925: fnd_message.set_token('MESSAGE', l_errMsg);
6926: fnd_msg_pub.add;
6927: END start_workflow;
6928:
6929: /*****************************************************************************

Line 7105: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');

7101: ));
7102:
7103: -- IF debug message level = 2, write statement below to log file
7104: IF (l_logLevel <= wip_constants.full_logging) THEN
7105: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
7106: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
7107: fnd_message.set_token('ENTITY2', 'WIP_OPERATIONS');
7108: l_msg := fnd_message.get;
7109: wip_logger.log(p_msg => l_msg,

Line 7106: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

7102:
7103: -- IF debug message level = 2, write statement below to log file
7104: IF (l_logLevel <= wip_constants.full_logging) THEN
7105: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
7106: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
7107: fnd_message.set_token('ENTITY2', 'WIP_OPERATIONS');
7108: l_msg := fnd_message.get;
7109: wip_logger.log(p_msg => l_msg,
7110: x_returnStatus => l_returnStatus);

Line 7107: fnd_message.set_token('ENTITY2', 'WIP_OPERATIONS');

7103: -- IF debug message level = 2, write statement below to log file
7104: IF (l_logLevel <= wip_constants.full_logging) THEN
7105: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
7106: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
7107: fnd_message.set_token('ENTITY2', 'WIP_OPERATIONS');
7108: l_msg := fnd_message.get;
7109: wip_logger.log(p_msg => l_msg,
7110: x_returnStatus => l_returnStatus);
7111: END IF;

Line 7108: l_msg := fnd_message.get;

7104: IF (l_logLevel <= wip_constants.full_logging) THEN
7105: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
7106: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
7107: fnd_message.set_token('ENTITY2', 'WIP_OPERATIONS');
7108: l_msg := fnd_message.get;
7109: wip_logger.log(p_msg => l_msg,
7110: x_returnStatus => l_returnStatus);
7111: END IF;
7112:

Line 7134: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

7130: p_procReturnStatus => x_returnStatus,
7131: p_msg => l_errMsg,
7132: x_returnStatus => l_returnStatus);
7133: END IF;
7134: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7135: fnd_message.set_token('MESSAGE', l_errMsg);
7136: fnd_msg_pub.add;
7137: END update_complete_qty;
7138:

Line 7135: fnd_message.set_token('MESSAGE', l_errMsg);

7131: p_msg => l_errMsg,
7132: x_returnStatus => l_returnStatus);
7133: END IF;
7134: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7135: fnd_message.set_token('MESSAGE', l_errMsg);
7136: fnd_msg_pub.add;
7137: END update_complete_qty;
7138:
7139: /*****************************************************************************

Line 7195: fnd_message.set_name('CST', l_errCode);

7191: p_msg => l_errMsg,
7192: x_returnStatus => l_returnStatus);
7193: END IF;
7194:
7195: fnd_message.set_name('CST', l_errCode);
7196: fnd_msg_pub.add;
7197:
7198: WHEN others THEN
7199: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

Line 7208: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

7204: p_procReturnStatus => x_returnStatus,
7205: p_msg => l_errMsg,
7206: x_returnStatus => l_returnStatus);
7207: END IF;
7208: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7209: fnd_message.set_token('MESSAGE', l_errMsg);
7210: fnd_msg_pub.add;
7211: END op_snapshot;
7212:

Line 7209: fnd_message.set_token('MESSAGE', l_errMsg);

7205: p_msg => l_errMsg,
7206: x_returnStatus => l_returnStatus);
7207: END IF;
7208: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7209: fnd_message.set_token('MESSAGE', l_errMsg);
7210: fnd_msg_pub.add;
7211: END op_snapshot;
7212:
7213: /*****************************************************************************

Line 7336: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

7332: p_procReturnStatus => x_returnStatus,
7333: p_msg => l_errMsg,
7334: x_returnStatus => l_returnStatus);
7335: END IF;
7336: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7337: fnd_message.set_token('MESSAGE', l_errMsg);
7338: fnd_msg_pub.add;
7339: END snapshot_online;
7340:

Line 7337: fnd_message.set_token('MESSAGE', l_errMsg);

7333: p_msg => l_errMsg,
7334: x_returnStatus => l_returnStatus);
7335: END IF;
7336: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7337: fnd_message.set_token('MESSAGE', l_errMsg);
7338: fnd_msg_pub.add;
7339: END snapshot_online;
7340:
7341: /*****************************************************************************

Line 7504: fnd_message.set_name('CST', l_errCode);

7500: err_code => l_errCode,
7501: err_msg => l_errMsg);
7502:
7503: IF(l_returnValue <> 1) THEN
7504: fnd_message.set_name('CST', l_errCode);
7505: fnd_msg_pub.add;
7506: l_errMsg := 'CSTACOSN.validate_move_snap_to_temp failed';
7507: raise fnd_api.g_exc_unexpected_error;
7508: END IF; -- check return status

Line 7552: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

7548: p_procReturnStatus => x_returnStatus,
7549: p_msg => l_errMsg,
7550: x_returnStatus => l_returnStatus);
7551: END IF;
7552: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7553: fnd_message.set_token('MESSAGE', l_errMsg);
7554: fnd_msg_pub.add;
7555: END snapshot_background;
7556:

Line 7553: fnd_message.set_token('MESSAGE', l_errMsg);

7549: p_msg => l_errMsg,
7550: x_returnStatus => l_returnStatus);
7551: END IF;
7552: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7553: fnd_message.set_token('MESSAGE', l_errMsg);
7554: fnd_msg_pub.add;
7555: END snapshot_background;
7556:
7557: /*****************************************************************************

Line 7660: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

7656: p_procReturnStatus => x_returnStatus,
7657: p_msg => l_errMsg,
7658: x_returnStatus => l_returnStatus);
7659: END IF;
7660: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7661: fnd_message.set_token('MESSAGE', l_errMsg);
7662: fnd_msg_pub.add;
7663: END update_wo_and_snapshot;
7664:

Line 7661: fnd_message.set_token('MESSAGE', l_errMsg);

7657: p_msg => l_errMsg,
7658: x_returnStatus => l_returnStatus);
7659: END IF;
7660: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
7661: fnd_message.set_token('MESSAGE', l_errMsg);
7662: fnd_msg_pub.add;
7663: END update_wo_and_snapshot;
7664:
7665: /*****************************************************************************

Line 7953: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');

7949: wdj2.quantity_scrapped) > 0);
7950:
7951: -- IF debug message level = 2, write statement below to log file
7952: IF (l_logLevel <= wip_constants.full_logging) THEN
7953: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
7954: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
7955: fnd_message.set_token('ENTITY2', 'WIP_DISCRETE_JOBS');
7956: l_msg := fnd_message.get;
7957: wip_logger.log(p_msg => l_msg,

Line 7954: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

7950:
7951: -- IF debug message level = 2, write statement below to log file
7952: IF (l_logLevel <= wip_constants.full_logging) THEN
7953: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
7954: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
7955: fnd_message.set_token('ENTITY2', 'WIP_DISCRETE_JOBS');
7956: l_msg := fnd_message.get;
7957: wip_logger.log(p_msg => l_msg,
7958: x_returnStatus => l_returnStatus);

Line 7955: fnd_message.set_token('ENTITY2', 'WIP_DISCRETE_JOBS');

7951: -- IF debug message level = 2, write statement below to log file
7952: IF (l_logLevel <= wip_constants.full_logging) THEN
7953: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
7954: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
7955: fnd_message.set_token('ENTITY2', 'WIP_DISCRETE_JOBS');
7956: l_msg := fnd_message.get;
7957: wip_logger.log(p_msg => l_msg,
7958: x_returnStatus => l_returnStatus);
7959: END IF;

Line 7956: l_msg := fnd_message.get;

7952: IF (l_logLevel <= wip_constants.full_logging) THEN
7953: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
7954: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
7955: fnd_message.set_token('ENTITY2', 'WIP_DISCRETE_JOBS');
7956: l_msg := fnd_message.get;
7957: wip_logger.log(p_msg => l_msg,
7958: x_returnStatus => l_returnStatus);
7959: END IF;
7960: END IF; -- END job transactions

Line 8001: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');

7997: OR wmti.to_intraoperation_step_type = WIP_CONSTANTS.SCRAP));
7998:
7999: -- IF debug message level = 2, write statement below to log file
8000: IF (l_logLevel <= wip_constants.full_logging) THEN
8001: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8002: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8003: fnd_message.set_token('ENTITY2', 'WIP_REPETITIVE_SCHEDULES');
8004: l_msg := fnd_message.get;
8005: wip_logger.log(p_msg => l_msg,

Line 8002: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

7998:
7999: -- IF debug message level = 2, write statement below to log file
8000: IF (l_logLevel <= wip_constants.full_logging) THEN
8001: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8002: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8003: fnd_message.set_token('ENTITY2', 'WIP_REPETITIVE_SCHEDULES');
8004: l_msg := fnd_message.get;
8005: wip_logger.log(p_msg => l_msg,
8006: x_returnStatus => l_returnStatus);

Line 8003: fnd_message.set_token('ENTITY2', 'WIP_REPETITIVE_SCHEDULES');

7999: -- IF debug message level = 2, write statement below to log file
8000: IF (l_logLevel <= wip_constants.full_logging) THEN
8001: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8002: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8003: fnd_message.set_token('ENTITY2', 'WIP_REPETITIVE_SCHEDULES');
8004: l_msg := fnd_message.get;
8005: wip_logger.log(p_msg => l_msg,
8006: x_returnStatus => l_returnStatus);
8007: END IF;

Line 8004: l_msg := fnd_message.get;

8000: IF (l_logLevel <= wip_constants.full_logging) THEN
8001: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8002: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8003: fnd_message.set_token('ENTITY2', 'WIP_REPETITIVE_SCHEDULES');
8004: l_msg := fnd_message.get;
8005: wip_logger.log(p_msg => l_msg,
8006: x_returnStatus => l_returnStatus);
8007: END IF;
8008: END IF; -- END repetitive schedule transactions

Line 8155: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

8151: AND msi.inventory_item_id = wmti.primary_item_id;
8152:
8153: -- IF debug message level = 2, write statement below to log file
8154: IF (l_logLevel <= wip_constants.full_logging) THEN
8155: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8156: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8157: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8158: l_msg := fnd_message.get;
8159: wip_logger.log(p_msg => l_msg,

Line 8156: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

8152:
8153: -- IF debug message level = 2, write statement below to log file
8154: IF (l_logLevel <= wip_constants.full_logging) THEN
8155: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8156: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8157: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8158: l_msg := fnd_message.get;
8159: wip_logger.log(p_msg => l_msg,
8160: x_returnStatus => l_returnStatus);

Line 8157: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');

8153: -- IF debug message level = 2, write statement below to log file
8154: IF (l_logLevel <= wip_constants.full_logging) THEN
8155: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8156: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8157: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8158: l_msg := fnd_message.get;
8159: wip_logger.log(p_msg => l_msg,
8160: x_returnStatus => l_returnStatus);
8161: END IF;

Line 8158: l_msg := fnd_message.get;

8154: IF (l_logLevel <= wip_constants.full_logging) THEN
8155: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8156: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8157: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8158: l_msg := fnd_message.get;
8159: wip_logger.log(p_msg => l_msg,
8160: x_returnStatus => l_returnStatus);
8161: END IF;
8162:

Line 8290: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

8286: AND msi.inventory_item_id = wmti.primary_item_id;
8287:
8288: -- IF debug message level = 2, write statement below to log file
8289: IF (l_logLevel <= wip_constants.full_logging) THEN
8290: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8291: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8292: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8293: l_msg := fnd_message.get;
8294: wip_logger.log(p_msg => l_msg,

Line 8291: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

8287:
8288: -- IF debug message level = 2, write statement below to log file
8289: IF (l_logLevel <= wip_constants.full_logging) THEN
8290: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8291: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8292: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8293: l_msg := fnd_message.get;
8294: wip_logger.log(p_msg => l_msg,
8295: x_returnStatus => l_returnStatus);

Line 8292: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');

8288: -- IF debug message level = 2, write statement below to log file
8289: IF (l_logLevel <= wip_constants.full_logging) THEN
8290: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8291: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8292: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8293: l_msg := fnd_message.get;
8294: wip_logger.log(p_msg => l_msg,
8295: x_returnStatus => l_returnStatus);
8296: END IF;

Line 8293: l_msg := fnd_message.get;

8289: IF (l_logLevel <= wip_constants.full_logging) THEN
8290: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8291: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8292: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TRANSACTIONS_TEMP');
8293: l_msg := fnd_message.get;
8294: wip_logger.log(p_msg => l_msg,
8295: x_returnStatus => l_returnStatus);
8296: END IF;
8297: END IF; -- Repetitive schedules

Line 8372: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

8368: p_procReturnStatus => x_returnStatus,
8369: p_msg => l_errMsg,
8370: x_returnStatus => l_returnStatus);
8371: END IF;
8372: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
8373: fnd_message.set_token('MESSAGE', l_errMsg);
8374: fnd_msg_pub.add;
8375: END scrap_txns;
8376:

Line 8373: fnd_message.set_token('MESSAGE', l_errMsg);

8369: p_msg => l_errMsg,
8370: x_returnStatus => l_returnStatus);
8371: END IF;
8372: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
8373: fnd_message.set_token('MESSAGE', l_errMsg);
8374: fnd_msg_pub.add;
8375: END scrap_txns;
8376:
8377: /*****************************************************************************

Line 8795: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

8791: END IF; -- Repetitive schedules
8792:
8793: -- IF debug message level = 2, write statement below to log file
8794: IF (l_logLevel <= wip_constants.full_logging) THEN
8795: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8796: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8797: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTIONS_INTERFACE');
8798: l_msg := fnd_message.get;
8799: wip_logger.log(p_msg => l_msg,

Line 8796: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

8792:
8793: -- IF debug message level = 2, write statement below to log file
8794: IF (l_logLevel <= wip_constants.full_logging) THEN
8795: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8796: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8797: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTIONS_INTERFACE');
8798: l_msg := fnd_message.get;
8799: wip_logger.log(p_msg => l_msg,
8800: x_returnStatus => l_returnStatus);

Line 8797: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTIONS_INTERFACE');

8793: -- IF debug message level = 2, write statement below to log file
8794: IF (l_logLevel <= wip_constants.full_logging) THEN
8795: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8796: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8797: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTIONS_INTERFACE');
8798: l_msg := fnd_message.get;
8799: wip_logger.log(p_msg => l_msg,
8800: x_returnStatus => l_returnStatus);
8801: END IF;

Line 8798: l_msg := fnd_message.get;

8794: IF (l_logLevel <= wip_constants.full_logging) THEN
8795: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8796: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8797: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTIONS_INTERFACE');
8798: l_msg := fnd_message.get;
8799: wip_logger.log(p_msg => l_msg,
8800: x_returnStatus => l_returnStatus);
8801: END IF;
8802:

Line 8894: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

8890: mti.transaction_interface_id);
8891:
8892: -- IF debug message level = 2, write statement below to log file
8893: IF (l_logLevel <= wip_constants.full_logging) THEN
8894: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8895: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8896: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
8897: l_msg := fnd_message.get;
8898: wip_logger.log(p_msg => l_msg,

Line 8895: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

8891:
8892: -- IF debug message level = 2, write statement below to log file
8893: IF (l_logLevel <= wip_constants.full_logging) THEN
8894: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8895: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8896: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
8897: l_msg := fnd_message.get;
8898: wip_logger.log(p_msg => l_msg,
8899: x_returnStatus => l_returnStatus);

Line 8896: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');

8892: -- IF debug message level = 2, write statement below to log file
8893: IF (l_logLevel <= wip_constants.full_logging) THEN
8894: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8895: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8896: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
8897: l_msg := fnd_message.get;
8898: wip_logger.log(p_msg => l_msg,
8899: x_returnStatus => l_returnStatus);
8900: END IF;

Line 8897: l_msg := fnd_message.get;

8893: IF (l_logLevel <= wip_constants.full_logging) THEN
8894: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
8895: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8896: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
8897: l_msg := fnd_message.get;
8898: wip_logger.log(p_msg => l_msg,
8899: x_returnStatus => l_returnStatus);
8900: END IF;
8901:

Line 8940: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');

8936: AND msi.lot_control_code = WIP_CONSTANTS.LOT);
8937:
8938: -- IF debug message level = 2, write statement below to log file
8939: IF (l_logLevel <= wip_constants.full_logging) THEN
8940: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8941: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8942: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
8943: l_msg := fnd_message.get;
8944: wip_logger.log(p_msg => l_msg,

Line 8941: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

8937:
8938: -- IF debug message level = 2, write statement below to log file
8939: IF (l_logLevel <= wip_constants.full_logging) THEN
8940: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8941: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8942: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
8943: l_msg := fnd_message.get;
8944: wip_logger.log(p_msg => l_msg,
8945: x_returnStatus => l_returnStatus);

Line 8942: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');

8938: -- IF debug message level = 2, write statement below to log file
8939: IF (l_logLevel <= wip_constants.full_logging) THEN
8940: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8941: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8942: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
8943: l_msg := fnd_message.get;
8944: wip_logger.log(p_msg => l_msg,
8945: x_returnStatus => l_returnStatus);
8946: END IF;

Line 8943: l_msg := fnd_message.get;

8939: IF (l_logLevel <= wip_constants.full_logging) THEN
8940: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8941: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8942: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
8943: l_msg := fnd_message.get;
8944: wip_logger.log(p_msg => l_msg,
8945: x_returnStatus => l_returnStatus);
8946: END IF;
8947:

Line 8986: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');

8982: AND msi.lot_control_code = WIP_CONSTANTS.LOT);
8983:
8984: -- IF debug message level = 2, write statement below to log file
8985: IF (l_logLevel <= wip_constants.full_logging) THEN
8986: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8987: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8988: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
8989: l_msg := fnd_message.get;
8990: wip_logger.log(p_msg => l_msg,

Line 8987: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

8983:
8984: -- IF debug message level = 2, write statement below to log file
8985: IF (l_logLevel <= wip_constants.full_logging) THEN
8986: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8987: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8988: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
8989: l_msg := fnd_message.get;
8990: wip_logger.log(p_msg => l_msg,
8991: x_returnStatus => l_returnStatus);

Line 8988: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');

8984: -- IF debug message level = 2, write statement below to log file
8985: IF (l_logLevel <= wip_constants.full_logging) THEN
8986: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8987: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8988: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
8989: l_msg := fnd_message.get;
8990: wip_logger.log(p_msg => l_msg,
8991: x_returnStatus => l_returnStatus);
8992: END IF;

Line 8989: l_msg := fnd_message.get;

8985: IF (l_logLevel <= wip_constants.full_logging) THEN
8986: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8987: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8988: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
8989: l_msg := fnd_message.get;
8990: wip_logger.log(p_msg => l_msg,
8991: x_returnStatus => l_returnStatus);
8992: END IF;
8993:

Line 9063: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

9059: AND mti.move_transaction_id = wsmi.transaction_id;
9060:
9061: -- IF debug message level = 2, write statement below to log file
9062: IF (l_logLevel <= wip_constants.full_logging) THEN
9063: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9064: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9065: fnd_message.set_token('ENTITY2', 'MTL_SERIAL_NUMBERS_INTERFACE');
9066: l_msg := fnd_message.get;
9067: wip_logger.log(p_msg => l_msg,

Line 9064: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

9060:
9061: -- IF debug message level = 2, write statement below to log file
9062: IF (l_logLevel <= wip_constants.full_logging) THEN
9063: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9064: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9065: fnd_message.set_token('ENTITY2', 'MTL_SERIAL_NUMBERS_INTERFACE');
9066: l_msg := fnd_message.get;
9067: wip_logger.log(p_msg => l_msg,
9068: x_returnStatus => l_returnStatus);

Line 9065: fnd_message.set_token('ENTITY2', 'MTL_SERIAL_NUMBERS_INTERFACE');

9061: -- IF debug message level = 2, write statement below to log file
9062: IF (l_logLevel <= wip_constants.full_logging) THEN
9063: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9064: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9065: fnd_message.set_token('ENTITY2', 'MTL_SERIAL_NUMBERS_INTERFACE');
9066: l_msg := fnd_message.get;
9067: wip_logger.log(p_msg => l_msg,
9068: x_returnStatus => l_returnStatus);
9069: END IF;

Line 9066: l_msg := fnd_message.get;

9062: IF (l_logLevel <= wip_constants.full_logging) THEN
9063: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
9064: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
9065: fnd_message.set_token('ENTITY2', 'MTL_SERIAL_NUMBERS_INTERFACE');
9066: l_msg := fnd_message.get;
9067: wip_logger.log(p_msg => l_msg,
9068: x_returnStatus => l_returnStatus);
9069: END IF;
9070: END IF; -- Discrete or OSFM jobs

Line 9173: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

9169: p_procReturnStatus => x_returnStatus,
9170: p_msg => l_errMsg,
9171: x_returnStatus => l_returnStatus);
9172: END IF;
9173: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9174: fnd_message.set_token('MESSAGE', l_errMsg);
9175: fnd_msg_pub.add;
9176: END ez_completion;
9177:

Line 9174: fnd_message.set_token('MESSAGE', l_errMsg);

9170: p_msg => l_errMsg,
9171: x_returnStatus => l_returnStatus);
9172: END IF;
9173: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9174: fnd_message.set_token('MESSAGE', l_errMsg);
9175: fnd_msg_pub.add;
9176: END ez_completion;
9177:
9178: /*****************************************************************************

Line 9284: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

9280: p_procReturnStatus => x_returnStatus,
9281: p_msg => l_errMsg,
9282: x_returnStatus => l_returnStatus);
9283: END IF;
9284: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9285: fnd_message.set_token('MESSAGE', l_errMsg);
9286: fnd_msg_pub.add;
9287: END update_wro;
9288:

Line 9285: fnd_message.set_token('MESSAGE', l_errMsg);

9281: p_msg => l_errMsg,
9282: x_returnStatus => l_returnStatus);
9283: END IF;
9284: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9285: fnd_message.set_token('MESSAGE', l_errMsg);
9286: fnd_msg_pub.add;
9287: END update_wro;
9288:
9289: /*****************************************************************************

Line 9564: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

9560: p_procReturnStatus => x_returnStatus,
9561: p_msg => l_errMsg,
9562: x_returnStatus => l_returnStatus);
9563: END IF;
9564: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9565: fnd_message.set_token('MESSAGE', l_errMsg);
9566: fnd_msg_pub.add;
9567: END move_txns;
9568:

Line 9565: fnd_message.set_token('MESSAGE', l_errMsg);

9561: p_msg => l_errMsg,
9562: x_returnStatus => l_returnStatus);
9563: END IF;
9564: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9565: fnd_message.set_token('MESSAGE', l_errMsg);
9566: fnd_msg_pub.add;
9567: END move_txns;
9568:
9569: /*****************************************************************************

Line 9912: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

9908: x_returnStatus => x_returnStatus,
9909: x_errorMsg => l_errMsg);
9910:
9911: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9912: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9913: fnd_message.set_token('MESSAGE', l_errMsg);
9914: fnd_msg_pub.add;
9915: l_errMsg := 'wip_mtlTempProc_priv.processTemp failed' ;
9916: raise fnd_api.g_exc_unexpected_error;

Line 9913: fnd_message.set_token('MESSAGE', l_errMsg);

9909: x_errorMsg => l_errMsg);
9910:
9911: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9912: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9913: fnd_message.set_token('MESSAGE', l_errMsg);
9914: fnd_msg_pub.add;
9915: l_errMsg := 'wip_mtlTempProc_priv.processTemp failed' ;
9916: raise fnd_api.g_exc_unexpected_error;
9917: END IF;

Line 9992: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

9988: p_msg_count => l_msgCount,
9989: p_msg_data => l_errMsg);
9990:
9991: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9992: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9993: fnd_message.set_token('MESSAGE', l_errMsg);
9994: fnd_msg_pub.add;
9995: l_errMsg := 'QA Failed. Collection ID:' || l_qa_collection_id;
9996: raise fnd_api.g_exc_unexpected_error;

Line 9993: fnd_message.set_token('MESSAGE', l_errMsg);

9989: p_msg_data => l_errMsg);
9990:
9991: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
9992: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9993: fnd_message.set_token('MESSAGE', l_errMsg);
9994: fnd_msg_pub.add;
9995: l_errMsg := 'QA Failed. Collection ID:' || l_qa_collection_id;
9996: raise fnd_api.g_exc_unexpected_error;
9997: END IF;

Line 10016: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');

10012: AND TRUNC(transaction_date) = TRUNC(l_gib.txn_date);
10013:
10014: -- IF debug message level = 2, write statement below to log file
10015: IF (l_logLevel <= wip_constants.full_logging) THEN
10016: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
10017: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
10018: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
10019: l_msg := fnd_message.get;
10020: wip_logger.log(p_msg => l_msg,

Line 10017: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

10013:
10014: -- IF debug message level = 2, write statement below to log file
10015: IF (l_logLevel <= wip_constants.full_logging) THEN
10016: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
10017: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
10018: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
10019: l_msg := fnd_message.get;
10020: wip_logger.log(p_msg => l_msg,
10021: x_returnStatus => l_returnStatus);

Line 10018: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');

10014: -- IF debug message level = 2, write statement below to log file
10015: IF (l_logLevel <= wip_constants.full_logging) THEN
10016: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
10017: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
10018: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
10019: l_msg := fnd_message.get;
10020: wip_logger.log(p_msg => l_msg,
10021: x_returnStatus => l_returnStatus);
10022: END IF;

Line 10019: l_msg := fnd_message.get;

10015: IF (l_logLevel <= wip_constants.full_logging) THEN
10016: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
10017: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
10018: fnd_message.set_token('ENTITY2', 'WIP_MOVE_TXN_INTERFACE');
10019: l_msg := fnd_message.get;
10020: wip_logger.log(p_msg => l_msg,
10021: x_returnStatus => l_returnStatus);
10022: END IF;
10023:

Line 10059: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

10055: x_returnStatus => x_returnStatus,
10056: x_errorMsg => l_errMsg);
10057:
10058: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10059: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
10060: fnd_message.set_token('MESSAGE', l_errMsg);
10061: fnd_msg_pub.add;
10062: l_errMsg := 'wip_mtlTempProc_priv.processTemp failed' ;
10063: raise fnd_api.g_exc_unexpected_error;

Line 10060: fnd_message.set_token('MESSAGE', l_errMsg);

10056: x_errorMsg => l_errMsg);
10057:
10058: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10059: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
10060: fnd_message.set_token('MESSAGE', l_errMsg);
10061: fnd_msg_pub.add;
10062: l_errMsg := 'wip_mtlTempProc_priv.processTemp failed' ;
10063: raise fnd_api.g_exc_unexpected_error;
10064: END IF;

Line 10141: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');

10137: ELSE
10138: IF(l_ls_required = WIP_CONSTANTS.YES) THEN
10139: -- If we need to gather more lot/serial, error out because
10140: -- we cannot gather lot/serial for background transaction.
10141: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
10142: fnd_msg_pub.add;
10143: raise fnd_api.g_exc_unexpected_error;
10144: END IF;
10145: END IF; -- check return status

Line 10180: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');

10176: ELSE
10177: IF(l_ls_required = WIP_CONSTANTS.YES) THEN
10178: -- If we need to gather more lot/serial, error out because
10179: -- we cannot gather lot/serial for background transaction.
10180: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
10181: fnd_msg_pub.add;
10182: raise fnd_api.g_exc_unexpected_error;
10183: END IF;
10184: END IF; -- check return status

Line 10193: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');

10189: wip_utilities.get_message_stack(p_msg =>l_errMsg);
10190: IF(l_errMsg IS NULL) THEN
10191: -- initialize message to something because we cannot
10192: -- insert null into WIP_TXN_INTERFACE_ERRORS
10193: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10194: l_errMsg := fnd_message.get;
10195: END IF;
10196: IF(p_move_mode = WIP_CONSTANTS.BACKGROUND) THEN
10197: /* Update process status to error */

Line 10194: l_errMsg := fnd_message.get;

10190: IF(l_errMsg IS NULL) THEN
10191: -- initialize message to something because we cannot
10192: -- insert null into WIP_TXN_INTERFACE_ERRORS
10193: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10194: l_errMsg := fnd_message.get;
10195: END IF;
10196: IF(p_move_mode = WIP_CONSTANTS.BACKGROUND) THEN
10197: /* Update process status to error */
10198: UPDATE wip_move_txn_interface

Line 10303: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

10299: x_returnStatus => x_returnStatus,
10300: x_errorMsg => l_errMsg);
10301:
10302: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10303: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
10304: fnd_message.set_token('MESSAGE', l_errMsg);
10305: fnd_msg_pub.add;
10306: l_errMsg := 'wip_mtlTempProc_priv.processTemp failed' ;
10307: raise fnd_api.g_exc_unexpected_error;

Line 10304: fnd_message.set_token('MESSAGE', l_errMsg);

10300: x_errorMsg => l_errMsg);
10301:
10302: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
10303: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
10304: fnd_message.set_token('MESSAGE', l_errMsg);
10305: fnd_msg_pub.add;
10306: l_errMsg := 'wip_mtlTempProc_priv.processTemp failed' ;
10307: raise fnd_api.g_exc_unexpected_error;
10308: END IF;

Line 10354: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');

10350: wip_utilities.get_message_stack(p_msg =>l_errMsg);
10351: IF(l_errMsg IS NULL) THEN
10352: -- initialize message to something because we cannot insert null
10353: -- into WIP_TXN_INTERFACE_ERRORS
10354: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10355: l_errMsg := fnd_message.get;
10356: END IF;
10357:
10358: /* insert error messages */

Line 10355: l_errMsg := fnd_message.get;

10351: IF(l_errMsg IS NULL) THEN
10352: -- initialize message to something because we cannot insert null
10353: -- into WIP_TXN_INTERFACE_ERRORS
10354: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10355: l_errMsg := fnd_message.get;
10356: END IF;
10357:
10358: /* insert error messages */
10359: INSERT INTO wip_txn_interface_errors

Line 10535: --fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');

10531: -- Fixed bug 5355443. We should not always put WIP_SOME_RECORDS_ERROR in
10532: -- the message stack because this API will be called for both online and
10533: -- background transaction. However, WIP_SOME_RECORDS_ERROR is only
10534: -- applicable for background transaction.
10535: --fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10536: --fnd_msg_pub.add;
10537: IF (l_logLevel <= wip_constants.trace_logging) THEN
10538: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processIntf',
10539: p_procReturnStatus => x_returnStatus,

Line 10631: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');

10627: -- Fixed bug 5355443. Since WIP_SOME_RECORDS_ERROR message is only
10628: -- applicable to background transaction, we should set error message here
10629: -- instead of wip_movProc_priv.processIntf().
10630: --wip_utilities.get_message_stack(p_msg =>errbuf);
10631: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10632: errbuf := fnd_message.get;
10633: END IF;
10634: COMMIT; -- To prevent Move Worker concurrent program rollback.
10635: EXCEPTION

Line 10632: errbuf := fnd_message.get;

10628: -- applicable to background transaction, we should set error message here
10629: -- instead of wip_movProc_priv.processIntf().
10630: --wip_utilities.get_message_stack(p_msg =>errbuf);
10631: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10632: errbuf := fnd_message.get;
10633: END IF;
10634: COMMIT; -- To prevent Move Worker concurrent program rollback.
10635: EXCEPTION
10636: WHEN others THEN

Line 10703: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');

10699: AND mmtt.transaction_action_id = WIP_CONSTANTS.SCRASSY_ACTION;
10700:
10701: -- IF debug message level = 2, write statement below to log file
10702: IF (l_logLevel <= wip_constants.full_logging) THEN
10703: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
10704: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
10705: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TXN_ALLOCATIONS');
10706: l_msg := fnd_message.get;
10707: wip_logger.log(p_msg => l_msg,

Line 10704: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

10700:
10701: -- IF debug message level = 2, write statement below to log file
10702: IF (l_logLevel <= wip_constants.full_logging) THEN
10703: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
10704: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
10705: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TXN_ALLOCATIONS');
10706: l_msg := fnd_message.get;
10707: wip_logger.log(p_msg => l_msg,
10708: x_returnStatus => l_returnStatus);

Line 10705: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TXN_ALLOCATIONS');

10701: -- IF debug message level = 2, write statement below to log file
10702: IF (l_logLevel <= wip_constants.full_logging) THEN
10703: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
10704: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
10705: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TXN_ALLOCATIONS');
10706: l_msg := fnd_message.get;
10707: wip_logger.log(p_msg => l_msg,
10708: x_returnStatus => l_returnStatus);
10709: END IF;

Line 10706: l_msg := fnd_message.get;

10702: IF (l_logLevel <= wip_constants.full_logging) THEN
10703: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
10704: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
10705: fnd_message.set_token('ENTITY2', 'MTL_MATERIAL_TXN_ALLOCATIONS');
10706: l_msg := fnd_message.get;
10707: wip_logger.log(p_msg => l_msg,
10708: x_returnStatus => l_returnStatus);
10709: END IF;
10710: x_returnStatus := fnd_api.g_ret_sts_success;

Line 10723: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

10719: p_procReturnStatus => x_returnStatus,
10720: p_msg => l_msg,
10721: x_returnStatus => l_returnStatus);
10722: END IF;
10723: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
10724: fnd_message.set_token('MESSAGE', l_msg);
10725: fnd_msg_pub.add;
10726: END repetitive_scrap;
10727:

Line 10724: fnd_message.set_token('MESSAGE', l_msg);

10720: p_msg => l_msg,
10721: x_returnStatus => l_returnStatus);
10722: END IF;
10723: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
10724: fnd_message.set_token('MESSAGE', l_msg);
10725: fnd_msg_pub.add;
10726: END repetitive_scrap;
10727:
10728: /*****************************************************************************

Line 11119: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

11115: -- If it fails inventory validation, no error will be recorded in WTIE.
11116: -- Instead, error message will be put in message stack.
11117: -- fnd_msg_pub.initialize;
11118: FOR l_errors IN c_errors LOOP
11119: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
11120: fnd_message.set_token('MESSAGE', l_errors.error_message);
11121: fnd_msg_pub.add;
11122: END LOOP;
11123: ROLLBACK TO SAVEPOINT s_oa_txn_proc;

Line 11120: fnd_message.set_token('MESSAGE', l_errors.error_message);

11116: -- Instead, error message will be put in message stack.
11117: -- fnd_msg_pub.initialize;
11118: FOR l_errors IN c_errors LOOP
11119: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
11120: fnd_message.set_token('MESSAGE', l_errors.error_message);
11121: fnd_msg_pub.add;
11122: END LOOP;
11123: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
11124: x_returnStatus := fnd_api.g_ret_sts_error;

Line 11139: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

11135: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
11136: x_returnStatus := fnd_api.g_ret_sts_error;
11137: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
11138:
11139: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
11140: fnd_message.set_token('MESSAGE', l_error_msg);
11141: fnd_msg_pub.add;
11142:
11143: IF (l_log_level <= wip_constants.trace_logging) THEN

Line 11140: fnd_message.set_token('MESSAGE', l_error_msg);

11136: x_returnStatus := fnd_api.g_ret_sts_error;
11137: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
11138:
11139: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
11140: fnd_message.set_token('MESSAGE', l_error_msg);
11141: fnd_msg_pub.add;
11142:
11143: IF (l_log_level <= wip_constants.trace_logging) THEN
11144: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.processOATxn',