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_TRANSACTIONS_PUB dependencies on FND_MESSAGE

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

169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170:
171: -- check organization
172: IF p_organization_id IS NULL THEN
173: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
174: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
175: FND_MSG_PUB.ADD;
176: RAISE EXCP_USER_DEFINED;
177: END IF;

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

170:
171: -- check organization
172: IF p_organization_id IS NULL THEN
173: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
174: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
175: FND_MSG_PUB.ADD;
176: RAISE EXCP_USER_DEFINED;
177: END IF;
178:

Line 187: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');

183: FROM mtl_txn_request_headers
184: WHERE header_id = px_header_id
185: AND organization_id = p_organization_id;
186:
187: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');
188: FND_MESSAGE.SET_TOKEN('PARAMETER', 'px_header_id' , TRUE);
189: FND_MSG_PUB.ADD;
190: RAISE EXCP_USER_DEFINED;
191:

Line 188: FND_MESSAGE.SET_TOKEN('PARAMETER', 'px_header_id' , TRUE);

184: WHERE header_id = px_header_id
185: AND organization_id = p_organization_id;
186:
187: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');
188: FND_MESSAGE.SET_TOKEN('PARAMETER', 'px_header_id' , TRUE);
189: FND_MSG_PUB.ADD;
190: RAISE EXCP_USER_DEFINED;
191:
192: EXCEPTION

Line 325: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

321: ,X_MSG_DATA => X_MSG_DATA
322: ,X_RETURN_STATUS => X_RETURN_STATUS);
323: WHEN OTHERS THEN
324: Rollback to Create_Move_Order_Header_PUB;
325: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
326: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
327: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
328: FND_MSG_PUB.ADD;
329: fnd_msg_pub.count_and_get

Line 326: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

322: ,X_RETURN_STATUS => X_RETURN_STATUS);
323: WHEN OTHERS THEN
324: Rollback to Create_Move_Order_Header_PUB;
325: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
326: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
327: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
328: FND_MSG_PUB.ADD;
329: fnd_msg_pub.count_and_get
330: ( p_count => x_msg_count

Line 327: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

323: WHEN OTHERS THEN
324: Rollback to Create_Move_Order_Header_PUB;
325: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
326: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
327: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
328: FND_MSG_PUB.ADD;
329: fnd_msg_pub.count_and_get
330: ( p_count => x_msg_count
331: , p_data => x_msg_data);

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

409: x_return_status := FND_API.G_RET_STS_SUCCESS;
410:
411: -- check organization
412: IF p_organization_id IS NULL THEN
413: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
414: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
415: FND_MSG_PUB.ADD;
416: RAISE EXCP_USER_DEFINED;
417: END IF;

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

410:
411: -- check organization
412: IF p_organization_id IS NULL THEN
413: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
414: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
415: FND_MSG_PUB.ADD;
416: RAISE EXCP_USER_DEFINED;
417: END IF;
418:

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

416: RAISE EXCP_USER_DEFINED;
417: END IF;
418:
419: IF p_header_id IS NULL THEN
420: FND_MESSAGE.SET_NAME('CSP', 'CSP_MISSING_PARAMETERS');
421: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_header_id', TRUE);
422: FND_MSG_PUB.ADD;
423: RAISE EXCP_USER_DEFINED;
424: END IF;

Line 421: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_header_id', TRUE);

417: END IF;
418:
419: IF p_header_id IS NULL THEN
420: FND_MESSAGE.SET_NAME('CSP', 'CSP_MISSING_PARAMETERS');
421: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_header_id', TRUE);
422: FND_MSG_PUB.ADD;
423: RAISE EXCP_USER_DEFINED;
424: END IF;
425:

Line 434: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');

430: FROM mtl_txn_request_lines
431: WHERE line_id = px_line_id
432: AND organization_id = p_organization_id;
433:
434: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');
435: FND_MESSAGE.SET_TOKEN('PARAMETER', 'px_line_id' , TRUE);
436: FND_MSG_PUB.ADD;
437: RAISE EXCP_USER_DEFINED;
438:

Line 435: FND_MESSAGE.SET_TOKEN('PARAMETER', 'px_line_id' , TRUE);

431: WHERE line_id = px_line_id
432: AND organization_id = p_organization_id;
433:
434: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');
435: FND_MESSAGE.SET_TOKEN('PARAMETER', 'px_line_id' , TRUE);
436: FND_MSG_PUB.ADD;
437: RAISE EXCP_USER_DEFINED;
438:
439: EXCEPTION

Line 581: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

577: ,X_MSG_DATA => X_MSG_DATA
578: ,X_RETURN_STATUS => X_RETURN_STATUS);
579: WHEN OTHERS THEN
580: Rollback to Create_Move_Order_Line_PUB;
581: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
582: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
583: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
584: FND_MSG_PUB.ADD;
585: fnd_msg_pub.count_and_get

Line 582: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

578: ,X_RETURN_STATUS => X_RETURN_STATUS);
579: WHEN OTHERS THEN
580: Rollback to Create_Move_Order_Line_PUB;
581: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
582: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
583: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
584: FND_MSG_PUB.ADD;
585: fnd_msg_pub.count_and_get
586: ( p_count => x_msg_count

Line 583: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

579: WHEN OTHERS THEN
580: Rollback to Create_Move_Order_Line_PUB;
581: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
582: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
583: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
584: FND_MSG_PUB.ADD;
585: fnd_msg_pub.count_and_get
586: ( p_count => x_msg_count
587: , p_data => x_msg_data);

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

743: END IF;
744:
745: -- validating transaction_type_id
746: IF p_transaction_type_id IS NULL THEN
747: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
748: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_type_id', TRUE);
749: FND_MSG_PUB.ADD;
750: RAISE EXCP_USER_DEFINED;
751: END IF;

Line 748: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_type_id', TRUE);

744:
745: -- validating transaction_type_id
746: IF p_transaction_type_id IS NULL THEN
747: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
748: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_type_id', TRUE);
749: FND_MSG_PUB.ADD;
750: RAISE EXCP_USER_DEFINED;
751: END IF;
752:

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

751: END IF;
752:
753: -- validating organization
754: IF p_organization_id IS NULL THEN
755: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
756: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
757: FND_MSG_PUB.ADD;
758: RAISE EXCP_USER_DEFINED;
759: END IF;

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

752:
753: -- validating organization
754: IF p_organization_id IS NULL THEN
755: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
756: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
757: FND_MSG_PUB.ADD;
758: RAISE EXCP_USER_DEFINED;
759: END IF;
760:

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

760:
761: -- Check that item is an inventory_item, stockable, transactable and reservable
762: --
763: IF p_inventory_item_id IS NULL THEN
764: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
765: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id ', TRUE);
766: FND_MSG_PUB.ADD;
767: RAISE EXCP_USER_DEFINED;
768: ELSE

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

761: -- Check that item is an inventory_item, stockable, transactable and reservable
762: --
763: IF p_inventory_item_id IS NULL THEN
764: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
765: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id ', TRUE);
766: FND_MSG_PUB.ADD;
767: RAISE EXCP_USER_DEFINED;
768: ELSE
769: BEGIN

Line 777: fnd_message.set_name('INV', 'INV-NO ITEM RECROD');

773: where inventory_item_id = p_inventory_item_id
774: and organization_id = p_organization_id;
775: EXCEPTION
776: WHEN NO_DATA_FOUND THEN
777: fnd_message.set_name('INV', 'INV-NO ITEM RECROD');
778: fnd_msg_pub.add;
779: RAISE EXCP_USER_DEFINED;
780: WHEN OTHERS THEN
781: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

777: fnd_message.set_name('INV', 'INV-NO ITEM RECROD');
778: fnd_msg_pub.add;
779: RAISE EXCP_USER_DEFINED;
780: WHEN OTHERS THEN
781: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
782: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
783: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
784: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
785: FND_MSG_PUB.ADD;

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

778: fnd_msg_pub.add;
779: RAISE EXCP_USER_DEFINED;
780: WHEN OTHERS THEN
781: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
782: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
783: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
784: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
785: FND_MSG_PUB.ADD;
786: RAISE EXCP_USER_DEFINED;

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

779: RAISE EXCP_USER_DEFINED;
780: WHEN OTHERS THEN
781: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
782: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
783: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
784: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
785: FND_MSG_PUB.ADD;
786: RAISE EXCP_USER_DEFINED;
787: END;

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

780: WHEN OTHERS THEN
781: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
782: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
783: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
784: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
785: FND_MSG_PUB.ADD;
786: RAISE EXCP_USER_DEFINED;
787: END;
788: END IF;

Line 792: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');

788: END IF;
789:
790: --validating transaction_quantity
791: IF p_quantity IS NULL OR p_quantity < 0 THEN
792: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
793: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_quantity', TRUE);
794: fnd_msg_pub.add;
795: RAISE EXCP_USER_DEFINED;
796: END IF;

Line 793: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_quantity', TRUE);

789:
790: --validating transaction_quantity
791: IF p_quantity IS NULL OR p_quantity < 0 THEN
792: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
793: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_quantity', TRUE);
794: fnd_msg_pub.add;
795: RAISE EXCP_USER_DEFINED;
796: END IF;
797:

Line 800: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');

796: END IF;
797:
798: --validating transaction_uom
799: IF p_uom IS NULL THEN
800: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
801: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_uom', TRUE);
802: fnd_msg_pub.add;
803: RAISE EXCP_USER_DEFINED;
804: END IF;

Line 801: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_uom', TRUE);

797:
798: --validating transaction_uom
799: IF p_uom IS NULL THEN
800: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
801: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_uom', TRUE);
802: fnd_msg_pub.add;
803: RAISE EXCP_USER_DEFINED;
804: END IF;
805:

Line 827: fnd_message.set_name('CSP', 'CSP_INVALID_ACCOUNT');

823: AND gcc.code_combination_id = p_account_id;
824:
825: EXCEPTION
826: WHEN NO_DATA_FOUND THEN
827: fnd_message.set_name('CSP', 'CSP_INVALID_ACCOUNT');
828: fnd_msg_pub.add;
829: RAISE EXCP_USER_DEFINED;
830: WHEN OTHERS THEN
831: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

827: fnd_message.set_name('CSP', 'CSP_INVALID_ACCOUNT');
828: fnd_msg_pub.add;
829: RAISE EXCP_USER_DEFINED;
830: WHEN OTHERS THEN
831: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
832: fnd_message.set_token('ERR_FIELD', 'p_account_id', TRUE);
833: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
834: fnd_message.set_token('TABLE', 'GL_code_combinations', TRUE);
835: FND_MSG_PUB.ADD;

Line 832: fnd_message.set_token('ERR_FIELD', 'p_account_id', TRUE);

828: fnd_msg_pub.add;
829: RAISE EXCP_USER_DEFINED;
830: WHEN OTHERS THEN
831: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
832: fnd_message.set_token('ERR_FIELD', 'p_account_id', TRUE);
833: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
834: fnd_message.set_token('TABLE', 'GL_code_combinations', TRUE);
835: FND_MSG_PUB.ADD;
836: RAISE EXCP_USER_DEFINED;

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

829: RAISE EXCP_USER_DEFINED;
830: WHEN OTHERS THEN
831: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
832: fnd_message.set_token('ERR_FIELD', 'p_account_id', TRUE);
833: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
834: fnd_message.set_token('TABLE', 'GL_code_combinations', TRUE);
835: FND_MSG_PUB.ADD;
836: RAISE EXCP_USER_DEFINED;
837: END;

Line 834: fnd_message.set_token('TABLE', 'GL_code_combinations', TRUE);

830: WHEN OTHERS THEN
831: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
832: fnd_message.set_token('ERR_FIELD', 'p_account_id', TRUE);
833: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
834: fnd_message.set_token('TABLE', 'GL_code_combinations', TRUE);
835: FND_MSG_PUB.ADD;
836: RAISE EXCP_USER_DEFINED;
837: END;
838: END IF;

Line 845: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');

841: /* Removed the vaalidation of subinventory code by klou.
842: Subinvnetory code is a NULL column in the interface table.
843: --validating subinventory_code
844: IF p_subinventory_code IS NULL THEN
845: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
846: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_subinventory_code', TRUE);
847: fnd_msg_pub.add;
848: RAISE EXCP_USER_DEFINED;
849: END IF;

Line 846: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_subinventory_code', TRUE);

842: Subinvnetory code is a NULL column in the interface table.
843: --validating subinventory_code
844: IF p_subinventory_code IS NULL THEN
845: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
846: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_subinventory_code', TRUE);
847: fnd_msg_pub.add;
848: RAISE EXCP_USER_DEFINED;
849: END IF;
850: */

Line 914: fnd_message.set_name('INV','INV_SHIP_USED');

910: l_ship_number := Null;
911: End;
912:
913: If l_ship_number is Not Null then
914: fnd_message.set_name('INV','INV_SHIP_USED');
915: fnd_msg_pub.add;
916: RAISE EXCP_USER_DEFINED;
917: End if;
918:

Line 929: fnd_message.set_name('INV','INV_SHIP_USED');

925: l_ship_number := Null;
926: End;
927:
928: If l_ship_number is Not Null then
929: fnd_message.set_name('INV','INV_SHIP_USED');
930: fnd_msg_pub.add;
931: RAISE EXCP_USER_DEFINED;
932: End if;
933:

Line 944: fnd_message.set_name('INV','INV_SHIP_USED');

940: l_ship_number := Null;
941: End;
942:
943: If l_ship_number is Not Null then
944: fnd_message.set_name('INV','INV_SHIP_USED');
945: fnd_msg_pub.add;
946: RAISE EXCP_USER_DEFINED;
947: End if;
948:

Line 1204: l_error_explanation:= fnd_message.get;

1200: l_error_code := ' ';
1201: l_error_explanation := 'No Errors';
1202: l_outcome := true;
1203: WHEN TOO_MANY_ROWS THEN
1204: l_error_explanation:= fnd_message.get;
1205: l_outcome := false;
1206: WHEN OTHERS THEN
1207: l_outcome := false;
1208: END;

Line 1229: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');

1225: END IF;
1226:
1227: IF (l_outcome = FALSE) THEN
1228: delete from mtl_transactions_interface where transaction_header_id = l_transaction_header_id;
1229: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');
1230: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, TRUE);
1231: FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);
1232: FND_MSG_PUB.ADD;
1233: RAISE EXCP_USER_DEFINED;

Line 1230: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, TRUE);

1226:
1227: IF (l_outcome = FALSE) THEN
1228: delete from mtl_transactions_interface where transaction_header_id = l_transaction_header_id;
1229: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');
1230: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, TRUE);
1231: FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);
1232: FND_MSG_PUB.ADD;
1233: RAISE EXCP_USER_DEFINED;
1234: END IF;

Line 1231: FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);

1227: IF (l_outcome = FALSE) THEN
1228: delete from mtl_transactions_interface where transaction_header_id = l_transaction_header_id;
1229: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');
1230: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, TRUE);
1231: FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);
1232: FND_MSG_PUB.ADD;
1233: RAISE EXCP_USER_DEFINED;
1234: END IF;
1235: END IF;

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

1273: WHEN OTHERS THEN
1274: If l_outcome = true then
1275: Rollback to Transact_Material_Pub;
1276: end if;
1277: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1278: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1279: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1280: fnd_msg_pub.add;
1281: fnd_msg_pub.count_and_get

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

1274: If l_outcome = true then
1275: Rollback to Transact_Material_Pub;
1276: end if;
1277: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1278: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1279: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1280: fnd_msg_pub.add;
1281: fnd_msg_pub.count_and_get
1282: ( p_count => x_msg_count

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

1275: Rollback to Transact_Material_Pub;
1276: end if;
1277: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1278: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1279: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1280: fnd_msg_pub.add;
1281: fnd_msg_pub.count_and_get
1282: ( p_count => x_msg_count
1283: , p_data => x_msg_data);

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

1448: END IF;
1449:
1450: IF p_validation_level = fnd_api.g_valid_level_full THEN
1451: IF p_transaction_temp_id IS NULL THEN
1452: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1453: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_temp_id', FALSE);
1454: FND_MSG_PUB.ADD;
1455: RAISE EXCP_USER_DEFINED;
1456: ELSE

Line 1453: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_temp_id', FALSE);

1449:
1450: IF p_validation_level = fnd_api.g_valid_level_full THEN
1451: IF p_transaction_temp_id IS NULL THEN
1452: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1453: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_temp_id', FALSE);
1454: FND_MSG_PUB.ADD;
1455: RAISE EXCP_USER_DEFINED;
1456: ELSE
1457: BEGIN

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

1459: from mtl_material_transactions_temp
1460: where transaction_temp_id = p_transaction_temp_id;
1461: EXCEPTION
1462: WHEN NO_DATA_FOUND THEN
1463: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1464: fnd_message.set_token('ID', to_char(p_transaction_temp_id), FALSE);
1465: fnd_msg_pub.add;
1466: RAISE EXCP_USER_DEFINED;
1467: WHEN OTHERS THEN

Line 1464: fnd_message.set_token('ID', to_char(p_transaction_temp_id), FALSE);

1460: where transaction_temp_id = p_transaction_temp_id;
1461: EXCEPTION
1462: WHEN NO_DATA_FOUND THEN
1463: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1464: fnd_message.set_token('ID', to_char(p_transaction_temp_id), FALSE);
1465: fnd_msg_pub.add;
1466: RAISE EXCP_USER_DEFINED;
1467: WHEN OTHERS THEN
1468: RAISE TOO_MANY_ROWS; -- this will really go to OTHERS exception.

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

1483: Open l_Get_Temp_Csr;
1484: Fetch l_Get_Temp_Csr Into l_mtl_txn_temp_rec;
1485: If l_Get_Temp_Csr%NOTFOUND Then
1486: Close l_Get_Temp_Csr;
1487: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1488: fnd_message.set_token('ID', to_char(p_transaction_temp_id), FALSE);
1489: fnd_msg_pub.add;
1490: RAISE EXCP_USER_DEFINED;
1491: Else

Line 1488: fnd_message.set_token('ID', to_char(p_transaction_temp_id), FALSE);

1484: Fetch l_Get_Temp_Csr Into l_mtl_txn_temp_rec;
1485: If l_Get_Temp_Csr%NOTFOUND Then
1486: Close l_Get_Temp_Csr;
1487: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1488: fnd_message.set_token('ID', to_char(p_transaction_temp_id), FALSE);
1489: fnd_msg_pub.add;
1490: RAISE EXCP_USER_DEFINED;
1491: Else
1492: Close l_Get_Temp_Csr;

Line 1501: fnd_message.set_name ('CSP', 'CSP_MOVEORDER_LINE_NO_PARENT');

1497: Open l_Get_Mo_Header_id_csr(l_mtl_txn_temp_rec.move_order_line_id);
1498: Fetch l_Get_Mo_Header_id_csr Into l_Mo_header_id;
1499: If l_Get_Mo_header_id_csr%NOTFOUND THEN
1500: Close l_Get_Mo_header_id_csr;
1501: fnd_message.set_name ('CSP', 'CSP_MOVEORDER_LINE_NO_PARENT');
1502: fnd_message.set_token ('LINE_ID', to_char(l_mtl_txn_temp_rec.move_order_line_id), FALSE);
1503: fnd_msg_pub.add;
1504: End If;
1505:

Line 1502: fnd_message.set_token ('LINE_ID', to_char(l_mtl_txn_temp_rec.move_order_line_id), FALSE);

1498: Fetch l_Get_Mo_Header_id_csr Into l_Mo_header_id;
1499: If l_Get_Mo_header_id_csr%NOTFOUND THEN
1500: Close l_Get_Mo_header_id_csr;
1501: fnd_message.set_name ('CSP', 'CSP_MOVEORDER_LINE_NO_PARENT');
1502: fnd_message.set_token ('LINE_ID', to_char(l_mtl_txn_temp_rec.move_order_line_id), FALSE);
1503: fnd_msg_pub.add;
1504: End If;
1505:
1506: Close l_Get_Mo_header_id_csr;

Line 1568: fnd_message.set_name('CSP', 'CSP_NO_LOT_TXN_RECORD');

1564: End Loop; -- <>
1565:
1566: If l_Get_Lot_Temp_Csr%rowcount = 0 Then
1567: Close l_Get_Lot_Temp_Csr;
1568: fnd_message.set_name('CSP', 'CSP_NO_LOT_TXN_RECORD');
1569: fnd_msg_pub.add;
1570: RAISE EXCP_USER_DEFINED;
1571: End if;
1572:

Line 1641: fnd_message.set_name('CSP', 'CSP_NO_SERIAL_TXN_RECORD');

1637:
1638: If l_Get_Serial_Temp_Csr%rowcount = 0 Then
1639: Close l_Get_Lot_Temp_Csr;
1640: Close l_Get_Serial_Temp_Csr;
1641: fnd_message.set_name('CSP', 'CSP_NO_SERIAL_TXN_RECORD');
1642: fnd_msg_pub.add;
1643: RAISE EXCP_USER_DEFINED;
1644: End If;
1645:

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

1782: ,X_MSG_DATA => X_MSG_DATA
1783: ,X_RETURN_STATUS => X_RETURN_STATUS);
1784: WHEN OTHERS THEN
1785: Rollback to transact_temp_record_pub;
1786: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1787: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1788: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1789: fnd_msg_pub.add;
1790: fnd_msg_pub.count_and_get

Line 1787: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);

1783: ,X_RETURN_STATUS => X_RETURN_STATUS);
1784: WHEN OTHERS THEN
1785: Rollback to transact_temp_record_pub;
1786: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1787: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1788: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1789: fnd_msg_pub.add;
1790: fnd_msg_pub.count_and_get
1791: ( p_count => x_msg_count

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

1784: WHEN OTHERS THEN
1785: Rollback to transact_temp_record_pub;
1786: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1787: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1788: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1789: fnd_msg_pub.add;
1790: fnd_msg_pub.count_and_get
1791: ( p_count => x_msg_count
1792: , p_data => x_msg_data);