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.OKC_PARAMETERS_PUB dependencies on OKC_API

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

6:
7: G_Params_tbl Params_Tbl_Type;
8: G_Params_count number := 0;
9:
10: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
11: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_PARAMETERS_PUB';
12: G_SQL_ID number;
13:
14: -- Start of comments

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

41: p_prmv_rec IN prmv_rec_type,
42: x_prmv_rec OUT NOCOPY prmv_rec_type) is
43: l_api_name CONSTANT VARCHAR2(30) := 'create_parameter';
44: l_api_version CONSTANT NUMBER := 1;
45: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
46: begin
47: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
48: G_PKG_NAME,
49: p_init_msg_list,

Line 47: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

43: l_api_name CONSTANT VARCHAR2(30) := 'create_parameter';
44: l_api_version CONSTANT NUMBER := 1;
45: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
46: begin
47: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
48: G_PKG_NAME,
49: p_init_msg_list,
50: l_api_version,
51: p_api_version,

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

50: l_api_version,
51: p_api_version,
52: '_PUB',
53: x_return_status);
54: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
55: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
56: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
57: RAISE OKC_API.G_EXCEPTION_ERROR;
58: END IF;

Line 55: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

51: p_api_version,
52: '_PUB',
53: x_return_status);
54: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
55: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
56: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
57: RAISE OKC_API.G_EXCEPTION_ERROR;
58: END IF;
59: OKC_PRM_PVT.insert_row(p_api_version,

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

52: '_PUB',
53: x_return_status);
54: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
55: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
56: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
57: RAISE OKC_API.G_EXCEPTION_ERROR;
58: END IF;
59: OKC_PRM_PVT.insert_row(p_api_version,
60: p_init_msg_list,

Line 57: RAISE OKC_API.G_EXCEPTION_ERROR;

53: x_return_status);
54: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
55: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
56: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
57: RAISE OKC_API.G_EXCEPTION_ERROR;
58: END IF;
59: OKC_PRM_PVT.insert_row(p_api_version,
60: p_init_msg_list,
61: x_return_status,

Line 66: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

62: x_msg_count,
63: x_msg_data,
64: p_prmv_rec,
65: x_prmv_rec);
66: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
67: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
68: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
69: RAISE OKC_API.G_EXCEPTION_ERROR;
70: END IF;

Line 67: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

63: x_msg_data,
64: p_prmv_rec,
65: x_prmv_rec);
66: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
67: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
68: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
69: RAISE OKC_API.G_EXCEPTION_ERROR;
70: END IF;
71: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 68: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

64: p_prmv_rec,
65: x_prmv_rec);
66: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
67: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
68: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
69: RAISE OKC_API.G_EXCEPTION_ERROR;
70: END IF;
71: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
72: EXCEPTION

Line 69: RAISE OKC_API.G_EXCEPTION_ERROR;

65: x_prmv_rec);
66: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
67: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
68: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
69: RAISE OKC_API.G_EXCEPTION_ERROR;
70: END IF;
71: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
72: EXCEPTION
73: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 71: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

67: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
68: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
69: RAISE OKC_API.G_EXCEPTION_ERROR;
70: END IF;
71: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
72: EXCEPTION
73: WHEN OKC_API.G_EXCEPTION_ERROR THEN
74: x_return_status := OKC_API.HANDLE_EXCEPTIONS
75: (substr(l_api_name,1,26),

Line 73: WHEN OKC_API.G_EXCEPTION_ERROR THEN

69: RAISE OKC_API.G_EXCEPTION_ERROR;
70: END IF;
71: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
72: EXCEPTION
73: WHEN OKC_API.G_EXCEPTION_ERROR THEN
74: x_return_status := OKC_API.HANDLE_EXCEPTIONS
75: (substr(l_api_name,1,26),
76: G_PKG_NAME,
77: 'OKC_API.G_RET_STS_ERROR',

Line 74: x_return_status := OKC_API.HANDLE_EXCEPTIONS

70: END IF;
71: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
72: EXCEPTION
73: WHEN OKC_API.G_EXCEPTION_ERROR THEN
74: x_return_status := OKC_API.HANDLE_EXCEPTIONS
75: (substr(l_api_name,1,26),
76: G_PKG_NAME,
77: 'OKC_API.G_RET_STS_ERROR',
78: x_msg_count,

Line 77: 'OKC_API.G_RET_STS_ERROR',

73: WHEN OKC_API.G_EXCEPTION_ERROR THEN
74: x_return_status := OKC_API.HANDLE_EXCEPTIONS
75: (substr(l_api_name,1,26),
76: G_PKG_NAME,
77: 'OKC_API.G_RET_STS_ERROR',
78: x_msg_count,
79: x_msg_data,
80: '_PUB');
81: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 81: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

77: 'OKC_API.G_RET_STS_ERROR',
78: x_msg_count,
79: x_msg_data,
80: '_PUB');
81: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
82: x_return_status := OKC_API.HANDLE_EXCEPTIONS
83: (substr(l_api_name,1,26),
84: G_PKG_NAME,
85: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 82: x_return_status := OKC_API.HANDLE_EXCEPTIONS

78: x_msg_count,
79: x_msg_data,
80: '_PUB');
81: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
82: x_return_status := OKC_API.HANDLE_EXCEPTIONS
83: (substr(l_api_name,1,26),
84: G_PKG_NAME,
85: 'OKC_API.G_RET_STS_UNEXP_ERROR',
86: x_msg_count,

Line 85: 'OKC_API.G_RET_STS_UNEXP_ERROR',

81: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
82: x_return_status := OKC_API.HANDLE_EXCEPTIONS
83: (substr(l_api_name,1,26),
84: G_PKG_NAME,
85: 'OKC_API.G_RET_STS_UNEXP_ERROR',
86: x_msg_count,
87: x_msg_data,
88: '_PUB');
89: WHEN OTHERS THEN

Line 90: x_return_status := OKC_API.HANDLE_EXCEPTIONS

86: x_msg_count,
87: x_msg_data,
88: '_PUB');
89: WHEN OTHERS THEN
90: x_return_status := OKC_API.HANDLE_EXCEPTIONS
91: (substr(l_api_name,1,26),
92: G_PKG_NAME,
93: 'OTHERS',
94: x_msg_count,

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

103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_prmv_tbl IN prmv_tbl_type,
105: x_prmv_tbl OUT NOCOPY prmv_tbl_type) is
106: i NUMBER;
107: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
108: begin
109: OKC_API.init_msg_list(p_init_msg_list);
110: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
111: if (p_prmv_tbl.COUNT>0) then

Line 109: OKC_API.init_msg_list(p_init_msg_list);

105: x_prmv_tbl OUT NOCOPY prmv_tbl_type) is
106: i NUMBER;
107: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
108: begin
109: OKC_API.init_msg_list(p_init_msg_list);
110: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
111: if (p_prmv_tbl.COUNT>0) then
112: i := p_prmv_tbl.FIRST;
113: LOOP

Line 110: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

106: i NUMBER;
107: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
108: begin
109: OKC_API.init_msg_list(p_init_msg_list);
110: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
111: if (p_prmv_tbl.COUNT>0) then
112: i := p_prmv_tbl.FIRST;
113: LOOP
114: create_parameter(p_api_version=>p_api_version,

Line 115: p_init_msg_list=>OKC_API.G_FALSE,

111: if (p_prmv_tbl.COUNT>0) then
112: i := p_prmv_tbl.FIRST;
113: LOOP
114: create_parameter(p_api_version=>p_api_version,
115: p_init_msg_list=>OKC_API.G_FALSE,
116: x_return_status=>l_return_status,
117: x_msg_count=>x_msg_count,
118: x_msg_data=>x_msg_data,
119: p_prmv_rec=>p_prmv_tbl(i),

Line 121: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

117: x_msg_count=>x_msg_count,
118: x_msg_data=>x_msg_data,
119: p_prmv_rec=>p_prmv_tbl(i),
120: x_prmv_rec=>x_prmv_tbl(i));
121: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
122: x_return_status := l_return_status;
123: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
124: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
125: x_return_status := l_return_status;

Line 123: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

119: p_prmv_rec=>p_prmv_tbl(i),
120: x_prmv_rec=>x_prmv_tbl(i));
121: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
122: x_return_status := l_return_status;
123: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
124: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
125: x_return_status := l_return_status;
126: end if;
127: EXIT WHEN (i=p_prmv_tbl.LAST);

Line 124: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

120: x_prmv_rec=>x_prmv_tbl(i));
121: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
122: x_return_status := l_return_status;
123: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
124: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
125: x_return_status := l_return_status;
126: end if;
127: EXIT WHEN (i=p_prmv_tbl.LAST);
128: i := p_prmv_tbl.NEXT(i);

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

140: p_prmv_rec IN prmv_rec_type,
141: x_prmv_rec OUT NOCOPY prmv_rec_type) is
142: l_api_name CONSTANT VARCHAR2(30) := 'update_parameter';
143: l_api_version CONSTANT NUMBER := 1;
144: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
145: begin
146: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
147: G_PKG_NAME,
148: p_init_msg_list,

Line 146: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

142: l_api_name CONSTANT VARCHAR2(30) := 'update_parameter';
143: l_api_version CONSTANT NUMBER := 1;
144: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
145: begin
146: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
147: G_PKG_NAME,
148: p_init_msg_list,
149: l_api_version,
150: p_api_version,

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

149: l_api_version,
150: p_api_version,
151: '_PUB',
152: x_return_status);
153: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
154: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
155: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
156: RAISE OKC_API.G_EXCEPTION_ERROR;
157: END IF;

Line 154: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

150: p_api_version,
151: '_PUB',
152: x_return_status);
153: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
154: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
155: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
156: RAISE OKC_API.G_EXCEPTION_ERROR;
157: END IF;
158: OKC_PRM_PVT.update_row(p_api_version,

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

151: '_PUB',
152: x_return_status);
153: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
154: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
155: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
156: RAISE OKC_API.G_EXCEPTION_ERROR;
157: END IF;
158: OKC_PRM_PVT.update_row(p_api_version,
159: p_init_msg_list,

Line 156: RAISE OKC_API.G_EXCEPTION_ERROR;

152: x_return_status);
153: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
154: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
155: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
156: RAISE OKC_API.G_EXCEPTION_ERROR;
157: END IF;
158: OKC_PRM_PVT.update_row(p_api_version,
159: p_init_msg_list,
160: x_return_status,

Line 165: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

161: x_msg_count,
162: x_msg_data,
163: p_prmv_rec,
164: x_prmv_rec);
165: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
167: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
168: RAISE OKC_API.G_EXCEPTION_ERROR;
169: END IF;

Line 166: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

162: x_msg_data,
163: p_prmv_rec,
164: x_prmv_rec);
165: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
167: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
168: RAISE OKC_API.G_EXCEPTION_ERROR;
169: END IF;
170: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 167: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

163: p_prmv_rec,
164: x_prmv_rec);
165: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
167: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
168: RAISE OKC_API.G_EXCEPTION_ERROR;
169: END IF;
170: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
171: EXCEPTION

Line 168: RAISE OKC_API.G_EXCEPTION_ERROR;

164: x_prmv_rec);
165: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
167: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
168: RAISE OKC_API.G_EXCEPTION_ERROR;
169: END IF;
170: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
171: EXCEPTION
172: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 170: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

166: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
167: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
168: RAISE OKC_API.G_EXCEPTION_ERROR;
169: END IF;
170: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
171: EXCEPTION
172: WHEN OKC_API.G_EXCEPTION_ERROR THEN
173: x_return_status := OKC_API.HANDLE_EXCEPTIONS
174: (substr(l_api_name,1,26),

Line 172: WHEN OKC_API.G_EXCEPTION_ERROR THEN

168: RAISE OKC_API.G_EXCEPTION_ERROR;
169: END IF;
170: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
171: EXCEPTION
172: WHEN OKC_API.G_EXCEPTION_ERROR THEN
173: x_return_status := OKC_API.HANDLE_EXCEPTIONS
174: (substr(l_api_name,1,26),
175: G_PKG_NAME,
176: 'OKC_API.G_RET_STS_ERROR',

Line 173: x_return_status := OKC_API.HANDLE_EXCEPTIONS

169: END IF;
170: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
171: EXCEPTION
172: WHEN OKC_API.G_EXCEPTION_ERROR THEN
173: x_return_status := OKC_API.HANDLE_EXCEPTIONS
174: (substr(l_api_name,1,26),
175: G_PKG_NAME,
176: 'OKC_API.G_RET_STS_ERROR',
177: x_msg_count,

Line 176: 'OKC_API.G_RET_STS_ERROR',

172: WHEN OKC_API.G_EXCEPTION_ERROR THEN
173: x_return_status := OKC_API.HANDLE_EXCEPTIONS
174: (substr(l_api_name,1,26),
175: G_PKG_NAME,
176: 'OKC_API.G_RET_STS_ERROR',
177: x_msg_count,
178: x_msg_data,
179: '_PUB');
180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

176: 'OKC_API.G_RET_STS_ERROR',
177: x_msg_count,
178: x_msg_data,
179: '_PUB');
180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
181: x_return_status := OKC_API.HANDLE_EXCEPTIONS
182: (substr(l_api_name,1,26),
183: G_PKG_NAME,
184: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 181: x_return_status := OKC_API.HANDLE_EXCEPTIONS

177: x_msg_count,
178: x_msg_data,
179: '_PUB');
180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
181: x_return_status := OKC_API.HANDLE_EXCEPTIONS
182: (substr(l_api_name,1,26),
183: G_PKG_NAME,
184: 'OKC_API.G_RET_STS_UNEXP_ERROR',
185: x_msg_count,

Line 184: 'OKC_API.G_RET_STS_UNEXP_ERROR',

180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
181: x_return_status := OKC_API.HANDLE_EXCEPTIONS
182: (substr(l_api_name,1,26),
183: G_PKG_NAME,
184: 'OKC_API.G_RET_STS_UNEXP_ERROR',
185: x_msg_count,
186: x_msg_data,
187: '_PUB');
188: WHEN OTHERS THEN

Line 189: x_return_status := OKC_API.HANDLE_EXCEPTIONS

185: x_msg_count,
186: x_msg_data,
187: '_PUB');
188: WHEN OTHERS THEN
189: x_return_status := OKC_API.HANDLE_EXCEPTIONS
190: (substr(l_api_name,1,26),
191: G_PKG_NAME,
192: 'OTHERS',
193: x_msg_count,

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

202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_prmv_tbl IN prmv_tbl_type,
204: x_prmv_tbl OUT NOCOPY prmv_tbl_type) is
205: i NUMBER;
206: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
207: begin
208: OKC_API.init_msg_list(p_init_msg_list);
209: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
210: if (p_prmv_tbl.COUNT>0) then

Line 208: OKC_API.init_msg_list(p_init_msg_list);

204: x_prmv_tbl OUT NOCOPY prmv_tbl_type) is
205: i NUMBER;
206: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
207: begin
208: OKC_API.init_msg_list(p_init_msg_list);
209: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
210: if (p_prmv_tbl.COUNT>0) then
211: i := p_prmv_tbl.FIRST;
212: LOOP

Line 209: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

205: i NUMBER;
206: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
207: begin
208: OKC_API.init_msg_list(p_init_msg_list);
209: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
210: if (p_prmv_tbl.COUNT>0) then
211: i := p_prmv_tbl.FIRST;
212: LOOP
213: update_parameter(p_api_version=>p_api_version,

Line 214: p_init_msg_list=>OKC_API.G_FALSE,

210: if (p_prmv_tbl.COUNT>0) then
211: i := p_prmv_tbl.FIRST;
212: LOOP
213: update_parameter(p_api_version=>p_api_version,
214: p_init_msg_list=>OKC_API.G_FALSE,
215: x_return_status=>l_return_status,
216: x_msg_count=>x_msg_count,
217: x_msg_data=>x_msg_data,
218: p_prmv_rec=>p_prmv_tbl(i),

Line 220: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

216: x_msg_count=>x_msg_count,
217: x_msg_data=>x_msg_data,
218: p_prmv_rec=>p_prmv_tbl(i),
219: x_prmv_rec=>x_prmv_tbl(i));
220: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
221: x_return_status := l_return_status;
222: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
224: x_return_status := l_return_status;

Line 222: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

218: p_prmv_rec=>p_prmv_tbl(i),
219: x_prmv_rec=>x_prmv_tbl(i));
220: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
221: x_return_status := l_return_status;
222: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
224: x_return_status := l_return_status;
225: end if;
226: EXIT WHEN (i=p_prmv_tbl.LAST);

Line 223: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

219: x_prmv_rec=>x_prmv_tbl(i));
220: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
221: x_return_status := l_return_status;
222: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
224: x_return_status := l_return_status;
225: end if;
226: EXIT WHEN (i=p_prmv_tbl.LAST);
227: i := p_prmv_tbl.NEXT(i);

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

238: x_msg_data OUT NOCOPY VARCHAR2,
239: p_prmv_rec IN prmv_rec_type) is
240: l_api_name CONSTANT VARCHAR2(30) := 'delete_parameter';
241: l_api_version CONSTANT NUMBER := 1;
242: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
243: begin
244: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
245: G_PKG_NAME,
246: p_init_msg_list,

Line 244: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

240: l_api_name CONSTANT VARCHAR2(30) := 'delete_parameter';
241: l_api_version CONSTANT NUMBER := 1;
242: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
243: begin
244: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
245: G_PKG_NAME,
246: p_init_msg_list,
247: l_api_version,
248: p_api_version,

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

247: l_api_version,
248: p_api_version,
249: '_PUB',
250: x_return_status);
251: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
252: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
253: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
254: RAISE OKC_API.G_EXCEPTION_ERROR;
255: END IF;

Line 252: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

248: p_api_version,
249: '_PUB',
250: x_return_status);
251: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
252: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
253: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
254: RAISE OKC_API.G_EXCEPTION_ERROR;
255: END IF;
256: OKC_PRM_PVT.delete_row(p_api_version,

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

249: '_PUB',
250: x_return_status);
251: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
252: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
253: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
254: RAISE OKC_API.G_EXCEPTION_ERROR;
255: END IF;
256: OKC_PRM_PVT.delete_row(p_api_version,
257: p_init_msg_list,

Line 254: RAISE OKC_API.G_EXCEPTION_ERROR;

250: x_return_status);
251: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
252: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
253: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
254: RAISE OKC_API.G_EXCEPTION_ERROR;
255: END IF;
256: OKC_PRM_PVT.delete_row(p_api_version,
257: p_init_msg_list,
258: x_return_status,

Line 262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

258: x_return_status,
259: x_msg_count,
260: x_msg_data,
261: p_prmv_rec);
262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
265: RAISE OKC_API.G_EXCEPTION_ERROR;
266: END IF;

Line 263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

259: x_msg_count,
260: x_msg_data,
261: p_prmv_rec);
262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
265: RAISE OKC_API.G_EXCEPTION_ERROR;
266: END IF;
267: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

260: x_msg_data,
261: p_prmv_rec);
262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
265: RAISE OKC_API.G_EXCEPTION_ERROR;
266: END IF;
267: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
268: EXCEPTION

Line 265: RAISE OKC_API.G_EXCEPTION_ERROR;

261: p_prmv_rec);
262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
265: RAISE OKC_API.G_EXCEPTION_ERROR;
266: END IF;
267: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
268: EXCEPTION
269: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 267: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
265: RAISE OKC_API.G_EXCEPTION_ERROR;
266: END IF;
267: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
268: EXCEPTION
269: WHEN OKC_API.G_EXCEPTION_ERROR THEN
270: x_return_status := OKC_API.HANDLE_EXCEPTIONS
271: (substr(l_api_name,1,26),

Line 269: WHEN OKC_API.G_EXCEPTION_ERROR THEN

265: RAISE OKC_API.G_EXCEPTION_ERROR;
266: END IF;
267: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
268: EXCEPTION
269: WHEN OKC_API.G_EXCEPTION_ERROR THEN
270: x_return_status := OKC_API.HANDLE_EXCEPTIONS
271: (substr(l_api_name,1,26),
272: G_PKG_NAME,
273: 'OKC_API.G_RET_STS_ERROR',

Line 270: x_return_status := OKC_API.HANDLE_EXCEPTIONS

266: END IF;
267: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
268: EXCEPTION
269: WHEN OKC_API.G_EXCEPTION_ERROR THEN
270: x_return_status := OKC_API.HANDLE_EXCEPTIONS
271: (substr(l_api_name,1,26),
272: G_PKG_NAME,
273: 'OKC_API.G_RET_STS_ERROR',
274: x_msg_count,

Line 273: 'OKC_API.G_RET_STS_ERROR',

269: WHEN OKC_API.G_EXCEPTION_ERROR THEN
270: x_return_status := OKC_API.HANDLE_EXCEPTIONS
271: (substr(l_api_name,1,26),
272: G_PKG_NAME,
273: 'OKC_API.G_RET_STS_ERROR',
274: x_msg_count,
275: x_msg_data,
276: '_PUB');
277: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 277: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

273: 'OKC_API.G_RET_STS_ERROR',
274: x_msg_count,
275: x_msg_data,
276: '_PUB');
277: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
278: x_return_status := OKC_API.HANDLE_EXCEPTIONS
279: (substr(l_api_name,1,26),
280: G_PKG_NAME,
281: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 278: x_return_status := OKC_API.HANDLE_EXCEPTIONS

274: x_msg_count,
275: x_msg_data,
276: '_PUB');
277: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
278: x_return_status := OKC_API.HANDLE_EXCEPTIONS
279: (substr(l_api_name,1,26),
280: G_PKG_NAME,
281: 'OKC_API.G_RET_STS_UNEXP_ERROR',
282: x_msg_count,

Line 281: 'OKC_API.G_RET_STS_UNEXP_ERROR',

277: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
278: x_return_status := OKC_API.HANDLE_EXCEPTIONS
279: (substr(l_api_name,1,26),
280: G_PKG_NAME,
281: 'OKC_API.G_RET_STS_UNEXP_ERROR',
282: x_msg_count,
283: x_msg_data,
284: '_PUB');
285: WHEN OTHERS THEN

Line 286: x_return_status := OKC_API.HANDLE_EXCEPTIONS

282: x_msg_count,
283: x_msg_data,
284: '_PUB');
285: WHEN OTHERS THEN
286: x_return_status := OKC_API.HANDLE_EXCEPTIONS
287: (substr(l_api_name,1,26),
288: G_PKG_NAME,
289: 'OTHERS',
290: x_msg_count,

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

298: x_msg_count OUT NOCOPY NUMBER,
299: x_msg_data OUT NOCOPY VARCHAR2,
300: p_prmv_tbl IN prmv_tbl_type) is
301: i NUMBER;
302: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
303: begin
304: OKC_API.init_msg_list(p_init_msg_list);
305: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
306: if (p_prmv_tbl.COUNT>0) then

Line 304: OKC_API.init_msg_list(p_init_msg_list);

300: p_prmv_tbl IN prmv_tbl_type) is
301: i NUMBER;
302: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
303: begin
304: OKC_API.init_msg_list(p_init_msg_list);
305: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
306: if (p_prmv_tbl.COUNT>0) then
307: i := p_prmv_tbl.FIRST;
308: LOOP

Line 305: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

301: i NUMBER;
302: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
303: begin
304: OKC_API.init_msg_list(p_init_msg_list);
305: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
306: if (p_prmv_tbl.COUNT>0) then
307: i := p_prmv_tbl.FIRST;
308: LOOP
309: delete_parameter(p_api_version=>p_api_version,

Line 310: p_init_msg_list=>OKC_API.G_FALSE,

306: if (p_prmv_tbl.COUNT>0) then
307: i := p_prmv_tbl.FIRST;
308: LOOP
309: delete_parameter(p_api_version=>p_api_version,
310: p_init_msg_list=>OKC_API.G_FALSE,
311: x_return_status=>l_return_status,
312: x_msg_count=>x_msg_count,
313: x_msg_data=>x_msg_data,
314: p_prmv_rec=>p_prmv_tbl(i));

Line 315: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

311: x_return_status=>l_return_status,
312: x_msg_count=>x_msg_count,
313: x_msg_data=>x_msg_data,
314: p_prmv_rec=>p_prmv_tbl(i));
315: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
316: x_return_status := l_return_status;
317: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
318: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
319: x_return_status := l_return_status;

Line 317: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

313: x_msg_data=>x_msg_data,
314: p_prmv_rec=>p_prmv_tbl(i));
315: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
316: x_return_status := l_return_status;
317: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
318: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
319: x_return_status := l_return_status;
320: end if;
321: EXIT WHEN (i=p_prmv_tbl.LAST);

Line 318: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

314: p_prmv_rec=>p_prmv_tbl(i));
315: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
316: x_return_status := l_return_status;
317: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
318: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
319: x_return_status := l_return_status;
320: end if;
321: EXIT WHEN (i=p_prmv_tbl.LAST);
322: i := p_prmv_tbl.NEXT(i);

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

333: x_msg_data OUT NOCOPY VARCHAR2,
334: p_prmv_rec IN prmv_rec_type) is
335: l_api_name CONSTANT VARCHAR2(30) := 'lock_parameter';
336: l_api_version CONSTANT NUMBER := 1;
337: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
338: begin
339: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
340: G_PKG_NAME,
341: p_init_msg_list,

Line 339: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

335: l_api_name CONSTANT VARCHAR2(30) := 'lock_parameter';
336: l_api_version CONSTANT NUMBER := 1;
337: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
338: begin
339: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
340: G_PKG_NAME,
341: p_init_msg_list,
342: l_api_version,
343: p_api_version,

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

342: l_api_version,
343: p_api_version,
344: '_PUB',
345: x_return_status);
346: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
347: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
349: RAISE OKC_API.G_EXCEPTION_ERROR;
350: END IF;

Line 347: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

343: p_api_version,
344: '_PUB',
345: x_return_status);
346: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
347: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
349: RAISE OKC_API.G_EXCEPTION_ERROR;
350: END IF;
351: OKC_PRM_PVT.lock_row(

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

344: '_PUB',
345: x_return_status);
346: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
347: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
349: RAISE OKC_API.G_EXCEPTION_ERROR;
350: END IF;
351: OKC_PRM_PVT.lock_row(
352: p_init_msg_list,

Line 349: RAISE OKC_API.G_EXCEPTION_ERROR;

345: x_return_status);
346: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
347: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
349: RAISE OKC_API.G_EXCEPTION_ERROR;
350: END IF;
351: OKC_PRM_PVT.lock_row(
352: p_init_msg_list,
353: x_return_status,

Line 357: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

353: x_return_status,
354: x_msg_count,
355: x_msg_data,
356: p_prmv_rec);
357: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
358: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
360: RAISE OKC_API.G_EXCEPTION_ERROR;
361: END IF;

Line 358: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

354: x_msg_count,
355: x_msg_data,
356: p_prmv_rec);
357: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
358: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
360: RAISE OKC_API.G_EXCEPTION_ERROR;
361: END IF;
362: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 359: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

355: x_msg_data,
356: p_prmv_rec);
357: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
358: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
360: RAISE OKC_API.G_EXCEPTION_ERROR;
361: END IF;
362: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
363: EXCEPTION

Line 360: RAISE OKC_API.G_EXCEPTION_ERROR;

356: p_prmv_rec);
357: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
358: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
360: RAISE OKC_API.G_EXCEPTION_ERROR;
361: END IF;
362: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
363: EXCEPTION
364: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 362: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

358: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
360: RAISE OKC_API.G_EXCEPTION_ERROR;
361: END IF;
362: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
363: EXCEPTION
364: WHEN OKC_API.G_EXCEPTION_ERROR THEN
365: x_return_status := OKC_API.HANDLE_EXCEPTIONS
366: (substr(l_api_name,1,26),

Line 364: WHEN OKC_API.G_EXCEPTION_ERROR THEN

360: RAISE OKC_API.G_EXCEPTION_ERROR;
361: END IF;
362: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
363: EXCEPTION
364: WHEN OKC_API.G_EXCEPTION_ERROR THEN
365: x_return_status := OKC_API.HANDLE_EXCEPTIONS
366: (substr(l_api_name,1,26),
367: G_PKG_NAME,
368: 'OKC_API.G_RET_STS_ERROR',

Line 365: x_return_status := OKC_API.HANDLE_EXCEPTIONS

361: END IF;
362: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
363: EXCEPTION
364: WHEN OKC_API.G_EXCEPTION_ERROR THEN
365: x_return_status := OKC_API.HANDLE_EXCEPTIONS
366: (substr(l_api_name,1,26),
367: G_PKG_NAME,
368: 'OKC_API.G_RET_STS_ERROR',
369: x_msg_count,

Line 368: 'OKC_API.G_RET_STS_ERROR',

364: WHEN OKC_API.G_EXCEPTION_ERROR THEN
365: x_return_status := OKC_API.HANDLE_EXCEPTIONS
366: (substr(l_api_name,1,26),
367: G_PKG_NAME,
368: 'OKC_API.G_RET_STS_ERROR',
369: x_msg_count,
370: x_msg_data,
371: '_PUB');
372: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 372: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

368: 'OKC_API.G_RET_STS_ERROR',
369: x_msg_count,
370: x_msg_data,
371: '_PUB');
372: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
373: x_return_status := OKC_API.HANDLE_EXCEPTIONS
374: (substr(l_api_name,1,26),
375: G_PKG_NAME,
376: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 373: x_return_status := OKC_API.HANDLE_EXCEPTIONS

369: x_msg_count,
370: x_msg_data,
371: '_PUB');
372: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
373: x_return_status := OKC_API.HANDLE_EXCEPTIONS
374: (substr(l_api_name,1,26),
375: G_PKG_NAME,
376: 'OKC_API.G_RET_STS_UNEXP_ERROR',
377: x_msg_count,

Line 376: 'OKC_API.G_RET_STS_UNEXP_ERROR',

372: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
373: x_return_status := OKC_API.HANDLE_EXCEPTIONS
374: (substr(l_api_name,1,26),
375: G_PKG_NAME,
376: 'OKC_API.G_RET_STS_UNEXP_ERROR',
377: x_msg_count,
378: x_msg_data,
379: '_PUB');
380: WHEN OTHERS THEN

Line 381: x_return_status := OKC_API.HANDLE_EXCEPTIONS

377: x_msg_count,
378: x_msg_data,
379: '_PUB');
380: WHEN OTHERS THEN
381: x_return_status := OKC_API.HANDLE_EXCEPTIONS
382: (substr(l_api_name,1,26),
383: G_PKG_NAME,
384: 'OTHERS',
385: x_msg_count,

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

393: x_msg_count OUT NOCOPY NUMBER,
394: x_msg_data OUT NOCOPY VARCHAR2,
395: p_prmv_tbl IN prmv_tbl_type) is
396: i NUMBER;
397: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
398: begin
399: OKC_API.init_msg_list(p_init_msg_list);
400: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
401: if (p_prmv_tbl.COUNT>0) then

Line 399: OKC_API.init_msg_list(p_init_msg_list);

395: p_prmv_tbl IN prmv_tbl_type) is
396: i NUMBER;
397: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
398: begin
399: OKC_API.init_msg_list(p_init_msg_list);
400: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
401: if (p_prmv_tbl.COUNT>0) then
402: i := p_prmv_tbl.FIRST;
403: LOOP

Line 400: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

396: i NUMBER;
397: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
398: begin
399: OKC_API.init_msg_list(p_init_msg_list);
400: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
401: if (p_prmv_tbl.COUNT>0) then
402: i := p_prmv_tbl.FIRST;
403: LOOP
404: lock_parameter(p_api_version=>p_api_version,

Line 405: p_init_msg_list=>OKC_API.G_FALSE,

401: if (p_prmv_tbl.COUNT>0) then
402: i := p_prmv_tbl.FIRST;
403: LOOP
404: lock_parameter(p_api_version=>p_api_version,
405: p_init_msg_list=>OKC_API.G_FALSE,
406: x_return_status=>l_return_status,
407: x_msg_count=>x_msg_count,
408: x_msg_data=>x_msg_data,
409: p_prmv_rec=>p_prmv_tbl(i));

Line 410: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

406: x_return_status=>l_return_status,
407: x_msg_count=>x_msg_count,
408: x_msg_data=>x_msg_data,
409: p_prmv_rec=>p_prmv_tbl(i));
410: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
411: x_return_status := l_return_status;
412: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
413: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
414: x_return_status := l_return_status;

Line 412: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

408: x_msg_data=>x_msg_data,
409: p_prmv_rec=>p_prmv_tbl(i));
410: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
411: x_return_status := l_return_status;
412: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
413: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
414: x_return_status := l_return_status;
415: end if;
416: EXIT WHEN (i=p_prmv_tbl.LAST);

Line 413: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

409: p_prmv_rec=>p_prmv_tbl(i));
410: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
411: x_return_status := l_return_status;
412: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
413: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
414: x_return_status := l_return_status;
415: end if;
416: EXIT WHEN (i=p_prmv_tbl.LAST);
417: i := p_prmv_tbl.NEXT(i);