[Home] [Help]
453:
454: BEGIN
455: --dbms_output.put_line('Create_terrtype PUB: Entering API');
456:
457: -- Standard Start of API savepoint
458: SAVEPOINT create_terrtype_pub;
459:
460: -- Standard call to check for call compatibility.
461: IF NOT fnd_api.compatible_api_call (
456:
457: -- Standard Start of API savepoint
458: SAVEPOINT create_terrtype_pub;
459:
460: -- Standard call to check for call compatibility.
461: IF NOT fnd_api.compatible_api_call (
462: l_api_version_number,
463: p_api_version_number,
464: l_api_name,
552: END IF;
553:
554: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
555:
556: -- Standard check for p_commit
557: IF fnd_api.to_boolean (p_commit)
558: THEN
559: COMMIT WORK;
560: END IF;
672:
673: BEGIN
674: --dbms_output.put_line('Update_terrtype PUB: Entering API');
675:
676: -- Standard Start of API savepoint
677: SAVEPOINT upadate_terrtype_pub;
678:
679: -- Standard call to check for call compatibility.
680: IF NOT fnd_api.compatible_api_call (
675:
676: -- Standard Start of API savepoint
677: SAVEPOINT upadate_terrtype_pub;
678:
679: -- Standard call to check for call compatibility.
680: IF NOT fnd_api.compatible_api_call (
681: l_api_version_number,
682: p_api_version_number,
683: l_api_name,
776: END IF;
777:
778: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
779:
780: -- Standard check for p_commit
781: IF fnd_api.to_boolean (p_commit)
782: THEN
783: COMMIT WORK;
784: END IF;
871: l_return_status VARCHAR2(1);
872: BEGIN
873: --dbms_output.put_line('Delete_terrtype PUB: Entering API');
874:
875: -- Standard Start of API savepoint
876: SAVEPOINT delete_terrtype_pub;
877:
878: -- Standard call to check for call compatibility.
879: IF NOT fnd_api.compatible_api_call (
874:
875: -- Standard Start of API savepoint
876: SAVEPOINT delete_terrtype_pub;
877:
878: -- Standard call to check for call compatibility.
879: IF NOT fnd_api.compatible_api_call (
880: l_api_version_number,
881: p_api_version_number,
882: l_api_name,
925: THEN
926: RAISE fnd_api.g_exc_unexpected_error;
927: END IF;
928:
929: -- Standard check of p_commit.
930: IF fnd_api.to_boolean (p_commit)
931: THEN
932: COMMIT WORK;
933: END IF;
939: fnd_message.set_name ('PROC_NAME', l_api_name);
940: fnd_msg_pub.add;
941: END IF;
942:
943: -- Standard call to get message count and if count is 1, get message info.
944: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
945: --dbms_output.put_line('Delete_terrtype PUB: Exiting API');
946: EXCEPTION
947: WHEN fnd_api.g_exc_error
1025: l_api_name CONSTANT VARCHAR2(30) := 'Deactivate_TerrType';
1026: l_api_version_number CONSTANT NUMBER := 1.0;
1027: l_return_status VARCHAR2(1);
1028: BEGIN
1029: -- Standard Start of API savepoint
1030: SAVEPOINT deactivate_terrtype_pub;
1031:
1032: -- Standard call to check for call compatibility.
1033: IF NOT fnd_api.compatible_api_call (
1028: BEGIN
1029: -- Standard Start of API savepoint
1030: SAVEPOINT deactivate_terrtype_pub;
1031:
1032: -- Standard call to check for call compatibility.
1033: IF NOT fnd_api.compatible_api_call (
1034: l_api_version_number,
1035: p_api_version_number,
1036: l_api_name,
1079: THEN
1080: RAISE fnd_api.g_exc_unexpected_error;
1081: END IF;
1082:
1083: -- Standard check of p_commit.
1084: IF fnd_api.to_boolean (p_commit)
1085: THEN
1086: COMMIT WORK;
1087: END IF;
1093: fnd_message.set_name ('PROC_NAME', l_api_name);
1094: fnd_msg_pub.add;
1095: END IF;
1096:
1097: -- Standard call to get message count and if count is 1, get message info.
1098: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1099: --dbms_output.put_line('De-Activate_terrtype PUB: Exiting API');
1100: EXCEPTION
1101: WHEN fnd_api.g_exc_error