DBA Data[Home] [Help]

APPS.OKS_CON_COVERAGE_PVT dependencies on OKC_API

Line 72: OKC_API.SET_MESSAGE

68: IF Lx_Csr_BPL%ISOPEN THEN
69: CLOSE Lx_Csr_BPL;
70: END IF;
71:
72: OKC_API.SET_MESSAGE
73: (P_App_Name => G_APP_NAME
74: ,P_Msg_Name => G_UNEXPECTED_ERROR
75: ,P_Token1 => G_SQLCODE_TOKEN
76: ,P_Token1_Value => SQLCODE

Line 115: OKC_API.SET_MESSAGE

111: EXCEPTION
112:
113: WHEN OTHERS THEN
114:
115: OKC_API.SET_MESSAGE
116: (P_App_Name => G_APP_NAME
117: ,P_Msg_Name => G_UNEXPECTED_ERROR
118: ,P_Token1 => G_SQLCODE_TOKEN
119: ,P_Token1_Value => SQLCODE

Line 316: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

312: j := j + 1;
313: END LOOP;
314: EXCEPTION
315: WHEN OTHERS THEN
316: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
317: ,p_msg_name => G_UNEXPECTED_ERROR
318: ,p_token1 => G_SQLCODE_TOKEN
319: ,p_token1_value => SQLcode
320: ,p_token2 => G_SQLERRM_TOKEN

Line 323: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

319: ,p_token1_value => SQLcode
320: ,p_token2 => G_SQLERRM_TOKEN
321: ,p_token2_value => SQLerrm);
322:
323: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
324: END populate_return_table;
325:
326: PROCEDURE populate_bt_table(x_return_status OUT NOCOPY Varchar2,
327: p_txngrp_id IN Number,

Line 528: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

524: END IF;
525:
526: EXCEPTION
527: WHEN OTHERS THEN
528: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
529: ,p_msg_name => G_UNEXPECTED_ERROR
530: ,p_token1 => G_SQLCODE_TOKEN
531: ,p_token1_value => SQLcode
532: ,p_token2 => G_SQLERRM_TOKEN

Line 535: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

531: ,p_token1_value => SQLcode
532: ,p_token2 => G_SQLERRM_TOKEN
533: ,p_token2_value => SQLerrm);
534:
535: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
536: END populate_bt_table;
537:
538: PROCEDURE populate_work_table(x_return_status OUT NOCOPY Varchar2,
539: p_as_tbl IN ser_tbl_type,

Line 574: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

570: j := j + 1;
571: END LOOP;
572: EXCEPTION
573: WHEN OTHERS THEN
574: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
575: ,p_msg_name => G_UNEXPECTED_ERROR
576: ,p_token1 => G_SQLCODE_TOKEN
577: ,p_token1_value => SQLcode
578: ,p_token2 => G_SQLERRM_TOKEN

Line 581: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

577: ,p_token1_value => SQLcode
578: ,p_token2 => G_SQLERRM_TOKEN
579: ,p_token2_value => SQLerrm);
580:
581: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
582: END populate_work_table;
583:
584: PROCEDURE apply_contract_coverage
585: (p_api_version IN Number

Line 738: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

734: EXCEPTION
735: WHEN G_EXCEPTION_HALT_VALIDATION THEN
736: Null;
737: WHEN OTHERS THEN
738: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
739: ,p_msg_name => G_UNEXPECTED_ERROR
740: ,p_token1 => G_SQLCODE_TOKEN
741: ,p_token1_value => SQLcode
742: ,p_token2 => G_SQLERRM_TOKEN

Line 745: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

741: ,p_token1_value => SQLcode
742: ,p_token2 => G_SQLERRM_TOKEN
743: ,p_token2_value => SQLerrm);
744:
745: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
746: END apply_contract_coverage;
747:
748: PROCEDURE get_bp_pricelist
749: (p_api_version IN Number

Line 879: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

875: EXCEPTION
876: WHEN G_EXCEPTION_HALT_VALIDATION THEN
877: Null;
878: WHEN OTHERS THEN
879: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
880: ,p_msg_name => G_UNEXPECTED_ERROR
881: ,p_token1 => G_SQLCODE_TOKEN
882: ,p_token1_value => SQLcode
883: ,p_token2 => G_SQLERRM_TOKEN

Line 886: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

882: ,p_token1_value => SQLcode
883: ,p_token2 => G_SQLERRM_TOKEN
884: ,p_token2_value => SQLerrm);
885:
886: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
887: END get_bp_pricelist;
888:
889: PROCEDURE get_bill_rates
890: (p_api_version IN Number

Line 1807: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1803: end if;
1804:
1805: end loop;
1806:
1807: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1808:
1809: EXCEPTION
1810: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1811: Null;

Line 1813: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1809: EXCEPTION
1810: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1811: Null;
1812: WHEN OTHERS THEN
1813: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1814: ,p_msg_name => G_UNEXPECTED_ERROR
1815: ,p_token1 => G_SQLCODE_TOKEN
1816: ,p_token1_value => SQLcode
1817: ,p_token2 => G_SQLERRM_TOKEN

Line 1820: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1816: ,p_token1_value => SQLcode
1817: ,p_token2 => G_SQLERRM_TOKEN
1818: ,p_token2_value => SQLerrm);
1819:
1820: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1821: END get_bill_rates;
1822:
1823: --Bug# 4194507 (JVARGHES)
1824:

Line 1862: OKC_API.SET_MESSAGE(p_App_Name => G_APP_NAME

1858:
1859: EXCEPTION
1860:
1861: WHEN OTHERS THEN
1862: OKC_API.SET_MESSAGE(p_App_Name => G_APP_NAME
1863: ,p_Msg_Name => G_UNEXPECTED_ERROR
1864: ,p_Token1 => G_SQLCODE_TOKEN
1865: ,p_Token1_Value => SQLCode
1866: ,p_Token2 => G_SQLERRM_TOKEN

Line 1869: x_Return_Status := OKC_API.G_RET_STS_UNEXP_ERROR;

1865: ,p_Token1_Value => SQLCode
1866: ,p_Token2 => G_SQLERRM_TOKEN
1867: ,p_Token2_Value => SQLErrm);
1868:
1869: x_Return_Status := OKC_API.G_RET_STS_UNEXP_ERROR;
1870:
1871: END Remove_Zero_Duration_Billrates;
1872:
1873: --

Line 1903: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1899: return x_next_wkday;
1900:
1901: EXCEPTION
1902: WHEN OTHERS THEN
1903: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1904: ,p_msg_name => G_UNEXPECTED_ERROR
1905: ,p_token1 => G_SQLCODE_TOKEN
1906: ,p_token1_value => SQLcode
1907: ,p_token2 => G_SQLERRM_TOKEN

Line 1974: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1970:
1971: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1972: Null;
1973: WHEN OTHERS THEN
1974: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1975: ,p_msg_name => G_UNEXPECTED_ERROR
1976: ,p_token1 => G_SQLCODE_TOKEN
1977: ,p_token1_value => SQLcode
1978: ,p_token2 => G_SQLERRM_TOKEN

Line 1981: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1977: ,p_token1_value => SQLcode
1978: ,p_token2 => G_SQLERRM_TOKEN
1979: ,p_token2_value => SQLerrm);
1980:
1981: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1982:
1983: END Sort_Billrates_datetime;
1984:
1985: FUNCTION Get_Final_End_Date(