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 273: p_validation_mode => Jtf_Plsql_Api.G_CREATE,

269: --
270: Validate_Repairs
271: (
272: P_Api_Version_Number => 1.0,
273: p_validation_mode => Jtf_Plsql_Api.G_CREATE,
274: p_repair_line_id => p_repair_line_id,
275: P_REPLN_Rec => l_REPLN_Rec,
276: x_return_status => x_return_status,
277: x_msg_count => x_msg_count,

Line 530: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

526: );
527:
528: EXCEPTION
529: WHEN Fnd_Api.G_EXC_ERROR THEN
530: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
531: ( P_API_NAME => L_API_NAME
532: ,P_PKG_NAME => G_PKG_NAME
533: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
534: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 534: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

530: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
531: ( P_API_NAME => L_API_NAME
532: ,P_PKG_NAME => G_PKG_NAME
533: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
534: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
535: ,X_MSG_COUNT => X_MSG_COUNT
536: ,X_MSG_DATA => X_MSG_DATA
537: ,X_RETURN_STATUS => X_RETURN_STATUS);
538:

Line 541: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

537: ,X_RETURN_STATUS => X_RETURN_STATUS);
538:
539: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
540: ROLLBACK TO CREATE_REPAIR_ORDER_PVT;
541: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
542: (P_API_NAME => L_API_NAME
543: ,P_PKG_NAME => G_PKG_NAME
544: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
545: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 545: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

541: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
542: (P_API_NAME => L_API_NAME
543: ,P_PKG_NAME => G_PKG_NAME
544: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
545: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
546: ,X_MSG_COUNT => X_MSG_COUNT
547: ,X_MSG_DATA => X_MSG_DATA
548: ,X_RETURN_STATUS => X_RETURN_STATUS);
549:

Line 551: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

547: ,X_MSG_DATA => X_MSG_DATA
548: ,X_RETURN_STATUS => X_RETURN_STATUS);
549:
550: WHEN OTHERS THEN
551: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
552: (P_API_NAME => L_API_NAME
553: ,P_PKG_NAME => G_PKG_NAME
554: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
555: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 554: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS

550: WHEN OTHERS THEN
551: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
552: (P_API_NAME => L_API_NAME
553: ,P_PKG_NAME => G_PKG_NAME
554: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
555: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
556: ,X_MSG_COUNT => X_MSG_COUNT
557: ,X_MSG_DATA => X_MSG_DATA
558: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 555: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

551: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
552: (P_API_NAME => L_API_NAME
553: ,P_PKG_NAME => G_PKG_NAME
554: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
555: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
556: ,X_MSG_COUNT => X_MSG_COUNT
557: ,X_MSG_DATA => X_MSG_DATA
558: ,X_RETURN_STATUS => X_RETURN_STATUS);
559:

Line 793: p_validation_mode => Jtf_Plsql_Api.G_UPDATE,

789:
790: Validate_Repairs
791: (
792: P_Api_Version_Number => 1.0,
793: p_validation_mode => Jtf_Plsql_Api.G_UPDATE,
794: p_repair_line_id => p_repair_line_id,
795: P_REPLN_Rec => P_REPLN_Rec,
796: P_OLD_REPLN_Rec => l_OLD_REPLN_Rec,
797: x_return_status => x_return_status,

Line 920: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

916: );
917:
918: EXCEPTION
919: WHEN Fnd_Api.G_EXC_ERROR THEN
920: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
921: (P_API_NAME => L_API_NAME
922: ,P_PKG_NAME => G_PKG_NAME
923: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
924: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 924: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

920: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
921: (P_API_NAME => L_API_NAME
922: ,P_PKG_NAME => G_PKG_NAME
923: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
924: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
925: ,X_MSG_COUNT => X_MSG_COUNT
926: ,X_MSG_DATA => X_MSG_DATA
927: ,X_RETURN_STATUS => X_RETURN_STATUS);
928:

Line 930: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

926: ,X_MSG_DATA => X_MSG_DATA
927: ,X_RETURN_STATUS => X_RETURN_STATUS);
928:
929: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
930: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
931: (P_API_NAME => L_API_NAME
932: ,P_PKG_NAME => G_PKG_NAME
933: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
934: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 934: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

930: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
931: (P_API_NAME => L_API_NAME
932: ,P_PKG_NAME => G_PKG_NAME
933: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
934: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
935: ,X_MSG_COUNT => X_MSG_COUNT
936: ,X_MSG_DATA => X_MSG_DATA
937: ,X_RETURN_STATUS => X_RETURN_STATUS);
938:

Line 940: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

936: ,X_MSG_DATA => X_MSG_DATA
937: ,X_RETURN_STATUS => X_RETURN_STATUS);
938:
939: WHEN OTHERS THEN
940: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
941: (P_API_NAME => L_API_NAME
942: ,P_PKG_NAME => G_PKG_NAME
943: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
944: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 943: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS

939: WHEN OTHERS THEN
940: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
941: (P_API_NAME => L_API_NAME
942: ,P_PKG_NAME => G_PKG_NAME
943: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
944: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
945: ,X_MSG_COUNT => X_MSG_COUNT
946: ,X_MSG_DATA => X_MSG_DATA
947: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 944: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

940: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
941: (P_API_NAME => L_API_NAME
942: ,P_PKG_NAME => G_PKG_NAME
943: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
944: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
945: ,X_MSG_COUNT => X_MSG_COUNT
946: ,X_MSG_DATA => X_MSG_DATA
947: ,X_RETURN_STATUS => X_RETURN_STATUS);
948:

Line 1006: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

1002: );
1003:
1004: EXCEPTION
1005: WHEN Fnd_Api.G_EXC_ERROR THEN
1006: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1007: (P_API_NAME => L_API_NAME
1008: ,P_PKG_NAME => G_PKG_NAME
1009: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
1010: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 1010: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

1006: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1007: (P_API_NAME => L_API_NAME
1008: ,P_PKG_NAME => G_PKG_NAME
1009: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
1010: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1011: ,X_MSG_COUNT => X_MSG_COUNT
1012: ,X_MSG_DATA => X_MSG_DATA
1013: ,X_RETURN_STATUS => X_RETURN_STATUS);
1014:

Line 1016: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

1012: ,X_MSG_DATA => X_MSG_DATA
1013: ,X_RETURN_STATUS => X_RETURN_STATUS);
1014:
1015: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1016: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1017: (P_API_NAME => L_API_NAME
1018: ,P_PKG_NAME => G_PKG_NAME
1019: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
1020: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 1020: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

1016: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1017: (P_API_NAME => L_API_NAME
1018: ,P_PKG_NAME => G_PKG_NAME
1019: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
1020: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1021: ,X_MSG_COUNT => X_MSG_COUNT
1022: ,X_MSG_DATA => X_MSG_DATA
1023: ,X_RETURN_STATUS => X_RETURN_STATUS);
1024:

Line 1026: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

1022: ,X_MSG_DATA => X_MSG_DATA
1023: ,X_RETURN_STATUS => X_RETURN_STATUS);
1024:
1025: WHEN OTHERS THEN
1026: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1027: (P_API_NAME => L_API_NAME
1028: ,P_PKG_NAME => G_PKG_NAME
1029: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
1030: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 1029: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS

1025: WHEN OTHERS THEN
1026: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1027: (P_API_NAME => L_API_NAME
1028: ,P_PKG_NAME => G_PKG_NAME
1029: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
1030: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1031: ,X_MSG_COUNT => X_MSG_COUNT
1032: ,X_MSG_DATA => X_MSG_DATA
1033: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1030: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

1026: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1027: (P_API_NAME => L_API_NAME
1028: ,P_PKG_NAME => G_PKG_NAME
1029: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
1030: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1031: ,X_MSG_COUNT => X_MSG_COUNT
1032: ,X_MSG_DATA => X_MSG_DATA
1033: ,X_RETURN_STATUS => X_RETURN_STATUS);
1034:

Line 1060: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

1056: BEGIN
1057:
1058: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1059:
1060: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1061: RETURN;
1062: END IF;
1063:
1064: IF p_repair_line_id = Fnd_Api.G_MISS_NUM

Line 1108: IF p_validation_mode = Jtf_Plsql_Api.G_CREATE

1104: BEGIN
1105:
1106: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1107:
1108: IF p_validation_mode = Jtf_Plsql_Api.G_CREATE
1109: AND (p_repair_number = Fnd_Api.G_MISS_CHAR
1110: OR p_repair_number IS NULL) THEN
1111: RETURN;
1112: END IF;

Line 1114: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

1110: OR p_repair_number IS NULL) THEN
1111: RETURN;
1112: END IF;
1113:
1114: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1115: IF p_repair_number IS NULL THEN
1116: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1117: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1118: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 1167: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

1163: BEGIN
1164:
1165: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1166:
1167: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1168: IF p_incident_id IS NULL THEN
1169: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1170: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1171: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 1223: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

1219: BEGIN
1220:
1221: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1222:
1223: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1224: IF p_inventory_item_id IS NULL THEN
1225: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1226: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1227: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 1284: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)

1280: BEGIN
1281:
1282: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1283:
1284: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)
1285: AND (p_customer_product_id = Fnd_Api.G_MISS_NUM
1286: OR p_customer_product_id IS NULL) THEN
1287: RETURN;
1288: END IF;

Line 1290: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)

1286: OR p_customer_product_id IS NULL) THEN
1287: RETURN;
1288: END IF;
1289:
1290: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)
1291: AND (p_customer_product_id = p_old_customer_product_id
1292: OR p_customer_product_id = Fnd_Api.G_MISS_NUM
1293: OR p_customer_product_id IS NULL) THEN
1294: RETURN;

Line 1348: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)

1344: BEGIN
1345:
1346: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1347:
1348: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)
1349: AND (p_customer_product_id = Fnd_Api.G_MISS_NUM
1350: OR p_customer_product_id IS NULL) THEN
1351: RETURN;
1352: END IF;

Line 1354: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)

1350: OR p_customer_product_id IS NULL) THEN
1351: RETURN;
1352: END IF;
1353:
1354: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)
1355: AND (p_customer_product_id = p_old_customer_product_id
1356: OR p_customer_product_id = Fnd_Api.G_MISS_NUM
1357: OR p_customer_product_id IS NULL) THEN
1358: RETURN;

Line 1407: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

1403: BEGIN
1404:
1405: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1406:
1407: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1408: IF p_unit_of_measure IS NULL THEN
1409: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1410: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1411: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 1462: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

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

Line 1546: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)

1542: l_resource_group := p_resource_group;
1543: end if;
1544: -- end swai: bug 7565999
1545:
1546: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)
1547: AND (p_resource_id = Fnd_Api.G_MISS_NUM
1548: OR p_resource_id IS NULL) THEN
1549: RETURN;
1550: END IF;

Line 1552: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)

1548: OR p_resource_id IS NULL) THEN
1549: RETURN;
1550: END IF;
1551:
1552: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)
1553: AND (p_resource_id = p_old_resource_id
1554: OR p_resource_id = Fnd_Api.G_MISS_NUM
1555: OR p_resource_id IS NULL) THEN
1556: RETURN;

Line 1604: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)

1600: BEGIN
1601:
1602: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1603:
1604: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)
1605: AND (p_resource_group = Fnd_Api.G_MISS_NUM
1606: OR p_resource_group IS NULL) THEN
1607: RETURN;
1608: END IF;

Line 1610: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)

1606: OR p_resource_group IS NULL) THEN
1607: RETURN;
1608: END IF;
1609:
1610: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)
1611: AND (p_resource_group = p_old_resource_group
1612: OR p_resource_group = Fnd_Api.G_MISS_NUM
1613: OR p_resource_group IS NULL) THEN
1614: RETURN;

Line 1708: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

1704: BEGIN
1705:
1706: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1707:
1708: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1709: IF p_status IS NULL THEN
1710: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1711: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1712: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 1764: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

1760: BEGIN
1761:
1762: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1763:
1764: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1765: IF p_approval_required_flag IS NULL THEN
1766: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1767: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1768: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 1828: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)

1824: BEGIN
1825:
1826: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1827:
1828: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)
1829: AND (p_approval_status = Fnd_Api.G_MISS_CHAR
1830: OR p_approval_status IS NULL) THEN
1831: RETURN;
1832: END IF;

Line 1834: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)

1830: OR p_approval_status IS NULL) THEN
1831: RETURN;
1832: END IF;
1833:
1834: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)
1835: AND (p_approval_status = p_old_approval_status
1836: OR p_approval_status = Fnd_Api.G_MISS_CHAR
1837: OR p_approval_status IS NULL) THEN
1838: RETURN;

Line 1890: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)

1886: BEGIN
1887:
1888: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1889:
1890: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)
1891: AND (p_promise_date = Fnd_Api.G_MISS_DATE
1892: OR p_promise_date IS NULL) THEN
1893: RETURN;
1894: END IF;

Line 1896: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)

1892: OR p_promise_date IS NULL) THEN
1893: RETURN;
1894: END IF;
1895:
1896: IF (p_validation_mode = Jtf_Plsql_Api.G_UPDATE)
1897: AND (p_promise_date = p_old_promise_date
1898: OR p_promise_date = Fnd_Api.G_MISS_DATE
1899: OR p_promise_date IS NULL) THEN
1900: RETURN;

Line 1933: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

1929: BEGIN
1930:
1931: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1932:
1933: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1934: IF p_quantity IS NULL THEN
1935: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1936: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1937: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 1986: if p_validation_mode = JTF_PLSQL_API.G_CREATE then

1982: or p_quantity_in_wip is null then
1983: return;
1984: end if;
1985:
1986: if p_validation_mode = JTF_PLSQL_API.G_CREATE then
1987: if p_quantity < p_quantity_in_wip then
1988: l_valid := 'N';
1989: end if;
1990: elsif p_validation_mode = JTF_PLSQL_API.G_UPDATE then

Line 1990: elsif p_validation_mode = JTF_PLSQL_API.G_UPDATE then

1986: if p_validation_mode = JTF_PLSQL_API.G_CREATE then
1987: if p_quantity < p_quantity_in_wip then
1988: l_valid := 'N';
1989: end if;
1990: elsif p_validation_mode = JTF_PLSQL_API.G_UPDATE then
1991: if p_quantity = FND_API.G_MISS_NUM
1992: or p_quantity is null then
1993: if p_old_quantity < p_quantity_in_wip then
1994: l_valid := 'N';

Line 2108: IF p_validation_mode = Jtf_Plsql_Api.G_CREATE THEN

2104:
2105: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2106:
2107: -- travi fix
2108: IF p_validation_mode = Jtf_Plsql_Api.G_CREATE THEN
2109: IF (p_ro_group_id IS NULL) THEN
2110: IF (g_debug > 0 ) THEN
2111: Csd_Gen_Utility_Pvt.ADD('Create_Repair_Order group_id is null : Validate_RO_GROUP_ID');
2112: END IF;

Line 2120: ELSIF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN

2116: END IF;
2117:
2118: RETURN;
2119: END IF;
2120: ELSIF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
2121: IF p_ro_group_id IS NULL THEN
2122: IF (g_debug > 0 ) THEN
2123: Csd_Gen_Utility_Pvt.ADD('Update_Repair_Order group_id is null : Validate_RO_GROUP_ID');
2124: END IF;

Line 2151: if p_validation_mode = JTF_PLSQL_API.G_UPDATE then

2147: END IF;
2148: END IF;
2149:
2150: /* old code
2151: if p_validation_mode = JTF_PLSQL_API.G_UPDATE then
2152: if p_ro_group_id is null then
2153: x_return_status := FND_API.G_RET_STS_ERROR;
2154: FND_MESSAGE.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2155: FND_MESSAGE.SET_TOKEN('API_NAME', 'Update_Repair_Order');

Line 2217: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)

2213: BEGIN
2214:
2215: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2216:
2217: IF (p_validation_mode = Jtf_Plsql_Api.G_CREATE)
2218: AND (p_ORIGINAL_SOURCE_REFERENCE = Fnd_Api.G_MISS_CHAR
2219: OR p_ORIGINAL_SOURCE_REFERENCE IS NULL) THEN
2220: RETURN;
2221: END IF;

Line 2517: p_validation_mode => Jtf_Plsql_Api.G_CREATE,

2513: (
2514: p_ORIGINAL_SOURCE_HEADER_ID => P_REPLN_Rec.ORIGINAL_SOURCE_HEADER_ID,
2515: p_ORIGINAL_SOURCE_LINE_ID => P_REPLN_Rec.ORIGINAL_SOURCE_LINE_ID,
2516: p_ORIGINAL_SOURCE_REFERENCE => P_REPLN_Rec.ORIGINAL_SOURCE_REFERENCE,
2517: p_validation_mode => Jtf_Plsql_Api.G_CREATE,
2518: x_return_status => x_return_status);
2519:
2520: -- Check return status from the above procedure call
2521: IF NOT (x_return_status = Fnd_Api.G_RET_STS_SUCCESS) THEN

Line 2884: IF p_validation_mode = Jtf_Plsql_Api.G_CREATE THEN

2880: -- bug#7242791, subhat (This FP also contains the fix provided in bug#7438725)
2881: -- the defaulting in the FND Flex API should happen only if the mode is
2882: -- create and profile CSD: Enable Flexfield Defaulting for Repair Orders Flexfield
2883: -- is set to Yes.
2884: IF p_validation_mode = Jtf_Plsql_Api.G_CREATE THEN
2885: if nvl(fnd_profile.value('CSD_RO_DFF_DEF'),'N') = 'Y' then
2886: l_valid_def_rec := Csd_Repairs_Util.Is_DescFlex_Valid
2887: (p_api_name => 'Create_Repair_Order',
2888: p_desc_flex_name => 'CSD_REPAIRS',

Line 2916: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

2912: END IF; -- End of Validation Level IF Block
2913: --
2914: EXCEPTION
2915: WHEN Fnd_Api.G_EXC_ERROR THEN
2916: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
2917: ( P_API_NAME => L_API_NAME
2918: ,P_PKG_NAME => G_PKG_NAME
2919: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
2920: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 2920: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

2916: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
2917: ( P_API_NAME => L_API_NAME
2918: ,P_PKG_NAME => G_PKG_NAME
2919: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
2920: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
2921: ,X_MSG_COUNT => X_MSG_COUNT
2922: ,X_MSG_DATA => X_MSG_DATA
2923: ,X_RETURN_STATUS => X_RETURN_STATUS);
2924:

Line 2926: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

2922: ,X_MSG_DATA => X_MSG_DATA
2923: ,X_RETURN_STATUS => X_RETURN_STATUS);
2924:
2925: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2926: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
2927: (P_API_NAME => L_API_NAME
2928: ,P_PKG_NAME => G_PKG_NAME
2929: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
2930: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 2930: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

2926: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
2927: (P_API_NAME => L_API_NAME
2928: ,P_PKG_NAME => G_PKG_NAME
2929: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
2930: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
2931: ,X_MSG_COUNT => X_MSG_COUNT
2932: ,X_MSG_DATA => X_MSG_DATA
2933: ,X_RETURN_STATUS => X_RETURN_STATUS);
2934:

Line 2936: Jtf_Plsql_Api.HANDLE_EXCEPTIONS

2932: ,X_MSG_DATA => X_MSG_DATA
2933: ,X_RETURN_STATUS => X_RETURN_STATUS);
2934:
2935: WHEN OTHERS THEN
2936: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
2937: (P_API_NAME => L_API_NAME
2938: ,P_PKG_NAME => G_PKG_NAME
2939: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
2940: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

Line 2939: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS

2935: WHEN OTHERS THEN
2936: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
2937: (P_API_NAME => L_API_NAME
2938: ,P_PKG_NAME => G_PKG_NAME
2939: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
2940: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
2941: ,X_MSG_COUNT => X_MSG_COUNT
2942: ,X_MSG_DATA => X_MSG_DATA
2943: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2940: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT

2936: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
2937: (P_API_NAME => L_API_NAME
2938: ,P_PKG_NAME => G_PKG_NAME
2939: ,P_EXCEPTION_LEVEL => Jtf_Plsql_Api.G_EXC_OTHERS
2940: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
2941: ,X_MSG_COUNT => X_MSG_COUNT
2942: ,X_MSG_DATA => X_MSG_DATA
2943: ,X_RETURN_STATUS => X_RETURN_STATUS);
2944: