APPS.OKS_UTIL_PUB dependencies on OKC_API

Line 581: l_init_msg_list VARCHAR2(1) := OKC_API.G_FALSE;

577: AND sales_group_id IS NULL;
578:
579: ---------------------------
580: l_api_version NUMBER := 1.0;
581: l_init_msg_list VARCHAR2(1) := OKC_API.G_FALSE;
582: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
583: l_msg_count NUMBER;
584: l_msg_data VARCHAR2(2000);
585: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;

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

578:
579: ---------------------------
580: l_api_version NUMBER := 1.0;
581: l_init_msg_list VARCHAR2(1) := OKC_API.G_FALSE;
582: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
583: l_msg_count NUMBER;
584: l_msg_data VARCHAR2(2000);
585: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
586: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;

Line 647: l_ctcv_tbl_in(1).object_version_number := okc_api.g_miss_NUM;

643: FND_FILE.PUT_LINE(FND_FILE.LOG, 'defaultsalesgroup ='||to_char(l_salesgrp_id));
644:
645: l_ctcv_tbl_in(1).id := contacts_rec.id;
646: l_ctcv_tbl_in(1).dnz_chr_id := l_hdr_rec.hdr_id;
647: l_ctcv_tbl_in(1).object_version_number := okc_api.g_miss_NUM;
648: l_ctcv_tbl_in(1).cpl_id := contacts_rec.cpl_id;
649: l_ctcv_tbl_in(1).cro_code := contacts_rec.cro_code;
650: l_ctcv_tbl_in(1).object1_id1 := contacts_rec.object1_id1;
651: l_ctcv_tbl_in(1).object1_id2 := '#';

Line 666: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

662:
663:
664: FND_FILE.PUT_LINE(FND_FILE.LOG, 'return status ='||l_return_status);
665:
666: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
667: FOR i in 1..fnd_msg_pub.count_msg
668: Loop
669: fnd_msg_pub.get
670: (p_msg_index => i,

Line 675: FND_FILE.PUT_LINE(FND_FILE.LOG, 'error from okc_API ='||l_msg_data);

671: p_encoded => 'F',
672: p_data => l_msg_data,
673: p_msg_index_out => l_index
674: );
675: FND_FILE.PUT_LINE(FND_FILE.LOG, 'error from okc_API ='||l_msg_data);
676: End Loop;
677: l_return_status := l_return_status;
678: -- commented out since program should continue even there is error.05/25/04
679: -- RAISE G_EXCEPTION_HALT_VALIDATION;

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

695: WHEN G_EXCEPTION_HALT_VALIDATION THEN
696: NULL;
697: WHEN OTHERS THEN
698: -- store SQL error message on message stack for caller
699: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
700: -- notify caller of an UNEXPECTED error
701: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
702: END update_contacts_salesgroup; -- Procedure
703:

Line 701: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

697: WHEN OTHERS THEN
698: -- store SQL error message on message stack for caller
699: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
700: -- notify caller of an UNEXPECTED error
701: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
702: END update_contacts_salesgroup; -- Procedure
703:
704: -- ===========================================================================
705: -- Function get_line_name