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_SO_RESERVATIONS dependencies on WIP_LOGGER

Line 696: l_params wip_logger.param_tbl_t;

692: l_msg_count NUMBER;
693: l_msg_data VARCHAR2(2000);
694: l_object_id NUMBER;
695: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
696: l_params wip_logger.param_tbl_t;
697: l_wip_cfg_rsv_level NUMBER;
698: l_skip_flag BOOLEAN; /* Bug 2976994 */
699: begin
700: x_return_status := fnd_api.g_ret_sts_success;

Line 706: wip_logger.entryPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',

702: if(l_logLevel <= wip_constants.trace_logging) then
703: l_params(1).paramName := 'not logging params';
704: l_params(1).paramValue := null;
705:
706: wip_logger.entryPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',
707: p_params => l_params,
708: x_returnStatus => l_return_status);
709: end if;
710: -------------------------------------

Line 722: wip_logger.log('no SO found', l_return_status);

718: -- demand source header id, the rest of lines won't have sales
719: -- order specified either. We are done.
720: IF (p_transaction_tbl(i).demand_source_header_id IS NULL) THEN
721: if(l_logLevel <= wip_constants.full_logging) then
722: wip_logger.log('no SO found', l_return_status);
723: end if;
724: EXIT;
725: END IF;
726:

Line 733: wip_logger.log('no lot', l_return_status);

729: -- if item under lot control, there must be lot number
730: IF (p_transaction_tbl(i).lot_control_code = WIP_CONSTANTS.LOT AND
731: p_transaction_tbl(i).lot_number IS NULL) THEN
732: if(l_logLevel <= wip_constants.full_logging) then
733: wip_logger.log('no lot', l_return_status);
734: end if;
735: fnd_message.set_name('WIP', 'WIP_NO_LOT_NUMBER');
736: fnd_msg_pub.add;
737: RAISE fnd_api.g_exc_error;

Line 745: wip_logger.log('no qty', l_return_status);

741: p_transaction_tbl(i).transaction_quantity IS NULL OR
742: p_transaction_tbl(i).primary_quantity = 0 OR
743: p_transaction_tbl(i).transaction_quantity = 0) THEN
744: if(l_logLevel <= wip_constants.full_logging) then
745: wip_logger.log('no qty', l_return_status);
746: end if;
747: fnd_message.set_name('WIP', 'WIP_ZERO_TRANSACTION_QUANTITY');
748: fnd_msg_pub.add;
749: RAISE fnd_api.g_exc_error;

Line 795: wip_logger.log('Bad SO info or no open demand. Skipping reservation.', l_return_status);

791: /* Fix for bug 2976994: Instead of flagging error, we complete the
792: flow schedule to inventory without reserving. */
793: l_skip_flag := TRUE;
794: if(l_logLevel <= wip_constants.full_logging) then
795: wip_logger.log('Bad SO info or no open demand. Skipping reservation.', l_return_status);
796: end if;
797: /* fnd_message.set_name('WIP', 'WIP_INVALID_SO_TXN_INFO');
798: fnd_msg_pub.add;
799: RAISE fnd_api.g_exc_error; */

Line 813: wip_logger.log('rsv qty:' || l_reservation_qty, l_return_status);

809: -- ** now we allow overcompletion against sales order
810: -- the over completed qty will not be reserved
811: l_reservation_qty := p_transaction_tbl(i).primary_quantity;
812: if(l_logLevel <= wip_constants.full_logging) then
813: wip_logger.log('rsv qty:' || l_reservation_qty, l_return_status);
814: end if;
815: IF (p_transaction_tbl(i).primary_quantity > l_primary_open_quantity) THEN
816: l_reservation_qty := l_primary_open_quantity;
817: /*

Line 838: wip_logger.log('inv_salesorder errorred', l_return_status);

834: l_oe_header_id,
835: x_return_status);
836: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
837: if(l_logLevel <= wip_constants.full_logging) then
838: wip_logger.log('inv_salesorder errorred', l_return_status);
839: end if;
840: RAISE fnd_api.g_exc_error;
841: END IF;
842:

Line 937: wip_logger.log('inserting log', l_return_status);

933: AND LOT_NUMBER = l_reservation_rec.lot_number;
934:
935: if (l_lotcount=0) then
936: if(l_logLevel <= wip_constants.full_logging) then
937: wip_logger.log('inserting log', l_return_status);
938: end if;
939:
940: INV_LOT_API_PUB.InsertLot(p_api_version => 1.0,
941: p_init_msg_list => 'F',

Line 969: wip_logger.log('creating reservation', l_return_status);

965: -- Fix for Bug#2268499
966: inv_quantity_tree_grp.clear_quantity_cache ;
967:
968: if(l_logLevel <= wip_constants.full_logging) then
969: wip_logger.log('creating reservation', l_return_status);
970: wip_logger.log('item' || l_reservation_rec.inventory_item_id, l_return_status);
971: wip_logger.log('sub' || l_reservation_rec.subinventory_code, l_return_status);
972: wip_logger.log('loc' || l_reservation_rec.locator_id, l_return_status);
973: wip_logger.log('qty' || l_reservation_rec.primary_reservation_quantity, l_return_status);

Line 970: wip_logger.log('item' || l_reservation_rec.inventory_item_id, l_return_status);

966: inv_quantity_tree_grp.clear_quantity_cache ;
967:
968: if(l_logLevel <= wip_constants.full_logging) then
969: wip_logger.log('creating reservation', l_return_status);
970: wip_logger.log('item' || l_reservation_rec.inventory_item_id, l_return_status);
971: wip_logger.log('sub' || l_reservation_rec.subinventory_code, l_return_status);
972: wip_logger.log('loc' || l_reservation_rec.locator_id, l_return_status);
973: wip_logger.log('qty' || l_reservation_rec.primary_reservation_quantity, l_return_status);
974: wip_logger.log('lpn' || l_reservation_rec.lpn_id, l_return_status);

Line 971: wip_logger.log('sub' || l_reservation_rec.subinventory_code, l_return_status);

967:
968: if(l_logLevel <= wip_constants.full_logging) then
969: wip_logger.log('creating reservation', l_return_status);
970: wip_logger.log('item' || l_reservation_rec.inventory_item_id, l_return_status);
971: wip_logger.log('sub' || l_reservation_rec.subinventory_code, l_return_status);
972: wip_logger.log('loc' || l_reservation_rec.locator_id, l_return_status);
973: wip_logger.log('qty' || l_reservation_rec.primary_reservation_quantity, l_return_status);
974: wip_logger.log('lpn' || l_reservation_rec.lpn_id, l_return_status);
975: end if;

Line 972: wip_logger.log('loc' || l_reservation_rec.locator_id, l_return_status);

968: if(l_logLevel <= wip_constants.full_logging) then
969: wip_logger.log('creating reservation', l_return_status);
970: wip_logger.log('item' || l_reservation_rec.inventory_item_id, l_return_status);
971: wip_logger.log('sub' || l_reservation_rec.subinventory_code, l_return_status);
972: wip_logger.log('loc' || l_reservation_rec.locator_id, l_return_status);
973: wip_logger.log('qty' || l_reservation_rec.primary_reservation_quantity, l_return_status);
974: wip_logger.log('lpn' || l_reservation_rec.lpn_id, l_return_status);
975: end if;
976: inv_reservation_pub.create_reservation(p_api_version_number => 1.0,

Line 973: wip_logger.log('qty' || l_reservation_rec.primary_reservation_quantity, l_return_status);

969: wip_logger.log('creating reservation', l_return_status);
970: wip_logger.log('item' || l_reservation_rec.inventory_item_id, l_return_status);
971: wip_logger.log('sub' || l_reservation_rec.subinventory_code, l_return_status);
972: wip_logger.log('loc' || l_reservation_rec.locator_id, l_return_status);
973: wip_logger.log('qty' || l_reservation_rec.primary_reservation_quantity, l_return_status);
974: wip_logger.log('lpn' || l_reservation_rec.lpn_id, l_return_status);
975: end if;
976: inv_reservation_pub.create_reservation(p_api_version_number => 1.0,
977: p_init_msg_lst => fnd_api.g_false,

Line 974: wip_logger.log('lpn' || l_reservation_rec.lpn_id, l_return_status);

970: wip_logger.log('item' || l_reservation_rec.inventory_item_id, l_return_status);
971: wip_logger.log('sub' || l_reservation_rec.subinventory_code, l_return_status);
972: wip_logger.log('loc' || l_reservation_rec.locator_id, l_return_status);
973: wip_logger.log('qty' || l_reservation_rec.primary_reservation_quantity, l_return_status);
974: wip_logger.log('lpn' || l_reservation_rec.lpn_id, l_return_status);
975: end if;
976: inv_reservation_pub.create_reservation(p_api_version_number => 1.0,
977: p_init_msg_lst => fnd_api.g_false,
978: x_return_status => l_return_status,

Line 994: wip_logger.log('reservation creation failed:' || l_msg_data, l_return_status);

990:
991:
992: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
993: if(l_logLevel <= wip_constants.full_logging) then
994: wip_logger.log('reservation creation failed:' || l_msg_data, l_return_status);
995: end if;
996: x_msg_count := l_msg_count;
997: x_msg_data := l_msg_data;
998: x_return_status := l_return_status;

Line 1008: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',

1004: END LOOP; -- loop through each completion form line
1005:
1006: x_return_status := fnd_api.g_ret_sts_success;
1007: if (l_logLevel <= wip_constants.trace_logging) then
1008: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',
1009: p_procReturnStatus => x_return_status,
1010: p_msg => 'succeeded',
1011: x_returnStatus => l_return_status); --discard logging return status
1012: end if;

Line 1018: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',

1014: WHEN g_need_to_rollback_exception THEN
1015: x_return_status := fnd_api.g_ret_sts_error;
1016: rollback to transfer_flow_lines_0;
1017: if (l_logLevel <= wip_constants.trace_logging) then
1018: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',
1019: p_procReturnStatus => x_return_status,
1020: p_msg => 'error1',
1021: x_returnStatus => l_return_status); --discard logging return status
1022: end if;

Line 1031: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',

1027: p_count => x_msg_count,
1028: p_data => x_msg_data);
1029: rollback to transfer_flow_lines_0;
1030: if (l_logLevel <= wip_constants.trace_logging) then
1031: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',
1032: p_procReturnStatus => x_return_status,
1033: p_msg => 'error2',
1034: x_returnStatus => l_return_status); --discard logging return status
1035: end if;

Line 1044: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',

1040: p_count => x_msg_count,
1041: p_data => x_msg_data);
1042: rollback to transfer_flow_lines_0;
1043: if (l_logLevel <= wip_constants.trace_logging) then
1044: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',
1045: p_procReturnStatus => x_return_status,
1046: p_msg => 'error3',
1047: x_returnStatus => l_return_status); --discard logging return status
1048: end if;

Line 1063: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',

1059: p_data => x_msg_data);
1060:
1061: rollback to transfer_flow_lines_0;
1062: if (l_logLevel <= wip_constants.trace_logging) then
1063: wip_logger.exitPoint(p_procName => 'wip_so_reservations.transfer_flow_lines',
1064: p_procReturnStatus => x_return_status,
1065: p_msg => 'error4',
1066: x_returnStatus => l_return_status); --discard logging return status
1067: end if;

Line 1085: l_params wip_logger.param_tbl_t;

1081: l_transaction_tbl transaction_temp_tbl_type;
1082: l_return_status VARCHAR2(1);
1083: l_msg_count NUMBER;
1084: l_msg_data VARCHAR2(2000);
1085: l_params wip_logger.param_tbl_t;
1086: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1087: begin
1088: x_return_status := fnd_api.g_ret_sts_success;
1089: if(l_logLevel <= wip_constants.trace_logging) then

Line 1099: wip_logger.entryPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',

1095: l_params(3).paramValue := p_primary_quantity;
1096: l_params(4).paramName := 'p_lot_number';
1097: l_params(4).paramValue := p_lot_number;
1098:
1099: wip_logger.entryPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',
1100: p_params => l_params,
1101: x_returnStatus => l_return_status);
1102: end if;
1103:

Line 1122: wip_logger.log(l_transaction_tbl.count || ' lines fetched for so rsv xfer', l_return_status);

1118: END IF;
1119: END IF;
1120:
1121: if(l_logLevel <= wip_constants.full_logging) then
1122: wip_logger.log(l_transaction_tbl.count || ' lines fetched for so rsv xfer', l_return_status);
1123: end if;
1124:
1125: transfer_flow_lines(p_transaction_tbl => l_transaction_tbl,
1126: p_table_type => 'WLC',

Line 1141: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',

1137: END IF;
1138: END IF;
1139:
1140: if (l_logLevel <= wip_constants.trace_logging) then
1141: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',
1142: p_procReturnStatus => x_return_status,
1143: p_msg => 'succeeded',
1144: x_returnStatus => l_return_status); --discard logging return status
1145: end if;

Line 1149: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',

1145: end if;
1146: EXCEPTION
1147: WHEN g_need_to_rollback_exception THEN
1148: if(l_logLevel <= wip_constants.trace_logging) then
1149: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',
1150: p_procReturnStatus => x_return_status,
1151: p_msg => 'error1',
1152: x_returnStatus => l_return_status); --discard logging return status
1153: end if;

Line 1166: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',

1162: x_msg_count := l_msg_count;
1163: end if;
1164: rollback to complete_flow_sched_to_so_1;
1165: if(l_logLevel <= wip_constants.trace_logging) then
1166: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',
1167: p_procReturnStatus => x_return_status,
1168: p_msg => 'error2',
1169: x_returnStatus => l_return_Status); --discard logging return status
1170: end if;

Line 1178: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',

1174: p_count => x_msg_count,
1175: p_data => x_msg_data);
1176: rollback to complete_flow_sched_to_so_1;
1177: if(l_logLevel <= wip_constants.trace_logging) then
1178: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',
1179: p_procReturnStatus => x_return_Status,
1180: p_msg => 'error3',
1181: x_returnStatus => l_return_Status); --discard logging return status
1182: end if;

Line 1194: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',

1190: p_count => x_msg_count,
1191: p_data => x_msg_data);
1192: rollback to complete_flow_sched_to_so_1;
1193: if(l_logLevel <= wip_constants.trace_logging) then
1194: wip_logger.exitPoint(p_procName => 'wip_so_reservations.complete_flow_sched_to_so',
1195: p_procReturnStatus => x_return_Status,
1196: p_msg => 'error4',
1197: x_returnStatus => l_return_Status); --discard logging return status
1198: end if;