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.ASO_APR_PUB dependencies on FND_API

Line 10: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

6:
7:
8: PROCEDURE get_all_approvers (
9: p_api_version_number IN NUMBER,
10: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
11: p_commit IN VARCHAR2 := fnd_api.g_false,
12: p_object_id IN NUMBER,
13: p_object_type IN VARCHAR2,
14: p_application_id IN NUMBER,

Line 11: p_commit IN VARCHAR2 := fnd_api.g_false,

7:
8: PROCEDURE get_all_approvers (
9: p_api_version_number IN NUMBER,
10: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
11: p_commit IN VARCHAR2 := fnd_api.g_false,
12: p_object_id IN NUMBER,
13: p_object_type IN VARCHAR2,
14: p_application_id IN NUMBER,
15: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 51: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

47: x_return_status => x_return_status,
48: x_msg_count => x_msg_count,
49: x_msg_data => x_msg_data );
50:
51: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
52: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
53: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
54: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.get_all_approvers_PRE', FALSE);
55: FND_MSG_PUB.ADD;

Line 57: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

53: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
54: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.get_all_approvers_PRE', FALSE);
55: FND_MSG_PUB.ADD;
56: END IF;
57: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
60: RAISE FND_API.G_EXC_ERROR;
61: END IF;

Line 58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

54: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.get_all_approvers_PRE', FALSE);
55: FND_MSG_PUB.ADD;
56: END IF;
57: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
60: RAISE FND_API.G_EXC_ERROR;
61: END IF;
62: END IF;

Line 59: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

55: FND_MSG_PUB.ADD;
56: END IF;
57: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
60: RAISE FND_API.G_EXC_ERROR;
61: END IF;
62: END IF;
63: END IF; -- customer hook

Line 60: RAISE FND_API.G_EXC_ERROR;

56: END IF;
57: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
60: RAISE FND_API.G_EXC_ERROR;
61: END IF;
62: END IF;
63: END IF; -- customer hook
64:

Line 76: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

72: x_return_status => x_return_status,
73: x_msg_count => x_msg_count,
74: x_msg_data => x_msg_data );
75:
76: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
77: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
78: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
79: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.get_all_approvers_PRE', FALSE);
80: FND_MSG_PUB.ADD;

Line 82: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

78: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
79: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.get_all_approvers_PRE', FALSE);
80: FND_MSG_PUB.ADD;
81: END IF;
82: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;

Line 83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

79: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.get_all_approvers_PRE', FALSE);
80: FND_MSG_PUB.ADD;
81: END IF;
82: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87: END IF;

Line 84: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

80: FND_MSG_PUB.ADD;
81: END IF;
82: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87: END IF;
88: END IF; -- vertical hook

Line 85: RAISE FND_API.G_EXC_ERROR;

81: END IF;
82: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87: END IF;
88: END IF; -- vertical hook
89:

Line 97: fnd_api.g_true,

93: p_commit,
94: p_object_id,
95: p_object_type,
96: p_application_id,
97: fnd_api.g_true,
98: x_return_status,
99: x_msg_count,
100: x_msg_data,
101: x_approvers_list,

Line 113: IF x_return_status = FND_API.G_RET_STS_ERROR then

109: );
110: END IF;
111:
112: -- Check return status from the above procedure call
113: IF x_return_status = FND_API.G_RET_STS_ERROR then
114: raise FND_API.G_EXC_ERROR;
115: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
116: raise FND_API.G_EXC_UNEXPECTED_ERROR;
117: END IF;

Line 114: raise FND_API.G_EXC_ERROR;

110: END IF;
111:
112: -- Check return status from the above procedure call
113: IF x_return_status = FND_API.G_RET_STS_ERROR then
114: raise FND_API.G_EXC_ERROR;
115: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
116: raise FND_API.G_EXC_UNEXPECTED_ERROR;
117: END IF;
118:

Line 115: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

111:
112: -- Check return status from the above procedure call
113: IF x_return_status = FND_API.G_RET_STS_ERROR then
114: raise FND_API.G_EXC_ERROR;
115: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
116: raise FND_API.G_EXC_UNEXPECTED_ERROR;
117: END IF;
118:
119: -- Calling the POST hooks

Line 116: raise FND_API.G_EXC_UNEXPECTED_ERROR;

112: -- Check return status from the above procedure call
113: IF x_return_status = FND_API.G_RET_STS_ERROR then
114: raise FND_API.G_EXC_ERROR;
115: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
116: raise FND_API.G_EXC_UNEXPECTED_ERROR;
117: END IF;
118:
119: -- Calling the POST hooks
120:

Line 131: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

127: x_return_status => x_return_status,
128: x_msg_count => x_msg_count,
129: x_msg_data => x_msg_data );
130:
131: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
132: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
133: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
134: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.get_all_approvers_POST', FALSE);
135: FND_MSG_PUB.ADD;

Line 137: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

133: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
134: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.get_all_approvers_POST', FALSE);
135: FND_MSG_PUB.ADD;
136: END IF;
137: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
140: RAISE FND_API.G_EXC_ERROR;
141: END IF;

Line 138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

134: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.get_all_approvers_POST', FALSE);
135: FND_MSG_PUB.ADD;
136: END IF;
137: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
140: RAISE FND_API.G_EXC_ERROR;
141: END IF;
142: END IF;

Line 139: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

135: FND_MSG_PUB.ADD;
136: END IF;
137: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
140: RAISE FND_API.G_EXC_ERROR;
141: END IF;
142: END IF;
143: END IF; -- customer hook

Line 140: RAISE FND_API.G_EXC_ERROR;

136: END IF;
137: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
140: RAISE FND_API.G_EXC_ERROR;
141: END IF;
142: END IF;
143: END IF; -- customer hook
144:

Line 156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

152: x_return_status => x_return_status,
153: x_msg_count => x_msg_count,
154: x_msg_data => x_msg_data );
155:
156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
157: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
158: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
159: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.get_all_approvers_POST', FALSE);
160: FND_MSG_PUB.ADD;

Line 162: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

158: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
159: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.get_all_approvers_POST', FALSE);
160: FND_MSG_PUB.ADD;
161: END IF;
162: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
165: RAISE FND_API.G_EXC_ERROR;
166: END IF;

Line 163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

159: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.get_all_approvers_POST', FALSE);
160: FND_MSG_PUB.ADD;
161: END IF;
162: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
165: RAISE FND_API.G_EXC_ERROR;
166: END IF;
167: END IF;

Line 164: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

160: FND_MSG_PUB.ADD;
161: END IF;
162: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
165: RAISE FND_API.G_EXC_ERROR;
166: END IF;
167: END IF;
168: END IF; -- vertical hook

Line 165: RAISE FND_API.G_EXC_ERROR;

161: END IF;
162: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
165: RAISE FND_API.G_EXC_ERROR;
166: END IF;
167: END IF;
168: END IF; -- vertical hook
169:

Line 171: IF FND_API.to_Boolean( p_commit )

167: END IF;
168: END IF; -- vertical hook
169:
170: -- Standard check for p_commit
171: IF FND_API.to_Boolean( p_commit )
172: THEN
173: COMMIT WORK;
174: END IF;
175:

Line 191: WHEN FND_API.G_EXC_ERROR THEN

187: );
188: END IF;
189:
190: EXCEPTION
191: WHEN FND_API.G_EXC_ERROR THEN
192: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
193: P_API_NAME => L_API_NAME
194: ,P_PKG_NAME => G_PKG_NAME
195: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

197: ,X_MSG_COUNT => X_MSG_COUNT
198: ,X_MSG_DATA => X_MSG_DATA
199: ,X_RETURN_STATUS => X_RETURN_STATUS);
200:
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
203: P_API_NAME => L_API_NAME
204: ,P_PKG_NAME => G_PKG_NAME
205: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 225: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

221: END get_all_approvers;
222:
223: PROCEDURE start_approval_process (
224: p_api_version_number IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
226: p_commit IN VARCHAR2 := fnd_api.g_false,
227: p_object_id IN NUMBER,
228: p_object_type IN VARCHAR2,
229: p_application_id IN NUMBER,

Line 226: p_commit IN VARCHAR2 := fnd_api.g_false,

222:
223: PROCEDURE start_approval_process (
224: p_api_version_number IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
226: p_commit IN VARCHAR2 := fnd_api.g_false,
227: p_object_id IN NUMBER,
228: p_object_type IN VARCHAR2,
229: p_application_id IN NUMBER,
230: p_approver_sequence IN NUMBER := fnd_api.g_miss_num,

Line 230: p_approver_sequence IN NUMBER := fnd_api.g_miss_num,

226: p_commit IN VARCHAR2 := fnd_api.g_false,
227: p_object_id IN NUMBER,
228: p_object_type IN VARCHAR2,
229: p_application_id IN NUMBER,
230: p_approver_sequence IN NUMBER := fnd_api.g_miss_num,
231: p_requester_comments IN VARCHAR2,
232: x_object_approval_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
233: x_approval_instance_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
234: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

267: x_return_status => x_return_status,
268: x_msg_count => x_msg_count,
269: x_msg_data => x_msg_data);
270:
271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
272: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
273: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
274: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.start_approval_process_PRE', FALSE);
275: FND_MSG_PUB.ADD;

Line 277: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

273: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
274: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.start_approval_process_PRE', FALSE);
275: FND_MSG_PUB.ADD;
276: END IF;
277: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
280: RAISE FND_API.G_EXC_ERROR;
281: END IF;

Line 278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

274: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.start_approval_process_PRE', FALSE);
275: FND_MSG_PUB.ADD;
276: END IF;
277: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
280: RAISE FND_API.G_EXC_ERROR;
281: END IF;
282: END IF;

Line 279: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

275: FND_MSG_PUB.ADD;
276: END IF;
277: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
280: RAISE FND_API.G_EXC_ERROR;
281: END IF;
282: END IF;
283: END IF; -- customer hook

Line 280: RAISE FND_API.G_EXC_ERROR;

276: END IF;
277: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
280: RAISE FND_API.G_EXC_ERROR;
281: END IF;
282: END IF;
283: END IF; -- customer hook
284:

Line 298: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

294: x_return_status => x_return_status,
295: x_msg_count => x_msg_count,
296: x_msg_data => x_msg_data);
297:
298: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
299: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
300: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
301: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.start_approval_process_PRE', FALSE);
302: FND_MSG_PUB.ADD;

Line 304: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

300: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
301: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.start_approval_process_PRE', FALSE);
302: FND_MSG_PUB.ADD;
303: END IF;
304: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
307: RAISE FND_API.G_EXC_ERROR;
308: END IF;

Line 305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

301: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.start_approval_process_PRE', FALSE);
302: FND_MSG_PUB.ADD;
303: END IF;
304: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
307: RAISE FND_API.G_EXC_ERROR;
308: END IF;
309: END IF;

Line 306: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

302: FND_MSG_PUB.ADD;
303: END IF;
304: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
307: RAISE FND_API.G_EXC_ERROR;
308: END IF;
309: END IF;
310: END IF; -- vertical hook

Line 307: RAISE FND_API.G_EXC_ERROR;

303: END IF;
304: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
307: RAISE FND_API.G_EXC_ERROR;
308: END IF;
309: END IF;
310: END IF; -- vertical hook
311:

Line 337: IF x_return_status = FND_API.G_RET_STS_ERROR then

333: END IF;
334:
335:
336: -- Check return status from the above procedure call
337: IF x_return_status = FND_API.G_RET_STS_ERROR then
338: raise FND_API.G_EXC_ERROR;
339: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
340: raise FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;

Line 338: raise FND_API.G_EXC_ERROR;

334:
335:
336: -- Check return status from the above procedure call
337: IF x_return_status = FND_API.G_RET_STS_ERROR then
338: raise FND_API.G_EXC_ERROR;
339: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
340: raise FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342:

Line 339: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

335:
336: -- Check return status from the above procedure call
337: IF x_return_status = FND_API.G_RET_STS_ERROR then
338: raise FND_API.G_EXC_ERROR;
339: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
340: raise FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342:
343: -- Calling the POST hooks

Line 340: raise FND_API.G_EXC_UNEXPECTED_ERROR;

336: -- Check return status from the above procedure call
337: IF x_return_status = FND_API.G_RET_STS_ERROR then
338: raise FND_API.G_EXC_ERROR;
339: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
340: raise FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342:
343: -- Calling the POST hooks
344:

Line 357: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

353: x_return_status => x_return_status,
354: x_msg_count => x_msg_count,
355: x_msg_data => x_msg_data);
356:
357: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
358: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
359: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
360: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.start_approval_process_POST', FALSE);
361: FND_MSG_PUB.ADD;

Line 363: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

359: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
360: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.start_approval_process_POST', FALSE);
361: FND_MSG_PUB.ADD;
362: END IF;
363: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
366: RAISE FND_API.G_EXC_ERROR;
367: END IF;

Line 364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

360: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.start_approval_process_POST', FALSE);
361: FND_MSG_PUB.ADD;
362: END IF;
363: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
366: RAISE FND_API.G_EXC_ERROR;
367: END IF;
368: END IF;

Line 365: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

361: FND_MSG_PUB.ADD;
362: END IF;
363: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
366: RAISE FND_API.G_EXC_ERROR;
367: END IF;
368: END IF;
369: END IF; -- customer hook

Line 366: RAISE FND_API.G_EXC_ERROR;

362: END IF;
363: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
366: RAISE FND_API.G_EXC_ERROR;
367: END IF;
368: END IF;
369: END IF; -- customer hook
370:

Line 384: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

380: x_return_status => x_return_status,
381: x_msg_count => x_msg_count,
382: x_msg_data => x_msg_data);
383:
384: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
385: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
386: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
387: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.start_approval_process_POST', FALSE);
388: FND_MSG_PUB.ADD;

Line 390: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

386: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
387: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.start_approval_process_POST', FALSE);
388: FND_MSG_PUB.ADD;
389: END IF;
390: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
393: RAISE FND_API.G_EXC_ERROR;
394: END IF;

Line 391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

387: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.start_approval_process_POST', FALSE);
388: FND_MSG_PUB.ADD;
389: END IF;
390: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
393: RAISE FND_API.G_EXC_ERROR;
394: END IF;
395: END IF;

Line 392: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

388: FND_MSG_PUB.ADD;
389: END IF;
390: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
393: RAISE FND_API.G_EXC_ERROR;
394: END IF;
395: END IF;
396: END IF; -- vertical hook

Line 393: RAISE FND_API.G_EXC_ERROR;

389: END IF;
390: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
393: RAISE FND_API.G_EXC_ERROR;
394: END IF;
395: END IF;
396: END IF; -- vertical hook
397:

Line 399: IF FND_API.to_Boolean( p_commit )

395: END IF;
396: END IF; -- vertical hook
397:
398: -- Standard check for p_commit
399: IF FND_API.to_Boolean( p_commit )
400: THEN
401: COMMIT WORK;
402: END IF;
403:

Line 420: WHEN FND_API.G_EXC_ERROR THEN

416: END IF;
417:
418:
419: EXCEPTION
420: WHEN FND_API.G_EXC_ERROR THEN
421: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
422: P_API_NAME => L_API_NAME
423: ,P_PKG_NAME => G_PKG_NAME
424: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

426: ,X_MSG_COUNT => X_MSG_COUNT
427: ,X_MSG_DATA => X_MSG_DATA
428: ,X_RETURN_STATUS => X_RETURN_STATUS);
429:
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
431: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
432: P_API_NAME => L_API_NAME
433: ,P_PKG_NAME => G_PKG_NAME
434: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 502: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

498: END cancel_approval_process;
499:
500: PROCEDURE skip_approver (
501: p_api_version_number IN NUMBER,
502: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
503: p_commit IN VARCHAR2 := fnd_api.g_false,
504: p_object_id IN NUMBER,
505: p_object_type IN VARCHAR2,
506: p_approver_id IN NUMBER,

Line 503: p_commit IN VARCHAR2 := fnd_api.g_false,

499:
500: PROCEDURE skip_approver (
501: p_api_version_number IN NUMBER,
502: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
503: p_commit IN VARCHAR2 := fnd_api.g_false,
504: p_object_id IN NUMBER,
505: p_object_type IN VARCHAR2,
506: p_approver_id IN NUMBER,
507: p_approval_instance_id IN NUMBER,

Line 548: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

544: END skip_approver;
545:
546: PROCEDURE get_rule_details (
547: p_api_version_number IN NUMBER,
548: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
549: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
550: p_object_approval_id IN NUMBER,
551: x_rules_list OUT NOCOPY /* file.sql.39 change */ aso_apr_pub.rules_list_tbl_type,
552: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 549: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

545:
546: PROCEDURE get_rule_details (
547: p_api_version_number IN NUMBER,
548: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
549: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
550: p_object_approval_id IN NUMBER,
551: x_rules_list OUT NOCOPY /* file.sql.39 change */ aso_apr_pub.rules_list_tbl_type,
552: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
553: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 592: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

588: END get_rule_details;
589:
590: PROCEDURE start_approval_workflow (
591: p_api_version_number IN NUMBER,
592: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
593: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
594: p_object_approval_id IN NUMBER,
595: p_itemtype IN VARCHAR2,
596: p_sender_name IN VARCHAR2,

Line 593: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

589:
590: PROCEDURE start_approval_workflow (
591: p_api_version_number IN NUMBER,
592: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
593: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
594: p_object_approval_id IN NUMBER,
595: p_itemtype IN VARCHAR2,
596: p_sender_name IN VARCHAR2,
597: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,