APPS.OKS_AUTH_UTIL_PUB dependencies on OKC_API

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

8: , x_msg_count OUT NOCOPY NUMBER
9: , x_msg_data OUT NOCOPY VARCHAR2
10: , x_prod_selections_tbl OUT NOCOPY prod_selections_tbl)
11: IS
12: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
13: l_api_name CONSTANT VARCHAR2(30) := 'GetSelections_prod';
14: BEGIN
15: l_return_status := OKC_API.START_ACTIVITY
16: (l_api_name

Line 15: l_return_status := OKC_API.START_ACTIVITY

11: IS
12: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
13: l_api_name CONSTANT VARCHAR2(30) := 'GetSelections_prod';
14: BEGIN
15: l_return_status := OKC_API.START_ACTIVITY
16: (l_api_name
17: , p_init_msg_list
18: , '_PUB'
19: , x_return_status);

Line 20: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

16: (l_api_name
17: , p_init_msg_list
18: , '_PUB'
19: , x_return_status);
20: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
21: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
23: RAISE OKC_API.G_EXCEPTION_ERROR;
24: END IF;

Line 21: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

17: , p_init_msg_list
18: , '_PUB'
19: , x_return_status);
20: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
21: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
23: RAISE OKC_API.G_EXCEPTION_ERROR;
24: END IF;
25:

Line 22: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

18: , '_PUB'
19: , x_return_status);
20: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
21: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
23: RAISE OKC_API.G_EXCEPTION_ERROR;
24: END IF;
25:
26: OKS_AUTH_UTIL_PVT.GetSelections_prod

Line 23: RAISE OKC_API.G_EXCEPTION_ERROR;

19: , x_return_status);
20: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
21: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
22: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
23: RAISE OKC_API.G_EXCEPTION_ERROR;
24: END IF;
25:
26: OKS_AUTH_UTIL_PVT.GetSelections_prod
27: (p_api_version => p_api_version

Line 35: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

31: , x_msg_count => x_msg_count
32: , x_msg_data => x_msg_data
33: , x_prod_selections_tbl => x_prod_selections_tbl);
34:
35: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
36: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
37: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
38: RAISE OKC_API.G_EXCEPTION_ERROR;
39: END IF;

Line 36: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

32: , x_msg_data => x_msg_data
33: , x_prod_selections_tbl => x_prod_selections_tbl);
34:
35: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
36: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
37: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
38: RAISE OKC_API.G_EXCEPTION_ERROR;
39: END IF;
40:

Line 37: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

33: , x_prod_selections_tbl => x_prod_selections_tbl);
34:
35: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
36: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
37: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
38: RAISE OKC_API.G_EXCEPTION_ERROR;
39: END IF;
40:
41: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 38: RAISE OKC_API.G_EXCEPTION_ERROR;

34:
35: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
36: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
37: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
38: RAISE OKC_API.G_EXCEPTION_ERROR;
39: END IF;
40:
41: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
42:

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

37: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
38: RAISE OKC_API.G_EXCEPTION_ERROR;
39: END IF;
40:
41: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
42:
43: x_return_status := l_return_status;
44: EXCEPTION
45: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 45: WHEN OKC_API.G_EXCEPTION_ERROR THEN

41: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
42:
43: x_return_status := l_return_status;
44: EXCEPTION
45: WHEN OKC_API.G_EXCEPTION_ERROR THEN
46: x_return_status := OKC_API.HANDLE_EXCEPTIONS
47: (l_api_name,
48: G_PKG_NAME,
49: 'OKC_API.G_RET_STS_ERROR',

Line 46: x_return_status := OKC_API.HANDLE_EXCEPTIONS

42:
43: x_return_status := l_return_status;
44: EXCEPTION
45: WHEN OKC_API.G_EXCEPTION_ERROR THEN
46: x_return_status := OKC_API.HANDLE_EXCEPTIONS
47: (l_api_name,
48: G_PKG_NAME,
49: 'OKC_API.G_RET_STS_ERROR',
50: x_msg_count,

Line 49: 'OKC_API.G_RET_STS_ERROR',

45: WHEN OKC_API.G_EXCEPTION_ERROR THEN
46: x_return_status := OKC_API.HANDLE_EXCEPTIONS
47: (l_api_name,
48: G_PKG_NAME,
49: 'OKC_API.G_RET_STS_ERROR',
50: x_msg_count,
51: x_msg_data,
52: '_PUB');
53: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 53: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

49: 'OKC_API.G_RET_STS_ERROR',
50: x_msg_count,
51: x_msg_data,
52: '_PUB');
53: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
54: x_return_status := OKC_API.HANDLE_EXCEPTIONS
55: (l_api_name,
56: G_PKG_NAME,
57: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 54: x_return_status := OKC_API.HANDLE_EXCEPTIONS

50: x_msg_count,
51: x_msg_data,
52: '_PUB');
53: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
54: x_return_status := OKC_API.HANDLE_EXCEPTIONS
55: (l_api_name,
56: G_PKG_NAME,
57: 'OKC_API.G_RET_STS_UNEXP_ERROR',
58: x_msg_count,

Line 57: 'OKC_API.G_RET_STS_UNEXP_ERROR',

53: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
54: x_return_status := OKC_API.HANDLE_EXCEPTIONS
55: (l_api_name,
56: G_PKG_NAME,
57: 'OKC_API.G_RET_STS_UNEXP_ERROR',
58: x_msg_count,
59: x_msg_data,
60: '_PUB');
61: WHEN OTHERS THEN

Line 62: x_return_status := OKC_API.HANDLE_EXCEPTIONS

58: x_msg_count,
59: x_msg_data,
60: '_PUB');
61: WHEN OTHERS THEN
62: x_return_status := OKC_API.HANDLE_EXCEPTIONS
63: (l_api_name,
64: G_PKG_NAME,
65: 'OTHERS',
66: x_msg_count,

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

75: , x_msg_count OUT NOCOPY NUMBER
76: , x_msg_data OUT NOCOPY VARCHAR2
77: , x_clvl_selections_tbl OUT NOCOPY clvl_selections_tbl)
78: IS
79: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
80: l_api_name CONSTANT VARCHAR2(30) := 'GetSelections_prod';
81: BEGIN
82: l_return_status := OKC_API.START_ACTIVITY
83: (l_api_name

Line 82: l_return_status := OKC_API.START_ACTIVITY

78: IS
79: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
80: l_api_name CONSTANT VARCHAR2(30) := 'GetSelections_prod';
81: BEGIN
82: l_return_status := OKC_API.START_ACTIVITY
83: (l_api_name
84: , p_init_msg_list
85: , '_PUB'
86: , x_return_status);

Line 87: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

83: (l_api_name
84: , p_init_msg_list
85: , '_PUB'
86: , x_return_status);
87: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
89: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
90: RAISE OKC_API.G_EXCEPTION_ERROR;
91: END IF;

Line 88: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

84: , p_init_msg_list
85: , '_PUB'
86: , x_return_status);
87: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
89: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
90: RAISE OKC_API.G_EXCEPTION_ERROR;
91: END IF;
92:

Line 89: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

85: , '_PUB'
86: , x_return_status);
87: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
89: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
90: RAISE OKC_API.G_EXCEPTION_ERROR;
91: END IF;
92:
93: OKS_AUTH_UTIL_PVT.GetSelections_other

Line 90: RAISE OKC_API.G_EXCEPTION_ERROR;

86: , x_return_status);
87: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
89: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
90: RAISE OKC_API.G_EXCEPTION_ERROR;
91: END IF;
92:
93: OKS_AUTH_UTIL_PVT.GetSelections_other
94: (p_api_version => p_api_version

Line 102: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

98: , x_msg_count => x_msg_count
99: , x_msg_data => x_msg_data
100: , x_clvl_selections_tbl => x_clvl_selections_tbl);
101:
102: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
103: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
104: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
105: RAISE OKC_API.G_EXCEPTION_ERROR;
106: END IF;

Line 103: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

99: , x_msg_data => x_msg_data
100: , x_clvl_selections_tbl => x_clvl_selections_tbl);
101:
102: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
103: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
104: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
105: RAISE OKC_API.G_EXCEPTION_ERROR;
106: END IF;
107:

Line 104: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

100: , x_clvl_selections_tbl => x_clvl_selections_tbl);
101:
102: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
103: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
104: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
105: RAISE OKC_API.G_EXCEPTION_ERROR;
106: END IF;
107:
108: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 105: RAISE OKC_API.G_EXCEPTION_ERROR;

101:
102: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
103: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
104: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
105: RAISE OKC_API.G_EXCEPTION_ERROR;
106: END IF;
107:
108: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
109:

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

104: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
105: RAISE OKC_API.G_EXCEPTION_ERROR;
106: END IF;
107:
108: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
109:
110: x_return_status := l_return_status;
111: EXCEPTION
112: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 112: WHEN OKC_API.G_EXCEPTION_ERROR THEN

108: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
109:
110: x_return_status := l_return_status;
111: EXCEPTION
112: WHEN OKC_API.G_EXCEPTION_ERROR THEN
113: x_return_status := OKC_API.HANDLE_EXCEPTIONS
114: (l_api_name,
115: G_PKG_NAME,
116: 'OKC_API.G_RET_STS_ERROR',

Line 113: x_return_status := OKC_API.HANDLE_EXCEPTIONS

109:
110: x_return_status := l_return_status;
111: EXCEPTION
112: WHEN OKC_API.G_EXCEPTION_ERROR THEN
113: x_return_status := OKC_API.HANDLE_EXCEPTIONS
114: (l_api_name,
115: G_PKG_NAME,
116: 'OKC_API.G_RET_STS_ERROR',
117: x_msg_count,

Line 116: 'OKC_API.G_RET_STS_ERROR',

112: WHEN OKC_API.G_EXCEPTION_ERROR THEN
113: x_return_status := OKC_API.HANDLE_EXCEPTIONS
114: (l_api_name,
115: G_PKG_NAME,
116: 'OKC_API.G_RET_STS_ERROR',
117: x_msg_count,
118: x_msg_data,
119: '_PUB');
120: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 120: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

116: 'OKC_API.G_RET_STS_ERROR',
117: x_msg_count,
118: x_msg_data,
119: '_PUB');
120: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
121: x_return_status := OKC_API.HANDLE_EXCEPTIONS
122: (l_api_name,
123: G_PKG_NAME,
124: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 121: x_return_status := OKC_API.HANDLE_EXCEPTIONS

117: x_msg_count,
118: x_msg_data,
119: '_PUB');
120: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
121: x_return_status := OKC_API.HANDLE_EXCEPTIONS
122: (l_api_name,
123: G_PKG_NAME,
124: 'OKC_API.G_RET_STS_UNEXP_ERROR',
125: x_msg_count,

Line 124: 'OKC_API.G_RET_STS_UNEXP_ERROR',

120: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
121: x_return_status := OKC_API.HANDLE_EXCEPTIONS
122: (l_api_name,
123: G_PKG_NAME,
124: 'OKC_API.G_RET_STS_UNEXP_ERROR',
125: x_msg_count,
126: x_msg_data,
127: '_PUB');
128: WHEN OTHERS THEN

Line 129: x_return_status := OKC_API.HANDLE_EXCEPTIONS

125: x_msg_count,
126: x_msg_data,
127: '_PUB');
128: WHEN OTHERS THEN
129: x_return_status := OKC_API.HANDLE_EXCEPTIONS
130: (l_api_name,
131: G_PKG_NAME,
132: 'OTHERS',
133: x_msg_count,

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

145: , p_change_status IN VARCHAR2) -- Added an additional flag parameter, p_change_status,
146: -- to decide whether to allow change of status of sublines
147: -- of the topline during update service
148: IS
149: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
150: l_api_name CONSTANT VARCHAR2(30) := 'CopyService';
151: BEGIN
152: l_return_status := OKC_API.START_ACTIVITY
153: (l_api_name

Line 152: l_return_status := OKC_API.START_ACTIVITY

148: IS
149: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
150: l_api_name CONSTANT VARCHAR2(30) := 'CopyService';
151: BEGIN
152: l_return_status := OKC_API.START_ACTIVITY
153: (l_api_name
154: , p_init_msg_list
155: , '_PUB'
156: , x_return_status);

Line 157: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

153: (l_api_name
154: , p_init_msg_list
155: , '_PUB'
156: , x_return_status);
157: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
158: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
159: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
160: RAISE OKC_API.G_EXCEPTION_ERROR;
161: END IF;

Line 158: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

154: , p_init_msg_list
155: , '_PUB'
156: , x_return_status);
157: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
158: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
159: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
160: RAISE OKC_API.G_EXCEPTION_ERROR;
161: END IF;
162:

Line 159: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

155: , '_PUB'
156: , x_return_status);
157: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
158: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
159: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
160: RAISE OKC_API.G_EXCEPTION_ERROR;
161: END IF;
162:
163: OKS_AUTH_UTIL_PVT.CopyService

Line 160: RAISE OKC_API.G_EXCEPTION_ERROR;

156: , x_return_status);
157: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
158: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
159: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
160: RAISE OKC_API.G_EXCEPTION_ERROR;
161: END IF;
162:
163: OKS_AUTH_UTIL_PVT.CopyService
164: (p_api_version => p_api_version

Line 175: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

171: , p_change_status => p_change_status); -- LLC Added an additional flag parameter, p_change_status,
172: -- to decide whether to allow change of status of sublines
173: -- of the topline during update service
174:
175: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
178: RAISE OKC_API.G_EXCEPTION_ERROR;
179: END IF;

Line 176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

172: -- to decide whether to allow change of status of sublines
173: -- of the topline during update service
174:
175: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
178: RAISE OKC_API.G_EXCEPTION_ERROR;
179: END IF;
180:

Line 177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

173: -- of the topline during update service
174:
175: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
178: RAISE OKC_API.G_EXCEPTION_ERROR;
179: END IF;
180:
181: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 178: RAISE OKC_API.G_EXCEPTION_ERROR;

174:
175: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
178: RAISE OKC_API.G_EXCEPTION_ERROR;
179: END IF;
180:
181: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
182:

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

177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
178: RAISE OKC_API.G_EXCEPTION_ERROR;
179: END IF;
180:
181: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
182:
183: x_return_status := l_return_status;
184:
185: EXCEPTION

Line 186: WHEN OKC_API.G_EXCEPTION_ERROR THEN

182:
183: x_return_status := l_return_status;
184:
185: EXCEPTION
186: WHEN OKC_API.G_EXCEPTION_ERROR THEN
187: x_return_status := OKC_API.HANDLE_EXCEPTIONS
188: (l_api_name,
189: G_PKG_NAME,
190: 'OKC_API.G_RET_STS_ERROR',

Line 187: x_return_status := OKC_API.HANDLE_EXCEPTIONS

183: x_return_status := l_return_status;
184:
185: EXCEPTION
186: WHEN OKC_API.G_EXCEPTION_ERROR THEN
187: x_return_status := OKC_API.HANDLE_EXCEPTIONS
188: (l_api_name,
189: G_PKG_NAME,
190: 'OKC_API.G_RET_STS_ERROR',
191: x_msg_count,

Line 190: 'OKC_API.G_RET_STS_ERROR',

186: WHEN OKC_API.G_EXCEPTION_ERROR THEN
187: x_return_status := OKC_API.HANDLE_EXCEPTIONS
188: (l_api_name,
189: G_PKG_NAME,
190: 'OKC_API.G_RET_STS_ERROR',
191: x_msg_count,
192: x_msg_data,
193: '_PUB');
194: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 194: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

190: 'OKC_API.G_RET_STS_ERROR',
191: x_msg_count,
192: x_msg_data,
193: '_PUB');
194: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
195: x_return_status := OKC_API.HANDLE_EXCEPTIONS
196: (l_api_name,
197: G_PKG_NAME,
198: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 195: x_return_status := OKC_API.HANDLE_EXCEPTIONS

191: x_msg_count,
192: x_msg_data,
193: '_PUB');
194: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
195: x_return_status := OKC_API.HANDLE_EXCEPTIONS
196: (l_api_name,
197: G_PKG_NAME,
198: 'OKC_API.G_RET_STS_UNEXP_ERROR',
199: x_msg_count,

Line 198: 'OKC_API.G_RET_STS_UNEXP_ERROR',

194: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
195: x_return_status := OKC_API.HANDLE_EXCEPTIONS
196: (l_api_name,
197: G_PKG_NAME,
198: 'OKC_API.G_RET_STS_UNEXP_ERROR',
199: x_msg_count,
200: x_msg_data,
201: '_PUB');
202: WHEN OTHERS THEN

Line 203: x_return_status := OKC_API.HANDLE_EXCEPTIONS

199: x_msg_count,
200: x_msg_data,
201: '_PUB');
202: WHEN OTHERS THEN
203: x_return_status := OKC_API.HANDLE_EXCEPTIONS
204: (l_api_name,
205: G_PKG_NAME,
206: 'OTHERS',
207: x_msg_count,

Line 215: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

211:
212: --Added for Bug#2419645, 07/18/2002, Sudam.
213: PROCEDURE COPY_PARAMETER(
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216: p_in_parameter_record IN in_parameter_record,
217: x_cur_rec OUT NOCOPY cur_rec,
218: x_hdr_cur_rec OUT NOCOPY hdr_cur_rec,
219: x_line_cur_rec OUT NOCOPY line_cur_rec,

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

268: l_cur_rec cur_rec;
269: l_hdr_cur_rec hdr_cur_rec;
270: l_line_cur_rec line_cur_rec;
271: l_api_version CONSTANT NUMBER := 1.0;
272: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
273:
274: BEGIN
275:
276: p_line_id := p_in_parameter_record.line_id;

Line 333: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

329: EXCEPTION
330: WHEN G_ERROR THEN
331: NULL;
332: WHEN OTHERS THEN
333: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
334: p_msg_name => G_UNEXPECTED_ERROR,
335: p_token1 => G_SQLCODE_TOKEN,
336: p_token1_value => SQLCODE,
337: p_token2 => G_SQLERRM_TOKEN,

Line 611: x_return_status := OKC_API.G_RET_STS_SUCCESS;

607: BEGIN
608:
609: IF (P_Contact_point_rec.contact_point_id IS NULL AND
610: p_contact_point_rec.email_address IS NULL) THEN
611: x_return_status := OKC_API.G_RET_STS_SUCCESS;
612: RETURN;
613: ELSIF (P_Contact_point_rec.contact_point_id IS NULL AND
614: p_contact_point_rec.email_address IS NOT NULL) THEN
615: --Create

Line 647: x_return_status := OKC_API.G_RET_STS_SUCCESS;

643: RAISE G_ERROR;
644: END IF;
645: x_contact_point_id := p_contact_point_rec.contact_point_id;
646: END IF;
647: x_return_status := OKC_API.G_RET_STS_SUCCESS;
648: EXCEPTION
649: WHEN G_ERROR THEN
650: NULL;
651: WHEN OTHERS THEN

Line 652: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

648: EXCEPTION
649: WHEN G_ERROR THEN
650: NULL;
651: WHEN OTHERS THEN
652: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
653: OKC_API.set_message
654: (OKC_API.G_APP_NAME,
655: G_UNEXPECTED_ERROR,
656: G_SQLCODE_TOKEN,

Line 653: OKC_API.set_message

649: WHEN G_ERROR THEN
650: NULL;
651: WHEN OTHERS THEN
652: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
653: OKC_API.set_message
654: (OKC_API.G_APP_NAME,
655: G_UNEXPECTED_ERROR,
656: G_SQLCODE_TOKEN,
657: SQLCODE,

Line 654: (OKC_API.G_APP_NAME,

650: NULL;
651: WHEN OTHERS THEN
652: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
653: OKC_API.set_message
654: (OKC_API.G_APP_NAME,
655: G_UNEXPECTED_ERROR,
656: G_SQLCODE_TOKEN,
657: SQLCODE,
658: G_SQLERRM_TOKEN,

Line 768: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

764: x_msg_data);
765:
766: EXCEPTION
767: WHEN OTHERS THEN
768: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
769: OKC_API.set_message
770: (OKC_API.G_APP_NAME,
771: G_UNEXPECTED_ERROR,
772: G_SQLCODE_TOKEN,

Line 769: OKC_API.set_message

765:
766: EXCEPTION
767: WHEN OTHERS THEN
768: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
769: OKC_API.set_message
770: (OKC_API.G_APP_NAME,
771: G_UNEXPECTED_ERROR,
772: G_SQLCODE_TOKEN,
773: SQLCODE,

Line 770: (OKC_API.G_APP_NAME,

766: EXCEPTION
767: WHEN OTHERS THEN
768: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
769: OKC_API.set_message
770: (OKC_API.G_APP_NAME,
771: G_UNEXPECTED_ERROR,
772: G_SQLCODE_TOKEN,
773: SQLCODE,
774: G_SQLERRM_TOKEN,

Line 799: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

795: x_msg_data);
796:
797: EXCEPTION
798: WHEN OTHERS THEN
799: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
800: OKC_API.set_message
801: (OKC_API.G_APP_NAME,
802: G_UNEXPECTED_ERROR,
803: G_SQLCODE_TOKEN,

Line 800: OKC_API.set_message

796:
797: EXCEPTION
798: WHEN OTHERS THEN
799: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
800: OKC_API.set_message
801: (OKC_API.G_APP_NAME,
802: G_UNEXPECTED_ERROR,
803: G_SQLCODE_TOKEN,
804: SQLCODE,

Line 801: (OKC_API.G_APP_NAME,

797: EXCEPTION
798: WHEN OTHERS THEN
799: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
800: OKC_API.set_message
801: (OKC_API.G_APP_NAME,
802: G_UNEXPECTED_ERROR,
803: G_SQLCODE_TOKEN,
804: SQLCODE,
805: G_SQLERRM_TOKEN,

Line 836: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

832: x_msg_data);
833:
834: EXCEPTION
835: WHEN OTHERS THEN
836: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
837: OKC_API.set_message
838: (OKC_API.G_APP_NAME,
839: G_UNEXPECTED_ERROR,
840: G_SQLCODE_TOKEN,

Line 837: OKC_API.set_message

833:
834: EXCEPTION
835: WHEN OTHERS THEN
836: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
837: OKC_API.set_message
838: (OKC_API.G_APP_NAME,
839: G_UNEXPECTED_ERROR,
840: G_SQLCODE_TOKEN,
841: SQLCODE,

Line 838: (OKC_API.G_APP_NAME,

834: EXCEPTION
835: WHEN OTHERS THEN
836: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
837: OKC_API.set_message
838: (OKC_API.G_APP_NAME,
839: G_UNEXPECTED_ERROR,
840: G_SQLCODE_TOKEN,
841: SQLCODE,
842: G_SQLERRM_TOKEN,

Line 871: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

867: x_msg_data);
868:
869: EXCEPTION
870: WHEN OTHERS THEN
871: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
872: OKC_API.set_message
873: (OKC_API.G_APP_NAME,
874: G_UNEXPECTED_ERROR,
875: G_SQLCODE_TOKEN,

Line 872: OKC_API.set_message

868:
869: EXCEPTION
870: WHEN OTHERS THEN
871: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
872: OKC_API.set_message
873: (OKC_API.G_APP_NAME,
874: G_UNEXPECTED_ERROR,
875: G_SQLCODE_TOKEN,
876: SQLCODE,

Line 873: (OKC_API.G_APP_NAME,

869: EXCEPTION
870: WHEN OTHERS THEN
871: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
872: OKC_API.set_message
873: (OKC_API.G_APP_NAME,
874: G_UNEXPECTED_ERROR,
875: G_SQLCODE_TOKEN,
876: SQLCODE,
877: G_SQLERRM_TOKEN,

Line 902: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

898: x_msg_data);
899:
900: EXCEPTION
901: WHEN OTHERS THEN
902: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
903: OKC_API.set_message
904: (OKC_API.G_APP_NAME,
905: G_UNEXPECTED_ERROR,
906: G_SQLCODE_TOKEN,

Line 903: OKC_API.set_message

899:
900: EXCEPTION
901: WHEN OTHERS THEN
902: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
903: OKC_API.set_message
904: (OKC_API.G_APP_NAME,
905: G_UNEXPECTED_ERROR,
906: G_SQLCODE_TOKEN,
907: SQLCODE,

Line 904: (OKC_API.G_APP_NAME,

900: EXCEPTION
901: WHEN OTHERS THEN
902: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
903: OKC_API.set_message
904: (OKC_API.G_APP_NAME,
905: G_UNEXPECTED_ERROR,
906: G_SQLCODE_TOKEN,
907: SQLCODE,
908: G_SQLERRM_TOKEN,

Line 931: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

927: x_msg_data);
928:
929: EXCEPTION
930: WHEN OTHERS THEN
931: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
932: OKC_API.set_message
933: (OKC_API.G_APP_NAME,
934: G_UNEXPECTED_ERROR,
935: G_SQLCODE_TOKEN,

Line 932: OKC_API.set_message

928:
929: EXCEPTION
930: WHEN OTHERS THEN
931: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
932: OKC_API.set_message
933: (OKC_API.G_APP_NAME,
934: G_UNEXPECTED_ERROR,
935: G_SQLCODE_TOKEN,
936: SQLCODE,

Line 933: (OKC_API.G_APP_NAME,

929: EXCEPTION
930: WHEN OTHERS THEN
931: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
932: OKC_API.set_message
933: (OKC_API.G_APP_NAME,
934: G_UNEXPECTED_ERROR,
935: G_SQLCODE_TOKEN,
936: SQLCODE,
937: G_SQLERRM_TOKEN,

Line 960: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

956: x_msg_data);
957:
958: EXCEPTION
959: WHEN OTHERS THEN
960: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
961: OKC_API.set_message
962: (OKC_API.G_APP_NAME,
963: G_UNEXPECTED_ERROR,
964: G_SQLCODE_TOKEN,

Line 961: OKC_API.set_message

957:
958: EXCEPTION
959: WHEN OTHERS THEN
960: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
961: OKC_API.set_message
962: (OKC_API.G_APP_NAME,
963: G_UNEXPECTED_ERROR,
964: G_SQLCODE_TOKEN,
965: SQLCODE,

Line 962: (OKC_API.G_APP_NAME,

958: EXCEPTION
959: WHEN OTHERS THEN
960: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
961: OKC_API.set_message
962: (OKC_API.G_APP_NAME,
963: G_UNEXPECTED_ERROR,
964: G_SQLCODE_TOKEN,
965: SQLCODE,
966: G_SQLERRM_TOKEN,

Line 989: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

985: x_msg_data);
986:
987: EXCEPTION
988: WHEN OTHERS THEN
989: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
990: OKC_API.set_message
991: (OKC_API.G_APP_NAME,
992: G_UNEXPECTED_ERROR,
993: G_SQLCODE_TOKEN,

Line 990: OKC_API.set_message

986:
987: EXCEPTION
988: WHEN OTHERS THEN
989: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
990: OKC_API.set_message
991: (OKC_API.G_APP_NAME,
992: G_UNEXPECTED_ERROR,
993: G_SQLCODE_TOKEN,
994: SQLCODE,

Line 991: (OKC_API.G_APP_NAME,

987: EXCEPTION
988: WHEN OTHERS THEN
989: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
990: OKC_API.set_message
991: (OKC_API.G_APP_NAME,
992: G_UNEXPECTED_ERROR,
993: G_SQLCODE_TOKEN,
994: SQLCODE,
995: G_SQLERRM_TOKEN,

Line 1018: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1014: x_msg_data);
1015:
1016: EXCEPTION
1017: WHEN OTHERS THEN
1018: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1019: OKC_API.set_message
1020: (OKC_API.G_APP_NAME,
1021: G_UNEXPECTED_ERROR,
1022: G_SQLCODE_TOKEN,

Line 1019: OKC_API.set_message

1015:
1016: EXCEPTION
1017: WHEN OTHERS THEN
1018: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1019: OKC_API.set_message
1020: (OKC_API.G_APP_NAME,
1021: G_UNEXPECTED_ERROR,
1022: G_SQLCODE_TOKEN,
1023: SQLCODE,

Line 1020: (OKC_API.G_APP_NAME,

1016: EXCEPTION
1017: WHEN OTHERS THEN
1018: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1019: OKC_API.set_message
1020: (OKC_API.G_APP_NAME,
1021: G_UNEXPECTED_ERROR,
1022: G_SQLCODE_TOKEN,
1023: SQLCODE,
1024: G_SQLERRM_TOKEN,

Line 1048: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1044: x_msg_data);
1045:
1046: EXCEPTION
1047: WHEN OTHERS THEN
1048: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1049: OKC_API.set_message
1050: (OKC_API.G_APP_NAME,
1051: G_UNEXPECTED_ERROR,
1052: G_SQLCODE_TOKEN,

Line 1049: OKC_API.set_message

1045:
1046: EXCEPTION
1047: WHEN OTHERS THEN
1048: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1049: OKC_API.set_message
1050: (OKC_API.G_APP_NAME,
1051: G_UNEXPECTED_ERROR,
1052: G_SQLCODE_TOKEN,
1053: SQLCODE,

Line 1050: (OKC_API.G_APP_NAME,

1046: EXCEPTION
1047: WHEN OTHERS THEN
1048: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1049: OKC_API.set_message
1050: (OKC_API.G_APP_NAME,
1051: G_UNEXPECTED_ERROR,
1052: G_SQLCODE_TOKEN,
1053: SQLCODE,
1054: G_SQLERRM_TOKEN,

Line 1136: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1132: END IF;
1133: END LOOP;
1134: END IF;
1135:
1136: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1137: x_status_tbl := l_final_status_tbl;
1138: EXCEPTION
1139: WHEN G_ERROR THEN
1140: NULL;