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.PO_FED_FIELD_FUNCTIONS dependencies on FND_API

Line 497: x_return_status := FND_API.G_RET_STS_SUCCESS;

493: l_submissionValid := FALSE;
494: END IF;
495:
496: IF l_submissionValid THEN
497: x_return_status := FND_API.G_RET_STS_SUCCESS;
498: x_errorcode := '0';
499: x_msg_count := '1';
500: x_msg_data := 'SUCCESS';
501: ELSE

Line 509: x_return_status := FND_API.G_RET_STS_ERROR;

505: WHERE lookup_type like '%PR_UDA_ADDRESS_TYPES'
506: AND lookup_code = p_HiddenAddType
507: AND rownum =1 ;
508:
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: x_errorcode := '-1';
511: x_msg_count := '1';
512:
513: IF p_location IS NULL then

Line 536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

532: END IF;
533:
534: EXCEPTION
535: WHEN OTHERS THEN
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: x_errorcode := '-2';
538: x_msg_count := '1';
539: x_msg_data := 'Exception in pr_addresses_XSC';
540: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data||': '||SQLERRM );

Line 588: x_return_status := FND_API.G_RET_STS_SUCCESS;

584: l_submissionValid := TRUE;
585: END IF;
586:
587: IF l_submissionValid THEN
588: x_return_status := FND_API.G_RET_STS_SUCCESS;
589: x_errorcode := '0';
590: x_msg_count := '1';
591: x_msg_data := 'SUCCESS';
592: ELSE

Line 601: x_return_status := FND_API.G_RET_STS_ERROR;

597: WHERE lookup_type = 'PO_MOD_UDA_ADDRESS_TYPES'
598: AND lookup_code = p_HiddenAddType;
599:
600:
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: x_errorcode := '-1';
603: x_msg_count := '1';
604: x_msg_data := 'Location cannot be null for ' || l_AddTypeDispField;
605:

Line 619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

615: END IF;
616:
617: EXCEPTION
618: WHEN OTHERS THEN
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: x_errorcode := '-2';
621: x_msg_count := '1';
622: x_msg_data := 'Exception in addresses_XSC';
623: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data||': '||SQLERRM );

Line 699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

695: END IF;
696:
697: EXCEPTION
698: WHEN OTHERS THEN
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: x_errorcode := '-2';
701: x_msg_count := '1';
702: x_msg_data := 'Exception in addresses_XPD';
703: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data||': '||SQLERRM );

Line 799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

795: END IF;
796:
797: EXCEPTION
798: WHEN OTHERS THEN
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: x_errorcode := '-2';
801: x_msg_count := '1';
802: x_msg_data := 'Exception in addresses_XPD';
803: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data||': '||SQLERRM );

Line 918: x_return_status := FND_API.G_RET_STS_SUCCESS;

914: ,p_HiddenLKPType
915: ,l_functional_area
916: );
917:
918: x_return_status := FND_API.G_RET_STS_SUCCESS;
919: x_errorcode := '0';
920: x_msg_count := '1';
921: x_msg_data := 'SUCCESS';
922:

Line 952: x_return_status := FND_API.G_RET_STS_SUCCESS;

948: ,p_HiddenLKPType
949: ,l_functional_area
950: );
951:
952: x_return_status := FND_API.G_RET_STS_SUCCESS;
953: x_errorcode := '0';
954: x_msg_count := '1';
955: x_msg_data := 'SUCCESS';
956:

Line 986: x_return_status := FND_API.G_RET_STS_SUCCESS;

982: ,p_HiddenLKPType
983: ,l_functional_area
984: );
985:
986: x_return_status := FND_API.G_RET_STS_SUCCESS;
987: x_errorcode := '0';
988: x_msg_count := '1';
989: x_msg_data := 'SUCCESS';
990: ELSE

Line 996: x_return_status := FND_API.G_RET_STS_ERROR;

992: x_contactdtlsxml :=NULL;
993: END IF;
994: ELSE
995:
996: x_return_status := FND_API.G_RET_STS_ERROR;
997: x_errorcode := '-1';
998: x_msg_count := '1';
999: x_msg_data := 'LOV Event is from not LOCATION/CONTACT/ADDRESS_CODE';
1000:

Line 1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1007: END IF;
1008:
1009: EXCEPTION
1010: WHEN OTHERS THEN
1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1012: x_errorcode := '-2';
1013: x_msg_count := '1';
1014: x_msg_data := 'Exception in addresses_XLE';
1015:

Line 1051: x_return_status := FND_API.G_RET_STS_SUCCESS;

1047: FROM PO_LOOKUP_CODES
1048: WHERE LOOKUP_TYPE = 'PO_CLM_CUSTOMER_PROJECT_CODE'
1049: AND LOOKUP_CODE = p_cust_proj_code;
1050:
1051: x_return_status := FND_API.G_RET_STS_SUCCESS;
1052: x_errorcode := '0';
1053: x_msg_count := '1';
1054: x_msg_data := 'SUCCESS';
1055:

Line 1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1060:
1061:
1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: x_errorcode := '-2';
1066: x_msg_count := '1';
1067: x_msg_data := 'Exception in bu_pri_prj_inf_XLE : '|| SQLERRM;
1068:

Line 1107: x_return_status := FND_API.G_RET_STS_SUCCESS;

1103: UPDATE PO_REQUISITION_HEADERS_ALL
1104: SET CLM_PRIORITY_CODE = p_priority
1105: WHERE REQUISITION_HEADER_ID = p_header_id;
1106:
1107: x_return_status := FND_API.G_RET_STS_SUCCESS;
1108: x_errorcode := '0';
1109: x_msg_count := '1';
1110: x_msg_data := 'SUCCESS';
1111:

Line 1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1110: x_msg_data := 'SUCCESS';
1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1115: x_errorcode := '-2';
1116: x_msg_count := '1';
1117: x_msg_data := 'Exception in bu_pri_prj_inf_XPD : '|| SQLERRM ;
1118: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data );

Line 1143: x_return_status := FND_API.G_RET_STS_SUCCESS;

1139: SET CLM_PRIORITY_CODE = p_priority
1140: WHERE PO_HEADER_ID = p_header_id
1141: AND Draft_id = XPD_DRAFT_ID;
1142:
1143: x_return_status := FND_API.G_RET_STS_SUCCESS;
1144: x_errorcode := '0';
1145: x_msg_count := '1';
1146: x_msg_data := 'SUCCESS';
1147:

Line 1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1146: x_msg_data := 'SUCCESS';
1147:
1148: EXCEPTION
1149: WHEN OTHERS THEN
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1151: x_errorcode := '-2';
1152: x_msg_count := '1';
1153: x_msg_data := 'Exception in bu_pri_prj_inf_XPD : '|| SQLERRM ;
1154: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data );

Line 1181: x_return_status := FND_API.G_RET_STS_SUCCESS;

1177: WHERE LOOKUP_TYPE = 'PO_CLM_CUSTOMER_PROJECT_CODE'
1178: AND LOOKUP_CODE = p_cust_proj_code;
1179: END IF;
1180:
1181: x_return_status := FND_API.G_RET_STS_SUCCESS;
1182: x_errorcode := '0';
1183: x_msg_count := '1';
1184: x_msg_data := 'SUCCESS';
1185:

Line 1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1184: x_msg_data := 'SUCCESS';
1185:
1186: EXCEPTION
1187: WHEN OTHERS THEN
1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1189: x_errorcode := '-2';
1190: x_msg_count := '1';
1191: x_msg_data := 'Exception in fed_cust_desg_XLE : '|| SQLERRM ;
1192: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data );

Line 1221: x_return_status := FND_API.G_RET_STS_SUCCESS;

1217: WHERE PO_LINE_ID = p_line_id
1218: AND Draft_id = XPD_DRAFT_ID;
1219:
1220:
1221: x_return_status := FND_API.G_RET_STS_SUCCESS;
1222: x_errorcode := '0';
1223: x_msg_count := '1';
1224: x_msg_data := 'SUCCESS';
1225:

Line 1228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1224: x_msg_data := 'SUCCESS';
1225:
1226: EXCEPTION
1227: WHEN OTHERS THEN
1228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1229: x_errorcode := '-2';
1230: x_msg_count := '1';
1231: x_msg_data := 'Exception in po_fed_cust_desg_XPD: '|| SQLERRM ;
1232: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data );

Line 1265: x_return_status := FND_API.G_RET_STS_SUCCESS;

1261: EXCEPTION
1262: WHEN no_data_found then
1263: x_item_long_desc:= NULL;
1264: END;
1265: x_return_status := FND_API.G_RET_STS_SUCCESS;
1266: x_errorcode := '0';
1267: x_msg_count := '1';
1268: x_msg_data := 'SUCCESS';
1269:

Line 1273: x_return_status := FND_API.G_RET_STS_ERROR;

1269:
1270:
1271: ELSE
1272:
1273: x_return_status := FND_API.G_RET_STS_ERROR;
1274: x_errorcode := '-1';
1275: x_msg_count := '1';
1276: x_msg_data := 'Item Long Description already defaulted';
1277:

Line 1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1278: END IF;
1279:
1280: EXCEPTION
1281: WHEN OTHERS THEN
1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1283: x_errorcode := '-2';
1284: x_msg_count := '1';
1285: x_msg_data := 'Exception in add_item_info_XD';
1286: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data );

Line 1317: x_return_status := FND_API.G_RET_STS_SUCCESS;

1313: AND ORGANIZATION_ID = p_org_id
1314: AND language = userenv('LANG');
1315: END IF;
1316:
1317: x_return_status := FND_API.G_RET_STS_SUCCESS;
1318: x_errorcode := '0';
1319: x_msg_count := '1';
1320: x_msg_data := 'SUCCESS';
1321:

Line 1324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1320: x_msg_data := 'SUCCESS';
1321:
1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1325: x_errorcode := '-2';
1326: x_msg_count := '1';
1327: x_msg_data := 'Exception in add_item_info_XLE';
1328: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data );

Line 1428: x_return_status := FND_API.G_RET_STS_SUCCESS;

1424: AND DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', FCL3.LANGUAGE) = DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))';
1425:
1426: EXECUTE IMMEDIATE l_ship_addr_xml_sql INTO p_hidd_ship_addr USING p_ship_to_loc_id;
1427:
1428: x_return_status := FND_API.G_RET_STS_SUCCESS;
1429: x_errorcode := '0';
1430: x_msg_count := '1';
1431: x_msg_data := 'SUCCESS';
1432: ELSE

Line 1433: x_return_status := FND_API.G_RET_STS_ERROR;

1429: x_errorcode := '0';
1430: x_msg_count := '1';
1431: x_msg_data := 'SUCCESS';
1432: ELSE
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: x_errorcode := '-1';
1435: x_msg_count := '1';
1436: x_msg_data := 'Shipping address is already defaulted';
1437:

Line 1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1439: EXCEPTION
1440: WHEN No_Data_Found THEN
1441: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name ||': NO DATA FOUND' );
1442: WHEN OTHERS THEN
1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1444: x_errorcode := '-2';
1445: x_msg_count := '1';
1446: x_msg_data := 'Exception in ship_info_XD';
1447: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data );

Line 1554: x_return_status := FND_API.G_RET_STS_SUCCESS;

1550: x_ship_to_addr := NULL ;
1551:
1552: END IF ;
1553:
1554: x_return_status := FND_API.G_RET_STS_SUCCESS;
1555: x_errorcode := '0';
1556: x_msg_count := '1';
1557: x_msg_data := 'SUCCESS';
1558:

Line 1568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1564: p_hiddenZipCode := NULL ;
1565: x_ship_to_addr := NULL ;
1566:
1567: WHEN OTHERS THEN
1568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1569: x_errorcode := '-2';
1570: x_msg_count := '1';
1571: x_msg_data := 'Exception in ship_info_XLE';
1572: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data );

Line 1596: x_return_status := FND_API.G_RET_STS_SUCCESS;

1592: UPDATE PO_REQUISITION_HEADERS_ALL
1593: SET SUGGESTED_AWARD_NO = p_suggest_aw_no
1594: WHERE REQUISITION_HEADER_ID = p_header_id;
1595:
1596: x_return_status := FND_API.G_RET_STS_SUCCESS;
1597: x_errorcode := '0';
1598: x_msg_count := '1';
1599: x_msg_data := 'SUCCESS';
1600:

Line 1603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1599: x_msg_data := 'SUCCESS';
1600:
1601: EXCEPTION
1602: WHEN OTHERS THEN
1603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1604: x_errorcode := '-2';
1605: x_msg_count := '1';
1606: x_msg_data := 'Exception in sourcing_info_req_XPD';
1607: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data );

Line 1661: x_return_status := FND_API.G_RET_STS_SUCCESS;

1657: l_msg_count NUMBER(6) := 0;
1658:
1659: BEGIN
1660:
1661: x_return_status := FND_API.G_RET_STS_SUCCESS;
1662: x_errorcode := '0';
1663: x_msg_count := '1';
1664: x_msg_data := 'SUCCESS';
1665:

Line 1667: x_return_status := FND_API.G_RET_STS_ERROR;

1663: x_msg_count := '1';
1664: x_msg_data := 'SUCCESS';
1665:
1666: IF p_set_aside_stat = 'UNRESTRICTED' AND To_Number(Nvl(p_set_aside_perc,0)) > 0 THEN
1667: x_return_status := FND_API.G_RET_STS_ERROR;
1668: x_errorcode := '-1';
1669: l_msg_count := l_msg_count + 1;
1670: x_msg_data := 'The set aside percentage does not apply on an unrestricted action.';
1671: fnd_message.set_name(d_appln_short_name, 'PO_NO_PER_UNRES_ACTION');

Line 1675: x_return_status := FND_API.G_RET_STS_ERROR;

1671: fnd_message.set_name(d_appln_short_name, 'PO_NO_PER_UNRES_ACTION');
1672: fnd_msg_pub.ADD;
1673: END IF ;
1674: IF p_set_aside_stat = 'SET_ASIDE' AND To_Number(Nvl(p_set_aside_perc,0)) <= 0 THEN
1675: x_return_status := FND_API.G_RET_STS_ERROR;
1676: x_errorcode := '-1';
1677: l_msg_count := l_msg_count + 1;
1678: x_msg_data := 'The Set Aside Percentage must contain a value greater than 0, when the Set Aside Status is ''Set Aside''.';
1679: fnd_message.set_name(d_appln_short_name, 'PO_SET_ASIDE_PER_POSITIVE');

Line 1683: x_return_status := FND_API.G_RET_STS_ERROR;

1679: fnd_message.set_name(d_appln_short_name, 'PO_SET_ASIDE_PER_POSITIVE');
1680: fnd_msg_pub.ADD;
1681: END IF;
1682: IF p_set_aside_stat = 'SET_ASIDE' AND p_set_aside_type IS null THEN
1683: x_return_status := FND_API.G_RET_STS_ERROR;
1684: x_errorcode := '-1';
1685: l_msg_count := l_msg_count + 1;
1686: x_msg_data := 'When the Set Aside Status is ''Set Aside'', you must select a value for the set aside type.';
1687: fnd_message.set_name(d_appln_short_name,'PO_SET_ASIDE_SELECT_TYPE');

Line 1696: x_return_status := FND_API.G_RET_STS_ERROR;

1692: --, this validation should be carried on only for Base
1693: --Documents, since it is a read only field in Modifications
1694: IF p_set_aside_stat = 'SET_ASIDE' AND p_set_aside_type = 'SMALL_BUSINESS'
1695: AND p_draft_id = -1 THEN
1696: x_return_status := FND_API.G_RET_STS_ERROR;
1697: x_errorcode := '-1';
1698: l_msg_count := l_msg_count + 1;
1699: x_msg_data := 'The value ''Small Business'' for Set-Aside is not valid for new Awards/ IDVs.';
1700: fnd_message.set_name(d_appln_short_name,'PO_SMALL_BUSNS_INVALID');

Line 1705: x_return_status := FND_API.G_RET_STS_ERROR;

1701: fnd_msg_pub.ADD;
1702: END IF;
1703:
1704: IF p_set_aside_stat = 'SET_ASIDE' AND p_naics IS null THEN
1705: x_return_status := FND_API.G_RET_STS_ERROR;
1706: x_errorcode := '-1';
1707: l_msg_count := l_msg_count + 1;
1708: x_msg_data := 'When the Set Aside Status is ''Set Aside'' you must select a value for the NAICS ';
1709: fnd_message.set_name(d_appln_short_name, 'PO_SET_ASIDE_NAICS');

Line 1713: x_return_status := FND_API.G_RET_STS_ERROR;

1709: fnd_message.set_name(d_appln_short_name, 'PO_SET_ASIDE_NAICS');
1710: fnd_msg_pub.ADD;
1711: END IF;
1712: IF p_set_aside_stat = 'UNRESTRICTED' AND p_size_stand IS NOT null THEN
1713: x_return_status := FND_API.G_RET_STS_ERROR;
1714: x_errorcode := '-1';
1715: l_msg_count := l_msg_count + 1;
1716: x_msg_data := 'The size standard does not apply on an unrestricted action.';
1717: fnd_message.set_name(d_appln_short_name, 'PO_NO_SIZE_UNRES_ACTION');

Line 1721: x_return_status := FND_API.G_RET_STS_ERROR;

1717: fnd_message.set_name(d_appln_short_name, 'PO_NO_SIZE_UNRES_ACTION');
1718: fnd_msg_pub.ADD;
1719: END IF;
1720: IF p_set_aside_stat = 'UNRESTRICTED' AND p_naics IS NOT null THEN
1721: x_return_status := FND_API.G_RET_STS_ERROR;
1722: x_errorcode := '-1';
1723: l_msg_count := l_msg_count + 1;
1724: x_msg_data := 'The NAICS designation does not apply on an unrestricted action.';
1725: fnd_message.set_name(d_appln_short_name, 'PO_NO_NAICS_UNRES_ACTION');

Line 1729: x_return_status := FND_API.G_RET_STS_ERROR;

1725: fnd_message.set_name(d_appln_short_name, 'PO_NO_NAICS_UNRES_ACTION');
1726: fnd_msg_pub.ADD;
1727: END IF;
1728: IF p_set_aside_stat = 'UNRESTRICTED' AND p_set_aside_type IS NOT null THEN
1729: x_return_status := FND_API.G_RET_STS_ERROR;
1730: x_errorcode := '-1';
1731: l_msg_count := l_msg_count + 1;
1732: x_msg_data := 'The set aside type does not apply on an unrestricted action.';
1733: fnd_message.set_name(d_appln_short_name, 'PO_NO_ASIDETYPE_UNRES_ACTION');

Line 1742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1738: x_msg_count := l_msg_count;
1739: END IF ;
1740: EXCEPTION
1741: WHEN OTHERS THEN
1742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1743: x_errorcode := '-2';
1744: x_msg_count := '1';
1745: x_msg_data := 'Exception in competitive_info_XV';
1746: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data );

Line 1794: x_return_status := FND_API.G_RET_STS_ERROR;

1790: IF p_set_aside_stat = 'SET_ASIDE' THEN
1791: p_set_aside_type := 'SMALL_BUSINESS';
1792: END IF;
1793: ELSE
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: x_errorcode := '-1';
1796: x_msg_count := '1';
1797: x_msg_data := 'LOV Event is not from set_aside ';
1798: END IF;

Line 1800: x_return_status := FND_API.G_RET_STS_SUCCESS;

1796: x_msg_count := '1';
1797: x_msg_data := 'LOV Event is not from set_aside ';
1798: END IF;
1799:
1800: x_return_status := FND_API.G_RET_STS_SUCCESS;
1801: x_errorcode := '0';
1802: x_msg_count := '1';
1803: x_msg_data := 'SUCCESS';
1804:

Line 1807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1803: x_msg_data := 'SUCCESS';
1804:
1805: EXCEPTION
1806: WHEN OTHERS THEN
1807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1808: x_errorcode := '-2';
1809: x_msg_count := '1';
1810: x_msg_data := 'Exception in competitive_info_XLE';
1811: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data );

Line 2438: x_return_status := FND_API.G_RET_STS_SUCCESS;

2434: PO_LOG.proc_begin(d_module, 'p_ccr_reg_idictr', p_ccr_reg_idictr);
2435:
2436: END IF;
2437:
2438: x_return_status := FND_API.G_RET_STS_SUCCESS;
2439: x_errorcode := '0';
2440: x_msg_count := '1';
2441: x_msg_data := 'SUCCESS';
2442:

Line 2444: x_return_status := FND_API.G_RET_STS_ERROR;

2440: x_msg_count := '1';
2441: x_msg_data := 'SUCCESS';
2442:
2443: IF p_ccr_reg_idictr ='No' AND p_ccr_exp_reason IS NULL THEN
2444: x_return_status := FND_API.G_RET_STS_ERROR;
2445: x_errorcode := '-1';
2446: l_msg_count := l_msg_count + 1;
2447: x_msg_data := 'A CCR Exception Reason must be entered when the Vendor is not registered within CCR.';
2448: fnd_message.set_name(d_appln_short_name, 'PO_VEN_NOT_REG_CCR_EXC_REASON');

Line 2453: x_return_status := FND_API.G_RET_STS_ERROR;

2449: fnd_msg_pub.ADD;
2450: END IF ;
2451: -- rather than checking for 'Inactive' status, we must check for 'Expired' status.
2452: IF p_ccr_reg_status ='Expired' AND p_ccr_exp_reason IS NULL THEN
2453: x_return_status := FND_API.G_RET_STS_ERROR;
2454: x_errorcode := '-1';
2455: l_msg_count := l_msg_count + 1;
2456: x_msg_data := 'A CCR Exception Reason must be provided when the vendors CCR registration has expired.';
2457: fnd_message.set_name(d_appln_short_name, 'PO_REG_EXP_CCR_EXC_REASON');

Line 2461: x_return_status := FND_API.G_RET_STS_ERROR;

2457: fnd_message.set_name(d_appln_short_name, 'PO_REG_EXP_CCR_EXC_REASON');
2458: fnd_msg_pub.ADD ;
2459: END IF ;
2460: IF p_eft_indctr = 'N' AND p_eft_exc_resn IS NULL THEN
2461: x_return_status := FND_API.G_RET_STS_ERROR;
2462: x_errorcode := '-1';
2463: l_msg_count := l_msg_count + 1;
2464: x_msg_data := 'When EFT does not apply, an EFT exclusion reason must be selected.';
2465: fnd_message.set_name(d_appln_short_name, 'PO_NO_EFT_REASON_SELECTED');

Line 2475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2471: END IF ;
2472:
2473: EXCEPTION
2474: WHEN OTHERS THEN
2475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2476: x_errorcode := '-2';
2477: x_msg_count := '1';
2478: x_msg_data := 'Exception in addresses_XSC';
2479: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data||': '||SQLERRM );

Line 2597: x_return_status := FND_API.G_RET_STS_SUCCESS;

2593: WHEN OTHERS THEN
2594: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data||': '||SQLERRM );
2595: END ;
2596:
2597: x_return_status := FND_API.G_RET_STS_SUCCESS;
2598: x_errorcode := '0';
2599: x_msg_count := '1';
2600: x_msg_data := 'SUCCESS';
2601:

Line 2604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2600: x_msg_data := 'SUCCESS';
2601:
2602: EXCEPTION
2603: WHEN OTHERS THEN
2604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2605: x_errorcode := '-2';
2606: x_msg_count := '1';
2607: x_msg_data := 'Exception in supplier_details_XLE';
2608: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data||': '||SQLERRM );

Line 2938: x_return_status := FND_API.G_RET_STS_SUCCESS;

2934: WHEN OTHERS THEN
2935: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data||': '||SQLERRM );
2936: END ;
2937:
2938: x_return_status := FND_API.G_RET_STS_SUCCESS;
2939: x_errorcode := '0';
2940: x_msg_count := '1';
2941: x_msg_data := 'SUCCESS';
2942:

Line 2945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2941: x_msg_data := 'SUCCESS';
2942:
2943: EXCEPTION
2944: WHEN OTHERS THEN
2945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2946: x_errorcode := '-2';
2947: x_msg_count := '1';
2948: x_msg_data := 'Exception in supplier_details_XRD';
2949: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data||': '||SQLERRM );

Line 3061: x_return_status := FND_API.G_RET_STS_SUCCESS;

3057: );
3058:
3059:
3060:
3061: x_return_status := FND_API.G_RET_STS_SUCCESS;
3062: x_errorcode := '0';
3063: x_msg_count := '1';
3064: x_msg_data := 'SUCCESS';
3065: END IF;

Line 3167: x_return_status := FND_API.G_RET_STS_SUCCESS;

3163: AND DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', FCL3.LANGUAGE) = DECODE(FCL3.LOOKUP_CODE, NULL, ''1'', USERENV(''LANG''))';
3164:
3165: EXECUTE IMMEDIATE l_ship_addr_xml_sql INTO p_hidd_ship_addr USING l_ship_to_loc_id;
3166:
3167: x_return_status := FND_API.G_RET_STS_SUCCESS;
3168: x_errorcode := '0';
3169: x_msg_count := '1';
3170: x_msg_data := 'SUCCESS';
3171:

Line 3176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3172: EXCEPTION
3173: WHEN No_Data_Found THEN
3174: null;
3175: WHEN OTHERS THEN
3176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3177: x_errorcode := '-2';
3178: x_msg_count := '1';
3179: x_msg_data := 'Exception in po_ship_info_XRD';
3180: END po_ship_info_XRD;

Line 3287: x_return_status := FND_API.G_RET_STS_SUCCESS;

3283: ,p_accp_addressdetails
3284: ,l_source
3285: );
3286:
3287: x_return_status := FND_API.G_RET_STS_SUCCESS;
3288: x_errorcode := '0';
3289: x_msg_count := '1';
3290: x_msg_data := 'SUCCESS';
3291:

Line 3314: x_return_status := FND_API.G_RET_STS_SUCCESS;

3310: ,p_accp_addressdetails
3311: ,l_source
3312: );
3313:
3314: x_return_status := FND_API.G_RET_STS_SUCCESS;
3315: x_errorcode := '0';
3316: x_msg_count := '1';
3317: x_msg_data := 'SUCCESS';
3318:

Line 3341: x_return_status := FND_API.G_RET_STS_SUCCESS;

3337: ,p_accp_addressdetails
3338: ,l_source
3339: );
3340:
3341: x_return_status := FND_API.G_RET_STS_SUCCESS;
3342: x_errorcode := '0';
3343: x_msg_count := '1';
3344: x_msg_data := 'SUCCESS';
3345:

Line 3368: x_return_status := FND_API.G_RET_STS_SUCCESS;

3364: ,p_accp_addressdetails
3365: ,l_source
3366: );
3367:
3368: x_return_status := FND_API.G_RET_STS_SUCCESS;
3369: x_errorcode := '0';
3370: x_msg_count := '1';
3371: x_msg_data := 'SUCCESS';
3372: END IF;

Line 3376: x_return_status := FND_API.G_RET_STS_ERROR;

3372: END IF;
3373:
3374: ELSE
3375:
3376: x_return_status := FND_API.G_RET_STS_ERROR;
3377: x_errorcode := '-1';
3378: x_msg_count := '1';
3379: x_msg_data := 'LOV Event is not from LOCATION/ADDRESS_CODE';
3380:

Line 3385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3381: END IF;
3382:
3383: EXCEPTION
3384: WHEN OTHERS THEN
3385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3386: x_errorcode := '-2';
3387: x_msg_count := '1';
3388: x_msg_data := 'Exception in addresses_XLE';
3389:

Line 3595: x_return_status := FND_API.G_RET_STS_SUCCESS;

3591: l_msg_count number :=0;
3592: l_line_obli_type VARCHAR2(30) := NULL;
3593: l_mipr_type VARCHAR2(15) := NULL;
3594: BEGIN
3595: x_return_status := FND_API.G_RET_STS_SUCCESS;
3596: x_errorcode := '0';
3597: x_msg_count := '1';
3598: x_msg_data := 'SUCCESS';
3599:

Line 3609: x_return_status := FND_API.G_RET_STS_ERROR;

3605: PO_LOG.proc_begin(d_module, 'p_remarks', p_remarks);
3606: END IF;
3607:
3608: IF p_funds_info IS NOT NULL AND p_amount IS NULL THEN
3609: x_return_status := FND_API.G_RET_STS_ERROR;
3610: x_errorcode := '-1';
3611: l_msg_count := l_msg_count + 1;
3612: x_msg_count := to_char( l_msg_count) ;
3613: x_msg_data := 'Enter a value for Amount if you have selected a value in Funds Information.' ;

Line 3620: x_return_status := FND_API.G_RET_STS_ERROR;

3616:
3617: END IF;
3618:
3619: IF (p_acceptance_status = 'CHANGE' OR p_acceptance_status = 'REJECT') AND p_remarks IS NULL THEN
3620: x_return_status := FND_API.G_RET_STS_ERROR;
3621: x_errorcode := '-1';
3622: l_msg_count := l_msg_count + 1;
3623: x_msg_count := to_char( l_msg_count) ;
3624: x_msg_data := 'Enter the remarks if MIPR Acceptance Status is Rejected with changes. ' ;

Line 3636: x_return_status := FND_API.G_RET_STS_ERROR;

3632: FROM po_requisition_lines_all
3633: WHERE requisition_header_id = p_header_id AND ROWNUM = 1;
3634:
3635: IF l_line_obli_type = 'NONE' THEN
3636: x_return_status := FND_API.G_RET_STS_ERROR;
3637: x_errorcode := '-1';
3638: l_msg_count := l_msg_count + 1;
3639: x_msg_count := to_char( l_msg_count) ;
3640: x_msg_data := 'You have entered MIPR Obligation Type as Both. Please specify Obligation Type for each Line in Lines page.' ;

Line 3652: x_return_status := FND_API.G_RET_STS_ERROR;

3648: WHERE requisition_header_id = p_header_id AND ROWNUM = 1;
3649:
3650: IF l_mipr_type = 'MIPR_OTHERS' THEN
3651: IF p_acceptance_status IS NULL THEN
3652: x_return_status := FND_API.G_RET_STS_ERROR;
3653: x_errorcode := '-1';
3654: l_msg_count := l_msg_count + 1;
3655: x_msg_count := to_char( l_msg_count) ;
3656: x_msg_data := 'MIPR Acceptance Status cannot be Blank' ;

Line 3663: x_return_status := FND_API.G_RET_STS_ERROR;

3659:
3660: END IF;
3661:
3662: IF p_obligation_type IS NULL THEN
3663: x_return_status := FND_API.G_RET_STS_ERROR;
3664: x_errorcode := '-1';
3665: l_msg_count := l_msg_count + 1;
3666: x_msg_count := to_char( l_msg_count) ;
3667: x_msg_data := 'MIPR Obligation Type cannot be Blank' ;

Line 3674: x_return_status := FND_API.G_RET_STS_ERROR;

3670:
3671: END IF;
3672:
3673: IF p_auth_officer IS NULL THEN
3674: x_return_status := FND_API.G_RET_STS_ERROR;
3675: x_errorcode := '-1';
3676: l_msg_count := l_msg_count + 1;
3677: x_msg_count := to_char( l_msg_count) ;
3678: x_msg_data := 'MIPR Authorizing Officer cannot be Blank' ;

Line 3693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3689: END IF;
3690:
3691: EXCEPTION
3692: WHEN OTHERS THEN
3693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3694: x_errorcode := '-2';
3695: x_msg_count := '1';
3696: x_msg_data := 'Exception in pr_mipr_acc_info_xsc';
3697: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data||': '||SQLERRM );

Line 3768: x_return_status := FND_API.G_RET_STS_SUCCESS;

3764:
3765: payment_no := l_payment_no;
3766: payment_date := l_payment_date;
3767:
3768: x_return_status := FND_API.G_RET_STS_SUCCESS;
3769: x_errorcode := '0';
3770: x_msg_count := '1';
3771: x_msg_data := 'SUCCESS';
3772: ELSE

Line 3773: x_return_status := FND_API.G_RET_STS_ERROR;

3769: x_errorcode := '0';
3770: x_msg_count := '1';
3771: x_msg_data := 'SUCCESS';
3772: ELSE
3773: x_return_status := FND_API.G_RET_STS_ERROR;
3774: x_errorcode := '-1';
3775: x_msg_count := '1';
3776: x_msg_data := 'Closeout details not defaulted';
3777: END IF;

Line 3782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3778: EXCEPTION
3779: WHEN OTHERS THEN
3780: payment_no := null;
3781: payment_date := null;
3782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3783: x_errorcode := '-2';
3784: x_msg_count := '1';
3785: x_msg_data := 'Exception in closeout_XD';
3786: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data );

Line 3813: x_return_status := FND_API.G_RET_STS_SUCCESS;

3809: l_is_amendment VARCHAR2(1);
3810:
3811: BEGIN
3812:
3813: x_return_status := FND_API.G_RET_STS_SUCCESS;
3814: x_errorcode := '0';
3815: x_msg_count := '1';
3816: x_msg_data := 'SUCCESS';
3817:

Line 3829: x_return_status := FND_API.G_RET_STS_ERROR;

3825: l_is_amendment := 'N';
3826: END;
3827:
3828: IF p_set_aside_stat = 'UNRESTRICTED' AND To_Number(Nvl(p_set_aside_perc,0)) > 0 THEN
3829: x_return_status := FND_API.G_RET_STS_ERROR;
3830: x_errorcode := '-1';
3831: l_msg_count := l_msg_count + 1;
3832: x_msg_data := 'The set aside percentage does not apply on an unrestricted action.';
3833: fnd_message.set_name(d_appln_short_name, 'PO_NO_PER_UNRES_ACTION');

Line 3837: x_return_status := FND_API.G_RET_STS_ERROR;

3833: fnd_message.set_name(d_appln_short_name, 'PO_NO_PER_UNRES_ACTION');
3834: fnd_msg_pub.ADD;
3835: END IF ;
3836: IF p_set_aside_stat = 'SET_ASIDE' AND To_Number(Nvl(p_set_aside_perc,0)) <= 0 THEN
3837: x_return_status := FND_API.G_RET_STS_ERROR;
3838: x_errorcode := '-1';
3839: l_msg_count := l_msg_count + 1;
3840: x_msg_data := 'The Set Aside Percentage must contain a value greater than 0, when the Set Aside Status is ''Set Aside''.';
3841: fnd_message.set_name(d_appln_short_name, 'PO_SET_ASIDE_PER_POSITIVE');

Line 3845: x_return_status := FND_API.G_RET_STS_ERROR;

3841: fnd_message.set_name(d_appln_short_name, 'PO_SET_ASIDE_PER_POSITIVE');
3842: fnd_msg_pub.ADD;
3843: END IF;
3844: IF p_set_aside_stat = 'SET_ASIDE' AND p_set_aside_type IS null THEN
3845: x_return_status := FND_API.G_RET_STS_ERROR;
3846: x_errorcode := '-1';
3847: l_msg_count := l_msg_count + 1;
3848: x_msg_data := 'When the Set Aside Status is ''Set Aside'', you must select a value for the set aside type.';
3849: fnd_message.set_name(d_appln_short_name,'PO_SET_ASIDE_SELECT_TYPE');

Line 3856: x_return_status := FND_API.G_RET_STS_ERROR;

3852:
3853:
3854: --this validation should be carried on only for Base Documents/Sols, since it is a read only field in Mods/Amendmenst
3855: IF p_set_aside_stat = 'SET_ASIDE' AND p_set_aside_type = 'SMALL_BUSINESS' AND l_is_amendment = 'N' THEN
3856: x_return_status := FND_API.G_RET_STS_ERROR;
3857: x_errorcode := '-1';
3858: l_msg_count := l_msg_count + 1;
3859: x_msg_data := 'The value ''Small Business'' for Set-Aside is not valid for new Awards/ IDVs.';
3860: fnd_message.set_name(d_appln_short_name,'PO_SMALL_BUSNS_INVALID');

Line 3865: x_return_status := FND_API.G_RET_STS_ERROR;

3861: fnd_msg_pub.ADD;
3862: END IF;
3863:
3864: IF p_set_aside_stat = 'SET_ASIDE' AND p_naics IS null THEN
3865: x_return_status := FND_API.G_RET_STS_ERROR;
3866: x_errorcode := '-1';
3867: l_msg_count := l_msg_count + 1;
3868: x_msg_data := 'When the Set Aside Status is ''Set Aside'' you must select a value for the NAICS ';
3869: fnd_message.set_name(d_appln_short_name, 'PO_SET_ASIDE_NAICS');

Line 3873: x_return_status := FND_API.G_RET_STS_ERROR;

3869: fnd_message.set_name(d_appln_short_name, 'PO_SET_ASIDE_NAICS');
3870: fnd_msg_pub.ADD;
3871: END IF;
3872: IF p_set_aside_stat = 'UNRESTRICTED' AND p_size_stand IS NOT null THEN
3873: x_return_status := FND_API.G_RET_STS_ERROR;
3874: x_errorcode := '-1';
3875: l_msg_count := l_msg_count + 1;
3876: x_msg_data := 'The size standard does not apply on an unrestricted action.';
3877: fnd_message.set_name(d_appln_short_name, 'PO_NO_SIZE_UNRES_ACTION');

Line 3881: x_return_status := FND_API.G_RET_STS_ERROR;

3877: fnd_message.set_name(d_appln_short_name, 'PO_NO_SIZE_UNRES_ACTION');
3878: fnd_msg_pub.ADD;
3879: END IF;
3880: IF p_set_aside_stat = 'UNRESTRICTED' AND p_naics IS NOT null THEN
3881: x_return_status := FND_API.G_RET_STS_ERROR;
3882: x_errorcode := '-1';
3883: l_msg_count := l_msg_count + 1;
3884: x_msg_data := 'The NAICS designation does not apply on an unrestricted action.';
3885: fnd_message.set_name(d_appln_short_name, 'PO_NO_NAICS_UNRES_ACTION');

Line 3889: x_return_status := FND_API.G_RET_STS_ERROR;

3885: fnd_message.set_name(d_appln_short_name, 'PO_NO_NAICS_UNRES_ACTION');
3886: fnd_msg_pub.ADD;
3887: END IF;
3888: IF p_set_aside_stat = 'UNRESTRICTED' AND p_set_aside_type IS NOT null THEN
3889: x_return_status := FND_API.G_RET_STS_ERROR;
3890: x_errorcode := '-1';
3891: l_msg_count := l_msg_count + 1;
3892: x_msg_data := 'The set aside type does not apply on an unrestricted action.';
3893: fnd_message.set_name(d_appln_short_name, 'PO_NO_ASIDETYPE_UNRES_ACTION');

Line 3902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3898: x_msg_count := l_msg_count;
3899: END IF ;
3900: EXCEPTION
3901: WHEN OTHERS THEN
3902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3903: x_errorcode := '-2';
3904: x_msg_count := '1';
3905: x_msg_data := 'Exception in pon_competitive_info_XV';
3906: fnd_msg_pub.Add_Exc_Msg ( d_pkg_name, d_proc_name, x_msg_data );