[Home] [Help]
132:
133: BEGIN
134:
135: IF FND_API.To_Boolean(x_init_msg_list) THEN
136: FND_MSG_PUB.Initialize;
137: END IF;
138:
139: SELECT
140: COUNT(*)
155: END LOOP;
156:
157: FND_MESSAGE.Set_Name(g_app_name, 'EGO_RF_RF_EXISTS');
158: FND_MESSAGE.Set_Token('NAME', l_name);
159: FND_MSG_PUB.Add;
160:
161: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
162:
163: ELSE
513:
514: BEGIN
515:
516: IF (FND_API.To_Boolean(x_init_msg_list) = TRUE) THEN
517: FND_MSG_PUB.Initialize;
518: END IF;
519:
520: --first check unique constraint
521:
637:
638: ELSE
639:
640: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_CRITERIA_TEMPLATE');
641: FND_MSG_PUB.Add;
642:
643: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
644:
645: END IF;
687:
688: BEGIN
689:
690: IF FND_API.To_Boolean(x_init_msg_list) THEN
691: FND_MSG_PUB.Initialize;
692: END IF;
693:
694: IF (Criteria_Template_Name_Exists(X_NAME
695: ,X_WEB_USER_ID
774:
775: ELSE
776:
777: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_CRITERIA_TEMPLATE');
778: FND_MSG_PUB.Add;
779:
780: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
781:
782: END IF;
803:
804: BEGIN
805:
806: IF FND_API.To_Boolean(x_init_msg_list) THEN
807: FND_MSG_PUB.Initialize;
808: END IF;
809:
810: --begin bug 10384119
811: IF (X_REGION_CODE = 'EGO_ITEM_MATCH_RULE_REGION') THEN
829:
830: IF (l_count > 0) THEN
831: FND_MESSAGE.Set_Name(g_app_name, 'EGO_MR_RF_EXISTS'); --"The Match Rule \"&NAME\" cannot be deleted because it is referenced by Import Batches or Source Systems."
832: FND_MESSAGE.Set_Token('NAME', l_name);
833: FND_MSG_PUB.Add;
834: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
835: RETURN;
836: END IF;
837: END IF;
902: AND REGION_CODE = X_REGION_CODE;
903:
904: FND_MESSAGE.Set_Name(g_app_name, 'EGO_CT_RF_EXISTS');
905: FND_MESSAGE.Set_Token('NAME', l_name);
906: FND_MSG_PUB.Add;
907:
908: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
909:
910: END IF;
1046:
1047: BEGIN
1048:
1049: IF FND_API.To_Boolean(x_init_msg_list) THEN
1050: FND_MSG_PUB.Initialize;
1051: END IF;
1052:
1053: IF (X_RF_CUSTOMIZATION_CODE IS NOT NULL) THEN
1054:
1120:
1121: BEGIN
1122:
1123: IF FND_API.To_Boolean(x_init_msg_list) THEN
1124: FND_MSG_PUB.Initialize;
1125: END IF;
1126:
1127: SELECT
1128: COUNT(*) INTO l_count
1194:
1195: BEGIN
1196:
1197: IF FND_API.To_Boolean(x_init_msg_list) THEN
1198: FND_MSG_PUB.Initialize;
1199: END IF;
1200:
1201: SELECT
1202: COUNT(*) INTO l_count
1261:
1262: BEGIN
1263:
1264: IF FND_API.To_Boolean(x_init_msg_list) THEN
1265: FND_MSG_PUB.Initialize;
1266: END IF;
1267:
1268: --first check unique constraint
1269:
1493: ELSE
1494:
1495:
1496: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_RESULTS_FORMAT');
1497: FND_MSG_PUB.Add;
1498:
1499: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1500:
1501:
1555:
1556: BEGIN
1557:
1558: IF FND_API.To_Boolean(x_init_msg_list) THEN
1559: FND_MSG_PUB.Initialize;
1560: END IF;
1561:
1562: IF (Results_Format_Name_Exists(X_NAME
1563: ,X_WEB_USER_ID
1814:
1815: ELSE
1816:
1817: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_RESULTS_FORMAT');
1818: FND_MSG_PUB.Add;
1819:
1820: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1821:
1822: END IF;
1839:
1840: BEGIN
1841:
1842: IF FND_API.To_Boolean(x_init_msg_list) THEN
1843: FND_MSG_PUB.Initialize;
1844: END IF;
1845:
1846: Check_Result_Format_Deletion
1847: (
2017:
2018: BEGIN
2019:
2020: IF FND_API.To_Boolean(x_init_msg_list) THEN
2021: FND_MSG_PUB.Initialize;
2022: END IF;
2023:
2024: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2025: X_ROWID => l_rowid,
2167:
2168: BEGIN
2169:
2170: IF FND_API.To_Boolean(x_init_msg_list) THEN
2171: FND_MSG_PUB.Initialize;
2172: END IF;
2173:
2174: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
2175: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
2497:
2498: BEGIN
2499:
2500: IF FND_API.To_Boolean(x_init_msg_list) THEN
2501: FND_MSG_PUB.Initialize;
2502: END IF;
2503:
2504: DELETE FROM AK_CUSTOM_REGION_ITEMS
2505: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
2559:
2560: BEGIN
2561:
2562: IF FND_API.To_Boolean(x_init_msg_list) THEN
2563: FND_MSG_PUB.Initialize;
2564: END IF;
2565:
2566: AK_CRITERIA_PKG.insert_row
2567: (
2692:
2693: BEGIN
2694:
2695: IF FND_API.To_Boolean(x_init_msg_list) THEN
2696: FND_MSG_PUB.Initialize;
2697: END IF;
2698:
2699: AK_CRITERIA_PKG.update_row
2700: (
2888:
2889: BEGIN
2890:
2891: IF FND_API.To_Boolean(x_init_msg_list) THEN
2892: FND_MSG_PUB.Initialize;
2893: END IF;
2894:
2895: AK_CRITERIA_PKG.delete_row
2896: (
2969:
2970: BEGIN
2971:
2972: IF FND_API.To_Boolean(x_init_msg_list) THEN
2973: FND_MSG_PUB.Initialize;
2974: END IF;
2975:
2976: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
2977: X_ROWID => l_rowid,
3025:
3026: BEGIN
3027:
3028: IF FND_API.To_Boolean(x_init_msg_list) THEN
3029: FND_MSG_PUB.Initialize;
3030: END IF;
3031:
3032: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
3033: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
3069:
3070: BEGIN
3071:
3072: IF FND_API.To_Boolean(x_init_msg_list) THEN
3073: FND_MSG_PUB.Initialize;
3074: END IF;
3075:
3076: DELETE FROM AK_CUSTOM_REGION_ITEMS
3077: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID