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 400: IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN

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

Line 408: x_return_status := OKC_API.G_RET_STS_ERROR;

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

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

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

Line 454: x_inv_organization_id NUMBER := OKC_API.G_MISS_NUM;

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

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

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

Line 619: x_return_status := OKC_API.G_RET_STS_ERROR;

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

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

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

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

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

Line 747: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,

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

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

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

Line 770: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 859: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 864: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

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

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

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

Line 950: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,

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

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

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

Line 995: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1093:
1094: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1095: 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);
1096: END IF;
1097: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1098: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1099: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1100: END IF;
1101: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1101: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1106: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1187: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1188: 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);
1189: END IF;
1190:
1191: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1192: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1193: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1194: END IF;
1195: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1195: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1200: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1264:
1265: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1266: 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);
1267: END IF;
1268: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1269: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1270: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);
1271: END IF;
1272: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1272: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1277: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

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

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

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

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

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

Line 1529: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

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

Line 1543: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

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

Line 1812: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

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

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

Line 2021: p_init_msg_list => OKC_API.G_FALSE,

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

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

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

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

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

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

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

Line 2787: x_return_status := OKC_API.g_ret_sts_warning;

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

Line 2791: x_return_status := OKC_API.g_ret_sts_warning;

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