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

Line 68: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

64: WHERE id = (SELECT parent_ole_id
65: FROM okc_operation_lines
66: WHERE id = p_id);
67: l_api_version CONSTANT NUMBER := 1.0;
68: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
69: l_return_status VARCHAR2(1);
70: l_msg_count NUMBER;
71: l_msg_data VARCHAR2(2000);
72: l_msg_index_out NUMBER;

Line 100: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

96: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
97: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Update_Operation_Line l_return_status = ' || l_return_status);
98: END IF;
99: x_return_status := l_return_status;
100: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
101: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
102: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Update_Operation_Line l_msg_data = ' || l_msg_data);
103: END IF;
104: RETURN;

Line 105: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

101: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
102: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Update_Operation_Line l_msg_data = ' || l_msg_data);
103: END IF;
104: RETURN;
105: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
106: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
107: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Update_Operation_Line l_msg_data = ' || l_msg_data);
108: END IF;
109: RETURN;

Line 114: x_return_status := OKC_API.G_RET_STS_SUCCESS;

110: END IF;
111: END SET_OL_SEL;
112:
113: BEGIN
114: x_return_status := OKC_API.G_RET_STS_SUCCESS;
115: SET_OL_SEL(p_id);
116: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
117: RAISE OKC_API.G_EXCEPTION_ERROR;
118: END IF;

Line 116: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

112:
113: BEGIN
114: x_return_status := OKC_API.G_RET_STS_SUCCESS;
115: SET_OL_SEL(p_id);
116: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
117: RAISE OKC_API.G_EXCEPTION_ERROR;
118: END IF;
119: FOR parent_rec IN parent_cur
120: LOOP

Line 117: RAISE OKC_API.G_EXCEPTION_ERROR;

113: BEGIN
114: x_return_status := OKC_API.G_RET_STS_SUCCESS;
115: SET_OL_SEL(p_id);
116: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
117: RAISE OKC_API.G_EXCEPTION_ERROR;
118: END IF;
119: FOR parent_rec IN parent_cur
120: LOOP
121: SET_OL_SEL(parent_rec.id);

Line 122: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

118: END IF;
119: FOR parent_rec IN parent_cur
120: LOOP
121: SET_OL_SEL(parent_rec.id);
122: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
123: RAISE OKC_API.G_EXCEPTION_ERROR;
124: END IF;
125: EXIT;
126: END LOOP;

Line 123: RAISE OKC_API.G_EXCEPTION_ERROR;

119: FOR parent_rec IN parent_cur
120: LOOP
121: SET_OL_SEL(parent_rec.id);
122: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
123: RAISE OKC_API.G_EXCEPTION_ERROR;
124: END IF;
125: EXIT;
126: END LOOP;
127: END SET_OL_SELECTED;

Line 156: x_org_id NUMBER := OKC_API.G_MISS_NUM; --mmadhavi MOAC : changed to org_id

152: ------------------------------------------------------------------
153: ----TARGET HEADER MATCHING RULES
154: ------------------------------------------------------------------
155: x_scs_code VARCHAR2(200) := NULL;
156: x_org_id NUMBER := OKC_API.G_MISS_NUM; --mmadhavi MOAC : changed to org_id
157: x_inv_organization_id NUMBER := OKC_API.G_MISS_NUM;
158: x_party_id VARCHAR2(200) := NULL;
159: x_currency_code VARCHAR2(200) := NULL;
160:

Line 157: x_inv_organization_id NUMBER := OKC_API.G_MISS_NUM;

153: ----TARGET HEADER MATCHING RULES
154: ------------------------------------------------------------------
155: x_scs_code VARCHAR2(200) := NULL;
156: x_org_id NUMBER := OKC_API.G_MISS_NUM; --mmadhavi MOAC : changed to org_id
157: x_inv_organization_id NUMBER := OKC_API.G_MISS_NUM;
158: x_party_id VARCHAR2(200) := NULL;
159: x_currency_code VARCHAR2(200) := NULL;
160:
161: ------------------------------------------------------------------

Line 347: OKC_API.set_message(p_app_name => 'OKS',

343: x_end_date := x_end_date - 1;
344:
345: EXCEPTION
346: WHEN NO_DATA_FOUND THEN
347: OKC_API.set_message(p_app_name => 'OKS',
348: p_msg_name => 'OKS_INVALID_TARGET',
349: p_token1 => NULL,
350: p_token1_value => NULL);
351: -- Bug#5981381: Performance avoid calling log messages if not called from UI

Line 356: x_return_status := OKC_API.G_RET_STS_ERROR;

352: if p_conc_program IS NOT NULL THEN
353: LOG_MESSAGES('TARGET IS INVALID');
354: end if;
355: x_program_status := G_TARGET_INVALID;
356: x_return_status := OKC_API.G_RET_STS_ERROR;
357: END;
358: ------------------------------------------------------------------------------
359: ---Check Operation Lines to see if there are operations already in that table
360: ------------------------------------------------------------------------------

Line 399: IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN

395: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
396: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'set_ol_selected l_return_status: '|| x_return_status);
397: END IF;
398:
399: IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN
400: x_sources_tbl(i).select_yn := 'Y';
401: ELSE
402:
403: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

Line 407: x_return_status := OKC_API.G_RET_STS_ERROR;

403: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
404: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'Unable to set select_yn to Y ');
405: END IF;
406:
407: x_return_status := OKC_API.G_RET_STS_ERROR;
408: RETURN;
409: END IF;
410: END IF;
411:

Line 452: x_org_id NUMBER := OKC_API.G_MISS_NUM; --mmadhavi MOAC : changed to org_id

448: ------------------------------------------------------------------
449: ----TARGET HEADER MATCHING RULES
450: ------------------------------------------------------------------
451: x_scs_code VARCHAR2(200) := NULL;
452: x_org_id NUMBER := OKC_API.G_MISS_NUM; --mmadhavi MOAC : changed to org_id
453: x_inv_organization_id NUMBER := OKC_API.G_MISS_NUM;
454: x_party_id VARCHAR2(200) := NULL;
455: x_currency_code VARCHAR2(200) := NULL;
456:

Line 453: x_inv_organization_id NUMBER := OKC_API.G_MISS_NUM;

449: ----TARGET HEADER MATCHING RULES
450: ------------------------------------------------------------------
451: x_scs_code VARCHAR2(200) := NULL;
452: x_org_id NUMBER := OKC_API.G_MISS_NUM; --mmadhavi MOAC : changed to org_id
453: x_inv_organization_id NUMBER := OKC_API.G_MISS_NUM;
454: x_party_id VARCHAR2(200) := NULL;
455: x_currency_code VARCHAR2(200) := NULL;
456:
457: ------------------------------------------------------------------

Line 610: OKC_API.set_message(p_app_name => 'OKS',

606: x_currency_code;
607: CLOSE valid_target;
608: EXCEPTION
609: WHEN NO_DATA_FOUND THEN
610: OKC_API.set_message(p_app_name => 'OKS',
611: p_msg_name => 'OKS_INVALID_TARGET',
612: p_token1 => NULL,
613: p_token1_value => NULL);
614: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

Line 618: x_return_status := OKC_API.G_RET_STS_ERROR;

614: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
615: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'TARGET IS INVALID');
616: END IF;
617: x_program_status := G_TARGET_INVALID;
618: x_return_status := OKC_API.G_RET_STS_ERROR;
619: END;
620: i := 0;
621:
622: x_start_date := x_start_date - 1;

Line 719: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'valid_header_sources');

715: WHEN NO_DATA_FOUND THEN
716: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
717: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'NO CONTRACT SOURCES FOUND');
718: END IF;
719: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'valid_header_sources');
720: END;
721: ----------------------------------------------------------------------------
722: ---Create one record in OKC_OPERATION_INSTANCES_V if x_sources_tbl is not empty
723: ----------------------------------------------------------------------------

Line 740: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'CREATE_OPERATION_INSTANCES');

736: WHEN NO_DATA_FOUND THEN
737: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
738: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.CREATE_OPERATION_INSTANCES NO_DATA_FOUND');
739: END IF;
740: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'CREATE_OPERATION_INSTANCES');
741: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
742: WHEN OTHERS THEN
743: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
744: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.CREATE_OPERATION_INSTANCES OTHERS ');

Line 746: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,

742: WHEN OTHERS THEN
743: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
744: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.CREATE_OPERATION_INSTANCES OTHERS ');
745: END IF;
746: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
747: G_SQLCODE_TOKEN, SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
748: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
749: END;
750: ----------------------------------------------------------------------------

Line 763: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'CREATE_OPERATION_LINES');

759: WHEN NO_DATA_FOUND THEN
760: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
761: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.CREATE_OPERATION_LINES NO_DATA_FOUND');
762: END IF;
763: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'CREATE_OPERATION_LINES');
764: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
765: WHEN OTHERS THEN
766: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
767: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.CREATE_OPERATION_LINES OTHERS ');

Line 769: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,

765: WHEN OTHERS THEN
766: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
767: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.CREATE_OPERATION_LINES OTHERS ');
768: END IF;
769: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
770: G_SQLCODE_TOKEN, SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
771: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
772: END;
773: END IF;

Line 798: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

794: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_OPERATION_INSTANCES';
795: l_mod_name VARCHAR2(256) := lower(G_OKS_APP_NAME) || '.plsql.' || G_PROGRAM_NAME || '.' || l_api_name;
796:
797: l_api_version CONSTANT NUMBER := 1.0;
798: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
799: l_return_status VARCHAR2(1);
800: l_msg_count NUMBER;
801: l_msg_data VARCHAR2(2000);
802:

Line 827: l_oiev_tbl_in(1).name := OKC_API.G_MISS_CHAR;

823: EXIT;
824: END LOOP;
825: */
826:
827: l_oiev_tbl_in(1).name := OKC_API.G_MISS_CHAR;
828: -- l_oiev_tbl_in(1).cop_id := p_class_operation_id;
829: l_oiev_tbl_in(1).cop_id := G_RENCON_CLASS_OPERATION_ID;
830: l_oiev_tbl_in(1).status_code := G_OI_STATUS_CODE;
831: l_oiev_tbl_in(1).target_chr_id := p_target_chr_id;

Line 832: l_oiev_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;

828: -- l_oiev_tbl_in(1).cop_id := p_class_operation_id;
829: l_oiev_tbl_in(1).cop_id := G_RENCON_CLASS_OPERATION_ID;
830: l_oiev_tbl_in(1).status_code := G_OI_STATUS_CODE;
831: l_oiev_tbl_in(1).target_chr_id := p_target_chr_id;
832: l_oiev_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;
833: l_oiev_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
834: l_oiev_tbl_in(1).creation_date := SYSDATE;
835: l_oiev_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
836: l_oiev_tbl_in(1).last_update_date := SYSDATE;

Line 833: l_oiev_tbl_in(1).created_by := OKC_API.G_MISS_NUM;

829: l_oiev_tbl_in(1).cop_id := G_RENCON_CLASS_OPERATION_ID;
830: l_oiev_tbl_in(1).status_code := G_OI_STATUS_CODE;
831: l_oiev_tbl_in(1).target_chr_id := p_target_chr_id;
832: l_oiev_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;
833: l_oiev_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
834: l_oiev_tbl_in(1).creation_date := SYSDATE;
835: l_oiev_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
836: l_oiev_tbl_in(1).last_update_date := SYSDATE;
837: l_oiev_tbl_in(1).last_update_login := OKC_API.G_MISS_NUM;

Line 835: l_oiev_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;

831: l_oiev_tbl_in(1).target_chr_id := p_target_chr_id;
832: l_oiev_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;
833: l_oiev_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
834: l_oiev_tbl_in(1).creation_date := SYSDATE;
835: l_oiev_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
836: l_oiev_tbl_in(1).last_update_date := SYSDATE;
837: l_oiev_tbl_in(1).last_update_login := OKC_API.G_MISS_NUM;
838:
839: OKC_OPER_INST_PUB.Create_Operation_Instance(

Line 837: l_oiev_tbl_in(1).last_update_login := OKC_API.G_MISS_NUM;

833: l_oiev_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
834: l_oiev_tbl_in(1).creation_date := SYSDATE;
835: l_oiev_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
836: l_oiev_tbl_in(1).last_update_date := SYSDATE;
837: l_oiev_tbl_in(1).last_update_login := OKC_API.G_MISS_NUM;
838:
839: OKC_OPER_INST_PUB.Create_Operation_Instance(
840: p_api_version => l_api_version,
841: p_init_msg_list => l_init_msg_list,

Line 854: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

850: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
851: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Instance l_return_status = ' || l_return_status);
852: END IF;
853:
854: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
855: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
856: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Instance l_msg_data = ' || l_msg_data);
857: END IF;
858: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 858: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

854: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
855: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
856: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Instance l_msg_data = ' || l_msg_data);
857: END IF;
858: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
860: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
861: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Instance l_msg_data = ' || l_msg_data);
862: END IF;

Line 859: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

855: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
856: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Instance l_msg_data = ' || l_msg_data);
857: END IF;
858: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
860: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
861: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Instance l_msg_data = ' || l_msg_data);
862: END IF;
863: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 863: RAISE OKC_API.G_EXCEPTION_ERROR;

859: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
860: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
861: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Instance l_msg_data = ' || l_msg_data);
862: END IF;
863: RAISE OKC_API.G_EXCEPTION_ERROR;
864: END IF;
865:
866: END CREATE_OPERATION_INSTANCES;
867:

Line 884: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

880: l_api_version CONSTANT NUMBER := 1.0;
881: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_OPERATION_LINES';
882: l_mod_name VARCHAR2(256) := lower(G_OKS_APP_NAME) || '.plsql.' || G_PROGRAM_NAME || '.' || l_api_name;
883:
884: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
885: l_return_status VARCHAR2(1);
886: l_msg_count NUMBER;
887: l_msg_data VARCHAR2(2000);
888:

Line 943: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'IS_PRESENT');

939: WHEN NO_DATA_FOUND THEN
940: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
941: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.IS_K_PRESENT NO_DATA_FOUND');
942: END IF;
943: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'IS_PRESENT');
944: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
945: WHEN OTHERS THEN
946: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
947: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.IS_K_PRESENT OTHERS ');

Line 949: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,

945: WHEN OTHERS THEN
946: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
947: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.IS_K_PRESENT OTHERS ');
948: END IF;
949: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
950: G_SQLCODE_TOKEN, SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
951: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
952: END IS_K_PRESENT;
953:

Line 988: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'IS_PRESENT');

984: WHEN NO_DATA_FOUND THEN
985: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
986: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.IS_PRESENT NO_DATA_FOUND');
987: END IF;
988: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'IS_PRESENT');
989: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
990: WHEN OTHERS THEN
991: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
992: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.IS_PRESENT OTHERS ');

Line 994: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,

990: WHEN OTHERS THEN
991: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
992: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKS_RENCON_PVT.IS_PRESENT OTHERS ');
993: END IF;
994: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
995: G_SQLCODE_TOKEN, SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
996: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
997: END IS_PRESENT;
998:

Line 1067: l_olev_tbl_in(i).object_version_number := OKC_API.G_MISS_NUM;

1063: l_olev_tbl_in(i).object_chr_id := v_id_list_k(j).contract_id;
1064: l_olev_tbl_in(i).subject_cle_id := NULL;
1065: l_olev_tbl_in(i).parent_ole_id := NULL;
1066: l_olev_tbl_in(i).object_cle_id := NULL;
1067: l_olev_tbl_in(i).object_version_number := OKC_API.G_MISS_NUM;
1068: l_olev_tbl_in(i).created_by := OKC_API.G_MISS_NUM;
1069: l_olev_tbl_in(i).creation_date := SYSDATE;
1070: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1071: l_olev_tbl_in(i).last_update_date := SYSDATE;

Line 1068: l_olev_tbl_in(i).created_by := OKC_API.G_MISS_NUM;

1064: l_olev_tbl_in(i).subject_cle_id := NULL;
1065: l_olev_tbl_in(i).parent_ole_id := NULL;
1066: l_olev_tbl_in(i).object_cle_id := NULL;
1067: l_olev_tbl_in(i).object_version_number := OKC_API.G_MISS_NUM;
1068: l_olev_tbl_in(i).created_by := OKC_API.G_MISS_NUM;
1069: l_olev_tbl_in(i).creation_date := SYSDATE;
1070: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1071: l_olev_tbl_in(i).last_update_date := SYSDATE;
1072: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;

Line 1070: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;

1066: l_olev_tbl_in(i).object_cle_id := NULL;
1067: l_olev_tbl_in(i).object_version_number := OKC_API.G_MISS_NUM;
1068: l_olev_tbl_in(i).created_by := OKC_API.G_MISS_NUM;
1069: l_olev_tbl_in(i).creation_date := SYSDATE;
1070: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1071: l_olev_tbl_in(i).last_update_date := SYSDATE;
1072: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1073: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1074: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;

Line 1072: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;

1068: l_olev_tbl_in(i).created_by := OKC_API.G_MISS_NUM;
1069: l_olev_tbl_in(i).creation_date := SYSDATE;
1070: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1071: l_olev_tbl_in(i).last_update_date := SYSDATE;
1072: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1073: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1074: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1075: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1076: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;

Line 1076: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;

1072: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1073: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1074: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1075: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1076: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1077: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1078: i := i + 1;
1079: END IF;
1080: j := j + 1;

Line 1077: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;

1073: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1074: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1075: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1076: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1077: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1078: i := i + 1;
1079: END IF;
1080: j := j + 1;
1081: END LOOP;

Line 1096: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1092:
1093: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1094: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'FOR CONTRACT HEADER OKC_OPER_INST_PUB.Create_Operation_Line l_return_status = ' || l_return_status);
1095: END IF;
1096: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1097: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1098: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1099: END IF;
1100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1096: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1097: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1098: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1099: END IF;
1100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1101: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1102: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1103: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1104: END IF;

Line 1101: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1097: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1098: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1099: END IF;
1100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1101: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1102: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1103: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1104: END IF;
1105: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1105: RAISE OKC_API.G_EXCEPTION_ERROR;

1101: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1102: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1103: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1104: END IF;
1105: RAISE OKC_API.G_EXCEPTION_ERROR;
1106: END IF;
1107: ------------------------------------------------------------------------------------
1108: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1109: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'Update the v_id_list_k with the operation_lines_id');

Line 1155: l_olev_tbl_in(i).subject_cle_id := OKC_API.G_MISS_NUM;

1151: l_olev_tbl_in(i).process_flag := 'A';
1152: l_olev_tbl_in(i).oie_id := p_oie_id;
1153: l_olev_tbl_in(i).subject_chr_id := p_target_chr_id;
1154: l_olev_tbl_in(i).object_chr_id := v_id_list(j).contract_id;
1155: l_olev_tbl_in(i).subject_cle_id := OKC_API.G_MISS_NUM;
1156: IF IS_K_PRESENT(v_id_list(j).contract_id, v_ole_id, v_id_list_k) = 'Y' THEN
1157: l_olev_tbl_in(i).parent_ole_id := v_ole_id;
1158: END IF;
1159: l_olev_tbl_in(i).object_cle_id := v_id_list(j).line_id;

Line 1160: l_olev_tbl_in(i).object_version_number := OKC_API.G_MISS_NUM;

1156: IF IS_K_PRESENT(v_id_list(j).contract_id, v_ole_id, v_id_list_k) = 'Y' THEN
1157: l_olev_tbl_in(i).parent_ole_id := v_ole_id;
1158: END IF;
1159: l_olev_tbl_in(i).object_cle_id := v_id_list(j).line_id;
1160: l_olev_tbl_in(i).object_version_number := OKC_API.G_MISS_NUM;
1161: l_olev_tbl_in(i).created_by := OKC_API.G_MISS_NUM;
1162: l_olev_tbl_in(i).creation_date := SYSDATE;
1163: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1164: l_olev_tbl_in(i).last_update_date := SYSDATE;

Line 1161: l_olev_tbl_in(i).created_by := OKC_API.G_MISS_NUM;

1157: l_olev_tbl_in(i).parent_ole_id := v_ole_id;
1158: END IF;
1159: l_olev_tbl_in(i).object_cle_id := v_id_list(j).line_id;
1160: l_olev_tbl_in(i).object_version_number := OKC_API.G_MISS_NUM;
1161: l_olev_tbl_in(i).created_by := OKC_API.G_MISS_NUM;
1162: l_olev_tbl_in(i).creation_date := SYSDATE;
1163: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1164: l_olev_tbl_in(i).last_update_date := SYSDATE;
1165: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;

Line 1163: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;

1159: l_olev_tbl_in(i).object_cle_id := v_id_list(j).line_id;
1160: l_olev_tbl_in(i).object_version_number := OKC_API.G_MISS_NUM;
1161: l_olev_tbl_in(i).created_by := OKC_API.G_MISS_NUM;
1162: l_olev_tbl_in(i).creation_date := SYSDATE;
1163: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1164: l_olev_tbl_in(i).last_update_date := SYSDATE;
1165: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1166: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1167: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;

Line 1165: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;

1161: l_olev_tbl_in(i).created_by := OKC_API.G_MISS_NUM;
1162: l_olev_tbl_in(i).creation_date := SYSDATE;
1163: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1164: l_olev_tbl_in(i).last_update_date := SYSDATE;
1165: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1166: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1167: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1168: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1169: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;

Line 1169: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;

1165: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1166: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1167: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1168: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1169: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1170: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1171: i := i + 1;
1172: END IF;
1173: j := j + 1;

Line 1170: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;

1166: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1167: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1168: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1169: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1170: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1171: i := i + 1;
1172: END IF;
1173: j := j + 1;
1174: END LOOP;

Line 1190: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1186: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1187: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'FOR TOP LINES OKC_OPER_INST_PUB.Create_Operation_Line l_return_status = ' || l_return_status);
1188: END IF;
1189:
1190: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1191: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1192: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1193: END IF;
1194: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1194: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1190: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1191: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1192: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1193: END IF;
1194: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1195: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1196: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1197: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1198: END IF;

Line 1195: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1191: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1192: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1193: END IF;
1194: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1195: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1196: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1197: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1198: END IF;
1199: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1199: RAISE OKC_API.G_EXCEPTION_ERROR;

1195: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1196: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1197: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1198: END IF;
1199: RAISE OKC_API.G_EXCEPTION_ERROR;
1200: END IF;
1201: ------------------------------------------------------------------------------------
1202: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1203: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'Update the v_id_list with the operation_lines_id');

Line 1234: l_olev_tbl_in(i).subject_cle_id := OKC_API.G_MISS_NUM;

1230: l_olev_tbl_in(i).process_flag := 'A';
1231: l_olev_tbl_in(i).oie_id := p_oie_id;
1232: l_olev_tbl_in(i).subject_chr_id := p_target_chr_id;
1233: l_olev_tbl_in(i).object_chr_id := p_sources_tbl_type(j).contract_id;
1234: l_olev_tbl_in(i).subject_cle_id := OKC_API.G_MISS_NUM;
1235: IF IS_PRESENT(p_sources_tbl_type(j).line_id, v_ole_id, v_id_list) = 'Y' THEN
1236: l_olev_tbl_in(i).parent_ole_id := v_ole_id;
1237: END IF;
1238: l_olev_tbl_in(i).object_cle_id := p_sources_tbl_type(j).subline_id;

Line 1239: l_olev_tbl_in(i).object_version_number := OKC_API.G_MISS_NUM;

1235: IF IS_PRESENT(p_sources_tbl_type(j).line_id, v_ole_id, v_id_list) = 'Y' THEN
1236: l_olev_tbl_in(i).parent_ole_id := v_ole_id;
1237: END IF;
1238: l_olev_tbl_in(i).object_cle_id := p_sources_tbl_type(j).subline_id;
1239: l_olev_tbl_in(i).object_version_number := OKC_API.G_MISS_NUM;
1240: l_olev_tbl_in(i).created_by := OKC_API.G_MISS_NUM;
1241: l_olev_tbl_in(i).creation_date := SYSDATE;
1242: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1243: l_olev_tbl_in(i).last_update_date := SYSDATE;

Line 1240: l_olev_tbl_in(i).created_by := OKC_API.G_MISS_NUM;

1236: l_olev_tbl_in(i).parent_ole_id := v_ole_id;
1237: END IF;
1238: l_olev_tbl_in(i).object_cle_id := p_sources_tbl_type(j).subline_id;
1239: l_olev_tbl_in(i).object_version_number := OKC_API.G_MISS_NUM;
1240: l_olev_tbl_in(i).created_by := OKC_API.G_MISS_NUM;
1241: l_olev_tbl_in(i).creation_date := SYSDATE;
1242: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1243: l_olev_tbl_in(i).last_update_date := SYSDATE;
1244: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;

Line 1242: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;

1238: l_olev_tbl_in(i).object_cle_id := p_sources_tbl_type(j).subline_id;
1239: l_olev_tbl_in(i).object_version_number := OKC_API.G_MISS_NUM;
1240: l_olev_tbl_in(i).created_by := OKC_API.G_MISS_NUM;
1241: l_olev_tbl_in(i).creation_date := SYSDATE;
1242: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1243: l_olev_tbl_in(i).last_update_date := SYSDATE;
1244: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1245: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1246: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;

Line 1244: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;

1240: l_olev_tbl_in(i).created_by := OKC_API.G_MISS_NUM;
1241: l_olev_tbl_in(i).creation_date := SYSDATE;
1242: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1243: l_olev_tbl_in(i).last_update_date := SYSDATE;
1244: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1245: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1246: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1247: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1248: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;

Line 1248: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;

1244: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1245: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1246: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1247: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1248: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1249: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1250: i := i + 1;
1251: j := j + 1;
1252: END LOOP;

Line 1249: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;

1245: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1246: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1247: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1248: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1249: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1250: i := i + 1;
1251: j := j + 1;
1252: END LOOP;
1253:

Line 1267: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1263:
1264: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1265: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'FOR SUBLINES OKC_OPER_INST_PUB.Create_Operation_Line l_return_status = ' || l_return_status);
1266: END IF;
1267: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1268: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1269: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1270: END IF;
1271: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1271: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1267: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1268: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1269: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1270: END IF;
1271: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1272: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1273: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1274: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1275: END IF;

Line 1272: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1268: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1269: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1270: END IF;
1271: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1272: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1273: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1274: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1275: END IF;
1276: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1276: RAISE OKC_API.G_EXCEPTION_ERROR;

1272: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1273: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1274: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1275: END IF;
1276: RAISE OKC_API.G_EXCEPTION_ERROR;
1277: END IF;
1278: ------------------------------------------------------------------------------------
1279: --Update the p_sources_tbl_type with the operation_lines_id
1280: ------------------------------------------------------------------------------------

Line 1361: OKC_API.set_message(p_app_name => 'OKS',

1357: --x_return := G_TARGET_INVALID;
1358: x_return := FALSE;
1359: END;
1360: IF x_return = FALSE THEN
1361: OKC_API.set_message(p_app_name => 'OKS',
1362: p_msg_name => 'OKS_INVALID_TARGET',
1363: p_token1 => NULL,
1364: p_token1_value => NULL);
1365: END IF;

Line 1392: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'GET_PARENT_LINE_ID');

1388: WHEN NO_DATA_FOUND THEN
1389: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1390: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'GET_PARENT_LINE_ID INVALID');
1391: END IF;
1392: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'GET_PARENT_LINE_ID');
1393: x_return := NULL;
1394: END;
1395: RETURN(x_return);
1396: END GET_PARENT_LINE_ID;

Line 1476: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

1472: l_source_start_date DATE;
1473: l_source_end_date DATE;
1474:
1475: l_api_version CONSTANT NUMBER := 1.0;
1476: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
1477: l_msg_count NUMBER;
1478: l_msg_data VARCHAR2(2000);
1479: l_coverage_match VARCHAR2(1);
1480: l_index NUMBER;

Line 1528: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

1524: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1525: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.lrt_KEP', 'l_target_duration='||l_target_duration||' ,l_target_timeunit='||l_target_timeunit);
1526: END IF;
1527:
1528: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1529: OKC_TIME_UTIL_PUB.get_duration (
1530: p_start_date => p_source_line_details.start_date,
1531: p_end_date => p_source_line_details.end_date,
1532: x_duration => l_source_duration,

Line 1542: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

1538: END IF;
1539:
1540: END IF;
1541:
1542: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1543:
1544: l_source_start_date := p_source_line_details.end_date + 1;
1545:
1546: l_source_end_date := OKC_TIME_UTIL_PUB.get_enddate(

Line 1810: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1806: -----------------------------------------------------------------------------------------
1807: PROCEDURE SUBMIT(ERRBUF OUT NOCOPY VARCHAR2,
1808: RETCODE OUT NOCOPY NUMBER,
1809: p_api_version IN NUMBER,
1810: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1811: x_return_status OUT NOCOPY VARCHAR2,
1812: x_msg_count OUT NOCOPY NUMBER,
1813: x_msg_data OUT NOCOPY VARCHAR2,
1814: p_conc_program IN VARCHAR2,

Line 1928: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;

1924: s_cle_id NUMBER := NULL;
1925: i NUMBER := 0;
1926: l_conc_status BOOLEAN := TRUE;
1927:
1928: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
1929:
1930: l_return_status VARCHAR2(1);
1931: l_msg_count NUMBER;
1932: l_msg_data VARCHAR2(4000);

Line 2019: p_init_msg_list => OKC_API.G_FALSE,

2015: LOG_MESSAGES('l_start_date : '||to_char(l_start_date,'DD-MON-YYYY'));
2016: LOG_MESSAGES(' ');
2017: OKS_RENEW_UTIL_PUB.GET_RENEW_RULES (
2018: p_api_version => 1.0,
2019: p_init_msg_list => OKC_API.G_FALSE,
2020: x_return_status => l_return_status,
2021: x_msg_count => l_msg_count,
2022: x_msg_data => l_msg_data,
2023: P_Chr_Id => NULL,

Line 2171: ELSIF(l_return_status = OKC_API.g_ret_sts_warning) THEN

2167: --for U:unexpected error stop, for E:regular error, try next line
2168: --for W:warnings or S:Success continue
2169: IF (l_return_status = FND_API.g_ret_sts_success) THEN
2170: NULL; --continue
2171: ELSIF(l_return_status = OKC_API.g_ret_sts_warning) THEN
2172: l_warnings := TRUE;
2173: ELSIF (l_return_status = FND_API.g_ret_sts_error) THEN
2174: l_errors := TRUE;
2175: ELSE --all others treated as unexpected

Line 2275: ELSIF(l_return_status = OKC_API.g_ret_sts_warning) THEN

2271: LOG_MESSAGES('After Calling OKS_RENCPY_PVT.copy_contract_line, l_return_status : '||l_return_status);
2272: LOG_MESSAGES(' ');
2273: IF (l_return_status = FND_API.g_ret_sts_success) THEN
2274: NULL;
2275: ELSIF(l_return_status = OKC_API.g_ret_sts_warning) THEN
2276: l_warnings := TRUE;
2277: ELSIF (l_return_status = FND_API.g_ret_sts_error) THEN
2278: l_errors := TRUE;
2279: ELSE

Line 2443: ELSIF(l_return_status = OKC_API.g_ret_sts_warning) THEN

2439: END IF;
2440:
2441: IF (l_return_status = FND_API.g_ret_sts_success) THEN
2442: NULL;
2443: ELSIF(l_return_status = OKC_API.g_ret_sts_warning) THEN
2444: l_warnings := TRUE;
2445: ELSIF (l_return_status = FND_API.g_ret_sts_error) THEN
2446: l_errors := TRUE;
2447: ELSE

Line 2785: x_return_status := OKC_API.g_ret_sts_warning;

2781:
2782:
2783: --set the x_return_status depending on any warnings or errors during line copy
2784: IF l_errors THEN
2785: x_return_status := OKC_API.g_ret_sts_warning;
2786: l_dummy := FND_CONCURRENT.set_completion_status('WARNING', null);
2787: log_messages('Some lines where not copied');
2788: ELSIF l_warnings THEN
2789: x_return_status := OKC_API.g_ret_sts_warning;

Line 2789: x_return_status := OKC_API.g_ret_sts_warning;

2785: x_return_status := OKC_API.g_ret_sts_warning;
2786: l_dummy := FND_CONCURRENT.set_completion_status('WARNING', null);
2787: log_messages('Some lines where not copied');
2788: ELSIF l_warnings THEN
2789: x_return_status := OKC_API.g_ret_sts_warning;
2790: l_dummy := FND_CONCURRENT.set_completion_status('WARNING', null);
2791: log_messages('Some lines where copied with warnings');
2792: ELSE
2793: x_return_status := FND_API.g_ret_sts_success;