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.CSP_MO_MTLTXNS_UTIL dependencies on CSP_PP_UTIL

Line 379: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;

375: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
376: l_csp_mtltxn_over_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
377: l_csp_mtltxn_bak_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
378: l_csp_mtltxn_misc_issue_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
379: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;
380: l_msnt_tbl csp_pp_util.g_msnt_tbl_type;
381: l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
382: l_packlist_headers_rec CSP_packlist_headers_PVT.PLH_Rec_Type;
383:

Line 380: l_msnt_tbl csp_pp_util.g_msnt_tbl_type;

376: l_csp_mtltxn_over_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
377: l_csp_mtltxn_bak_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
378: l_csp_mtltxn_misc_issue_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
379: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;
380: l_msnt_tbl csp_pp_util.g_msnt_tbl_type;
381: l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
382: l_packlist_headers_rec CSP_packlist_headers_PVT.PLH_Rec_Type;
383:
384: -- Use 1 as the starting index because it is what the core apps API uses.

Line 1044: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);

1040: -- Now we have to check whether we need to insert into the mtlt and msnt tables.
1041: IF nvl(l_csp_mtltxn_rec.item_lot_control_code, 1) <> 1 THEN
1042: IF nvl(p_lot_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1043: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_LOT_MISSED');
1044: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);
1045: fnd_msg_pub.add;
1046: RAISE EXCP_USER_DEFINED;
1047: END IF;
1048:

Line 1067: csp_pp_util.insert_mtlt(

1063: AND organization_id = p_organization_id
1064: AND lot_number = p_lot_number;
1065:
1066: -- create a mtlt record
1067: csp_pp_util.insert_mtlt(
1068: x_return_status => l_return_status
1069: ,p_mtlt_tbl => l_mtlt_tbl
1070: ,p_mtlt_tbl_size => 1
1071: );

Line 1086: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);

1082: IF nvl(l_csp_mtltxn_rec.item_serial_control_code, 1) in (2,5) THEN
1083:
1084: IF nvl(p_serial_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1085: fnd_message.set_name ('CSP', 'CSP_OVER_RECEIPT_SERIAL_MISSED');
1086: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);
1087: fnd_msg_pub.add;
1088: RAISE EXCP_USER_DEFINED;
1089: ELSE
1090: IF p_quantity_received <> 1 THEN

Line 1092: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);

1088: RAISE EXCP_USER_DEFINED;
1089: ELSE
1090: IF p_quantity_received <> 1 THEN
1091: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_SERIAL_QTY');
1092: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);
1093: fnd_msg_pub.add;
1094: RAISE EXCP_USER_DEFINED;
1095: END IF;
1096: END IF;

Line 1129: csp_pp_util.insert_msnt(

1125: l_msnt_tbl(l_index).fm_serial_number := p_serial_number;
1126: l_msnt_tbl(l_index).to_serial_number := p_serial_number;
1127: l_msnt_tbl(l_index).serial_prefix := 1;
1128:
1129: csp_pp_util.insert_msnt(
1130: x_return_status => l_return_status
1131: ,p_msnt_tbl => l_msnt_tbl
1132: ,p_msnt_tbl_size => 1
1133: );

Line 1148: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);

1144: nvl(l_csp_mtltxn_rec.item_serial_control_code, 1) in (2, 5) THEN
1145: -- Serial control only
1146: IF nvl(p_serial_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1147: fnd_message.set_name ('CSP', 'CSP_OVER_RECEIPT_SERIAL_MISSED');
1148: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);
1149: fnd_msg_pub.add;
1150: RAISE EXCP_USER_DEFINED;
1151: ELSE
1152: IF p_quantity_received <> 1 THEN

Line 1154: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);

1150: RAISE EXCP_USER_DEFINED;
1151: ELSE
1152: IF p_quantity_received <> 1 THEN
1153: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_SERIAL_QTY');
1154: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_rec.inventory_item_id), FALSE);
1155: fnd_msg_pub.add;
1156: RAISE EXCP_USER_DEFINED;
1157: END IF;
1158: END IF;

Line 1169: csp_pp_util.insert_msnt(

1165: l_msnt_tbl(l_index).fm_serial_number := p_serial_number;
1166: l_msnt_tbl(l_index).to_serial_number := p_serial_number;
1167: l_msnt_tbl(l_index).serial_prefix := 1;
1168:
1169: csp_pp_util.insert_msnt(
1170: x_return_status => l_return_status
1171: ,p_msnt_tbl => l_msnt_tbl
1172: ,p_msnt_tbl_size => 1
1173: );

Line 1485: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_over_rec.inventory_item_id), FALSE);

1481: -- This case should not happen because we always transact one serial number at time.
1482: -- Eventually, the transaction_qunatity is either 1 or the whole transaction temp record
1483: -- was deleted when the last expected serial number is transacted.
1484: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_SERIAL_QTY');
1485: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_over_rec.inventory_item_id), FALSE);
1486: fnd_msg_pub.add;
1487: RAISE EXCP_USER_DEFINED;
1488: END IF;
1489: IF nvl(l_csp_mtltxn_over_rec.item_lot_control_code, 1) <> 1 THEN

Line 1492: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_over_rec.inventory_item_id), FALSE);

1488: END IF;
1489: IF nvl(l_csp_mtltxn_over_rec.item_lot_control_code, 1) <> 1 THEN
1490: IF nvl(p_lot_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1491: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_LOT_MISSED');
1492: fnd_message.set_token('ITEM_NAME', csp_pp_util.get_item_name(l_csp_mtltxn_over_rec.inventory_item_id), FALSE);
1493: fnd_msg_pub.add;
1494: RAISE EXCP_USER_DEFINED;
1495: END IF;
1496:

Line 1498: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;

1494: RAISE EXCP_USER_DEFINED;
1495: END IF;
1496:
1497: DECLARE
1498: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;
1499: l_index NUMBER := 1;
1500: CURSOR l_Get_Mtlt IS
1501: SELECT * FROM mtl_transaction_lots_temp
1502: WHERE transaction_temp_id = l_csp_mtltxn_rec.transaction_temp_id -- Get the lot record form the original temp id

Line 1521: csp_pp_util.insert_mtlt(

1517: l_mtlt_tbl(l_index).lot_number := p_lot_number;
1518: l_mtlt_tbl(l_index).transaction_quantity := l_csp_mtltxn_over_rec.transaction_quantity;
1519: l_mtlt_tbl(l_index).primary_quantity := l_csp_mtltxn_over_rec.primary_quantity;
1520:
1521: csp_pp_util.insert_mtlt(
1522: x_return_status => l_return_status
1523: ,p_mtlt_tbl => l_mtlt_tbl
1524: ,p_mtlt_tbl_size => 1
1525: );

Line 2213: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;

2209: l_msg_count NUMBER := 0;
2210: l_msg_data VARCHAR2(300);
2211: l_check_existence NUMBER := 0;
2212: l_return_status VARCHAR2(1);
2213: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;
2214: l_index NUMBER := 1;
2215: l_temp_id_to_be_processed NUMBER := p_transaction_temp_id;
2216: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
2217: CURSOR l_ml_records IS

Line 2592: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;

2588: l_commit VARCHAR2(1) := fnd_api.g_false;
2589: l_check_existence NUMBER := 0;
2590: l_return_status VARCHAR2(1);
2591: l_msg_count NUMBER := 0;
2592: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;
2593: l_index NUMBER := 1;
2594: l_transaction_header_id NUMBER := NULL;
2595: l_account_id NUMBER := NULL;
2596: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;

Line 2933: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;

2929: X_Return_Status OUT NOCOPY VARCHAR2,
2930: X_Msg_Count OUT NOCOPY NUMBER,
2931: X_Msg_Data OUT NOCOPY VARCHAR2)
2932: IS
2933: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;
2934: l_msnt_tbl csp_pp_util.g_msnt_tbl_type;
2935:
2936: -- use 1 as the starting index because it is what the core apps API uses.
2937: -- we are not going to update this index becase there is only one record in the

Line 2934: l_msnt_tbl csp_pp_util.g_msnt_tbl_type;

2930: X_Msg_Count OUT NOCOPY NUMBER,
2931: X_Msg_Data OUT NOCOPY VARCHAR2)
2932: IS
2933: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;
2934: l_msnt_tbl csp_pp_util.g_msnt_tbl_type;
2935:
2936: -- use 1 as the starting index because it is what the core apps API uses.
2937: -- we are not going to update this index becase there is only one record in the
2938: -- msnt that is coresponding to the l_packlist_sl_rec.serial_number.

Line 2989: csp_pp_util.split_prefix_num (

2985:
2986: -- l_serial_transaction_temp_id := l_msnt_tbl(l_index).transaction_temp_id; -- removed on 03/30/00
2987:
2988: -- analyze the serial number range
2989: csp_pp_util.split_prefix_num (
2990: p_serial_number => p_serial_number
2991: ,p_prefix => l_prefix
2992: ,x_num => l_num
2993: );

Line 2994: csp_pp_util.split_prefix_num (

2990: p_serial_number => p_serial_number
2991: ,p_prefix => l_prefix
2992: ,x_num => l_num
2993: );
2994: csp_pp_util.split_prefix_num (
2995: p_serial_number => l_msnt_tbl(l_index).fm_serial_number
2996: ,p_prefix => l_temp_fm_prefix
2997: ,x_num => l_temp_fm_num
2998: );

Line 2999: csp_pp_util.split_prefix_num (

2995: p_serial_number => l_msnt_tbl(l_index).fm_serial_number
2996: ,p_prefix => l_temp_fm_prefix
2997: ,x_num => l_temp_fm_num
2998: );
2999: csp_pp_util.split_prefix_num (
3000: p_serial_number => l_msnt_tbl(l_index).to_serial_number
3001: ,p_prefix => l_temp_to_prefix
3002: ,x_num => l_temp_to_num
3003: );

Line 3050: csp_pp_util.insert_msnt(

3046: l_msnt_tbl(l_index).creation_date := sysdate;
3047: l_msnt_tbl(l_index).last_update_date := sysdate;
3048:
3049: -- create a new msnt record based on the above information.
3050: csp_pp_util.insert_msnt(
3051: x_return_status => l_return_status
3052: ,p_msnt_tbl => l_msnt_tbl
3053: ,p_msnt_tbl_size => 1
3054: );

Line 3073: csp_pp_util.insert_msnt(

3069: l_msnt_tbl(l_index).serial_prefix := 1;
3070: l_msnt_tbl(l_index).creation_date := sysdate;
3071: l_msnt_tbl(l_index).last_update_date := sysdate;
3072:
3073: csp_pp_util.insert_msnt(
3074: x_return_status => l_return_status
3075: ,p_msnt_tbl => l_msnt_tbl
3076: ,p_msnt_tbl_size => 1
3077: );

Line 3127: csp_pp_util.insert_msnt(

3123: l_msnt_tbl(l_index).serial_prefix := 1;
3124: l_msnt_tbl(l_index).creation_date := sysdate;
3125: l_msnt_tbl(l_index).last_update_date := sysdate;
3126:
3127: csp_pp_util.insert_msnt(
3128: x_return_status => l_return_status
3129: ,p_msnt_tbl => l_msnt_tbl
3130: ,p_msnt_tbl_size => 1
3131: );

Line 3181: csp_pp_util.insert_msnt(

3177: l_msnt_tbl(l_index).serial_prefix := 1;
3178: l_msnt_tbl(l_index).creation_date := sysdate;
3179: l_msnt_tbl(l_index).last_update_date := sysdate;
3180:
3181: csp_pp_util.insert_msnt(
3182: x_return_status => l_return_status
3183: ,p_msnt_tbl => l_msnt_tbl
3184: ,p_msnt_tbl_size => 1
3185: );

Line 3351: csp_pp_util.insert_mtlt(

3347: l_mtlt_tbl(l_index).primary_quantity := p_qty_received;
3348: l_mtlt_tbl(l_index).transaction_temp_id := p_new_transaction_temp_id;
3349: l_mtlt_tbl(l_index).serial_transaction_temp_id := l_new_serial_temp_id;
3350:
3351: csp_pp_util.insert_mtlt(
3352: x_return_status => l_return_status
3353: ,p_mtlt_tbl => l_mtlt_tbl
3354: ,p_mtlt_tbl_size => 1
3355: );

Line 3426: csp_pp_util.insert_mtlt(

3422: l_mtlt_tbl(l_index).transaction_quantity := l_qty_received;
3423: l_mtlt_tbl(l_index).primary_quantity := l_qty_received;
3424: l_mtlt_tbl(l_index).transaction_temp_id := p_new_transaction_temp_id;
3425:
3426: csp_pp_util.insert_mtlt(
3427: x_return_status => l_return_status
3428: ,p_mtlt_tbl => l_mtlt_tbl
3429: ,p_mtlt_tbl_size => 1
3430: );