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.OKS_EXTWAR_UTIL_PVT dependencies on OKC_API

Line 343: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

339:
340: l_serv_rec l_serv_csr%ROWTYPE;
341: l_found BOOLEAN := FALSE;
342: l_line_id NUMBER;
343: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
344: l_object_id VARCHAR2 (1);
345: l_object VARCHAR2 (1);
346: BEGIN
347: x_status := 'N';

Line 348: l_return_status := okc_api.g_ret_sts_success;

344: l_object_id VARCHAR2 (1);
345: l_object VARCHAR2 (1);
346: BEGIN
347: x_status := 'N';
348: l_return_status := okc_api.g_ret_sts_success;
349:
350: FOR l_line_rec IN l_serv_csr (p_service_id)
351: LOOP
352: l_object_id := NULL;

Line 374: x_return_status := okc_api.g_ret_sts_unexp_error;

370: x_return_status := l_return_status;
371: NULL;
372: WHEN OTHERS
373: THEN
374: x_return_status := okc_api.g_ret_sts_unexp_error;
375: okc_api.set_message (g_app_name,
376: g_unexpected_error,
377: g_sqlcode_token,
378: SQLCODE,

Line 375: okc_api.set_message (g_app_name,

371: NULL;
372: WHEN OTHERS
373: THEN
374: x_return_status := okc_api.g_ret_sts_unexp_error;
375: okc_api.set_message (g_app_name,
376: g_unexpected_error,
377: g_sqlcode_token,
378: SQLCODE,
379: g_sqlerrm_token,

Line 587: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

583: AND kii.dnz_chr_id = rel.chr_id;
584:
585: --Added for bug# 5382119
586:
587: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
588: l_order_hdr_id NUMBER := NULL;
589: l_chr_id NUMBER;
590: l_service_line_id NUMBER;
591: l_cle_status CHAR;

Line 623: l_return_status := okc_api.g_ret_sts_error;

619:
620: IF l_order_hdr_id IS NULL
621: THEN
622: x_service_status := NULL;
623: l_return_status := okc_api.g_ret_sts_error;
624:
625: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
626: THEN
627: fnd_log.STRING (fnd_log.level_error,

Line 634: okc_api.set_message (g_app_name,

630: 'Order Header Id NULL'
631: );
632: END IF;
633:
634: okc_api.set_message (g_app_name,
635: 'OKS_INVD_ORD_LINE_ID',
636: 'LINE_ID',
637: p_order_line_id
638: );

Line 645: -- l_return_status := okc_api.g_ret_sts_success;

641:
642: -- Modified for bug# 5382119
643:
644: -- x_service_status := 'N';
645: -- l_return_status := okc_api.g_ret_sts_success;
646:
647: l_service_dup := 'N';
648:
649: OPEN c_service_dup(c_order_hdr_id => to_char(l_Order_hdr_id)

Line 691: -- l_return_status := okc_api.g_ret_sts_success;

687: -- x_service_status := l_cle_status;
688: --
689: -- IF l_cle_status = 'D'
690: -- THEN
691: -- l_return_status := okc_api.g_ret_sts_success;
692: -- RAISE g_exception_halt_validation;
693: -- END IF;
694: --
695: -- IF NOT l_return_status = okc_api.g_ret_sts_success

Line 695: -- IF NOT l_return_status = okc_api.g_ret_sts_success

691: -- l_return_status := okc_api.g_ret_sts_success;
692: -- RAISE g_exception_halt_validation;
693: -- END IF;
694: --
695: -- IF NOT l_return_status = okc_api.g_ret_sts_success
696: -- THEN
697: -- l_return_status := okc_api.g_ret_sts_unexp_error;
698: -- okc_api.set_message (g_app_name, 'OKS_PROC_GET_K_LINE_ID');
699: -- RAISE g_exception_halt_validation;

Line 697: -- l_return_status := okc_api.g_ret_sts_unexp_error;

693: -- END IF;
694: --
695: -- IF NOT l_return_status = okc_api.g_ret_sts_success
696: -- THEN
697: -- l_return_status := okc_api.g_ret_sts_unexp_error;
698: -- okc_api.set_message (g_app_name, 'OKS_PROC_GET_K_LINE_ID');
699: -- RAISE g_exception_halt_validation;
700: -- END IF;
701: -- END LOOP;

Line 698: -- okc_api.set_message (g_app_name, 'OKS_PROC_GET_K_LINE_ID');

694: --
695: -- IF NOT l_return_status = okc_api.g_ret_sts_success
696: -- THEN
697: -- l_return_status := okc_api.g_ret_sts_unexp_error;
698: -- okc_api.set_message (g_app_name, 'OKS_PROC_GET_K_LINE_ID');
699: -- RAISE g_exception_halt_validation;
700: -- END IF;
701: -- END LOOP;
702: --

Line 721: x_return_status := okc_api.g_ret_sts_unexp_error;

717: || SQLERRM
718: );
719: END IF;
720:
721: x_return_status := okc_api.g_ret_sts_unexp_error;
722: okc_api.set_message (g_app_name,
723: g_unexpected_error,
724: g_sqlcode_token,
725: SQLCODE,

Line 722: okc_api.set_message (g_app_name,

718: );
719: END IF;
720:
721: x_return_status := okc_api.g_ret_sts_unexp_error;
722: okc_api.set_message (g_app_name,
723: g_unexpected_error,
724: g_sqlcode_token,
725: SQLCODE,
726: g_sqlerrm_token,

Line 750: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

746: )
747: IS
748: l_comm_bill_seq_id NUMBER;
749: l_ptr2 BINARY_INTEGER;
750: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
751:
752: CURSOR c_war_items_csr (c_bill_seq_id NUMBER)
753: IS
754: SELECT bic.component_item_id war_item_id

Line 831: x_return_status := okc_api.g_ret_sts_unexp_error;

827: x_return_status := l_return_status;
828: NULL;
829: WHEN OTHERS
830: THEN
831: x_return_status := okc_api.g_ret_sts_unexp_error;
832: okc_api.set_message (g_app_name,
833: g_unexpected_error,
834: g_sqlcode_token,
835: SQLCODE,

Line 832: okc_api.set_message (g_app_name,

828: NULL;
829: WHEN OTHERS
830: THEN
831: x_return_status := okc_api.g_ret_sts_unexp_error;
832: okc_api.set_message (g_app_name,
833: g_unexpected_error,
834: g_sqlcode_token,
835: SQLCODE,
836: g_sqlerrm_token,

Line 877: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

873: )
874: IS
875: l_war_date DATE;
876: l_com_bill_seq_id NUMBER;
877: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
878:
879: CURSOR bom_dtls_csr
880: IS
881: SELECT bic.component_quantity, b.primary_uom_code,

Line 896: x_return_status := okc_api.g_ret_sts_success;

892: -- fix bug 2458473
893: AND b.vendor_warranty_flag = 'Y'
894: AND ROWNUM < 2;
895: BEGIN
896: x_return_status := okc_api.g_ret_sts_success;
897: l_war_date := NVL (p_war_date, SYSDATE);
898:
899: OPEN bom_dtls_csr;
900:

Line 908: l_return_status := okc_api.g_ret_sts_unexp_error;

904: IF bom_dtls_csr%NOTFOUND
905: THEN
906: CLOSE bom_dtls_csr;
907:
908: l_return_status := okc_api.g_ret_sts_unexp_error;
909:
910: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
911: THEN
912: fnd_log.STRING

Line 919: okc_api.set_message (g_app_name, 'MISSING_DUR_AND_COVERAGE');

915: 'Bom_dtl_csr not Found: Mising Duration And Coverage '
916: );
917: END IF;
918:
919: okc_api.set_message (g_app_name, 'MISSING_DUR_AND_COVERAGE');
920: RAISE g_exception_halt_validation;
921: END IF;
922:
923: CLOSE bom_dtls_csr;

Line 941: x_return_status := okc_api.g_ret_sts_unexp_error;

937: x_return_status := l_return_status;
938: NULL;
939: WHEN OTHERS
940: THEN
941: x_return_status := okc_api.g_ret_sts_unexp_error;
942: okc_api.set_message (g_app_name,
943: g_unexpected_error,
944: g_sqlcode_token,
945: SQLCODE,

Line 942: okc_api.set_message (g_app_name,

938: NULL;
939: WHEN OTHERS
940: THEN
941: x_return_status := okc_api.g_ret_sts_unexp_error;
942: okc_api.set_message (g_app_name,
943: g_unexpected_error,
944: g_sqlcode_token,
945: SQLCODE,
946: g_sqlerrm_token,

Line 985: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

981: IS
982: l_warranty_tbl war_item_new_tbl_type;
983: l_ptr INTEGER;
984: l_comm_bill_seq_id NUMBER;
985: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
986: l_ship_date DATE;
987: l_ship_flag VARCHAR2 (1);
988: l_start_delay NUMBER;
989: p_date DATE;

Line 1034: x_return_status := okc_api.g_ret_sts_success;

1030: /* end of fix for bug#6047047-fp of bug#5939487 */
1031:
1032: l_get_date_rec get_ship_flag_csr%ROWTYPE;
1033: BEGIN
1034: x_return_status := okc_api.g_ret_sts_success;
1035:
1036: /* commented for the bug#6047047-fp of bug#5939487
1037: IF p_prod_item_id IS NULL
1038: THEN

Line 1039: x_return_status := okc_api.g_ret_sts_error;

1035:
1036: /* commented for the bug#6047047-fp of bug#5939487
1037: IF p_prod_item_id IS NULL
1038: THEN
1039: x_return_status := okc_api.g_ret_sts_error;
1040:
1041: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1042: THEN
1043: fnd_log.STRING (fnd_log.level_error,

Line 1049: okc_api.set_message (g_app_name, 'OKS_ORG_ID_INV_ID REQUIRED');

1045: 'Product Item Id Required'
1046: );
1047: END IF;
1048:
1049: okc_api.set_message (g_app_name, 'OKS_ORG_ID_INV_ID REQUIRED');
1050: RAISE g_exception_halt_validation;
1051: END IF;
1052:
1053: OPEN get_ship_csr;

Line 1071: l_return_status := okc_api.g_ret_sts_error;

1067: IF get_ship_csr%NOTFOUND
1068: THEN
1069: CLOSE get_ship_csr;
1070:
1071: l_return_status := okc_api.g_ret_sts_error;
1072:
1073: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1074: THEN
1075: fnd_log.STRING (fnd_log.level_error,

Line 1081: okc_api.set_message (g_app_name,

1077: 'Get_Ship_Csr not Found'
1078: );
1079: END IF;
1080:
1081: okc_api.set_message (g_app_name,
1082: 'OKS_SHIPFLG_STDELAY_NOT_SET',
1083: 'P_PROD_ITEM_ID',
1084: p_prod_item_id
1085: );

Line 1093: l_return_status := okc_api.g_ret_sts_error;

1089: CLOSE get_ship_csr;
1090:
1091: IF p_installation_date IS NULL AND p_ship_date IS NULL
1092: THEN
1093: l_return_status := okc_api.g_ret_sts_error;
1094:
1095: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1096: THEN
1097: fnd_log.STRING (fnd_log.level_error,

Line 1103: okc_api.set_message (g_app_name,

1099: 'Installation date and Ship Date not Set'
1100: );
1101: END IF;
1102:
1103: okc_api.set_message (g_app_name,
1104: 'OKS_SHIPFLG_SHIPDT_NOT_SET',
1105: 'P_ITEM_ID',
1106: p_prod_item_id
1107: );

Line 1182: IF NOT l_return_status = okc_api.g_ret_sts_success

1178: || ')'
1179: );
1180: END IF;
1181:
1182: IF NOT l_return_status = okc_api.g_ret_sts_success
1183: THEN
1184: RAISE g_exception_halt_validation;
1185: END IF;
1186:

Line 1227: okc_api.set_message (g_app_name, 'OKS_END_DT_DUR_REQUIRED');

1223: 'Null Warranty End Date'
1224: );
1225: END IF;
1226:
1227: okc_api.set_message (g_app_name, 'OKS_END_DT_DUR_REQUIRED');
1228: l_return_status := okc_api.g_ret_sts_error;
1229: RAISE g_exception_halt_validation;
1230: END IF;
1231:

Line 1228: l_return_status := okc_api.g_ret_sts_error;

1224: );
1225: END IF;
1226:
1227: okc_api.set_message (g_app_name, 'OKS_END_DT_DUR_REQUIRED');
1228: l_return_status := okc_api.g_ret_sts_error;
1229: RAISE g_exception_halt_validation;
1230: END IF;
1231:
1232: EXIT WHEN (l_ptr = l_warranty_tbl.LAST);

Line 1242: x_return_status := OKC_API.G_RET_STS_ERROR;

1238: /* New code for the bug#6047047 - fp of bug#5939487 */
1239: -- Added to check the warranty item associated to the item even before checking the start delay in Inventory. --
1240:
1241: If p_prod_item_id is Null then
1242: x_return_status := OKC_API.G_RET_STS_ERROR;
1243: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1244: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ERROR','Product Item Id Required');
1245: END IF;
1246: OKC_API.set_message(G_APP_NAME,'OKS_ORG_ID_INV_ID REQUIRED');

Line 1246: OKC_API.set_message(G_APP_NAME,'OKS_ORG_ID_INV_ID REQUIRED');

1242: x_return_status := OKC_API.G_RET_STS_ERROR;
1243: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1244: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ERROR','Product Item Id Required');
1245: END IF;
1246: OKC_API.set_message(G_APP_NAME,'OKS_ORG_ID_INV_ID REQUIRED');
1247: Raise G_EXCEPTION_HALT_VALIDATION;
1248: End If;
1249:
1250: Open Bill_Seq_Csr;

Line 1275: l_return_status := OKC_API.G_RET_STS_ERROR;

1271: 'Start Delay = '||l_start_delay );
1272: END IF;
1273:
1274: If p_installation_date Is Null AND p_ship_date Is Null Then
1275: l_return_status := OKC_API.G_RET_STS_ERROR;
1276: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1277: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ERROR','Installation date and Ship Date not Set');
1278: END IF;
1279: OKC_API.set_message(G_APP_NAME,'OKS_SHIPFLG_SHIPDT_NOT_SET','P_ITEM_ID',p_prod_item_id);

Line 1279: OKC_API.set_message(G_APP_NAME,'OKS_SHIPFLG_SHIPDT_NOT_SET','P_ITEM_ID',p_prod_item_id);

1275: l_return_status := OKC_API.G_RET_STS_ERROR;
1276: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1277: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ERROR','Installation date and Ship Date not Set');
1278: END IF;
1279: OKC_API.set_message(G_APP_NAME,'OKS_SHIPFLG_SHIPDT_NOT_SET','P_ITEM_ID',p_prod_item_id);
1280: Raise G_EXCEPTION_HALT_VALIDATION;
1281: End If;
1282:
1283: -- Installation date will be considered first -- vigandhi 04-jun-2002

Line 1324: If Not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

1320: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.Internal_call.after',
1321: ' Get_War_Dur_Per(Return status = '||l_return_status ||')');
1322: END IF;
1323:
1324: If Not l_return_status = OKC_API.G_RET_STS_SUCCESS Then
1325: Raise G_EXCEPTION_HALT_VALIDATION;
1326: End If;
1327:
1328: x_warranty_tbl(l_ptr).Service_item_id := l_warranty_tbl(l_ptr).war_item_id;

Line 1351: OKC_API.set_message(G_APP_NAME,'OKS_END_DT_DUR_REQUIRED');

1347: If x_warranty_tbl(l_ptr).warranty_end_date Is Null Then
1348: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1349: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ERROR','Null Warranty End Date');
1350: END IF;
1351: OKC_API.set_message(G_APP_NAME,'OKS_END_DT_DUR_REQUIRED');
1352: l_return_status := OKC_API.G_RET_STS_ERROR;
1353: RAISE G_EXCEPTION_HALT_VALIDATION;
1354: End If;
1355:

Line 1352: l_return_status := OKC_API.G_RET_STS_ERROR;

1348: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1349: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ERROR','Null Warranty End Date');
1350: END IF;
1351: OKC_API.set_message(G_APP_NAME,'OKS_END_DT_DUR_REQUIRED');
1352: l_return_status := OKC_API.G_RET_STS_ERROR;
1353: RAISE G_EXCEPTION_HALT_VALIDATION;
1354: End If;
1355:
1356: END IF;

Line 1375: x_return_status := okc_api.g_ret_sts_unexp_error;

1371: x_return_status := l_return_status;
1372: NULL;
1373: WHEN OTHERS
1374: THEN
1375: x_return_status := okc_api.g_ret_sts_unexp_error;
1376: okc_api.set_message (g_app_name,
1377: g_unexpected_error,
1378: g_sqlcode_token,
1379: SQLCODE,

Line 1376: okc_api.set_message (g_app_name,

1372: NULL;
1373: WHEN OTHERS
1374: THEN
1375: x_return_status := okc_api.g_ret_sts_unexp_error;
1376: okc_api.set_message (g_app_name,
1377: g_unexpected_error,
1378: g_sqlcode_token,
1379: SQLCODE,
1380: g_sqlerrm_token,

Line 1504: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

1500: FROM oe_order_headers_all
1501: WHERE header_id = p_hdr_id;
1502:
1503: l_ord_hdr_rec l_ord_hdr_csr%ROWTYPE;
1504: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
1505: l_warranty_tbl war_tbl;
1506: p_hdr_id NUMBER;
1507: l_party_id NUMBER;
1508: l_tax_id NUMBER;

Line 1539: l_return_status := okc_api.g_ret_sts_error;

1535: 'Header Id NULL for line ' || p_order_line_id
1536: );
1537: END IF;
1538:
1539: l_return_status := okc_api.g_ret_sts_error;
1540: okc_api.set_message (g_app_name,
1541: 'OKS_INVD_ORD_LINE_ID',
1542: 'LINE_ID',
1543: p_order_line_id

Line 1540: okc_api.set_message (g_app_name,

1536: );
1537: END IF;
1538:
1539: l_return_status := okc_api.g_ret_sts_error;
1540: okc_api.set_message (g_app_name,
1541: 'OKS_INVD_ORD_LINE_ID',
1542: 'LINE_ID',
1543: p_order_line_id
1544: );

Line 1578: l_return_status := okc_api.g_ret_sts_error;

1574: END IF;
1575:
1576: CLOSE l_ord_hdr_csr;
1577:
1578: l_return_status := okc_api.g_ret_sts_error;
1579: okc_api.set_message (g_app_name,
1580: 'OKS_ORD_HDR_DTLS_NOT_FOUND',
1581: 'ORDER_HEADER_ID',
1582: p_hdr_id

Line 1579: okc_api.set_message (g_app_name,

1575:
1576: CLOSE l_ord_hdr_csr;
1577:
1578: l_return_status := okc_api.g_ret_sts_error;
1579: okc_api.set_message (g_app_name,
1580: 'OKS_ORD_HDR_DTLS_NOT_FOUND',
1581: 'ORDER_HEADER_ID',
1582: p_hdr_id
1583: );

Line 1664: l_return_status := okc_api.g_ret_sts_error;

1660: END IF;
1661:
1662: CLOSE l_party_csr;
1663:
1664: l_return_status := okc_api.g_ret_sts_error;
1665: okc_api.set_message (g_app_name,
1666: 'OKS_PARTY_ID_NOT_FOUND',
1667: 'CUSTOMER_ID',
1668: l_ord_hdr_rec.sold_to_org_id

Line 1665: okc_api.set_message (g_app_name,

1661:
1662: CLOSE l_party_csr;
1663:
1664: l_return_status := okc_api.g_ret_sts_error;
1665: okc_api.set_message (g_app_name,
1666: 'OKS_PARTY_ID_NOT_FOUND',
1667: 'CUSTOMER_ID',
1668: l_ord_hdr_rec.sold_to_org_id
1669: );

Line 1767: l_return_status := OKC_API.G_RET_STS_ERROR;

1763: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1764: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.ERROR',
1765: 'Tax Exemption Record Not Found');
1766: END IF;
1767: l_return_status := OKC_API.G_RET_STS_ERROR;
1768: OKC_API.set_message(G_APP_NAME,'OKS_TAX_DTLS_NOT_FOUND');
1769: Raise G_EXCEPTION_HALT_VALIDATION;
1770: End if;
1771:

Line 1768: OKC_API.set_message(G_APP_NAME,'OKS_TAX_DTLS_NOT_FOUND');

1764: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.ERROR',
1765: 'Tax Exemption Record Not Found');
1766: END IF;
1767: l_return_status := OKC_API.G_RET_STS_ERROR;
1768: OKC_API.set_message(G_APP_NAME,'OKS_TAX_DTLS_NOT_FOUND');
1769: Raise G_EXCEPTION_HALT_VALIDATION;
1770: End if;
1771:
1772: End If;

Line 1798: l_return_status := okc_api.g_ret_sts_error;

1794: END IF;
1795:
1796: CLOSE l_tax_flag_csr;
1797:
1798: l_return_status := okc_api.g_ret_sts_error;
1799: --OKC_API.set_message(G_APP_NAME,'OKS_TAX_DTLS_NOT_FOUND');
1800: RAISE g_exception_halt_validation;
1801: END IF;
1802:

Line 1799: --OKC_API.set_message(G_APP_NAME,'OKS_TAX_DTLS_NOT_FOUND');

1795:
1796: CLOSE l_tax_flag_csr;
1797:
1798: l_return_status := okc_api.g_ret_sts_error;
1799: --OKC_API.set_message(G_APP_NAME,'OKS_TAX_DTLS_NOT_FOUND');
1800: RAISE g_exception_halt_validation;
1801: END IF;
1802:
1803: CLOSE l_tax_flag_csr;

Line 1849: okc_api.set_message (g_app_name,

1845: EXCEPTION
1846: WHEN g_exception_halt_validation
1847: THEN
1848: x_return_status := l_return_status;
1849: okc_api.set_message (g_app_name,
1850: g_unexpected_error,
1851: g_sqlcode_token,
1852: SQLCODE,
1853: g_sqlerrm_token,

Line 1858: x_return_status := okc_api.g_ret_sts_unexp_error;

1854: SQLERRM
1855: );
1856: WHEN OTHERS
1857: THEN
1858: x_return_status := okc_api.g_ret_sts_unexp_error;
1859: okc_api.set_message (g_app_name,
1860: g_unexpected_error,
1861: g_sqlcode_token,
1862: SQLCODE,

Line 1859: okc_api.set_message (g_app_name,

1855: );
1856: WHEN OTHERS
1857: THEN
1858: x_return_status := okc_api.g_ret_sts_unexp_error;
1859: okc_api.set_message (g_app_name,
1860: g_unexpected_error,
1861: g_sqlcode_token,
1862: SQLCODE,
1863: g_sqlerrm_token,

Line 1929: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

1925: AND t.LANGUAGE = USERENV ('LANG')
1926: AND b.inventory_item_id = p_product_item
1927: AND b.organization_id = okc_context.get_okc_organization_id;
1928:
1929: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
1930: l_warranty_tbl war_tbl;
1931: l_ptr BINARY_INTEGER;
1932: l_ord_line_rec l_ord_line_csr%ROWTYPE;
1933: l_segment_rec l_segment_csr%ROWTYPE;

Line 1956: l_return_status := okc_api.g_ret_sts_error;

1952: || p_order_line_id
1953: );
1954: END IF;
1955:
1956: l_return_status := okc_api.g_ret_sts_error;
1957: okc_api.set_message (g_app_name,
1958: 'OKS_ORD_LINE_DTLS_NOT_FOUND',
1959: 'ORDER_LINE',
1960: p_order_line_id

Line 1957: okc_api.set_message (g_app_name,

1953: );
1954: END IF;
1955:
1956: l_return_status := okc_api.g_ret_sts_error;
1957: okc_api.set_message (g_app_name,
1958: 'OKS_ORD_LINE_DTLS_NOT_FOUND',
1959: 'ORDER_LINE',
1960: p_order_line_id
1961: );

Line 1986: l_return_status := okc_api.g_ret_sts_error;

1982: || l_ord_line_rec.org_id
1983: );
1984: END IF;
1985:
1986: l_return_status := okc_api.g_ret_sts_error;
1987: okc_api.set_message (g_app_name,
1988: 'OKS_ITEM_DTLS_NOT_FOUND',
1989: 'PRODUCT_ITEM',
1990: p_product_item

Line 1987: okc_api.set_message (g_app_name,

1983: );
1984: END IF;
1985:
1986: l_return_status := okc_api.g_ret_sts_error;
1987: okc_api.set_message (g_app_name,
1988: 'OKS_ITEM_DTLS_NOT_FOUND',
1989: 'PRODUCT_ITEM',
1990: p_product_item
1991: );

Line 2055: okc_api.set_message (g_app_name,

2051: EXCEPTION
2052: WHEN g_exception_halt_validation
2053: THEN
2054: x_return_status := l_return_status;
2055: okc_api.set_message (g_app_name,
2056: g_unexpected_error,
2057: g_sqlcode_token,
2058: SQLCODE,
2059: g_sqlerrm_token,

Line 2064: x_return_status := okc_api.g_ret_sts_unexp_error;

2060: SQLERRM
2061: );
2062: WHEN OTHERS
2063: THEN
2064: x_return_status := okc_api.g_ret_sts_unexp_error;
2065: okc_api.set_message (g_app_name,
2066: g_unexpected_error,
2067: g_sqlcode_token,
2068: SQLCODE,

Line 2065: okc_api.set_message (g_app_name,

2061: );
2062: WHEN OTHERS
2063: THEN
2064: x_return_status := okc_api.g_ret_sts_unexp_error;
2065: okc_api.set_message (g_app_name,
2066: g_unexpected_error,
2067: g_sqlcode_token,
2068: SQLCODE,
2069: g_sqlerrm_token,

Line 2179: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

2175: AND ol.ID = ot.cle_id
2176: AND ol.lse_id = 18;
2177:
2178: l_ord_line_rec l_ord_line_csr%ROWTYPE;
2179: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
2180: l_inv_id NUMBER;
2181: l_war_edt DATE;
2182: l_curr_code VARCHAR2 (15);
2183: l_line_tax_status VARCHAR2 (40);

Line 2221: l_return_status := okc_api.g_ret_sts_error;

2217: END IF;
2218:
2219: CLOSE l_ord_line_csr;
2220:
2221: l_return_status := okc_api.g_ret_sts_error;
2222: okc_api.set_message (g_app_name,
2223: 'OKS_ORD_LINE_DTLS_NOT_FOUND',
2224: 'ORDER_LINE',
2225: p_order_line_id

Line 2222: okc_api.set_message (g_app_name,

2218:
2219: CLOSE l_ord_line_csr;
2220:
2221: l_return_status := okc_api.g_ret_sts_error;
2222: okc_api.set_message (g_app_name,
2223: 'OKS_ORD_LINE_DTLS_NOT_FOUND',
2224: 'ORDER_LINE',
2225: p_order_line_id
2226: );

Line 2256: l_return_status := okc_api.g_ret_sts_error;

2252: 'End Date, Duration, Period Required '
2253: );
2254: END IF;
2255:
2256: l_return_status := okc_api.g_ret_sts_error;
2257: x_return_status := l_return_status;
2258: okc_api.set_message (g_app_name, 'OKS_END_DT_DUR_REQUIRED');
2259:
2260: --mmadhavi

Line 2258: okc_api.set_message (g_app_name, 'OKS_END_DT_DUR_REQUIRED');

2254: END IF;
2255:
2256: l_return_status := okc_api.g_ret_sts_error;
2257: x_return_status := l_return_status;
2258: okc_api.set_message (g_app_name, 'OKS_END_DT_DUR_REQUIRED');
2259:
2260: --mmadhavi
2261: IF (p_caller = 'OC')
2262: THEN

Line 2393: okc_api.set_message (g_app_name,

2389: ' Null Start Date'
2390: );
2391: END IF;
2392:
2393: okc_api.set_message (g_app_name,
2394: 'OKS_NULL_SDT',
2395: 'LINE_ID',
2396: p_order_line_id
2397: );

Line 2398: l_return_status := okc_api.g_ret_sts_error;

2394: 'OKS_NULL_SDT',
2395: 'LINE_ID',
2396: p_order_line_id
2397: );
2398: l_return_status := okc_api.g_ret_sts_error;
2399:
2400: --mmadhavi
2401: IF (p_caller = 'OC')
2402: THEN

Line 2424: okc_api.set_message (g_app_name, 'OKS_END_DT_DUR_REQUIRED');

2420: ' Null End Date'
2421: );
2422: END IF;
2423:
2424: okc_api.set_message (g_app_name, 'OKS_END_DT_DUR_REQUIRED');
2425: l_return_status := okc_api.g_ret_sts_error;
2426:
2427: --mmadhavi
2428: IF (p_caller = 'OC')

Line 2425: l_return_status := okc_api.g_ret_sts_error;

2421: );
2422: END IF;
2423:
2424: okc_api.set_message (g_app_name, 'OKS_END_DT_DUR_REQUIRED');
2425: l_return_status := okc_api.g_ret_sts_error;
2426:
2427: --mmadhavi
2428: IF (p_caller = 'OC')
2429: THEN

Line 2492: okc_api.set_message (g_app_name,

2488: EXCEPTION
2489: WHEN g_exception_halt_validation
2490: THEN
2491: x_return_status := l_return_status;
2492: okc_api.set_message (g_app_name,
2493: g_unexpected_error,
2494: g_sqlcode_token,
2495: SQLCODE,
2496: g_sqlerrm_token,

Line 2501: x_return_status := okc_api.g_ret_sts_unexp_error;

2497: SQLERRM
2498: );
2499: WHEN OTHERS
2500: THEN
2501: x_return_status := okc_api.g_ret_sts_unexp_error;
2502: okc_api.set_message (g_app_name,
2503: g_unexpected_error,
2504: g_sqlcode_token,
2505: SQLCODE,

Line 2502: okc_api.set_message (g_app_name,

2498: );
2499: WHEN OTHERS
2500: THEN
2501: x_return_status := okc_api.g_ret_sts_unexp_error;
2502: okc_api.set_message (g_app_name,
2503: g_unexpected_error,
2504: g_sqlcode_token,
2505: SQLCODE,
2506: g_sqlerrm_token,

Line 2544: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

2540: l_ord_hdr_id NUMBER;
2541: l_ptr INTEGER;
2542: l_found BOOLEAN := TRUE;
2543: l_order_header_id NUMBER;
2544: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
2545:
2546: CURSOR l_line_csr (p_ord_hdr_id NUMBER)
2547: IS
2548: SELECT line_id, inventory_item_id, service_start_date,

Line 2561: l_return_status := okc_api.g_ret_sts_error;

2557:
2558: IF l_ord_hdr_id IS NULL
2559: THEN
2560: x_immediate_service_status := 'N';
2561: l_return_status := okc_api.g_ret_sts_error;
2562:
2563: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2564: THEN
2565: fnd_log.STRING (fnd_log.level_error,

Line 2573: okc_api.set_message (g_app_name,

2569: || p_order_line_id
2570: );
2571: END IF;
2572:
2573: okc_api.set_message (g_app_name,
2574: 'OKS_INVD_ORD_LINE_ID',
2575: 'LINE_ID',
2576: p_order_line_id
2577: );

Line 2614: x_return_status := okc_api.g_ret_sts_unexp_error;

2610: THEN
2611: x_return_status := l_return_status;
2612: WHEN OTHERS
2613: THEN
2614: x_return_status := okc_api.g_ret_sts_unexp_error;
2615: okc_api.set_message (g_app_name,
2616: g_unexpected_error,
2617: g_sqlcode_token,
2618: SQLCODE,

Line 2615: okc_api.set_message (g_app_name,

2611: x_return_status := l_return_status;
2612: WHEN OTHERS
2613: THEN
2614: x_return_status := okc_api.g_ret_sts_unexp_error;
2615: okc_api.set_message (g_app_name,
2616: g_unexpected_error,
2617: g_sqlcode_token,
2618: SQLCODE,
2619: g_sqlerrm_token,

Line 2658: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

2654: l_ord_hdr_id NUMBER;
2655: l_ptr INTEGER;
2656: l_found BOOLEAN := TRUE;
2657: l_order_header_id NUMBER;
2658: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
2659:
2660: /* --Commented 17-jul-2003
2661: --Delayed services with ref type ORDER can be picked up
2662: --by order capture concurrent prog

Line 2700: l_return_status := okc_api.g_ret_sts_error;

2696: );
2697: END IF;
2698:
2699: x_delayed_service_status := 'N';
2700: l_return_status := okc_api.g_ret_sts_error;
2701: okc_api.set_message (g_app_name,
2702: 'OKS_INVD_ORD_LINE_ID',
2703: 'LINE_ID',
2704: p_order_line_id

Line 2701: okc_api.set_message (g_app_name,

2697: END IF;
2698:
2699: x_delayed_service_status := 'N';
2700: l_return_status := okc_api.g_ret_sts_error;
2701: okc_api.set_message (g_app_name,
2702: 'OKS_INVD_ORD_LINE_ID',
2703: 'LINE_ID',
2704: p_order_line_id
2705: );

Line 2756: x_return_status := okc_api.g_ret_sts_unexp_error;

2752: THEN
2753: x_return_status := l_return_status;
2754: WHEN OTHERS
2755: THEN
2756: x_return_status := okc_api.g_ret_sts_unexp_error;
2757:
2758: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2759: THEN
2760: fnd_log.STRING (fnd_log.level_unexpected,

Line 2768: okc_api.set_message (g_app_name,

2764: || SQLERRM
2765: );
2766: END IF;
2767:
2768: okc_api.set_message (g_app_name,
2769: g_unexpected_error,
2770: g_sqlcode_token,
2771: SQLCODE,
2772: g_sqlerrm_token,

Line 2935: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

2931: l_unit_price NUMBER;
2932: l_serv_amount NUMBER;
2933: l_coverage_tempid NUMBER;
2934: l_chrid NUMBER;
2935: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
2936: warranty_flag VARCHAR2 (1);
2937: l_id NUMBER;
2938: l_org_id NUMBER;
2939: l_contract_number VARCHAR2 (120);

Line 3259: x_return_status := okc_api.g_ret_sts_unexp_error;

3255: x_return_status := l_return_status;
3256: NULL;
3257: WHEN OTHERS
3258: THEN
3259: x_return_status := okc_api.g_ret_sts_unexp_error;
3260: okc_api.set_message (g_app_name,
3261: g_unexpected_error,
3262: g_sqlcode_token,
3263: SQLCODE,

Line 3260: okc_api.set_message (g_app_name,

3256: NULL;
3257: WHEN OTHERS
3258: THEN
3259: x_return_status := okc_api.g_ret_sts_unexp_error;
3260: okc_api.set_message (g_app_name,
3261: g_unexpected_error,
3262: g_sqlcode_token,
3263: SQLCODE,
3264: g_sqlerrm_token,

Line 3298: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

3294: p_cle_id IN NUMBER
3295: )
3296: IS
3297: l_ptr NUMBER;
3298: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
3299:
3300: CURSOR l_bill_csr
3301: IS
3302: SELECT date_billed_from, date_billed_to, creation_date

Line 3321: l_return_status := okc_api.g_ret_sts_success;

3317: l_qty NUMBER;
3318: BEGIN
3319: IF p_bill_start_date IS NULL OR p_bill_end_date IS NULL
3320: THEN
3321: l_return_status := okc_api.g_ret_sts_success;
3322: RAISE g_exception_halt_validation;
3323: END IF;
3324:
3325: x_return_status := l_return_status;

Line 3345: l_return_status := okc_api.g_ret_sts_success;

3341: THEN
3342: x_billing_schedule_tbl (l_ptr).invoice_on_date := NULL;
3343: END IF;
3344:
3345: l_return_status := okc_api.g_ret_sts_success;
3346: RAISE g_exception_halt_validation;
3347: END IF;
3348:
3349: /**

Line 3379: l_return_status := okc_api.g_ret_sts_success;

3375: x_billing_schedule_tbl (l_ptr).billed_flag := 'F';
3376:
3377: IF x_billing_schedule_tbl (l_ptr).bill_to_date = p_bill_end_date
3378: THEN
3379: l_return_status := okc_api.g_ret_sts_success;
3380: RAISE g_exception_halt_validation;
3381: ELSE
3382: l_ptr := l_ptr + 1;
3383: END IF;

Line 3456: l_return_status := okc_api.g_ret_sts_unexp_error;

3452: ),
3453: p_bill_end_date
3454: );
3455: ELSE
3456: l_return_status := okc_api.g_ret_sts_unexp_error;
3457: okc_api.set_message (g_app_name, 'OKS_WRONG_BILLING_FREQUENCY');
3458: RAISE g_exception_halt_validation;
3459: END IF;
3460:

Line 3457: okc_api.set_message (g_app_name, 'OKS_WRONG_BILLING_FREQUENCY');

3453: p_bill_end_date
3454: );
3455: ELSE
3456: l_return_status := okc_api.g_ret_sts_unexp_error;
3457: okc_api.set_message (g_app_name, 'OKS_WRONG_BILLING_FREQUENCY');
3458: RAISE g_exception_halt_validation;
3459: END IF;
3460:
3461: IF UPPER (p_billing_method) = 'ADVANCE'

Line 3470: l_return_status := okc_api.g_ret_sts_unexp_error;

3466: ELSIF UPPER (p_billing_method) = 'ARREARS'
3467: THEN
3468: x_billing_schedule_tbl (l_ptr).invoice_on_date := NULL;
3469: ELSE
3470: l_return_status := okc_api.g_ret_sts_unexp_error;
3471: okc_api.set_message (g_app_name, 'OKS_WRONG_BILLING_METHOD');
3472: END IF;
3473:
3474: x_billing_schedule_tbl (l_ptr).billed_flag := 'F';

Line 3471: okc_api.set_message (g_app_name, 'OKS_WRONG_BILLING_METHOD');

3467: THEN
3468: x_billing_schedule_tbl (l_ptr).invoice_on_date := NULL;
3469: ELSE
3470: l_return_status := okc_api.g_ret_sts_unexp_error;
3471: okc_api.set_message (g_app_name, 'OKS_WRONG_BILLING_METHOD');
3472: END IF;
3473:
3474: x_billing_schedule_tbl (l_ptr).billed_flag := 'F';
3475: EXIT WHEN x_billing_schedule_tbl (l_ptr).bill_to_date =

Line 3486: x_return_status := okc_api.g_ret_sts_unexp_error;

3482: x_return_status := l_return_status;
3483: NULL;
3484: WHEN OTHERS
3485: THEN
3486: x_return_status := okc_api.g_ret_sts_unexp_error;
3487: okc_api.set_message (g_app_name,
3488: g_unexpected_error,
3489: g_sqlcode_token,
3490: SQLCODE,

Line 3487: okc_api.set_message (g_app_name,

3483: NULL;
3484: WHEN OTHERS
3485: THEN
3486: x_return_status := okc_api.g_ret_sts_unexp_error;
3487: okc_api.set_message (g_app_name,
3488: g_unexpected_error,
3489: g_sqlcode_token,
3490: SQLCODE,
3491: g_sqlerrm_token,

Line 3519: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

3515: IS
3516: l_warranty_tbl war_item_id_tbl_type;
3517: l_ptr INTEGER;
3518: l_comm_bill_seq_id NUMBER;
3519: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
3520: l_ship_date DATE;
3521: l_ship_flag VARCHAR2 (1);
3522: l_start_delay NUMBER;
3523:

Line 3534: x_return_status := okc_api.g_ret_sts_success;

3530: BEGIN
3531: okc_context.set_okc_org_context (p_org_id => p_org_id,
3532: p_organization_id => NULL
3533: );
3534: x_return_status := okc_api.g_ret_sts_success;
3535:
3536: IF p_prod_item_id IS NULL
3537: THEN
3538: --or p_customer_product_id is NULL

Line 3547: x_return_status := okc_api.g_ret_sts_error;

3543: 'Product Item Id Required'
3544: );
3545: END IF;
3546:
3547: x_return_status := okc_api.g_ret_sts_error;
3548: okc_api.set_message (g_app_name, 'OKS_ORG_ID_INV_ID REQUIRED');
3549: RAISE g_exception_halt_validation;
3550: END IF;
3551:

Line 3548: okc_api.set_message (g_app_name, 'OKS_ORG_ID_INV_ID REQUIRED');

3544: );
3545: END IF;
3546:
3547: x_return_status := okc_api.g_ret_sts_error;
3548: okc_api.set_message (g_app_name, 'OKS_ORG_ID_INV_ID REQUIRED');
3549: RAISE g_exception_halt_validation;
3550: END IF;
3551:
3552: get_war_item_id (p_inventory_item_id => p_prod_item_id,

Line 3604: IF NOT l_return_status = okc_api.g_ret_sts_success

3600: || ')'
3601: );
3602: END IF;
3603:
3604: IF NOT l_return_status = okc_api.g_ret_sts_success
3605: THEN
3606: RAISE g_exception_halt_validation;
3607: END IF;
3608:

Line 3629: x_return_status := okc_api.g_ret_sts_unexp_error;

3625: x_return_status := l_return_status;
3626: NULL;
3627: WHEN OTHERS
3628: THEN
3629: x_return_status := okc_api.g_ret_sts_unexp_error;
3630: okc_api.set_message (g_app_name,
3631: g_unexpected_error,
3632: g_sqlcode_token,
3633: SQLCODE,

Line 3630: okc_api.set_message (g_app_name,

3626: NULL;
3627: WHEN OTHERS
3628: THEN
3629: x_return_status := okc_api.g_ret_sts_unexp_error;
3630: okc_api.set_message (g_app_name,
3631: g_unexpected_error,
3632: g_sqlcode_token,
3633: SQLCODE,
3634: g_sqlerrm_token,

Line 3701: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

3697: WHERE ol.line_id = p_line_id AND ol.header_id = oh.header_id;
3698:
3699: cust_rec cust_csr%ROWTYPE;
3700: order_rec order_csr%ROWTYPE;
3701: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
3702: BEGIN
3703: x_return_status := l_return_status;
3704:
3705: OPEN cust_csr;

Line 3722: l_return_status := okc_api.g_ret_sts_error;

3718: ' Cust_csr Not Found '
3719: );
3720: END IF;
3721:
3722: l_return_status := okc_api.g_ret_sts_error;
3723: okc_api.set_message (g_app_name,
3724: 'OKS_CUST_PROD_DTLS_NOT_FOUND',
3725: 'CUSTOMER_PRODUCT',
3726: p_cpid

Line 3723: okc_api.set_message (g_app_name,

3719: );
3720: END IF;
3721:
3722: l_return_status := okc_api.g_ret_sts_error;
3723: okc_api.set_message (g_app_name,
3724: 'OKS_CUST_PROD_DTLS_NOT_FOUND',
3725: 'CUSTOMER_PRODUCT',
3726: p_cpid
3727: );

Line 3818: x_return_status := okc_api.g_ret_sts_unexp_error;

3814: THEN
3815: x_return_status := l_return_status;
3816: WHEN OTHERS
3817: THEN
3818: x_return_status := okc_api.g_ret_sts_unexp_error;
3819: okc_api.set_message (g_app_name,
3820: g_unexpected_error,
3821: g_sqlcode_token,
3822: SQLCODE,

Line 3819: okc_api.set_message (g_app_name,

3815: x_return_status := l_return_status;
3816: WHEN OTHERS
3817: THEN
3818: x_return_status := okc_api.g_ret_sts_unexp_error;
3819: okc_api.set_message (g_app_name,
3820: g_unexpected_error,
3821: g_sqlcode_token,
3822: SQLCODE,
3823: g_sqlerrm_token,

Line 3938: x_return_status := okc_api.g_ret_sts_unexp_error;

3934: END LOOP;
3935: EXCEPTION
3936: WHEN OTHERS
3937: THEN
3938: x_return_status := okc_api.g_ret_sts_unexp_error;
3939: okc_api.set_message (g_app_name,
3940: g_unexpected_error,
3941: g_sqlcode_token,
3942: SQLCODE,

Line 3939: okc_api.set_message (g_app_name,

3935: EXCEPTION
3936: WHEN OTHERS
3937: THEN
3938: x_return_status := okc_api.g_ret_sts_unexp_error;
3939: okc_api.set_message (g_app_name,
3940: g_unexpected_error,
3941: g_sqlcode_token,
3942: SQLCODE,
3943: g_sqlerrm_token,

Line 3991: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

3987: AND LANGUAGE = USERENV('LANG');
3988:
3989: */
3990: i INTEGER := 0;
3991: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
3992: BEGIN
3993: x_return_status := l_return_status;
3994: i := 1;
3995:

Line 4011: x_return_status := okc_api.g_ret_sts_unexp_error;

4007: THEN
4008: x_return_status := l_return_status;
4009: WHEN OTHERS
4010: THEN
4011: x_return_status := okc_api.g_ret_sts_unexp_error;
4012:
4013: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4014: THEN
4015: fnd_log.STRING (fnd_log.level_unexpected,

Line 4022: okc_api.set_message (g_app_name,

4018: || SQLERRM
4019: );
4020: END IF;
4021:
4022: okc_api.set_message (g_app_name,
4023: g_unexpected_error,
4024: g_sqlcode_token,
4025: SQLCODE,
4026: g_sqlerrm_token,

Line 4045: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

4041: FROM oe_sales_credits
4042: WHERE header_id = p_order_hdr_id AND line_id IS NULL;
4043:
4044: i INTEGER := 0;
4045: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
4046: BEGIN
4047: x_return_status := l_return_status;
4048: i := 1;
4049:

Line 4065: x_return_status := okc_api.g_ret_sts_unexp_error;

4061: THEN
4062: x_return_status := l_return_status;
4063: WHEN OTHERS
4064: THEN
4065: x_return_status := okc_api.g_ret_sts_unexp_error;
4066:
4067: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4068: THEN
4069: fnd_log.STRING (fnd_log.level_unexpected,

Line 4076: okc_api.set_message (g_app_name,

4072: || SQLERRM
4073: );
4074: END IF;
4075:
4076: okc_api.set_message (g_app_name,
4077: g_unexpected_error,
4078: g_sqlcode_token,
4079: SQLCODE,
4080: g_sqlerrm_token,

Line 4118: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

4114: l_link_rec2 l_link_csr_b%ROWTYPE;
4115: l_codv_tbl_in oks_cod_pvt.codv_tbl_type;
4116: l_codv_tbl_out oks_cod_pvt.codv_tbl_type;
4117: l_link_to_order_id VARCHAR2 (40);
4118: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
4119: l_msg_count NUMBER;
4120: l_msg_data VARCHAR2 (2000);
4121: link_flag NUMBER := 0;
4122: BEGIN

Line 4144: okc_api.set_message (g_app_name,

4140: || p_order_line_id
4141: );
4142: END IF;
4143:
4144: okc_api.set_message (g_app_name,
4145: 'OKS_ORDER_DETAILS',
4146: 'ORDER_DETAILS',
4147: p_order_line_id
4148: );

Line 4188: IF NOT l_return_status = okc_api.g_ret_sts_success

4184: || ')'
4185: );
4186: END IF;
4187:
4188: IF NOT l_return_status = okc_api.g_ret_sts_success
4189: THEN
4190: x_return_status := l_return_status;
4191: RAISE g_exception_halt_validation;
4192: END IF;

Line 4232: IF NOT l_return_status = okc_api.g_ret_sts_success

4228: || ')'
4229: );
4230: END IF;
4231:
4232: IF NOT l_return_status = okc_api.g_ret_sts_success
4233: THEN
4234: x_return_status := l_return_status;
4235: RAISE g_exception_halt_validation;
4236: END IF;

Line 4247: x_return_status := okc_api.g_ret_sts_unexp_error;

4243: THEN
4244: x_return_status := l_return_status;
4245: WHEN OTHERS
4246: THEN
4247: x_return_status := okc_api.g_ret_sts_unexp_error;
4248: okc_api.set_message (g_app_name,
4249: g_unexpected_error,
4250: g_sqlcode_token,
4251: SQLCODE,

Line 4248: okc_api.set_message (g_app_name,

4244: x_return_status := l_return_status;
4245: WHEN OTHERS
4246: THEN
4247: x_return_status := okc_api.g_ret_sts_unexp_error;
4248: okc_api.set_message (g_app_name,
4249: g_unexpected_error,
4250: g_sqlcode_token,
4251: SQLCODE,
4252: g_sqlerrm_token,

Line 4339: okc_api.set_message (g_app_name,

4335: EXCEPTION
4336: WHEN OTHERS
4337: THEN
4338: x_return_status := 'U';
4339: okc_api.set_message (g_app_name,
4340: g_unexpected_error,
4341: g_sqlcode_token,
4342: SQLCODE,
4343: g_sqlerrm_token,

Line 4430: okc_api.set_message (g_app_name,

4426: EXCEPTION
4427: WHEN OTHERS
4428: THEN
4429: x_return_status := 'U';
4430: okc_api.set_message (g_app_name,
4431: g_unexpected_error,
4432: g_sqlcode_token,
4433: SQLCODE,
4434: g_sqlerrm_token,

Line 4582: l_return_status VARCHAR2 (3) := okc_api.g_ret_sts_success;

4578: p_line_id NUMBER,
4579: x_return_status OUT NOCOPY VARCHAR2
4580: )
4581: IS
4582: l_return_status VARCHAR2 (3) := okc_api.g_ret_sts_success;
4583:
4584: CURSOR scredit_csr
4585: IS
4586: SELECT PERCENT, ctc_id, sales_credit_type_id1,

Line 4644: x_return_status := okc_api.g_ret_sts_unexp_error;

4640: THEN
4641: x_return_status := l_return_status;
4642: WHEN OTHERS
4643: THEN
4644: x_return_status := okc_api.g_ret_sts_unexp_error;
4645: okc_api.set_message (g_app_name,
4646: g_unexpected_error,
4647: g_sqlcode_token,
4648: SQLCODE,

Line 4645: okc_api.set_message (g_app_name,

4641: x_return_status := l_return_status;
4642: WHEN OTHERS
4643: THEN
4644: x_return_status := okc_api.g_ret_sts_unexp_error;
4645: okc_api.set_message (g_app_name,
4646: g_unexpected_error,
4647: g_sqlcode_token,
4648: SQLCODE,
4649: g_sqlerrm_token,

Line 4697: x_return_status := okc_api.g_ret_sts_success;

4693: l_cursor_id INTEGER;
4694: l_name VARCHAR2 (800) := NULL;
4695: l_delimiter VARCHAR2 (5);
4696: BEGIN
4697: x_return_status := okc_api.g_ret_sts_success;
4698:
4699: IF p_code = 'SERV'
4700: THEN
4701: l_structure_code := 'ORACLE_SERVICE_ITEM_FLEXFIELD';

Line 4771: x_return_status := okc_api.g_ret_sts_unexp_error;

4767: RETURN (l_name);
4768: EXCEPTION
4769: WHEN OTHERS
4770: THEN
4771: x_return_status := okc_api.g_ret_sts_unexp_error;
4772: okc_api.set_message (g_app_name,
4773: g_unexpected_error,
4774: g_sqlcode_token,
4775: SQLCODE,

Line 4772: okc_api.set_message (g_app_name,

4768: EXCEPTION
4769: WHEN OTHERS
4770: THEN
4771: x_return_status := okc_api.g_ret_sts_unexp_error;
4772: okc_api.set_message (g_app_name,
4773: g_unexpected_error,
4774: g_sqlcode_token,
4775: SQLCODE,
4776: g_sqlerrm_token,

Line 4817: x_return_status := okc_api.g_ret_sts_success;

4813: l_name VARCHAR2 (800) := NULL;
4814: l_desc VARCHAR2 (800) := NULL;
4815: l_delimiter VARCHAR2 (5);
4816: BEGIN
4817: x_return_status := okc_api.g_ret_sts_success;
4818:
4819: IF p_code = 'SERV'
4820: THEN
4821: l_structure_code := 'ORACLE_SERVICE_ITEM_FLEXFIELD';

Line 4897: x_return_status := okc_api.g_ret_sts_unexp_error;

4893: x_description := l_desc;
4894: EXCEPTION
4895: WHEN OTHERS
4896: THEN
4897: x_return_status := okc_api.g_ret_sts_unexp_error;
4898: x_name := NULL;
4899: x_description := NULL;
4900: okc_api.set_message (g_app_name,
4901: g_unexpected_error,

Line 4900: okc_api.set_message (g_app_name,

4896: THEN
4897: x_return_status := okc_api.g_ret_sts_unexp_error;
4898: x_name := NULL;
4899: x_description := NULL;
4900: okc_api.set_message (g_app_name,
4901: g_unexpected_error,
4902: g_sqlcode_token,
4903: SQLCODE,
4904: g_sqlerrm_token,

Line 5044: okc_api.set_message (g_app_name,

5040: END IF;
5041:
5042: IF l_salesrep_id IS NULL
5043: THEN
5044: okc_api.set_message (g_app_name,
5045: g_required_value,
5046: g_col_name_token,
5047: 'NO CONTACT FOUND FOR CONTRACT ID '
5048: || p_contract_id

Line 5062: okc_api.set_message (g_app_name,

5058: CLOSE l_get_source_csr;
5059:
5060: IF l_source_id IS NULL
5061: THEN
5062: okc_api.set_message (g_app_name,
5063: g_required_value,
5064: g_col_name_token,
5065: 'NO SOURCE FOUND FOR SALESREP ' || l_salesrep_id
5066: );

Line 5116: okc_api.set_message (g_app_name,

5112: x_return_status := 'E';
5113: WHEN OTHERS
5114: THEN
5115: x_return_status := 'U';
5116: okc_api.set_message (g_app_name,
5117: g_unexpected_error,
5118: g_sqlcode_token,
5119: SQLCODE,
5120: g_sqlerrm_token,

Line 5754: okc_api.set_message (g_app_name,

5750: ELSIF TRUNC (p_end_date) >= l_max_dt_billed_to
5751: THEN
5752: RETURN FALSE;
5753: ELSE ----TRUNC(p_end_date) < TRUNC(l_max_dt_billed_to)
5754: okc_api.set_message (g_app_name,
5755: 'OKS_BILLED_CHECK',
5756: 'MAX_BILLED_DATE',
5757: l_max_dt_billed_to
5758: );

Line 5766: --OKC_API.set_message(G_APP_NAME,'OKS_BILLED_CHECK','MAX_BILLED_DATE',TO_CHAR(l_max_dt_billed_to,'DD-MON-YYYY HH24:MI:SS'));

5762: IF l_max_dt_billed_to IS NULL
5763: THEN
5764: RETURN FALSE;
5765: ELSE
5766: --OKC_API.set_message(G_APP_NAME,'OKS_BILLED_CHECK','MAX_BILLED_DATE',TO_CHAR(l_max_dt_billed_to,'DD-MON-YYYY HH24:MI:SS'));
5767: okc_api.set_message (g_app_name, 'OKS_BA_UPDATE_NOT_ALLOWED');
5768: RETURN TRUE;
5769: END IF;
5770: END IF;

Line 5767: okc_api.set_message (g_app_name, 'OKS_BA_UPDATE_NOT_ALLOWED');

5763: THEN
5764: RETURN FALSE;
5765: ELSE
5766: --OKC_API.set_message(G_APP_NAME,'OKS_BILLED_CHECK','MAX_BILLED_DATE',TO_CHAR(l_max_dt_billed_to,'DD-MON-YYYY HH24:MI:SS'));
5767: okc_api.set_message (g_app_name, 'OKS_BA_UPDATE_NOT_ALLOWED');
5768: RETURN TRUE;
5769: END IF;
5770: END IF;
5771: EXCEPTION