DBA Data[Home] [Help]

APPS.CSP_PC_FORM_MTLTXNS dependencies on FND_MESSAGE

Line 259: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

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

Line 260: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);

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

Line 270: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');

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');

Line 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;

Line 275: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);

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;

Line 276: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

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;

Line 277: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);

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;

Line 284: fnd_message.set_name ('INV', 'INV-INVALID ACTION');

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;

Line 285: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);

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:

Line 299: fnd_message.set_name ('CSP', 'CSP_DUPLICATE_RECORD');

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

Line 309: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

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

Line 310: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_transaction_temp_id', TRUE);

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

Line 321: fnd_message.set_name ('CSP', 'CSP_INVALID_TEMP_ID');

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

Line 322: fnd_message.set_token ('ID', to_char(px_transaction_temp_id), TRUE);

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;

Line 328: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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;

Line 329: fnd_message.set_token('ERR_FIELD', 'px_transaction_temp_id', TRUE);

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;

Line 330: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

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;

Line 331: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', TRUE);

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;

Line 341: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

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

Line 342: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id', TRUE);

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

Line 354: fnd_message.set_name ('INV', 'INV-NO ITEM RECORD');

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');

Line 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;

Line 359: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);

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;

Line 360: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

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;

Line 361: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);

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;

Line 645: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

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

Line 646: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);

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

Line 647: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);

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);

Line 946: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

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

Line 947: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);

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

Line 957: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');

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');

Line 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;

Line 962: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);

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;

Line 963: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

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;

Line 964: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);

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;

Line 992: fnd_message.set_name ('CSP', 'CSP_INVALID_INTRANSIT_SUB');

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

Line 997: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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;

Line 998: fnd_message.set_token('ERR_FIELD', 'profile_option_value', TRUE);

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;

Line 999: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

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;

Line 1000: fnd_message.set_token('TABLE', 'fnd_profile_option_values', TRUE);

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:

Line 1025: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');

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;

Line 1026: fnd_message.set_token ('ID', to_char(p_transaction_temp_id), TRUE);

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;

Line 1128: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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;

Line 1129: fnd_message.set_token('ERR_FIELD', 'secondary_inventory', TRUE);

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:

Line 1130: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

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

Line 1131: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', TRUE);

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;

Line 1162: fnd_message.set_name ('CSP', 'CSP_SUB_TXFER_ERROR');

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;

Line 1228: fnd_message.set_name ('CSP', 'CSP_SUB_TXFER_ERROR');

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;

Line 1286: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

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

Line 1287: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);

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

Line 1288: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);

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);

Line 1569: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

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

Line 1570: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);

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

Line 1580: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');

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');

Line 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;

Line 1585: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);

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;

Line 1586: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

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;

Line 1587: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);

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;

Line 1595: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

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

Line 1596: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_temp_id', TRUE);

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

Line 1623: fnd_message.set_name ('CSP', 'CSP_INVALID_AUTORECEIPT');

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:

Line 1632: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');

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');

Line 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;

Line 1637: fnd_message.set_token('ERR_FIELD', 'autoreceipt_flag', TRUE);

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;

Line 1638: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

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;

Line 1639: fnd_message.set_token('TABLE', 'csp_moveorder_headers', TRUE);

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;

Line 1727: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

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

Line 1728: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);

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

Line 1729: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);

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);