DBA Data[Home] [Help]

APPS.ZPB_BUSAREA_MAINT dependencies on FND_MESSAGE

Line 15: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_EPB_BUSINESS_AREA');

11: is
12: l_count NUMBER;
13: l_name VARCHAR2(100);
14: begin
15: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_EPB_BUSINESS_AREA');
16: l_name := FND_MESSAGE.GET;
17:
18: select count(*)
19: into l_count

Line 16: l_name := FND_MESSAGE.GET;

12: l_count NUMBER;
13: l_name VARCHAR2(100);
14: begin
15: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_EPB_BUSINESS_AREA');
16: l_name := FND_MESSAGE.GET;
17:
18: select count(*)
19: into l_count
20: from ZPB_BUSINESS_AREAS_VL

Line 1285: FND_MESSAGE.CLEAR;

1281: end;
1282:
1283: if (length(l_ba_name) > 0)
1284: then
1285: FND_MESSAGE.CLEAR;
1286: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_BUSAREA_DELETE');
1287: FND_MESSAGE.SET_TOKEN('NAME', l_ba_name);
1288: l_retVal := FND_REQUEST.SUBMIT_REQUEST ('ZPB',
1289: 'ZPB_BA_DELETE',

Line 1286: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_BUSAREA_DELETE');

1282:
1283: if (length(l_ba_name) > 0)
1284: then
1285: FND_MESSAGE.CLEAR;
1286: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_BUSAREA_DELETE');
1287: FND_MESSAGE.SET_TOKEN('NAME', l_ba_name);
1288: l_retVal := FND_REQUEST.SUBMIT_REQUEST ('ZPB',
1289: 'ZPB_BA_DELETE',
1290: FND_MESSAGE.GET,

Line 1287: FND_MESSAGE.SET_TOKEN('NAME', l_ba_name);

1283: if (length(l_ba_name) > 0)
1284: then
1285: FND_MESSAGE.CLEAR;
1286: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_BUSAREA_DELETE');
1287: FND_MESSAGE.SET_TOKEN('NAME', l_ba_name);
1288: l_retVal := FND_REQUEST.SUBMIT_REQUEST ('ZPB',
1289: 'ZPB_BA_DELETE',
1290: FND_MESSAGE.GET,
1291: null,

Line 1290: FND_MESSAGE.GET,

1286: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_BUSAREA_DELETE');
1287: FND_MESSAGE.SET_TOKEN('NAME', l_ba_name);
1288: l_retVal := FND_REQUEST.SUBMIT_REQUEST ('ZPB',
1289: 'ZPB_BA_DELETE',
1290: FND_MESSAGE.GET,
1291: null,
1292: null,
1293: p_business_area_id);
1294: commit;

Line 1598: FND_MESSAGE.CLEAR;

1594: into l_ba_name
1595: from ZPB_BUSINESS_AREAS_VL
1596: where BUSINESS_AREA_ID = p_business_area_id;
1597:
1598: FND_MESSAGE.CLEAR;
1599: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_BUSAREA_REFRESH');
1600: FND_MESSAGE.SET_TOKEN('NAME', l_ba_name);
1601: return FND_REQUEST.SUBMIT_REQUEST ('ZPB',
1602: 'ZPB_MD_WRTBK',

Line 1599: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_BUSAREA_REFRESH');

1595: from ZPB_BUSINESS_AREAS_VL
1596: where BUSINESS_AREA_ID = p_business_area_id;
1597:
1598: FND_MESSAGE.CLEAR;
1599: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_BUSAREA_REFRESH');
1600: FND_MESSAGE.SET_TOKEN('NAME', l_ba_name);
1601: return FND_REQUEST.SUBMIT_REQUEST ('ZPB',
1602: 'ZPB_MD_WRTBK',
1603: FND_MESSAGE.GET,

Line 1600: FND_MESSAGE.SET_TOKEN('NAME', l_ba_name);

1596: where BUSINESS_AREA_ID = p_business_area_id;
1597:
1598: FND_MESSAGE.CLEAR;
1599: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_BUSAREA_REFRESH');
1600: FND_MESSAGE.SET_TOKEN('NAME', l_ba_name);
1601: return FND_REQUEST.SUBMIT_REQUEST ('ZPB',
1602: 'ZPB_MD_WRTBK',
1603: FND_MESSAGE.GET,
1604: null,

Line 1603: FND_MESSAGE.GET,

1599: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_BUSAREA_REFRESH');
1600: FND_MESSAGE.SET_TOKEN('NAME', l_ba_name);
1601: return FND_REQUEST.SUBMIT_REQUEST ('ZPB',
1602: 'ZPB_MD_WRTBK',
1603: FND_MESSAGE.GET,
1604: null,
1605: null,
1606: p_business_area_id);
1607: end REFRESH;