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.PV_PARTNER_PROGRAM_PVT dependencies on FND_MESSAGE

Line 258: -- FND_MESSAGE.set_name('PV', 'PV_PROGRAM_ENTER_PROPER_PARTNO');

254: -- OR p_program_rec.item_number = FND_API.g_miss_char)
255: -- THEN
256: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
257: -- THEN
258: -- FND_MESSAGE.set_name('PV', 'PV_PROGRAM_ENTER_PROPER_PARTNO');
259: -- FND_MSG_PUB.add;
260: -- END IF;
261: -- x_return_status := FND_API.g_ret_sts_error;
262: -- RETURN;

Line 270: FND_MESSAGE.set_name('PV', 'PV_SET_MASTER_INV_ORG_ID');

266: IF (l_org_Id IS NULL)
267: THEN
268: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
269: THEN
270: FND_MESSAGE.set_name('PV', 'PV_SET_MASTER_INV_ORG_ID');
271: FND_MSG_PUB.add;
272: END IF;
273: x_return_status := FND_API.g_ret_sts_error;
274: RETURN;

Line 281: FND_MESSAGE.set_name('PV', 'PV_SET_DEFAULT_UOM_CODE');

277: IF (l_uom_code IS NULL)
278: THEN
279: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
280: THEN
281: FND_MESSAGE.set_name('PV', 'PV_SET_DEFAULT_UOM_CODE');
282: FND_MSG_PUB.add;
283: END IF;
284: x_return_status := FND_API.g_ret_sts_error;
285: RETURN;

Line 295: FND_MESSAGE.set_name('PV', 'PV_PROGRAM_INVENTORY_NOT_SET');

291: IF (l_flx_fld IS NULL)
292: THEN
293: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
294: THEN
295: FND_MESSAGE.set_name('PV', 'PV_PROGRAM_INVENTORY_NOT_SET');
296: FND_MSG_PUB.add;
297: END IF;
298: x_return_status := FND_API.g_ret_sts_error;
299: RETURN;

Line 305: FND_MESSAGE.set_name('PV', 'PV_PRGM_PROF_VAL_INCORRECT');

301:
302: --check whether the profile value for PV_PROGRAM_INV_FLEX_SEGMENTS contains PV_PRGM_FLEX_CODE
303: l_no:=INSTR(l_flx_fld,'PV_PRGM_FLEX_CODE');
304: IF l_no=0 THEN
305: FND_MESSAGE.set_name('PV', 'PV_PRGM_PROF_VAL_INCORRECT');
306: FND_MSG_PUB.add;
307: RAISE FND_API.G_EXC_ERROR;
308: END IF;
309: -- /*** here pre concatenating the val with 1st Five characters of the program Name so it is the unique ***/

Line 343: Fnd_Message.SET_NAME('PV','PV_UOM_CODE_NOT_DEFINED');

339: FETCH uom_csr INTO l_flag;
340: CLOSE uom_csr;
341:
342: IF l_flag is NULL THEN
343: Fnd_Message.SET_NAME('PV','PV_UOM_CODE_NOT_DEFINED');
344: Fnd_Msg_Pub.ADD;
345: RAISE FND_API.G_EXC_ERROR;
346: END IF;
347:

Line 379: Fnd_Message.SET_NAME('PV','PV_PRGM_CREAT_INVENTORY');

375: x_error_tbl(l_cnt).organization_id := l_error_tbl(l_cnt).organization_id;
376: END LOOP;
377: END IF;
378: FOR i IN 1 .. x_error_tbl.count LOOP
379: Fnd_Message.SET_NAME('PV','PV_PRGM_CREAT_INVENTORY');
380: Fnd_Message.SET_TOKEN('ERROR_MSG','Transaction_id is '|| x_error_tbl(i).transaction_id
381: ||', message_name is '||x_error_tbl(i).message_name
382: || ', mesage_text is '||x_error_tbl(i).message_text
383: || ', table name is '||x_error_tbl(i).table_name

Line 380: Fnd_Message.SET_TOKEN('ERROR_MSG','Transaction_id is '|| x_error_tbl(i).transaction_id

376: END LOOP;
377: END IF;
378: FOR i IN 1 .. x_error_tbl.count LOOP
379: Fnd_Message.SET_NAME('PV','PV_PRGM_CREAT_INVENTORY');
380: Fnd_Message.SET_TOKEN('ERROR_MSG','Transaction_id is '|| x_error_tbl(i).transaction_id
381: ||', message_name is '||x_error_tbl(i).message_name
382: || ', mesage_text is '||x_error_tbl(i).message_text
383: || ', table name is '||x_error_tbl(i).table_name
384: || ', column name is '||x_error_tbl(i).column_name

Line 460: FND_MESSAGE.set_name('PV', 'PV_SET_DEFAULT_UOM_CODE');

456: IF (l_uom_code IS NULL)
457: THEN
458: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
459: THEN
460: FND_MESSAGE.set_name('PV', 'PV_SET_DEFAULT_UOM_CODE');
461: FND_MSG_PUB.add;
462: END IF;
463: x_return_status := FND_API.g_ret_sts_error;
464: RETURN;

Line 981: FND_MESSAGE.set_name('PV', 'PV_PROGRAM_BAD_USER_STATUS');

977: CLOSE c_status_code;
978:
979: IF l_status_code IS NULL THEN
980: x_return_status := FND_API.g_ret_sts_error;
981: FND_MESSAGE.set_name('PV', 'PV_PROGRAM_BAD_USER_STATUS');
982: FND_MESSAGE.set_token('ID',to_char( p_user_status_id) );
983: FND_MSG_PUB.add;
984: END IF;
985:

Line 982: FND_MESSAGE.set_token('ID',to_char( p_user_status_id) );

978:
979: IF l_status_code IS NULL THEN
980: x_return_status := FND_API.g_ret_sts_error;
981: FND_MESSAGE.set_name('PV', 'PV_PROGRAM_BAD_USER_STATUS');
982: FND_MESSAGE.set_token('ID',to_char( p_user_status_id) );
983: FND_MSG_PUB.add;
984: END IF;
985:
986: x_status_code := l_status_code;

Line 1071: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');

1067:
1068: --------------- validate -------------------------
1069:
1070: IF FND_GLOBAL.User_Id IS NULL THEN
1071: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
1072: FND_MSG_PUB.add;
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;
1075: get_program_status_code(l_ptr_prgm_rec.user_status_id,l_ptr_prgm_rec.program_status_code,x_return_status);

Line 1102: FND_MESSAGE.set_name('PV', 'PV_PRGM_CURRENCY_UNDEFINED');

1098:
1099: --get the currency of the logged in user
1100: l_currency:=FND_PROFILE.Value('ICX_PREFERRED_CURRENCY');
1101: IF l_currency IS NULL THEN
1102: FND_MESSAGE.set_name('PV', 'PV_PRGM_CURRENCY_UNDEFINED');
1103: FND_MSG_PUB.add;
1104: RAISE FND_API.G_EXC_ERROR;
1105: END IF;
1106:

Line 1110: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1106:
1107: --program name is a required filed for process rule api and so doing the validation here.
1108: IF l_ptr_prgm_rec.program_name = FND_API.g_miss_char
1109: OR l_ptr_prgm_rec.program_name IS NULL THEN
1110: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1111: FND_MESSAGE.set_token('COLUMN','PROGRAM_NAME');
1112: FND_MSG_PUB.add;
1113: RAISE FND_API.g_exc_error;
1114:

Line 1111: FND_MESSAGE.set_token('COLUMN','PROGRAM_NAME');

1107: --program name is a required filed for process rule api and so doing the validation here.
1108: IF l_ptr_prgm_rec.program_name = FND_API.g_miss_char
1109: OR l_ptr_prgm_rec.program_name IS NULL THEN
1110: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1111: FND_MESSAGE.set_token('COLUMN','PROGRAM_NAME');
1112: FND_MSG_PUB.add;
1113: RAISE FND_API.g_exc_error;
1114:
1115: END IF;

Line 1385: FND_MESSAGE.set_name('PV', 'PV_END_DATE_SMALL_START_DATE');

1381:
1382:
1383:
1384: IF l_ptr_prgm_rec.program_start_date>=l_ptr_prgm_rec.program_end_date THEN
1385: FND_MESSAGE.set_name('PV', 'PV_END_DATE_SMALL_START_DATE');
1386: FND_MSG_PUB.add;
1387: RAISE FND_API.G_EXC_ERROR;
1388: END IF;
1389:

Line 1394: FND_MESSAGE.set_name('PV', 'PV_START_END_DATE_NOT_IN_RANGE');

1390:
1391: IF l_ptr_prgm_rec.program_parent_id is not null THEN
1392: l_start_end_date_within_range:=isStartEndDateInRange(l_ptr_prgm_rec.program_parent_id,l_ptr_prgm_rec.program_start_date,l_ptr_prgm_rec.program_end_date);
1393: IF l_start_end_date_within_range=false THEN
1394: FND_MESSAGE.set_name('PV', 'PV_START_END_DATE_NOT_IN_RANGE');
1395: FND_MSG_PUB.add;
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398: END IF ;

Line 1411: FND_MESSAGE.set_name('PV', 'PV_ENRL_DATE_NOT_INRANGE');

1407: ,l_ptr_prgm_rec.program_start_date
1408: ,l_ptr_prgm_rec.program_end_date
1409: );
1410: IF l_isNoEnrlDateInRange=false THEN
1411: FND_MESSAGE.set_name('PV', 'PV_ENRL_DATE_NOT_INRANGE');
1412: FND_MSG_PUB.add;
1413: RAISE FND_API.G_EXC_ERROR;
1414: END IF;
1415:

Line 1810: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');

1806: OPEN c_get_Partner_Program( l_tar_ptr_prgm_rec.program_id);
1807: FETCH c_get_Partner_Program INTO l_ref_ptr_prgm_rec ;
1808:
1809: IF ( c_get_Partner_Program%NOTFOUND) THEN
1810: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
1811: FND_MESSAGE.set_token('MODE','Update');
1812: FND_MESSAGE.set_token('ENTITY','Partner_Program');
1813: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_rec.program_id));
1814: FND_MSG_PUB.add;

Line 1811: FND_MESSAGE.set_token('MODE','Update');

1807: FETCH c_get_Partner_Program INTO l_ref_ptr_prgm_rec ;
1808:
1809: IF ( c_get_Partner_Program%NOTFOUND) THEN
1810: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
1811: FND_MESSAGE.set_token('MODE','Update');
1812: FND_MESSAGE.set_token('ENTITY','Partner_Program');
1813: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_rec.program_id));
1814: FND_MSG_PUB.add;
1815: RAISE FND_API.G_EXC_ERROR;

Line 1812: FND_MESSAGE.set_token('ENTITY','Partner_Program');

1808:
1809: IF ( c_get_Partner_Program%NOTFOUND) THEN
1810: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
1811: FND_MESSAGE.set_token('MODE','Update');
1812: FND_MESSAGE.set_token('ENTITY','Partner_Program');
1813: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_rec.program_id));
1814: FND_MSG_PUB.add;
1815: RAISE FND_API.G_EXC_ERROR;
1816: END IF;

Line 1813: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_rec.program_id));

1809: IF ( c_get_Partner_Program%NOTFOUND) THEN
1810: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
1811: FND_MESSAGE.set_token('MODE','Update');
1812: FND_MESSAGE.set_token('ENTITY','Partner_Program');
1813: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_rec.program_id));
1814: FND_MSG_PUB.add;
1815: RAISE FND_API.G_EXC_ERROR;
1816: END IF;
1817:

Line 1828: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');

1824:
1825: IF (l_tar_ptr_prgm_rec.object_version_number IS NULL OR
1826: l_tar_ptr_prgm_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1827:
1828: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
1829: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
1830: FND_MSG_PUB.add;
1831: RAISE FND_API.G_EXC_ERROR;
1832: End if;

Line 1829: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');

1825: IF (l_tar_ptr_prgm_rec.object_version_number IS NULL OR
1826: l_tar_ptr_prgm_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1827:
1828: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
1829: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
1830: FND_MSG_PUB.add;
1831: RAISE FND_API.G_EXC_ERROR;
1832: End if;
1833:

Line 1836: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');

1832: End if;
1833:
1834: -- Check Whether record has been changed by someone else
1835: If (l_tar_ptr_prgm_rec.object_version_number <> l_ref_ptr_prgm_rec.object_version_number) THEN
1836: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
1837: FND_MESSAGE.set_token('VALUE','Partner_Program');
1838: FND_MSG_PUB.add;
1839: RAISE FND_API.G_EXC_ERROR;
1840: End if;

Line 1837: FND_MESSAGE.set_token('VALUE','Partner_Program');

1833:
1834: -- Check Whether record has been changed by someone else
1835: If (l_tar_ptr_prgm_rec.object_version_number <> l_ref_ptr_prgm_rec.object_version_number) THEN
1836: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
1837: FND_MESSAGE.set_token('VALUE','Partner_Program');
1838: FND_MSG_PUB.add;
1839: RAISE FND_API.G_EXC_ERROR;
1840: End if;
1841:

Line 1899: FND_MESSAGE.set_name('PV', 'PV_END_DATE_SMALL_START_DATE');

1895: );
1896: get_program_status_code(l_tar_ptr_prgm_rec.user_status_id,l_tar_ptr_prgm_rec.program_status_code,x_return_status);
1897:
1898: IF l_tar_ptr_prgm_rec.program_start_date>=l_tar_ptr_prgm_rec.program_end_date THEN
1899: FND_MESSAGE.set_name('PV', 'PV_END_DATE_SMALL_START_DATE');
1900: FND_MSG_PUB.add;
1901: RAISE FND_API.G_EXC_ERROR;
1902: END IF;
1903:

Line 1907: FND_MESSAGE.set_name('PV', 'PV_START_END_DATE_NOT_IN_RANGE');

1903:
1904: IF (l_tar_ptr_prgm_rec.program_parent_id is not null) and (l_tar_ptr_prgm_rec.program_parent_id <> FND_API.g_miss_num) THEN
1905: l_start_end_date_within_range:=isStartEndDateInRange(l_tar_ptr_prgm_rec.program_parent_id,l_tar_ptr_prgm_rec.program_start_date,l_tar_ptr_prgm_rec.program_end_date);
1906: IF l_start_end_date_within_range=false THEN
1907: FND_MESSAGE.set_name('PV', 'PV_START_END_DATE_NOT_IN_RANGE');
1908: FND_MSG_PUB.add;
1909: RAISE FND_API.G_EXC_ERROR;
1910: END IF;
1911: END IF ;

Line 1916: FND_MESSAGE.set_name('PV', 'PV_PARENT_NOT_ACTIVATED');

1912:
1913: IF (l_tar_ptr_prgm_rec.program_parent_id is not null) and (l_tar_ptr_prgm_rec.program_parent_id <> FND_API.g_miss_num) and (l_tar_ptr_prgm_rec.program_status_code='ACTIVE') THEN
1914: l_activatable:=isChildActivatable(l_tar_ptr_prgm_rec.program_parent_id);
1915: IF l_activatable=false THEN
1916: FND_MESSAGE.set_name('PV', 'PV_PARENT_NOT_ACTIVATED');
1917: FND_MSG_PUB.add;
1918: RAISE FND_API.G_EXC_ERROR;
1919: END IF;
1920: END IF;

Line 1931: FND_MESSAGE.set_name('PV', 'PV_PRGM_INV_ITEM_UNDEFIND');

1927: ) THEN
1928:
1929: l_check_inventory_item_exists:=check_inventory_item_exists(l_tar_ptr_prgm_rec.program_id);
1930: IF ( l_check_inventory_item_exists='N' ) THEN
1931: FND_MESSAGE.set_name('PV', 'PV_PRGM_INV_ITEM_UNDEFIND');
1932: FND_MSG_PUB.add;
1933: RAISE FND_API.G_EXC_ERROR;
1934: END IF;
1935:

Line 1940: FND_MESSAGE.set_name('PV', 'PV_PRGM_PRICE_UNDEFINED_SUBMIT');

1936: -- check whether price is defined for this membership
1937: l_check_price_exists:=check_price_exists(l_tar_ptr_prgm_rec.program_id);
1938:
1939: IF ( l_check_price_exists='N' ) THEN
1940: FND_MESSAGE.set_name('PV', 'PV_PRGM_PRICE_UNDEFINED_SUBMIT');
1941: FND_MSG_PUB.add;
1942: RAISE FND_API.G_EXC_ERROR;
1943: END IF;
1944: END IF;

Line 1954: FND_MESSAGE.set_name('PV', 'PV_PRGM_INV_ITEM_UNDEFIND');

1950: ) THEN
1951:
1952: l_check_inventory_item_exists:=check_inventory_item_exists(l_tar_ptr_prgm_rec.program_id);
1953: IF ( l_check_inventory_item_exists='N' ) THEN
1954: FND_MESSAGE.set_name('PV', 'PV_PRGM_INV_ITEM_UNDEFIND');
1955: FND_MSG_PUB.add;
1956: RAISE FND_API.G_EXC_ERROR;
1957: END IF;
1958:

Line 1962: FND_MESSAGE.set_name('PV', 'PV_PRGM_PRICE_UNDEFINED_ACTIVE');

1958:
1959: l_check_price_exists:=check_price_exists(l_tar_ptr_prgm_rec.program_id);
1960:
1961: IF ( l_check_price_exists='N' ) THEN
1962: FND_MESSAGE.set_name('PV', 'PV_PRGM_PRICE_UNDEFINED_ACTIVE');
1963: FND_MSG_PUB.add;
1964: RAISE FND_API.G_EXC_ERROR;
1965: END IF;
1966: END IF;

Line 1981: FND_MESSAGE.set_name('PV', 'PV_PRGM_NO_DURATION');

1977: ) THEN
1978:
1979: --l_check_membership_duration:=check_membership_duration(l_tar_ptr_prgm_rec.program_id);
1980: --IF ( l_check_membership_duration='N' ) THEN
1981: FND_MESSAGE.set_name('PV', 'PV_PRGM_NO_DURATION');
1982: FND_MSG_PUB.add;
1983: RAISE FND_API.G_EXC_ERROR;
1984: -- END IF;
1985:

Line 1994: FND_MESSAGE.set_name('PV', 'PV_ENRQ_DEFAULT_APPR_NOT_SET');

1990: IF ( l_tar_ptr_prgm_rec.program_status_code='ACTIVE' and
1991: l_tar_ptr_prgm_rec.program_level_code='MEMBERSHIP' and
1992: l_default_appr is NULL ) THEN
1993:
1994: FND_MESSAGE.set_name('PV', 'PV_ENRQ_DEFAULT_APPR_NOT_SET');
1995: FND_MSG_PUB.add;
1996: RAISE FND_API.G_EXC_ERROR;
1997:
1998: END IF;

Line 2010: FND_MESSAGE.set_name('PV', 'PV_ENRL_DATE_NOT_INRANGE');

2006: ,l_tar_ptr_prgm_rec.program_start_date
2007: ,l_tar_ptr_prgm_rec.program_end_date
2008: );
2009: IF l_isNoEnrlDateInRange=false THEN
2010: FND_MESSAGE.set_name('PV', 'PV_ENRL_DATE_NOT_INRANGE');
2011: FND_MSG_PUB.add;
2012: RAISE FND_API.G_EXC_ERROR;
2013: END IF;
2014:

Line 2103: FND_MESSAGE.set_name('PV', 'PV_CHILD_NOT_CANCLD_OR_CLSED');

2099:
2100: IF l_tar_ptr_prgm_rec.program_status_code in ('CANCEL' ,'CLOSED') THEN
2101: l_is_ProgramCancellable:=isProgramCancellable(l_tar_ptr_prgm_rec.program_id);
2102: IF l_is_ProgramCancellable=false THEN
2103: FND_MESSAGE.set_name('PV', 'PV_CHILD_NOT_CANCLD_OR_CLSED');
2104: FND_MSG_PUB.add;
2105: RAISE FND_API.G_EXC_ERROR;
2106: END IF;
2107:

Line 2123: FND_MESSAGE.set_name('PV', 'PV_PARENT_NOT_APPROVED');

2119: END IF;
2120: IF (l_tar_ptr_prgm_rec.program_parent_id is not null) and (l_tar_ptr_prgm_rec.program_parent_id <> FND_API.g_miss_num) THEN
2121: l_is_parent_approved:=isParentApproved(l_tar_ptr_prgm_rec.program_parent_id);
2122: IF l_is_parent_approved=false THEN
2123: FND_MESSAGE.set_name('PV', 'PV_PARENT_NOT_APPROVED');
2124: FND_MSG_PUB.add;
2125: RAISE FND_API.G_EXC_ERROR;
2126: END IF;
2127: -- to flag that the child programs need to be submitted for approval

Line 2169: FND_MESSAGE.set_name('PV', 'PV_APPROVER_NOT_AVAILABLE');

2165: ,p_item_type=>'AMSGAPP'
2166: );
2167:
2168: ELSE
2169: FND_MESSAGE.set_name('PV', 'PV_APPROVER_NOT_AVAILABLE');
2170: FND_MSG_PUB.add;
2171: RAISE FND_API.G_EXC_ERROR;
2172: END IF;
2173: END IF;

Line 2177: FND_MESSAGE.set_name('PV', 'PV_ENROLLER_NOT_VALID');

2173: END IF;
2174: /**IF l_tar_ptr_prgm_rec.program_status_code not in('CANCEL','CLOSED','ARCHIVE') THEN
2175: l_enrollment_valid :=isEnrollApproverValid(l_tar_ptr_prgm_rec.program_id,l_tar_ptr_prgm_rec.program_end_date);
2176: IF l_enrollment_valid=false THEN
2177: FND_MESSAGE.set_name('PV', 'PV_ENROLLER_NOT_VALID');
2178: FND_MSG_PUB.add;
2179:
2180: END IF;
2181: END IF;

Line 2311: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');

2307: END IF;
2308: IF (p_object_version_number is NULL or
2309: p_object_version_number = FND_API.G_MISS_NUM ) THEN
2310:
2311: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
2312: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
2313: FND_MSG_PUB.add;
2314: RAISE FND_API.G_EXC_ERROR;
2315: END IF;

Line 2312: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');

2308: IF (p_object_version_number is NULL or
2309: p_object_version_number = FND_API.G_MISS_NUM ) THEN
2310:
2311: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
2312: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
2313: FND_MSG_PUB.add;
2314: RAISE FND_API.G_EXC_ERROR;
2315: END IF;
2316:

Line 2327: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');

2323: OPEN c_get_partner_program_rec(p_program_id);
2324: FETCH c_get_partner_program_rec INTO l_ref_ptr_prgm_rec ;
2325:
2326: IF ( c_get_partner_program_rec%NOTFOUND) THEN
2327: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
2328: FND_MESSAGE.set_token('MODE','Update');
2329: FND_MESSAGE.set_token('ENTITY','Partner_Program');
2330: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_rec.program_id));
2331: FND_MSG_PUB.add;

Line 2328: FND_MESSAGE.set_token('MODE','Update');

2324: FETCH c_get_partner_program_rec INTO l_ref_ptr_prgm_rec ;
2325:
2326: IF ( c_get_partner_program_rec%NOTFOUND) THEN
2327: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
2328: FND_MESSAGE.set_token('MODE','Update');
2329: FND_MESSAGE.set_token('ENTITY','Partner_Program');
2330: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_rec.program_id));
2331: FND_MSG_PUB.add;
2332: RAISE FND_API.G_EXC_ERROR;

Line 2329: FND_MESSAGE.set_token('ENTITY','Partner_Program');

2325:
2326: IF ( c_get_partner_program_rec%NOTFOUND) THEN
2327: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
2328: FND_MESSAGE.set_token('MODE','Update');
2329: FND_MESSAGE.set_token('ENTITY','Partner_Program');
2330: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_rec.program_id));
2331: FND_MSG_PUB.add;
2332: RAISE FND_API.G_EXC_ERROR;
2333: END IF;

Line 2330: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_rec.program_id));

2326: IF ( c_get_partner_program_rec%NOTFOUND) THEN
2327: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
2328: FND_MESSAGE.set_token('MODE','Update');
2329: FND_MESSAGE.set_token('ENTITY','Partner_Program');
2330: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_rec.program_id));
2331: FND_MSG_PUB.add;
2332: RAISE FND_API.G_EXC_ERROR;
2333: END IF;
2334:

Line 2345: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');

2341:
2342: IF (l_tar_ptr_prgm_rec.object_version_number is NULL or
2343: l_tar_ptr_prgm_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
2344:
2345: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
2346: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
2347: FND_MSG_PUB.add;
2348: raise FND_API.G_EXC_ERROR;
2349: End if;

Line 2346: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');

2342: IF (l_tar_ptr_prgm_rec.object_version_number is NULL or
2343: l_tar_ptr_prgm_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
2344:
2345: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
2346: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
2347: FND_MSG_PUB.add;
2348: raise FND_API.G_EXC_ERROR;
2349: End if;
2350:

Line 2353: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');

2349: End if;
2350:
2351: -- Check Whether record has been changed by someone else
2352: If (l_tar_ptr_prgm_rec.object_version_number <> l_ref_ptr_prgm_rec.object_version_number) THEN
2353: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
2354: FND_MESSAGE.set_token('VALUE','Partner_Program');
2355: FND_MSG_PUB.add;
2356: raise FND_API.G_EXC_ERROR;
2357: End if;

Line 2354: FND_MESSAGE.set_token('VALUE','Partner_Program');

2350:
2351: -- Check Whether record has been changed by someone else
2352: If (l_tar_ptr_prgm_rec.object_version_number <> l_ref_ptr_prgm_rec.object_version_number) THEN
2353: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
2354: FND_MESSAGE.set_token('VALUE','Partner_Program');
2355: FND_MSG_PUB.add;
2356: raise FND_API.G_EXC_ERROR;
2357: End if;
2358: --Check whether the status is PENDING_APPROVAL. if so delete should not be allowed by raising exception

Line 2360: FND_MESSAGE.set_name('PV', 'PV_PENDING_APPROVAL');

2356: raise FND_API.G_EXC_ERROR;
2357: End if;
2358: --Check whether the status is PENDING_APPROVAL. if so delete should not be allowed by raising exception
2359: If (l_ref_ptr_prgm_rec.program_status_code='PENDING_APPROVAL') THEN
2360: FND_MESSAGE.set_name('PV', 'PV_PENDING_APPROVAL');
2361: FND_MSG_PUB.add;
2362: raise FND_API.G_EXC_ERROR;
2363: End if;
2364: l_is_deletable :=isProgramDeletable(l_tar_ptr_prgm_rec.program_id);

Line 2366: FND_MESSAGE.set_name('PV', 'PV_CHILD_PROGRAM');

2362: raise FND_API.G_EXC_ERROR;
2363: End if;
2364: l_is_deletable :=isProgramDeletable(l_tar_ptr_prgm_rec.program_id);
2365: if ( l_is_deletable =false) THEN
2366: FND_MESSAGE.set_name('PV', 'PV_CHILD_PROGRAM');
2367: FND_MSG_PUB.add;
2368: raise FND_API.G_EXC_ERROR;
2369: End if;
2370:

Line 2502: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_NOT_FOUND');

2498:
2499: IF (c_Partner_Program%NOTFOUND) THEN
2500: CLOSE c_Partner_Program;
2501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2502: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_NOT_FOUND');
2503: FND_MSG_PUB.add;
2504: END IF;
2505: RAISE FND_API.g_exc_error;
2506: END IF;

Line 2587: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');

2583: 'PROGRAM_ID = ''' || p_ptr_prgm_rec.PROGRAM_ID ||''''
2584: );
2585:
2586: IF l_valid_flag = FND_API.g_false THEN
2587: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
2588: FND_MESSAGE.set_token('ID',to_char(p_ptr_prgm_rec.PROGRAM_ID) );
2589: FND_MESSAGE.set_token('ENTITY','Partner_Program');
2590: FND_MSG_PUB.add;
2591: x_return_status := FND_API.g_ret_sts_error;

Line 2588: FND_MESSAGE.set_token('ID',to_char(p_ptr_prgm_rec.PROGRAM_ID) );

2584: );
2585:
2586: IF l_valid_flag = FND_API.g_false THEN
2587: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
2588: FND_MESSAGE.set_token('ID',to_char(p_ptr_prgm_rec.PROGRAM_ID) );
2589: FND_MESSAGE.set_token('ENTITY','Partner_Program');
2590: FND_MSG_PUB.add;
2591: x_return_status := FND_API.g_ret_sts_error;
2592: RETURN;

Line 2589: FND_MESSAGE.set_token('ENTITY','Partner_Program');

2585:
2586: IF l_valid_flag = FND_API.g_false THEN
2587: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
2588: FND_MESSAGE.set_token('ID',to_char(p_ptr_prgm_rec.PROGRAM_ID) );
2589: FND_MESSAGE.set_token('ENTITY','Partner_Program');
2590: FND_MSG_PUB.add;
2591: x_return_status := FND_API.g_ret_sts_error;
2592: RETURN;
2593: END IF;

Line 2607: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');

2603: 'PROCESS_RULE_ID = ''' || p_ptr_prgm_rec.PROCESS_RULE_ID ||''''
2604: );
2605:
2606: IF l_valid_flag = FND_API.g_false THEN
2607: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
2608: FND_MESSAGE.set_token('ID',to_char(p_ptr_prgm_rec.PROCESS_RULE_ID) );
2609: FND_MESSAGE.set_token('ENTITY','Partner_Program');
2610: FND_MSG_PUB.add;
2611: x_return_status := FND_API.g_ret_sts_error;

Line 2608: FND_MESSAGE.set_token('ID',to_char(p_ptr_prgm_rec.PROCESS_RULE_ID) );

2604: );
2605:
2606: IF l_valid_flag = FND_API.g_false THEN
2607: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
2608: FND_MESSAGE.set_token('ID',to_char(p_ptr_prgm_rec.PROCESS_RULE_ID) );
2609: FND_MESSAGE.set_token('ENTITY','Partner_Program');
2610: FND_MSG_PUB.add;
2611: x_return_status := FND_API.g_ret_sts_error;
2612: RETURN;

Line 2609: FND_MESSAGE.set_token('ENTITY','Partner_Program');

2605:
2606: IF l_valid_flag = FND_API.g_false THEN
2607: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
2608: FND_MESSAGE.set_token('ID',to_char(p_ptr_prgm_rec.PROCESS_RULE_ID) );
2609: FND_MESSAGE.set_token('ENTITY','Partner_Program');
2610: FND_MSG_PUB.add;
2611: x_return_status := FND_API.g_ret_sts_error;
2612: RETURN;
2613: END IF;

Line 2627: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');

2623: 'PREREQ_PROCESS_RULE_ID = ''' || p_ptr_prgm_rec.PREREQ_PROCESS_RULE_ID ||''''
2624: );
2625:
2626: IF l_valid_flag = FND_API.g_false THEN
2627: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
2628: FND_MESSAGE.set_token('ID',to_char(p_ptr_prgm_rec.PREREQ_PROCESS_RULE_ID) );
2629: FND_MESSAGE.set_token('ENTITY','Partner_Program');
2630: FND_MSG_PUB.add;
2631: x_return_status := FND_API.g_ret_sts_error;

Line 2628: FND_MESSAGE.set_token('ID',to_char(p_ptr_prgm_rec.PREREQ_PROCESS_RULE_ID) );

2624: );
2625:
2626: IF l_valid_flag = FND_API.g_false THEN
2627: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
2628: FND_MESSAGE.set_token('ID',to_char(p_ptr_prgm_rec.PREREQ_PROCESS_RULE_ID) );
2629: FND_MESSAGE.set_token('ENTITY','Partner_Program');
2630: FND_MSG_PUB.add;
2631: x_return_status := FND_API.g_ret_sts_error;
2632: RETURN;

Line 2629: FND_MESSAGE.set_token('ENTITY','Partner_Program');

2625:
2626: IF l_valid_flag = FND_API.g_false THEN
2627: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
2628: FND_MESSAGE.set_token('ID',to_char(p_ptr_prgm_rec.PREREQ_PROCESS_RULE_ID) );
2629: FND_MESSAGE.set_token('ENTITY','Partner_Program');
2630: FND_MSG_PUB.add;
2631: x_return_status := FND_API.g_ret_sts_error;
2632: RETURN;
2633: END IF;

Line 2659: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2655: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2656:
2657: IF p_ptr_prgm_rec.program_id = FND_API.g_miss_num
2658: OR p_ptr_prgm_rec.program_id IS NULL THEN
2659: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2660: FND_MESSAGE.set_token('COLUMN','PROGRAM_ID');
2661: FND_MSG_PUB.add;
2662: x_return_status := FND_API.g_ret_sts_error;
2663: RETURN;

Line 2660: FND_MESSAGE.set_token('COLUMN','PROGRAM_ID');

2656:
2657: IF p_ptr_prgm_rec.program_id = FND_API.g_miss_num
2658: OR p_ptr_prgm_rec.program_id IS NULL THEN
2659: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2660: FND_MESSAGE.set_token('COLUMN','PROGRAM_ID');
2661: FND_MSG_PUB.add;
2662: x_return_status := FND_API.g_ret_sts_error;
2663: RETURN;
2664: END IF;

Line 2669: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2665:
2666:
2667: IF p_ptr_prgm_rec.PROGRAM_TYPE_ID = FND_API.g_miss_num
2668: OR p_ptr_prgm_rec.PROGRAM_TYPE_ID IS NULL THEN
2669: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2670: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_ID');
2671: FND_MSG_PUB.add;
2672: x_return_status := FND_API.g_ret_sts_error;
2673: RETURN;

Line 2670: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_ID');

2666:
2667: IF p_ptr_prgm_rec.PROGRAM_TYPE_ID = FND_API.g_miss_num
2668: OR p_ptr_prgm_rec.PROGRAM_TYPE_ID IS NULL THEN
2669: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2670: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_ID');
2671: FND_MSG_PUB.add;
2672: x_return_status := FND_API.g_ret_sts_error;
2673: RETURN;
2674: END IF;

Line 2679: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2675:
2676:
2677: IF p_ptr_prgm_rec.custom_setup_id = FND_API.g_miss_num
2678: OR p_ptr_prgm_rec.custom_setup_id IS NULL THEN
2679: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2680: FND_MESSAGE.set_token('COLUMN','CUSTOM_SETUP_ID');
2681: FND_MSG_PUB.add;
2682: x_return_status := FND_API.g_ret_sts_error;
2683: RETURN;

Line 2680: FND_MESSAGE.set_token('COLUMN','CUSTOM_SETUP_ID');

2676:
2677: IF p_ptr_prgm_rec.custom_setup_id = FND_API.g_miss_num
2678: OR p_ptr_prgm_rec.custom_setup_id IS NULL THEN
2679: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2680: FND_MESSAGE.set_token('COLUMN','CUSTOM_SETUP_ID');
2681: FND_MSG_PUB.add;
2682: x_return_status := FND_API.g_ret_sts_error;
2683: RETURN;
2684: END IF;

Line 2689: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2685:
2686:
2687: IF p_ptr_prgm_rec.program_level_code = FND_API.g_miss_char
2688: OR p_ptr_prgm_rec.program_level_code IS NULL THEN
2689: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2690: FND_MESSAGE.set_token('COLUMN','PROGRAM_LEVEL_CODE');
2691: FND_MSG_PUB.add;
2692: x_return_status := FND_API.g_ret_sts_error;
2693: RETURN;

Line 2690: FND_MESSAGE.set_token('COLUMN','PROGRAM_LEVEL_CODE');

2686:
2687: IF p_ptr_prgm_rec.program_level_code = FND_API.g_miss_char
2688: OR p_ptr_prgm_rec.program_level_code IS NULL THEN
2689: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2690: FND_MESSAGE.set_token('COLUMN','PROGRAM_LEVEL_CODE');
2691: FND_MSG_PUB.add;
2692: x_return_status := FND_API.g_ret_sts_error;
2693: RETURN;
2694: END IF;

Line 2699: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2695:
2696:
2697: IF p_ptr_prgm_rec.program_owner_resource_id = FND_API.g_miss_num
2698: OR p_ptr_prgm_rec.program_owner_resource_id IS NULL THEN
2699: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2700: FND_MESSAGE.set_token('COLUMN','PROGRAM_OWNER_RESOURCE_ID');
2701: FND_MSG_PUB.add;
2702: x_return_status := FND_API.g_ret_sts_error;
2703: RETURN;

Line 2700: FND_MESSAGE.set_token('COLUMN','PROGRAM_OWNER_RESOURCE_ID');

2696:
2697: IF p_ptr_prgm_rec.program_owner_resource_id = FND_API.g_miss_num
2698: OR p_ptr_prgm_rec.program_owner_resource_id IS NULL THEN
2699: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2700: FND_MESSAGE.set_token('COLUMN','PROGRAM_OWNER_RESOURCE_ID');
2701: FND_MSG_PUB.add;
2702: x_return_status := FND_API.g_ret_sts_error;
2703: RETURN;
2704: END IF;

Line 2709: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2705:
2706:
2707: IF p_ptr_prgm_rec.program_start_date = FND_API.g_miss_date
2708: OR p_ptr_prgm_rec.program_start_date IS NULL THEN
2709: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2710: FND_MESSAGE.set_token('COLUMN','PROGRAM_START_DATE');
2711: FND_MSG_PUB.add;
2712: x_return_status := FND_API.g_ret_sts_error;
2713: RETURN;

Line 2710: FND_MESSAGE.set_token('COLUMN','PROGRAM_START_DATE');

2706:
2707: IF p_ptr_prgm_rec.program_start_date = FND_API.g_miss_date
2708: OR p_ptr_prgm_rec.program_start_date IS NULL THEN
2709: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2710: FND_MESSAGE.set_token('COLUMN','PROGRAM_START_DATE');
2711: FND_MSG_PUB.add;
2712: x_return_status := FND_API.g_ret_sts_error;
2713: RETURN;
2714: END IF;

Line 2724: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2720:
2721:
2722: IF p_ptr_prgm_rec.program_end_date = FND_API.g_miss_date
2723: OR p_ptr_prgm_rec.program_end_date IS NULL THEN
2724: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2725: FND_MESSAGE.set_token('COLUMN','PROGRAM_END_DATE');
2726: FND_MSG_PUB.add;
2727: x_return_status := FND_API.g_ret_sts_error;
2728: RETURN;

Line 2725: FND_MESSAGE.set_token('COLUMN','PROGRAM_END_DATE');

2721:
2722: IF p_ptr_prgm_rec.program_end_date = FND_API.g_miss_date
2723: OR p_ptr_prgm_rec.program_end_date IS NULL THEN
2724: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2725: FND_MESSAGE.set_token('COLUMN','PROGRAM_END_DATE');
2726: FND_MSG_PUB.add;
2727: x_return_status := FND_API.g_ret_sts_error;
2728: RETURN;
2729: END IF;

Line 2734: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2730:
2731:
2732: IF p_ptr_prgm_rec.process_rule_id = FND_API.g_miss_num
2733: OR p_ptr_prgm_rec.process_rule_id IS NULL THEN
2734: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2735: FND_MESSAGE.set_token('COLUMN','PROCESS_RULE_ID');
2736: FND_MSG_PUB.add;
2737: x_return_status := FND_API.g_ret_sts_error;
2738: RETURN;

Line 2735: FND_MESSAGE.set_token('COLUMN','PROCESS_RULE_ID');

2731:
2732: IF p_ptr_prgm_rec.process_rule_id = FND_API.g_miss_num
2733: OR p_ptr_prgm_rec.process_rule_id IS NULL THEN
2734: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2735: FND_MESSAGE.set_token('COLUMN','PROCESS_RULE_ID');
2736: FND_MSG_PUB.add;
2737: x_return_status := FND_API.g_ret_sts_error;
2738: RETURN;
2739: END IF;

Line 2744: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2740:
2741:
2742: IF p_ptr_prgm_rec.program_status_code = FND_API.g_miss_char
2743: OR p_ptr_prgm_rec.program_status_code IS NULL THEN
2744: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2745: FND_MESSAGE.set_token('COLUMN','PROGRAM_STATUS_CODE');
2746: FND_MSG_PUB.add;
2747: x_return_status := FND_API.g_ret_sts_error;
2748: RETURN;

Line 2745: FND_MESSAGE.set_token('COLUMN','PROGRAM_STATUS_CODE');

2741:
2742: IF p_ptr_prgm_rec.program_status_code = FND_API.g_miss_char
2743: OR p_ptr_prgm_rec.program_status_code IS NULL THEN
2744: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2745: FND_MESSAGE.set_token('COLUMN','PROGRAM_STATUS_CODE');
2746: FND_MSG_PUB.add;
2747: x_return_status := FND_API.g_ret_sts_error;
2748: RETURN;
2749: END IF;

Line 2753: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2749: END IF;
2750:
2751: IF p_ptr_prgm_rec.submit_child_nodes = FND_API.g_miss_char
2752: OR p_ptr_prgm_rec.submit_child_nodes IS NULL THEN
2753: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2754: FND_MESSAGE.set_token('COLUMN','SUBMIT_CHILD_NODES');
2755: FND_MSG_PUB.add;
2756: x_return_status := FND_API.g_ret_sts_error;
2757: RETURN;

Line 2754: FND_MESSAGE.set_token('COLUMN','SUBMIT_CHILD_NODES');

2750:
2751: IF p_ptr_prgm_rec.submit_child_nodes = FND_API.g_miss_char
2752: OR p_ptr_prgm_rec.submit_child_nodes IS NULL THEN
2753: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2754: FND_MESSAGE.set_token('COLUMN','SUBMIT_CHILD_NODES');
2755: FND_MSG_PUB.add;
2756: x_return_status := FND_API.g_ret_sts_error;
2757: RETURN;
2758: END IF;

Line 2763: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2759:
2760: /*
2761: IF p_ptr_prgm_rec.bus_user_resp_id = FND_API.g_miss_num
2762: OR p_ptr_prgm_rec.bus_user_resp_id IS NULL THEN
2763: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2764: FND_MESSAGE.set_token('COLUMN','BUS_USER_RESP_ID');
2765: FND_MSG_PUB.add;
2766: x_return_status := FND_API.g_ret_sts_error;
2767: RETURN;

Line 2764: FND_MESSAGE.set_token('COLUMN','BUS_USER_RESP_ID');

2760: /*
2761: IF p_ptr_prgm_rec.bus_user_resp_id = FND_API.g_miss_num
2762: OR p_ptr_prgm_rec.bus_user_resp_id IS NULL THEN
2763: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2764: FND_MESSAGE.set_token('COLUMN','BUS_USER_RESP_ID');
2765: FND_MSG_PUB.add;
2766: x_return_status := FND_API.g_ret_sts_error;
2767: RETURN;
2768: END IF;

Line 2772: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2768: END IF;
2769:
2770: IF p_ptr_prgm_rec.admin_resp_id = FND_API.g_miss_num
2771: OR p_ptr_prgm_rec.admin_resp_id IS NULL THEN
2772: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2773: FND_MESSAGE.set_token('COLUMN','ADMIN_RESP_ID');
2774: FND_MSG_PUB.add;
2775: x_return_status := FND_API.g_ret_sts_error;
2776: RETURN;

Line 2773: FND_MESSAGE.set_token('COLUMN','ADMIN_RESP_ID');

2769:
2770: IF p_ptr_prgm_rec.admin_resp_id = FND_API.g_miss_num
2771: OR p_ptr_prgm_rec.admin_resp_id IS NULL THEN
2772: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2773: FND_MESSAGE.set_token('COLUMN','ADMIN_RESP_ID');
2774: FND_MSG_PUB.add;
2775: x_return_status := FND_API.g_ret_sts_error;
2776: RETURN;
2777: END IF;

Line 2781: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2777: END IF;
2778: */
2779: IF p_ptr_prgm_rec.no_fee_flag = FND_API.g_miss_char
2780: OR p_ptr_prgm_rec.no_fee_flag IS NULL THEN
2781: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2782: FND_MESSAGE.set_token('COLUMN','NO_FEE_FLAG');
2783: FND_MSG_PUB.add;
2784: x_return_status := FND_API.g_ret_sts_error;
2785: RETURN;

Line 2782: FND_MESSAGE.set_token('COLUMN','NO_FEE_FLAG');

2778: */
2779: IF p_ptr_prgm_rec.no_fee_flag = FND_API.g_miss_char
2780: OR p_ptr_prgm_rec.no_fee_flag IS NULL THEN
2781: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2782: FND_MESSAGE.set_token('COLUMN','NO_FEE_FLAG');
2783: FND_MSG_PUB.add;
2784: x_return_status := FND_API.g_ret_sts_error;
2785: RETURN;
2786: END IF;

Line 2790: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2786: END IF;
2787:
2788: IF p_ptr_prgm_rec.user_status_id = FND_API.g_miss_num
2789: OR p_ptr_prgm_rec.user_status_id IS NULL THEN
2790: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2791: FND_MESSAGE.set_token('COLUMN','USER_STATUS_ID');
2792: FND_MSG_PUB.add;
2793: x_return_status := FND_API.g_ret_sts_error;
2794: RETURN;

Line 2791: FND_MESSAGE.set_token('COLUMN','USER_STATUS_ID');

2787:
2788: IF p_ptr_prgm_rec.user_status_id = FND_API.g_miss_num
2789: OR p_ptr_prgm_rec.user_status_id IS NULL THEN
2790: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2791: FND_MESSAGE.set_token('COLUMN','USER_STATUS_ID');
2792: FND_MSG_PUB.add;
2793: x_return_status := FND_API.g_ret_sts_error;
2794: RETURN;
2795: END IF;

Line 2799: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2795: END IF;
2796:
2797: IF p_ptr_prgm_rec.enabled_flag = FND_API.g_miss_char
2798: OR p_ptr_prgm_rec.enabled_flag IS NULL THEN
2799: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2800: FND_MESSAGE.set_token('COLUMN','ENABLED_FLAG');
2801: FND_MSG_PUB.add;
2802: x_return_status := FND_API.g_ret_sts_error;
2803: RETURN;

Line 2800: FND_MESSAGE.set_token('COLUMN','ENABLED_FLAG');

2796:
2797: IF p_ptr_prgm_rec.enabled_flag = FND_API.g_miss_char
2798: OR p_ptr_prgm_rec.enabled_flag IS NULL THEN
2799: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2800: FND_MESSAGE.set_token('COLUMN','ENABLED_FLAG');
2801: FND_MSG_PUB.add;
2802: x_return_status := FND_API.g_ret_sts_error;
2803: RETURN;
2804: END IF;

Line 2809: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2805:
2806:
2807: IF p_ptr_prgm_rec.object_version_number = FND_API.g_miss_num
2808: OR p_ptr_prgm_rec.object_version_number IS NULL THEN
2809: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2810: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
2811: FND_MSG_PUB.add;
2812: x_return_status := FND_API.g_ret_sts_error;
2813: RETURN;

Line 2810: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');

2806:
2807: IF p_ptr_prgm_rec.object_version_number = FND_API.g_miss_num
2808: OR p_ptr_prgm_rec.object_version_number IS NULL THEN
2809: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2810: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
2811: FND_MSG_PUB.add;
2812: x_return_status := FND_API.g_ret_sts_error;
2813: RETURN;
2814: END IF;

Line 2819: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2815:
2816:
2817: IF p_ptr_prgm_rec.creation_date = FND_API.g_miss_date
2818: OR p_ptr_prgm_rec.creation_date IS NULL THEN
2819: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2820: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');
2821: FND_MSG_PUB.add;
2822: x_return_status := FND_API.g_ret_sts_error;
2823: RETURN;

Line 2820: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');

2816:
2817: IF p_ptr_prgm_rec.creation_date = FND_API.g_miss_date
2818: OR p_ptr_prgm_rec.creation_date IS NULL THEN
2819: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2820: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');
2821: FND_MSG_PUB.add;
2822: x_return_status := FND_API.g_ret_sts_error;
2823: RETURN;
2824: END IF;

Line 2835: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2831:
2832:
2833: IF p_ptr_prgm_rec.created_by = FND_API.g_miss_num
2834: OR p_ptr_prgm_rec.created_by IS NULL THEN
2835: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2836: FND_MESSAGE.set_token('COLUMN','CREATED_BY');
2837: FND_MSG_PUB.add;
2838: x_return_status := FND_API.g_ret_sts_error;
2839: RETURN;

Line 2836: FND_MESSAGE.set_token('COLUMN','CREATED_BY');

2832:
2833: IF p_ptr_prgm_rec.created_by = FND_API.g_miss_num
2834: OR p_ptr_prgm_rec.created_by IS NULL THEN
2835: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2836: FND_MESSAGE.set_token('COLUMN','CREATED_BY');
2837: FND_MSG_PUB.add;
2838: x_return_status := FND_API.g_ret_sts_error;
2839: RETURN;
2840: END IF;

Line 2845: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2841:
2842:
2843: IF p_ptr_prgm_rec.last_update_login = FND_API.g_miss_num
2844: OR p_ptr_prgm_rec.last_update_login IS NULL THEN
2845: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2846: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');
2847: FND_MSG_PUB.add;
2848: x_return_status := FND_API.g_ret_sts_error;
2849: RETURN;

Line 2846: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');

2842:
2843: IF p_ptr_prgm_rec.last_update_login = FND_API.g_miss_num
2844: OR p_ptr_prgm_rec.last_update_login IS NULL THEN
2845: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2846: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');
2847: FND_MSG_PUB.add;
2848: x_return_status := FND_API.g_ret_sts_error;
2849: RETURN;
2850: END IF;

Line 2855: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2851:
2852:
2853: IF p_ptr_prgm_rec.last_update_date = FND_API.g_miss_date
2854: OR p_ptr_prgm_rec.last_update_date IS NULL THEN
2855: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2856: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');
2857: FND_MSG_PUB.add;
2858: x_return_status := FND_API.g_ret_sts_error;
2859: RETURN;

Line 2856: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');

2852:
2853: IF p_ptr_prgm_rec.last_update_date = FND_API.g_miss_date
2854: OR p_ptr_prgm_rec.last_update_date IS NULL THEN
2855: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2856: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');
2857: FND_MSG_PUB.add;
2858: x_return_status := FND_API.g_ret_sts_error;
2859: RETURN;
2860: END IF;

Line 2865: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2861:
2862:
2863: IF p_ptr_prgm_rec.last_updated_by = FND_API.g_miss_num
2864: OR p_ptr_prgm_rec.last_updated_by IS NULL THEN
2865: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2866: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');
2867: FND_MSG_PUB.add;
2868: x_return_status := FND_API.g_ret_sts_error;
2869: RETURN;

Line 2866: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');

2862:
2863: IF p_ptr_prgm_rec.last_updated_by = FND_API.g_miss_num
2864: OR p_ptr_prgm_rec.last_updated_by IS NULL THEN
2865: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2866: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');
2867: FND_MSG_PUB.add;
2868: x_return_status := FND_API.g_ret_sts_error;
2869: RETURN;
2870: END IF;

Line 2875: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2871:
2872:
2873: IF p_ptr_prgm_rec.program_name = FND_API.g_miss_char
2874: OR p_ptr_prgm_rec.program_name IS NULL THEN
2875: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2876: FND_MESSAGE.set_token('COLUMN','PROGRAM_NAME');
2877: FND_MSG_PUB.add;
2878: x_return_status := FND_API.g_ret_sts_error;
2879: RETURN;

Line 2876: FND_MESSAGE.set_token('COLUMN','PROGRAM_NAME');

2872:
2873: IF p_ptr_prgm_rec.program_name = FND_API.g_miss_char
2874: OR p_ptr_prgm_rec.program_name IS NULL THEN
2875: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2876: FND_MESSAGE.set_token('COLUMN','PROGRAM_NAME');
2877: FND_MSG_PUB.add;
2878: x_return_status := FND_API.g_ret_sts_error;
2879: RETURN;
2880: END IF;

Line 2884: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2880: END IF;
2881: ELSE
2882:
2883: IF p_ptr_prgm_rec.program_id IS NULL THEN
2884: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2885: Fnd_Message.set_token('COLUMN','PROGRAM_ID');
2886: FND_MSG_PUB.add;
2887: x_return_status := FND_API.g_ret_sts_error;
2888: RETURN;

Line 2885: Fnd_Message.set_token('COLUMN','PROGRAM_ID');

2881: ELSE
2882:
2883: IF p_ptr_prgm_rec.program_id IS NULL THEN
2884: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2885: Fnd_Message.set_token('COLUMN','PROGRAM_ID');
2886: FND_MSG_PUB.add;
2887: x_return_status := FND_API.g_ret_sts_error;
2888: RETURN;
2889: END IF;

Line 2893: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

2889: END IF;
2890:
2891:
2892: IF p_ptr_prgm_rec.object_version_number IS NULL THEN
2893: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2894: Fnd_Message.set_token('COLUMN','OBJECT_VERSION_NUMBER');
2895: FND_MSG_PUB.add;
2896: x_return_status := FND_API.g_ret_sts_error;
2897: RETURN;

Line 2894: Fnd_Message.set_token('COLUMN','OBJECT_VERSION_NUMBER');

2890:
2891:
2892: IF p_ptr_prgm_rec.object_version_number IS NULL THEN
2893: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
2894: Fnd_Message.set_token('COLUMN','OBJECT_VERSION_NUMBER');
2895: FND_MSG_PUB.add;
2896: x_return_status := FND_API.g_ret_sts_error;
2897: RETURN;
2898: END IF;

Line 2950: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_OWNER');

2946: FETCH c_resource_exists INTO l_resource_exists;
2947: IF c_resource_exists%NOTFOUND THEN
2948: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2949: THEN
2950: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_OWNER');
2951: FND_MSG_PUB.add;
2952: END IF;
2953: CLOSE c_resource_exists;
2954: x_return_status := FND_API.g_ret_sts_error;

Line 2971: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PROCESS_RULE');

2967: FETCH c_pr_exists INTO l_pr_exists;
2968: IF c_pr_exists%NOTFOUND THEN
2969: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2970: THEN
2971: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PROCESS_RULE');
2972: FND_MSG_PUB.add;
2973: END IF;
2974: CLOSE c_pr_exists;
2975: RETURN;

Line 2993: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PROCESS_RULE');

2989: FETCH c_pr_exists_1 INTO l_pr_exists_1;
2990: IF c_pr_exists_1%NOTFOUND THEN
2991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2992: THEN
2993: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PROCESS_RULE');
2994: FND_MSG_PUB.add;
2995: END IF;
2996: CLOSE c_pr_exists_1;
2997: RETURN;

Line 3026: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PTR_PRGM_TYPE');

3022: ) = FND_API.g_false
3023: THEN
3024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3025: THEN
3026: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PTR_PRGM_TYPE');
3027: FND_MSG_PUB.add;
3028: END IF;
3029:
3030: x_return_status := FND_API.g_ret_sts_error;

Line 3062: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_CUSTOM_SETUP_ID');

3058: ) = FND_API.g_false
3059: THEN
3060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3061: THEN
3062: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_CUSTOM_SETUP_ID');
3063: FND_MSG_PUB.add;
3064: END IF;
3065:
3066: x_return_status := FND_API.g_ret_sts_error;

Line 3093: FND_MESSAGE.set_name('PV', 'PV_PARENT_PROGRAM_NOT_VALID');

3089: ) = FND_API.g_false
3090: THEN
3091: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3092: THEN
3093: FND_MESSAGE.set_name('PV', 'PV_PARENT_PROGRAM_NOT_VALID');
3094: FND_MSG_PUB.add;
3095: END IF;
3096:
3097: x_return_status := FND_API.g_ret_sts_error;

Line 3130: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PROGRAM_LEVEL');

3126: ) = FND_API.g_false
3127: THEN
3128: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3129: THEN
3130: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PROGRAM_LEVEL');
3131: FND_MSG_PUB.add;
3132: END IF;
3133: x_return_status := FND_API.g_ret_sts_error;
3134: RETURN;

Line 3155: FND_MESSAGE.set_name('PV', 'PV_INVALID_PROGRAM_MEMB_UNIT');

3151: ) = FND_API.g_false
3152: THEN
3153: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3154: THEN
3155: FND_MESSAGE.set_name('PV', 'PV_INVALID_PROGRAM_MEMB_UNIT');
3156: FND_MSG_PUB.add;
3157: END IF;
3158: x_return_status := FND_API.g_ret_sts_error;
3159: RETURN;

Line 3175: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PROGRAM_STATUS');

3171: ) = FND_API.g_false
3172: THEN
3173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3174: THEN
3175: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PROGRAM_STATUS');
3176: FND_MSG_PUB.add;
3177: END IF;
3178: x_return_status := FND_API.g_ret_sts_error;
3179: RETURN;

Line 5630: FND_MESSAGE.set_name('PV', 'PV_PRGM_CURRENCY_UNDEFINED');

5626: --get the currency of the logged in user
5627: l_currency:=FND_PROFILE.Value('ICX_PREFERRED_CURRENCY');
5628:
5629: IF l_currency IS NULL THEN
5630: FND_MESSAGE.set_name('PV', 'PV_PRGM_CURRENCY_UNDEFINED');
5631: FND_MSG_PUB.add;
5632: RAISE FND_API.G_EXC_ERROR;
5633: END IF;
5634: