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.JTF_TERRITORY_PUB dependencies on FND_API

Line 830: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE

826: -- p_Terr_Values_Tbl Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl
827: --
828: -- Optional
829: -- Parameter Name Data Type Default
830: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
831: -- p_Commit VARCHAR2 := FND_API.G_FALSE
832: --
833: -- OUT NOCOPY :
834: -- Parameter Name Data Type

Line 831: -- p_Commit VARCHAR2 := FND_API.G_FALSE

827: --
828: -- Optional
829: -- Parameter Name Data Type Default
830: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
831: -- p_Commit VARCHAR2 := FND_API.G_FALSE
832: --
833: -- OUT NOCOPY :
834: -- Parameter Name Data Type
835: -- x_Return_Status VARCHAR2(1)

Line 852: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

848: -- End of Comments
849: --
850: PROCEDURE create_territory (
851: p_api_version_number IN NUMBER,
852: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
853: p_commit IN VARCHAR2 := fnd_api.g_false,
854: x_return_status OUT NOCOPY VARCHAR2,
855: x_msg_count OUT NOCOPY NUMBER,
856: x_msg_data OUT NOCOPY VARCHAR2,

Line 853: p_commit IN VARCHAR2 := fnd_api.g_false,

849: --
850: PROCEDURE create_territory (
851: p_api_version_number IN NUMBER,
852: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
853: p_commit IN VARCHAR2 := fnd_api.g_false,
854: x_return_status OUT NOCOPY VARCHAR2,
855: x_msg_count OUT NOCOPY NUMBER,
856: x_msg_data OUT NOCOPY VARCHAR2,
857: p_terr_all_rec IN terr_all_rec_type

Line 894: IF NOT fnd_api.compatible_api_call (

890: -- Standard Start of API savepoint
891: SAVEPOINT create_territory_pub;
892:
893: -- Standard call to check for call compatibility.
894: IF NOT fnd_api.compatible_api_call (
895: l_api_version_number,
896: p_api_version_number,
897: l_api_name,
898: g_pkg_name

Line 901: RAISE fnd_api.g_exc_unexpected_error;

897: l_api_name,
898: g_pkg_name
899: )
900: THEN
901: RAISE fnd_api.g_exc_unexpected_error;
902: END IF;
903:
904: -- Initialize message list if p_init_msg_list is set to TRUE.
905: IF fnd_api.to_boolean (p_init_msg_list)

Line 905: IF fnd_api.to_boolean (p_init_msg_list)

901: RAISE fnd_api.g_exc_unexpected_error;
902: END IF;
903:
904: -- Initialize message list if p_init_msg_list is set to TRUE.
905: IF fnd_api.to_boolean (p_init_msg_list)
906: THEN
907: fnd_msg_pub.initialize;
908: END IF;
909:

Line 919: x_return_status := fnd_api.g_ret_sts_success;

915: fnd_msg_pub.add;
916: END IF;
917:
918: -- Initialize API return status to success
919: x_return_status := fnd_api.g_ret_sts_success;
920: --
921: -- API body
922: --
923: convert_terrrec_pubtopvt (

Line 946: p_init_msg_list => fnd_api.g_false,

942: ); */
943: -- ******************************************************************
944: jtf_territory_pvt.create_territory (
945: p_api_version_number => 1.0,
946: p_init_msg_list => fnd_api.g_false,
947: p_commit => fnd_api.g_false,
948: p_validation_level => fnd_api.g_valid_level_full,
949: x_return_status => l_return_status,
950: x_msg_count => x_msg_count,

Line 947: p_commit => fnd_api.g_false,

943: -- ******************************************************************
944: jtf_territory_pvt.create_territory (
945: p_api_version_number => 1.0,
946: p_init_msg_list => fnd_api.g_false,
947: p_commit => fnd_api.g_false,
948: p_validation_level => fnd_api.g_valid_level_full,
949: x_return_status => l_return_status,
950: x_msg_count => x_msg_count,
951: x_msg_data => x_msg_data,

Line 948: p_validation_level => fnd_api.g_valid_level_full,

944: jtf_territory_pvt.create_territory (
945: p_api_version_number => 1.0,
946: p_init_msg_list => fnd_api.g_false,
947: p_commit => fnd_api.g_false,
948: p_validation_level => fnd_api.g_valid_level_full,
949: x_return_status => l_return_status,
950: x_msg_count => x_msg_count,
951: x_msg_data => x_msg_data,
952: p_terr_all_rec => l_terr_rec,

Line 981: IF l_return_status = fnd_api.g_ret_sts_error

977: x_terrvaluesout_tbl => x_terr_values_out_tbl
978: );
979: x_return_status := l_return_status;
980:
981: IF l_return_status = fnd_api.g_ret_sts_error
982: THEN
983: RAISE fnd_api.g_exc_error;
984: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
985: THEN

Line 983: RAISE fnd_api.g_exc_error;

979: x_return_status := l_return_status;
980:
981: IF l_return_status = fnd_api.g_ret_sts_error
982: THEN
983: RAISE fnd_api.g_exc_error;
984: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
985: THEN
986: RAISE fnd_api.g_exc_unexpected_error;
987: END IF;

Line 984: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error

980:
981: IF l_return_status = fnd_api.g_ret_sts_error
982: THEN
983: RAISE fnd_api.g_exc_error;
984: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
985: THEN
986: RAISE fnd_api.g_exc_unexpected_error;
987: END IF;
988:

Line 986: RAISE fnd_api.g_exc_unexpected_error;

982: THEN
983: RAISE fnd_api.g_exc_error;
984: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
985: THEN
986: RAISE fnd_api.g_exc_unexpected_error;
987: END IF;
988:
989: --
990: -- End of API body.

Line 994: IF fnd_api.to_boolean (p_commit)

990: -- End of API body.
991: --
992:
993: -- Standard check of p_commit.
994: IF fnd_api.to_boolean (p_commit)
995: THEN
996: COMMIT WORK;
997: END IF;
998:

Line 1010: WHEN fnd_api.g_exc_error

1006:
1007: -- Standard call to get message count and if count is 1, get message info.
1008: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1009: EXCEPTION
1010: WHEN fnd_api.g_exc_error
1011: THEN
1012: ROLLBACK TO create_territory_pub;
1013: x_return_status := fnd_api.g_ret_sts_error;
1014: fnd_msg_pub.count_and_get (

Line 1013: x_return_status := fnd_api.g_ret_sts_error;

1009: EXCEPTION
1010: WHEN fnd_api.g_exc_error
1011: THEN
1012: ROLLBACK TO create_territory_pub;
1013: x_return_status := fnd_api.g_ret_sts_error;
1014: fnd_msg_pub.count_and_get (
1015: p_count => x_msg_count,
1016: p_data => x_msg_data
1017: );

Line 1018: WHEN fnd_api.g_exc_unexpected_error

1014: fnd_msg_pub.count_and_get (
1015: p_count => x_msg_count,
1016: p_data => x_msg_data
1017: );
1018: WHEN fnd_api.g_exc_unexpected_error
1019: THEN
1020: ROLLBACK TO create_territory_pub;
1021: x_return_status := fnd_api.g_ret_sts_unexp_error;
1022: fnd_msg_pub.count_and_get (

Line 1021: x_return_status := fnd_api.g_ret_sts_unexp_error;

1017: );
1018: WHEN fnd_api.g_exc_unexpected_error
1019: THEN
1020: ROLLBACK TO create_territory_pub;
1021: x_return_status := fnd_api.g_ret_sts_unexp_error;
1022: fnd_msg_pub.count_and_get (
1023: p_count => x_msg_count,
1024: p_data => x_msg_data
1025: );

Line 1029: x_return_status := fnd_api.g_ret_sts_unexp_error;

1025: );
1026: WHEN OTHERS
1027: THEN
1028: ROLLBACK TO create_territory_pub;
1029: x_return_status := fnd_api.g_ret_sts_unexp_error;
1030:
1031: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1032: THEN
1033: fnd_msg_pub.add_exc_msg (

Line 1066: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE

1062: -- p_Terr_Id NUMBER
1063: --
1064: -- Optional
1065: -- Parameter Name Data Type Default
1066: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1067: -- p_Commit VARCHAR2 FND_API.G_FALSE
1068: --
1069: -- OUT :
1070: -- Parameter Name Data Type

Line 1067: -- p_Commit VARCHAR2 FND_API.G_FALSE

1063: --
1064: -- Optional
1065: -- Parameter Name Data Type Default
1066: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1067: -- p_Commit VARCHAR2 FND_API.G_FALSE
1068: --
1069: -- OUT :
1070: -- Parameter Name Data Type
1071: -- p_Return_Status VARCHAR2(1)

Line 1083: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1079: -- End of Comments
1080: --
1081: PROCEDURE delete_territory (
1082: p_api_version_number IN NUMBER,
1083: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1084: p_commit IN VARCHAR2 := fnd_api.g_false,
1085: x_return_status OUT NOCOPY VARCHAR2,
1086: x_msg_count OUT NOCOPY NUMBER,
1087: x_msg_data OUT NOCOPY VARCHAR2,

Line 1084: p_commit IN VARCHAR2 := fnd_api.g_false,

1080: --
1081: PROCEDURE delete_territory (
1082: p_api_version_number IN NUMBER,
1083: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1084: p_commit IN VARCHAR2 := fnd_api.g_false,
1085: x_return_status OUT NOCOPY VARCHAR2,
1086: x_msg_count OUT NOCOPY NUMBER,
1087: x_msg_data OUT NOCOPY VARCHAR2,
1088: p_terr_id IN NUMBER

Line 1099: IF NOT fnd_api.compatible_api_call (

1095: -- Standard Start of API savepoint
1096: SAVEPOINT delete_territory_pub;
1097:
1098: -- Standard call to check for call compatibility.
1099: IF NOT fnd_api.compatible_api_call (
1100: l_api_version_number,
1101: p_api_version_number,
1102: l_api_name,
1103: g_pkg_name

Line 1106: RAISE fnd_api.g_exc_unexpected_error;

1102: l_api_name,
1103: g_pkg_name
1104: )
1105: THEN
1106: RAISE fnd_api.g_exc_unexpected_error;
1107: END IF;
1108:
1109: -- Initialize message list if p_init_msg_list is set to TRUE.
1110: IF fnd_api.to_boolean (p_init_msg_list)

Line 1110: IF fnd_api.to_boolean (p_init_msg_list)

1106: RAISE fnd_api.g_exc_unexpected_error;
1107: END IF;
1108:
1109: -- Initialize message list if p_init_msg_list is set to TRUE.
1110: IF fnd_api.to_boolean (p_init_msg_list)
1111: THEN
1112: fnd_msg_pub.initialize;
1113: END IF;
1114:

Line 1124: x_return_status := fnd_api.g_ret_sts_success;

1120: fnd_msg_pub.add;
1121: END IF;
1122:
1123: -- Initialize API return status to success
1124: x_return_status := fnd_api.g_ret_sts_success;
1125: --
1126: -- API body
1127: --
1128: jtf_territory_pvt.delete_territory (

Line 1141: IF x_return_status = fnd_api.g_ret_sts_error

1137:
1138: --l_return_status := x_return_status;
1139:
1140: --
1141: IF x_return_status = fnd_api.g_ret_sts_error
1142: THEN
1143: RAISE fnd_api.g_exc_error;
1144: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1145: THEN

Line 1143: RAISE fnd_api.g_exc_error;

1139:
1140: --
1141: IF x_return_status = fnd_api.g_ret_sts_error
1142: THEN
1143: RAISE fnd_api.g_exc_error;
1144: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1145: THEN
1146: RAISE fnd_api.g_exc_unexpected_error;
1147: END IF;

Line 1144: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1140: --
1141: IF x_return_status = fnd_api.g_ret_sts_error
1142: THEN
1143: RAISE fnd_api.g_exc_error;
1144: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1145: THEN
1146: RAISE fnd_api.g_exc_unexpected_error;
1147: END IF;
1148:

Line 1146: RAISE fnd_api.g_exc_unexpected_error;

1142: THEN
1143: RAISE fnd_api.g_exc_error;
1144: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1145: THEN
1146: RAISE fnd_api.g_exc_unexpected_error;
1147: END IF;
1148:
1149: -- Standard check of p_commit.
1150: IF fnd_api.to_boolean (p_commit)

Line 1150: IF fnd_api.to_boolean (p_commit)

1146: RAISE fnd_api.g_exc_unexpected_error;
1147: END IF;
1148:
1149: -- Standard check of p_commit.
1150: IF fnd_api.to_boolean (p_commit)
1151: THEN
1152: COMMIT WORK;
1153: END IF;
1154:

Line 1166: WHEN fnd_api.g_exc_error

1162:
1163: -- Standard call to get message count and if count is 1, get message info.
1164: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1165: EXCEPTION
1166: WHEN fnd_api.g_exc_error
1167: THEN
1168: ROLLBACK TO delete_territory_pub;
1169: x_return_status := fnd_api.g_ret_sts_error;
1170: fnd_msg_pub.count_and_get (

Line 1169: x_return_status := fnd_api.g_ret_sts_error;

1165: EXCEPTION
1166: WHEN fnd_api.g_exc_error
1167: THEN
1168: ROLLBACK TO delete_territory_pub;
1169: x_return_status := fnd_api.g_ret_sts_error;
1170: fnd_msg_pub.count_and_get (
1171: p_count => x_msg_count,
1172: p_data => x_msg_data
1173: );

Line 1174: WHEN fnd_api.g_exc_unexpected_error

1170: fnd_msg_pub.count_and_get (
1171: p_count => x_msg_count,
1172: p_data => x_msg_data
1173: );
1174: WHEN fnd_api.g_exc_unexpected_error
1175: THEN
1176: ROLLBACK TO delete_territory_pub;
1177: x_return_status := fnd_api.g_ret_sts_unexp_error;
1178: fnd_msg_pub.count_and_get (

Line 1177: x_return_status := fnd_api.g_ret_sts_unexp_error;

1173: );
1174: WHEN fnd_api.g_exc_unexpected_error
1175: THEN
1176: ROLLBACK TO delete_territory_pub;
1177: x_return_status := fnd_api.g_ret_sts_unexp_error;
1178: fnd_msg_pub.count_and_get (
1179: p_count => x_msg_count,
1180: p_data => x_msg_data
1181: );

Line 1185: x_return_status := fnd_api.g_ret_sts_unexp_error;

1181: );
1182: WHEN OTHERS
1183: THEN
1184: ROLLBACK TO delete_territory_pub;
1185: x_return_status := fnd_api.g_ret_sts_unexp_error;
1186:
1187: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1188: THEN
1189: fnd_msg_pub.add_exc_msg (

Line 1221: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE

1217: -- p_Terr_All_Rec Terr_All_Rec_Type := G_Miss_Terr_All_Rec
1218: --
1219: -- Optional
1220: -- Parameter Name Data Type Default
1221: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1222: -- p_Commit VARCHAR2 := FND_API.G_FALSE
1223: --
1224: -- OUT NOCOPY :
1225: -- Parameter Name Data Type

Line 1222: -- p_Commit VARCHAR2 := FND_API.G_FALSE

1218: --
1219: -- Optional
1220: -- Parameter Name Data Type Default
1221: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1222: -- p_Commit VARCHAR2 := FND_API.G_FALSE
1223: --
1224: -- OUT NOCOPY :
1225: -- Parameter Name Data Type
1226: -- p_Return_Status VARCHAR2(1)

Line 1239: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1235: -- End of Comments
1236: --
1237: PROCEDURE update_territory (
1238: p_api_version_number IN NUMBER,
1239: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1240: p_commit IN VARCHAR2 := fnd_api.g_false,
1241: x_return_status OUT NOCOPY VARCHAR2,
1242: x_msg_count OUT NOCOPY NUMBER,
1243: x_msg_data OUT NOCOPY VARCHAR2,

Line 1240: p_commit IN VARCHAR2 := fnd_api.g_false,

1236: --
1237: PROCEDURE update_territory (
1238: p_api_version_number IN NUMBER,
1239: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1240: p_commit IN VARCHAR2 := fnd_api.g_false,
1241: x_return_status OUT NOCOPY VARCHAR2,
1242: x_msg_count OUT NOCOPY NUMBER,
1243: x_msg_data OUT NOCOPY VARCHAR2,
1244: p_terr_all_rec IN terr_all_rec_type

Line 1282: IF NOT fnd_api.compatible_api_call (

1278: -- Standard Start of API savepoint
1279: SAVEPOINT update_territory_pub;
1280:
1281: -- Standard call to check for call compatibility.
1282: IF NOT fnd_api.compatible_api_call (
1283: l_api_version_number,
1284: p_api_version_number,
1285: l_api_name,
1286: g_pkg_name

Line 1289: RAISE fnd_api.g_exc_unexpected_error;

1285: l_api_name,
1286: g_pkg_name
1287: )
1288: THEN
1289: RAISE fnd_api.g_exc_unexpected_error;
1290: END IF;
1291:
1292: -- Initialize message list if p_init_msg_list is set to TRUE.
1293: IF fnd_api.to_boolean (p_init_msg_list)

Line 1293: IF fnd_api.to_boolean (p_init_msg_list)

1289: RAISE fnd_api.g_exc_unexpected_error;
1290: END IF;
1291:
1292: -- Initialize message list if p_init_msg_list is set to TRUE.
1293: IF fnd_api.to_boolean (p_init_msg_list)
1294: THEN
1295: fnd_msg_pub.initialize;
1296: END IF;
1297:

Line 1307: x_return_status := fnd_api.g_ret_sts_success;

1303: fnd_msg_pub.add;
1304: END IF;
1305:
1306: -- Initialize API return status to success
1307: x_return_status := fnd_api.g_ret_sts_success;
1308: --
1309: -- API body
1310: --
1311: --

Line 1337: p_init_msg_list => fnd_api.g_false,

1333: ); */
1334: --dbms_output.put_line('Update_Territory PUB: Before Calling JTF_TERRITORY_PVT.Update_Territory');
1335: jtf_territory_pvt.update_territory (
1336: p_api_version_number => 1.0,
1337: p_init_msg_list => fnd_api.g_false,
1338: p_commit => fnd_api.g_false,
1339: p_validation_level => fnd_api.g_valid_level_full,
1340: x_return_status => l_return_status,
1341: x_msg_count => x_msg_count,

Line 1338: p_commit => fnd_api.g_false,

1334: --dbms_output.put_line('Update_Territory PUB: Before Calling JTF_TERRITORY_PVT.Update_Territory');
1335: jtf_territory_pvt.update_territory (
1336: p_api_version_number => 1.0,
1337: p_init_msg_list => fnd_api.g_false,
1338: p_commit => fnd_api.g_false,
1339: p_validation_level => fnd_api.g_valid_level_full,
1340: x_return_status => l_return_status,
1341: x_msg_count => x_msg_count,
1342: x_msg_data => x_msg_data,

Line 1339: p_validation_level => fnd_api.g_valid_level_full,

1335: jtf_territory_pvt.update_territory (
1336: p_api_version_number => 1.0,
1337: p_init_msg_list => fnd_api.g_false,
1338: p_commit => fnd_api.g_false,
1339: p_validation_level => fnd_api.g_valid_level_full,
1340: x_return_status => l_return_status,
1341: x_msg_count => x_msg_count,
1342: x_msg_data => x_msg_data,
1343: p_terr_all_rec => l_terr_rec,

Line 1380: IF l_return_status <> fnd_api.g_ret_sts_success

1376: --
1377:
1378: x_return_status := l_return_status;
1379:
1380: IF l_return_status <> fnd_api.g_ret_sts_success
1381: THEN
1382: RAISE fnd_api.g_exc_error;
1383: END IF;
1384:

Line 1382: RAISE fnd_api.g_exc_error;

1378: x_return_status := l_return_status;
1379:
1380: IF l_return_status <> fnd_api.g_ret_sts_success
1381: THEN
1382: RAISE fnd_api.g_exc_error;
1383: END IF;
1384:
1385: -- Debug Message
1386: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 1396: IF fnd_api.to_boolean (p_commit)

1392:
1393: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1394:
1395: -- Standard check for p_commit
1396: IF fnd_api.to_boolean (p_commit)
1397: THEN
1398: COMMIT WORK;
1399: END IF;
1400: --dbms_output.put_line('Update_Territory PUB: Exiting API');

Line 1404: WHEN fnd_api.g_exc_error

1400: --dbms_output.put_line('Update_Territory PUB: Exiting API');
1401: --
1402: EXCEPTION
1403: --
1404: WHEN fnd_api.g_exc_error
1405: THEN
1406: --dbms_output.put_line('Update_Territory PUB: FND_API.G_EXC_ERROR');
1407: ROLLBACK TO update_territory_pub;
1408: x_return_status := fnd_api.g_ret_sts_error;

Line 1406: --dbms_output.put_line('Update_Territory PUB: FND_API.G_EXC_ERROR');

1402: EXCEPTION
1403: --
1404: WHEN fnd_api.g_exc_error
1405: THEN
1406: --dbms_output.put_line('Update_Territory PUB: FND_API.G_EXC_ERROR');
1407: ROLLBACK TO update_territory_pub;
1408: x_return_status := fnd_api.g_ret_sts_error;
1409: fnd_msg_pub.count_and_get (
1410: p_count => x_msg_count,

Line 1408: x_return_status := fnd_api.g_ret_sts_error;

1404: WHEN fnd_api.g_exc_error
1405: THEN
1406: --dbms_output.put_line('Update_Territory PUB: FND_API.G_EXC_ERROR');
1407: ROLLBACK TO update_territory_pub;
1408: x_return_status := fnd_api.g_ret_sts_error;
1409: fnd_msg_pub.count_and_get (
1410: p_count => x_msg_count,
1411: p_data => x_msg_data
1412: );

Line 1413: WHEN fnd_api.g_exc_unexpected_error

1409: fnd_msg_pub.count_and_get (
1410: p_count => x_msg_count,
1411: p_data => x_msg_data
1412: );
1413: WHEN fnd_api.g_exc_unexpected_error
1414: THEN
1415: --dbms_output.put_line('Update_Territory PUB: FND_API.G_EXC_UNEXPECTED_ERROR');
1416: ROLLBACK TO update_territory_pub;
1417: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1415: --dbms_output.put_line('Update_Territory PUB: FND_API.G_EXC_UNEXPECTED_ERROR');

1411: p_data => x_msg_data
1412: );
1413: WHEN fnd_api.g_exc_unexpected_error
1414: THEN
1415: --dbms_output.put_line('Update_Territory PUB: FND_API.G_EXC_UNEXPECTED_ERROR');
1416: ROLLBACK TO update_territory_pub;
1417: x_return_status := fnd_api.g_ret_sts_unexp_error;
1418: fnd_msg_pub.count_and_get (
1419: p_count => x_msg_count,

Line 1417: x_return_status := fnd_api.g_ret_sts_unexp_error;

1413: WHEN fnd_api.g_exc_unexpected_error
1414: THEN
1415: --dbms_output.put_line('Update_Territory PUB: FND_API.G_EXC_UNEXPECTED_ERROR');
1416: ROLLBACK TO update_territory_pub;
1417: x_return_status := fnd_api.g_ret_sts_unexp_error;
1418: fnd_msg_pub.count_and_get (
1419: p_count => x_msg_count,
1420: p_data => x_msg_data
1421: );

Line 1426: x_return_status := fnd_api.g_ret_sts_unexp_error;

1422: WHEN OTHERS
1423: THEN
1424: --dbms_output.put_line('Update_Territory PUB: OTHERS - ' || SQLERRM);
1425: ROLLBACK TO update_territory_pub;
1426: x_return_status := fnd_api.g_ret_sts_unexp_error;
1427:
1428: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1429: THEN
1430: fnd_msg_pub.add_exc_msg (

Line 1462: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE

1458: -- p_Terr_Id NUMBER
1459: --
1460: -- Optional
1461: -- Parameter Name Data Type Default
1462: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1463: -- p_Commit VARCHAR2 FND_API.G_FALSE
1464: --
1465: -- OUT NOCOPY :
1466: -- Parameter Name Data Type

Line 1463: -- p_Commit VARCHAR2 FND_API.G_FALSE

1459: --
1460: -- Optional
1461: -- Parameter Name Data Type Default
1462: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1463: -- p_Commit VARCHAR2 FND_API.G_FALSE
1464: --
1465: -- OUT NOCOPY :
1466: -- Parameter Name Data Type
1467: -- x_Return_Status VARCHAR2(1)

Line 1479: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1475: -- End of Comments
1476: --
1477: PROCEDURE deactivate_territory (
1478: p_api_version_number IN NUMBER,
1479: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1480: p_commit IN VARCHAR2 := fnd_api.g_false,
1481: x_return_status OUT NOCOPY VARCHAR2,
1482: x_msg_count OUT NOCOPY NUMBER,
1483: x_msg_data OUT NOCOPY VARCHAR2,

Line 1480: p_commit IN VARCHAR2 := fnd_api.g_false,

1476: --
1477: PROCEDURE deactivate_territory (
1478: p_api_version_number IN NUMBER,
1479: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1480: p_commit IN VARCHAR2 := fnd_api.g_false,
1481: x_return_status OUT NOCOPY VARCHAR2,
1482: x_msg_count OUT NOCOPY NUMBER,
1483: x_msg_data OUT NOCOPY VARCHAR2,
1484: p_terr_id IN NUMBER

Line 1495: IF NOT fnd_api.compatible_api_call (

1491: -- Standard Start of API savepoint
1492: SAVEPOINT deactivate_territory_pub;
1493:
1494: -- Standard call to check for call compatibility.
1495: IF NOT fnd_api.compatible_api_call (
1496: l_api_version_number,
1497: p_api_version_number,
1498: l_api_name,
1499: g_pkg_name

Line 1502: RAISE fnd_api.g_exc_unexpected_error;

1498: l_api_name,
1499: g_pkg_name
1500: )
1501: THEN
1502: RAISE fnd_api.g_exc_unexpected_error;
1503: END IF;
1504:
1505: -- Initialize message list if p_init_msg_list is set to TRUE.
1506: IF fnd_api.to_boolean (p_init_msg_list)

Line 1506: IF fnd_api.to_boolean (p_init_msg_list)

1502: RAISE fnd_api.g_exc_unexpected_error;
1503: END IF;
1504:
1505: -- Initialize message list if p_init_msg_list is set to TRUE.
1506: IF fnd_api.to_boolean (p_init_msg_list)
1507: THEN
1508: fnd_msg_pub.initialize;
1509: END IF;
1510:

Line 1520: x_return_status := fnd_api.g_ret_sts_success;

1516: fnd_msg_pub.add;
1517: END IF;
1518:
1519: -- Initialize API return status to success
1520: x_return_status := fnd_api.g_ret_sts_success;
1521: --
1522: -- API body
1523: --
1524: jtf_territory_pvt.deactivate_territory (

Line 1536: IF x_return_status = fnd_api.g_ret_sts_error

1532: );
1533: --x_return_status := l_return_status;
1534:
1535: --
1536: IF x_return_status = fnd_api.g_ret_sts_error
1537: THEN
1538: RAISE fnd_api.g_exc_error;
1539: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1540: THEN

Line 1538: RAISE fnd_api.g_exc_error;

1534:
1535: --
1536: IF x_return_status = fnd_api.g_ret_sts_error
1537: THEN
1538: RAISE fnd_api.g_exc_error;
1539: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1540: THEN
1541: RAISE fnd_api.g_exc_unexpected_error;
1542: END IF;

Line 1539: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1535: --
1536: IF x_return_status = fnd_api.g_ret_sts_error
1537: THEN
1538: RAISE fnd_api.g_exc_error;
1539: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1540: THEN
1541: RAISE fnd_api.g_exc_unexpected_error;
1542: END IF;
1543:

Line 1541: RAISE fnd_api.g_exc_unexpected_error;

1537: THEN
1538: RAISE fnd_api.g_exc_error;
1539: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1540: THEN
1541: RAISE fnd_api.g_exc_unexpected_error;
1542: END IF;
1543:
1544: -- Standard check of p_commit.
1545: IF fnd_api.to_boolean (p_commit)

Line 1545: IF fnd_api.to_boolean (p_commit)

1541: RAISE fnd_api.g_exc_unexpected_error;
1542: END IF;
1543:
1544: -- Standard check of p_commit.
1545: IF fnd_api.to_boolean (p_commit)
1546: THEN
1547: COMMIT WORK;
1548: END IF;
1549:

Line 1561: WHEN fnd_api.g_exc_error

1557:
1558: -- Standard call to get message count and if count is 1, get message info.
1559: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1560: EXCEPTION
1561: WHEN fnd_api.g_exc_error
1562: THEN
1563: ROLLBACK TO deactivate_territory_pub;
1564: x_return_status := fnd_api.g_ret_sts_error;
1565: fnd_msg_pub.count_and_get (

Line 1564: x_return_status := fnd_api.g_ret_sts_error;

1560: EXCEPTION
1561: WHEN fnd_api.g_exc_error
1562: THEN
1563: ROLLBACK TO deactivate_territory_pub;
1564: x_return_status := fnd_api.g_ret_sts_error;
1565: fnd_msg_pub.count_and_get (
1566: p_count => x_msg_count,
1567: p_data => x_msg_data
1568: );

Line 1569: WHEN fnd_api.g_exc_unexpected_error

1565: fnd_msg_pub.count_and_get (
1566: p_count => x_msg_count,
1567: p_data => x_msg_data
1568: );
1569: WHEN fnd_api.g_exc_unexpected_error
1570: THEN
1571: ROLLBACK TO deactivate_territory_pub;
1572: x_return_status := fnd_api.g_ret_sts_unexp_error;
1573: fnd_msg_pub.count_and_get (

Line 1572: x_return_status := fnd_api.g_ret_sts_unexp_error;

1568: );
1569: WHEN fnd_api.g_exc_unexpected_error
1570: THEN
1571: ROLLBACK TO deactivate_territory_pub;
1572: x_return_status := fnd_api.g_ret_sts_unexp_error;
1573: fnd_msg_pub.count_and_get (
1574: p_count => x_msg_count,
1575: p_data => x_msg_data
1576: );

Line 1580: x_return_status := fnd_api.g_ret_sts_unexp_error;

1576: );
1577: WHEN OTHERS
1578: THEN
1579: ROLLBACK TO deactivate_territory_pub;
1580: x_return_status := fnd_api.g_ret_sts_unexp_error;
1581:
1582: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1583: THEN
1584: fnd_msg_pub.add_exc_msg (

Line 1617: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE

1613: -- p_Terr_Values_Tbl Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl
1614: --
1615: -- Optional
1616: -- Parameter Name Data Type Default
1617: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1618: -- p_Commit VARCHAR2 := FND_API.G_FALSE
1619: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL,
1620: --
1621: -- OUT :

Line 1618: -- p_Commit VARCHAR2 := FND_API.G_FALSE

1614: --
1615: -- Optional
1616: -- Parameter Name Data Type Default
1617: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1618: -- p_Commit VARCHAR2 := FND_API.G_FALSE
1619: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL,
1620: --
1621: -- OUT :
1622: -- Parameter Name Data Type

Line 1619: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL,

1615: -- Optional
1616: -- Parameter Name Data Type Default
1617: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1618: -- p_Commit VARCHAR2 := FND_API.G_FALSE
1619: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL,
1620: --
1621: -- OUT :
1622: -- Parameter Name Data Type
1623: -- x_Return_Status VARCHAR2(1)

Line 1634: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1630: --
1631: PROCEDURE Create_Terr_qualifier
1632: (
1633: p_Api_Version_Number IN NUMBER,
1634: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1635: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1637: x_Return_Status OUT NOCOPY VARCHAR2,
1638: x_Msg_Count OUT NOCOPY NUMBER,

Line 1635: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

1631: PROCEDURE Create_Terr_qualifier
1632: (
1633: p_Api_Version_Number IN NUMBER,
1634: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1635: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1637: x_Return_Status OUT NOCOPY VARCHAR2,
1638: x_Msg_Count OUT NOCOPY NUMBER,
1639: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 1636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1632: (
1633: p_Api_Version_Number IN NUMBER,
1634: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1635: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1637: x_Return_Status OUT NOCOPY VARCHAR2,
1638: x_Msg_Count OUT NOCOPY NUMBER,
1639: x_Msg_Data OUT NOCOPY VARCHAR2,
1640: P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,

Line 1660: IF NOT fnd_api.compatible_api_call (

1656: -- Standard Start of API savepoint
1657: SAVEPOINT create_territory_pub;
1658:
1659: -- Standard call to check for call compatibility.
1660: IF NOT fnd_api.compatible_api_call (
1661: l_api_version_number,
1662: p_api_version_number,
1663: l_api_name,
1664: g_pkg_name

Line 1667: RAISE fnd_api.g_exc_unexpected_error;

1663: l_api_name,
1664: g_pkg_name
1665: )
1666: THEN
1667: RAISE fnd_api.g_exc_unexpected_error;
1668: END IF;
1669: -- Initialize message list if p_init_msg_list is set to TRUE.
1670: IF fnd_api.to_boolean (p_init_msg_list)
1671: THEN

Line 1670: IF fnd_api.to_boolean (p_init_msg_list)

1666: THEN
1667: RAISE fnd_api.g_exc_unexpected_error;
1668: END IF;
1669: -- Initialize message list if p_init_msg_list is set to TRUE.
1670: IF fnd_api.to_boolean (p_init_msg_list)
1671: THEN
1672: fnd_msg_pub.initialize;
1673: END IF;
1674:

Line 1684: x_return_status := fnd_api.g_ret_sts_success;

1680: fnd_msg_pub.add;
1681: END IF;
1682:
1683: -- Initialize API return status to success
1684: x_return_status := fnd_api.g_ret_sts_success;
1685: --
1686: -- API body
1687: --
1688: convert_terrqualrec_pubtopvt (

Line 1699: p_init_msg_list => fnd_api.g_false,

1695: );
1696: -- ******************************************************************
1697: jtf_territory_pvt.Create_Terr_qualifier (
1698: p_api_version_number => 1.0,
1699: p_init_msg_list => fnd_api.g_false,
1700: p_commit => fnd_api.g_false,
1701: p_validation_level => fnd_api.g_valid_level_full,
1702: x_return_status => l_return_status,
1703: x_msg_count => x_msg_count,

Line 1700: p_commit => fnd_api.g_false,

1696: -- ******************************************************************
1697: jtf_territory_pvt.Create_Terr_qualifier (
1698: p_api_version_number => 1.0,
1699: p_init_msg_list => fnd_api.g_false,
1700: p_commit => fnd_api.g_false,
1701: p_validation_level => fnd_api.g_valid_level_full,
1702: x_return_status => l_return_status,
1703: x_msg_count => x_msg_count,
1704: x_msg_data => x_msg_data,

Line 1701: p_validation_level => fnd_api.g_valid_level_full,

1697: jtf_territory_pvt.Create_Terr_qualifier (
1698: p_api_version_number => 1.0,
1699: p_init_msg_list => fnd_api.g_false,
1700: p_commit => fnd_api.g_false,
1701: p_validation_level => fnd_api.g_valid_level_full,
1702: x_return_status => l_return_status,
1703: x_msg_count => x_msg_count,
1704: x_msg_data => x_msg_data,
1705: p_terr_qual_rec => l_terr_qual_rec,

Line 1721: IF l_return_status = fnd_api.g_ret_sts_error

1717: );
1718:
1719: x_return_status := l_return_status;
1720:
1721: IF l_return_status = fnd_api.g_ret_sts_error
1722: THEN
1723: RAISE fnd_api.g_exc_error;
1724: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
1725: THEN

Line 1723: RAISE fnd_api.g_exc_error;

1719: x_return_status := l_return_status;
1720:
1721: IF l_return_status = fnd_api.g_ret_sts_error
1722: THEN
1723: RAISE fnd_api.g_exc_error;
1724: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
1725: THEN
1726: RAISE fnd_api.g_exc_unexpected_error;
1727: END IF;

Line 1724: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error

1720:
1721: IF l_return_status = fnd_api.g_ret_sts_error
1722: THEN
1723: RAISE fnd_api.g_exc_error;
1724: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
1725: THEN
1726: RAISE fnd_api.g_exc_unexpected_error;
1727: END IF;
1728:

Line 1726: RAISE fnd_api.g_exc_unexpected_error;

1722: THEN
1723: RAISE fnd_api.g_exc_error;
1724: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
1725: THEN
1726: RAISE fnd_api.g_exc_unexpected_error;
1727: END IF;
1728:
1729: --
1730: -- End of API body.

Line 1734: IF fnd_api.to_boolean (p_commit)

1730: -- End of API body.
1731: --
1732:
1733: -- Standard check of p_commit.
1734: IF fnd_api.to_boolean (p_commit)
1735: THEN
1736: COMMIT WORK;
1737: END IF;
1738:

Line 1750: WHEN fnd_api.g_exc_error

1746:
1747: -- Standard call to get message count and if count is 1, get message info.
1748: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1749: EXCEPTION
1750: WHEN fnd_api.g_exc_error
1751: THEN
1752: ROLLBACK TO create_territory_pub;
1753: x_return_status := fnd_api.g_ret_sts_error;
1754: fnd_msg_pub.count_and_get (

Line 1753: x_return_status := fnd_api.g_ret_sts_error;

1749: EXCEPTION
1750: WHEN fnd_api.g_exc_error
1751: THEN
1752: ROLLBACK TO create_territory_pub;
1753: x_return_status := fnd_api.g_ret_sts_error;
1754: fnd_msg_pub.count_and_get (
1755: p_count => x_msg_count,
1756: p_data => x_msg_data
1757: );

Line 1758: WHEN fnd_api.g_exc_unexpected_error

1754: fnd_msg_pub.count_and_get (
1755: p_count => x_msg_count,
1756: p_data => x_msg_data
1757: );
1758: WHEN fnd_api.g_exc_unexpected_error
1759: THEN
1760: ROLLBACK TO create_territory_pub;
1761: x_return_status := fnd_api.g_ret_sts_unexp_error;
1762: fnd_msg_pub.count_and_get (

Line 1761: x_return_status := fnd_api.g_ret_sts_unexp_error;

1757: );
1758: WHEN fnd_api.g_exc_unexpected_error
1759: THEN
1760: ROLLBACK TO create_territory_pub;
1761: x_return_status := fnd_api.g_ret_sts_unexp_error;
1762: fnd_msg_pub.count_and_get (
1763: p_count => x_msg_count,
1764: p_data => x_msg_data
1765: );

Line 1769: x_return_status := fnd_api.g_ret_sts_unexp_error;

1765: );
1766: WHEN OTHERS
1767: THEN
1768: ROLLBACK TO create_territory_pub;
1769: x_return_status := fnd_api.g_ret_sts_unexp_error;
1770:
1771: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1772: THEN
1773: fnd_msg_pub.add_exc_msg (

Line 1803: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE

1799: -- P_Terr_Qual_Id NUMBER
1800: --
1801: -- Optional
1802: -- Parameter Name Data Type Default
1803: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1804: -- p_Commit VARCHAR2 FND_API.G_FALSE
1805: --
1806: -- OUT :
1807: -- Parameter Name Data Type

Line 1804: -- p_Commit VARCHAR2 FND_API.G_FALSE

1800: --
1801: -- Optional
1802: -- Parameter Name Data Type Default
1803: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1804: -- p_Commit VARCHAR2 FND_API.G_FALSE
1805: --
1806: -- OUT :
1807: -- Parameter Name Data Type
1808: -- p_Return_Status VARCHAR2(1)

Line 1820: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1816: -- End of Comments
1817: --
1818: PROCEDURE Delete_Terr_Qualifier (
1819: p_api_version_number IN NUMBER,
1820: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1821: p_commit IN VARCHAR2 := fnd_api.g_false,
1822: x_return_status OUT NOCOPY VARCHAR2,
1823: x_msg_count OUT NOCOPY NUMBER,
1824: x_msg_data OUT NOCOPY VARCHAR2,

Line 1821: p_commit IN VARCHAR2 := fnd_api.g_false,

1817: --
1818: PROCEDURE Delete_Terr_Qualifier (
1819: p_api_version_number IN NUMBER,
1820: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1821: p_commit IN VARCHAR2 := fnd_api.g_false,
1822: x_return_status OUT NOCOPY VARCHAR2,
1823: x_msg_count OUT NOCOPY NUMBER,
1824: x_msg_data OUT NOCOPY VARCHAR2,
1825: P_Terr_Qual_Id IN NUMBER

Line 1836: IF NOT fnd_api.compatible_api_call (

1832: -- Standard Start of API savepoint
1833: SAVEPOINT delete_territory_pub;
1834:
1835: -- Standard call to check for call compatibility.
1836: IF NOT fnd_api.compatible_api_call (
1837: l_api_version_number,
1838: p_api_version_number,
1839: l_api_name,
1840: g_pkg_name

Line 1843: RAISE fnd_api.g_exc_unexpected_error;

1839: l_api_name,
1840: g_pkg_name
1841: )
1842: THEN
1843: RAISE fnd_api.g_exc_unexpected_error;
1844: END IF;
1845:
1846: -- Initialize message list if p_init_msg_list is set to TRUE.
1847: IF fnd_api.to_boolean (p_init_msg_list)

Line 1847: IF fnd_api.to_boolean (p_init_msg_list)

1843: RAISE fnd_api.g_exc_unexpected_error;
1844: END IF;
1845:
1846: -- Initialize message list if p_init_msg_list is set to TRUE.
1847: IF fnd_api.to_boolean (p_init_msg_list)
1848: THEN
1849: fnd_msg_pub.initialize;
1850: END IF;
1851:

Line 1861: x_return_status := fnd_api.g_ret_sts_success;

1857: fnd_msg_pub.add;
1858: END IF;
1859:
1860: -- Initialize API return status to success
1861: x_return_status := fnd_api.g_ret_sts_success;
1862: --
1863: -- API body
1864: --
1865: jtf_territory_pvt.Delete_Terr_Qualifier (

Line 1878: IF l_return_status = fnd_api.g_ret_sts_error

1874:
1875: x_return_status := l_return_status;
1876:
1877: --
1878: IF l_return_status = fnd_api.g_ret_sts_error
1879: THEN
1880: RAISE fnd_api.g_exc_error;
1881: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
1882: THEN

Line 1880: RAISE fnd_api.g_exc_error;

1876:
1877: --
1878: IF l_return_status = fnd_api.g_ret_sts_error
1879: THEN
1880: RAISE fnd_api.g_exc_error;
1881: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
1882: THEN
1883: RAISE fnd_api.g_exc_unexpected_error;
1884: END IF;

Line 1881: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error

1877: --
1878: IF l_return_status = fnd_api.g_ret_sts_error
1879: THEN
1880: RAISE fnd_api.g_exc_error;
1881: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
1882: THEN
1883: RAISE fnd_api.g_exc_unexpected_error;
1884: END IF;
1885:

Line 1883: RAISE fnd_api.g_exc_unexpected_error;

1879: THEN
1880: RAISE fnd_api.g_exc_error;
1881: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
1882: THEN
1883: RAISE fnd_api.g_exc_unexpected_error;
1884: END IF;
1885:
1886: -- Standard check of p_commit.
1887: IF fnd_api.to_boolean (p_commit)

Line 1887: IF fnd_api.to_boolean (p_commit)

1883: RAISE fnd_api.g_exc_unexpected_error;
1884: END IF;
1885:
1886: -- Standard check of p_commit.
1887: IF fnd_api.to_boolean (p_commit)
1888: THEN
1889: COMMIT WORK;
1890: END IF;
1891:

Line 1903: WHEN fnd_api.g_exc_error

1899:
1900: -- Standard call to get message count and if count is 1, get message info.
1901: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1902: EXCEPTION
1903: WHEN fnd_api.g_exc_error
1904: THEN
1905: ROLLBACK TO delete_territory_pub;
1906: x_return_status := fnd_api.g_ret_sts_error;
1907: fnd_msg_pub.count_and_get (

Line 1906: x_return_status := fnd_api.g_ret_sts_error;

1902: EXCEPTION
1903: WHEN fnd_api.g_exc_error
1904: THEN
1905: ROLLBACK TO delete_territory_pub;
1906: x_return_status := fnd_api.g_ret_sts_error;
1907: fnd_msg_pub.count_and_get (
1908: p_count => x_msg_count,
1909: p_data => x_msg_data
1910: );

Line 1911: WHEN fnd_api.g_exc_unexpected_error

1907: fnd_msg_pub.count_and_get (
1908: p_count => x_msg_count,
1909: p_data => x_msg_data
1910: );
1911: WHEN fnd_api.g_exc_unexpected_error
1912: THEN
1913: ROLLBACK TO delete_territory_pub;
1914: x_return_status := fnd_api.g_ret_sts_unexp_error;
1915: fnd_msg_pub.count_and_get (

Line 1914: x_return_status := fnd_api.g_ret_sts_unexp_error;

1910: );
1911: WHEN fnd_api.g_exc_unexpected_error
1912: THEN
1913: ROLLBACK TO delete_territory_pub;
1914: x_return_status := fnd_api.g_ret_sts_unexp_error;
1915: fnd_msg_pub.count_and_get (
1916: p_count => x_msg_count,
1917: p_data => x_msg_data
1918: );

Line 1922: x_return_status := fnd_api.g_ret_sts_unexp_error;

1918: );
1919: WHEN OTHERS
1920: THEN
1921: ROLLBACK TO delete_territory_pub;
1922: x_return_status := fnd_api.g_ret_sts_unexp_error;
1923:
1924: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1925: THEN
1926: fnd_msg_pub.add_exc_msg (

Line 1956: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE

1952: -- p_Terr_Values_Tbl Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl
1953: --
1954: -- Optional
1955: -- Parameter Name Data Type Default
1956: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1957: -- p_Commit VARCHAR2 := FND_API.G_FALSE
1958: --
1959: -- OUT NOCOPY :
1960: -- Parameter Name Data Type

Line 1957: -- p_Commit VARCHAR2 := FND_API.G_FALSE

1953: --
1954: -- Optional
1955: -- Parameter Name Data Type Default
1956: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1957: -- p_Commit VARCHAR2 := FND_API.G_FALSE
1958: --
1959: -- OUT NOCOPY :
1960: -- Parameter Name Data Type
1961: -- p_Return_Status VARCHAR2(1)

Line 1973: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1969: -- End of Comments
1970: --
1971: PROCEDURE Create_Qualifier_Value (
1972: p_api_version_number IN NUMBER,
1973: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1974: p_commit IN VARCHAR2 := fnd_api.g_false,
1975: x_return_status OUT NOCOPY VARCHAR2,
1976: x_msg_count OUT NOCOPY NUMBER,
1977: x_msg_data OUT NOCOPY VARCHAR2,

Line 1974: p_commit IN VARCHAR2 := fnd_api.g_false,

1970: --
1971: PROCEDURE Create_Qualifier_Value (
1972: p_api_version_number IN NUMBER,
1973: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1974: p_commit IN VARCHAR2 := fnd_api.g_false,
1975: x_return_status OUT NOCOPY VARCHAR2,
1976: x_msg_count OUT NOCOPY NUMBER,
1977: x_msg_data OUT NOCOPY VARCHAR2,
1978: p_terr_qual_id IN NUMBER,

Line 1997: IF NOT fnd_api.compatible_api_call (

1993: -- Standard Start of API savepoint
1994: SAVEPOINT update_territory_pub;
1995:
1996: -- Standard call to check for call compatibility.
1997: IF NOT fnd_api.compatible_api_call (
1998: l_api_version_number,
1999: p_api_version_number,
2000: l_api_name,
2001: g_pkg_name

Line 2004: RAISE fnd_api.g_exc_unexpected_error;

2000: l_api_name,
2001: g_pkg_name
2002: )
2003: THEN
2004: RAISE fnd_api.g_exc_unexpected_error;
2005: END IF;
2006:
2007: -- Initialize message list if p_init_msg_list is set to TRUE.
2008: IF fnd_api.to_boolean (p_init_msg_list)

Line 2008: IF fnd_api.to_boolean (p_init_msg_list)

2004: RAISE fnd_api.g_exc_unexpected_error;
2005: END IF;
2006:
2007: -- Initialize message list if p_init_msg_list is set to TRUE.
2008: IF fnd_api.to_boolean (p_init_msg_list)
2009: THEN
2010: fnd_msg_pub.initialize;
2011: END IF;
2012:

Line 2022: x_return_status := fnd_api.g_ret_sts_success;

2018: fnd_msg_pub.add;
2019: END IF;
2020:
2021: -- Initialize API return status to success
2022: x_return_status := fnd_api.g_ret_sts_success;
2023: --
2024: -- API body
2025: --
2026: --

Line 2038: P_Init_Msg_List => fnd_api.g_false,

2034: -- Check whether ant data is passed for update of value table
2035: If P_Terr_Values_Tbl.Count > 0 Then
2036: --dbms_output('Update_Territory PVT: Before Calling Update_Terr_Value');
2037: jtf_territory_pvt.create_terr_value( P_Api_Version_Number => 1.0,
2038: P_Init_Msg_List => fnd_api.g_false,
2039: P_Commit => fnd_api.g_false,
2040: p_validation_level => fnd_api.g_valid_level_full,
2041: P_Terr_Id => null,
2042: p_terr_qual_id => p_terr_qual_id,

Line 2039: P_Commit => fnd_api.g_false,

2035: If P_Terr_Values_Tbl.Count > 0 Then
2036: --dbms_output('Update_Territory PVT: Before Calling Update_Terr_Value');
2037: jtf_territory_pvt.create_terr_value( P_Api_Version_Number => 1.0,
2038: P_Init_Msg_List => fnd_api.g_false,
2039: P_Commit => fnd_api.g_false,
2040: p_validation_level => fnd_api.g_valid_level_full,
2041: P_Terr_Id => null,
2042: p_terr_qual_id => p_terr_qual_id,
2043: P_Terr_Value_Tbl => l_Terr_Values_Tbl,

Line 2040: p_validation_level => fnd_api.g_valid_level_full,

2036: --dbms_output('Update_Territory PVT: Before Calling Update_Terr_Value');
2037: jtf_territory_pvt.create_terr_value( P_Api_Version_Number => 1.0,
2038: P_Init_Msg_List => fnd_api.g_false,
2039: P_Commit => fnd_api.g_false,
2040: p_validation_level => fnd_api.g_valid_level_full,
2041: P_Terr_Id => null,
2042: p_terr_qual_id => p_terr_qual_id,
2043: P_Terr_Value_Tbl => l_Terr_Values_Tbl,
2044: X_Return_Status => l_Return_Status,

Line 2048: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2044: X_Return_Status => l_Return_Status,
2045: X_Msg_Count => x_Msg_Count,
2046: X_Msg_Data => x_Msg_Data,
2047: X_Terr_Value_Out_Tbl => l_Terr_Values_Out_Tbl);
2048: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2049: RAISE FND_API.G_EXC_ERROR;
2050: END IF;
2051: End If;
2052:

Line 2049: RAISE FND_API.G_EXC_ERROR;

2045: X_Msg_Count => x_Msg_Count,
2046: X_Msg_Data => x_Msg_Data,
2047: X_Terr_Value_Out_Tbl => l_Terr_Values_Out_Tbl);
2048: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2049: RAISE FND_API.G_EXC_ERROR;
2050: END IF;
2051: End If;
2052:
2053: --dbms_output.put_line('Update_Territory PUB: Before Calling Convertion routine from PVT to PUB');

Line 2061: IF l_return_status <> fnd_api.g_ret_sts_success

2057: );
2058:
2059: x_return_status := l_return_status;
2060: --
2061: IF l_return_status <> fnd_api.g_ret_sts_success
2062: THEN
2063: RAISE fnd_api.g_exc_error;
2064: END IF;
2065:

Line 2063: RAISE fnd_api.g_exc_error;

2059: x_return_status := l_return_status;
2060: --
2061: IF l_return_status <> fnd_api.g_ret_sts_success
2062: THEN
2063: RAISE fnd_api.g_exc_error;
2064: END IF;
2065:
2066: -- Debug Message
2067: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 2077: IF fnd_api.to_boolean (p_commit)

2073:
2074: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2075:
2076: -- Standard check for p_commit
2077: IF fnd_api.to_boolean (p_commit)
2078: THEN
2079: COMMIT WORK;
2080: END IF;
2081: --dbms_output.put_line('create_terr_value PUB: Exiting API');

Line 2085: WHEN fnd_api.g_exc_error

2081: --dbms_output.put_line('create_terr_value PUB: Exiting API');
2082: --
2083: EXCEPTION
2084: --
2085: WHEN fnd_api.g_exc_error
2086: THEN
2087: --dbms_output.put_line('Update_Territory Values PUB: FND_API.G_EXC_ERROR');
2088: ROLLBACK TO update_territory_pub;
2089: x_return_status := fnd_api.g_ret_sts_error;

Line 2087: --dbms_output.put_line('Update_Territory Values PUB: FND_API.G_EXC_ERROR');

2083: EXCEPTION
2084: --
2085: WHEN fnd_api.g_exc_error
2086: THEN
2087: --dbms_output.put_line('Update_Territory Values PUB: FND_API.G_EXC_ERROR');
2088: ROLLBACK TO update_territory_pub;
2089: x_return_status := fnd_api.g_ret_sts_error;
2090: fnd_msg_pub.count_and_get (
2091: p_count => x_msg_count,

Line 2089: x_return_status := fnd_api.g_ret_sts_error;

2085: WHEN fnd_api.g_exc_error
2086: THEN
2087: --dbms_output.put_line('Update_Territory Values PUB: FND_API.G_EXC_ERROR');
2088: ROLLBACK TO update_territory_pub;
2089: x_return_status := fnd_api.g_ret_sts_error;
2090: fnd_msg_pub.count_and_get (
2091: p_count => x_msg_count,
2092: p_data => x_msg_data
2093: );

Line 2094: WHEN fnd_api.g_exc_unexpected_error

2090: fnd_msg_pub.count_and_get (
2091: p_count => x_msg_count,
2092: p_data => x_msg_data
2093: );
2094: WHEN fnd_api.g_exc_unexpected_error
2095: THEN
2096: --dbms_output.put_line('Update_Territory_Values PUB: FND_API.G_EXC_UNEXPECTED_ERROR');
2097: ROLLBACK TO update_territory_pub;
2098: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2096: --dbms_output.put_line('Update_Territory_Values PUB: FND_API.G_EXC_UNEXPECTED_ERROR');

2092: p_data => x_msg_data
2093: );
2094: WHEN fnd_api.g_exc_unexpected_error
2095: THEN
2096: --dbms_output.put_line('Update_Territory_Values PUB: FND_API.G_EXC_UNEXPECTED_ERROR');
2097: ROLLBACK TO update_territory_pub;
2098: x_return_status := fnd_api.g_ret_sts_unexp_error;
2099: fnd_msg_pub.count_and_get (
2100: p_count => x_msg_count,

Line 2098: x_return_status := fnd_api.g_ret_sts_unexp_error;

2094: WHEN fnd_api.g_exc_unexpected_error
2095: THEN
2096: --dbms_output.put_line('Update_Territory_Values PUB: FND_API.G_EXC_UNEXPECTED_ERROR');
2097: ROLLBACK TO update_territory_pub;
2098: x_return_status := fnd_api.g_ret_sts_unexp_error;
2099: fnd_msg_pub.count_and_get (
2100: p_count => x_msg_count,
2101: p_data => x_msg_data
2102: );

Line 2107: x_return_status := fnd_api.g_ret_sts_unexp_error;

2103: WHEN OTHERS
2104: THEN
2105: --dbms_output.put_line('Update_Territory Values PUB: OTHERS - ' || SQLERRM);
2106: ROLLBACK TO update_territory_pub;
2107: x_return_status := fnd_api.g_ret_sts_unexp_error;
2108:
2109: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2110: THEN
2111: fnd_msg_pub.add_exc_msg (

Line 2140: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE

2136: -- p_Terr_Values_Tbl Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl
2137: --
2138: -- Optional
2139: -- Parameter Name Data Type Default
2140: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
2141: -- p_Commit VARCHAR2 := FND_API.G_FALSE
2142: --
2143: -- OUT NOCOPY :
2144: -- Parameter Name Data Type

Line 2141: -- p_Commit VARCHAR2 := FND_API.G_FALSE

2137: --
2138: -- Optional
2139: -- Parameter Name Data Type Default
2140: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
2141: -- p_Commit VARCHAR2 := FND_API.G_FALSE
2142: --
2143: -- OUT NOCOPY :
2144: -- Parameter Name Data Type
2145: -- p_Return_Status VARCHAR2(1)

Line 2157: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

2153: -- End of Comments
2154: --
2155: PROCEDURE Update_Qualifier_Value (
2156: p_api_version_number IN NUMBER,
2157: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2158: p_commit IN VARCHAR2 := fnd_api.g_false,
2159: x_return_status OUT NOCOPY VARCHAR2,
2160: x_msg_count OUT NOCOPY NUMBER,
2161: x_msg_data OUT NOCOPY VARCHAR2,

Line 2158: p_commit IN VARCHAR2 := fnd_api.g_false,

2154: --
2155: PROCEDURE Update_Qualifier_Value (
2156: p_api_version_number IN NUMBER,
2157: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2158: p_commit IN VARCHAR2 := fnd_api.g_false,
2159: x_return_status OUT NOCOPY VARCHAR2,
2160: x_msg_count OUT NOCOPY NUMBER,
2161: x_msg_data OUT NOCOPY VARCHAR2,
2162: p_terr_values_tbl IN terr_values_tbl_type

Line 2179: IF NOT fnd_api.compatible_api_call (

2175: -- Standard Start of API savepoint
2176: SAVEPOINT update_territory_pub;
2177:
2178: -- Standard call to check for call compatibility.
2179: IF NOT fnd_api.compatible_api_call (
2180: l_api_version_number,
2181: p_api_version_number,
2182: l_api_name,
2183: g_pkg_name

Line 2186: RAISE fnd_api.g_exc_unexpected_error;

2182: l_api_name,
2183: g_pkg_name
2184: )
2185: THEN
2186: RAISE fnd_api.g_exc_unexpected_error;
2187: END IF;
2188:
2189: -- Initialize message list if p_init_msg_list is set to TRUE.
2190: IF fnd_api.to_boolean (p_init_msg_list)

Line 2190: IF fnd_api.to_boolean (p_init_msg_list)

2186: RAISE fnd_api.g_exc_unexpected_error;
2187: END IF;
2188:
2189: -- Initialize message list if p_init_msg_list is set to TRUE.
2190: IF fnd_api.to_boolean (p_init_msg_list)
2191: THEN
2192: fnd_msg_pub.initialize;
2193: END IF;
2194:

Line 2204: x_return_status := fnd_api.g_ret_sts_success;

2200: fnd_msg_pub.add;
2201: END IF;
2202:
2203: -- Initialize API return status to success
2204: x_return_status := fnd_api.g_ret_sts_success;
2205: --
2206: -- API body
2207: --
2208: --

Line 2220: P_Init_Msg_List => fnd_api.g_false,

2216: -- Check whether ant data is passed for update of value table
2217: If P_Terr_Values_Tbl.Count > 0 Then
2218: --dbms_output('Update_Territory PVT: Before Calling Update_Terr_Value');
2219: jtf_territory_pvt.Update_Terr_Value( P_Api_Version_Number => 1.0,
2220: P_Init_Msg_List => fnd_api.g_false,
2221: P_Commit => fnd_api.g_false,
2222: p_validation_level => fnd_api.g_valid_level_full,
2223: P_Terr_Value_Tbl => l_Terr_Values_Tbl,
2224: X_Return_Status => l_Return_Status,

Line 2221: P_Commit => fnd_api.g_false,

2217: If P_Terr_Values_Tbl.Count > 0 Then
2218: --dbms_output('Update_Territory PVT: Before Calling Update_Terr_Value');
2219: jtf_territory_pvt.Update_Terr_Value( P_Api_Version_Number => 1.0,
2220: P_Init_Msg_List => fnd_api.g_false,
2221: P_Commit => fnd_api.g_false,
2222: p_validation_level => fnd_api.g_valid_level_full,
2223: P_Terr_Value_Tbl => l_Terr_Values_Tbl,
2224: X_Return_Status => l_Return_Status,
2225: X_Msg_Count => x_Msg_Count,

Line 2222: p_validation_level => fnd_api.g_valid_level_full,

2218: --dbms_output('Update_Territory PVT: Before Calling Update_Terr_Value');
2219: jtf_territory_pvt.Update_Terr_Value( P_Api_Version_Number => 1.0,
2220: P_Init_Msg_List => fnd_api.g_false,
2221: P_Commit => fnd_api.g_false,
2222: p_validation_level => fnd_api.g_valid_level_full,
2223: P_Terr_Value_Tbl => l_Terr_Values_Tbl,
2224: X_Return_Status => l_Return_Status,
2225: X_Msg_Count => x_Msg_Count,
2226: X_Msg_Data => x_Msg_Data,

Line 2228: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2224: X_Return_Status => l_Return_Status,
2225: X_Msg_Count => x_Msg_Count,
2226: X_Msg_Data => x_Msg_Data,
2227: X_Terr_Value_Out_Tbl => l_Terr_Values_Out_Tbl);
2228: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2229: RAISE FND_API.G_EXC_ERROR;
2230: END IF;
2231: End If;
2232:

Line 2229: RAISE FND_API.G_EXC_ERROR;

2225: X_Msg_Count => x_Msg_Count,
2226: X_Msg_Data => x_Msg_Data,
2227: X_Terr_Value_Out_Tbl => l_Terr_Values_Out_Tbl);
2228: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2229: RAISE FND_API.G_EXC_ERROR;
2230: END IF;
2231: End If;
2232:
2233: --dbms_output.put_line('Update_Territory PUB: Before Calling Convertion routine from PVT to PUB');

Line 2241: IF l_return_status <> fnd_api.g_ret_sts_success

2237: );
2238:
2239: x_return_status := l_return_status;
2240: --
2241: IF l_return_status <> fnd_api.g_ret_sts_success
2242: THEN
2243: RAISE fnd_api.g_exc_error;
2244: END IF;
2245:

Line 2243: RAISE fnd_api.g_exc_error;

2239: x_return_status := l_return_status;
2240: --
2241: IF l_return_status <> fnd_api.g_ret_sts_success
2242: THEN
2243: RAISE fnd_api.g_exc_error;
2244: END IF;
2245:
2246: -- Debug Message
2247: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 2257: IF fnd_api.to_boolean (p_commit)

2253:
2254: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2255:
2256: -- Standard check for p_commit
2257: IF fnd_api.to_boolean (p_commit)
2258: THEN
2259: COMMIT WORK;
2260: END IF;
2261: --dbms_output.put_line('Update_Territory values PUB: Exiting API');

Line 2265: WHEN fnd_api.g_exc_error

2261: --dbms_output.put_line('Update_Territory values PUB: Exiting API');
2262: --
2263: EXCEPTION
2264: --
2265: WHEN fnd_api.g_exc_error
2266: THEN
2267: --dbms_output.put_line('Update_Territory Values PUB: FND_API.G_EXC_ERROR');
2268: ROLLBACK TO update_territory_pub;
2269: x_return_status := fnd_api.g_ret_sts_error;

Line 2267: --dbms_output.put_line('Update_Territory Values PUB: FND_API.G_EXC_ERROR');

2263: EXCEPTION
2264: --
2265: WHEN fnd_api.g_exc_error
2266: THEN
2267: --dbms_output.put_line('Update_Territory Values PUB: FND_API.G_EXC_ERROR');
2268: ROLLBACK TO update_territory_pub;
2269: x_return_status := fnd_api.g_ret_sts_error;
2270: fnd_msg_pub.count_and_get (
2271: p_count => x_msg_count,

Line 2269: x_return_status := fnd_api.g_ret_sts_error;

2265: WHEN fnd_api.g_exc_error
2266: THEN
2267: --dbms_output.put_line('Update_Territory Values PUB: FND_API.G_EXC_ERROR');
2268: ROLLBACK TO update_territory_pub;
2269: x_return_status := fnd_api.g_ret_sts_error;
2270: fnd_msg_pub.count_and_get (
2271: p_count => x_msg_count,
2272: p_data => x_msg_data
2273: );

Line 2274: WHEN fnd_api.g_exc_unexpected_error

2270: fnd_msg_pub.count_and_get (
2271: p_count => x_msg_count,
2272: p_data => x_msg_data
2273: );
2274: WHEN fnd_api.g_exc_unexpected_error
2275: THEN
2276: --dbms_output.put_line('Update_Territory_Values PUB: FND_API.G_EXC_UNEXPECTED_ERROR');
2277: ROLLBACK TO update_territory_pub;
2278: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2276: --dbms_output.put_line('Update_Territory_Values PUB: FND_API.G_EXC_UNEXPECTED_ERROR');

2272: p_data => x_msg_data
2273: );
2274: WHEN fnd_api.g_exc_unexpected_error
2275: THEN
2276: --dbms_output.put_line('Update_Territory_Values PUB: FND_API.G_EXC_UNEXPECTED_ERROR');
2277: ROLLBACK TO update_territory_pub;
2278: x_return_status := fnd_api.g_ret_sts_unexp_error;
2279: fnd_msg_pub.count_and_get (
2280: p_count => x_msg_count,

Line 2278: x_return_status := fnd_api.g_ret_sts_unexp_error;

2274: WHEN fnd_api.g_exc_unexpected_error
2275: THEN
2276: --dbms_output.put_line('Update_Territory_Values PUB: FND_API.G_EXC_UNEXPECTED_ERROR');
2277: ROLLBACK TO update_territory_pub;
2278: x_return_status := fnd_api.g_ret_sts_unexp_error;
2279: fnd_msg_pub.count_and_get (
2280: p_count => x_msg_count,
2281: p_data => x_msg_data
2282: );

Line 2287: x_return_status := fnd_api.g_ret_sts_unexp_error;

2283: WHEN OTHERS
2284: THEN
2285: --dbms_output.put_line('Update_Territory Values PUB: OTHERS - ' || SQLERRM);
2286: ROLLBACK TO update_territory_pub;
2287: x_return_status := fnd_api.g_ret_sts_unexp_error;
2288:
2289: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2290: THEN
2291: fnd_msg_pub.add_exc_msg (

Line 2321: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE

2317: -- P_Terr_Value_Id NUMBER
2318: --
2319: -- Optional
2320: -- Parameter Name Data Type Default
2321: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
2322: -- p_Commit VARCHAR2 FND_API.G_FALSE
2323: --
2324: -- OUT :
2325: -- Parameter Name Data Type

Line 2322: -- p_Commit VARCHAR2 FND_API.G_FALSE

2318: --
2319: -- Optional
2320: -- Parameter Name Data Type Default
2321: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
2322: -- p_Commit VARCHAR2 FND_API.G_FALSE
2323: --
2324: -- OUT :
2325: -- Parameter Name Data Type
2326: -- p_Return_Status VARCHAR2(1)

Line 2338: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

2334: -- End of Comments
2335: --
2336: PROCEDURE Delete_Qualifier_Value (
2337: p_api_version_number IN NUMBER,
2338: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2339: p_commit IN VARCHAR2 := fnd_api.g_false,
2340: x_return_status OUT NOCOPY VARCHAR2,
2341: x_msg_count OUT NOCOPY NUMBER,
2342: x_msg_data OUT NOCOPY VARCHAR2,

Line 2339: p_commit IN VARCHAR2 := fnd_api.g_false,

2335: --
2336: PROCEDURE Delete_Qualifier_Value (
2337: p_api_version_number IN NUMBER,
2338: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2339: p_commit IN VARCHAR2 := fnd_api.g_false,
2340: x_return_status OUT NOCOPY VARCHAR2,
2341: x_msg_count OUT NOCOPY NUMBER,
2342: x_msg_data OUT NOCOPY VARCHAR2,
2343: P_Terr_Value_Id IN NUMBER

Line 2354: IF NOT fnd_api.compatible_api_call (

2350: -- Standard Start of API savepoint
2351: SAVEPOINT delete_territory_pub;
2352:
2353: -- Standard call to check for call compatibility.
2354: IF NOT fnd_api.compatible_api_call (
2355: l_api_version_number,
2356: p_api_version_number,
2357: l_api_name,
2358: g_pkg_name

Line 2361: RAISE fnd_api.g_exc_unexpected_error;

2357: l_api_name,
2358: g_pkg_name
2359: )
2360: THEN
2361: RAISE fnd_api.g_exc_unexpected_error;
2362: END IF;
2363:
2364: -- Initialize message list if p_init_msg_list is set to TRUE.
2365: IF fnd_api.to_boolean (p_init_msg_list)

Line 2365: IF fnd_api.to_boolean (p_init_msg_list)

2361: RAISE fnd_api.g_exc_unexpected_error;
2362: END IF;
2363:
2364: -- Initialize message list if p_init_msg_list is set to TRUE.
2365: IF fnd_api.to_boolean (p_init_msg_list)
2366: THEN
2367: fnd_msg_pub.initialize;
2368: END IF;
2369:

Line 2379: x_return_status := fnd_api.g_ret_sts_success;

2375: fnd_msg_pub.add;
2376: END IF;
2377:
2378: -- Initialize API return status to success
2379: x_return_status := fnd_api.g_ret_sts_success;
2380: --
2381: -- API body
2382: --
2383:

Line 2397: IF l_return_status = fnd_api.g_ret_sts_error

2393:
2394: x_return_status := l_return_status;
2395:
2396: --
2397: IF l_return_status = fnd_api.g_ret_sts_error
2398: THEN
2399: RAISE fnd_api.g_exc_error;
2400: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2401: THEN

Line 2399: RAISE fnd_api.g_exc_error;

2395:
2396: --
2397: IF l_return_status = fnd_api.g_ret_sts_error
2398: THEN
2399: RAISE fnd_api.g_exc_error;
2400: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2401: THEN
2402: RAISE fnd_api.g_exc_unexpected_error;
2403: END IF;

Line 2400: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error

2396: --
2397: IF l_return_status = fnd_api.g_ret_sts_error
2398: THEN
2399: RAISE fnd_api.g_exc_error;
2400: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2401: THEN
2402: RAISE fnd_api.g_exc_unexpected_error;
2403: END IF;
2404:

Line 2402: RAISE fnd_api.g_exc_unexpected_error;

2398: THEN
2399: RAISE fnd_api.g_exc_error;
2400: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2401: THEN
2402: RAISE fnd_api.g_exc_unexpected_error;
2403: END IF;
2404:
2405: -- Standard check of p_commit.
2406: IF fnd_api.to_boolean (p_commit)

Line 2406: IF fnd_api.to_boolean (p_commit)

2402: RAISE fnd_api.g_exc_unexpected_error;
2403: END IF;
2404:
2405: -- Standard check of p_commit.
2406: IF fnd_api.to_boolean (p_commit)
2407: THEN
2408: COMMIT WORK;
2409: END IF;
2410:

Line 2422: WHEN fnd_api.g_exc_error

2418:
2419: -- Standard call to get message count and if count is 1, get message info.
2420: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2421: EXCEPTION
2422: WHEN fnd_api.g_exc_error
2423: THEN
2424: ROLLBACK TO delete_territory_pub;
2425: x_return_status := fnd_api.g_ret_sts_error;
2426: fnd_msg_pub.count_and_get (

Line 2425: x_return_status := fnd_api.g_ret_sts_error;

2421: EXCEPTION
2422: WHEN fnd_api.g_exc_error
2423: THEN
2424: ROLLBACK TO delete_territory_pub;
2425: x_return_status := fnd_api.g_ret_sts_error;
2426: fnd_msg_pub.count_and_get (
2427: p_count => x_msg_count,
2428: p_data => x_msg_data
2429: );

Line 2430: WHEN fnd_api.g_exc_unexpected_error

2426: fnd_msg_pub.count_and_get (
2427: p_count => x_msg_count,
2428: p_data => x_msg_data
2429: );
2430: WHEN fnd_api.g_exc_unexpected_error
2431: THEN
2432: ROLLBACK TO delete_territory_pub;
2433: x_return_status := fnd_api.g_ret_sts_unexp_error;
2434: fnd_msg_pub.count_and_get (

Line 2433: x_return_status := fnd_api.g_ret_sts_unexp_error;

2429: );
2430: WHEN fnd_api.g_exc_unexpected_error
2431: THEN
2432: ROLLBACK TO delete_territory_pub;
2433: x_return_status := fnd_api.g_ret_sts_unexp_error;
2434: fnd_msg_pub.count_and_get (
2435: p_count => x_msg_count,
2436: p_data => x_msg_data
2437: );

Line 2441: x_return_status := fnd_api.g_ret_sts_unexp_error;

2437: );
2438: WHEN OTHERS
2439: THEN
2440: ROLLBACK TO delete_territory_pub;
2441: x_return_status := fnd_api.g_ret_sts_unexp_error;
2442:
2443: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2444: THEN
2445: fnd_msg_pub.add_exc_msg (

Line 2481: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE

2477: -- p_TerrRsc_Access_Tbl TerrRsc_Access_tbl_type := G_MISS_TERRRSC_ACCESS_TBL
2478: --
2479: -- Optional
2480: -- Parameter Name Data Type Default
2481: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
2482: -- p_Commit VARCHAR2 := FND_API.G_FALSE
2483: --
2484: -- OUT NOCOPY :
2485: -- Parameter Name Data Type

Line 2482: -- p_Commit VARCHAR2 := FND_API.G_FALSE

2478: --
2479: -- Optional
2480: -- Parameter Name Data Type Default
2481: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
2482: -- p_Commit VARCHAR2 := FND_API.G_FALSE
2483: --
2484: -- OUT NOCOPY :
2485: -- Parameter Name Data Type
2486: -- x_Return_Status VARCHAR2(1)

Line 2500: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

2496: -- End of Comments
2497: --
2498: PROCEDURE create_terrresource (
2499: p_api_version_number IN NUMBER,
2500: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2501: p_commit IN VARCHAR2 := fnd_api.g_false,
2502: x_return_status OUT NOCOPY VARCHAR2,
2503: x_msg_count OUT NOCOPY NUMBER,
2504: x_msg_data OUT NOCOPY VARCHAR2,

Line 2501: p_commit IN VARCHAR2 := fnd_api.g_false,

2497: --
2498: PROCEDURE create_terrresource (
2499: p_api_version_number IN NUMBER,
2500: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2501: p_commit IN VARCHAR2 := fnd_api.g_false,
2502: x_return_status OUT NOCOPY VARCHAR2,
2503: x_msg_count OUT NOCOPY NUMBER,
2504: x_msg_data OUT NOCOPY VARCHAR2,
2505: p_terrrsc_tbl IN terrresource_tbl_type

Line 2527: IF NOT fnd_api.compatible_api_call (

2523: -- Standard Start of API savepoint
2524: SAVEPOINT create_terrresource_pub;
2525:
2526: -- Standard call to check for call compatibility.
2527: IF NOT fnd_api.compatible_api_call (
2528: l_api_version_number,
2529: p_api_version_number,
2530: l_api_name,
2531: g_pkg_name

Line 2534: RAISE fnd_api.g_exc_unexpected_error;

2530: l_api_name,
2531: g_pkg_name
2532: )
2533: THEN
2534: RAISE fnd_api.g_exc_unexpected_error;
2535: END IF;
2536:
2537: -- Initialize message list if p_init_msg_list is set to TRUE.
2538: IF fnd_api.to_boolean (p_init_msg_list)

Line 2538: IF fnd_api.to_boolean (p_init_msg_list)

2534: RAISE fnd_api.g_exc_unexpected_error;
2535: END IF;
2536:
2537: -- Initialize message list if p_init_msg_list is set to TRUE.
2538: IF fnd_api.to_boolean (p_init_msg_list)
2539: THEN
2540: fnd_msg_pub.initialize;
2541: END IF;
2542: fnd_msg_pub.initialize;

Line 2553: x_return_status := fnd_api.g_ret_sts_success;

2549: fnd_msg_pub.add;
2550: END IF;
2551:
2552: -- Initialize API return status to success
2553: x_return_status := fnd_api.g_ret_sts_success;
2554: -- Convert incomming data from public to private Tbl format
2555: convert_terrrsc_pubtopvt (
2556: p_terrrsc_tbl => p_terrrsc_tbl,
2557: x_terrrsc_tbl => l_terrrsc_tbl

Line 2568: p_init_msg_list => fnd_api.g_false,

2564: -- API body
2565: --
2566: jtf_territory_resource_pvt.create_terrresource (
2567: p_api_version_number => 1.0,
2568: p_init_msg_list => fnd_api.g_false,
2569: p_commit => fnd_api.g_false,
2570: p_validation_level => fnd_api.g_valid_level_full,
2571: x_return_status => l_return_status,
2572: x_msg_count => x_msg_count,

Line 2569: p_commit => fnd_api.g_false,

2565: --
2566: jtf_territory_resource_pvt.create_terrresource (
2567: p_api_version_number => 1.0,
2568: p_init_msg_list => fnd_api.g_false,
2569: p_commit => fnd_api.g_false,
2570: p_validation_level => fnd_api.g_valid_level_full,
2571: x_return_status => l_return_status,
2572: x_msg_count => x_msg_count,
2573: x_msg_data => x_msg_data,

Line 2570: p_validation_level => fnd_api.g_valid_level_full,

2566: jtf_territory_resource_pvt.create_terrresource (
2567: p_api_version_number => 1.0,
2568: p_init_msg_list => fnd_api.g_false,
2569: p_commit => fnd_api.g_false,
2570: p_validation_level => fnd_api.g_valid_level_full,
2571: x_return_status => l_return_status,
2572: x_msg_count => x_msg_count,
2573: x_msg_data => x_msg_data,
2574: p_terrrsc_tbl => l_terrrsc_tbl,

Line 2590: IF l_return_status = fnd_api.g_ret_sts_error

2586: );
2587:
2588: x_return_status := l_return_status;
2589:
2590: IF l_return_status = fnd_api.g_ret_sts_error
2591: THEN
2592: RAISE fnd_api.g_exc_error;
2593: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2594: THEN

Line 2592: RAISE fnd_api.g_exc_error;

2588: x_return_status := l_return_status;
2589:
2590: IF l_return_status = fnd_api.g_ret_sts_error
2591: THEN
2592: RAISE fnd_api.g_exc_error;
2593: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2594: THEN
2595: RAISE fnd_api.g_exc_unexpected_error;
2596: END IF;

Line 2593: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error

2589:
2590: IF l_return_status = fnd_api.g_ret_sts_error
2591: THEN
2592: RAISE fnd_api.g_exc_error;
2593: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2594: THEN
2595: RAISE fnd_api.g_exc_unexpected_error;
2596: END IF;
2597:

Line 2595: RAISE fnd_api.g_exc_unexpected_error;

2591: THEN
2592: RAISE fnd_api.g_exc_error;
2593: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2594: THEN
2595: RAISE fnd_api.g_exc_unexpected_error;
2596: END IF;
2597:
2598: --
2599: -- End of API body.

Line 2603: IF fnd_api.to_boolean (p_commit)

2599: -- End of API body.
2600: --
2601:
2602: -- Standard check of p_commit.
2603: IF fnd_api.to_boolean (p_commit)
2604: THEN
2605: COMMIT WORK;
2606: END IF;
2607:

Line 2619: WHEN fnd_api.g_exc_error

2615:
2616: -- Standard call to get message count and if count is 1, get message info.
2617: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2618: EXCEPTION
2619: WHEN fnd_api.g_exc_error
2620: THEN
2621: ROLLBACK TO create_terrresource_pub;
2622: x_return_status := fnd_api.g_ret_sts_error;
2623: fnd_msg_pub.count_and_get (

Line 2622: x_return_status := fnd_api.g_ret_sts_error;

2618: EXCEPTION
2619: WHEN fnd_api.g_exc_error
2620: THEN
2621: ROLLBACK TO create_terrresource_pub;
2622: x_return_status := fnd_api.g_ret_sts_error;
2623: fnd_msg_pub.count_and_get (
2624: p_count => x_msg_count,
2625: p_data => x_msg_data
2626: );

Line 2628: WHEN fnd_api.g_exc_unexpected_error

2624: p_count => x_msg_count,
2625: p_data => x_msg_data
2626: );
2627:
2628: WHEN fnd_api.g_exc_unexpected_error
2629: THEN
2630: ROLLBACK TO create_terrresource_pub;
2631: x_return_status := fnd_api.g_ret_sts_unexp_error;
2632: fnd_msg_pub.count_and_get (

Line 2631: x_return_status := fnd_api.g_ret_sts_unexp_error;

2627:
2628: WHEN fnd_api.g_exc_unexpected_error
2629: THEN
2630: ROLLBACK TO create_terrresource_pub;
2631: x_return_status := fnd_api.g_ret_sts_unexp_error;
2632: fnd_msg_pub.count_and_get (
2633: p_count => x_msg_count,
2634: p_data => x_msg_data
2635: );

Line 2640: x_return_status := fnd_api.g_ret_sts_unexp_error;

2636:
2637: WHEN OTHERS
2638: THEN
2639: ROLLBACK TO create_terrresource_pub;
2640: x_return_status := fnd_api.g_ret_sts_unexp_error;
2641:
2642: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2643: THEN
2644: fnd_msg_pub.add_exc_msg (

Line 2677: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE

2673: -- p_TerrRsc_Id NUMBER
2674: --
2675: -- Optional
2676: -- Parameter Name Data Type Default
2677: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
2678: -- p_Commit VARCHAR2 FND_API.G_FALSE
2679: --
2680: -- OUT NOCOPY :
2681: -- Parameter Name Data Type

Line 2678: -- p_Commit VARCHAR2 FND_API.G_FALSE

2674: --
2675: -- Optional
2676: -- Parameter Name Data Type Default
2677: -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
2678: -- p_Commit VARCHAR2 FND_API.G_FALSE
2679: --
2680: -- OUT NOCOPY :
2681: -- Parameter Name Data Type
2682: -- p_Return_Status VARCHAR2(1)

Line 2694: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

2690: -- End of Comments
2691: --
2692: PROCEDURE delete_terrresource (
2693: p_api_version_number IN NUMBER,
2694: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2695: p_commit IN VARCHAR2 := fnd_api.g_false,
2696: x_return_status OUT NOCOPY VARCHAR2,
2697: x_msg_count OUT NOCOPY NUMBER,
2698: x_msg_data OUT NOCOPY VARCHAR2,

Line 2695: p_commit IN VARCHAR2 := fnd_api.g_false,

2691: --
2692: PROCEDURE delete_terrresource (
2693: p_api_version_number IN NUMBER,
2694: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2695: p_commit IN VARCHAR2 := fnd_api.g_false,
2696: x_return_status OUT NOCOPY VARCHAR2,
2697: x_msg_count OUT NOCOPY NUMBER,
2698: x_msg_data OUT NOCOPY VARCHAR2,
2699: p_terrrsc_id IN NUMBER

Line 2710: IF NOT fnd_api.compatible_api_call (

2706: -- Standard Start of API savepoint
2707: SAVEPOINT delete_terrresource_pub;
2708:
2709: -- Standard call to check for call compatibility.
2710: IF NOT fnd_api.compatible_api_call (
2711: l_api_version_number,
2712: p_api_version_number,
2713: l_api_name,
2714: g_pkg_name

Line 2717: RAISE fnd_api.g_exc_unexpected_error;

2713: l_api_name,
2714: g_pkg_name
2715: )
2716: THEN
2717: RAISE fnd_api.g_exc_unexpected_error;
2718: END IF;
2719:
2720: -- Initialize message list if p_init_msg_list is set to TRUE.
2721: IF fnd_api.to_boolean (p_init_msg_list)

Line 2721: IF fnd_api.to_boolean (p_init_msg_list)

2717: RAISE fnd_api.g_exc_unexpected_error;
2718: END IF;
2719:
2720: -- Initialize message list if p_init_msg_list is set to TRUE.
2721: IF fnd_api.to_boolean (p_init_msg_list)
2722: THEN
2723: fnd_msg_pub.initialize;
2724: END IF;
2725:

Line 2735: x_return_status := fnd_api.g_ret_sts_success;

2731: fnd_msg_pub.add;
2732: END IF;
2733:
2734: -- Initialize API return status to success
2735: x_return_status := fnd_api.g_ret_sts_success;
2736: --
2737: -- API body
2738: --
2739: jtf_territory_resource_pvt.delete_terr_resource (

Line 2743: p_validation_level => fnd_api.g_valid_level_full,

2739: jtf_territory_resource_pvt.delete_terr_resource (
2740: p_api_version_number => p_api_version_number,
2741: p_init_msg_list => p_init_msg_list,
2742: p_commit => p_commit,
2743: p_validation_level => fnd_api.g_valid_level_full,
2744: x_return_status => l_return_status,
2745: x_msg_count => x_msg_count,
2746: x_msg_data => x_msg_data,
2747: p_terrrsc_id => p_terrrsc_id

Line 2753: IF l_return_status = fnd_api.g_ret_sts_error

2749:
2750: x_return_status := l_return_status;
2751:
2752: --
2753: IF l_return_status = fnd_api.g_ret_sts_error
2754: THEN
2755: RAISE fnd_api.g_exc_error;
2756: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2757: THEN

Line 2755: RAISE fnd_api.g_exc_error;

2751:
2752: --
2753: IF l_return_status = fnd_api.g_ret_sts_error
2754: THEN
2755: RAISE fnd_api.g_exc_error;
2756: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2757: THEN
2758: RAISE fnd_api.g_exc_unexpected_error;
2759: END IF;

Line 2756: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error

2752: --
2753: IF l_return_status = fnd_api.g_ret_sts_error
2754: THEN
2755: RAISE fnd_api.g_exc_error;
2756: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2757: THEN
2758: RAISE fnd_api.g_exc_unexpected_error;
2759: END IF;
2760:

Line 2758: RAISE fnd_api.g_exc_unexpected_error;

2754: THEN
2755: RAISE fnd_api.g_exc_error;
2756: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2757: THEN
2758: RAISE fnd_api.g_exc_unexpected_error;
2759: END IF;
2760:
2761: -- Standard check of p_commit.
2762: IF fnd_api.to_boolean (p_commit)

Line 2762: IF fnd_api.to_boolean (p_commit)

2758: RAISE fnd_api.g_exc_unexpected_error;
2759: END IF;
2760:
2761: -- Standard check of p_commit.
2762: IF fnd_api.to_boolean (p_commit)
2763: THEN
2764: COMMIT WORK;
2765: END IF;
2766:

Line 2778: WHEN fnd_api.g_exc_error

2774:
2775: -- Standard call to get message count and if count is 1, get message info.
2776: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2777: EXCEPTION
2778: WHEN fnd_api.g_exc_error
2779: THEN
2780: ROLLBACK TO delete_terrresource_pub;
2781: x_return_status := fnd_api.g_ret_sts_error;
2782: fnd_msg_pub.count_and_get (

Line 2781: x_return_status := fnd_api.g_ret_sts_error;

2777: EXCEPTION
2778: WHEN fnd_api.g_exc_error
2779: THEN
2780: ROLLBACK TO delete_terrresource_pub;
2781: x_return_status := fnd_api.g_ret_sts_error;
2782: fnd_msg_pub.count_and_get (
2783: p_count => x_msg_count,
2784: p_data => x_msg_data
2785: );

Line 2786: WHEN fnd_api.g_exc_unexpected_error

2782: fnd_msg_pub.count_and_get (
2783: p_count => x_msg_count,
2784: p_data => x_msg_data
2785: );
2786: WHEN fnd_api.g_exc_unexpected_error
2787: THEN
2788: ROLLBACK TO delete_terrresource_pub;
2789: x_return_status := fnd_api.g_ret_sts_unexp_error;
2790: fnd_msg_pub.count_and_get (

Line 2789: x_return_status := fnd_api.g_ret_sts_unexp_error;

2785: );
2786: WHEN fnd_api.g_exc_unexpected_error
2787: THEN
2788: ROLLBACK TO delete_terrresource_pub;
2789: x_return_status := fnd_api.g_ret_sts_unexp_error;
2790: fnd_msg_pub.count_and_get (
2791: p_count => x_msg_count,
2792: p_data => x_msg_data
2793: );

Line 2797: x_return_status := fnd_api.g_ret_sts_unexp_error;

2793: );
2794: WHEN OTHERS
2795: THEN
2796: ROLLBACK TO delete_terrresource_pub;
2797: x_return_status := fnd_api.g_ret_sts_unexp_error;
2798:
2799: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2800: THEN
2801: fnd_msg_pub.add_exc_msg (

Line 2834: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE

2830: -- p_TerrRsc_Access_Tbl TerrRsc_Access_tbl_type := G_MISS_TERRRSC_ACCESS_TBL
2831: --
2832: -- Optional
2833: -- Parameter Name Data Type Default
2834: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
2835: -- p_Commit VARCHAR2 := FND_API.G_FALSE
2836: --
2837: -- OUT NOCOPY :
2838: -- Parameter Name Data Type

Line 2835: -- p_Commit VARCHAR2 := FND_API.G_FALSE

2831: --
2832: -- Optional
2833: -- Parameter Name Data Type Default
2834: -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
2835: -- p_Commit VARCHAR2 := FND_API.G_FALSE
2836: --
2837: -- OUT NOCOPY :
2838: -- Parameter Name Data Type
2839: -- x_Return_Status VARCHAR2(1)

Line 2853: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

2849: -- End of Comments
2850: --
2851: PROCEDURE update_terrresource (
2852: p_api_version_number IN NUMBER,
2853: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2854: p_commit IN VARCHAR2 := fnd_api.g_false,
2855: x_return_status OUT NOCOPY VARCHAR2,
2856: x_msg_count OUT NOCOPY NUMBER,
2857: x_msg_data OUT NOCOPY VARCHAR2,

Line 2854: p_commit IN VARCHAR2 := fnd_api.g_false,

2850: --
2851: PROCEDURE update_terrresource (
2852: p_api_version_number IN NUMBER,
2853: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2854: p_commit IN VARCHAR2 := fnd_api.g_false,
2855: x_return_status OUT NOCOPY VARCHAR2,
2856: x_msg_count OUT NOCOPY NUMBER,
2857: x_msg_data OUT NOCOPY VARCHAR2,
2858: p_terrrsc_tbl IN terrresource_tbl_type

Line 2880: IF NOT fnd_api.compatible_api_call (

2876: -- Standard Start of API savepoint
2877: SAVEPOINT update_terrresource_pub;
2878:
2879: -- Standard call to check for call compatibility.
2880: IF NOT fnd_api.compatible_api_call (
2881: l_api_version_number,
2882: p_api_version_number,
2883: l_api_name,
2884: g_pkg_name

Line 2887: RAISE fnd_api.g_exc_unexpected_error;

2883: l_api_name,
2884: g_pkg_name
2885: )
2886: THEN
2887: RAISE fnd_api.g_exc_unexpected_error;
2888: END IF;
2889:
2890: -- Initialize message list if p_init_msg_list is set to TRUE.
2891: IF fnd_api.to_boolean (p_init_msg_list)

Line 2891: IF fnd_api.to_boolean (p_init_msg_list)

2887: RAISE fnd_api.g_exc_unexpected_error;
2888: END IF;
2889:
2890: -- Initialize message list if p_init_msg_list is set to TRUE.
2891: IF fnd_api.to_boolean (p_init_msg_list)
2892: THEN
2893: fnd_msg_pub.initialize;
2894: END IF;
2895:

Line 2905: x_return_status := fnd_api.g_ret_sts_success;

2901: fnd_msg_pub.add;
2902: END IF;
2903:
2904: -- Initialize API return status to success
2905: x_return_status := fnd_api.g_ret_sts_success;
2906: --
2907: -- API body
2908: --
2909: -- Convert incomming data from public to private Tbl format

Line 2921: p_init_msg_list => fnd_api.g_false,

2917: );
2918: --
2919: jtf_territory_resource_pvt.update_terrresource (
2920: p_api_version_number => 1.0,
2921: p_init_msg_list => fnd_api.g_false,
2922: p_commit => fnd_api.g_false,
2923: p_validation_level => fnd_api.g_valid_level_full,
2924: x_return_status => l_return_status,
2925: x_msg_count => x_msg_count,

Line 2922: p_commit => fnd_api.g_false,

2918: --
2919: jtf_territory_resource_pvt.update_terrresource (
2920: p_api_version_number => 1.0,
2921: p_init_msg_list => fnd_api.g_false,
2922: p_commit => fnd_api.g_false,
2923: p_validation_level => fnd_api.g_valid_level_full,
2924: x_return_status => l_return_status,
2925: x_msg_count => x_msg_count,
2926: x_msg_data => x_msg_data,

Line 2923: p_validation_level => fnd_api.g_valid_level_full,

2919: jtf_territory_resource_pvt.update_terrresource (
2920: p_api_version_number => 1.0,
2921: p_init_msg_list => fnd_api.g_false,
2922: p_commit => fnd_api.g_false,
2923: p_validation_level => fnd_api.g_valid_level_full,
2924: x_return_status => l_return_status,
2925: x_msg_count => x_msg_count,
2926: x_msg_data => x_msg_data,
2927: p_terrrsc_tbl => l_terrrsc_tbl,

Line 2943: IF l_return_status <> fnd_api.g_ret_sts_success

2939: );
2940:
2941: x_return_status := l_return_status;
2942: --
2943: IF l_return_status <> fnd_api.g_ret_sts_success
2944: THEN
2945: RAISE fnd_api.g_exc_error;
2946: END IF;
2947:

Line 2945: RAISE fnd_api.g_exc_error;

2941: x_return_status := l_return_status;
2942: --
2943: IF l_return_status <> fnd_api.g_ret_sts_success
2944: THEN
2945: RAISE fnd_api.g_exc_error;
2946: END IF;
2947:
2948: -- Debug Message
2949: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 2959: IF fnd_api.to_boolean (p_commit)

2955:
2956: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2957:
2958: -- Standard check for p_commit
2959: IF fnd_api.to_boolean (p_commit)
2960: THEN
2961: COMMIT WORK;
2962: END IF;
2963: --

Line 2966: WHEN fnd_api.g_exc_error

2962: END IF;
2963: --
2964: EXCEPTION
2965: --
2966: WHEN fnd_api.g_exc_error
2967: THEN
2968: ROLLBACK TO update_terrresource_pub;
2969: x_return_status := fnd_api.g_ret_sts_error;
2970: fnd_msg_pub.count_and_get (

Line 2969: x_return_status := fnd_api.g_ret_sts_error;

2965: --
2966: WHEN fnd_api.g_exc_error
2967: THEN
2968: ROLLBACK TO update_terrresource_pub;
2969: x_return_status := fnd_api.g_ret_sts_error;
2970: fnd_msg_pub.count_and_get (
2971: p_count => x_msg_count,
2972: p_data => x_msg_data
2973: );

Line 2974: WHEN fnd_api.g_exc_unexpected_error

2970: fnd_msg_pub.count_and_get (
2971: p_count => x_msg_count,
2972: p_data => x_msg_data
2973: );
2974: WHEN fnd_api.g_exc_unexpected_error
2975: THEN
2976: ROLLBACK TO update_terrresource_pub;
2977: x_return_status := fnd_api.g_ret_sts_unexp_error;
2978: fnd_msg_pub.count_and_get (

Line 2977: x_return_status := fnd_api.g_ret_sts_unexp_error;

2973: );
2974: WHEN fnd_api.g_exc_unexpected_error
2975: THEN
2976: ROLLBACK TO update_terrresource_pub;
2977: x_return_status := fnd_api.g_ret_sts_unexp_error;
2978: fnd_msg_pub.count_and_get (
2979: p_count => x_msg_count,
2980: p_data => x_msg_data
2981: );

Line 2986: x_return_status := fnd_api.g_ret_sts_unexp_error;

2982:
2983: WHEN OTHERS
2984: THEN
2985: ROLLBACK TO update_terrresource_pub;
2986: x_return_status := fnd_api.g_ret_sts_unexp_error;
2987:
2988: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2989: THEN
2990: fnd_msg_pub.add_exc_msg (