APPS.JTF_DSP_SECTION_GRP dependencies on FND_MSG_PUB

Line 671: FND_MSG_PUB.initialize;

667: END IF;
668:
669: -- Initialize message list if p_init_msg_list is set to TRUE.
670: IF FND_API.to_Boolean(p_init_msg_list) THEN
671: FND_MSG_PUB.initialize;
672: END IF;
673:
674: -- Initialize API return status to error, i.e, its not duplicate
675: x_return_status := FND_API.G_RET_STS_ERROR;

Line 749: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

745: EXCEPTION
746:
747: WHEN FND_API.G_EXC_ERROR THEN
748: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
749: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
750: p_data => x_msg_data,
751: p_encoded => 'F');
752:
753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

751: p_encoded => 'F');
752:
753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
756: p_data => x_msg_data,
757: p_encoded => 'F');
758:
759: WHEN OTHERS THEN

Line 762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

758:
759: WHEN OTHERS THEN
760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
761:
762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
763: THEN
764: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
765: END IF;
766:

Line 764: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
761:
762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
763: THEN
764: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
765: END IF;
766:
767: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
768: p_data => x_msg_data,

Line 767: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

763: THEN
764: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
765: END IF;
766:
767: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
768: p_data => x_msg_data,
769: p_encoded => 'F');
770:
771: END Check_Duplicate_Entry;

Line 840: FND_MSG_PUB.initialize;

836: BEGIN
837:
838: -- Initialize message list if p_init_msg_list is set to TRUE.
839: IF FND_API.to_Boolean(p_init_msg_list) THEN
840: FND_MSG_PUB.initialize;
841: END IF;
842:
843: -- Initialize API return status to success
844: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 854: FND_MSG_PUB.Add;

850: IF ((p_display_name IS NULL) OR
851: (p_display_name = FND_API.G_MISS_CHAR))
852: THEN
853: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_DSP_NAME');
854: FND_MSG_PUB.Add;
855: RAISE FND_API.G_EXC_ERROR;
856: END IF;
857:
858: -- section_type_code

Line 863: FND_MSG_PUB.Add;

859: IF ((p_section_type_code IS NULL) OR
860: (p_section_type_code = FND_API.G_MISS_CHAR))
861: THEN
862: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_SCT_TYPE');
863: FND_MSG_PUB.Add;
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;
866:
867: -- status_code

Line 872: FND_MSG_PUB.Add;

868: IF ((p_status_code IS NULL) OR
869: (p_status_code = FND_API.G_MISS_CHAR))
870: THEN
871: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_STATUS');
872: FND_MSG_PUB.Add;
873: RAISE FND_API.G_EXC_ERROR;
874: END IF;
875:
876: -- start_date_active

Line 881: FND_MSG_PUB.Add;

877: IF ((p_start_date_active IS NULL) OR
878: (p_start_date_active = FND_API.G_MISS_DATE))
879: THEN
880: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_START_DATE');
881: FND_MSG_PUB.Add;
882: RAISE FND_API.G_EXC_ERROR;
883: END IF;
884:
885: --

Line 896: FND_MSG_PUB.Add;

892: IF(p_available_in_all_sites_flag <> 'Y' AND
893: p_available_in_all_sites_flag <> 'N')
894: THEN
895: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_AVL_FLAG');
896: FND_MSG_PUB.Add;
897: RAISE FND_API.G_EXC_ERROR;
898: END IF;
899: END IF;
900:

Line 916: FND_MSG_PUB.Add;

912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
913: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
914: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_AUTO_PLACE');
915: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);
916: FND_MSG_PUB.Add;
917: RAISE FND_API.G_EXC_ERROR;
918: END IF;
919:
920: END IF;

Line 938: FND_MSG_PUB.Add;

934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
936: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_ORDER_BY');
937: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);
938: FND_MSG_PUB.Add;
939: RAISE FND_API.G_EXC_ERROR;
940: END IF;
941:
942: END IF;

Line 957: FND_MSG_PUB.Add;

953: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
956: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_DUPLICATE_SECT');
957: FND_MSG_PUB.Add;
958: RAISE FND_API.G_EXC_ERROR; -- duplicate section
959: END IF;
960:
961: --

Line 975: FND_MSG_PUB.Add;

971: EXCEPTION
972: WHEN NO_DATA_FOUND THEN
973: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DSP_CTX');
974: FND_MESSAGE.Set_Token('DISPLAY_CONTEXT', p_display_context_id);
975: FND_MSG_PUB.Add;
976: RAISE FND_API.G_EXC_ERROR;
977: WHEN OTHERS THEN
978: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DSP_CTX');
979: FND_MSG_PUB.Add;

Line 979: FND_MSG_PUB.Add;

975: FND_MSG_PUB.Add;
976: RAISE FND_API.G_EXC_ERROR;
977: WHEN OTHERS THEN
978: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DSP_CTX');
979: FND_MSG_PUB.Add;
980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
981: END;
982: END IF;
983:

Line 995: FND_MSG_PUB.Add;

991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
993: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DLVRBL');
994: FND_MESSAGE.Set_Token('DELIVERABLE', p_deliverable_id);
995: FND_MSG_PUB.Add;
996: RAISE FND_API.G_EXC_ERROR;
997: WHEN OTHERS THEN
998: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DLVRBL');
999: FND_MSG_PUB.Add;

Line 999: FND_MSG_PUB.Add;

995: FND_MSG_PUB.Add;
996: RAISE FND_API.G_EXC_ERROR;
997: WHEN OTHERS THEN
998: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DLVRBL');
999: FND_MSG_PUB.Add;
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: END;
1002: END IF;
1003:

Line 1015: FND_MSG_PUB.Add;

1011: EXCEPTION
1012: WHEN NO_DATA_FOUND THEN
1013: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_TYPE');
1014: FND_MESSAGE.Set_Token('SECTION_TYPE', p_section_type_code);
1015: FND_MSG_PUB.Add;
1016: RAISE FND_API.G_EXC_ERROR;
1017: WHEN OTHERS THEN
1018: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_TYPE');
1019: FND_MSG_PUB.Add;

Line 1019: FND_MSG_PUB.Add;

1015: FND_MSG_PUB.Add;
1016: RAISE FND_API.G_EXC_ERROR;
1017: WHEN OTHERS THEN
1018: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_TYPE');
1019: FND_MSG_PUB.Add;
1020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1021: END;
1022:
1023: -- status code

Line 1031: FND_MSG_PUB.Add;

1027: IF (c3%NOTFOUND) THEN
1028: CLOSE c3;
1029: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_STATUS');
1030: FND_MESSAGE.Set_Token('STATUS', p_status_code);
1031: FND_MSG_PUB.Add;
1032: RAISE FND_API.G_EXC_ERROR;
1033: END IF;
1034: CLOSE c3;
1035:

Line 1040: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1036: EXCEPTION
1037:
1038: WHEN FND_API.G_EXC_ERROR THEN
1039: x_return_status := FND_API.G_RET_STS_ERROR;
1040: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1041: p_data => x_msg_data,
1042: p_encoded => 'F');
1043:
1044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1046: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1042: p_encoded => 'F');
1043:
1044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1047: p_data => x_msg_data,
1048: p_encoded => 'F');
1049:
1050: WHEN OTHERS THEN

Line 1053: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1049:
1050: WHEN OTHERS THEN
1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1052:
1053: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1054: THEN
1055: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1056: END IF;
1057:

Line 1055: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1052:
1053: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1054: THEN
1055: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1056: END IF;
1057:
1058: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1059: p_data => x_msg_data,

Line 1058: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1054: THEN
1055: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1056: END IF;
1057:
1058: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1059: p_data => x_msg_data,
1060: p_encoded => 'F');
1061:
1062: END Validate_Create;

Line 1133: FND_MSG_PUB.initialize;

1129: BEGIN
1130:
1131: -- Initialize message list if p_init_msg_list is set to TRUE.
1132: IF FND_API.to_Boolean(p_init_msg_list) THEN
1133: FND_MSG_PUB.initialize;
1134: END IF;
1135:
1136: -- Initialize API return status to success
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1145: FND_MSG_PUB.Add;

1141: --
1142: -- section_id
1143: IF (p_section_id IS NULL) THEN
1144: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NULL_SCT_ID');
1145: FND_MSG_PUB.Add;
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148:
1149: -- display_name

Line 1152: FND_MSG_PUB.Add;

1148:
1149: -- display_name
1150: IF (p_display_name IS NULL) THEN
1151: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NULL_DSP_NAME');
1152: FND_MSG_PUB.Add;
1153: RAISE FND_API.G_EXC_ERROR;
1154: END IF;
1155:
1156: -- section_type_code

Line 1159: FND_MSG_PUB.Add;

1155:
1156: -- section_type_code
1157: IF (p_section_type_code IS NULL) THEN
1158: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NULL_SCT_TYPE');
1159: FND_MSG_PUB.Add;
1160: RAISE FND_API.G_EXC_ERROR;
1161: END IF;
1162:
1163: -- status_code

Line 1166: FND_MSG_PUB.Add;

1162:
1163: -- status_code
1164: IF (p_status_code IS NULL) THEN
1165: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NULL_STATUS');
1166: FND_MSG_PUB.Add;
1167: RAISE FND_API.G_EXC_ERROR;
1168: END IF;
1169:
1170: -- start_date_active

Line 1173: FND_MSG_PUB.Add;

1169:
1170: -- start_date_active
1171: IF (p_start_date_active IS NULL) THEN
1172: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NULL_START_DATE');
1173: FND_MSG_PUB.Add;
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176:
1177: -- non-null field validation

Line 1185: FND_MSG_PUB.Add;

1181: IF(p_available_in_all_sites_flag <> 'Y' AND
1182: p_available_in_all_sites_flag <> 'N')
1183: THEN
1184: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_AVL_FLAG');
1185: FND_MSG_PUB.Add;
1186: RAISE FND_API.G_EXC_ERROR;
1187: END IF;
1188: END IF;
1189:

Line 1205: FND_MSG_PUB.Add;

1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1202: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1203: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_AUTO_PLACE');
1204: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);
1205: FND_MSG_PUB.Add;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208:
1209: END IF;

Line 1227: FND_MSG_PUB.Add;

1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1225: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_ORDER_BY');
1226: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);
1227: FND_MSG_PUB.Add;
1228: RAISE FND_API.G_EXC_ERROR;
1229: END IF;
1230:
1231: END IF;

Line 1247: FND_MSG_PUB.Add;

1243: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1245: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1246: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_DUPLICATE_SECT');
1247: FND_MSG_PUB.Add;
1248: RAISE FND_API.G_EXC_ERROR; -- duplicate fields
1249: END IF;
1250:
1251: --

Line 1265: FND_MSG_PUB.Add;

1261: EXCEPTION
1262: WHEN NO_DATA_FOUND THEN
1263: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DSP_CTX');
1264: FND_MESSAGE.Set_Token('DISPLAY_CONTEXT', p_display_context_id);
1265: FND_MSG_PUB.Add;
1266: RAISE FND_API.G_EXC_ERROR;
1267: WHEN OTHERS THEN
1268: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DSP_CTX');
1269: FND_MSG_PUB.Add;

Line 1269: FND_MSG_PUB.Add;

1265: FND_MSG_PUB.Add;
1266: RAISE FND_API.G_EXC_ERROR;
1267: WHEN OTHERS THEN
1268: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DSP_CTX');
1269: FND_MSG_PUB.Add;
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271: END;
1272: END IF;
1273:

Line 1285: FND_MSG_PUB.Add;

1281: EXCEPTION
1282: WHEN NO_DATA_FOUND THEN
1283: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DLVRBL');
1284: FND_MESSAGE.Set_Token('DELIVERABLE', p_deliverable_id);
1285: FND_MSG_PUB.Add;
1286: RAISE FND_API.G_EXC_ERROR;
1287: WHEN OTHERS THEN
1288: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DLVRBL');
1289: FND_MSG_PUB.Add;

Line 1289: FND_MSG_PUB.Add;

1285: FND_MSG_PUB.Add;
1286: RAISE FND_API.G_EXC_ERROR;
1287: WHEN OTHERS THEN
1288: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DLVRBL');
1289: FND_MSG_PUB.Add;
1290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1291: END;
1292: END IF;
1293:

Line 1306: FND_MSG_PUB.Add;

1302: EXCEPTION
1303: WHEN NO_DATA_FOUND THEN
1304: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_TYPE');
1305: FND_MESSAGE.Set_Token('SECTION_TYPE', p_section_type_code);
1306: FND_MSG_PUB.Add;
1307: RAISE FND_API.G_EXC_ERROR;
1308: WHEN OTHERS THEN
1309: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_TYPE');
1310: FND_MSG_PUB.Add;

Line 1310: FND_MSG_PUB.Add;

1306: FND_MSG_PUB.Add;
1307: RAISE FND_API.G_EXC_ERROR;
1308: WHEN OTHERS THEN
1309: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_TYPE');
1310: FND_MSG_PUB.Add;
1311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1312: END;
1313: END IF;
1314:

Line 1324: FND_MSG_PUB.Add;

1320: IF (c3%NOTFOUND) THEN
1321: CLOSE c3;
1322: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_STATUS');
1323: FND_MESSAGE.Set_Token('STATUS', p_status_code);
1324: FND_MSG_PUB.Add;
1325: RAISE FND_API.G_EXC_ERROR;
1326: END IF;
1327: CLOSE c3;
1328: END IF;

Line 1334: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1330: EXCEPTION
1331:
1332: WHEN FND_API.G_EXC_ERROR THEN
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1335: p_data => x_msg_data,
1336: p_encoded => 'F');
1337:
1338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1340: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1336: p_encoded => 'F');
1337:
1338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1340: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1341: p_data => x_msg_data,
1342: p_encoded => 'F');
1343:
1344: WHEN OTHERS THEN

Line 1347: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1343:
1344: WHEN OTHERS THEN
1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346:
1347: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1348: THEN
1349: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1350: END IF;
1351:

Line 1349: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346:
1347: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1348: THEN
1349: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1350: END IF;
1351:
1352: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1353: p_data => x_msg_data,

Line 1352: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1348: THEN
1349: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1350: END IF;
1351:
1352: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1353: p_data => x_msg_data,
1354: p_encoded => 'F');
1355:
1356: END Validate_Update;

Line 1429: FND_MSG_PUB.initialize;

1425: END IF;
1426:
1427: -- Initialize message list if p_init_msg_list is set to TRUE.
1428: IF FND_API.to_Boolean(p_init_msg_list) THEN
1429: FND_MSG_PUB.initialize;
1430: END IF;
1431:
1432: -- Initialize API return status to success
1433: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1487: FND_MSG_PUB.Add;

1483: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1485: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1486: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_CREATE');
1487: FND_MSG_PUB.Add;
1488: RAISE FND_API.G_EXC_ERROR; -- invalid section
1489: END IF;
1490:
1491: --

Line 1540: FND_MSG_PUB.Add;

1536: );
1537: EXCEPTION
1538: WHEN NO_DATA_FOUND THEN
1539: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INSERT_FAIL');
1540: FND_MSG_PUB.Add;
1541: RAISE FND_API.G_EXC_ERROR;
1542: WHEN OTHERS THEN
1543: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INSERT_FAIL');
1544: FND_MSG_PUB.Add;

Line 1544: FND_MSG_PUB.Add;

1540: FND_MSG_PUB.Add;
1541: RAISE FND_API.G_EXC_ERROR;
1542: WHEN OTHERS THEN
1543: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INSERT_FAIL');
1544: FND_MSG_PUB.Add;
1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1546: END;
1547:
1548: --

Line 1557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1553: COMMIT WORK;
1554: END IF;
1555:
1556: -- Standard call to get message count and if count is 1, get message info.
1557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1558: p_data => x_msg_data,
1559: p_encoded => 'F');
1560:
1561: EXCEPTION

Line 1566: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1562:
1563: WHEN FND_API.G_EXC_ERROR THEN
1564: ROLLBACK TO CREATE_SECTION_GRP;
1565: x_return_status := FND_API.G_RET_STS_ERROR;
1566: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1567: p_data => x_msg_data,
1568: p_encoded => 'F');
1569:
1570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1573: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1569:
1570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1571: ROLLBACK TO CREATE_SECTION_GRP;
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1573: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1574: p_data => x_msg_data,
1575: p_encoded => 'F');
1576:
1577: WHEN OTHERS THEN

Line 1581: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1577: WHEN OTHERS THEN
1578: ROLLBACK TO CREATE_SECTION_GRP;
1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1580:
1581: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1582: THEN
1583: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1584: END IF;
1585:

Line 1583: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1580:
1581: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1582: THEN
1583: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1584: END IF;
1585:
1586: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1587: p_data => x_msg_data,

Line 1586: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1582: THEN
1583: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1584: END IF;
1585:
1586: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1587: p_data => x_msg_data,
1588: p_encoded => 'F');
1589:
1590: END Create_Section;

Line 1659: FND_MSG_PUB.initialize;

1655: END IF;
1656:
1657: -- Initialize message list if p_init_msg_list is set to TRUE.
1658: IF FND_API.to_Boolean(p_init_msg_list) THEN
1659: FND_MSG_PUB.initialize;
1660: END IF;
1661:
1662: -- Initialize API return status to success
1663: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1687: FND_MSG_PUB.Add;

1683: EXCEPTION
1684: WHEN NO_DATA_FOUND THEN
1685: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');
1686: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1687: FND_MSG_PUB.Add;
1688: RAISE FND_API.G_EXC_ERROR;
1689: WHEN OTHERS THEN
1690: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ACSS_NAME');
1691: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);

Line 1692: FND_MSG_PUB.Add;

1688: RAISE FND_API.G_EXC_ERROR;
1689: WHEN OTHERS THEN
1690: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ACSS_NAME');
1691: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1692: FND_MSG_PUB.Add;
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694: END;
1695: ELSE
1696: -- neither section_id nor access_name is specified

Line 1698: FND_MSG_PUB.Add;

1694: END;
1695: ELSE
1696: -- neither section_id nor access_name is specified
1697: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_ID_OR_ACSS');
1698: FND_MSG_PUB.Add;
1699: RAISE FND_API.G_EXC_ERROR;
1700: END IF;
1701:
1702:

Line 1751: FND_MSG_PUB.Add;

1747: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1749: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1750: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_CREATE');
1751: FND_MSG_PUB.Add;
1752: RAISE FND_API.G_EXC_ERROR; -- invalid section
1753: END IF;
1754:
1755: -- 2. update row with section data into section table

Line 1798: FND_MSG_PUB.Add;

1794: );
1795: EXCEPTION
1796: WHEN NO_DATA_FOUND THEN
1797: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_UPDATE_FAIL');
1798: FND_MSG_PUB.Add;
1799: RAISE FND_API.G_EXC_ERROR;
1800: WHEN OTHERS THEN
1801: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_UPDATE_FAIL');
1802: FND_MSG_PUB.Add;

Line 1802: FND_MSG_PUB.Add;

1798: FND_MSG_PUB.Add;
1799: RAISE FND_API.G_EXC_ERROR;
1800: WHEN OTHERS THEN
1801: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_UPDATE_FAIL');
1802: FND_MSG_PUB.Add;
1803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1804: END;
1805:
1806: --

Line 1815: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1811: COMMIT WORK;
1812: END IF;
1813:
1814: -- Standard call to get message count and if count is 1, get message info.
1815: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1816: p_data => x_msg_data,
1817: p_encoded => 'F');
1818:
1819: EXCEPTION

Line 1824: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1820:
1821: WHEN FND_API.G_EXC_ERROR THEN
1822: ROLLBACK TO UPDATE_SECTION_GRP;
1823: x_return_status := FND_API.G_RET_STS_ERROR;
1824: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1825: p_data => x_msg_data,
1826: p_encoded => 'F');
1827:
1828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1831: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1827:
1828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1829: ROLLBACK TO UPDATE_SECTION_GRP;
1830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1831: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1832: p_data => x_msg_data,
1833: p_encoded => 'F');
1834:
1835: WHEN OTHERS THEN

Line 1839: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1835: WHEN OTHERS THEN
1836: ROLLBACK TO UPDATE_SECTION_GRP;
1837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1838:
1839: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1840: THEN
1841: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1842: END IF;
1843:

Line 1841: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1838:
1839: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1840: THEN
1841: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1842: END IF;
1843:
1844: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1845: p_data => x_msg_data,

Line 1844: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1840: THEN
1841: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1842: END IF;
1843:
1844: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1845: p_data => x_msg_data,
1846: p_encoded => 'F');
1847:
1848: END Update_Section;

Line 1896: FND_MSG_PUB.initialize;

1892: END IF;
1893:
1894: -- Initialize message list if p_init_msg_list is set to TRUE.
1895: IF FND_API.to_Boolean(p_init_msg_list) THEN
1896: FND_MSG_PUB.initialize;
1897: END IF;
1898:
1899: -- Initialize API return status to success
1900: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1924: FND_MSG_PUB.Add;

1920: EXCEPTION
1921: WHEN NO_DATA_FOUND THEN
1922: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');
1923: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1924: FND_MSG_PUB.Add;
1925: RAISE FND_API.G_EXC_ERROR;
1926: WHEN OTHERS THEN
1927: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');
1928: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);

Line 1929: FND_MSG_PUB.Add;

1925: RAISE FND_API.G_EXC_ERROR;
1926: WHEN OTHERS THEN
1927: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');
1928: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1929: FND_MSG_PUB.Add;
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END;
1932: ELSE
1933: -- neither section_id nor access_name is specified, therefore cannot delete

Line 1935: FND_MSG_PUB.Add;

1931: END;
1932: ELSE
1933: -- neither section_id nor access_name is specified, therefore cannot delete
1934: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_ID_OR_ACSS');
1935: FND_MSG_PUB.Add;
1936: RAISE FND_API.G_EXC_ERROR;
1937: END IF;
1938:
1939: --

Line 1951: FND_MSG_PUB.Add;

1947: IF (c3%FOUND) THEN
1948: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_MSITE_REF');
1949: FND_MESSAGE.Set_Token('SECTION_ID', l_section_id);
1950: FND_MESSAGE.Set_Token('MINI_SITE_ID', l_mini_site_id);
1951: FND_MSG_PUB.Add;
1952: RAISE FND_API.G_EXC_ERROR;
1953: END IF;
1954:
1955: -- delete from jtf_dsp_msite_sct_sects table

Line 2025: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2021:
2022: WHEN FND_API.G_EXC_ERROR THEN
2023: ROLLBACK TO DELETE_SECTION_GRP;
2024: x_return_status := FND_API.G_RET_STS_ERROR;
2025: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2026: p_data => x_msg_data,
2027: p_encoded => 'F');
2028:
2029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2032: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2028:
2029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2030: ROLLBACK TO DELETE_SECTION_GRP;
2031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2032: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2033: p_data => x_msg_data,
2034: p_encoded => 'F');
2035:
2036: WHEN OTHERS THEN

Line 2040: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

2036: WHEN OTHERS THEN
2037: ROLLBACK TO DELETE_SECTION_GRP;
2038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2039:
2040: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2041: THEN
2042: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2043: END IF;
2044:

Line 2042: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

2038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2039:
2040: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2041: THEN
2042: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2043: END IF;
2044:
2045: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2046: p_data => x_msg_data,

Line 2045: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2041: THEN
2042: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2043: END IF;
2044:
2045: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2046: p_data => x_msg_data,
2047: p_encoded => 'F');
2048:
2049: END Delete_Section;

Line 2084: FND_MSG_PUB.initialize;

2080: END IF;
2081:
2082: -- Initialize message list if p_init_msg_list is set to TRUE.
2083: IF FND_API.to_Boolean(p_init_msg_list) THEN
2084: FND_MSG_PUB.initialize;
2085: END IF;
2086:
2087: -- Initialize API return status to success
2088: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2110: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2106: COMMIT WORK;
2107: END IF;
2108:
2109: -- Standard call to get message count and if count is 1, get message info.
2110: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2111: p_data => x_msg_data,
2112: p_encoded => 'F');
2113:
2114: EXCEPTION

Line 2119: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2115:
2116: WHEN FND_API.G_EXC_ERROR THEN
2117: ROLLBACK TO UPDATE_DSP_CONTEXT_TO_NULL_GRP;
2118: x_return_status := FND_API.G_RET_STS_ERROR;
2119: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2120: p_data => x_msg_data,
2121: p_encoded => 'F');
2122:
2123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2126: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2122:
2123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2124: ROLLBACK TO UPDATE_DSP_CONTEXT_TO_NULL_GRP;
2125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2126: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2127: p_data => x_msg_data,
2128: p_encoded => 'F');
2129:
2130: WHEN OTHERS THEN

Line 2134: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2130: WHEN OTHERS THEN
2131: ROLLBACK TO UPDATE_DSP_CONTEXT_TO_NULL_GRP;
2132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2133:
2134: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2135: THEN
2136: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2137: END IF;
2138:

Line 2136: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

2132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2133:
2134: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2135: THEN
2136: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2137: END IF;
2138:
2139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2140: p_data => x_msg_data,

Line 2139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2135: THEN
2136: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2137: END IF;
2138:
2139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2140: p_data => x_msg_data,
2141: p_encoded => 'F');
2142:
2143: END Update_Dsp_Context_To_Null;

Line 2178: FND_MSG_PUB.initialize;

2174: END IF;
2175:
2176: -- Initialize message list if p_init_msg_list is set to TRUE.
2177: IF FND_API.to_Boolean(p_init_msg_list) THEN
2178: FND_MSG_PUB.initialize;
2179: END IF;
2180:
2181: -- Initialize API return status to success
2182: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2204: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2200: COMMIT WORK;
2201: END IF;
2202:
2203: -- Standard call to get message count and if count is 1, get message info.
2204: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2205: p_data => x_msg_data,
2206: p_encoded => 'F');
2207:
2208: EXCEPTION

Line 2213: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2209:
2210: WHEN FND_API.G_EXC_ERROR THEN
2211: ROLLBACK TO UPDATE_DELIVERABLE_TO_NULL_GRP;
2212: x_return_status := FND_API.G_RET_STS_ERROR;
2213: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2214: p_data => x_msg_data,
2215: p_encoded => 'F');
2216:
2217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2220: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2216:
2217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2218: ROLLBACK TO UPDATE_DELIVERABLE_TO_NULL_GRP;
2219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2220: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2221: p_data => x_msg_data,
2222: p_encoded => 'F');
2223:
2224: WHEN OTHERS THEN

Line 2228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2224: WHEN OTHERS THEN
2225: ROLLBACK TO UPDATE_DELIVERABLE_TO_NULL_GRP;
2226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2227:
2228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2229: THEN
2230: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2231: END IF;
2232:

Line 2230: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

2226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2227:
2228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2229: THEN
2230: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2231: END IF;
2232:
2233: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2234: p_data => x_msg_data,

Line 2233: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2229: THEN
2230: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2231: END IF;
2232:
2233: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2234: p_data => x_msg_data,
2235: p_encoded => 'F');
2236:
2237: END Update_Deliverable_To_Null;