APPS.OKC_PHI_PVT dependencies on OKC_API

Line 10: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

6: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
7: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
8: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
9: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_PHI_PVT';
10: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
11:
12: TYPE qp_relship_rec_typ IS RECORD
13: (
14: id okc_k_lines_b.id%TYPE, --Cle id, or line break id

Line 296: OKC_API.set_message(p_app_name => g_app_name, --OKC

292: okc_util.print_trace(2,'Modifier needs to be created');
293: END IF;
294: l_MODIFIER_LIST_rec.comments := l_k_header.short_description;
295:
296: OKC_API.set_message(p_app_name => g_app_name, --OKC
297: p_msg_name => 'OKC_PH_MODIFIER_NAME',
298: p_token1 => 'KNUMBER',
299: p_token1_value => l_k_header.contract_number,
300: p_token2 => 'KMODIFIER',

Line 464: OKC_API.set_message(p_app_name => g_app_name, --OKC

460: CLOSE c_ph_rules;
461:
462: IF not l_cust_found THEN
463:
464: OKC_API.set_message(p_app_name => g_app_name, --OKC
465: p_msg_name => 'OKC_NO_PRICE_HOLD_CAN');
466:
467: IF (l_debug = 'Y') THEN
468: okc_util.print_trace(2,'No Customer Account found');

Line 471: RAISE OKC_API.G_EXCEPTION_ERROR;

467: IF (l_debug = 'Y') THEN
468: okc_util.print_trace(2,'No Customer Account found');
469: END IF;
470:
471: RAISE OKC_API.G_EXCEPTION_ERROR;
472:
473: END IF;
474:
475: END IF; -- IF nvl(l_ph_header.ph_integrated_with_qp,'N')='N' then

Line 898: p_restricted_update => OKC_API.G_TRUE,

894: p_init_msg_list => FND_API.G_FALSE,
895: x_return_status => l_return_status,
896: x_msg_count => x_msg_count,
897: x_msg_data => x_msg_data,
898: p_restricted_update => OKC_API.G_TRUE,
899: p_clev_tbl => l_clev_tbl,
900: x_clev_tbl => lx_clev_tbl);
901:
902: IF (l_debug = 'Y') THEN

Line 949: OKC_API.set_message(p_app_name => g_app_name, --OKC

945:
946:
947: IF p_termination_date IS NULL THEN
948:
949: OKC_API.set_message(p_app_name => g_app_name, --OKC
950: p_msg_name => 'OKC_NO_PH_TERMINATE_DATE');
951:
952: RAISE OKC_API.G_EXCEPTION_ERROR;
953:

Line 952: RAISE OKC_API.G_EXCEPTION_ERROR;

948:
949: OKC_API.set_message(p_app_name => g_app_name, --OKC
950: p_msg_name => 'OKC_NO_PH_TERMINATE_DATE');
951:
952: RAISE OKC_API.G_EXCEPTION_ERROR;
953:
954: END IF;
955:
956: l_call_qp_api := true ;

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

1462: top_PRICE_LIST_ID NUMBER;
1463: top_PH_PRICING_TYPE VARCHAR2(50);
1464: top_PH_ADJUSTMENT NUMBER;
1465: l_unit_price NUMBER;
1466: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1467:
1468: CURSOR c_cur_ph_lines(p_par_id NUMBER) IS
1469: select id
1470: from okc_k_lines_v

Line 1760: IF( l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1756: p_restricted_update => p_restricted_update,
1757: p_clev_rec => x_clev_rec,
1758: x_clev_rec => xn_clev_rec
1759: );
1760: IF( l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1761: x_cimv_rec.cle_id := xn_clev_rec.id;
1762: okc_contract_item_pub.create_contract_item (
1763: p_api_version => p_api_version,
1764: p_init_msg_list => p_init_msg_list,

Line 1776: IF( l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1772: l_cnt := l_cnt + 1 ;
1773: END IF;
1774:
1775: IF( Nvl(p_commit_changes_yn, 'N') = 'Y' ) THEN
1776: IF( l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1777: commit;
1778: ELSE
1779: rollback;
1780: END IF;

Line 1787: IF x_msg_count>0 THEN x_return_status := OKC_API.G_RET_STS_ERROR; END IF;

1783: END LOOP;
1784: x_recs_copied := l_cnt-1;
1785: x_msg_count := Fnd_Msg_Pub.Count_Msg;
1786: x_msg_data := Fnd_Msg_Pub.Get( p_msg_index => Fnd_Msg_Pub.G_FIRST, p_encoded => FND_API.G_FALSE );
1787: IF x_msg_count>0 THEN x_return_status := OKC_API.G_RET_STS_ERROR; END IF;
1788: EXCEPTION
1789: WHEN OTHERS THEN
1790: -- store SQL error message on message stack for caller
1791: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

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

1787: IF x_msg_count>0 THEN x_return_status := OKC_API.G_RET_STS_ERROR; END IF;
1788: EXCEPTION
1789: WHEN OTHERS THEN
1790: -- store SQL error message on message stack for caller
1791: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1792: -- notify caller of an UNEXPECTED error
1793: x_msg_count := Fnd_Msg_Pub.Count_Msg;
1794: x_msg_data := Fnd_Msg_Pub.Get( p_msg_index => Fnd_Msg_Pub.G_FIRST, p_encoded => FND_API.G_FALSE );
1795: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 1795: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1791: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1792: -- notify caller of an UNEXPECTED error
1793: x_msg_count := Fnd_Msg_Pub.Count_Msg;
1794: x_msg_data := Fnd_Msg_Pub.Get( p_msg_index => Fnd_Msg_Pub.G_FIRST, p_encoded => FND_API.G_FALSE );
1795: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1796: END COPY_LINES;
1797:
1798: END OKC_PHI_PVT;