DBA Data[Home] [Help]

APPS.OKS_RENCON_PVT dependencies on OKC_OPER_INST_PUB

Line 73: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type;

69: l_return_status VARCHAR2(1);
70: l_msg_count NUMBER;
71: l_msg_data VARCHAR2(2000);
72: l_msg_index_out NUMBER;
73: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type;
74: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type;
75:
76: PROCEDURE SET_OL_SEL(p_ole_id IN NUMBER) IS
77: l_api_name CONSTANT VARCHAR2(30) := 'SET_OL_SEL';

Line 74: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type;

70: l_msg_count NUMBER;
71: l_msg_data VARCHAR2(2000);
72: l_msg_index_out NUMBER;
73: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type;
74: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type;
75:
76: PROCEDURE SET_OL_SEL(p_ole_id IN NUMBER) IS
77: l_api_name CONSTANT VARCHAR2(30) := 'SET_OL_SEL';
78: l_mod_name VARCHAR2(256) := lower(G_OKS_APP_NAME) || '.plsql.' || G_PROGRAM_NAME || '.' || l_api_name;

Line 88: OKC_OPER_INST_PUB.Update_Operation_Line(

84: RETURN;
85: END IF;
86: l_olev_tbl_in(1).id := p_ole_id;
87: l_olev_tbl_in(1).select_yn := 'Y';
88: OKC_OPER_INST_PUB.Update_Operation_Line(
89: p_api_version => l_api_version,
90: p_init_msg_list => l_init_msg_list,
91: x_return_status => l_return_status,
92: x_msg_count => l_msg_count,

Line 97: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Update_Operation_Line l_return_status = ' || l_return_status);

93: x_msg_data => l_msg_data,
94: p_olev_tbl => l_olev_tbl_in,
95: x_olev_tbl => l_olev_tbl_out );
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

Line 102: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Update_Operation_Line l_msg_data = ' || l_msg_data);

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;
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

Line 107: 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;
110: END IF;
111: END SET_OL_SEL;

Line 806: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE

802: l_msg_data VARCHAR2(2000);
803:
804: l_msg_index_out NUMBER;
805:
806: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
807: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
808: --------------------------------------------------------------------
809: ---Program Variables
810: --------------------------------------------------------------------

Line 807: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE

803:
804: l_msg_index_out NUMBER;
805:
806: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
807: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
808: --------------------------------------------------------------------
809: ---Program Variables
810: --------------------------------------------------------------------
811: p_class_operation_id NUMBER := 0;

Line 840: OKC_OPER_INST_PUB.Create_Operation_Instance(

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,
843: x_return_status => l_return_status,
844: x_msg_count => l_msg_count,

Line 852: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Instance l_return_status = ' || l_return_status);

848: );
849: p_oie_id := l_oiev_tbl_out(1).id;
850:
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

Line 857: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Instance l_msg_data = ' || l_msg_data);

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;
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

Line 862: 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;
865: END IF;
866:

Line 892: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES

888: l_msg_data VARCHAR2(2000);
889:
890: l_msg_index_out NUMBER;
891:
892: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
893: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
894:
895:
896: ------------------------------------------------------------------

Line 893: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES

889:
890: l_msg_index_out NUMBER;
891:
892: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
893: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
894:
895:
896: ------------------------------------------------------------------
897: ---PROGRAM variables

Line 1084: OKC_OPER_INST_PUB.Create_Operation_Line(

1080: END IF;
1081: j := j + 1;
1082: END LOOP;
1083:
1084: OKC_OPER_INST_PUB.Create_Operation_Line(
1085: p_api_version => l_api_version,
1086: p_init_msg_list => l_init_msg_list,
1087: x_return_status => l_return_status,
1088: x_msg_count => l_msg_count,

Line 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);

1091: x_olev_tbl => l_olev_tbl_out
1092: );
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);

Line 1099: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);

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;
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

Line 1104: 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;
1107: END IF;
1108: ------------------------------------------------------------------------------------

Line 1177: OKC_OPER_INST_PUB.Create_Operation_Line(

1173: END IF;
1174: j := j + 1;
1175: END LOOP;
1176:
1177: OKC_OPER_INST_PUB.Create_Operation_Line(
1178: p_api_version => l_api_version,
1179: p_init_msg_list => l_init_msg_list,
1180: x_return_status => l_return_status,
1181: x_msg_count => l_msg_count,

Line 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);

1184: x_olev_tbl => l_olev_tbl_out
1185: );
1186:
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

Line 1193: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);

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;
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

Line 1198: 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;
1201: END IF;
1202: ------------------------------------------------------------------------------------

Line 1255: OKC_OPER_INST_PUB.Create_Operation_Line(

1251: i := i + 1;
1252: j := j + 1;
1253: END LOOP;
1254:
1255: OKC_OPER_INST_PUB.Create_Operation_Line(
1256: p_api_version => l_api_version,
1257: p_init_msg_list => l_init_msg_list,
1258: x_return_status => l_return_status,
1259: x_msg_count => l_msg_count,

Line 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);

1262: x_olev_tbl => l_olev_tbl_out
1263: );
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);

Line 1270: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'OKC_OPER_INST_PUB.Create_Operation_Line l_msg_data = ' || l_msg_data);

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;
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

Line 1275: 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;
1278: END IF;
1279: ------------------------------------------------------------------------------------