DBA Data[Home] [Help]

APPS.BIS_AK_REGION_PUB dependencies on FND_MSG_PUB

Line 1076: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1077: ,p_data => x_msg_data);
1078: WHEN OTHERS THEN
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 1080: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1076: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1077: ,p_data => x_msg_data);
1078: WHEN OTHERS THEN
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1081: ,p_data => x_msg_data);
1082: if (x_msg_data is null) then
1083: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_ROW: ' || SQLERRM;
1084: end if;

Line 1162: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1158:
1159: EXCEPTION
1160: WHEN FND_API.G_EXC_ERROR THEN
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1163: ,p_data => x_msg_data);
1164: WHEN OTHERS THEN
1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 1166: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1162: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1163: ,p_data => x_msg_data);
1164: WHEN OTHERS THEN
1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1167: ,p_data => x_msg_data);
1168: IF (x_msg_data IS NULL) THEN
1169: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_REGION_ROW: ' || SQLERRM;
1170: END IF;

Line 1429: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1425:
1426: EXCEPTION
1427: WHEN FND_API.G_EXC_ERROR THEN
1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1430: ,p_data => x_msg_data);
1431: WHEN OTHERS THEN
1432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1433: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 1433: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1429: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1430: ,p_data => x_msg_data);
1431: WHEN OTHERS THEN
1432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1433: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1434: ,p_data => x_msg_data);
1435: if (x_msg_data is null) then
1436: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ROW: ' || SQLERRM;
1437: end if;

Line 1673: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1669:
1670: EXCEPTION
1671: WHEN FND_API.G_EXC_ERROR THEN
1672: x_return_status := FND_API.G_RET_STS_ERROR;
1673: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1674: ,p_data => x_msg_data);
1675: WHEN OTHERS THEN
1676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1677: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 1677: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1673: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1674: ,p_data => x_msg_data);
1675: WHEN OTHERS THEN
1676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1677: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1678: ,p_data => x_msg_data);
1679: IF (x_msg_data IS NULL) THEN
1680: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ROW: ' || SQLERRM;
1681: END IF;

Line 1710: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1706:
1707: EXCEPTION
1708: WHEN FND_API.G_EXC_ERROR THEN
1709: x_return_status := FND_API.G_RET_STS_ERROR;
1710: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1711: ,p_data => x_msg_data);
1712: WHEN OTHERS THEN
1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1714: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 1714: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1710: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1711: ,p_data => x_msg_data);
1712: WHEN OTHERS THEN
1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1714: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1715: ,p_data => x_msg_data);
1716: if (x_msg_data is null) then
1717: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_ROW: ' || SQLERRM;
1718: end if;

Line 1950: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1946:
1947: EXCEPTION
1948: WHEN FND_API.G_EXC_ERROR THEN
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1951: ,p_data => x_msg_data);
1952: WHEN OTHERS THEN
1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1954: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 1954: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1950: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1951: ,p_data => x_msg_data);
1952: WHEN OTHERS THEN
1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1954: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1955: ,p_data => x_msg_data);
1956: if (x_msg_data is null) then
1957: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW: ' || SQLERRM;
1958: end if;

Line 2169: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2165:
2166: EXCEPTION
2167: WHEN FND_API.G_EXC_ERROR THEN
2168: x_return_status := FND_API.G_RET_STS_ERROR;
2169: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2170: ,p_data => x_msg_data);
2171: WHEN OTHERS THEN
2172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2173: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 2173: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2169: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2170: ,p_data => x_msg_data);
2171: WHEN OTHERS THEN
2172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2173: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2174: ,p_data => x_msg_data);
2175: IF (x_msg_data IS NULL) THEN
2176: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW: ' || SQLERRM;
2177: END IF;

Line 2480: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2476:
2477: EXCEPTION
2478: WHEN FND_API.G_EXC_ERROR THEN
2479: x_return_status := FND_API.G_RET_STS_ERROR;
2480: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2481: ,p_data => x_msg_data);
2482: WHEN OTHERS THEN
2483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2484: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 2484: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2480: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2481: ,p_data => x_msg_data);
2482: WHEN OTHERS THEN
2483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2484: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2485: ,p_data => x_msg_data);
2486: IF (x_msg_data IS NULL) THEN
2487: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ROW: ' || SQLERRM;
2488: END IF;

Line 2521: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2517:
2518: EXCEPTION
2519: WHEN FND_API.G_EXC_ERROR THEN
2520: x_return_status := FND_API.G_RET_STS_ERROR;
2521: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2522: ,p_data => x_msg_data);
2523: WHEN OTHERS THEN
2524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2525: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 2525: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2521: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2522: ,p_data => x_msg_data);
2523: WHEN OTHERS THEN
2524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2525: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2526: ,p_data => x_msg_data);
2527: if (x_msg_data is null) then
2528: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW: ' || SQLERRM;
2529: end if;

Line 2582: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2578:
2579: EXCEPTION
2580: WHEN FND_API.G_EXC_ERROR THEN
2581: x_return_status := FND_API.G_RET_STS_ERROR;
2582: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2583: ,p_data => x_msg_data);
2584: WHEN OTHERS THEN
2585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2586: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 2586: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2582: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2583: ,p_data => x_msg_data);
2584: WHEN OTHERS THEN
2585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2586: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2587: ,p_data => x_msg_data);
2588: if (x_msg_data is null) then
2589: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_AND_REGION_ITEMS: ' || SQLERRM;
2590: end if;

Line 2633: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2629:
2630: EXCEPTION
2631: WHEN FND_API.G_EXC_ERROR THEN
2632: x_return_status := FND_API.G_RET_STS_ERROR;
2633: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2634: ,p_data => x_msg_data);
2635: WHEN OTHERS THEN
2636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2637: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 2637: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2633: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2634: ,p_data => x_msg_data);
2635: WHEN OTHERS THEN
2636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2637: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2638: ,p_data => x_msg_data);
2639: if (x_msg_data is null) then
2640: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_ITEMS: ' || SQLERRM;
2641: end if;

Line 2681: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2677:
2678: EXCEPTION
2679: WHEN FND_API.G_EXC_ERROR THEN
2680: x_return_status := FND_API.G_RET_STS_ERROR;
2681: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2682: ,p_data => x_msg_data);
2683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2685: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 2685: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2681: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2682: ,p_data => x_msg_data);
2683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2685: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2686: ,p_data => x_msg_data);
2687: WHEN NO_DATA_FOUND THEN
2688: x_return_status := FND_API.G_RET_STS_ERROR;
2689: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 2689: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2685: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2686: ,p_data => x_msg_data);
2687: WHEN NO_DATA_FOUND THEN
2688: x_return_status := FND_API.G_RET_STS_ERROR;
2689: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2690: ,p_data => x_msg_data);
2691: WHEN OTHERS THEN
2692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2693: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 2693: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2689: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2690: ,p_data => x_msg_data);
2691: WHEN OTHERS THEN
2692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2693: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2694: ,p_data => x_msg_data);
2695: if (x_msg_data is null) then
2696: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_EXT_ITEMS: ' || SQLERRM;
2697: end if;

Line 2872: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2868:
2869: EXCEPTION
2870: WHEN NO_DATA_FOUND THEN
2871: x_return_status := FND_API.G_RET_STS_ERROR;
2872: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2873: ,p_data => x_msg_data);
2874: WHEN OTHERS THEN
2875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2876: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 2876: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2872: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2873: ,p_data => x_msg_data);
2874: WHEN OTHERS THEN
2875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2876: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2877: ,p_data => x_msg_data);
2878: IF (x_msg_data IS NULL) THEN
2879: x_msg_data := 'BIS_AK_REGION_PUB.GET_REGION_ITEM_REC: ' || SQLERRM;
2880: END IF;

Line 2924: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2920: );
2921: EXCEPTION
2922: WHEN FND_API.G_EXC_ERROR THEN
2923: x_return_status := FND_API.G_RET_STS_ERROR;
2924: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2925: ,p_data => x_msg_data);
2926: WHEN OTHERS THEN
2927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2928: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 2928: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

2924: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2925: ,p_data => x_msg_data);
2926: WHEN OTHERS THEN
2927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2928: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2929: ,p_data => x_msg_data);
2930: IF (x_msg_data IS NULL) THEN
2931: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ATTR: ' || SQLERRM;
2932: END IF;

Line 3064: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

3060:
3061: EXCEPTION
3062: WHEN FND_API.G_EXC_ERROR THEN
3063: x_return_status := FND_API.G_RET_STS_ERROR;
3064: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
3065: ,p_data => x_msg_data);
3066: WHEN OTHERS THEN
3067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3068: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 3068: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

3064: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
3065: ,p_data => x_msg_data);
3066: WHEN OTHERS THEN
3067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3068: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
3069: ,p_data => x_msg_data);
3070: IF (x_msg_data IS NULL) THEN
3071: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ATTR: ' || SQLERRM;
3072: END IF;

Line 3301: FND_MSG_PUB.Initialize;

3297: FROM AK_REGIONS_VL A
3298: WHERE A.REGION_CODE = p_Region_Code
3299: AND A.REGION_APPLICATION_ID = p_Region_Application_Id;
3300: BEGIN
3301: FND_MSG_PUB.Initialize;
3302: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
3303:
3304: FOR c_AkRTl IN c_AkRegionsTl LOOP
3305: x_Region_Name := c_AkRTl.NAME;

Line 3365: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

3361: IF cr_items%ISOPEN THEN
3362: CLOSE cr_items;
3363: END IF;
3364: x_return_status := FND_API.G_RET_STS_ERROR;
3365: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3366: , p_count => x_msg_count
3367: , p_data => x_msg_data);
3368: WHEN OTHERS THEN
3369: IF cr_items%ISOPEN THEN

Line 3373: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

3369: IF cr_items%ISOPEN THEN
3370: CLOSE cr_items;
3371: END IF;
3372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3373: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3374: , p_count => x_msg_count
3375: , p_data => x_msg_data);
3376: IF (x_msg_data IS NULL) THEN
3377: x_msg_data := 'BIS_AK_REGION_PUB.reset_ak_items_display_seq: ' || SQLERRM;