255: END IF;
256:
257: -- validate p_organization_id
258: IF p_organization_id IS NULL THEN
259: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
260: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
261: FND_MSG_PUB.ADD;
262: RAISE EXCP_USER_DEFINED;
263: ELSE
256:
257: -- validate p_organization_id
258: IF p_organization_id IS NULL THEN
259: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
260: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
261: FND_MSG_PUB.ADD;
262: RAISE EXCP_USER_DEFINED;
263: ELSE
264: BEGIN
266: from mtl_parameters
267: where organization_id = p_organization_id;
268: EXCEPTION
269: WHEN NO_DATA_FOUND THEN
270: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
271: FND_MSG_PUB.ADD;
272: RAISE EXCP_USER_DEFINED;
273: WHEN OTHERS THEN
274: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
270: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
271: FND_MSG_PUB.ADD;
272: RAISE EXCP_USER_DEFINED;
273: WHEN OTHERS THEN
274: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
275: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
276: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
277: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
278: FND_MSG_PUB.ADD;
271: FND_MSG_PUB.ADD;
272: RAISE EXCP_USER_DEFINED;
273: WHEN OTHERS THEN
274: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
275: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
276: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
277: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
278: FND_MSG_PUB.ADD;
279: RAISE EXCP_USER_DEFINED;
272: RAISE EXCP_USER_DEFINED;
273: WHEN OTHERS THEN
274: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
275: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
276: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
277: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
278: FND_MSG_PUB.ADD;
279: RAISE EXCP_USER_DEFINED;
280: END;
273: WHEN OTHERS THEN
274: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
275: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
276: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
277: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
278: FND_MSG_PUB.ADD;
279: RAISE EXCP_USER_DEFINED;
280: END;
281: END IF;
280: END;
281: END IF;
282:
283: IF p_action_code NOT IN (0, 1, 2) OR p_action_code IS NULL THEN
284: fnd_message.set_name ('INV', 'INV-INVALID ACTION');
285: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
286: fnd_msg_pub.add;
287: RAISE EXCP_USER_DEFINED;
288: END IF;
281: END IF;
282:
283: IF p_action_code NOT IN (0, 1, 2) OR p_action_code IS NULL THEN
284: fnd_message.set_name ('INV', 'INV-INVALID ACTION');
285: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
286: fnd_msg_pub.add;
287: RAISE EXCP_USER_DEFINED;
288: END IF;
289:
295: FROM mtl_material_transactions_temp
296: WHERE transaction_temp_id = px_transaction_temp_id
297: AND organization_id = p_organization_id;
298:
299: fnd_message.set_name ('CSP', 'CSP_DUPLICATE_RECORD');
300: fnd_msg_pub.add;
301: RAISE EXCP_USER_DEFINED;
302:
303: EXCEPTION
305: NULL;
306: END;
307: ELSIF p_action_code IN (1, 2) THEN
308: IF px_transaction_temp_id IS NULL THEN
309: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
310: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_transaction_temp_id', TRUE);
311: FND_MSG_PUB.ADD;
312: RAISE EXCP_USER_DEFINED;
313: ELSE
306: END;
307: ELSIF p_action_code IN (1, 2) THEN
308: IF px_transaction_temp_id IS NULL THEN
309: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
310: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_transaction_temp_id', TRUE);
311: FND_MSG_PUB.ADD;
312: RAISE EXCP_USER_DEFINED;
313: ELSE
314: BEGIN
317: where organization_id = p_organization_id
318: and transaction_temp_id = px_transaction_temp_id;
319: EXCEPTION
320: WHEN NO_DATA_FOUND THEN
321: fnd_message.set_name ('CSP', 'CSP_INVALID_TEMP_ID');
322: fnd_message.set_token ('ID', to_char(px_transaction_temp_id), TRUE);
323: fnd_msg_pub.add;
324: RAISE EXCP_USER_DEFINED;
325: WHEN EXCP_USER_DEFINED THEN
318: and transaction_temp_id = px_transaction_temp_id;
319: EXCEPTION
320: WHEN NO_DATA_FOUND THEN
321: fnd_message.set_name ('CSP', 'CSP_INVALID_TEMP_ID');
322: fnd_message.set_token ('ID', to_char(px_transaction_temp_id), TRUE);
323: fnd_msg_pub.add;
324: RAISE EXCP_USER_DEFINED;
325: WHEN EXCP_USER_DEFINED THEN
326: RAISE EXCP_USER_DEFINED;
324: RAISE EXCP_USER_DEFINED;
325: WHEN EXCP_USER_DEFINED THEN
326: RAISE EXCP_USER_DEFINED;
327: WHEN OTHERS THEN
328: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
329: fnd_message.set_token('ERR_FIELD', 'px_transaction_temp_id', TRUE);
330: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
331: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', TRUE);
332: FND_MSG_PUB.ADD;
325: WHEN EXCP_USER_DEFINED THEN
326: RAISE EXCP_USER_DEFINED;
327: WHEN OTHERS THEN
328: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
329: fnd_message.set_token('ERR_FIELD', 'px_transaction_temp_id', TRUE);
330: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
331: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', TRUE);
332: FND_MSG_PUB.ADD;
333: RAISE EXCP_USER_DEFINED;
326: RAISE EXCP_USER_DEFINED;
327: WHEN OTHERS THEN
328: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
329: fnd_message.set_token('ERR_FIELD', 'px_transaction_temp_id', TRUE);
330: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
331: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', TRUE);
332: FND_MSG_PUB.ADD;
333: RAISE EXCP_USER_DEFINED;
334: END;
327: WHEN OTHERS THEN
328: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
329: fnd_message.set_token('ERR_FIELD', 'px_transaction_temp_id', TRUE);
330: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
331: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', TRUE);
332: FND_MSG_PUB.ADD;
333: RAISE EXCP_USER_DEFINED;
334: END;
335: END IF;
337: END IF;
338:
339: --validating inventory_item_id
340: IF p_inventory_item_id IS NULL THEN
341: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
342: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id', TRUE);
343: FND_MSG_PUB.ADD;
344: RAISE EXCP_USER_DEFINED;
345: ELSE
338:
339: --validating inventory_item_id
340: IF p_inventory_item_id IS NULL THEN
341: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
342: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id', TRUE);
343: FND_MSG_PUB.ADD;
344: RAISE EXCP_USER_DEFINED;
345: ELSE
346: BEGIN
350: where inventory_item_id = p_inventory_item_id
351: and organization_id = p_organization_id;
352: EXCEPTION
353: WHEN NO_DATA_FOUND THEN
354: fnd_message.set_name ('INV', 'INV-NO ITEM RECORD');
355: fnd_msg_pub.add;
356: RAISE EXCP_USER_DEFINED;
357: WHEN OTHERS THEN
358: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
354: fnd_message.set_name ('INV', 'INV-NO ITEM RECORD');
355: fnd_msg_pub.add;
356: RAISE EXCP_USER_DEFINED;
357: WHEN OTHERS THEN
358: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
359: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
360: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
361: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
362: fnd_msg_pub.add;
355: fnd_msg_pub.add;
356: RAISE EXCP_USER_DEFINED;
357: WHEN OTHERS THEN
358: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
359: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
360: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
361: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
362: fnd_msg_pub.add;
363: RAISE EXCP_USER_DEFINED;
356: RAISE EXCP_USER_DEFINED;
357: WHEN OTHERS THEN
358: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
359: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
360: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
361: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
362: fnd_msg_pub.add;
363: RAISE EXCP_USER_DEFINED;
364: END;
357: WHEN OTHERS THEN
358: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
359: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
360: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
361: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
362: fnd_msg_pub.add;
363: RAISE EXCP_USER_DEFINED;
364: END;
365: END IF;
641: ,X_MSG_DATA => X_MSG_DATA
642: ,X_RETURN_STATUS => X_RETURN_STATUS);
643: WHEN OTHERS THEN
644: Rollback to Validate_And_Write_PUB;
645: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
646: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
647: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
648: fnd_msg_pub.add;
649: fnd_msg_pub.count_and_get
642: ,X_RETURN_STATUS => X_RETURN_STATUS);
643: WHEN OTHERS THEN
644: Rollback to Validate_And_Write_PUB;
645: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
646: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
647: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
648: fnd_msg_pub.add;
649: fnd_msg_pub.count_and_get
650: ( p_count => x_msg_count
643: WHEN OTHERS THEN
644: Rollback to Validate_And_Write_PUB;
645: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
646: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
647: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
648: fnd_msg_pub.add;
649: fnd_msg_pub.count_and_get
650: ( p_count => x_msg_count
651: , p_data => x_msg_data);
942: -- this procedure handle the validations except that they know what they are doing.
943:
944: -- validate p_organization_id
945: IF p_organization_id IS NULL THEN
946: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
947: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
948: FND_MSG_PUB.ADD;
949: RAISE EXCP_USER_DEFINED;
950: ELSE
943:
944: -- validate p_organization_id
945: IF p_organization_id IS NULL THEN
946: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
947: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
948: FND_MSG_PUB.ADD;
949: RAISE EXCP_USER_DEFINED;
950: ELSE
951: BEGIN
953: from mtl_parameters
954: where organization_id = p_organization_id;
955: EXCEPTION
956: WHEN NO_DATA_FOUND THEN
957: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
958: FND_MSG_PUB.ADD;
959: RAISE EXCP_USER_DEFINED;
960: WHEN OTHERS THEN
961: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
957: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
958: FND_MSG_PUB.ADD;
959: RAISE EXCP_USER_DEFINED;
960: WHEN OTHERS THEN
961: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
962: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
963: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
964: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
965: FND_MSG_PUB.ADD;
958: FND_MSG_PUB.ADD;
959: RAISE EXCP_USER_DEFINED;
960: WHEN OTHERS THEN
961: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
962: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
963: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
964: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
965: FND_MSG_PUB.ADD;
966: RAISE EXCP_USER_DEFINED;
959: RAISE EXCP_USER_DEFINED;
960: WHEN OTHERS THEN
961: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
962: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
963: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
964: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
965: FND_MSG_PUB.ADD;
966: RAISE EXCP_USER_DEFINED;
967: END;
960: WHEN OTHERS THEN
961: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
962: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
963: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
964: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
965: FND_MSG_PUB.ADD;
966: RAISE EXCP_USER_DEFINED;
967: END;
968: END IF;
988: and nvl(disable_date, sysdate + 1) > sysdate;
989:
990: EXCEPTION
991: WHEN NO_DATA_FOUND THEN
992: fnd_message.set_name ('CSP', 'CSP_INVALID_INTRANSIT_SUB');
993: fnd_msg_pub.add;
994: --l_msg_data := 'Validation of intransit subinventory failed. Please make sure a subinventory under the working organizatin is assigned to the CSP_INTRANSIT_SUBINVENTORY profile.';
995: RAISE EXCP_USER_DEFINED;
996: WHEN OTHERS THEN
993: fnd_msg_pub.add;
994: --l_msg_data := 'Validation of intransit subinventory failed. Please make sure a subinventory under the working organizatin is assigned to the CSP_INTRANSIT_SUBINVENTORY profile.';
995: RAISE EXCP_USER_DEFINED;
996: WHEN OTHERS THEN
997: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
998: fnd_message.set_token('ERR_FIELD', 'profile_option_value', TRUE);
999: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1000: fnd_message.set_token('TABLE', 'fnd_profile_option_values', TRUE);
1001: FND_MSG_PUB.ADD;
994: --l_msg_data := 'Validation of intransit subinventory failed. Please make sure a subinventory under the working organizatin is assigned to the CSP_INTRANSIT_SUBINVENTORY profile.';
995: RAISE EXCP_USER_DEFINED;
996: WHEN OTHERS THEN
997: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
998: fnd_message.set_token('ERR_FIELD', 'profile_option_value', TRUE);
999: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1000: fnd_message.set_token('TABLE', 'fnd_profile_option_values', TRUE);
1001: FND_MSG_PUB.ADD;
1002: RAISE EXCP_USER_DEFINED;
995: RAISE EXCP_USER_DEFINED;
996: WHEN OTHERS THEN
997: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
998: fnd_message.set_token('ERR_FIELD', 'profile_option_value', TRUE);
999: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1000: fnd_message.set_token('TABLE', 'fnd_profile_option_values', TRUE);
1001: FND_MSG_PUB.ADD;
1002: RAISE EXCP_USER_DEFINED;
1003: END;
996: WHEN OTHERS THEN
997: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
998: fnd_message.set_token('ERR_FIELD', 'profile_option_value', TRUE);
999: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1000: fnd_message.set_token('TABLE', 'fnd_profile_option_values', TRUE);
1001: FND_MSG_PUB.ADD;
1002: RAISE EXCP_USER_DEFINED;
1003: END;
1004:
1021: OPEN c_ml_records;
1022: FETCH c_ml_records into l_csp_mtltxn_rec;
1023:
1024: IF c_ml_records%NOTFOUND THEN
1025: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1026: fnd_message.set_token ('ID', to_char(p_transaction_temp_id), TRUE);
1027: fnd_msg_pub.add;
1028: close c_ml_records;
1029: RAISE EXCP_USER_DEFINED;
1022: FETCH c_ml_records into l_csp_mtltxn_rec;
1023:
1024: IF c_ml_records%NOTFOUND THEN
1025: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1026: fnd_message.set_token ('ID', to_char(p_transaction_temp_id), TRUE);
1027: fnd_msg_pub.add;
1028: close c_ml_records;
1029: RAISE EXCP_USER_DEFINED;
1030: END IF;
1124: p_PROCESSING_LEAD_TIME => NULL,
1125: p_POSTPROCESSING_LEAD_TIME => NULL);
1126:
1127: WHEN OTHERS THEN
1128: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1129: fnd_message.set_token('ERR_FIELD', 'secondary_inventory', TRUE);
1130: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1131: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', TRUE);
1132: FND_MSG_PUB.ADD;
1125: p_POSTPROCESSING_LEAD_TIME => NULL);
1126:
1127: WHEN OTHERS THEN
1128: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1129: fnd_message.set_token('ERR_FIELD', 'secondary_inventory', TRUE);
1130: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1131: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', TRUE);
1132: FND_MSG_PUB.ADD;
1133:
1126:
1127: WHEN OTHERS THEN
1128: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1129: fnd_message.set_token('ERR_FIELD', 'secondary_inventory', TRUE);
1130: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1131: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', TRUE);
1132: FND_MSG_PUB.ADD;
1133:
1134: IF c_ml_records%ISOPEN THEN
1127: WHEN OTHERS THEN
1128: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1129: fnd_message.set_token('ERR_FIELD', 'secondary_inventory', TRUE);
1130: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1131: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', TRUE);
1132: FND_MSG_PUB.ADD;
1133:
1134: IF c_ml_records%ISOPEN THEN
1135: close c_ml_records;
1158: );
1159:
1160:
1161: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1162: fnd_message.set_name ('CSP', 'CSP_SUB_TXFER_ERROR');
1163: fnd_msg_pub.add;
1164: IF c_ml_records%ISOPEN THEN
1165: close c_ml_records;
1166: END IF;
1224: X_Msg_Data => l_msg_data
1225: );
1226:
1227: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1228: fnd_message.set_name ('CSP', 'CSP_SUB_TXFER_ERROR');
1229: fnd_msg_pub.add;
1230: IF c_ml_records%ISOPEN THEN
1231: close c_ml_records;
1232: END IF;
1282: ,X_MSG_DATA => X_MSG_DATA
1283: ,X_RETURN_STATUS => X_RETURN_STATUS);
1284: WHEN OTHERS THEN
1285: Rollback to CSP_MO_LINES_MANUAL_PUB;
1286: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1287: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1288: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1289: fnd_msg_pub.add;
1290: fnd_msg_pub.count_and_get
1283: ,X_RETURN_STATUS => X_RETURN_STATUS);
1284: WHEN OTHERS THEN
1285: Rollback to CSP_MO_LINES_MANUAL_PUB;
1286: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1287: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1288: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1289: fnd_msg_pub.add;
1290: fnd_msg_pub.count_and_get
1291: ( p_count => x_msg_count
1284: WHEN OTHERS THEN
1285: Rollback to CSP_MO_LINES_MANUAL_PUB;
1286: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1287: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1288: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1289: fnd_msg_pub.add;
1290: fnd_msg_pub.count_and_get
1291: ( p_count => x_msg_count
1292: , p_data => x_msg_data);
1565: -- this procedure handle the validations except that they know what they are doing.
1566:
1567: -- validate p_organization_id
1568: IF p_organization_id IS NULL THEN
1569: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1570: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
1571: FND_MSG_PUB.ADD;
1572: RAISE EXCP_USER_DEFINED;
1573: ELSE
1566:
1567: -- validate p_organization_id
1568: IF p_organization_id IS NULL THEN
1569: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1570: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
1571: FND_MSG_PUB.ADD;
1572: RAISE EXCP_USER_DEFINED;
1573: ELSE
1574: BEGIN
1576: from mtl_parameters
1577: where organization_id = p_organization_id;
1578: EXCEPTION
1579: WHEN NO_DATA_FOUND THEN
1580: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
1581: FND_MSG_PUB.ADD;
1582: RAISE EXCP_USER_DEFINED;
1583: WHEN OTHERS THEN
1584: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1580: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
1581: FND_MSG_PUB.ADD;
1582: RAISE EXCP_USER_DEFINED;
1583: WHEN OTHERS THEN
1584: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1585: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
1586: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1587: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
1588: FND_MSG_PUB.ADD;
1581: FND_MSG_PUB.ADD;
1582: RAISE EXCP_USER_DEFINED;
1583: WHEN OTHERS THEN
1584: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1585: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
1586: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1587: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
1588: FND_MSG_PUB.ADD;
1589: RAISE EXCP_USER_DEFINED;
1582: RAISE EXCP_USER_DEFINED;
1583: WHEN OTHERS THEN
1584: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1585: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
1586: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1587: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
1588: FND_MSG_PUB.ADD;
1589: RAISE EXCP_USER_DEFINED;
1590: END;
1583: WHEN OTHERS THEN
1584: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1585: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
1586: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1587: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
1588: FND_MSG_PUB.ADD;
1589: RAISE EXCP_USER_DEFINED;
1590: END;
1591: END IF;
1591: END IF;
1592:
1593: -- validate p_move_order_line_id
1594: IF p_transaction_temp_id IS NULL THEN
1595: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1596: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_temp_id', TRUE);
1597: FND_MSG_PUB.ADD;
1598: RAISE EXCP_USER_DEFINED;
1599: ELSE
1592:
1593: -- validate p_move_order_line_id
1594: IF p_transaction_temp_id IS NULL THEN
1595: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1596: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_temp_id', TRUE);
1597: FND_MSG_PUB.ADD;
1598: RAISE EXCP_USER_DEFINED;
1599: ELSE
1600: DECLARE
1619: from csp_moveorder_headers
1620: where header_id = l_header_id;
1621:
1622: IF l_autoreceipt_flag <> 'Y' THEN
1623: fnd_message.set_name ('CSP', 'CSP_INVALID_AUTORECEIPT');
1624: fnd_msg_pub.add;
1625: RAISE EXCP_USER_DEFINED;
1626: END IF;
1627:
1628: EXCEPTION
1629: WHEN EXCP_USER_DEFINED THEN
1630: RAISE EXCP_USER_DEFINED;
1631: WHEN NO_DATA_FOUND THEN
1632: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');
1633: fnd_msg_pub.add;
1634: RAISE EXCP_USER_DEFINED;
1635: WHEN OTHERS THEN
1636: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1632: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');
1633: fnd_msg_pub.add;
1634: RAISE EXCP_USER_DEFINED;
1635: WHEN OTHERS THEN
1636: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1637: fnd_message.set_token('ERR_FIELD', 'autoreceipt_flag', TRUE);
1638: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1639: fnd_message.set_token('TABLE', 'csp_moveorder_headers', TRUE);
1640: FND_MSG_PUB.ADD;
1633: fnd_msg_pub.add;
1634: RAISE EXCP_USER_DEFINED;
1635: WHEN OTHERS THEN
1636: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1637: fnd_message.set_token('ERR_FIELD', 'autoreceipt_flag', TRUE);
1638: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1639: fnd_message.set_token('TABLE', 'csp_moveorder_headers', TRUE);
1640: FND_MSG_PUB.ADD;
1641: RAISE EXCP_USER_DEFINED;
1634: RAISE EXCP_USER_DEFINED;
1635: WHEN OTHERS THEN
1636: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1637: fnd_message.set_token('ERR_FIELD', 'autoreceipt_flag', TRUE);
1638: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1639: fnd_message.set_token('TABLE', 'csp_moveorder_headers', TRUE);
1640: FND_MSG_PUB.ADD;
1641: RAISE EXCP_USER_DEFINED;
1642: END;
1635: WHEN OTHERS THEN
1636: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1637: fnd_message.set_token('ERR_FIELD', 'autoreceipt_flag', TRUE);
1638: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1639: fnd_message.set_token('TABLE', 'csp_moveorder_headers', TRUE);
1640: FND_MSG_PUB.ADD;
1641: RAISE EXCP_USER_DEFINED;
1642: END;
1643: END IF;
1723: ,X_MSG_DATA => X_MSG_DATA
1724: ,X_RETURN_STATUS => X_RETURN_STATUS);
1725: WHEN OTHERS THEN
1726: Rollback to CSP_MO_Lines_Auto_PUB;
1727: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1728: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1729: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1730: fnd_msg_pub.add;
1731: fnd_msg_pub.count_and_get
1724: ,X_RETURN_STATUS => X_RETURN_STATUS);
1725: WHEN OTHERS THEN
1726: Rollback to CSP_MO_Lines_Auto_PUB;
1727: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1728: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1729: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1730: fnd_msg_pub.add;
1731: fnd_msg_pub.count_and_get
1732: ( p_count => x_msg_count
1725: WHEN OTHERS THEN
1726: Rollback to CSP_MO_Lines_Auto_PUB;
1727: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1728: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1729: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1730: fnd_msg_pub.add;
1731: fnd_msg_pub.count_and_get
1732: ( p_count => x_msg_count
1733: , p_data => x_msg_data);