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_OMINT_PUB dependencies on OKC_API

Line 17: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,

13:
14: Procedure Get_Duration
15: (
16: P_Api_Version IN Number,
17: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,
18: X_msg_Count OUT NOCOPY Number,
19: X_msg_Data OUT NOCOPY Varchar2,
20: X_Return_Status OUT NOCOPY Varchar2,
21: P_customer_id IN Number,

Line 25: P_coterm_checked_yn IN Varchar2 Default OKC_API.G_FALSE,

21: P_customer_id IN Number,
22: P_system_id IN Number,
23: P_Service_Duration IN Number,
24: P_service_period IN Varchar2,
25: P_coterm_checked_yn IN Varchar2 Default OKC_API.G_FALSE,
26: P_start_date IN Date,
27: P_end_date IN Date,
28: X_service_duration OUT NOCOPY Number,
29: X_service_period OUT NOCOPY Varchar2,

Line 36: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

32: Is
33: l_api_name CONSTANT VARCHAR2(30) := 'GET_DURATION';
34: l_api_version CONSTANT NUMBER := 11.5;
35: l_row_count NUMBER;
36: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
37:
38: Cursor l_Customer_Coterm_Csr is
39: Select Coterminate_Day_Month
40: From HZ_CUST_ACCOUNTS --OKX_CUSTOMER_ACCOUNTS_V

Line 74: x_return_status := OKC_API.G_RET_STS_SUCCESS;

70: l_unit_of_measure Varchar2(20);
71: l_tce_rec l_tce_csr%rowtype;
72: BEGIN
73:
74: x_return_status := OKC_API.G_RET_STS_SUCCESS;
75:
76: -- Profile Check
77: l_min_duration := fnd_profile.value('OKS_MINIMUM_SVC_DURATION');
78: l_min_period := fnd_profile.value('OKS_MINIMUM_SVC_PERIOD');

Line 84: l_return_status := OKC_API.G_RET_STS_ERROR;

80: If l_min_duration Is Null Or l_min_period Is Null Then
81: -- l_min_duration := 60;
82: -- l_min_period := 'DAY';
83:
84: l_return_status := OKC_API.G_RET_STS_ERROR;
85: OKC_API.set_message(G_APP_NAME,'OKS_PROFILE_NOT_SET');
86: Raise G_EXCEPTION_HALT_VALIDATION;
87:
88: End If;

Line 85: OKC_API.set_message(G_APP_NAME,'OKS_PROFILE_NOT_SET');

81: -- l_min_duration := 60;
82: -- l_min_period := 'DAY';
83:
84: l_return_status := OKC_API.G_RET_STS_ERROR;
85: OKC_API.set_message(G_APP_NAME,'OKS_PROFILE_NOT_SET');
86: Raise G_EXCEPTION_HALT_VALIDATION;
87:
88: End If;
89:

Line 93: l_return_status := OKC_API.G_RET_STS_ERROR;

89:
90: -- Parameter Check
91:
92: If p_start_date Is Null Then
93: l_return_status := OKC_API.G_RET_STS_ERROR;
94: OKC_API.set_message(G_APP_NAME,'OKS_START_DATE_REQUIRED');
95: Raise G_EXCEPTION_HALT_VALIDATION;
96: End If;
97:

Line 94: OKC_API.set_message(G_APP_NAME,'OKS_START_DATE_REQUIRED');

90: -- Parameter Check
91:
92: If p_start_date Is Null Then
93: l_return_status := OKC_API.G_RET_STS_ERROR;
94: OKC_API.set_message(G_APP_NAME,'OKS_START_DATE_REQUIRED');
95: Raise G_EXCEPTION_HALT_VALIDATION;
96: End If;
97:
98: If p_end_date Is Null And (p_service_duration Is Null Or p_service_period Is Null) Then

Line 99: l_return_status := OKC_API.G_RET_STS_ERROR;

95: Raise G_EXCEPTION_HALT_VALIDATION;
96: End If;
97:
98: If p_end_date Is Null And (p_service_duration Is Null Or p_service_period Is Null) Then
99: l_return_status := OKC_API.G_RET_STS_ERROR;
100: OKC_API.set_message(G_APP_NAME,'OKS_END_DT_DUR_REQUIRED');
101: Raise G_EXCEPTION_HALT_VALIDATION;
102: End If;
103:

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

96: End If;
97:
98: If p_end_date Is Null And (p_service_duration Is Null Or p_service_period Is Null) Then
99: l_return_status := OKC_API.G_RET_STS_ERROR;
100: OKC_API.set_message(G_APP_NAME,'OKS_END_DT_DUR_REQUIRED');
101: Raise G_EXCEPTION_HALT_VALIDATION;
102: End If;
103:
104: If p_Service_Duration Is Not Null Then

Line 108: l_return_status := OKC_API.G_RET_STS_ERROR;

104: If p_Service_Duration Is Not Null Then
105: Open l_UOM_Csr;
106: Fetch l_UOM_Csr Into l_UOM_Rec;
107: If l_UOM_Csr%NotFound Then
108: l_return_status := OKC_API.G_RET_STS_ERROR;
109: OKC_API.set_message(G_APP_NAME,'OKS_INVD_PERIOD');
110: Raise G_EXCEPTION_HALT_VALIDATION;
111: End if;
112: l_unit_of_measure := l_uom_rec.uom_code;

Line 109: OKC_API.set_message(G_APP_NAME,'OKS_INVD_PERIOD');

105: Open l_UOM_Csr;
106: Fetch l_UOM_Csr Into l_UOM_Rec;
107: If l_UOM_Csr%NotFound Then
108: l_return_status := OKC_API.G_RET_STS_ERROR;
109: OKC_API.set_message(G_APP_NAME,'OKS_INVD_PERIOD');
110: Raise G_EXCEPTION_HALT_VALIDATION;
111: End if;
112: l_unit_of_measure := l_uom_rec.uom_code;
113: End If;

Line 165: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

161: x_timeunit => x_service_period,
162: x_return_status => l_return_status
163: );
164:
165: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then
166: Raise G_EXCEPTION_HALT_VALIDATION;
167: End if;
168: Else
169:

Line 229: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

225: x_return_status => l_return_status
226: );
227:
228:
229: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then
230: Raise G_EXCEPTION_HALT_VALIDATION;
231: End If;
232:
233: End if;

Line 240: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

236:
237: When G_EXCEPTION_HALT_VALIDATION Then
238: x_return_status := l_return_status;
239: When Others Then
240: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
241: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
242:
243: END;
244:

Line 241: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

237: When G_EXCEPTION_HALT_VALIDATION Then
238: x_return_status := l_return_status;
239: When Others Then
240: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
241: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
242:
243: END;
244:
245:

Line 249: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,

245:
246: Procedure Is_service_available
247: (
248: P_Api_Version IN Number,
249: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,
250: X_msg_Count OUT NOCOPY Number,
251: X_msg_Data OUT NOCOPY Varchar2,
252: X_Return_Status OUT NOCOPY Varchar2,
253: p_check_service_rec IN CHECK_SERVICE_REC_TYPE,

Line 263: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

259: Is
260: l_api_name CONSTANT VARCHAR2(30) := 'GET_DURATION';
261: l_api_version CONSTANT NUMBER := 11.5;
262: l_row_count NUMBER;
263: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
264:
265: --Local
266: l_first Boolean := TRUE;
267: l_pstat Boolean;

Line 569: l_return_status := OKC_API.G_RET_STS_ERROR;

565: --end 4897884
566:
567: If p_check_service_rec.Service_Item_id Is Null
568: Or (p_check_service_rec.Customer_id Is Null and l_product_item_id Is Null) Then
569: l_return_status := OKC_API.G_RET_STS_ERROR;
570: x_available_yn := 'N';
571: OKC_API.set_message(G_APP_NAME, 'OKS_MISSING_REQUIRED_PARAMETERS');
572: Raise G_EXCEPTION_HALT_VALIDATION;
573: End If;

Line 571: OKC_API.set_message(G_APP_NAME, 'OKS_MISSING_REQUIRED_PARAMETERS');

567: If p_check_service_rec.Service_Item_id Is Null
568: Or (p_check_service_rec.Customer_id Is Null and l_product_item_id Is Null) Then
569: l_return_status := OKC_API.G_RET_STS_ERROR;
570: x_available_yn := 'N';
571: OKC_API.set_message(G_APP_NAME, 'OKS_MISSING_REQUIRED_PARAMETERS');
572: Raise G_EXCEPTION_HALT_VALIDATION;
573: End If;
574: /****** Added to check whether Item is servicable or not ****/
575:

Line 583: l_return_status := OKC_API.G_RET_STS_SUCCESS;

579: Fetch l_model_item_csr Into l_model_flag;
580: Close l_model_item_csr;
581:
582: If l_model_flag = 'Y' then
583: l_return_status := OKC_API.G_RET_STS_SUCCESS;
584: x_available_yn := 'Y';
585: Raise G_EXCEPTION_HALT_VALIDATION;
586: End If;
587: */

Line 599: l_return_status := OKC_API.G_RET_STS_ERROR;

595: Fetch l_servicable_prod_csr Into l_servicable_flag_yn;
596: Close l_servicable_prod_csr;
597:
598: IF NVL(l_servicable_flag_yn,'N') = 'N' THEN
599: l_return_status := OKC_API.G_RET_STS_ERROR;
600: x_available_yn := 'N';
601: OKC_API.set_message(G_APP_NAME, 'OKS_PRODUCT_NOT_SERVICABLE');
602: Raise G_EXCEPTION_HALT_VALIDATION;
603: END IF;

Line 601: OKC_API.set_message(G_APP_NAME, 'OKS_PRODUCT_NOT_SERVICABLE');

597:
598: IF NVL(l_servicable_flag_yn,'N') = 'N' THEN
599: l_return_status := OKC_API.G_RET_STS_ERROR;
600: x_available_yn := 'N';
601: OKC_API.set_message(G_APP_NAME, 'OKS_PRODUCT_NOT_SERVICABLE');
602: Raise G_EXCEPTION_HALT_VALIDATION;
603: END IF;
604: End If;
605:

Line 645: OKC_API.set_message(G_APP_NAME,'OKS_PARTY_ID_NOT_FOUND','CUSTOMER_ID',to_char(p_check_service_rec.customer_id));

641:
642: If l_party_id IS Null Then
643: l_return_status := 'E';
644: x_available_yn := 'N';
645: OKC_API.set_message(G_APP_NAME,'OKS_PARTY_ID_NOT_FOUND','CUSTOMER_ID',to_char(p_check_service_rec.customer_id));
646: Raise G_EXCEPTION_HALT_VALIDATION;
647: End If;
648:
649: Customer(l_party_id, l_cstat);

Line 701: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

697: mo_global.set_policy_context(l_original_access_mode,l_original_org_id);
698: --END NPALEPU */
699: --end 4897884
700: When Others Then
701: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
702: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
703: --npalepu 23-dec-2005 removed the code for bug # 4897884
704: /* --NPALEPU 29-sep-2005 for bug # 4608694
705: --Resetting th eoriginal context

Line 702: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

698: --END NPALEPU */
699: --end 4897884
700: When Others Then
701: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
702: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
703: --npalepu 23-dec-2005 removed the code for bug # 4897884
704: /* --NPALEPU 29-sep-2005 for bug # 4608694
705: --Resetting th eoriginal context
706: mo_global.set_policy_context(l_original_access_mode,l_original_org_id);

Line 716: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,

712:
713: Procedure Available_Services
714: (
715: P_Api_Version IN Number,
716: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,
717: X_msg_Count OUT NOCOPY Number,
718: X_msg_Data OUT NOCOPY Varchar2,
719: X_Return_Status OUT NOCOPY Varchar2,
720: p_avail_service_rec IN AVAIL_SERVICE_REC_TYPE,

Line 760: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

756: l_api_name CONSTANT VARCHAR2(30) := 'GET_DURATION';
757: l_api_version CONSTANT NUMBER := 11.5;
758: l_row_count NUMBER;
759: l_msg_data VARCHAR2(2000);
760: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
761: l_ptr Binary_Integer := 0 ;
762: l_avail Varchar2(1);
763: l_isrec Check_service_rec_type;
764: l_Srv_tbl order_service_tbl_type;

Line 827: OKC_API.set_message(G_APP_NAME,'OKS_PARTY_ID_NOT_FOUND','CUSTOMER_ID',to_char(p_avail_service_rec.customer_id));

823: Close l_party_csr;
824:
825: If l_party_id IS Null Then
826: l_return_status := 'E';
827: OKC_API.set_message(G_APP_NAME,'OKS_PARTY_ID_NOT_FOUND','CUSTOMER_ID',to_char(p_avail_service_rec.customer_id));
828: Raise G_EXCEPTION_HALT_VALIDATION;
829: End If;
830:
831: End If;

Line 851: OKC_API.G_FALSE,

847: --npalepu modified on 20-nov-2005
848: /* Is_Service_Available
849: (
850: 1.0,
851: OKC_API.G_FALSE,
852: l_row_count,
853: l_msg_Data,
854: l_Return_Status,
855: l_isrec,

Line 861: P_init_msg_list => OKC_API.G_FALSE,

857: ); */
858: Is_Service_Available
859: (
860: P_Api_Version => 1.0,
861: P_init_msg_list => OKC_API.G_FALSE,
862: X_msg_Count => l_row_count,
863: X_msg_Data => l_msg_Data,
864: X_Return_Status => l_Return_Status,
865: p_check_service_rec => l_isrec,

Line 870: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

866: X_Available_YN => l_Avail
867: );
868: --end npalepu
869:
870: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then
871: Raise G_EXCEPTION_HALT_VALIDATION;
872: End If;
873:
874:

Line 882: x_return_status := OKC_API.G_RET_STS_SUCCESS;

878: End If;
879:
880: End Loop;
881:
882: x_return_status := OKC_API.G_RET_STS_SUCCESS;
883:
884: --npalepu removed the following code for bug # 4897884
885: /* --NPALEPU 21-sep-2005 for bug # 4608694
886: --Resetting to original context

Line 903: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

899: mo_global.set_policy_context(l_original_access_mode,l_original_org_id);
900: --END NPALEPU */
901: --end 4897884
902: When Others Then
903: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
904: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
905: --npalepu removed the following code for bug # 4897884
906: /* --NPALEPU 21-sep-2005 for bug # 4608694
907: --Resetting to original context

Line 904: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

900: --END NPALEPU */
901: --end 4897884
902: When Others Then
903: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
904: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
905: --npalepu removed the following code for bug # 4897884
906: /* --NPALEPU 21-sep-2005 for bug # 4608694
907: --Resetting to original context
908: mo_global.set_policy_context(l_original_access_mode,l_original_org_id);

Line 917: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,

913:
914: Procedure OKS_Available_Services
915: (
916: P_Api_Version IN Number,
917: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,
918: X_msg_Count OUT NOCOPY Number,
919: X_msg_Data OUT NOCOPY Varchar2,
920: X_Return_Status OUT NOCOPY Varchar2,
921: p_avail_service_rec IN AVAIL_SERVICE_REC_TYPE,

Line 963: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

959: l_api_name CONSTANT VARCHAR2(30) := 'GET_DURATION';
960: l_api_version CONSTANT NUMBER := 11.5;
961: l_row_count NUMBER;
962: l_msg_data VARCHAR2(2000);
963: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
964: l_ptr Binary_Integer := 0 ;
965: l_avail Varchar2(1);
966: l_isrec Check_service_rec_type;
967: l_Srv_tbl order_service_tbl_type;

Line 994: OKC_API.set_message(G_APP_NAME,'OKS_PARTY_ID_NOT_FOUND','CUSTOMER_ID',to_char(p_check_service_rec.customer_id));

990: Close l_party_csr;
991:
992: If l_party_id IS Null Then
993: l_return_status := 'E';
994: OKC_API.set_message(G_APP_NAME,'OKS_PARTY_ID_NOT_FOUND','CUSTOMER_ID',to_char(p_check_service_rec.customer_id));
995: Raise G_EXCEPTION_HALT_VALIDATION;
996: End If;
997:
998: End If;

Line 1055: OKC_API.G_FALSE,

1051: --npalepu modified on 20-nov-2005
1052: /* Is_Service_Available
1053: (
1054: 1.0,
1055: OKC_API.G_FALSE,
1056: l_row_count,
1057: l_msg_Data,
1058: l_Return_Status,
1059: l_isrec,

Line 1065: P_init_msg_list => OKC_API.G_FALSE,

1061: ); */
1062: Is_Service_Available
1063: (
1064: P_Api_Version => 1.0,
1065: P_init_msg_list => OKC_API.G_FALSE,
1066: X_msg_Count => l_row_count,
1067: X_msg_Data => l_msg_Data,
1068: X_Return_Status => l_Return_Status,
1069: p_check_service_rec => l_isrec,

Line 1074: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

1070: X_Available_YN => l_Avail
1071: );
1072: --end npalepu
1073:
1074: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then
1075: Raise G_EXCEPTION_HALT_VALIDATION;
1076: End If;
1077:
1078:

Line 1090: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1086: End If;
1087:
1088: End Loop;
1089:
1090: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1091:
1092: --npalepu removed the following code for bug # 4897884
1093: /* --NPALEPU 21-sep-2005 for bug # 4608694
1094: --Resetting to original context

Line 1111: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1107: --END NPALEPU */
1108: --end 4897884
1109:
1110: When Others Then
1111: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1112: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1113: --npalepu removed the following code for bug # 4897884
1114: /* --NPALEPU 21-sep-2005 for bug # 4608694
1115: --Resetting to original context

Line 1112: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

1108: --end 4897884
1109:
1110: When Others Then
1111: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1112: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1113: --npalepu removed the following code for bug # 4897884
1114: /* --NPALEPU 21-sep-2005 for bug # 4608694
1115: --Resetting to original context
1116: mo_global.set_policy_context(l_original_access_mode,l_original_org_id);

Line 1127: ,p_init_msg_list IN Varchar2 Default OKC_API.G_FALSE

1123: (p_api_version IN Number
1124: ,p_party_id IN Number
1125: ,p_service_id IN Number
1126: ,p_request_date IN Date Default sysdate
1127: ,p_init_msg_list IN Varchar2 Default OKC_API.G_FALSE
1128: ,x_available_yn OUT NOCOPY Varchar2
1129: ,x_msg_Count OUT NOCOPY Number
1130: ,x_msg_Data OUT NOCOPY Varchar2
1131: ,x_return_status OUT NOCOPY Varchar2)

Line 1162: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1158:
1159:
1160: BEGIN
1161: -- initialize return status
1162: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1163: If p_Service_id Is Null Or p_party_id Is Null Then
1164: x_return_status := OKC_API.G_RET_STS_ERROR;
1165: OKC_API.set_message(G_APP_NAME, 'OKS_MISSING_REQUIRED_PARAMETERS');
1166: Raise G_EXCEPTION_HALT_VALIDATION;

Line 1164: x_return_status := OKC_API.G_RET_STS_ERROR;

1160: BEGIN
1161: -- initialize return status
1162: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1163: If p_Service_id Is Null Or p_party_id Is Null Then
1164: x_return_status := OKC_API.G_RET_STS_ERROR;
1165: OKC_API.set_message(G_APP_NAME, 'OKS_MISSING_REQUIRED_PARAMETERS');
1166: Raise G_EXCEPTION_HALT_VALIDATION;
1167: End If;
1168:

Line 1165: OKC_API.set_message(G_APP_NAME, 'OKS_MISSING_REQUIRED_PARAMETERS');

1161: -- initialize return status
1162: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1163: If p_Service_id Is Null Or p_party_id Is Null Then
1164: x_return_status := OKC_API.G_RET_STS_ERROR;
1165: OKC_API.set_message(G_APP_NAME, 'OKS_MISSING_REQUIRED_PARAMETERS');
1166: Raise G_EXCEPTION_HALT_VALIDATION;
1167: End If;
1168:
1169: Open l_service_csr ('C');

Line 1230: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1226:
1227: End If;
1228: End If;
1229: Close l_service_csr;
1230: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1231:
1232:
1233: Exception
1234:

Line 1240: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1236: Close l_service_csr;
1237: Null;
1238: When Others Then
1239: x_available_yn := 'N';
1240: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1241: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1242:
1243: END Is_service_available;
1244:

Line 1241: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

1237: Null;
1238: When Others Then
1239: x_available_yn := 'N';
1240: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1241: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1242:
1243: END Is_service_available;
1244:
1245:

Line 1248: ,p_init_msg_list IN Varchar2 Default OKC_API.G_FALSE

1244:
1245:
1246: Procedure Delete_Contract_details
1247: ( p_api_version IN Number
1248: ,p_init_msg_list IN Varchar2 Default OKC_API.G_FALSE
1249: ,p_order_line_id IN Number
1250: ,x_msg_Count OUT NOCOPY Number
1251: ,x_msg_Data OUT NOCOPY Varchar2
1252: ,x_return_status OUT NOCOPY Varchar2)

Line 1257: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1253: Is
1254:
1255: l_api_name CONSTANT VARCHAR2(30) := 'GET_DURATION';
1256: l_api_version CONSTANT NUMBER := 11.5;
1257: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1258: l_msg_count Number;
1259: l_msg_data Varchar(2000);
1260: l_line_id Number := Null;
1261: l_coc_tbl_in Oks_coc_pvt.cocv_tbl_type;

Line 1315: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

1311: ,P_cocv_tbl => l_coc_tbl_in
1312:
1313: );
1314:
1315: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then
1316: Raise G_EXCEPTION_HALT_VALIDATION;
1317: End If;
1318: End Loop;
1319:

Line 1331: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

1327: ,X_msg_data => l_msg_data
1328: ,P_codv_tbl => l_cod_tbl_in
1329: );
1330:
1331: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then
1332: Raise G_EXCEPTION_HALT_VALIDATION;
1333: End If;
1334: End Loop;
1335:

Line 1351: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

1347: ,P_cocv_tbl => l_coc_tbl_in
1348:
1349: );
1350:
1351: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then
1352: Raise G_EXCEPTION_HALT_VALIDATION;
1353: End If;
1354: End Loop;
1355:

Line 1367: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

1363: ,X_msg_data => l_msg_data
1364: ,P_codv_tbl => l_cod_tbl_in
1365: );
1366:
1367: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then
1368: Raise G_EXCEPTION_HALT_VALIDATION;
1369: End If;
1370:
1371:

Line 1384: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1380: Exception
1381: When G_EXCEPTION_HALT_VALIDATION Then
1382: x_return_status := l_return_status;
1383: When Others Then
1384: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1385: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1386:
1387: END Delete_Contract_details;
1388:

Line 1385: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

1381: When G_EXCEPTION_HALT_VALIDATION Then
1382: x_return_status := l_return_status;
1383: When Others Then
1384: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1385: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1386:
1387: END Delete_Contract_details;
1388:
1389:

Line 1437: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1433: From csi_item_instances csi
1434: Where csi.instance_id = p_cp_id;
1435:
1436:
1437: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1438: l_cp_rec l_cp_csr%rowtype;
1439: l_line_rec l_oline_csr%rowtype;
1440: l_install_date Date;
1441: l_ship_date Date;

Line 1451: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1447:
1448: l_line_rec := Null;
1449: l_cp_rec := Null;
1450:
1451: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1452: x_return_status := l_return_status;
1453: Open l_oline_csr;
1454: Fetch l_oline_csr into l_line_rec;
1455: Close l_oline_csr;

Line 1464: OKC_API.set_message(G_APP_NAME,'OKS_NULL_SDT','LINE_ID',p_order_line_id);

1460: Close l_cp_csr;
1461:
1462: If l_cp_rec.instance_id Is Null Then
1463: l_return_status := 'E';
1464: OKC_API.set_message(G_APP_NAME,'OKS_NULL_SDT','LINE_ID',p_order_line_id);
1465: Raise G_EXCEPTION_HALT_VALIDATION;
1466: End If;
1467: l_warend_date := Null;
1468: Open l_get_warr_dates_csr(l_cp_rec.instance_id);

Line 1502: OKC_API.set_message(G_APP_NAME,'OKS_NULL_SDT','LINE_ID',p_order_line_id);

1498:
1499: End If;
1500: If X_start_date Is Null Then
1501: l_return_status := 'E';
1502: OKC_API.set_message(G_APP_NAME,'OKS_NULL_SDT','LINE_ID',p_order_line_id);
1503: Raise G_EXCEPTION_HALT_VALIDATION;
1504: End If;
1505: X_end_date := okc_time_util_pub.get_enddate
1506: ( X_Start_Date

Line 1517: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1513: Exception
1514: When G_EXCEPTION_HALT_VALIDATION Then
1515: x_return_status := l_return_status;
1516: When Others Then
1517: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1518: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1519:
1520:
1521:

Line 1518: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

1514: When G_EXCEPTION_HALT_VALIDATION Then
1515: x_return_status := l_return_status;
1516: When Others Then
1517: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1518: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1519:
1520:
1521:
1522: End;

Line 1709: IF l_status = OKC_API.G_RET_STS_ERROR

1705: END IF;
1706: --Addition Ends
1707:
1708:
1709: IF l_status = OKC_API.G_RET_STS_ERROR
1710: THEN
1711: return 0;
1712: END IF;
1713:

Line 1731: OKC_API.set_message('OKS','OKS_INVD_UOM_CODE');

1727: EXCEPTION
1728: WHEN
1729: INVALID_UOM_EXCEPTION
1730: THEN
1731: OKC_API.set_message('OKS','OKS_INVD_UOM_CODE');
1732: close cs_validate_uom;
1733: return 0;
1734: WHEN
1735: INVALID_DATE_EXCEPTION

Line 1737: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');

1733: return 0;
1734: WHEN
1735: INVALID_DATE_EXCEPTION
1736: THEN
1737: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');
1738: return 0;
1739: WHEN OTHERS THEN
1740: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1741: return 0;

Line 1740: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

1736: THEN
1737: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');
1738: return 0;
1739: WHEN OTHERS THEN
1740: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1741: return 0;
1742:
1743: END get_quantity;
1744:

Line 1873: IF l_return_status = OKC_API.G_RET_STS_ERROR

1869: x_period_type => l_period_type,
1870: x_period_start => l_period_start,
1871: x_price_uom => l_price_uom,
1872: x_return_status => l_return_status);
1873: IF l_return_status = OKC_API.G_RET_STS_ERROR
1874: THEN
1875: return 0;
1876: END IF;
1877:

Line 1953: OKC_API.set_message('OKS','OKS_INVD_DURATION');

1949: END IF;
1950:
1951: END IF;
1952: ELSE --none of two sets of parameters are passed so set the error message and return 0
1953: OKC_API.set_message('OKS','OKS_INVD_DURATION');
1954: return 0;
1955: END IF;
1956: END IF;
1957: return(l_target_qty);

Line 1963: OKC_API.set_message('OKS','OKS_INVD_UOM_CODE');

1959: EXCEPTION
1960: WHEN
1961: INVALID_UOM_EXCEPTION
1962: THEN
1963: OKC_API.set_message('OKS','OKS_INVD_UOM_CODE');
1964: close cs_validate_uom;
1965: return 0;
1966: WHEN
1967: G_EXCEPTION_HALT_VALIDATION

Line 1973: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');

1969: return 0;
1970: WHEN
1971: INVALID_DATE_EXCEPTION
1972: THEN
1973: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');
1974: return 0;
1975: WHEN OTHERS THEN
1976: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1977: return 0;

Line 1976: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

1972: THEN
1973: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');
1974: return 0;
1975: WHEN OTHERS THEN
1976: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1977: return 0;
1978:
1979: END get_target_duration;
1980:

Line 1989: P_init_msg_list IN VARCHAR2 Default OKC_API.G_FALSE,

1985:
1986: PROCEDURE Available_Services
1987: (
1988: P_Api_Version IN NUMBER,
1989: P_init_msg_list IN VARCHAR2 Default OKC_API.G_FALSE,
1990: P_search_input IN VARCHAR2 Default OKC_API.G_MISS_CHAR,
1991: P_MAX_ROWS_RETURNED IN NUMBER Default 200,
1992: X_msg_Count OUT NOCOPY NUMBER,
1993: X_msg_Data OUT NOCOPY VARCHAR2,

Line 1990: P_search_input IN VARCHAR2 Default OKC_API.G_MISS_CHAR,

1986: PROCEDURE Available_Services
1987: (
1988: P_Api_Version IN NUMBER,
1989: P_init_msg_list IN VARCHAR2 Default OKC_API.G_FALSE,
1990: P_search_input IN VARCHAR2 Default OKC_API.G_MISS_CHAR,
1991: P_MAX_ROWS_RETURNED IN NUMBER Default 200,
1992: X_msg_Count OUT NOCOPY NUMBER,
1993: X_msg_Data OUT NOCOPY VARCHAR2,
1994: X_Return_Status OUT NOCOPY VARCHAR2,

Line 2111: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2107: l_api_name CONSTANT VARCHAR2(30) := 'GET_DURATION';
2108: l_api_version CONSTANT NUMBER := 11.5;
2109: l_row_count NUMBER;
2110: l_msg_data VARCHAR2(2000);
2111: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2112: l_ptr Binary_Integer := 0 ;
2113: l_avail Varchar2(1);
2114: l_isrec Check_service_rec_type;
2115: l_found BOOLEAN;

Line 2180: OKC_API.set_message(G_APP_NAME,'OKS_PARTY_ID_NOT_FOUND','CUSTOMER_ID',to_char(p_avail_service_rec.customer_id));

2176: Close l_party_csr;
2177:
2178: If l_party_id IS Null Then
2179: l_return_status := 'E';
2180: OKC_API.set_message(G_APP_NAME,'OKS_PARTY_ID_NOT_FOUND','CUSTOMER_ID',to_char(p_avail_service_rec.customer_id));
2181: Raise G_EXCEPTION_HALT_VALIDATION;
2182: End If; /*IF */
2183:
2184: End If; /*IF */

Line 2186: IF ((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL)) THEN

2182: End If; /*IF */
2183:
2184: End If; /*IF */
2185:
2186: IF ((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL)) THEN
2187: --npalepu modified on 23-dec-2005 for bug # 4897884
2188: /* OPEN l_service_csr1; */
2189: OPEN l_service_csr1(l_organization_id);
2190: --end 4897884

Line 2196: End IF;/IF <((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL))> /

2192: --npalepu modified on 23-dec-2005 for bug # 4897884
2193: /* OPEN l_service_csr; */
2194: OPEN l_service_csr(l_organization_id);
2195: --end 4897884
2196: End IF;/*IF <((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL))> */
2197:
2198: LOOP
2199: IF ((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL)) THEN
2200: FETCH l_service_csr1 BULK COLLECT INTO l_Srv_tbl LIMIT 1000;

Line 2199: IF ((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL)) THEN

2195: --end 4897884
2196: End IF;/*IF <((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL))> */
2197:
2198: LOOP
2199: IF ((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL)) THEN
2200: FETCH l_service_csr1 BULK COLLECT INTO l_Srv_tbl LIMIT 1000;
2201: ELSE
2202: FETCH l_service_csr BULK COLLECT INTO l_Srv_tbl LIMIT 1000;
2203: END IF; /*IF <((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL))> */

Line 2203: END IF; /IF <((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL))> /

2199: IF ((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL)) THEN
2200: FETCH l_service_csr1 BULK COLLECT INTO l_Srv_tbl LIMIT 1000;
2201: ELSE
2202: FETCH l_service_csr BULK COLLECT INTO l_Srv_tbl LIMIT 1000;
2203: END IF; /*IF <((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL))> */
2204:
2205: IF l_Srv_tbl.count > 0 THEN
2206: l_index := l_Srv_tbl.FIRST;
2207:

Line 2221: OKC_API.G_FALSE,

2217: --npalepu modified on 20-nov-2005
2218: /* Is_Service_Available
2219: (
2220: 1.0,
2221: OKC_API.G_FALSE,
2222: l_row_count,
2223: l_msg_Data,
2224: l_Return_Status,
2225: l_isrec,

Line 2231: P_init_msg_list => OKC_API.G_FALSE,

2227: ); */
2228: Is_Service_Available
2229: (
2230: P_Api_Version => 1.0,
2231: P_init_msg_list => OKC_API.G_FALSE,
2232: X_msg_Count => l_row_count,
2233: X_msg_Data => l_msg_Data,
2234: X_Return_Status => l_Return_Status,
2235: p_check_service_rec => l_isrec,

Line 2240: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

2236: X_Available_YN => l_Avail
2237: );
2238: --end npalepu
2239:
2240: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then
2241: Raise G_EXCEPTION_HALT_VALIDATION;
2242: End If;
2243:
2244: IF (l_ptr >= P_MAX_ROWS_RETURNED) THEN

Line 2277: If ((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL)) then

2273: l_outer_loop_exit := 'N';
2274: Exit;
2275: END IF; /*IF <(l_outer_loop_exit = 'Y')> */
2276:
2277: If ((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL)) then
2278: Exit When l_service_csr1%NOTFound;
2279: ELSE
2280: Exit When l_service_csr%NOTFound;
2281: End If; /*IF <((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL))> */

Line 2281: End If; /IF <((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL))> /

2277: If ((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL)) then
2278: Exit When l_service_csr1%NOTFound;
2279: ELSE
2280: Exit When l_service_csr%NOTFound;
2281: End If; /*IF <((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL))> */
2282:
2283: END LOOP;/*End of Outer Loop */
2284:
2285: If ((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL)) then

Line 2285: If ((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL)) then

2281: End If; /*IF <((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL))> */
2282:
2283: END LOOP;/*End of Outer Loop */
2284:
2285: If ((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL)) then
2286: CLOSE l_service_csr1;
2287: ELSE
2288: CLOSE l_service_csr;
2289: End If; /*IF <((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL))> */

Line 2289: End If; /IF <((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL))> /

2285: If ((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL)) then
2286: CLOSE l_service_csr1;
2287: ELSE
2288: CLOSE l_service_csr;
2289: End If; /*IF <((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL))> */
2290:
2291: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2292:
2293: --npalepu removed the code for bug # 4897884

Line 2291: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2287: ELSE
2288: CLOSE l_service_csr;
2289: End If; /*IF <((P_search_input = OKC_API.G_MISS_CHAR) OR (P_search_input IS NULL))> */
2290:
2291: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2292:
2293: --npalepu removed the code for bug # 4897884
2294: /* --NPALEPU 21-sep-2005 for bug # 4608694
2295: --Resetting to original context

Line 2315: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2311: mo_global.set_policy_context(l_original_access_mode,l_original_org_id);
2312: --END NPALEPU */
2313: --end 4897884
2314: When Others Then
2315: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2316: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
2317: IF (l_service_csr1%ISOPEN) THEN
2318: CLOSE l_service_csr1;
2319: ELSIF (l_service_csr%ISOPEN) THEN

Line 2316: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

2312: --END NPALEPU */
2313: --end 4897884
2314: When Others Then
2315: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2316: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
2317: IF (l_service_csr1%ISOPEN) THEN
2318: CLOSE l_service_csr1;
2319: ELSIF (l_service_csr%ISOPEN) THEN
2320: CLOSE l_service_csr;