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

Line 22: p_organization_id = FND_API.G_MISS_NUM ) THEN

18: ) RETURN VARCHAR2
19: IS
20: BEGIN
21: IF ( p_organization_id IS NULL OR
22: p_organization_id = FND_API.G_MISS_NUM ) THEN
23: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_ID_NULL' );
24: FND_MSG_PUB.add;
25: RETURN FND_API.G_RET_STS_ERROR;
26: END IF;

Line 25: RETURN FND_API.G_RET_STS_ERROR;

21: IF ( p_organization_id IS NULL OR
22: p_organization_id = FND_API.G_MISS_NUM ) THEN
23: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_ID_NULL' );
24: FND_MSG_PUB.add;
25: RETURN FND_API.G_RET_STS_ERROR;
26: END IF;
27:
28: IF ( p_transaction_number IS NULL OR
29: p_transaction_number = FND_API.G_MISS_NUM ) THEN

Line 29: p_transaction_number = FND_API.G_MISS_NUM ) THEN

25: RETURN FND_API.G_RET_STS_ERROR;
26: END IF;
27:
28: IF ( p_transaction_number IS NULL OR
29: p_transaction_number = FND_API.G_MISS_NUM ) THEN
30: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_TXN_NO_NULL' );
31: FND_MSG_PUB.add;
32: RETURN FND_API.G_RET_STS_ERROR;
33: END IF;

Line 32: RETURN FND_API.G_RET_STS_ERROR;

28: IF ( p_transaction_number IS NULL OR
29: p_transaction_number = FND_API.G_MISS_NUM ) THEN
30: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_TXN_NO_NULL' );
31: FND_MSG_PUB.add;
32: RETURN FND_API.G_RET_STS_ERROR;
33: END IF;
34:
35: IF ( p_col_trigger_value IS NULL OR
36: p_col_trigger_value = FND_API.G_MISS_NUM ) THEN

Line 36: p_col_trigger_value = FND_API.G_MISS_NUM ) THEN

32: RETURN FND_API.G_RET_STS_ERROR;
33: END IF;
34:
35: IF ( p_col_trigger_value IS NULL OR
36: p_col_trigger_value = FND_API.G_MISS_NUM ) THEN
37: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INSPECTION_TYPE_NULL' );
38: FND_MSG_PUB.add;
39: RETURN FND_API.G_RET_STS_ERROR;
40: END IF;

Line 39: RETURN FND_API.G_RET_STS_ERROR;

35: IF ( p_col_trigger_value IS NULL OR
36: p_col_trigger_value = FND_API.G_MISS_NUM ) THEN
37: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INSPECTION_TYPE_NULL' );
38: FND_MSG_PUB.add;
39: RETURN FND_API.G_RET_STS_ERROR;
40: END IF;
41:
42: END validate_gqp_inputs;
43:

Line 117: p_plan_id = FND_API.G_MISS_NUM ) THEN

113:
114: BEGIN
115:
116: IF ( p_plan_id IS NULL OR
117: p_plan_id = FND_API.G_MISS_NUM ) THEN
118: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_PLAN_ID_NULL' );
119: FND_MSG_PUB.add;
120: RETURN FND_API.G_RET_STS_ERROR;
121: END IF;

Line 120: RETURN FND_API.G_RET_STS_ERROR;

116: IF ( p_plan_id IS NULL OR
117: p_plan_id = FND_API.G_MISS_NUM ) THEN
118: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_PLAN_ID_NULL' );
119: FND_MSG_PUB.add;
120: RETURN FND_API.G_RET_STS_ERROR;
121: END IF;
122:
123: IF ( p_organization_id IS NULL OR
124: p_organization_id = FND_API.G_MISS_NUM ) THEN

Line 124: p_organization_id = FND_API.G_MISS_NUM ) THEN

120: RETURN FND_API.G_RET_STS_ERROR;
121: END IF;
122:
123: IF ( p_organization_id IS NULL OR
124: p_organization_id = FND_API.G_MISS_NUM ) THEN
125: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_ID_NULL' );
126: FND_MSG_PUB.add;
127: RETURN FND_API.G_RET_STS_ERROR;
128: END IF;

Line 127: RETURN FND_API.G_RET_STS_ERROR;

123: IF ( p_organization_id IS NULL OR
124: p_organization_id = FND_API.G_MISS_NUM ) THEN
125: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_ID_NULL' );
126: FND_MSG_PUB.add;
127: RETURN FND_API.G_RET_STS_ERROR;
128: END IF;
129:
130: IF ( p_results_tbl.COUNT = 0 ) THEN
131: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ONE_RESULT_REQD' );

Line 133: RETURN FND_API.G_RET_STS_ERROR;

129:
130: IF ( p_results_tbl.COUNT = 0 ) THEN
131: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ONE_RESULT_REQD' );
132: FND_MSG_PUB.add;
133: RETURN FND_API.G_RET_STS_ERROR;
134: END IF;
135:
136: BEGIN
137: SELECT organization_id

Line 146: RETURN FND_API.G_RET_STS_ERROR;

142: EXCEPTION
143: WHEN NO_DATA_FOUND THEN
144: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_PLAN_NOT_FOUND' );
145: FND_MSG_PUB.add;
146: RETURN FND_API.G_RET_STS_ERROR;
147: END;
148:
149: -- rroy
150: -- ACL Changes

Line 176: IF l_return_status = FND_API.G_TRUE THEN

172: --nsikka
173: --Changes made for Bug 5324101 .
174: --tokens passed changed to MR_TITLE
175:
176: IF l_return_status = FND_API.G_TRUE THEN
177: OPEN ue_title_csr(l_unit_effectivity_id);
178: FETCH ue_title_csr INTO l_mr_title;
179: CLOSE ue_title_csr;
180: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_MR_QA_UNTLCKD');

Line 183: RETURN FND_API.G_RET_STS_ERROR;

179: CLOSE ue_title_csr;
180: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_MR_QA_UNTLCKD');
181: FND_MESSAGE.Set_Token('MR_TITLE', l_mr_title);
182: FND_MSG_PUB.ADD;
183: RETURN FND_API.G_RET_STS_ERROR;
184: END IF;
185: ELSIF p_transaction_no = G_JOB_TXN_NO THEN
186: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id, p_ue_id => NULL,
187: p_visit_id => NULL,

Line 189: IF l_return_status = FND_API.G_TRUE THEN

185: ELSIF p_transaction_no = G_JOB_TXN_NO THEN
186: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id, p_ue_id => NULL,
187: p_visit_id => NULL,
188: p_item_instance_id => NULL);
189: IF l_return_status = FND_API.G_TRUE THEN
190: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_WO_QA_UNTLCKD');
191: FND_MSG_PUB.ADD;
192: RETURN FND_API.G_RET_STS_ERROR;
193: END IF;

Line 192: RETURN FND_API.G_RET_STS_ERROR;

188: p_item_instance_id => NULL);
189: IF l_return_status = FND_API.G_TRUE THEN
190: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_WO_QA_UNTLCKD');
191: FND_MSG_PUB.ADD;
192: RETURN FND_API.G_RET_STS_ERROR;
193: END IF;
194: ELSIF p_transaction_no = G_OP_TXN_NO THEN
195: OPEN get_wo_from_op(l_workorder_operation_id);
196: FETCH get_wo_from_op INTO l_workorder_id;

Line 202: IF l_return_status = FND_API.G_TRUE THEN

198:
199: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id, p_ue_id => NULL,
200: p_visit_id => NULL,
201: p_item_instance_id => NULL);
202: IF l_return_status = FND_API.G_TRUE THEN
203: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_OP_QA_UNTLCKD');
204: FND_MSG_PUB.ADD;
205: RETURN FND_API.G_RET_STS_ERROR;
206: END IF;

Line 205: RETURN FND_API.G_RET_STS_ERROR;

201: p_item_instance_id => NULL);
202: IF l_return_status = FND_API.G_TRUE THEN
203: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_OP_QA_UNTLCKD');
204: FND_MSG_PUB.ADD;
205: RETURN FND_API.G_RET_STS_ERROR;
206: END IF;
207: END IF;
208:
209:

Line 214: RETURN FND_API.G_RET_STS_ERROR;

210:
211: IF ( l_organization_id <> p_organization_id ) THEN
212: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_MISMATCH' );
213: FND_MSG_PUB.add;
214: RETURN FND_API.G_RET_STS_ERROR;
215: END IF;
216:
217: IF ( p_collection_id IS NOT NULL AND
218: p_collection_id <> FND_API.G_MISS_NUM ) THEN

Line 218: p_collection_id <> FND_API.G_MISS_NUM ) THEN

214: RETURN FND_API.G_RET_STS_ERROR;
215: END IF;
216:
217: IF ( p_collection_id IS NOT NULL AND
218: p_collection_id <> FND_API.G_MISS_NUM ) THEN
219: FOR results_cursor IN get_plan_from_results( p_collection_id ) LOOP
220: IF ( results_cursor.plan_id <> p_plan_id ) THEN
221: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_COLL_MANY_PLANS' );
222: FND_MSG_PUB.add;

Line 224: RETURN FND_API.G_RET_STS_ERROR;

220: IF ( results_cursor.plan_id <> p_plan_id ) THEN
221: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_COLL_MANY_PLANS' );
222: FND_MSG_PUB.add;
223: CLOSE get_plan_from_results;
224: RETURN FND_API.G_RET_STS_ERROR;
225: END IF;
226:
227: l_element_count := l_element_count + 1;
228: END LOOP;

Line 233: RETURN FND_API.G_RET_STS_ERROR;

229:
230: IF ( l_element_count = 1 ) THEN
231: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_COLL_NOT_FOUND' );
232: FND_MSG_PUB.add;
233: RETURN FND_API.G_RET_STS_ERROR;
234: END IF;
235:
236: END IF;
237:

Line 257: RETURN FND_API.G_RET_STS_ERROR;

253:
254: IF ( l_match_found = FALSE ) THEN
255: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_RESULTS_NO_PLAN_CHAR' );
256: FND_MSG_PUB.add;
257: RETURN FND_API.G_RET_STS_ERROR;
258: END IF;
259:
260: l_match_found := FALSE;
261:

Line 276: RETURN FND_API.G_RET_STS_ERROR;

272:
273: IF ( l_match_found = FALSE ) THEN
274: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_HIDDEN_NO_PLAN_CHAR' );
275: FND_MSG_PUB.add;
276: RETURN FND_API.G_RET_STS_ERROR;
277: END IF;
278:
279: l_match_found := FALSE;
280:

Line 283: RETURN FND_API.G_RET_STS_SUCCESS;

279: l_match_found := FALSE;
280:
281: END LOOP;
282:
283: RETURN FND_API.G_RET_STS_SUCCESS;
284: END validate_sqar_inputs;
285:
286: FUNCTION fire_ahl_actions
287: (

Line 327: RETURN FND_API.G_RET_STS_ERROR;

323: IF ( l_unit_effectivity_id IS NULL OR
324: l_object_version_number IS NULL ) THEN
325: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_UE_INPUTS' );
326: FND_MSG_PUB.add;
327: RETURN FND_API.G_RET_STS_ERROR;
328: END IF;
329:
330: -- Change to call capture_mr_updates
331: UPDATE AHL_UNIT_EFFECTIVITIES_B

Line 343: RETURN FND_API.G_RET_STS_ERROR;

339:
340: IF ( SQL%ROWCOUNT = 0 ) THEN
341: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_UE_NOT_FOUND' );
342: FND_MSG_PUB.add;
343: RETURN FND_API.G_RET_STS_ERROR;
344: END IF;
345:
346: ELSIF ( p_transaction_no = G_JOB_TXN_NO ) THEN
347:

Line 352: RETURN FND_API.G_RET_STS_ERROR;

348: IF ( l_workorder_id IS NULL OR
349: l_object_version_number IS NULL ) THEN
350: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_WO_INPUTS' );
351: FND_MSG_PUB.add;
352: RETURN FND_API.G_RET_STS_ERROR;
353: END IF;
354:
355: UPDATE AHL_WORKORDERS
356: SET collection_id = p_collection_id,

Line 367: RETURN FND_API.G_RET_STS_ERROR;

363:
364: IF ( SQL%ROWCOUNT = 0 ) THEN
365: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_NOT_FOUND' );
366: FND_MSG_PUB.add;
367: RETURN FND_API.G_RET_STS_ERROR;
368: END IF;
369:
370: ELSIF ( p_transaction_no = G_OP_TXN_NO ) THEN
371:

Line 376: RETURN FND_API.G_RET_STS_ERROR;

372: IF ( l_workorder_operation_id IS NULL OR
373: l_object_version_number IS NULL ) THEN
374: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_COP_INPUTS' );
375: FND_MSG_PUB.add;
376: RETURN FND_API.G_RET_STS_ERROR;
377: END IF;
378:
379: UPDATE AHL_WORKORDER_OPERATIONS
380: SET collection_id = p_collection_id,

Line 391: RETURN FND_API.G_RET_STS_ERROR;

387:
388: IF ( SQL%ROWCOUNT = 0 ) THEN
389: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_OP_NOT_FOUND' );
390: FND_MSG_PUB.add;
391: RETURN FND_API.G_RET_STS_ERROR;
392: END IF;
393:
394: ELSIF ( p_transaction_no = G_MRB_TXN_NO ) THEN
395: NULL;

Line 400: RETURN FND_API.G_RET_STS_SUCCESS;

396: ELSE
397: NULL;
398: END IF;
399:
400: RETURN FND_API.G_RET_STS_SUCCESS;
401:
402: END fire_ahl_actions;
403:
404: FUNCTION form_hidden_qa_result_string

Line 445: RETURN FND_API.G_RET_STS_SUCCESS;

441: END IF;
442:
443: END LOOP;
444:
445: RETURN FND_API.G_RET_STS_SUCCESS;
446: END form_hidden_qa_result_string;
447:
448: FUNCTION form_qa_result_string
449: (

Line 473: RETURN FND_API.G_RET_STS_SUCCESS;

469: END IF;
470:
471: END LOOP;
472:
473: RETURN FND_API.G_RET_STS_SUCCESS;
474: END form_qa_result_string;
475:
476: PROCEDURE submit_qa_results
477: (

Line 479: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

475:
476: PROCEDURE submit_qa_results
477: (
478: p_api_version IN NUMBER := 1.0,
479: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
480: p_commit IN VARCHAR2 := FND_API.G_FALSE,
481: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482: p_default IN VARCHAR2 := FND_API.G_FALSE,
483: p_module_type IN VARCHAR2 := NULL,

Line 480: p_commit IN VARCHAR2 := FND_API.G_FALSE,

476: PROCEDURE submit_qa_results
477: (
478: p_api_version IN NUMBER := 1.0,
479: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
480: p_commit IN VARCHAR2 := FND_API.G_FALSE,
481: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482: p_default IN VARCHAR2 := FND_API.G_FALSE,
483: p_module_type IN VARCHAR2 := NULL,
484: x_return_status OUT NOCOPY VARCHAR2,

Line 481: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

477: (
478: p_api_version IN NUMBER := 1.0,
479: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
480: p_commit IN VARCHAR2 := FND_API.G_FALSE,
481: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482: p_default IN VARCHAR2 := FND_API.G_FALSE,
483: p_module_type IN VARCHAR2 := NULL,
484: x_return_status OUT NOCOPY VARCHAR2,
485: x_msg_count OUT NOCOPY NUMBER,

Line 482: p_default IN VARCHAR2 := FND_API.G_FALSE,

478: p_api_version IN NUMBER := 1.0,
479: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
480: p_commit IN VARCHAR2 := FND_API.G_FALSE,
481: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482: p_default IN VARCHAR2 := FND_API.G_FALSE,
483: p_module_type IN VARCHAR2 := NULL,
484: x_return_status OUT NOCOPY VARCHAR2,
485: x_msg_count OUT NOCOPY NUMBER,
486: x_msg_data OUT NOCOPY VARCHAR2,

Line 519: x_return_status := FND_API.G_RET_STS_SUCCESS;

515: AHL_DEBUG_PUB.enable_debug;
516: END IF;
517:
518: -- Initialize API return status to success
519: x_return_status := FND_API.G_RET_STS_SUCCESS;
520:
521: -- Standard Start of API savepoint
522: SAVEPOINT submit_qa_results_PVT;
523:

Line 525: IF FND_API.to_boolean( p_init_msg_list ) THEN

521: -- Standard Start of API savepoint
522: SAVEPOINT submit_qa_results_PVT;
523:
524: -- Initialize message list if p_init_msg_list is set to TRUE.
525: IF FND_API.to_boolean( p_init_msg_list ) THEN
526: FND_MSG_PUB.initialize;
527: END IF;
528:
529: l_return_status :=

Line 543: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

539: p_result_commit_flag => p_result_commit_flag,
540: p_collection_id => p_x_collection_id
541: );
542:
543: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
544: RAISE FND_API.G_EXC_ERROR;
545: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
547: END IF;

Line 544: RAISE FND_API.G_EXC_ERROR;

540: p_collection_id => p_x_collection_id
541: );
542:
543: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
544: RAISE FND_API.G_EXC_ERROR;
545: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
547: END IF;
548:

Line 545: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

541: );
542:
543: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
544: RAISE FND_API.G_EXC_ERROR;
545: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
547: END IF;
548:
549: IF G_DEBUG = 'Y' THEN

Line 546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

542:
543: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
544: RAISE FND_API.G_EXC_ERROR;
545: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
547: END IF;
548:
549: IF G_DEBUG = 'Y' THEN
550: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After validating Inputs ' );

Line 580: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

576: p_id_or_value => p_id_or_value,
577: x_result_string => l_hidden_result_string
578: );
579:
580: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
581: RAISE FND_API.G_EXC_ERROR;
582: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
584: END IF;

Line 581: RAISE FND_API.G_EXC_ERROR;

577: x_result_string => l_hidden_result_string
578: );
579:
580: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
581: RAISE FND_API.G_EXC_ERROR;
582: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
584: END IF;
585:

Line 582: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

578: );
579:
580: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
581: RAISE FND_API.G_EXC_ERROR;
582: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
584: END IF;
585:
586: IF G_DEBUG = 'Y' THEN

Line 583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

579:
580: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
581: RAISE FND_API.G_EXC_ERROR;
582: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
584: END IF;
585:
586: IF G_DEBUG = 'Y' THEN
587: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Forming Hidden Result String : ' || l_hidden_result_string );

Line 602: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

598: p_id_or_value => p_id_or_value,
599: x_result_string => l_result_string
600: );
601:
602: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
603: RAISE FND_API.G_EXC_ERROR;
604: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;

Line 603: RAISE FND_API.G_EXC_ERROR;

599: x_result_string => l_result_string
600: );
601:
602: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
603: RAISE FND_API.G_EXC_ERROR;
604: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607:

Line 604: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

600: );
601:
602: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
603: RAISE FND_API.G_EXC_ERROR;
604: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607:
608: IF G_DEBUG = 'Y' THEN

Line 605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

601:
602: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
603: RAISE FND_API.G_EXC_ERROR;
604: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607:
608: IF G_DEBUG = 'Y' THEN
609: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Forming Result String : ' || l_result_string || ' for row : ' || i );

Line 619: p_transaction_no = FND_API.G_MISS_NUM ) THEN

615: l_result_string := l_result_string || '@' || l_hidden_result_string;
616: END IF;
617:
618: IF ( p_transaction_no IS NULL OR
619: p_transaction_no = FND_API.G_MISS_NUM ) THEN
620: l_qa_post_result :=
621: QA_SS_RESULTS.nontxn_post_result
622: (
623: x_occurrence => l_occurrence,

Line 688: RAISE FND_API.G_EXC_ERROR;

684:
685: IF ( l_msg_data IS NULL ) THEN
686: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_POST_UNEXP_ERROR' );
687: FND_MSG_PUB.add;
688: RAISE FND_API.G_EXC_ERROR;
689: ELSE
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: x_msg_data := l_msg_data;
692: x_msg_count := 1;

Line 690: x_return_status := FND_API.G_RET_STS_ERROR;

686: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_POST_UNEXP_ERROR' );
687: FND_MSG_PUB.add;
688: RAISE FND_API.G_EXC_ERROR;
689: ELSE
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: x_msg_data := l_msg_data;
692: x_msg_count := 1;
693: RETURN;
694: END IF;

Line 722: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

718: p_context_tbl => p_context_tbl,
719: p_collection_id => p_x_collection_id
720: );
721:
722: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
723: IF ( l_msg_data IS NOT NULL ) THEN
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: x_msg_data := l_msg_data;
726: x_msg_count := 1;

Line 724: x_return_status := FND_API.G_RET_STS_ERROR;

720: );
721:
722: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
723: IF ( l_msg_data IS NOT NULL ) THEN
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: x_msg_data := l_msg_data;
726: x_msg_count := 1;
727: RETURN;
728: ELSE

Line 729: RAISE FND_API.G_EXC_ERROR;

725: x_msg_data := l_msg_data;
726: x_msg_count := 1;
727: RETURN;
728: ELSE
729: RAISE FND_API.G_EXC_ERROR;
730: END IF;
731: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: END IF;

Line 731: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

727: RETURN;
728: ELSE
729: RAISE FND_API.G_EXC_ERROR;
730: END IF;
731: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: END IF;
734:
735: IF G_DEBUG = 'Y' THEN

Line 732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

728: ELSE
729: RAISE FND_API.G_EXC_ERROR;
730: END IF;
731: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: END IF;
734:
735: IF G_DEBUG = 'Y' THEN
736: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Firing AHL Actions ' );

Line 743: --IF ( l_committed = 2 AND FND_API.to_boolean( p_commit ) ) THEN

739:
740: -- Fix for bug# 5501482.
741: --IF ( l_committed = 1 ) THEN
742: IF ( l_committed = 2 ) THEN
743: --IF ( l_committed = 2 AND FND_API.to_boolean( p_commit ) ) THEN
744: QA_SS_RESULTS.wrapper_fire_action
745: (
746: q_collection_id => p_x_collection_id,
747: q_return_status => l_return_status,

Line 752: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

748: q_msg_count => l_msg_count,
749: q_msg_data => l_msg_data
750: );
751:
752: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
753: IF ( l_msg_data IS NULL ) THEN
754: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_ACTION_UNEXP_ERROR' );
755: FND_MSG_PUB.add;
756: RAISE FND_API.G_EXC_ERROR;

Line 756: RAISE FND_API.G_EXC_ERROR;

752: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
753: IF ( l_msg_data IS NULL ) THEN
754: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_ACTION_UNEXP_ERROR' );
755: FND_MSG_PUB.add;
756: RAISE FND_API.G_EXC_ERROR;
757: ELSE
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: x_msg_data := l_msg_data;
760: x_msg_count := 1;

Line 758: x_return_status := FND_API.G_RET_STS_ERROR;

754: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_ACTION_UNEXP_ERROR' );
755: FND_MSG_PUB.add;
756: RAISE FND_API.G_EXC_ERROR;
757: ELSE
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: x_msg_data := l_msg_data;
760: x_msg_count := 1;
761: RETURN;
762: END IF;

Line 763: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

759: x_msg_data := l_msg_data;
760: x_msg_count := 1;
761: RETURN;
762: END IF;
763: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
765: END IF;
766:
767: IF G_DEBUG = 'Y' THEN

Line 764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

760: x_msg_count := 1;
761: RETURN;
762: END IF;
763: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
765: END IF;
766:
767: IF G_DEBUG = 'Y' THEN
768: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Firing QA Actions ' || l_msg_data );

Line 778: IF ( FND_API.to_boolean( p_commit ) ) THEN

774: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : returned message: ' || x_msg_data );
775: END IF;
776:
777: -- Perform the Commit (if requested)
778: IF ( FND_API.to_boolean( p_commit ) ) THEN
779: COMMIT WORK;
780: END IF;
781:
782:

Line 789: WHEN FND_API.G_EXC_ERROR THEN

785: END IF;
786:
787: EXCEPTION
788:
789: WHEN FND_API.G_EXC_ERROR THEN
790: ROLLBACK TO submit_qa_results_PVT;
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: FND_MSG_PUB.count_and_get
793: (

Line 791: x_return_status := FND_API.G_RET_STS_ERROR;

787: EXCEPTION
788:
789: WHEN FND_API.G_EXC_ERROR THEN
790: ROLLBACK TO submit_qa_results_PVT;
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: FND_MSG_PUB.count_and_get
793: (
794: p_encoded => FND_API.G_FALSE,
795: p_count => x_msg_count,

Line 794: p_encoded => FND_API.G_FALSE,

790: ROLLBACK TO submit_qa_results_PVT;
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: FND_MSG_PUB.count_and_get
793: (
794: p_encoded => FND_API.G_FALSE,
795: p_count => x_msg_count,
796: p_data => x_msg_data
797: );
798:

Line 803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

799: IF ( G_DEBUG = 'Y' ) THEN
800: AHL_DEBUG_PUB.disable_debug;
801: END IF;
802:
803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
804: ROLLBACK TO submit_qa_results_PVT;
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
806: FND_MSG_PUB.count_and_get
807: (

Line 805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

801: END IF;
802:
803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
804: ROLLBACK TO submit_qa_results_PVT;
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
806: FND_MSG_PUB.count_and_get
807: (
808: p_encoded => FND_API.G_FALSE,
809: p_count => x_msg_count,

Line 808: p_encoded => FND_API.G_FALSE,

804: ROLLBACK TO submit_qa_results_PVT;
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
806: FND_MSG_PUB.count_and_get
807: (
808: p_encoded => FND_API.G_FALSE,
809: p_count => x_msg_count,
810: p_data => x_msg_data
811: );
812:

Line 819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

815: END IF;
816:
817: WHEN OTHERS THEN
818: ROLLBACK TO submit_qa_results_PVT;
819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
820: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
821: THEN
822: FND_MSG_PUB.add_exc_msg
823: (

Line 831: p_encoded => FND_API.G_FALSE,

827: );
828: END IF;
829: FND_MSG_PUB.count_and_get
830: (
831: p_encoded => FND_API.G_FALSE,
832: p_count => x_msg_count,
833: p_data => x_msg_data
834: );
835:

Line 845: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

841:
842: PROCEDURE get_char_lov_sql
843: (
844: p_api_version IN NUMBER := 1.0,
845: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
846: p_commit IN VARCHAR2 := FND_API.G_FALSE,
847: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
848: p_default IN VARCHAR2 := FND_API.G_FALSE,
849: p_module_type IN VARCHAR2 := NULL,

Line 846: p_commit IN VARCHAR2 := FND_API.G_FALSE,

842: PROCEDURE get_char_lov_sql
843: (
844: p_api_version IN NUMBER := 1.0,
845: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
846: p_commit IN VARCHAR2 := FND_API.G_FALSE,
847: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
848: p_default IN VARCHAR2 := FND_API.G_FALSE,
849: p_module_type IN VARCHAR2 := NULL,
850: x_return_status OUT NOCOPY VARCHAR2,

Line 847: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

843: (
844: p_api_version IN NUMBER := 1.0,
845: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
846: p_commit IN VARCHAR2 := FND_API.G_FALSE,
847: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
848: p_default IN VARCHAR2 := FND_API.G_FALSE,
849: p_module_type IN VARCHAR2 := NULL,
850: x_return_status OUT NOCOPY VARCHAR2,
851: x_msg_count OUT NOCOPY NUMBER,

Line 848: p_default IN VARCHAR2 := FND_API.G_FALSE,

844: p_api_version IN NUMBER := 1.0,
845: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
846: p_commit IN VARCHAR2 := FND_API.G_FALSE,
847: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
848: p_default IN VARCHAR2 := FND_API.G_FALSE,
849: p_module_type IN VARCHAR2 := NULL,
850: x_return_status OUT NOCOPY VARCHAR2,
851: x_msg_count OUT NOCOPY NUMBER,
852: x_msg_data OUT NOCOPY VARCHAR2,

Line 873: x_return_status := FND_API.G_RET_STS_SUCCESS;

869: AHL_DEBUG_PUB.enable_debug;
870: END IF;
871:
872: -- Initialize API return status to success
873: x_return_status := FND_API.G_RET_STS_SUCCESS;
874:
875: -- Initialize message list if p_init_msg_list is set to TRUE.
876: IF FND_API.to_boolean( p_init_msg_list ) THEN
877: FND_MSG_PUB.initialize;

Line 876: IF FND_API.to_boolean( p_init_msg_list ) THEN

872: -- Initialize API return status to success
873: x_return_status := FND_API.G_RET_STS_SUCCESS;
874:
875: -- Initialize message list if p_init_msg_list is set to TRUE.
876: IF FND_API.to_boolean( p_init_msg_list ) THEN
877: FND_MSG_PUB.initialize;
878: END IF;
879:
880: x_char_lov_sql :=

Line 906: RAISE FND_API.G_EXC_ERROR;

902: );
903:
904: -- Error handling code added by balaji for bug # 4091726
905: IF FND_MSG_PUB.count_msg > 0 THEN
906: RAISE FND_API.G_EXC_ERROR;
907: END IF;
908:
909: IF ( x_char_lov_sql IS NULL ) THEN
910: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_CHAR_LOV_NULL' );

Line 912: RAISE FND_API.G_EXC_ERROR;

908:
909: IF ( x_char_lov_sql IS NULL ) THEN
910: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_CHAR_LOV_NULL' );
911: FND_MSG_PUB.add;
912: RAISE FND_API.G_EXC_ERROR;
913: END IF;
914:
915: IF ( G_DEBUG = 'Y' ) THEN
916: AHL_DEBUG_PUB.disable_debug;

Line 921: WHEN FND_API.G_EXC_ERROR THEN

917: END IF;
918:
919: EXCEPTION
920:
921: WHEN FND_API.G_EXC_ERROR THEN
922: x_return_status := FND_API.G_RET_STS_ERROR;
923: FND_MSG_PUB.count_and_get
924: (
925: p_encoded => FND_API.G_FALSE,

Line 922: x_return_status := FND_API.G_RET_STS_ERROR;

918:
919: EXCEPTION
920:
921: WHEN FND_API.G_EXC_ERROR THEN
922: x_return_status := FND_API.G_RET_STS_ERROR;
923: FND_MSG_PUB.count_and_get
924: (
925: p_encoded => FND_API.G_FALSE,
926: p_count => x_msg_count,

Line 925: p_encoded => FND_API.G_FALSE,

921: WHEN FND_API.G_EXC_ERROR THEN
922: x_return_status := FND_API.G_RET_STS_ERROR;
923: FND_MSG_PUB.count_and_get
924: (
925: p_encoded => FND_API.G_FALSE,
926: p_count => x_msg_count,
927: p_data => x_msg_data
928: );
929:

Line 934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

930: IF ( G_DEBUG = 'Y' ) THEN
931: AHL_DEBUG_PUB.disable_debug;
932: END IF;
933:
934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
936: FND_MSG_PUB.count_and_get
937: (
938: p_encoded => FND_API.G_FALSE,

Line 935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

931: AHL_DEBUG_PUB.disable_debug;
932: END IF;
933:
934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
936: FND_MSG_PUB.count_and_get
937: (
938: p_encoded => FND_API.G_FALSE,
939: p_count => x_msg_count,

Line 938: p_encoded => FND_API.G_FALSE,

934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
936: FND_MSG_PUB.count_and_get
937: (
938: p_encoded => FND_API.G_FALSE,
939: p_count => x_msg_count,
940: p_data => x_msg_data
941: );
942:

Line 948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

944: AHL_DEBUG_PUB.disable_debug;
945: END IF;
946:
947: WHEN OTHERS THEN
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
949: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
950: THEN
951: FND_MSG_PUB.add_exc_msg
952: (

Line 960: p_encoded => FND_API.G_FALSE,

956: );
957: END IF;
958: FND_MSG_PUB.count_and_get
959: (
960: p_encoded => FND_API.G_FALSE,
961: p_count => x_msg_count,
962: p_data => x_msg_data
963: );
964:

Line 973: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

969:
970: PROCEDURE get_qa_plan
971: (
972: p_api_version IN NUMBER := 1.0,
973: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
974: p_commit IN VARCHAR2 := FND_API.G_FALSE,
975: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
976: p_default IN VARCHAR2 := FND_API.G_FALSE,
977: p_module_type IN VARCHAR2 := NULL,

Line 974: p_commit IN VARCHAR2 := FND_API.G_FALSE,

970: PROCEDURE get_qa_plan
971: (
972: p_api_version IN NUMBER := 1.0,
973: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
974: p_commit IN VARCHAR2 := FND_API.G_FALSE,
975: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
976: p_default IN VARCHAR2 := FND_API.G_FALSE,
977: p_module_type IN VARCHAR2 := NULL,
978: x_return_status OUT NOCOPY VARCHAR2,

Line 975: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

971: (
972: p_api_version IN NUMBER := 1.0,
973: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
974: p_commit IN VARCHAR2 := FND_API.G_FALSE,
975: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
976: p_default IN VARCHAR2 := FND_API.G_FALSE,
977: p_module_type IN VARCHAR2 := NULL,
978: x_return_status OUT NOCOPY VARCHAR2,
979: x_msg_count OUT NOCOPY NUMBER,

Line 976: p_default IN VARCHAR2 := FND_API.G_FALSE,

972: p_api_version IN NUMBER := 1.0,
973: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
974: p_commit IN VARCHAR2 := FND_API.G_FALSE,
975: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
976: p_default IN VARCHAR2 := FND_API.G_FALSE,
977: p_module_type IN VARCHAR2 := NULL,
978: x_return_status OUT NOCOPY VARCHAR2,
979: x_msg_count OUT NOCOPY NUMBER,
980: x_msg_data OUT NOCOPY VARCHAR2,

Line 996: x_return_status := FND_API.G_RET_STS_SUCCESS;

992: AHL_DEBUG_PUB.enable_debug;
993: END IF;
994:
995: -- Initialize API return status to success
996: x_return_status := FND_API.G_RET_STS_SUCCESS;
997:
998: -- Initialize message list if p_init_msg_list is set to TRUE.
999: IF FND_API.to_boolean( p_init_msg_list ) THEN
1000: FND_MSG_PUB.initialize;

Line 999: IF FND_API.to_boolean( p_init_msg_list ) THEN

995: -- Initialize API return status to success
996: x_return_status := FND_API.G_RET_STS_SUCCESS;
997:
998: -- Initialize message list if p_init_msg_list is set to TRUE.
999: IF FND_API.to_boolean( p_init_msg_list ) THEN
1000: FND_MSG_PUB.initialize;
1001: END IF;
1002:
1003: BEGIN

Line 1023: RAISE FND_API.G_EXC_ERROR;

1019: x_plan_id := NULL;
1020: IF ( p_module_type = 'JSP' ) THEN
1021: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_PLAN_NOT_FOUND' );
1022: FND_MSG_PUB.add;
1023: RAISE FND_API.G_EXC_ERROR;
1024: ELSE
1025: RETURN;
1026: END IF;
1027: WHEN OTHERS THEN

Line 1028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1024: ELSE
1025: RETURN;
1026: END IF;
1027: WHEN OTHERS THEN
1028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1029: END;
1030:
1031: IF ( G_DEBUG = 'Y' ) THEN
1032: AHL_DEBUG_PUB.disable_debug;

Line 1037: WHEN FND_API.G_EXC_ERROR THEN

1033: END IF;
1034:
1035: EXCEPTION
1036:
1037: WHEN FND_API.G_EXC_ERROR THEN
1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039: FND_MSG_PUB.count_and_get
1040: (
1041: p_encoded => FND_API.G_FALSE,

Line 1038: x_return_status := FND_API.G_RET_STS_ERROR;

1034:
1035: EXCEPTION
1036:
1037: WHEN FND_API.G_EXC_ERROR THEN
1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039: FND_MSG_PUB.count_and_get
1040: (
1041: p_encoded => FND_API.G_FALSE,
1042: p_count => x_msg_count,

Line 1041: p_encoded => FND_API.G_FALSE,

1037: WHEN FND_API.G_EXC_ERROR THEN
1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039: FND_MSG_PUB.count_and_get
1040: (
1041: p_encoded => FND_API.G_FALSE,
1042: p_count => x_msg_count,
1043: p_data => x_msg_data
1044: );
1045:

Line 1050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1046: IF ( G_DEBUG = 'Y' ) THEN
1047: AHL_DEBUG_PUB.disable_debug;
1048: END IF;
1049:
1050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1052: FND_MSG_PUB.count_and_get
1053: (
1054: p_encoded => FND_API.G_FALSE,

Line 1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1047: AHL_DEBUG_PUB.disable_debug;
1048: END IF;
1049:
1050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1052: FND_MSG_PUB.count_and_get
1053: (
1054: p_encoded => FND_API.G_FALSE,
1055: p_count => x_msg_count,

Line 1054: p_encoded => FND_API.G_FALSE,

1050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1052: FND_MSG_PUB.count_and_get
1053: (
1054: p_encoded => FND_API.G_FALSE,
1055: p_count => x_msg_count,
1056: p_data => x_msg_data
1057: );
1058:

Line 1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1060: AHL_DEBUG_PUB.disable_debug;
1061: END IF;
1062:
1063: WHEN OTHERS THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1065: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1066: THEN
1067: FND_MSG_PUB.add_exc_msg
1068: (

Line 1076: p_encoded => FND_API.G_FALSE,

1072: );
1073: END IF;
1074: FND_MSG_PUB.count_and_get
1075: (
1076: p_encoded => FND_API.G_FALSE,
1077: p_count => x_msg_count,
1078: p_data => x_msg_data
1079: );
1080: