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 986: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

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

Line 1035: x_return_status := okc_api.g_ret_sts_success;

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

Line 1040: x_return_status := okc_api.g_ret_sts_error;

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

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

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

Line 1072: l_return_status := okc_api.g_ret_sts_error;

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

Line 1082: okc_api.set_message (g_app_name,

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

Line 1094: l_return_status := okc_api.g_ret_sts_error;

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

Line 1104: okc_api.set_message (g_app_name,

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

Line 1183: IF NOT l_return_status = okc_api.g_ret_sts_success

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

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

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

Line 1229: l_return_status := okc_api.g_ret_sts_error;

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

Line 1243: x_return_status := OKC_API.G_RET_STS_ERROR;

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

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

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

Line 1276: l_return_status := OKC_API.G_RET_STS_ERROR;

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

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

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

Line 1326: If Not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

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

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

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

Line 1354: l_return_status := OKC_API.G_RET_STS_ERROR;

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

Line 1379: x_return_status := okc_api.g_ret_sts_unexp_error;

1375: x_return_status := l_return_status;
1376: NULL;
1377: WHEN OTHERS
1378: THEN
1379: x_return_status := okc_api.g_ret_sts_unexp_error;
1380: okc_api.set_message (g_app_name,
1381: g_unexpected_error,
1382: g_sqlcode_token,
1383: SQLCODE,

Line 1380: okc_api.set_message (g_app_name,

1376: NULL;
1377: WHEN OTHERS
1378: THEN
1379: x_return_status := okc_api.g_ret_sts_unexp_error;
1380: okc_api.set_message (g_app_name,
1381: g_unexpected_error,
1382: g_sqlcode_token,
1383: SQLCODE,
1384: g_sqlerrm_token,

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

1504: FROM oe_order_headers_all
1505: WHERE header_id = p_hdr_id;
1506:
1507: l_ord_hdr_rec l_ord_hdr_csr%ROWTYPE;
1508: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
1509: l_warranty_tbl war_tbl;
1510: p_hdr_id NUMBER;
1511: l_party_id NUMBER;
1512: l_tax_id NUMBER;

Line 1543: l_return_status := okc_api.g_ret_sts_error;

1539: 'Header Id NULL for line ' || p_order_line_id
1540: );
1541: END IF;
1542:
1543: l_return_status := okc_api.g_ret_sts_error;
1544: okc_api.set_message (g_app_name,
1545: 'OKS_INVD_ORD_LINE_ID',
1546: 'LINE_ID',
1547: p_order_line_id

Line 1544: okc_api.set_message (g_app_name,

1540: );
1541: END IF;
1542:
1543: l_return_status := okc_api.g_ret_sts_error;
1544: okc_api.set_message (g_app_name,
1545: 'OKS_INVD_ORD_LINE_ID',
1546: 'LINE_ID',
1547: p_order_line_id
1548: );

Line 1582: l_return_status := okc_api.g_ret_sts_error;

1578: END IF;
1579:
1580: CLOSE l_ord_hdr_csr;
1581:
1582: l_return_status := okc_api.g_ret_sts_error;
1583: okc_api.set_message (g_app_name,
1584: 'OKS_ORD_HDR_DTLS_NOT_FOUND',
1585: 'ORDER_HEADER_ID',
1586: p_hdr_id

Line 1583: okc_api.set_message (g_app_name,

1579:
1580: CLOSE l_ord_hdr_csr;
1581:
1582: l_return_status := okc_api.g_ret_sts_error;
1583: okc_api.set_message (g_app_name,
1584: 'OKS_ORD_HDR_DTLS_NOT_FOUND',
1585: 'ORDER_HEADER_ID',
1586: p_hdr_id
1587: );

Line 1668: l_return_status := okc_api.g_ret_sts_error;

1664: END IF;
1665:
1666: CLOSE l_party_csr;
1667:
1668: l_return_status := okc_api.g_ret_sts_error;
1669: okc_api.set_message (g_app_name,
1670: 'OKS_PARTY_ID_NOT_FOUND',
1671: 'CUSTOMER_ID',
1672: l_ord_hdr_rec.sold_to_org_id

Line 1669: okc_api.set_message (g_app_name,

1665:
1666: CLOSE l_party_csr;
1667:
1668: l_return_status := okc_api.g_ret_sts_error;
1669: okc_api.set_message (g_app_name,
1670: 'OKS_PARTY_ID_NOT_FOUND',
1671: 'CUSTOMER_ID',
1672: l_ord_hdr_rec.sold_to_org_id
1673: );

Line 1771: l_return_status := OKC_API.G_RET_STS_ERROR;

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

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

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

Line 1802: l_return_status := okc_api.g_ret_sts_error;

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

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

1799:
1800: CLOSE l_tax_flag_csr;
1801:
1802: l_return_status := okc_api.g_ret_sts_error;
1803: --OKC_API.set_message(G_APP_NAME,'OKS_TAX_DTLS_NOT_FOUND');
1804: RAISE g_exception_halt_validation;
1805: END IF;
1806:
1807: CLOSE l_tax_flag_csr;

Line 1853: okc_api.set_message (g_app_name,

1849: EXCEPTION
1850: WHEN g_exception_halt_validation
1851: THEN
1852: x_return_status := l_return_status;
1853: okc_api.set_message (g_app_name,
1854: g_unexpected_error,
1855: g_sqlcode_token,
1856: SQLCODE,
1857: g_sqlerrm_token,

Line 1862: x_return_status := okc_api.g_ret_sts_unexp_error;

1858: SQLERRM
1859: );
1860: WHEN OTHERS
1861: THEN
1862: x_return_status := okc_api.g_ret_sts_unexp_error;
1863: okc_api.set_message (g_app_name,
1864: g_unexpected_error,
1865: g_sqlcode_token,
1866: SQLCODE,

Line 1863: okc_api.set_message (g_app_name,

1859: );
1860: WHEN OTHERS
1861: THEN
1862: x_return_status := okc_api.g_ret_sts_unexp_error;
1863: okc_api.set_message (g_app_name,
1864: g_unexpected_error,
1865: g_sqlcode_token,
1866: SQLCODE,
1867: g_sqlerrm_token,

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

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

Line 1960: l_return_status := okc_api.g_ret_sts_error;

1956: || p_order_line_id
1957: );
1958: END IF;
1959:
1960: l_return_status := okc_api.g_ret_sts_error;
1961: okc_api.set_message (g_app_name,
1962: 'OKS_ORD_LINE_DTLS_NOT_FOUND',
1963: 'ORDER_LINE',
1964: p_order_line_id

Line 1961: okc_api.set_message (g_app_name,

1957: );
1958: END IF;
1959:
1960: l_return_status := okc_api.g_ret_sts_error;
1961: okc_api.set_message (g_app_name,
1962: 'OKS_ORD_LINE_DTLS_NOT_FOUND',
1963: 'ORDER_LINE',
1964: p_order_line_id
1965: );

Line 1990: l_return_status := okc_api.g_ret_sts_error;

1986: || l_ord_line_rec.org_id
1987: );
1988: END IF;
1989:
1990: l_return_status := okc_api.g_ret_sts_error;
1991: okc_api.set_message (g_app_name,
1992: 'OKS_ITEM_DTLS_NOT_FOUND',
1993: 'PRODUCT_ITEM',
1994: p_product_item

Line 1991: okc_api.set_message (g_app_name,

1987: );
1988: END IF;
1989:
1990: l_return_status := okc_api.g_ret_sts_error;
1991: okc_api.set_message (g_app_name,
1992: 'OKS_ITEM_DTLS_NOT_FOUND',
1993: 'PRODUCT_ITEM',
1994: p_product_item
1995: );

Line 2059: okc_api.set_message (g_app_name,

2055: EXCEPTION
2056: WHEN g_exception_halt_validation
2057: THEN
2058: x_return_status := l_return_status;
2059: okc_api.set_message (g_app_name,
2060: g_unexpected_error,
2061: g_sqlcode_token,
2062: SQLCODE,
2063: g_sqlerrm_token,

Line 2068: x_return_status := okc_api.g_ret_sts_unexp_error;

2064: SQLERRM
2065: );
2066: WHEN OTHERS
2067: THEN
2068: x_return_status := okc_api.g_ret_sts_unexp_error;
2069: okc_api.set_message (g_app_name,
2070: g_unexpected_error,
2071: g_sqlcode_token,
2072: SQLCODE,

Line 2069: okc_api.set_message (g_app_name,

2065: );
2066: WHEN OTHERS
2067: THEN
2068: x_return_status := okc_api.g_ret_sts_unexp_error;
2069: okc_api.set_message (g_app_name,
2070: g_unexpected_error,
2071: g_sqlcode_token,
2072: SQLCODE,
2073: g_sqlerrm_token,

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

2180: AND ol.ID = ot.cle_id
2181: AND ol.lse_id = 18;
2182:
2183: l_ord_line_rec l_ord_line_csr%ROWTYPE;
2184: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
2185: l_inv_id NUMBER;
2186: l_war_edt DATE;
2187: l_curr_code VARCHAR2 (15);
2188: l_line_tax_status VARCHAR2 (40);

Line 2226: l_return_status := okc_api.g_ret_sts_error;

2222: END IF;
2223:
2224: CLOSE l_ord_line_csr;
2225:
2226: l_return_status := okc_api.g_ret_sts_error;
2227: okc_api.set_message (g_app_name,
2228: 'OKS_ORD_LINE_DTLS_NOT_FOUND',
2229: 'ORDER_LINE',
2230: p_order_line_id

Line 2227: okc_api.set_message (g_app_name,

2223:
2224: CLOSE l_ord_line_csr;
2225:
2226: l_return_status := okc_api.g_ret_sts_error;
2227: okc_api.set_message (g_app_name,
2228: 'OKS_ORD_LINE_DTLS_NOT_FOUND',
2229: 'ORDER_LINE',
2230: p_order_line_id
2231: );

Line 2261: l_return_status := okc_api.g_ret_sts_error;

2257: 'End Date, Duration, Period Required '
2258: );
2259: END IF;
2260:
2261: l_return_status := okc_api.g_ret_sts_error;
2262: x_return_status := l_return_status;
2263: okc_api.set_message (g_app_name, 'OKS_END_DT_DUR_REQUIRED');
2264:
2265: --mmadhavi

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

2259: END IF;
2260:
2261: l_return_status := okc_api.g_ret_sts_error;
2262: x_return_status := l_return_status;
2263: okc_api.set_message (g_app_name, 'OKS_END_DT_DUR_REQUIRED');
2264:
2265: --mmadhavi
2266: IF (p_caller = 'OC')
2267: THEN

Line 2287: l_return_status := okc_api.g_ret_sts_error;

2283: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2284: 'Start_Date,End_Date are required for Subscription line '
2285: );
2286: END IF;
2287: l_return_status := okc_api.g_ret_sts_error;
2288: x_return_status := l_return_status;
2289: okc_api.set_message (g_app_name, 'OKS_END_DT_DUR_REQUIRED');
2290: --mmadhavi
2291: IF (p_caller = 'OC')

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

2285: );
2286: END IF;
2287: l_return_status := okc_api.g_ret_sts_error;
2288: x_return_status := l_return_status;
2289: okc_api.set_message (g_app_name, 'OKS_END_DT_DUR_REQUIRED');
2290: --mmadhavi
2291: IF (p_caller = 'OC')
2292: THEN
2293: fnd_message.set_name (g_app_name, 'OKS_END_DT_DUR_REQUIRED');

Line 2433: okc_api.set_message (g_app_name,

2429: ' Null Start Date'
2430: );
2431: END IF;
2432:
2433: okc_api.set_message (g_app_name,
2434: 'OKS_NULL_SDT',
2435: 'LINE_ID',
2436: p_order_line_id
2437: );

Line 2438: l_return_status := okc_api.g_ret_sts_error;

2434: 'OKS_NULL_SDT',
2435: 'LINE_ID',
2436: p_order_line_id
2437: );
2438: l_return_status := okc_api.g_ret_sts_error;
2439:
2440: --mmadhavi
2441: IF (p_caller = 'OC')
2442: THEN

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

2460: ' Null End Date'
2461: );
2462: END IF;
2463:
2464: okc_api.set_message (g_app_name, 'OKS_END_DT_DUR_REQUIRED');
2465: l_return_status := okc_api.g_ret_sts_error;
2466:
2467: --mmadhavi
2468: IF (p_caller = 'OC')

Line 2465: l_return_status := okc_api.g_ret_sts_error;

2461: );
2462: END IF;
2463:
2464: okc_api.set_message (g_app_name, 'OKS_END_DT_DUR_REQUIRED');
2465: l_return_status := okc_api.g_ret_sts_error;
2466:
2467: --mmadhavi
2468: IF (p_caller = 'OC')
2469: THEN

Line 2538: okc_api.set_message (g_app_name,

2534: EXCEPTION
2535: WHEN g_exception_halt_validation
2536: THEN
2537: x_return_status := l_return_status;
2538: okc_api.set_message (g_app_name,
2539: g_unexpected_error,
2540: g_sqlcode_token,
2541: SQLCODE,
2542: g_sqlerrm_token,

Line 2547: x_return_status := okc_api.g_ret_sts_unexp_error;

2543: SQLERRM
2544: );
2545: WHEN OTHERS
2546: THEN
2547: x_return_status := okc_api.g_ret_sts_unexp_error;
2548: okc_api.set_message (g_app_name,
2549: g_unexpected_error,
2550: g_sqlcode_token,
2551: SQLCODE,

Line 2548: okc_api.set_message (g_app_name,

2544: );
2545: WHEN OTHERS
2546: THEN
2547: x_return_status := okc_api.g_ret_sts_unexp_error;
2548: okc_api.set_message (g_app_name,
2549: g_unexpected_error,
2550: g_sqlcode_token,
2551: SQLCODE,
2552: g_sqlerrm_token,

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

2586: l_ord_hdr_id NUMBER;
2587: l_ptr INTEGER;
2588: l_found BOOLEAN := TRUE;
2589: l_order_header_id NUMBER;
2590: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
2591:
2592: CURSOR l_line_csr (p_ord_hdr_id NUMBER)
2593: IS
2594: SELECT line_id, inventory_item_id, service_start_date,

Line 2607: l_return_status := okc_api.g_ret_sts_error;

2603:
2604: IF l_ord_hdr_id IS NULL
2605: THEN
2606: x_immediate_service_status := 'N';
2607: l_return_status := okc_api.g_ret_sts_error;
2608:
2609: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2610: THEN
2611: fnd_log.STRING (fnd_log.level_error,

Line 2619: okc_api.set_message (g_app_name,

2615: || p_order_line_id
2616: );
2617: END IF;
2618:
2619: okc_api.set_message (g_app_name,
2620: 'OKS_INVD_ORD_LINE_ID',
2621: 'LINE_ID',
2622: p_order_line_id
2623: );

Line 2660: x_return_status := okc_api.g_ret_sts_unexp_error;

2656: THEN
2657: x_return_status := l_return_status;
2658: WHEN OTHERS
2659: THEN
2660: x_return_status := okc_api.g_ret_sts_unexp_error;
2661: okc_api.set_message (g_app_name,
2662: g_unexpected_error,
2663: g_sqlcode_token,
2664: SQLCODE,

Line 2661: okc_api.set_message (g_app_name,

2657: x_return_status := l_return_status;
2658: WHEN OTHERS
2659: THEN
2660: x_return_status := okc_api.g_ret_sts_unexp_error;
2661: okc_api.set_message (g_app_name,
2662: g_unexpected_error,
2663: g_sqlcode_token,
2664: SQLCODE,
2665: g_sqlerrm_token,

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

2700: l_ord_hdr_id NUMBER;
2701: l_ptr INTEGER;
2702: l_found BOOLEAN := TRUE;
2703: l_order_header_id NUMBER;
2704: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
2705:
2706: /* --Commented 17-jul-2003
2707: --Delayed services with ref type ORDER can be picked up
2708: --by order capture concurrent prog

Line 2746: l_return_status := okc_api.g_ret_sts_error;

2742: );
2743: END IF;
2744:
2745: x_delayed_service_status := 'N';
2746: l_return_status := okc_api.g_ret_sts_error;
2747: okc_api.set_message (g_app_name,
2748: 'OKS_INVD_ORD_LINE_ID',
2749: 'LINE_ID',
2750: p_order_line_id

Line 2747: okc_api.set_message (g_app_name,

2743: END IF;
2744:
2745: x_delayed_service_status := 'N';
2746: l_return_status := okc_api.g_ret_sts_error;
2747: okc_api.set_message (g_app_name,
2748: 'OKS_INVD_ORD_LINE_ID',
2749: 'LINE_ID',
2750: p_order_line_id
2751: );

Line 2802: x_return_status := okc_api.g_ret_sts_unexp_error;

2798: THEN
2799: x_return_status := l_return_status;
2800: WHEN OTHERS
2801: THEN
2802: x_return_status := okc_api.g_ret_sts_unexp_error;
2803:
2804: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2805: THEN
2806: fnd_log.STRING (fnd_log.level_unexpected,

Line 2814: okc_api.set_message (g_app_name,

2810: || SQLERRM
2811: );
2812: END IF;
2813:
2814: okc_api.set_message (g_app_name,
2815: g_unexpected_error,
2816: g_sqlcode_token,
2817: SQLCODE,
2818: g_sqlerrm_token,

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

2977: l_unit_price NUMBER;
2978: l_serv_amount NUMBER;
2979: l_coverage_tempid NUMBER;
2980: l_chrid NUMBER;
2981: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
2982: warranty_flag VARCHAR2 (1);
2983: l_id NUMBER;
2984: l_org_id NUMBER;
2985: l_contract_number VARCHAR2 (120);

Line 3305: x_return_status := okc_api.g_ret_sts_unexp_error;

3301: x_return_status := l_return_status;
3302: NULL;
3303: WHEN OTHERS
3304: THEN
3305: x_return_status := okc_api.g_ret_sts_unexp_error;
3306: okc_api.set_message (g_app_name,
3307: g_unexpected_error,
3308: g_sqlcode_token,
3309: SQLCODE,

Line 3306: okc_api.set_message (g_app_name,

3302: NULL;
3303: WHEN OTHERS
3304: THEN
3305: x_return_status := okc_api.g_ret_sts_unexp_error;
3306: okc_api.set_message (g_app_name,
3307: g_unexpected_error,
3308: g_sqlcode_token,
3309: SQLCODE,
3310: g_sqlerrm_token,

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

3340: p_cle_id IN NUMBER
3341: )
3342: IS
3343: l_ptr NUMBER;
3344: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
3345:
3346: CURSOR l_bill_csr
3347: IS
3348: SELECT date_billed_from, date_billed_to, creation_date

Line 3367: l_return_status := okc_api.g_ret_sts_success;

3363: l_qty NUMBER;
3364: BEGIN
3365: IF p_bill_start_date IS NULL OR p_bill_end_date IS NULL
3366: THEN
3367: l_return_status := okc_api.g_ret_sts_success;
3368: RAISE g_exception_halt_validation;
3369: END IF;
3370:
3371: x_return_status := l_return_status;

Line 3391: l_return_status := okc_api.g_ret_sts_success;

3387: THEN
3388: x_billing_schedule_tbl (l_ptr).invoice_on_date := NULL;
3389: END IF;
3390:
3391: l_return_status := okc_api.g_ret_sts_success;
3392: RAISE g_exception_halt_validation;
3393: END IF;
3394:
3395: /**

Line 3425: l_return_status := okc_api.g_ret_sts_success;

3421: x_billing_schedule_tbl (l_ptr).billed_flag := 'F';
3422:
3423: IF x_billing_schedule_tbl (l_ptr).bill_to_date = p_bill_end_date
3424: THEN
3425: l_return_status := okc_api.g_ret_sts_success;
3426: RAISE g_exception_halt_validation;
3427: ELSE
3428: l_ptr := l_ptr + 1;
3429: END IF;

Line 3502: l_return_status := okc_api.g_ret_sts_unexp_error;

3498: ),
3499: p_bill_end_date
3500: );
3501: ELSE
3502: l_return_status := okc_api.g_ret_sts_unexp_error;
3503: okc_api.set_message (g_app_name, 'OKS_WRONG_BILLING_FREQUENCY');
3504: RAISE g_exception_halt_validation;
3505: END IF;
3506:

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

3499: p_bill_end_date
3500: );
3501: ELSE
3502: l_return_status := okc_api.g_ret_sts_unexp_error;
3503: okc_api.set_message (g_app_name, 'OKS_WRONG_BILLING_FREQUENCY');
3504: RAISE g_exception_halt_validation;
3505: END IF;
3506:
3507: IF UPPER (p_billing_method) = 'ADVANCE'

Line 3516: l_return_status := okc_api.g_ret_sts_unexp_error;

3512: ELSIF UPPER (p_billing_method) = 'ARREARS'
3513: THEN
3514: x_billing_schedule_tbl (l_ptr).invoice_on_date := NULL;
3515: ELSE
3516: l_return_status := okc_api.g_ret_sts_unexp_error;
3517: okc_api.set_message (g_app_name, 'OKS_WRONG_BILLING_METHOD');
3518: END IF;
3519:
3520: x_billing_schedule_tbl (l_ptr).billed_flag := 'F';

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

3513: THEN
3514: x_billing_schedule_tbl (l_ptr).invoice_on_date := NULL;
3515: ELSE
3516: l_return_status := okc_api.g_ret_sts_unexp_error;
3517: okc_api.set_message (g_app_name, 'OKS_WRONG_BILLING_METHOD');
3518: END IF;
3519:
3520: x_billing_schedule_tbl (l_ptr).billed_flag := 'F';
3521: EXIT WHEN x_billing_schedule_tbl (l_ptr).bill_to_date =

Line 3532: x_return_status := okc_api.g_ret_sts_unexp_error;

3528: x_return_status := l_return_status;
3529: NULL;
3530: WHEN OTHERS
3531: THEN
3532: x_return_status := okc_api.g_ret_sts_unexp_error;
3533: okc_api.set_message (g_app_name,
3534: g_unexpected_error,
3535: g_sqlcode_token,
3536: SQLCODE,

Line 3533: okc_api.set_message (g_app_name,

3529: NULL;
3530: WHEN OTHERS
3531: THEN
3532: x_return_status := okc_api.g_ret_sts_unexp_error;
3533: okc_api.set_message (g_app_name,
3534: g_unexpected_error,
3535: g_sqlcode_token,
3536: SQLCODE,
3537: g_sqlerrm_token,

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

3561: IS
3562: l_warranty_tbl war_item_id_tbl_type;
3563: l_ptr INTEGER;
3564: l_comm_bill_seq_id NUMBER;
3565: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
3566: l_ship_date DATE;
3567: l_ship_flag VARCHAR2 (1);
3568: l_start_delay NUMBER;
3569:

Line 3580: x_return_status := okc_api.g_ret_sts_success;

3576: BEGIN
3577: okc_context.set_okc_org_context (p_org_id => p_org_id,
3578: p_organization_id => NULL
3579: );
3580: x_return_status := okc_api.g_ret_sts_success;
3581:
3582: IF p_prod_item_id IS NULL
3583: THEN
3584: --or p_customer_product_id is NULL

Line 3593: x_return_status := okc_api.g_ret_sts_error;

3589: 'Product Item Id Required'
3590: );
3591: END IF;
3592:
3593: x_return_status := okc_api.g_ret_sts_error;
3594: okc_api.set_message (g_app_name, 'OKS_ORG_ID_INV_ID REQUIRED');
3595: RAISE g_exception_halt_validation;
3596: END IF;
3597:

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

3590: );
3591: END IF;
3592:
3593: x_return_status := okc_api.g_ret_sts_error;
3594: okc_api.set_message (g_app_name, 'OKS_ORG_ID_INV_ID REQUIRED');
3595: RAISE g_exception_halt_validation;
3596: END IF;
3597:
3598: get_war_item_id (p_inventory_item_id => p_prod_item_id,

Line 3650: IF NOT l_return_status = okc_api.g_ret_sts_success

3646: || ')'
3647: );
3648: END IF;
3649:
3650: IF NOT l_return_status = okc_api.g_ret_sts_success
3651: THEN
3652: RAISE g_exception_halt_validation;
3653: END IF;
3654:

Line 3675: x_return_status := okc_api.g_ret_sts_unexp_error;

3671: x_return_status := l_return_status;
3672: NULL;
3673: WHEN OTHERS
3674: THEN
3675: x_return_status := okc_api.g_ret_sts_unexp_error;
3676: okc_api.set_message (g_app_name,
3677: g_unexpected_error,
3678: g_sqlcode_token,
3679: SQLCODE,

Line 3676: okc_api.set_message (g_app_name,

3672: NULL;
3673: WHEN OTHERS
3674: THEN
3675: x_return_status := okc_api.g_ret_sts_unexp_error;
3676: okc_api.set_message (g_app_name,
3677: g_unexpected_error,
3678: g_sqlcode_token,
3679: SQLCODE,
3680: g_sqlerrm_token,

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

3743: WHERE ol.line_id = p_line_id AND ol.header_id = oh.header_id;
3744:
3745: cust_rec cust_csr%ROWTYPE;
3746: order_rec order_csr%ROWTYPE;
3747: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
3748: BEGIN
3749: x_return_status := l_return_status;
3750:
3751: OPEN cust_csr;

Line 3768: l_return_status := okc_api.g_ret_sts_error;

3764: ' Cust_csr Not Found '
3765: );
3766: END IF;
3767:
3768: l_return_status := okc_api.g_ret_sts_error;
3769: okc_api.set_message (g_app_name,
3770: 'OKS_CUST_PROD_DTLS_NOT_FOUND',
3771: 'CUSTOMER_PRODUCT',
3772: p_cpid

Line 3769: okc_api.set_message (g_app_name,

3765: );
3766: END IF;
3767:
3768: l_return_status := okc_api.g_ret_sts_error;
3769: okc_api.set_message (g_app_name,
3770: 'OKS_CUST_PROD_DTLS_NOT_FOUND',
3771: 'CUSTOMER_PRODUCT',
3772: p_cpid
3773: );

Line 3864: x_return_status := okc_api.g_ret_sts_unexp_error;

3860: THEN
3861: x_return_status := l_return_status;
3862: WHEN OTHERS
3863: THEN
3864: x_return_status := okc_api.g_ret_sts_unexp_error;
3865: okc_api.set_message (g_app_name,
3866: g_unexpected_error,
3867: g_sqlcode_token,
3868: SQLCODE,

Line 3865: okc_api.set_message (g_app_name,

3861: x_return_status := l_return_status;
3862: WHEN OTHERS
3863: THEN
3864: x_return_status := okc_api.g_ret_sts_unexp_error;
3865: okc_api.set_message (g_app_name,
3866: g_unexpected_error,
3867: g_sqlcode_token,
3868: SQLCODE,
3869: g_sqlerrm_token,

Line 3984: x_return_status := okc_api.g_ret_sts_unexp_error;

3980: END LOOP;
3981: EXCEPTION
3982: WHEN OTHERS
3983: THEN
3984: x_return_status := okc_api.g_ret_sts_unexp_error;
3985: okc_api.set_message (g_app_name,
3986: g_unexpected_error,
3987: g_sqlcode_token,
3988: SQLCODE,

Line 3985: okc_api.set_message (g_app_name,

3981: EXCEPTION
3982: WHEN OTHERS
3983: THEN
3984: x_return_status := okc_api.g_ret_sts_unexp_error;
3985: okc_api.set_message (g_app_name,
3986: g_unexpected_error,
3987: g_sqlcode_token,
3988: SQLCODE,
3989: g_sqlerrm_token,

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

4033: AND LANGUAGE = USERENV('LANG');
4034:
4035: */
4036: i INTEGER := 0;
4037: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
4038: BEGIN
4039: x_return_status := l_return_status;
4040: i := 1;
4041:

Line 4057: x_return_status := okc_api.g_ret_sts_unexp_error;

4053: THEN
4054: x_return_status := l_return_status;
4055: WHEN OTHERS
4056: THEN
4057: x_return_status := okc_api.g_ret_sts_unexp_error;
4058:
4059: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4060: THEN
4061: fnd_log.STRING (fnd_log.level_unexpected,

Line 4068: okc_api.set_message (g_app_name,

4064: || SQLERRM
4065: );
4066: END IF;
4067:
4068: okc_api.set_message (g_app_name,
4069: g_unexpected_error,
4070: g_sqlcode_token,
4071: SQLCODE,
4072: g_sqlerrm_token,

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

4087: FROM oe_sales_credits
4088: WHERE header_id = p_order_hdr_id AND line_id IS NULL;
4089:
4090: i INTEGER := 0;
4091: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
4092: BEGIN
4093: x_return_status := l_return_status;
4094: i := 1;
4095:

Line 4111: x_return_status := okc_api.g_ret_sts_unexp_error;

4107: THEN
4108: x_return_status := l_return_status;
4109: WHEN OTHERS
4110: THEN
4111: x_return_status := okc_api.g_ret_sts_unexp_error;
4112:
4113: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4114: THEN
4115: fnd_log.STRING (fnd_log.level_unexpected,

Line 4122: okc_api.set_message (g_app_name,

4118: || SQLERRM
4119: );
4120: END IF;
4121:
4122: okc_api.set_message (g_app_name,
4123: g_unexpected_error,
4124: g_sqlcode_token,
4125: SQLCODE,
4126: g_sqlerrm_token,

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

4160: l_link_rec2 l_link_csr_b%ROWTYPE;
4161: l_codv_tbl_in oks_cod_pvt.codv_tbl_type;
4162: l_codv_tbl_out oks_cod_pvt.codv_tbl_type;
4163: l_link_to_order_id VARCHAR2 (40);
4164: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
4165: l_msg_count NUMBER;
4166: l_msg_data VARCHAR2 (2000);
4167: link_flag NUMBER := 0;
4168: BEGIN

Line 4190: okc_api.set_message (g_app_name,

4186: || p_order_line_id
4187: );
4188: END IF;
4189:
4190: okc_api.set_message (g_app_name,
4191: 'OKS_ORDER_DETAILS',
4192: 'ORDER_DETAILS',
4193: p_order_line_id
4194: );

Line 4234: IF NOT l_return_status = okc_api.g_ret_sts_success

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

Line 4278: IF NOT l_return_status = okc_api.g_ret_sts_success

4274: || ')'
4275: );
4276: END IF;
4277:
4278: IF NOT l_return_status = okc_api.g_ret_sts_success
4279: THEN
4280: x_return_status := l_return_status;
4281: RAISE g_exception_halt_validation;
4282: END IF;

Line 4293: x_return_status := okc_api.g_ret_sts_unexp_error;

4289: THEN
4290: x_return_status := l_return_status;
4291: WHEN OTHERS
4292: THEN
4293: x_return_status := okc_api.g_ret_sts_unexp_error;
4294: okc_api.set_message (g_app_name,
4295: g_unexpected_error,
4296: g_sqlcode_token,
4297: SQLCODE,

Line 4294: okc_api.set_message (g_app_name,

4290: x_return_status := l_return_status;
4291: WHEN OTHERS
4292: THEN
4293: x_return_status := okc_api.g_ret_sts_unexp_error;
4294: okc_api.set_message (g_app_name,
4295: g_unexpected_error,
4296: g_sqlcode_token,
4297: SQLCODE,
4298: g_sqlerrm_token,

Line 4385: okc_api.set_message (g_app_name,

4381: EXCEPTION
4382: WHEN OTHERS
4383: THEN
4384: x_return_status := 'U';
4385: okc_api.set_message (g_app_name,
4386: g_unexpected_error,
4387: g_sqlcode_token,
4388: SQLCODE,
4389: g_sqlerrm_token,

Line 4476: okc_api.set_message (g_app_name,

4472: EXCEPTION
4473: WHEN OTHERS
4474: THEN
4475: x_return_status := 'U';
4476: okc_api.set_message (g_app_name,
4477: g_unexpected_error,
4478: g_sqlcode_token,
4479: SQLCODE,
4480: g_sqlerrm_token,

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

4624: p_line_id NUMBER,
4625: x_return_status OUT NOCOPY VARCHAR2
4626: )
4627: IS
4628: l_return_status VARCHAR2 (3) := okc_api.g_ret_sts_success;
4629:
4630: CURSOR scredit_csr
4631: IS
4632: SELECT PERCENT, ctc_id, sales_credit_type_id1,

Line 4690: x_return_status := okc_api.g_ret_sts_unexp_error;

4686: THEN
4687: x_return_status := l_return_status;
4688: WHEN OTHERS
4689: THEN
4690: x_return_status := okc_api.g_ret_sts_unexp_error;
4691: okc_api.set_message (g_app_name,
4692: g_unexpected_error,
4693: g_sqlcode_token,
4694: SQLCODE,

Line 4691: okc_api.set_message (g_app_name,

4687: x_return_status := l_return_status;
4688: WHEN OTHERS
4689: THEN
4690: x_return_status := okc_api.g_ret_sts_unexp_error;
4691: okc_api.set_message (g_app_name,
4692: g_unexpected_error,
4693: g_sqlcode_token,
4694: SQLCODE,
4695: g_sqlerrm_token,

Line 4743: x_return_status := okc_api.g_ret_sts_success;

4739: l_cursor_id INTEGER;
4740: l_name VARCHAR2 (800) := NULL;
4741: l_delimiter VARCHAR2 (5);
4742: BEGIN
4743: x_return_status := okc_api.g_ret_sts_success;
4744:
4745: IF p_code = 'SERV'
4746: THEN
4747: l_structure_code := 'ORACLE_SERVICE_ITEM_FLEXFIELD';

Line 4817: x_return_status := okc_api.g_ret_sts_unexp_error;

4813: RETURN (l_name);
4814: EXCEPTION
4815: WHEN OTHERS
4816: THEN
4817: x_return_status := okc_api.g_ret_sts_unexp_error;
4818: okc_api.set_message (g_app_name,
4819: g_unexpected_error,
4820: g_sqlcode_token,
4821: SQLCODE,

Line 4818: okc_api.set_message (g_app_name,

4814: EXCEPTION
4815: WHEN OTHERS
4816: THEN
4817: x_return_status := okc_api.g_ret_sts_unexp_error;
4818: okc_api.set_message (g_app_name,
4819: g_unexpected_error,
4820: g_sqlcode_token,
4821: SQLCODE,
4822: g_sqlerrm_token,

Line 4863: x_return_status := okc_api.g_ret_sts_success;

4859: l_name VARCHAR2 (800) := NULL;
4860: l_desc VARCHAR2 (800) := NULL;
4861: l_delimiter VARCHAR2 (5);
4862: BEGIN
4863: x_return_status := okc_api.g_ret_sts_success;
4864:
4865: IF p_code = 'SERV'
4866: THEN
4867: l_structure_code := 'ORACLE_SERVICE_ITEM_FLEXFIELD';

Line 4943: x_return_status := okc_api.g_ret_sts_unexp_error;

4939: x_description := l_desc;
4940: EXCEPTION
4941: WHEN OTHERS
4942: THEN
4943: x_return_status := okc_api.g_ret_sts_unexp_error;
4944: x_name := NULL;
4945: x_description := NULL;
4946: okc_api.set_message (g_app_name,
4947: g_unexpected_error,

Line 4946: okc_api.set_message (g_app_name,

4942: THEN
4943: x_return_status := okc_api.g_ret_sts_unexp_error;
4944: x_name := NULL;
4945: x_description := NULL;
4946: okc_api.set_message (g_app_name,
4947: g_unexpected_error,
4948: g_sqlcode_token,
4949: SQLCODE,
4950: g_sqlerrm_token,

Line 5090: okc_api.set_message (g_app_name,

5086: END IF;
5087:
5088: IF l_salesrep_id IS NULL
5089: THEN
5090: okc_api.set_message (g_app_name,
5091: g_required_value,
5092: g_col_name_token,
5093: 'NO CONTACT FOUND FOR CONTRACT ID '
5094: || p_contract_id

Line 5108: okc_api.set_message (g_app_name,

5104: CLOSE l_get_source_csr;
5105:
5106: IF l_source_id IS NULL
5107: THEN
5108: okc_api.set_message (g_app_name,
5109: g_required_value,
5110: g_col_name_token,
5111: 'NO SOURCE FOUND FOR SALESREP ' || l_salesrep_id
5112: );

Line 5162: okc_api.set_message (g_app_name,

5158: x_return_status := 'E';
5159: WHEN OTHERS
5160: THEN
5161: x_return_status := 'U';
5162: okc_api.set_message (g_app_name,
5163: g_unexpected_error,
5164: g_sqlcode_token,
5165: SQLCODE,
5166: g_sqlerrm_token,

Line 5800: okc_api.set_message (g_app_name,

5796: ELSIF TRUNC (p_end_date) >= l_max_dt_billed_to
5797: THEN
5798: RETURN FALSE;
5799: ELSE ----TRUNC(p_end_date) < TRUNC(l_max_dt_billed_to)
5800: okc_api.set_message (g_app_name,
5801: 'OKS_BILLED_CHECK',
5802: 'MAX_BILLED_DATE',
5803: l_max_dt_billed_to
5804: );

Line 5812: --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'));

5808: IF l_max_dt_billed_to IS NULL
5809: THEN
5810: RETURN FALSE;
5811: ELSE
5812: --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'));
5813: okc_api.set_message (g_app_name, 'OKS_BA_UPDATE_NOT_ALLOWED');
5814: RETURN TRUE;
5815: END IF;
5816: END IF;

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

5809: THEN
5810: RETURN FALSE;
5811: ELSE
5812: --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'));
5813: okc_api.set_message (g_app_name, 'OKS_BA_UPDATE_NOT_ALLOWED');
5814: RETURN TRUE;
5815: END IF;
5816: END IF;
5817: EXCEPTION