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 228: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:
226: -- check organization
227: IF p_organization_id IS NULL THEN
228: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
229: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
230: FND_MSG_PUB.ADD;
231: RAISE EXCP_USER_DEFINED;
232: END IF;

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

225:
226: -- check organization
227: IF p_organization_id IS NULL THEN
228: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
229: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
230: FND_MSG_PUB.ADD;
231: RAISE EXCP_USER_DEFINED;
232: END IF;
233:

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

238: FROM mtl_txn_request_headers
239: WHERE header_id = px_header_id
240: AND organization_id = p_organization_id;
241:
242: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');
243: FND_MESSAGE.SET_TOKEN('PARAMETER', 'px_header_id' , TRUE);
244: FND_MSG_PUB.ADD;
245: RAISE EXCP_USER_DEFINED;
246:

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

239: WHERE header_id = px_header_id
240: AND organization_id = p_organization_id;
241:
242: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');
243: FND_MESSAGE.SET_TOKEN('PARAMETER', 'px_header_id' , TRUE);
244: FND_MSG_PUB.ADD;
245: RAISE EXCP_USER_DEFINED;
246:
247: EXCEPTION

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

376: ,X_MSG_DATA => X_MSG_DATA
377: ,X_RETURN_STATUS => X_RETURN_STATUS);
378: WHEN OTHERS THEN
379: Rollback to Create_Move_Order_Header_PUB;
380: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
381: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
382: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
383: FND_MSG_PUB.ADD;
384: fnd_msg_pub.count_and_get

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

377: ,X_RETURN_STATUS => X_RETURN_STATUS);
378: WHEN OTHERS THEN
379: Rollback to Create_Move_Order_Header_PUB;
380: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
381: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
382: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
383: FND_MSG_PUB.ADD;
384: fnd_msg_pub.count_and_get
385: ( p_count => x_msg_count

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

378: WHEN OTHERS THEN
379: Rollback to Create_Move_Order_Header_PUB;
380: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
381: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
382: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
383: FND_MSG_PUB.ADD;
384: fnd_msg_pub.count_and_get
385: ( p_count => x_msg_count
386: , p_data => x_msg_data);

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

464: x_return_status := FND_API.G_RET_STS_SUCCESS;
465:
466: -- check organization
467: IF p_organization_id IS NULL THEN
468: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
469: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
470: FND_MSG_PUB.ADD;
471: RAISE EXCP_USER_DEFINED;
472: END IF;

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

465:
466: -- check organization
467: IF p_organization_id IS NULL THEN
468: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
469: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
470: FND_MSG_PUB.ADD;
471: RAISE EXCP_USER_DEFINED;
472: END IF;
473:

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

471: RAISE EXCP_USER_DEFINED;
472: END IF;
473:
474: IF p_header_id IS NULL THEN
475: FND_MESSAGE.SET_NAME('CSP', 'CSP_MISSING_PARAMETERS');
476: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_header_id', TRUE);
477: FND_MSG_PUB.ADD;
478: RAISE EXCP_USER_DEFINED;
479: END IF;

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

472: END IF;
473:
474: IF p_header_id IS NULL THEN
475: FND_MESSAGE.SET_NAME('CSP', 'CSP_MISSING_PARAMETERS');
476: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_header_id', TRUE);
477: FND_MSG_PUB.ADD;
478: RAISE EXCP_USER_DEFINED;
479: END IF;
480:

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

485: FROM mtl_txn_request_lines
486: WHERE line_id = px_line_id
487: AND organization_id = p_organization_id;
488:
489: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');
490: FND_MESSAGE.SET_TOKEN('PARAMETER', 'px_line_id' , TRUE);
491: FND_MSG_PUB.ADD;
492: RAISE EXCP_USER_DEFINED;
493:

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

486: WHERE line_id = px_line_id
487: AND organization_id = p_organization_id;
488:
489: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');
490: FND_MESSAGE.SET_TOKEN('PARAMETER', 'px_line_id' , TRUE);
491: FND_MSG_PUB.ADD;
492: RAISE EXCP_USER_DEFINED;
493:
494: EXCEPTION

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

632: ,X_MSG_DATA => X_MSG_DATA
633: ,X_RETURN_STATUS => X_RETURN_STATUS);
634: WHEN OTHERS THEN
635: Rollback to Create_Move_Order_Line_PUB;
636: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
637: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
638: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
639: FND_MSG_PUB.ADD;
640: fnd_msg_pub.count_and_get

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

633: ,X_RETURN_STATUS => X_RETURN_STATUS);
634: WHEN OTHERS THEN
635: Rollback to Create_Move_Order_Line_PUB;
636: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
637: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
638: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
639: FND_MSG_PUB.ADD;
640: fnd_msg_pub.count_and_get
641: ( p_count => x_msg_count

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

634: WHEN OTHERS THEN
635: Rollback to Create_Move_Order_Line_PUB;
636: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
637: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
638: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
639: FND_MSG_PUB.ADD;
640: fnd_msg_pub.count_and_get
641: ( p_count => x_msg_count
642: , p_data => x_msg_data);

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

868: END IF;
869:
870: -- validating transaction_type_id
871: IF p_transaction_type_id IS NULL THEN
872: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
873: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_type_id', TRUE);
874: FND_MSG_PUB.ADD;
875: RAISE EXCP_USER_DEFINED;
876: END IF;

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

869:
870: -- validating transaction_type_id
871: IF p_transaction_type_id IS NULL THEN
872: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
873: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_type_id', TRUE);
874: FND_MSG_PUB.ADD;
875: RAISE EXCP_USER_DEFINED;
876: END IF;
877:

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

876: END IF;
877:
878: -- validating organization
879: IF p_organization_id IS NULL THEN
880: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
881: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
882: FND_MSG_PUB.ADD;
883: RAISE EXCP_USER_DEFINED;
884: END IF;

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

877:
878: -- validating organization
879: IF p_organization_id IS NULL THEN
880: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
881: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
882: FND_MSG_PUB.ADD;
883: RAISE EXCP_USER_DEFINED;
884: END IF;
885:

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

885:
886: -- Check that item is an inventory_item, stockable, transactable and reservable
887: --
888: IF p_inventory_item_id IS NULL THEN
889: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
890: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id ', TRUE);
891: FND_MSG_PUB.ADD;
892: RAISE EXCP_USER_DEFINED;
893: ELSE

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

886: -- Check that item is an inventory_item, stockable, transactable and reservable
887: --
888: IF p_inventory_item_id IS NULL THEN
889: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
890: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id ', TRUE);
891: FND_MSG_PUB.ADD;
892: RAISE EXCP_USER_DEFINED;
893: ELSE
894: BEGIN

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

898: where inventory_item_id = p_inventory_item_id
899: and organization_id = p_organization_id;
900: EXCEPTION
901: WHEN NO_DATA_FOUND THEN
902: fnd_message.set_name('INV', 'INV-NO ITEM RECROD');
903: fnd_msg_pub.add;
904: RAISE EXCP_USER_DEFINED;
905: WHEN OTHERS THEN
906: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

902: fnd_message.set_name('INV', 'INV-NO ITEM RECROD');
903: fnd_msg_pub.add;
904: RAISE EXCP_USER_DEFINED;
905: WHEN OTHERS THEN
906: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
907: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
908: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
909: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
910: FND_MSG_PUB.ADD;

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

903: fnd_msg_pub.add;
904: RAISE EXCP_USER_DEFINED;
905: WHEN OTHERS THEN
906: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
907: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
908: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
909: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
910: FND_MSG_PUB.ADD;
911: RAISE EXCP_USER_DEFINED;

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

904: RAISE EXCP_USER_DEFINED;
905: WHEN OTHERS THEN
906: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
907: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
908: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
909: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
910: FND_MSG_PUB.ADD;
911: RAISE EXCP_USER_DEFINED;
912: END;

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

905: WHEN OTHERS THEN
906: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
907: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
908: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
909: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
910: FND_MSG_PUB.ADD;
911: RAISE EXCP_USER_DEFINED;
912: END;
913: END IF;

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

913: END IF;
914:
915: --validating transaction_quantity
916: IF p_quantity IS NULL OR p_quantity < 0 THEN
917: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
918: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_quantity', TRUE);
919: fnd_msg_pub.add;
920: RAISE EXCP_USER_DEFINED;
921: END IF;

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

914:
915: --validating transaction_quantity
916: IF p_quantity IS NULL OR p_quantity < 0 THEN
917: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
918: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_quantity', TRUE);
919: fnd_msg_pub.add;
920: RAISE EXCP_USER_DEFINED;
921: END IF;
922:

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

921: END IF;
922:
923: --validating transaction_uom
924: IF p_uom IS NULL THEN
925: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
926: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_uom', TRUE);
927: fnd_msg_pub.add;
928: RAISE EXCP_USER_DEFINED;
929: END IF;

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

922:
923: --validating transaction_uom
924: IF p_uom IS NULL THEN
925: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
926: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_uom', TRUE);
927: fnd_msg_pub.add;
928: RAISE EXCP_USER_DEFINED;
929: END IF;
930:

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

948: AND gcc.code_combination_id = p_account_id;
949:
950: EXCEPTION
951: WHEN NO_DATA_FOUND THEN
952: fnd_message.set_name('CSP', 'CSP_INVALID_ACCOUNT');
953: fnd_msg_pub.add;
954: RAISE EXCP_USER_DEFINED;
955: WHEN OTHERS THEN
956: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

952: fnd_message.set_name('CSP', 'CSP_INVALID_ACCOUNT');
953: fnd_msg_pub.add;
954: RAISE EXCP_USER_DEFINED;
955: WHEN OTHERS THEN
956: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
957: fnd_message.set_token('ERR_FIELD', 'p_account_id', TRUE);
958: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
959: fnd_message.set_token('TABLE', 'GL_code_combinations', TRUE);
960: FND_MSG_PUB.ADD;

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

953: fnd_msg_pub.add;
954: RAISE EXCP_USER_DEFINED;
955: WHEN OTHERS THEN
956: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
957: fnd_message.set_token('ERR_FIELD', 'p_account_id', TRUE);
958: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
959: fnd_message.set_token('TABLE', 'GL_code_combinations', TRUE);
960: FND_MSG_PUB.ADD;
961: RAISE EXCP_USER_DEFINED;

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

954: RAISE EXCP_USER_DEFINED;
955: WHEN OTHERS THEN
956: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
957: fnd_message.set_token('ERR_FIELD', 'p_account_id', TRUE);
958: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
959: fnd_message.set_token('TABLE', 'GL_code_combinations', TRUE);
960: FND_MSG_PUB.ADD;
961: RAISE EXCP_USER_DEFINED;
962: END;

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

955: WHEN OTHERS THEN
956: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
957: fnd_message.set_token('ERR_FIELD', 'p_account_id', TRUE);
958: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
959: fnd_message.set_token('TABLE', 'GL_code_combinations', TRUE);
960: FND_MSG_PUB.ADD;
961: RAISE EXCP_USER_DEFINED;
962: END;
963: END IF;

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

966: /* Removed the vaalidation of subinventory code by klou.
967: Subinvnetory code is a NULL column in the interface table.
968: --validating subinventory_code
969: IF p_subinventory_code IS NULL THEN
970: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
971: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_subinventory_code', TRUE);
972: fnd_msg_pub.add;
973: RAISE EXCP_USER_DEFINED;
974: END IF;

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

967: Subinvnetory code is a NULL column in the interface table.
968: --validating subinventory_code
969: IF p_subinventory_code IS NULL THEN
970: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
971: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_subinventory_code', TRUE);
972: fnd_msg_pub.add;
973: RAISE EXCP_USER_DEFINED;
974: END IF;
975: */

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

1035: l_ship_number := Null;
1036: End;
1037:
1038: If l_ship_number is Not Null then
1039: fnd_message.set_name('INV','INV_SHIP_USED');
1040: fnd_msg_pub.add;
1041: RAISE EXCP_USER_DEFINED;
1042: End if;
1043:

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

1050: l_ship_number := Null;
1051: End;
1052:
1053: If l_ship_number is Not Null then
1054: fnd_message.set_name('INV','INV_SHIP_USED');
1055: fnd_msg_pub.add;
1056: RAISE EXCP_USER_DEFINED;
1057: End if;
1058:

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

1065: l_ship_number := Null;
1066: End;
1067:
1068: If l_ship_number is Not Null then
1069: fnd_message.set_name('INV','INV_SHIP_USED');
1070: fnd_msg_pub.add;
1071: RAISE EXCP_USER_DEFINED;
1072: End if;
1073:

Line 1329: l_error_explanation:= fnd_message.get;

1325: l_error_code := ' ';
1326: l_error_explanation := 'No Errors';
1327: l_outcome := true;
1328: WHEN TOO_MANY_ROWS THEN
1329: l_error_explanation:= fnd_message.get;
1330: l_outcome := false;
1331: WHEN OTHERS THEN
1332: l_outcome := false;
1333: END;

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

1350: END IF;
1351:
1352: IF (l_outcome = FALSE) THEN
1353: delete from mtl_transactions_interface where transaction_header_id = l_transaction_header_id;
1354: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');
1355: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, TRUE);
1356: FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);
1357: FND_MSG_PUB.ADD;
1358: RAISE EXCP_USER_DEFINED;

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

1351:
1352: IF (l_outcome = FALSE) THEN
1353: delete from mtl_transactions_interface where transaction_header_id = l_transaction_header_id;
1354: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');
1355: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, TRUE);
1356: FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);
1357: FND_MSG_PUB.ADD;
1358: RAISE EXCP_USER_DEFINED;
1359: else

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

1352: IF (l_outcome = FALSE) THEN
1353: delete from mtl_transactions_interface where transaction_header_id = l_transaction_header_id;
1354: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');
1355: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, TRUE);
1356: FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);
1357: FND_MSG_PUB.ADD;
1358: RAISE EXCP_USER_DEFINED;
1359: else
1360: OPEN transaction_id_cur;

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

1547: WHEN OTHERS THEN
1548: If l_outcome = true then
1549: Rollback to Transact_Material_Pub;
1550: end if;
1551: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1552: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1553: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1554: fnd_msg_pub.add;
1555: fnd_msg_pub.count_and_get

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

1548: If l_outcome = true then
1549: Rollback to Transact_Material_Pub;
1550: end if;
1551: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1552: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1553: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1554: fnd_msg_pub.add;
1555: fnd_msg_pub.count_and_get
1556: ( p_count => x_msg_count

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

1549: Rollback to Transact_Material_Pub;
1550: end if;
1551: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1552: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1553: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1554: fnd_msg_pub.add;
1555: fnd_msg_pub.count_and_get
1556: ( p_count => x_msg_count
1557: , p_data => x_msg_data);

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

1722: END IF;
1723:
1724: IF p_validation_level = fnd_api.g_valid_level_full THEN
1725: IF p_transaction_temp_id IS NULL THEN
1726: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1727: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_temp_id', FALSE);
1728: FND_MSG_PUB.ADD;
1729: RAISE EXCP_USER_DEFINED;
1730: ELSE

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

1723:
1724: IF p_validation_level = fnd_api.g_valid_level_full THEN
1725: IF p_transaction_temp_id IS NULL THEN
1726: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1727: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_temp_id', FALSE);
1728: FND_MSG_PUB.ADD;
1729: RAISE EXCP_USER_DEFINED;
1730: ELSE
1731: BEGIN

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

1733: from mtl_material_transactions_temp
1734: where transaction_temp_id = p_transaction_temp_id;
1735: EXCEPTION
1736: WHEN NO_DATA_FOUND THEN
1737: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1738: fnd_message.set_token('ID', to_char(p_transaction_temp_id), FALSE);
1739: fnd_msg_pub.add;
1740: RAISE EXCP_USER_DEFINED;
1741: WHEN OTHERS THEN

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

1734: where transaction_temp_id = p_transaction_temp_id;
1735: EXCEPTION
1736: WHEN NO_DATA_FOUND THEN
1737: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1738: fnd_message.set_token('ID', to_char(p_transaction_temp_id), FALSE);
1739: fnd_msg_pub.add;
1740: RAISE EXCP_USER_DEFINED;
1741: WHEN OTHERS THEN
1742: RAISE TOO_MANY_ROWS; -- this will really go to OTHERS exception.

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

1757: Open l_Get_Temp_Csr;
1758: Fetch l_Get_Temp_Csr Into l_mtl_txn_temp_rec;
1759: If l_Get_Temp_Csr%NOTFOUND Then
1760: Close l_Get_Temp_Csr;
1761: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1762: fnd_message.set_token('ID', to_char(p_transaction_temp_id), FALSE);
1763: fnd_msg_pub.add;
1764: RAISE EXCP_USER_DEFINED;
1765: Else

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

1758: Fetch l_Get_Temp_Csr Into l_mtl_txn_temp_rec;
1759: If l_Get_Temp_Csr%NOTFOUND Then
1760: Close l_Get_Temp_Csr;
1761: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1762: fnd_message.set_token('ID', to_char(p_transaction_temp_id), FALSE);
1763: fnd_msg_pub.add;
1764: RAISE EXCP_USER_DEFINED;
1765: Else
1766: Close l_Get_Temp_Csr;

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

1771: Open l_Get_Mo_Header_id_csr(l_mtl_txn_temp_rec.move_order_line_id);
1772: Fetch l_Get_Mo_Header_id_csr Into l_Mo_header_id;
1773: If l_Get_Mo_header_id_csr%NOTFOUND THEN
1774: Close l_Get_Mo_header_id_csr;
1775: fnd_message.set_name ('CSP', 'CSP_MOVEORDER_LINE_NO_PARENT');
1776: fnd_message.set_token ('LINE_ID', to_char(l_mtl_txn_temp_rec.move_order_line_id), FALSE);
1777: fnd_msg_pub.add;
1778: End If;
1779:

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

1772: Fetch l_Get_Mo_Header_id_csr Into l_Mo_header_id;
1773: If l_Get_Mo_header_id_csr%NOTFOUND THEN
1774: Close l_Get_Mo_header_id_csr;
1775: fnd_message.set_name ('CSP', 'CSP_MOVEORDER_LINE_NO_PARENT');
1776: fnd_message.set_token ('LINE_ID', to_char(l_mtl_txn_temp_rec.move_order_line_id), FALSE);
1777: fnd_msg_pub.add;
1778: End If;
1779:
1780: Close l_Get_Mo_header_id_csr;

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

1838: End Loop; -- <>
1839:
1840: If l_Get_Lot_Temp_Csr%rowcount = 0 Then
1841: Close l_Get_Lot_Temp_Csr;
1842: fnd_message.set_name('CSP', 'CSP_NO_LOT_TXN_RECORD');
1843: fnd_msg_pub.add;
1844: RAISE EXCP_USER_DEFINED;
1845: End if;
1846:

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

1911:
1912: If l_Get_Serial_Temp_Csr%rowcount = 0 Then
1913: Close l_Get_Lot_Temp_Csr;
1914: Close l_Get_Serial_Temp_Csr;
1915: fnd_message.set_name('CSP', 'CSP_NO_SERIAL_TXN_RECORD');
1916: fnd_msg_pub.add;
1917: RAISE EXCP_USER_DEFINED;
1918: End If;
1919:

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

2056: ,X_MSG_DATA => X_MSG_DATA
2057: ,X_RETURN_STATUS => X_RETURN_STATUS);
2058: WHEN OTHERS THEN
2059: Rollback to transact_temp_record_pub;
2060: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2061: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
2062: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
2063: fnd_msg_pub.add;
2064: fnd_msg_pub.count_and_get

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

2057: ,X_RETURN_STATUS => X_RETURN_STATUS);
2058: WHEN OTHERS THEN
2059: Rollback to transact_temp_record_pub;
2060: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2061: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
2062: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
2063: fnd_msg_pub.add;
2064: fnd_msg_pub.count_and_get
2065: ( p_count => x_msg_count

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

2058: WHEN OTHERS THEN
2059: Rollback to transact_temp_record_pub;
2060: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2061: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
2062: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
2063: fnd_msg_pub.add;
2064: fnd_msg_pub.count_and_get
2065: ( p_count => x_msg_count
2066: , p_data => x_msg_data);