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.CSD_REPAIRS_PVT dependencies on JTF_PLSQL_API

Line 300: p_validation_mode => Jtf_Plsql_Api.G_CREATE,

296: --
297: Validate_Repairs
298: (
299: P_Api_Version_Number => 1.0,
300: p_validation_mode => Jtf_Plsql_Api.G_CREATE,
301: p_repair_line_id => p_repair_line_id,
302: P_REPLN_Rec => l_REPLN_Rec,
303: x_return_status => x_return_status,
304: x_msg_count => x_msg_count,

Line 710: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

706: );
707:
708: EXCEPTION
709: WHEN Fnd_Api.G_EXC_ERROR THEN
710: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
711: ( P_API_NAME => L_API_NAME
712: ,P_PKG_NAME => G_PKG_NAME
713: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
714: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 714: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

710: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
711: ( P_API_NAME => L_API_NAME
712: ,P_PKG_NAME => G_PKG_NAME
713: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
714: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
715: ,X_MSG_COUNT => X_MSG_COUNT
716: ,X_MSG_DATA => X_MSG_DATA
717: ,X_RETURN_STATUS => X_RETURN_STATUS);
718:

Line 721: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

717: ,X_RETURN_STATUS => X_RETURN_STATUS);
718:
719: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
720: ROLLBACK TO CREATE_REPAIR_ORDER_PVT;
721: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
722: (P_API_NAME => L_API_NAME
723: ,P_PKG_NAME => G_PKG_NAME
724: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
725: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 725: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

721: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
722: (P_API_NAME => L_API_NAME
723: ,P_PKG_NAME => G_PKG_NAME
724: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
725: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
726: ,X_MSG_COUNT => X_MSG_COUNT
727: ,X_MSG_DATA => X_MSG_DATA
728: ,X_RETURN_STATUS => X_RETURN_STATUS);
729:

Line 731: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

727: ,X_MSG_DATA => X_MSG_DATA
728: ,X_RETURN_STATUS => X_RETURN_STATUS);
729:
730: WHEN OTHERS THEN
731: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
732: (P_API_NAME => L_API_NAME
733: ,P_PKG_NAME => G_PKG_NAME
734: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
735: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 734: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS

730: WHEN OTHERS THEN
731: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
732: (P_API_NAME => L_API_NAME
733: ,P_PKG_NAME => G_PKG_NAME
734: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
735: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
736: ,X_MSG_COUNT => X_MSG_COUNT
737: ,X_MSG_DATA => X_MSG_DATA
738: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 735: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

731: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
732: (P_API_NAME => L_API_NAME
733: ,P_PKG_NAME => G_PKG_NAME
734: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
735: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
736: ,X_MSG_COUNT => X_MSG_COUNT
737: ,X_MSG_DATA => X_MSG_DATA
738: ,X_RETURN_STATUS => X_RETURN_STATUS);
739:

Line 1051: p_validation_mode => Jtf_Plsql_Api.G_UPDATE,

1047:
1048: Validate_Repairs
1049: (
1050: P_Api_Version_Number => 1.0,
1051: p_validation_mode => Jtf_Plsql_Api.G_UPDATE,
1052: p_repair_line_id => p_repair_line_id,
1053: P_REPLN_Rec => P_REPLN_Rec,
1054: P_OLD_REPLN_Rec => l_OLD_REPLN_Rec,
1055: x_return_status => x_return_status,

Line 1214: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

1210: );
1211:
1212: EXCEPTION
1213: WHEN Fnd_Api.G_EXC_ERROR THEN
1214: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1215: (P_API_NAME => L_API_NAME
1216: ,P_PKG_NAME => G_PKG_NAME
1217: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
1218: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 1218: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

1214: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1215: (P_API_NAME => L_API_NAME
1216: ,P_PKG_NAME => G_PKG_NAME
1217: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
1218: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1219: ,X_MSG_COUNT => X_MSG_COUNT
1220: ,X_MSG_DATA => X_MSG_DATA
1221: ,X_RETURN_STATUS => X_RETURN_STATUS);
1222:

Line 1224: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

1220: ,X_MSG_DATA => X_MSG_DATA
1221: ,X_RETURN_STATUS => X_RETURN_STATUS);
1222:
1223: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1224: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1225: (P_API_NAME => L_API_NAME
1226: ,P_PKG_NAME => G_PKG_NAME
1227: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
1228: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 1228: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

1224: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1225: (P_API_NAME => L_API_NAME
1226: ,P_PKG_NAME => G_PKG_NAME
1227: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
1228: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1229: ,X_MSG_COUNT => X_MSG_COUNT
1230: ,X_MSG_DATA => X_MSG_DATA
1231: ,X_RETURN_STATUS => X_RETURN_STATUS);
1232:

Line 1234: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

1230: ,X_MSG_DATA => X_MSG_DATA
1231: ,X_RETURN_STATUS => X_RETURN_STATUS);
1232:
1233: WHEN OTHERS THEN
1234: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1235: (P_API_NAME => L_API_NAME
1236: ,P_PKG_NAME => G_PKG_NAME
1237: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
1238: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 1237: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS

1233: WHEN OTHERS THEN
1234: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1235: (P_API_NAME => L_API_NAME
1236: ,P_PKG_NAME => G_PKG_NAME
1237: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
1238: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1239: ,X_MSG_COUNT => X_MSG_COUNT
1240: ,X_MSG_DATA => X_MSG_DATA
1241: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1238: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

1234: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1235: (P_API_NAME => L_API_NAME
1236: ,P_PKG_NAME => G_PKG_NAME
1237: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
1238: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1239: ,X_MSG_COUNT => X_MSG_COUNT
1240: ,X_MSG_DATA => X_MSG_DATA
1241: ,X_RETURN_STATUS => X_RETURN_STATUS);
1242:

Line 1300: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

1296: );
1297:
1298: EXCEPTION
1299: WHEN Fnd_Api.G_EXC_ERROR THEN
1300: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1301: (P_API_NAME => L_API_NAME
1302: ,P_PKG_NAME => G_PKG_NAME
1303: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
1304: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 1304: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

1300: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1301: (P_API_NAME => L_API_NAME
1302: ,P_PKG_NAME => G_PKG_NAME
1303: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
1304: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1305: ,X_MSG_COUNT => X_MSG_COUNT
1306: ,X_MSG_DATA => X_MSG_DATA
1307: ,X_RETURN_STATUS => X_RETURN_STATUS);
1308:

Line 1310: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

1306: ,X_MSG_DATA => X_MSG_DATA
1307: ,X_RETURN_STATUS => X_RETURN_STATUS);
1308:
1309: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1310: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1311: (P_API_NAME => L_API_NAME
1312: ,P_PKG_NAME => G_PKG_NAME
1313: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
1314: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 1314: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

1310: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1311: (P_API_NAME => L_API_NAME
1312: ,P_PKG_NAME => G_PKG_NAME
1313: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
1314: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1315: ,X_MSG_COUNT => X_MSG_COUNT
1316: ,X_MSG_DATA => X_MSG_DATA
1317: ,X_RETURN_STATUS => X_RETURN_STATUS);
1318:

Line 1320: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

1316: ,X_MSG_DATA => X_MSG_DATA
1317: ,X_RETURN_STATUS => X_RETURN_STATUS);
1318:
1319: WHEN OTHERS THEN
1320: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1321: (P_API_NAME => L_API_NAME
1322: ,P_PKG_NAME => G_PKG_NAME
1323: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
1324: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 1323: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS

1319: WHEN OTHERS THEN
1320: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1321: (P_API_NAME => L_API_NAME
1322: ,P_PKG_NAME => G_PKG_NAME
1323: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
1324: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1325: ,X_MSG_COUNT => X_MSG_COUNT
1326: ,X_MSG_DATA => X_MSG_DATA
1327: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1324: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

1320: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1321: (P_API_NAME => L_API_NAME
1322: ,P_PKG_NAME => G_PKG_NAME
1323: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
1324: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1325: ,X_MSG_COUNT => X_MSG_COUNT
1326: ,X_MSG_DATA => X_MSG_DATA
1327: ,X_RETURN_STATUS => X_RETURN_STATUS);
1328:

Line 1354: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

1350: BEGIN
1351:
1352: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1353:
1354: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1355: RETURN;
1356: END IF;
1357:
1358: IF p_repair_line_id = Fnd_Api.G_MISS_NUM

Line 1402: IF p_validation_mode = Jtf_Plsql_Api.G_CREATE

1398: BEGIN
1399:
1400: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1401:
1402: IF p_validation_mode = Jtf_Plsql_Api.G_CREATE
1403: AND (p_repair_number = Fnd_Api.G_MISS_CHAR
1404: OR p_repair_number IS NULL) THEN
1405: RETURN;
1406: END IF;

Line 1408: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

1404: OR p_repair_number IS NULL) THEN
1405: RETURN;
1406: END IF;
1407:
1408: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1409: IF p_repair_number IS NULL THEN
1410: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1411: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1412: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 1461: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

1457: BEGIN
1458:
1459: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1460:
1461: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1462: IF p_incident_id IS NULL THEN
1463: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1464: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1465: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 1517: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

1513: BEGIN
1514:
1515: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1516:
1517: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1518: IF p_inventory_item_id IS NULL THEN
1519: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1520: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1521: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 1591: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)

1587: BEGIN
1588:
1589: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1590:
1591: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)
1592: AND (p_customer_product_id = Fnd_Api.G_MISS_NUM
1593: OR p_customer_product_id IS NULL) THEN
1594: RETURN;
1595: END IF;

Line 1597: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)

1593: OR p_customer_product_id IS NULL) THEN
1594: RETURN;
1595: END IF;
1596:
1597: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)
1598: AND (p_customer_product_id = p_old_customer_product_id
1599: OR p_customer_product_id = Fnd_Api.G_MISS_NUM
1600: OR p_customer_product_id IS NULL) THEN
1601: RETURN;

Line 1655: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)

1651: BEGIN
1652:
1653: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1654:
1655: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)
1656: AND (p_customer_product_id = Fnd_Api.G_MISS_NUM
1657: OR p_customer_product_id IS NULL) THEN
1658: RETURN;
1659: END IF;

Line 1661: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)

1657: OR p_customer_product_id IS NULL) THEN
1658: RETURN;
1659: END IF;
1660:
1661: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)
1662: AND (p_customer_product_id = p_old_customer_product_id
1663: OR p_customer_product_id = Fnd_Api.G_MISS_NUM
1664: OR p_customer_product_id IS NULL) THEN
1665: RETURN;

Line 1714: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

1710: BEGIN
1711:
1712: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1713:
1714: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1715: IF p_unit_of_measure IS NULL THEN
1716: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1717: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1718: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 1769: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

1765: BEGIN
1766:
1767: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1768:
1769: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1770: IF p_repair_type_id IS NULL THEN
1771: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1772: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1773: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 1853: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)

1849: l_resource_group := p_resource_group;
1850: end if;
1851: -- end swai: bug 7565999
1852:
1853: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)
1854: AND (p_resource_id = Fnd_Api.G_MISS_NUM
1855: OR p_resource_id IS NULL) THEN
1856: RETURN;
1857: END IF;

Line 1859: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)

1855: OR p_resource_id IS NULL) THEN
1856: RETURN;
1857: END IF;
1858:
1859: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)
1860: AND (p_resource_id = p_old_resource_id
1861: OR p_resource_id = Fnd_Api.G_MISS_NUM
1862: OR p_resource_id IS NULL) THEN
1863: RETURN;

Line 1911: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)

1907: BEGIN
1908:
1909: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1910:
1911: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)
1912: AND (p_resource_group = Fnd_Api.G_MISS_NUM
1913: OR p_resource_group IS NULL) THEN
1914: RETURN;
1915: END IF;

Line 1917: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)

1913: OR p_resource_group IS NULL) THEN
1914: RETURN;
1915: END IF;
1916:
1917: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)
1918: AND (p_resource_group = p_old_resource_group
1919: OR p_resource_group = Fnd_Api.G_MISS_NUM
1920: OR p_resource_group IS NULL) THEN
1921: RETURN;

Line 2015: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

2011: BEGIN
2012:
2013: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2014:
2015: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
2016: IF p_status IS NULL THEN
2017: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2018: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2019: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 2071: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

2067: BEGIN
2068:
2069: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2070:
2071: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
2072: IF p_approval_required_flag IS NULL THEN
2073: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2074: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2075: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 2135: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)

2131: BEGIN
2132:
2133: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2134:
2135: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)
2136: AND (p_approval_status = Fnd_Api.G_MISS_CHAR
2137: OR p_approval_status IS NULL) THEN
2138: RETURN;
2139: END IF;

Line 2141: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)

2137: OR p_approval_status IS NULL) THEN
2138: RETURN;
2139: END IF;
2140:
2141: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)
2142: AND (p_approval_status = p_old_approval_status
2143: OR p_approval_status = Fnd_Api.G_MISS_CHAR
2144: OR p_approval_status IS NULL) THEN
2145: RETURN;

Line 2197: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)

2193: BEGIN
2194:
2195: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2196:
2197: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)
2198: AND (p_promise_date = Fnd_Api.G_MISS_DATE
2199: OR p_promise_date IS NULL) THEN
2200: RETURN;
2201: END IF;

Line 2203: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)

2199: OR p_promise_date IS NULL) THEN
2200: RETURN;
2201: END IF;
2202:
2203: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)
2204: AND (p_promise_date = p_old_promise_date
2205: OR p_promise_date = Fnd_Api.G_MISS_DATE
2206: OR p_promise_date IS NULL) THEN
2207: RETURN;

Line 2241: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

2237: BEGIN
2238:
2239: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2240:
2241: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
2242: IF p_quantity IS NULL THEN
2243: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2244: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2245: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 2294: if p_validation_mode = JTF_PLSQL_API.G_CREATE then

2290: or p_quantity_in_wip is null then
2291: return;
2292: end if;
2293:
2294: if p_validation_mode = JTF_PLSQL_API.G_CREATE then
2295: if p_quantity < p_quantity_in_wip then
2296: l_valid := 'N';
2297: end if;
2298: elsif p_validation_mode = JTF_PLSQL_API.G_UPDATE then

Line 2298: elsif p_validation_mode = JTF_PLSQL_API.G_UPDATE then

2294: if p_validation_mode = JTF_PLSQL_API.G_CREATE then
2295: if p_quantity < p_quantity_in_wip then
2296: l_valid := 'N';
2297: end if;
2298: elsif p_validation_mode = JTF_PLSQL_API.G_UPDATE then
2299: if p_quantity = FND_API.G_MISS_NUM
2300: or p_quantity is null then
2301: if p_old_quantity < p_quantity_in_wip then
2302: l_valid := 'N';

Line 2416: IF p_validation_mode = Jtf_Plsql_Api.G_CREATE THEN

2412:
2413: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2414:
2415: -- travi fix
2416: IF p_validation_mode = Jtf_Plsql_Api.G_CREATE THEN
2417: IF (p_ro_group_id IS NULL) THEN
2418: IF (g_debug > 0 ) THEN
2419: Csd_Gen_Utility_Pvt.ADD('Create_Repair_Order group_id is null : Validate_RO_GROUP_ID');
2420: END IF;

Line 2428: ELSIF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

2424: END IF;
2425:
2426: RETURN;
2427: END IF;
2428: ELSIF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
2429: IF p_ro_group_id IS NULL THEN
2430: IF (g_debug > 0 ) THEN
2431: Csd_Gen_Utility_Pvt.ADD('Update_Repair_Order group_id is null : Validate_RO_GROUP_ID');
2432: END IF;

Line 2459: if p_validation_mode = JTF_PLSQL_API.G_UPDATE then

2455: END IF;
2456: END IF;
2457:
2458: /* old code
2459: if p_validation_mode = JTF_PLSQL_API.G_UPDATE then
2460: if p_ro_group_id is null then
2461: x_return_status := FND_API.G_RET_STS_ERROR;
2462: FND_MESSAGE.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2463: FND_MESSAGE.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 2525: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)

2521: BEGIN
2522:
2523: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2524:
2525: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)
2526: AND (p_ORIGINAL_SOURCE_REFERENCE = Fnd_Api.G_MISS_CHAR
2527: OR p_ORIGINAL_SOURCE_REFERENCE IS NULL) THEN
2528: RETURN;
2529: END IF;

Line 2825: p_validation_mode => Jtf_Plsql_Api.G_CREATE,

2821: (
2822: p_ORIGINAL_SOURCE_HEADER_ID => P_REPLN_Rec.ORIGINAL_SOURCE_HEADER_ID,
2823: p_ORIGINAL_SOURCE_LINE_ID => P_REPLN_Rec.ORIGINAL_SOURCE_LINE_ID,
2824: p_ORIGINAL_SOURCE_REFERENCE => P_REPLN_Rec.ORIGINAL_SOURCE_REFERENCE,
2825: p_validation_mode => Jtf_Plsql_Api.G_CREATE,
2826: x_return_status => x_return_status);
2827:
2828: -- Check return status from the above procedure call
2829: IF NOT (x_return_status = Fnd_Api.G_RET_STS_SUCCESS) THEN

Line 3192: IF p_validation_mode = Jtf_Plsql_Api.G_CREATE THEN

3188: -- bug#7242791, subhat (This FP also contains the fix provided in bug#7438725)
3189: -- the defaulting in the FND Flex API should happen only if the mode is
3190: -- create and profile CSD: Enable Flexfield Defaulting for Repair Orders Flexfield
3191: -- is set to Yes.
3192: IF p_validation_mode = Jtf_Plsql_Api.G_CREATE THEN
3193: if nvl(fnd_profile.value('CSD_RO_DFF_DEF'),'N') = 'Y' then
3194: l_valid_def_rec := Csd_Repairs_Util.Is_DescFlex_Valid
3195: (p_api_name => 'Create_Repair_Order',
3196: p_desc_flex_name => 'CSD_REPAIRS',

Line 3224: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

3220: END IF; -- End of Validation Level IF Block
3221: --
3222: EXCEPTION
3223: WHEN Fnd_Api.G_EXC_ERROR THEN
3224: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
3225: ( P_API_NAME => L_API_NAME
3226: ,P_PKG_NAME => G_PKG_NAME
3227: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
3228: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 3228: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

3224: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
3225: ( P_API_NAME => L_API_NAME
3226: ,P_PKG_NAME => G_PKG_NAME
3227: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
3228: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
3229: ,X_MSG_COUNT => X_MSG_COUNT
3230: ,X_MSG_DATA => X_MSG_DATA
3231: ,X_RETURN_STATUS => X_RETURN_STATUS);
3232:

Line 3234: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

3230: ,X_MSG_DATA => X_MSG_DATA
3231: ,X_RETURN_STATUS => X_RETURN_STATUS);
3232:
3233: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3234: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
3235: (P_API_NAME => L_API_NAME
3236: ,P_PKG_NAME => G_PKG_NAME
3237: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
3238: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 3238: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

3234: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
3235: (P_API_NAME => L_API_NAME
3236: ,P_PKG_NAME => G_PKG_NAME
3237: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
3238: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
3239: ,X_MSG_COUNT => X_MSG_COUNT
3240: ,X_MSG_DATA => X_MSG_DATA
3241: ,X_RETURN_STATUS => X_RETURN_STATUS);
3242:

Line 3244: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

3240: ,X_MSG_DATA => X_MSG_DATA
3241: ,X_RETURN_STATUS => X_RETURN_STATUS);
3242:
3243: WHEN OTHERS THEN
3244: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
3245: (P_API_NAME => L_API_NAME
3246: ,P_PKG_NAME => G_PKG_NAME
3247: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
3248: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 3247: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS

3243: WHEN OTHERS THEN
3244: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
3245: (P_API_NAME => L_API_NAME
3246: ,P_PKG_NAME => G_PKG_NAME
3247: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
3248: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
3249: ,X_MSG_COUNT => X_MSG_COUNT
3250: ,X_MSG_DATA => X_MSG_DATA
3251: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3248: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

3244: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
3245: (P_API_NAME => L_API_NAME
3246: ,P_PKG_NAME => G_PKG_NAME
3247: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
3248: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
3249: ,X_MSG_COUNT => X_MSG_COUNT
3250: ,X_MSG_DATA => X_MSG_DATA
3251: ,X_RETURN_STATUS => X_RETURN_STATUS);
3252: