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 FND_MSG_PUB

Line 69: FND_MSG_PUB.initialize;

65: BEGIN
66: SAVEPOINT Update_Order_Line_Sts_PUB;
67: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
68: -- initialize message list
69: FND_MSG_PUB.initialize;
70: END IF;
71: -- Standard call to check for call compatibility.
72: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
73: p_api_version_number,

Line 91: FND_MSG_PUB.ADD;

87: -- validate p_organization_id
88: IF p_organization_id IS NULL THEN
89: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
90: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', FALSE);
91: FND_MSG_PUB.ADD;
92: RAISE EXCP_USER_DEFINED;
93: ELSE
94: BEGIN
95: select organization_id into l_check_existence

Line 101: FND_MSG_PUB.ADD;

97: where organization_id = p_organization_id ;
98: EXCEPTION
99: WHEN NO_DATA_FOUND THEN
100: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
101: FND_MSG_PUB.ADD;
102: RAISE EXCP_USER_DEFINED;
103: WHEN OTHERS THEN
104: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
105: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);

Line 108: FND_MSG_PUB.ADD;

104: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
105: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
106: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
107: fnd_message.set_token('TABLE', 'mtl_organizations', FALSE);
108: FND_MSG_PUB.ADD;
109: RAISE EXCP_USER_DEFINED;
110: END;
111: END IF;
112:

Line 118: FND_MSG_PUB.ADD;

114: -- validate p_move_order_line_id
115: IF p_move_order_line_id IS NULL THEN
116: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
117: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_move_order_line_id', FALSE);
118: FND_MSG_PUB.ADD;
119: RAISE EXCP_USER_DEFINED;
120: ELSE
121: -- validate whether the move_order_line_id exists in the mmtt table
122: BEGIN

Line 131: fnd_msg_pub.add;

127: EXCEPTION
128: WHEN NO_DATA_FOUND THEN
129: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');
130: fnd_message.set_token ('LINE_ID', to_char(p_move_order_line_id), FALSE);
131: fnd_msg_pub.add;
132: RAISE EXCP_USER_DEFINED;
133: WHEN TOO_MANY_ROWS THEN
134: -- This is normal. One move order line id can map to many transaction_temp_id's.
135: NULL;

Line 141: FND_MSG_PUB.ADD;

137: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
138: fnd_message.set_token('ERR_FIELD', 'p_move_order_line_id', FALSE);
139: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
140: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', FALSE);
141: FND_MSG_PUB.ADD;
142: RAISE EXCP_USER_DEFINED;
143: END;
144:
145: -- validate whether the move_order_line_id exists

Line 154: fnd_msg_pub.add;

150: EXCEPTION
151: WHEN NO_DATA_FOUND THEN
152: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');
153: fnd_message.set_token ('LINE_ID', to_char(p_move_order_line_id), FALSE);
154: fnd_msg_pub.add;
155: RAISE EXCP_USER_DEFINED;
156: WHEN OTHERS THEN
157: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
158: fnd_message.set_token('ERR_FIELD', 'p_move_order_line_id', FALSE);

Line 161: FND_MSG_PUB.ADD;

157: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
158: fnd_message.set_token('ERR_FIELD', 'p_move_order_line_id', FALSE);
159: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
160: fnd_message.set_token('TABLE', 'csp_moveorder_lines', FALSE);
161: FND_MSG_PUB.ADD;
162: RAISE EXCP_USER_DEFINED;
163: END;
164: END IF;
165: END IF;

Line 199: fnd_msg_pub.count_and_get

195: EXCEPTION
196: WHEN EXCP_USER_DEFINED THEN
197: Rollback to Update_Order_Line_Sts_PUB;
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: fnd_msg_pub.count_and_get
200: ( p_count => x_msg_count
201: , p_data => x_msg_data);
202: WHEN FND_API.G_EXC_ERROR THEN
203: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 206: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

202: WHEN FND_API.G_EXC_ERROR THEN
203: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
204: P_API_NAME => L_API_NAME
205: ,P_PKG_NAME => G_PKG_NAME
206: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
207: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
208: ,X_MSG_COUNT => X_MSG_COUNT
209: ,X_MSG_DATA => X_MSG_DATA
210: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 215: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
213: P_API_NAME => L_API_NAME
214: ,P_PKG_NAME => G_PKG_NAME
215: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
216: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
217: ,X_MSG_COUNT => X_MSG_COUNT
218: ,X_MSG_DATA => X_MSG_DATA
219: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 225: fnd_msg_pub.add;

221: Rollback to Update_Order_Line_Sts_PUB;
222: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
223: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
224: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
225: fnd_msg_pub.add;
226: fnd_msg_pub.count_and_get
227: ( p_count => x_msg_count
228: , p_data => x_msg_data);
229: x_return_status := fnd_api.g_ret_sts_error;

Line 226: fnd_msg_pub.count_and_get

222: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
223: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
224: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
225: fnd_msg_pub.add;
226: fnd_msg_pub.count_and_get
227: ( p_count => x_msg_count
228: , p_data => x_msg_data);
229: x_return_status := fnd_api.g_ret_sts_error;
230: END Update_Order_Line_Status;

Line 680: FND_MSG_PUB.initialize;

676: SAVEPOINT confirm_receipt_PUB;
677:
678: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
679: -- initialize message list
680: FND_MSG_PUB.initialize;
681: END IF;
682: -- Standard call to check for call compatibility.
683: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
684: p_api_version_number,

Line 702: FND_MSG_PUB.ADD;

698: -- validate p_organization_id
699: IF p_organization_id IS NULL THEN
700: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
701: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', FALSE);
702: FND_MSG_PUB.ADD;
703: RAISE EXCP_USER_DEFINED;
704: ELSE
705: BEGIN
706: select organization_id into l_check_existence

Line 712: FND_MSG_PUB.ADD;

708: where organization_id = p_organization_id;
709: EXCEPTION
710: WHEN NO_DATA_FOUND THEN
711: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
712: FND_MSG_PUB.ADD;
713: RAISE EXCP_USER_DEFINED;
714: WHEN OTHERS THEN
715: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
716: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);

Line 719: FND_MSG_PUB.ADD;

715: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
716: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
717: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
718: fnd_message.set_token('TABLE', 'mtl_organizations', FALSE);
719: FND_MSG_PUB.ADD;
720: RAISE EXCP_USER_DEFINED;
721: END;
722: END IF;
723:

Line 730: FND_MSG_PUB.ADD;

726: -- Validate the p_packlist_line_id
727: IF nvl(p_packlist_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
728: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
729: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_line_id', FALSE);
730: FND_MSG_PUB.ADD;
731: RAISE EXCP_USER_DEFINED;
732: ELSE
733: -- get the packlist_header_id
734: BEGIN

Line 743: fnd_msg_pub.add;

739: EXCEPTION
740: WHEN NO_DATA_FOUND THEN
741: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');
742: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);
743: fnd_msg_pub.add;
744: RAISE EXCP_USER_DEFINED;
745: WHEN OTHERS THEN
746: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
747: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', FALSE);

Line 750: fnd_msg_pub.add;

746: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
747: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', FALSE);
748: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
749: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);
750: fnd_msg_pub.add;
751: RAISE EXCP_USER_DEFINED;
752: END;
753:
754: -- Check whether the packlist already has a status of 'Received' (3) or of 'Received Short' (4).

Line 765: fnd_msg_pub.add;

761: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
762: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_status', FALSE);
763: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
764: fnd_message.set_token('TABLE', 'CSP_PACKLIST_HEADERS', FALSE);
765: fnd_msg_pub.add;
766: RAISE EXCP_USER_DEFINED;
767: END IF;
768:
769: IF l_packlist_header_status = '3' THEN

Line 772: fnd_msg_pub.add;

768:
769: IF l_packlist_header_status = '3' THEN
770: fnd_message.set_name('CSP', 'CSP_INVALID_PACKLIST_TXN');
771: fnd_message.set_token('PACKLIST_HEADER_ID', to_char(l_packlist_header_id), FALSE);
772: fnd_msg_pub.add;
773: RAISE EXCP_USER_DEFINED;
774: END IF;
775:
776: IF p_validation_level = fnd_api.g_valid_level_full THEN

Line 786: fnd_msg_pub.add;

782: EXCEPTION
783: WHEN NO_DATA_FOUND THEN
784: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');
785: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);
786: fnd_msg_pub.add;
787: RAISE EXCP_USER_DEFINED;
788: WHEN OTHERS THEN
789: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
790: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', FALSE);

Line 793: fnd_msg_pub.add;

789: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
790: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', FALSE);
791: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
792: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);
793: fnd_msg_pub.add;
794: RAISE EXCP_USER_DEFINED;
795: END;
796: END IF;
797: END IF;

Line 848: fnd_msg_pub.add;

844: FETCH l_ml_records INTO l_csp_mtltxn_rec;
845:
846: IF l_ml_records%NOTFOUND AND (p_receiving_option IN (0, 1)) THEN
847: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');
848: fnd_msg_pub.add;
849: CLOSE l_ml_records;
850: RAISE EXCP_USER_DEFINED;
851: END IF;
852: CLOSE l_ml_records;

Line 863: fnd_msg_pub.add;

859: IF l_Get_Moveorder_Headers%NOTFOUND THEN
860: CLOSE l_Get_Moveorder_Headers;
861: fnd_message.set_name ('CSP', 'CSP_MOVEORDER_LINE_NO_PARENT');
862: fnd_message.set_token ('LINE_ID', to_char(l_move_order_line_id), FALSE);
863: fnd_msg_pub.add;
864: RAISE EXCP_USER_DEFINED;
865: END IF;
866: CLOSE l_Get_Moveorder_Headers;
867:

Line 888: fnd_msg_pub.add;

884: END IF;
885: GOTO END_JOB;
886: ELSE
887: fnd_message.set_name ('CSP', 'CSP_INVALID_QUANTITY_RECEIVED');
888: fnd_msg_pub.add;
889: RAISE EXCP_USER_DEFINED;
890: END IF; */
891: fnd_message.set_name ('CSP', 'CSP_INVALID_QUANTITY_RECEIVED');
892: fnd_msg_pub.add;

Line 892: fnd_msg_pub.add;

888: fnd_msg_pub.add;
889: RAISE EXCP_USER_DEFINED;
890: END IF; */
891: fnd_message.set_name ('CSP', 'CSP_INVALID_QUANTITY_RECEIVED');
892: fnd_msg_pub.add;
893: RAISE EXCP_USER_DEFINED;
894: ELSE
895: OPEN l_Get_Shipped_Received_Qty;
896: FETCH l_Get_Shipped_Received_Qty INTO l_quantity_shipped, l_quantity_received;

Line 900: fnd_msg_pub.add;

896: FETCH l_Get_Shipped_Received_Qty INTO l_quantity_shipped, l_quantity_received;
897: IF l_Get_Shipped_Received_Qty%NOTFOUND THEN
898: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');
899: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);
900: fnd_msg_pub.add;
901: CLOSE l_Get_Shipped_Received_Qty;
902: RAISE EXCP_USER_DEFINED;
903: END IF;
904: CLOSE l_Get_Shipped_Received_Qty;

Line 923: fnd_msg_pub.add;

919: WHEN NO_DATA_FOUND THEN
920: fnd_message.set_name ('INV', 'INV-NO SUBINVENTORY RECORD');
921: fnd_message.set_token ('SUBINV', p_to_subinventory_code, FALSE);
922: fnd_message.set_token ('ORG', to_char(p_organization_id), FALSE);
923: fnd_msg_pub.add;
924: RAISE EXCP_USER_DEFINED;
925: WHEN OTHERS THEN
926: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
927: fnd_message.set_token('ERR_FIELD', 'p_to_subinventory_code', FALSE);

Line 930: fnd_msg_pub.add;

926: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
927: fnd_message.set_token('ERR_FIELD', 'p_to_subinventory_code', FALSE);
928: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
929: fnd_message.set_token('TABLE', 'csp_packlist_lines', FALSE);
930: fnd_msg_pub.add;
931: RAISE EXCP_USER_DEFINED;
932: END;
933: END IF;
934: IF p_to_locator_id IS NOT NULL THEN

Line 945: fnd_msg_pub.add;

941: AND nvl(disable_date, sysdate+1) > sysdate;
942: EXCEPTION
943: WHEN NO_DATA_FOUND THEN
944: fnd_message.set_name('INV', 'INV_LOCATOR_NOT_AVAILABLE');
945: fnd_msg_pub.add;
946: RAISE EXCP_USER_DEFINED;
947: WHEN OTHERS THEN
948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
949: fnd_message.set_token('ERR_FIELD', 'p_locator_id', FALSE);

Line 952: fnd_msg_pub.ADD;

948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
949: fnd_message.set_token('ERR_FIELD', 'p_locator_id', FALSE);
950: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
951: fnd_message.set_token('TABLE', 'mtl_item_locations', FALSE);
952: fnd_msg_pub.ADD;
953: RAISE EXCP_USER_DEFINED;
954: END;
955: END IF;
956: END IF;

Line 963: fnd_msg_pub.add;

959: OPEN l_ml_records(p_transaction_temp_id);
960: FETCH l_ml_records INTO l_csp_mtltxn_rec;
961: IF l_ml_records%NOTFOUND AND (p_receiving_option IN (0, 1)) THEN
962: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');
963: fnd_msg_pub.add;
964: CLOSE l_ml_records;
965: RAISE EXCP_USER_DEFINED;
966: ELSIF l_ml_records%NOTFOUND AND (p_receiving_option IN (2, 3)) THEN
967: -- In this case, the user may have received all the items. This situation praticularly happens when

Line 1045: fnd_msg_pub.add;

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:
1049: -- Insert the record into the mtlt.

Line 1077: fnd_msg_pub.add;

1073: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1074: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1075: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1076: fnd_message.set_token ('TABLE', 'MTL_TRANSACTION_LOTS_TEMP', FALSE);
1077: fnd_msg_pub.add;
1078: RAISE EXCP_USER_DEFINED;
1079: END IF;
1080:
1081: -- If the item is also under serial control, we need to insert into the msnt.

Line 1087: fnd_msg_pub.add;

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
1091: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_SERIAL_QTY');

Line 1093: fnd_msg_pub.add;

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;
1097:

Line 1114: fnd_msg_pub.add;

1110: If (SQL%NOTFOUND) then
1111: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1112: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1113: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', TRUE);
1114: fnd_msg_pub.add;
1115: RAISE EXCP_USER_DEFINED;
1116: End If;
1117:
1118: -- create the msnt recrod

Line 1139: fnd_msg_pub.add;

1135: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1136: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1137: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1138: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', TRUE);
1139: fnd_msg_pub.add;
1140: RAISE EXCP_USER_DEFINED;
1141: END IF;
1142: END IF;
1143: ELSIF nvl(l_csp_mtltxn_rec.item_lot_control_code, 1) = 1 AND

Line 1149: fnd_msg_pub.add;

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
1153: fnd_message.set_name('CSP', 'CSP_OVER_RECEIPT_SERIAL_QTY');

Line 1155: fnd_msg_pub.add;

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;
1159: l_msnt_tbl(l_index).transaction_temp_id := p_transaction_temp_id;

Line 1179: fnd_msg_pub.add;

1175: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1176: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1177: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1178: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', TRUE);
1179: fnd_msg_pub.add;
1180: RAISE EXCP_USER_DEFINED;
1181: END IF;
1182: ELSE NULL; -- already taken care.
1183: END IF;

Line 1212: fnd_msg_pub.add;

1208: IF l_Get_Moveorder_Headers%NOTFOUND THEN
1209: CLOSE l_Get_Moveorder_Headers;
1210: fnd_message.set_name ('CSP', 'CSP_MOVEORDER_LINE_NO_PARENT');
1211: fnd_message.set_token ('LINE_ID', to_char(l_move_order_line_id), FALSE);
1212: fnd_msg_pub.add;
1213: RAISE EXCP_USER_DEFINED;
1214: END IF;
1215: CLOSE l_Get_Moveorder_Headers;
1216:

Line 1244: fnd_msg_pub.add;

1240: EXCEPTION
1241: WHEN NO_DATA_FOUND THEN
1242: fnd_message.set_name ('CSP', 'CSP_ITEM_SUB_VIOLATION');
1243: fnd_message.set_token ('SUB', p_to_subinventory_code, FALSE);
1244: fnd_msg_pub.add;
1245: RAISE EXCP_USER_DEFINED;
1246: WHEN OTHERS THEN
1247: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1248: fnd_message.set_token('ERR_FIELD', 'p_to_subinventory_code', FALSE);

Line 1251: fnd_msg_pub.ADD;

1247: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1248: fnd_message.set_token('ERR_FIELD', 'p_to_subinventory_code', FALSE);
1249: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
1250: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', FALSE);
1251: fnd_msg_pub.ADD;
1252: RAISE EXCP_USER_DEFINED;
1253: END;
1254: END IF;
1255: EXCEPTION

Line 1258: fnd_msg_pub.add;

1254: END IF;
1255: EXCEPTION
1256: WHEN NO_DATA_FOUND THEN
1257: fnd_message.set_name ('INV', 'INV-NO ITEM RECORD');
1258: fnd_msg_pub.add;
1259: RAISE EXCP_USER_DEFINED;
1260: WHEN OTHERS THEN
1261: fnd_message.set_name('CSP', 'CSP_ITEM_UNEXPECTED_ERRORS');
1262: fnd_message.set_token('ROUTINE', l_api_name, FALSE);

Line 1263: fnd_msg_pub.ADD;

1259: RAISE EXCP_USER_DEFINED;
1260: WHEN OTHERS THEN
1261: fnd_message.set_name('CSP', 'CSP_ITEM_UNEXPECTED_ERRORS');
1262: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
1263: fnd_msg_pub.ADD;
1264: RAISE EXCP_USER_DEFINED;
1265: END;
1266: END IF;
1267: IF p_to_locator_id IS NOT NULL THEN

Line 1289: fnd_msg_pub.add;

1285: AND subinventory_code = p_to_subinventory_code;
1286: EXCEPTION
1287: WHEN NO_DATA_FOUND THEN
1288: fnd_message.set_name ('INV', 'INV_LOCATOR_NOT_AVAILABLE');
1289: fnd_msg_pub.add;
1290: RAISE EXCP_USER_DEFINED;
1291: WHEN OTHERS THEN
1292: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1293: fnd_message.set_token('ERR_FIELD', 'p_to_locator_id', FALSE);

Line 1296: fnd_msg_pub.ADD;

1292: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1293: fnd_message.set_token('ERR_FIELD', 'p_to_locator_id', FALSE);
1294: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
1295: fnd_message.set_token('TABLE', 'mtl_item_loc_defaults', FALSE);
1296: fnd_msg_pub.ADD;
1297: RAISE EXCP_USER_DEFINED;
1298: END;
1299: END IF;
1300: END;

Line 1310: fnd_msg_pub.add;

1306:
1307: -- In this case, the user has to specify a p_receiving_option either 2 or 3.
1308: IF p_receiving_option NOT IN (2, 3) THEN
1309: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');
1310: fnd_msg_pub.add;
1311: RAISE EXCP_USER_DEFINED;
1312: End If;
1313:
1314: l_csp_mtltxn_over_rec := l_csp_mtltxn_rec;

Line 1322: fnd_msg_pub.add;

1318: Fetch l_Get_Org_Qty_Csr Into l_org_received_qty;
1319: Close l_Get_Org_Qty_Csr;
1320: If l_org_received_qty < 0 Then
1321: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');
1322: fnd_msg_pub.add;
1323: RAISE EXCP_USER_DEFINED;
1324: End If;
1325:
1326: If l_org_received_qty < l_csp_mtltxn_rec.transaction_quantity Then

Line 1427: fnd_msg_pub.add;

1423: l_temp_id_to_be_processed := l_csp_mtltxn_rec.transaction_temp_id;
1424:
1425: Else -- this is an error.
1426: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');
1427: fnd_msg_pub.add;
1428: RAISE EXCP_USER_DEFINED;
1429: End If;
1430:
1431: l_csp_mtltxn_over_rec.creation_date := sysdate;

Line 1486: fnd_msg_pub.add;

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
1490: IF nvl(p_lot_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN

Line 1493: fnd_msg_pub.add;

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:
1497: DECLARE

Line 1510: fnd_msg_pub.add;

1506: OPEN l_Get_Mtlt;
1507: FETCH l_Get_Mtlt INTO l_mtlt_tbl(l_index);
1508: IF l_Get_Mtlt%rowcount = 0 THEN
1509: fnd_message.set_name ('CSP', 'CSP_NO_LOT_TXN_RECORD');
1510: fnd_msg_pub.add;
1511: CLOSE l_Get_Mtlt;
1512: RAISE EXCP_USER_DEFINED;
1513: END IF;
1514: CLOSE l_Get_Mtlt;

Line 1531: fnd_msg_pub.add;

1527: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1528: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
1529: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1530: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
1531: fnd_msg_pub.add;
1532: RAISE EXCP_USER_DEFINED;
1533: END IF;
1534:
1535: EXCEPTION

Line 1539: fnd_msg_pub.add;

1535: EXCEPTION
1536: WHEN NO_DATA_FOUND THEN
1537: fnd_message.set_name ('CSP', 'CSP_OVER_RECEIPT_LOT_QTY');
1538: fnd_message.set_token ('LOT_NUMBER', p_lot_number, FALSE);
1539: fnd_msg_pub.add;
1540: RAISE EXCP_USER_DEFINED;
1541: WHEN OTHERS THEN
1542: RAISE EXCP_USER_DEFINED;
1543: END;

Line 1575: fnd_msg_pub.add;

1571: WHEN OTHERS THEN
1572: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1573: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1574: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1575: fnd_msg_pub.add;
1576: RAISE EXCP_USER_DEFINED;
1577: END;
1578:
1579: -- Update order line status and order header status

Line 1640: fnd_msg_pub.add;

1636: WHEN OTHERS THEN
1637: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1638: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1639: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1640: fnd_msg_pub.add;
1641: RAISE EXCP_USER_DEFINED;
1642: END;
1643:
1644: -- update order line status and order header status

Line 1678: fnd_msg_pub.add;

1674: l_recv_less_than_txn := fnd_api.g_true;
1675:
1676: IF p_receiving_option NOT IN (0, 1) THEN
1677: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');
1678: fnd_msg_pub.add;
1679: RAISE EXCP_USER_DEFINED;
1680: END IF;
1681: l_csp_mtltxn_bak_rec := l_csp_mtltxn_rec;
1682:

Line 1832: fnd_msg_pub.add;

1828: IF NOT fnd_api.to_boolean(l_serial_lot_flag) AND
1829: l_Get_Packlist_SL%rowcount <> 0 THEN
1830: fnd_message.set_name ('CSP', 'CSP_NO_SERIAL_LOT_PACKLIST');
1831: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1832: fnd_msg_pub.add;
1833: CLOSE l_Get_Packlist_SL;
1834: RAISE EXCP_USER_DEFINED;
1835: END IF;
1836: IF l_Get_Packlist_SL%ISOPEN THEN

Line 1851: fnd_msg_pub.add;

1847: Close l_Get_Org_Qty_Csr;
1848:
1849: If l_org_received_qty < 0 Then
1850: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');
1851: fnd_msg_pub.add;
1852: RAISE EXCP_USER_DEFINED;
1853: End If;
1854:
1855: -- Now we need to do a misc. issue of which the txn qty = l_org_received_qty - p_quantity_received

Line 1957: fnd_msg_pub.add;

1953: IF NOT fnd_api.to_boolean(l_serial_lot_flag) AND
1954: l_Get_Packlist_SL%rowcount <> 0 THEN
1955: fnd_message.set_name ('CSP', 'CSP_NO_SERIAL_LOT_PACKLIST');
1956: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1957: fnd_msg_pub.add;
1958: CLOSE l_Get_Packlist_SL;
1959: RAISE EXCP_USER_DEFINED;
1960: END IF;
1961: IF l_Get_Packlist_SL%ISOPEN THEN

Line 2086: fnd_msg_pub.add;

2082: Fetch l_Get_Packlist_Csr Into l_packlist_headers_rec;
2083: If l_Get_Packlist_Csr%NOTFOUND Then
2084: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_LINE');
2085: fnd_message.set_token ('LINE_ID', to_char(p_packlist_line_id), FALSE);
2086: fnd_msg_pub.add;
2087: Close l_Get_Packlist_Csr;
2088: RAISE EXCP_USER_DEFINED;
2089: Else
2090: Close l_Get_Packlist_Csr;

Line 2164: fnd_msg_pub.count_and_get

2160: END IF;
2161: x_return_status := FND_API.G_RET_STS_SUCCESS;
2162:
2163: <>
2164: fnd_msg_pub.count_and_get
2165: ( p_count => x_msg_count
2166: , p_data => x_msg_data);
2167: EXCEPTION
2168: WHEN EXCP_USER_DEFINED THEN

Line 2171: fnd_msg_pub.count_and_get

2167: EXCEPTION
2168: WHEN EXCP_USER_DEFINED THEN
2169: Rollback to confirm_receipt_PUB;
2170: x_return_status := FND_API.G_RET_STS_ERROR;
2171: fnd_msg_pub.count_and_get
2172: ( p_count => x_msg_count
2173: , p_data => x_msg_data);
2174: WHEN FND_API.G_EXC_ERROR THEN
2175: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 2178: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2174: WHEN FND_API.G_EXC_ERROR THEN
2175: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2176: P_API_NAME => L_API_NAME
2177: ,P_PKG_NAME => G_PKG_NAME
2178: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2179: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2180: ,X_MSG_COUNT => X_MSG_COUNT
2181: ,X_MSG_DATA => X_MSG_DATA
2182: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2187: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2184: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2185: P_API_NAME => L_API_NAME
2186: ,P_PKG_NAME => G_PKG_NAME
2187: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2188: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2189: ,X_MSG_COUNT => X_MSG_COUNT
2190: ,X_MSG_DATA => X_MSG_DATA
2191: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2197: fnd_msg_pub.add;

2193: Rollback to confirm_receipt_PUB;
2194: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2195: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
2196: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
2197: fnd_msg_pub.add;
2198: fnd_msg_pub.count_and_get
2199: ( p_count => x_msg_count
2200: , p_data => x_msg_data);
2201: x_return_status := fnd_api.g_ret_sts_error;

Line 2198: fnd_msg_pub.count_and_get

2194: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2195: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
2196: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
2197: fnd_msg_pub.add;
2198: fnd_msg_pub.count_and_get
2199: ( p_count => x_msg_count
2200: , p_data => x_msg_data);
2201: x_return_status := fnd_api.g_ret_sts_error;
2202: END confirm_receipt;

Line 2418: fnd_msg_pub.add;

2414: OPEN l_ml_records;
2415: FETCH l_ml_records INTO l_csp_mtltxn_rec;
2416: IF l_ml_records%NOTFOUND THEN
2417: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');
2418: fnd_msg_pub.add;
2419: CLOSE l_ml_records;
2420: RAISE FND_API.G_EXC_ERROR;
2421: END IF;
2422: CLOSE l_ml_records;

Line 2451: FND_MSG_PUB.ADD;

2447: where transaction_temp_id = l_Serial_Temp_Id_Del;
2448: End Loop;
2449: If l_Get_Serial_Lot_id_Csr%ROWCOUNT = 0 Then
2450: FND_MESSAGE.SET_NAME('CSP', 'CSP_RECEIPT_SERIAL_LOT_FAILURE');
2451: FND_MSG_PUB.ADD;
2452: Close l_Get_Serial_Lot_id_Csr;
2453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2454: End If;
2455:

Line 2485: fnd_msg_pub.add;

2481: WHEN OTHERS THEN
2482: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2483: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
2484: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
2485: fnd_msg_pub.add;
2486: Return fnd_api.g_false;
2487: END Clean_Up;
2488:
2489: Function Call_Online (p_transaction_header_id NUMBER)

Line 2525: FND_MSG_PUB.ADD;

2521: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');
2522: --FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, FALSE);
2523: -- FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);
2524: FND_MESSAGE.SET_TOKEN('TRANSACTION_HEADER_ID', to_char(p_transaction_header_id), FALSE);
2525: FND_MSG_PUB.ADD;
2526: CLOSE l_Get_Interface_Csr;
2527: Return l_outcome;
2528: Else
2529: Begin

Line 2808: fnd_msg_pub.add;

2804: ORDER BY TRANSACTION_QUANTITY DESC;
2805: BEGIN
2806: IF p_receiving_option NOT IN (1, 2, 3) THEN
2807: fnd_message.set_name('CSP', 'CSP_INVALID_OVER_RECEIPT_QTY');
2808: fnd_msg_pub.add;
2809: RAISE EXCP_USER_DEFINED;
2810: END IF;
2811:
2812: OPEN l_ml_records;

Line 2816: fnd_msg_pub.add;

2812: OPEN l_ml_records;
2813: FETCH l_ml_records INTO l_csp_mtltxn_rec;
2814: IF l_ml_records%NOTFOUND THEN
2815: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');
2816: fnd_msg_pub.add;
2817: CLOSE l_ml_records;
2818: RAISE FND_API.G_EXC_ERROR;
2819: END IF;
2820: CLOSE l_ml_records;

Line 2826: fnd_msg_pub.add;

2822: l_csp_mtltxn_rec.distribution_account_id := Get_CSP_Acccount_ID (l_csp_mtltxn_rec.organization_id);
2823:
2824: IF l_csp_mtltxn_rec.distribution_account_id IS NULL THEN
2825: fnd_message.set_name('CSP', 'CSP_RECEIPT_ACCOUNT_NOT_FOUND');
2826: fnd_msg_pub.add;
2827: RAISE FND_API.G_EXC_ERROR;
2828: END IF;
2829:
2830: IF p_receiving_option = 1 THEN -- receiving short

Line 3036: fnd_msg_pub.add;

3032: If (SQL%NOTFOUND) then
3033: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3034: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3035: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3036: fnd_msg_pub.add;
3037: CLOSE l_Get_Msnt;
3038: RAISE EXCP_USER_DEFINED;
3039: End If;
3040:

Line 3060: fnd_msg_pub.add;

3056: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3057: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3058: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3059: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3060: fnd_msg_pub.add;
3061: CLOSE l_Get_Msnt;
3062: RAISE EXCP_USER_DEFINED;
3063: END IF;
3064:

Line 3083: fnd_msg_pub.add;

3079: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3080: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3081: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3082: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3083: fnd_msg_pub.add;
3084: CLOSE l_Get_Msnt;
3085: RAISE EXCP_USER_DEFINED;
3086: END IF;
3087:

Line 3114: fnd_msg_pub.add;

3110: If (SQL%NOTFOUND) then
3111: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3112: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3113: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3114: fnd_msg_pub.add;
3115: CLOSE l_Get_Msnt;
3116: RAISE EXCP_USER_DEFINED;
3117: End If;
3118:

Line 3137: fnd_msg_pub.add;

3133: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3134: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3135: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3136: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3137: fnd_msg_pub.add;
3138: CLOSE l_Get_Msnt;
3139: RAISE EXCP_USER_DEFINED;
3140: END IF;
3141:

Line 3168: fnd_msg_pub.add;

3164: If (SQL%NOTFOUND) then
3165: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3166: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3167: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3168: fnd_msg_pub.add;
3169: CLOSE l_Get_Msnt;
3170: RAISE EXCP_USER_DEFINED;
3171: End If;
3172:

Line 3191: fnd_msg_pub.add;

3187: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3188: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3189: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3190: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3191: fnd_msg_pub.add;
3192: CLOSE l_Get_Msnt;
3193: RAISE EXCP_USER_DEFINED;
3194: END IF;
3195:

Line 3219: fnd_msg_pub.add;

3215: If (SQL%NOTFOUND) then
3216: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3217: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3218: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3219: fnd_msg_pub.add;
3220: CLOSE l_Get_Msnt;
3221: RAISE EXCP_USER_DEFINED;
3222: End If;
3223:

Line 3254: fnd_msg_pub.add;

3250: If (SQL%NOTFOUND) then
3251: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3252: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3253: fnd_message.set_token ('TABLE', 'Mtl_Serial_Numbers_Temp', FALSE);
3254: fnd_msg_pub.add;
3255: CLOSE l_Get_Msnt;
3256: RAISE EXCP_USER_DEFINED;
3257: End If;
3258: exit;

Line 3269: fnd_msg_pub.add;

3265:
3266: IF (l_Get_Msnt%rowcount = 0 AND p_serial_number IS NOT NULL) OR
3267: (l_Get_Msnt%rowcount <> 0 AND NOT fnd_api.to_boolean(l_done_flag)) THEN
3268: fnd_message.set_name ('CSP', 'CSP_NO_SERIAL_TXN_RECORD');
3269: fnd_msg_pub.add;
3270: IF l_Get_Msnt%ISOPEN THEN
3271: CLOSE l_Get_Msnt;
3272: END IF;
3273: RAISE EXCP_USER_DEFINED;

Line 3307: fnd_msg_pub.add;

3303: -- This loop only loops once if everything is correct. Otherwise, exceptions should be thrown.
3304: FETCH l_Get_Mtlt_Lot_No INTO l_mtlt_tbl(l_index);
3305: IF l_Get_Mtlt_Lot_No%rowcount = 0 THEN
3306: fnd_message.set_name ('CSP', 'CSP_NO_LOT_TXN_RECORD');
3307: fnd_msg_pub.add;
3308: CLOSE l_Get_Mtlt_Lot_No;
3309: RAISE EXCP_USER_DEFINED;
3310: END IF;
3311:

Line 3334: fnd_msg_pub.add;

3330: If (SQL%NOTFOUND) then
3331: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3332: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3333: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3334: fnd_msg_pub.add;
3335: CLOSE l_Get_Mtlt;
3336: RAISE EXCP_USER_DEFINED;
3337: End If;
3338:

Line 3361: fnd_msg_pub.add;

3357: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3358: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3359: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3360: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3361: fnd_msg_pub.add;
3362: CLOSE l_Get_Mtlt;
3363: RAISE EXCP_USER_DEFINED;
3364: ELSE
3365: -- transact the serial number

Line 3374: fnd_msg_pub.add;

3370: ELSIF l_quantity_remained < 0 THEN
3371: -- For serial controlled items that are also under lot-control, this case should not
3372: -- happen because confirm receipt is transacting one serial number at time.
3373: fnd_message.set_name ('CSP', 'CSP_INVALID_SERIAL_QTY');
3374: fnd_msg_pub.add;
3375: --l_msg_data := 'Unexpected errors.';
3376: CLOSE l_Get_Mtlt;
3377: RAISE EXCP_USER_DEFINED;
3378:

Line 3385: fnd_msg_pub.add;

3381: -- The p_quantity_received must be 1 when the item is under serial control.
3382: -- If the serial number in the msnt is the last one to be transacted
3383: -- i.e. when fm_serial_number = to_serial_number, the l_serial_case should be 1.
3384: fnd_message.set_name ('CSP', 'CSP_INVALID_SERIAL_QTY');
3385: fnd_msg_pub.add;
3386: CLOSE l_Get_Mtlt;
3387: RAISE EXCP_USER_DEFINED;
3388:
3389: END IF;

Line 3416: fnd_msg_pub.add;

3412: If (SQL%NOTFOUND) then
3413: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3414: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3415: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3416: fnd_msg_pub.add;
3417: CLOSE l_Get_Mtlt;
3418: RAISE EXCP_USER_DEFINED;
3419: End If;
3420:

Line 3436: fnd_msg_pub.add;

3432: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3433: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3434: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3435: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3436: fnd_msg_pub.add;
3437: CLOSE l_Get_Mtlt;
3438: RAISE EXCP_USER_DEFINED;
3439: END IF;
3440: exit; -- exit the loop because the quantity_received is less than the transaction_quantity

Line 3456: fnd_msg_pub.add;

3452: If (SQL%NOTFOUND) then
3453: fnd_message.set_name ('CSP', 'CSP_EXEC_FAILED_IN_TBL');
3454: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3455: fnd_message.set_token ('TABLE', 'Mtl_Transaction_Lots_Temp', FALSE);
3456: fnd_msg_pub.add;
3457: CLOSE l_Get_Mtlt;
3458: RAISE EXCP_USER_DEFINED;
3459: End If;
3460: END IF;

Line 3465: fnd_msg_pub.add;

3461: END LOOP;
3462:
3463: IF l_Get_Mtlt%rowcount = 0 THEN
3464: fnd_message.set_name ('CSP', 'CSP_NO_LOT_TXN_RECORD');
3465: fnd_msg_pub.add;
3466: --l_msg_data := 'Could not find any records in the mtl_transaction_lots_temp table.';
3467: CLOSE l_Get_Mtlt;
3468: RAISE EXCP_USER_DEFINED;
3469: END IF;

Line 3479: fnd_msg_pub.count_and_get

3475: Else
3476: NULL;
3477: End if;
3478: x_return_status := FND_API.G_RET_STS_SUCCESS;
3479: fnd_msg_pub.count_and_get
3480: ( p_count => x_msg_count
3481: , p_data => x_msg_data);
3482: EXCEPTION
3483: WHEN EXCP_USER_DEFINED THEN

Line 3486: fnd_msg_pub.count_and_get

3482: EXCEPTION
3483: WHEN EXCP_USER_DEFINED THEN
3484: Rollback to Transact_Serial_Lots_PUB;
3485: x_return_status := FND_API.G_RET_STS_ERROR;
3486: fnd_msg_pub.count_and_get
3487: ( p_count => x_msg_count
3488: , p_data => x_msg_data);
3489: WHEN FND_API.G_EXC_ERROR THEN
3490: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 3493: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3489: WHEN FND_API.G_EXC_ERROR THEN
3490: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3491: P_API_NAME => L_API_NAME
3492: ,P_PKG_NAME => G_PKG_NAME
3493: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3494: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3495: ,X_MSG_COUNT => X_MSG_COUNT
3496: ,X_MSG_DATA => X_MSG_DATA
3497: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3499: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3500: P_API_NAME => L_API_NAME
3501: ,P_PKG_NAME => G_PKG_NAME
3502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3503: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3504: ,X_MSG_COUNT => X_MSG_COUNT
3505: ,X_MSG_DATA => X_MSG_DATA
3506: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3512: fnd_msg_pub.add;

3508: Rollback to Transact_Serial_Lots_PUB;
3509: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3510: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3511: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
3512: fnd_msg_pub.add;
3513: fnd_msg_pub.count_and_get
3514: ( p_count => x_msg_count
3515: , p_data => x_msg_data);
3516: x_return_status := fnd_api.g_ret_sts_error;

Line 3513: fnd_msg_pub.count_and_get

3509: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3510: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
3511: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
3512: fnd_msg_pub.add;
3513: fnd_msg_pub.count_and_get
3514: ( p_count => x_msg_count
3515: , p_data => x_msg_data);
3516: x_return_status := fnd_api.g_ret_sts_error;
3517: END Transact_Serial_Lots;

Line 3541: fnd_msg_pub.add;

3537: IF p_csp_mtltxn_rec.primary_quantity = -99999 THEN
3538: fnd_message.set_name ('INV', 'INV_INVALID_UOM_CONV');
3539: fnd_message.set_token ('VALUE1', p_csp_mtltxn_rec.transaction_uom, TRUE);
3540: fnd_message.set_token ('VALUE2', p_csp_mtltxn_rec.item_primary_uom_code, TRUE);
3541: fnd_msg_pub.add;
3542: RETURN fnd_api.g_false;
3543: END IF;
3544: END IF;
3545: RETURN fnd_api.g_true;