DBA Data[Home] [Help]

APPS.OE_HOLD_SOURCES_PVT dependencies on FND_API

Line 42: x_return_status := FND_API.G_RET_STS_SUCCESS;

38: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
39: --
40: BEGIN
41:
42: x_return_status := FND_API.G_RET_STS_SUCCESS;
43:
44:
45: -- Validate Hold ID
46:

Line 66: x_return_status := FND_API.G_RET_STS_ERROR;

62: END IF;
63: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HOLD_ID');
64: FND_MESSAGE.SET_TOKEN('HOLD_ID',p_hold_id);
65: FND_MSG_PUB.ADD;
66: x_return_status := FND_API.G_RET_STS_ERROR;
67:
68: END; -- Validate Hold ID
69:
70:

Line 80: x_return_status := FND_API.G_RET_STS_ERROR;

76: END IF;
77: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CODE');
78: FND_MESSAGE.SET_TOKEN('ENTITY_CODE',p_entity_code);
79: FND_MSG_PUB.ADD;
80: x_return_status := FND_API.G_RET_STS_ERROR;
81: END IF; -- Validate Entity Code
82:
83: -- Validate Entity ID
84:

Line 129: RAISE FND_API.G_EXC_ERROR;

125: END IF;
126: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_ID');
127: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id);
128: FND_MSG_PUB.ADD;
129: RAISE FND_API.G_EXC_ERROR;
130: -- too many rows maybe raised if the same entity id
131: -- e.g. an item exists in two orgs.
132: WHEN TOO_MANY_ROWS THEN
133: null;

Line 149: x_return_status := FND_API.G_RET_STS_ERROR;

145: END IF;
146: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CODE');
147: FND_MESSAGE.SET_TOKEN('ENTITY_CODE',p_entity_code2);
148: FND_MSG_PUB.ADD;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: END IF; -- Validate Entity Code
151:
152: -- Validate Entity ID
153:

Line 198: RAISE FND_API.G_EXC_ERROR;

194: END IF;
195: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_ID');
196: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id2);
197: FND_MSG_PUB.ADD;
198: RAISE FND_API.G_EXC_ERROR;
199: -- too many rows maybe raised if the same entity id
200: -- e.g. an item exists in two orgs.
201: WHEN TOO_MANY_ROWS THEN
202: null;

Line 210: WHEN FND_API.G_EXC_ERROR THEN

206: END IF; -- p_entity_code2 is not NULL THEN
207: ----------------------------------------------
208:
209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: WHEN OTHERS THEN
213: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
214: FND_MSG_PUB.Add_Exc_Msg

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207: ----------------------------------------------
208:
209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: WHEN OTHERS THEN
213: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
214: FND_MSG_PUB.Add_Exc_Msg
215: (G_PKG_NAME

Line 218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

214: FND_MSG_PUB.Add_Exc_Msg
215: (G_PKG_NAME
216: ,'ValidateHoldSource');
217: END IF;
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219:
220: END ValidateHoldSource;
221:
222:

Line 225: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

221:
222:
223: PROCEDURE Create_Hold_Source
224: ( p_hold_source_rec IN OE_Hold_Sources_Pvt.Hold_Source_REC
225: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
226: , x_hold_source_id OUT NOCOPY NUMBER
227:
228: , x_return_status OUT NOCOPY VARCHAR2
229:

Line 250: x_return_status := FND_API.G_RET_STS_SUCCESS;

246: oe_debug_pub.add( 'IN OE_HOLD_SOURCES_PVT.CREATE_HOLD_SOURCE' ) ;
247: END IF;
248: SAVEPOINT Create_Hold_Source;
249:
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: -- Retrieve user id
253:
254: Utilities(l_user_id);

Line 266: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN

262:
263: --dbms_output.put_line ('IN Create_Hold_Source');
264: -- VALIDATION
265:
266: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN
267:
268: IF l_debug_level > 0 THEN
269: oe_debug_pub.add( 'CALLING VALIDATEHOLDSOURCE' ) ;
270: END IF;

Line 282: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

278: , x_return_status => x_return_status
279: );
280:
281: --dbms_output.put_line ('ValidateHoldSource->x_return_status->' || x_return_status );
282: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
283: IF l_debug_level > 0 THEN
284: oe_debug_pub.add( 'VALIDATION NOT SUCCESSFUL' ) ;
285: END IF;
286: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 286: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

282: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
283: IF l_debug_level > 0 THEN
284: oe_debug_pub.add( 'VALIDATION NOT SUCCESSFUL' ) ;
285: END IF;
286: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
287: RAISE FND_API.G_EXC_ERROR;
288: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;

Line 287: RAISE FND_API.G_EXC_ERROR;

283: IF l_debug_level > 0 THEN
284: oe_debug_pub.add( 'VALIDATION NOT SUCCESSFUL' ) ;
285: END IF;
286: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
287: RAISE FND_API.G_EXC_ERROR;
288: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291: END IF;

Line 288: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

284: oe_debug_pub.add( 'VALIDATION NOT SUCCESSFUL' ) ;
285: END IF;
286: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
287: RAISE FND_API.G_EXC_ERROR;
288: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291: END IF;
292:

Line 289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

285: END IF;
286: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
287: RAISE FND_API.G_EXC_ERROR;
288: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291: END IF;
292:
293: -- Check for duplicate hold source

Line 313: RAISE FND_API.G_EXC_ERROR;

309: oe_debug_pub.add( 'DUPLICATE HOLD SOURCE' ) ;
310: END IF;
311: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
312: FND_MSG_PUB.ADD;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315:
316: END IF; -- End of VALIDATION
317:

Line 406: WHEN FND_API.G_EXC_ERROR THEN

402: );
403:
404: --dbms_output.put_line ('End CreateHold_source');
405: EXCEPTION
406: WHEN FND_API.G_EXC_ERROR THEN
407: ROLLBACK TO Create_Hold_Source;
408: x_return_status := FND_API.G_RET_STS_ERROR;
409: FND_MSG_PUB.Count_And_Get
410: ( p_count => x_msg_count

Line 408: x_return_status := FND_API.G_RET_STS_ERROR;

404: --dbms_output.put_line ('End CreateHold_source');
405: EXCEPTION
406: WHEN FND_API.G_EXC_ERROR THEN
407: ROLLBACK TO Create_Hold_Source;
408: x_return_status := FND_API.G_RET_STS_ERROR;
409: FND_MSG_PUB.Count_And_Get
410: ( p_count => x_msg_count
411: , p_data => x_msg_data
412: );

Line 413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

409: FND_MSG_PUB.Count_And_Get
410: ( p_count => x_msg_count
411: , p_data => x_msg_data
412: );
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK TO Create_Hold_Source;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: FND_MSG_PUB.Count_And_Get
417: ( p_count => x_msg_count

Line 415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

411: , p_data => x_msg_data
412: );
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK TO Create_Hold_Source;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: FND_MSG_PUB.Count_And_Get
417: ( p_count => x_msg_count
418: , p_data => x_msg_data
419: );

Line 422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

418: , p_data => x_msg_data
419: );
420: WHEN OTHERS THEN
421: ROLLBACK TO Create_Hold_Source;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: IF FND_MSG_PUB.Check_Msg_Level
424: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg

Line 445: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

441: , p_entity_id IN NUMBER DEFAULT NULL
442: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
443: , p_entity_id2 IN NUMBER DEFAULT NULL
444: , p_hold_release_rec IN OE_Hold_Sources_Pvt.Hold_Release_REC
445: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
446: , x_return_status OUT NOCOPY VARCHAR2
447:
448: , x_msg_count OUT NOCOPY NUMBER
449:

Line 481: x_return_status := FND_API.G_RET_STS_SUCCESS;

477: -- Retrieve user id
478:
479: Utilities(l_user_id);
480:
481: x_return_status := FND_API.G_RET_STS_SUCCESS;
482:
483:
484: l_hold_release_rec := p_hold_release_rec;
485:

Line 494: RAISE FND_API.G_EXC_ERROR;

490: FETCH hold_source INTO l_hold_release_rec.hold_source_id;
491: IF (hold_source%NOTFOUND) THEN
492: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_SOURCE');
493: FND_MSG_PUB.ADD;
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496: CLOSE hold_source;
497:
498: END IF;

Line 508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

504: , p_validation_level => p_validation_level
505: , x_hold_release_id => l_hold_release_id
506: , x_return_status => x_return_status
507: );
508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
509: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 509: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

505: , x_hold_release_id => l_hold_release_id
506: , x_return_status => x_return_status
507: );
508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
509: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;

Line 510: RAISE FND_API.G_EXC_ERROR;

506: , x_return_status => x_return_status
507: );
508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
509: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: END IF;

Line 511: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

507: );
508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
509: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: END IF;
515:

Line 512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
509: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: END IF;
515:
516:

Line 543: WHEN FND_API.G_EXC_ERROR THEN

539: , LAST_UPDATE_DATE = sysdate
540: WHERE hold_source_id = l_hold_source_id;
541:
542: EXCEPTION
543: WHEN FND_API.G_EXC_ERROR THEN
544: ROLLBACK TO release_hold_source;
545: x_return_status := FND_API.G_RET_STS_ERROR;
546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
547: ROLLBACK TO release_hold_source;

Line 545: x_return_status := FND_API.G_RET_STS_ERROR;

541:
542: EXCEPTION
543: WHEN FND_API.G_EXC_ERROR THEN
544: ROLLBACK TO release_hold_source;
545: x_return_status := FND_API.G_RET_STS_ERROR;
546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
547: ROLLBACK TO release_hold_source;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: WHEN OTHERS THEN

Line 546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

542: EXCEPTION
543: WHEN FND_API.G_EXC_ERROR THEN
544: ROLLBACK TO release_hold_source;
545: x_return_status := FND_API.G_RET_STS_ERROR;
546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
547: ROLLBACK TO release_hold_source;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: WHEN OTHERS THEN
550: ROLLBACK TO release_hold_source;

Line 548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

544: ROLLBACK TO release_hold_source;
545: x_return_status := FND_API.G_RET_STS_ERROR;
546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
547: ROLLBACK TO release_hold_source;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: WHEN OTHERS THEN
550: ROLLBACK TO release_hold_source;
551: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
552: FND_MSG_PUB.Add_Exc_Msg

Line 556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

552: FND_MSG_PUB.Add_Exc_Msg
553: (G_PKG_NAME
554: ,'Release_Hold_Source');
555: END IF;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557:
558: END Release_Hold_Source;
559:
560:

Line 621: x_return_status := FND_API.G_RET_STS_SUCCESS;

617: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
618: --
619: BEGIN
620:
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623:
624: FOR l_hold_source_REC IN hold_source_REC
625: LOOP

Line 639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

635: FND_MSG_PUB.Add_Exc_Msg
636: (G_PKG_NAME
637: ,'Query_Hold_Source');
638: END IF;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640:
641: END Query_Hold_Source;
642:
643:

Line 701: x_return_status := FND_API.G_RET_STS_SUCCESS;

697:
698: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
699: BEGIN
700:
701: x_return_status := FND_API.G_RET_STS_SUCCESS;
702:
703:
704: FOR l_hold_source_REC IN hold_source_REC
705: LOOP

Line 719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

715: FND_MSG_PUB.Add_Exc_Msg
716: (G_PKG_NAME
717: ,'Query_Hold_Source');
718: END IF;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720:
721: END Query_Line__Hold_Source;
722:
723:

Line 727: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL

723:
724:
725: PROCEDURE Insert_Hold_Release
726: ( p_hold_release_rec IN OE_Hold_Sources_Pvt.Hold_Release_Rec
727: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
728: , x_hold_release_id OUT NOCOPY NUMBER
729:
730: , x_return_status OUT NOCOPY VARCHAR2
731:

Line 749: x_return_status := FND_API.G_RET_STS_SUCCESS;

745: END IF;
746:
747: SAVEPOINT insert_hold_release;
748:
749: x_return_status := FND_API.G_RET_STS_SUCCESS;
750:
751: Utilities(l_user_id);
752:
753: ------------------------------------------------------------------

Line 757: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN

753: ------------------------------------------------------------------
754: -- Validate Input Parameters
755: ------------------------------------------------------------------
756:
757: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN
758:
759: -- Validate Reason Code
760:
761: BEGIN

Line 775: RAISE FND_API.G_EXC_ERROR;

771: WHEN NO_DATA_FOUND THEN
772: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_REASON_CODE');
773: FND_MESSAGE.SET_TOKEN('REASON_CODE',p_hold_release_rec.release_reason_code);
774: FND_MSG_PUB.ADD;
775: RAISE FND_API.G_EXC_ERROR;
776:
777: END; -- Validate Reason Code
778:
779: END IF; -- End of Validation

Line 871: WHEN FND_API.G_EXC_ERROR THEN

867: IF l_debug_level > 0 THEN
868: oe_debug_pub.add( 'AFTER INSERT' ) ;
869: END IF;
870: EXCEPTION
871: WHEN FND_API.G_EXC_ERROR THEN
872: x_return_status := FND_API.G_RET_STS_ERROR;
873: ROLLBACK TO insert_hold_release;
874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 872: x_return_status := FND_API.G_RET_STS_ERROR;

868: oe_debug_pub.add( 'AFTER INSERT' ) ;
869: END IF;
870: EXCEPTION
871: WHEN FND_API.G_EXC_ERROR THEN
872: x_return_status := FND_API.G_RET_STS_ERROR;
873: ROLLBACK TO insert_hold_release;
874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: ROLLBACK TO insert_hold_release;

Line 874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

870: EXCEPTION
871: WHEN FND_API.G_EXC_ERROR THEN
872: x_return_status := FND_API.G_RET_STS_ERROR;
873: ROLLBACK TO insert_hold_release;
874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: ROLLBACK TO insert_hold_release;
877: WHEN OTHERS THEN
878: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

871: WHEN FND_API.G_EXC_ERROR THEN
872: x_return_status := FND_API.G_RET_STS_ERROR;
873: ROLLBACK TO insert_hold_release;
874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: ROLLBACK TO insert_hold_release;
877: WHEN OTHERS THEN
878: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
879: FND_MSG_PUB.Add_Exc_Msg

Line 883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

879: FND_MSG_PUB.Add_Exc_Msg
880: (G_PKG_NAME
881: ,'Insert_Hold_Release');
882: END IF;
883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
884: ROLLBACK TO insert_hold_release;
885: END Insert_Hold_Release;
886:
887:

Line 954: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

950: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
951: --
952: BEGIN
953:
954: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
955:
956: -- CUSTOMER HOLD SOURCE
957: /* IF p_entity_code = 'C' THEN
958:

Line 1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1038: FND_MSG_PUB.Add_Exc_Msg
1039: (G_PKG_NAME
1040: ,'Release_Hold_Source_WF');
1041: END IF;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043:
1044: END Release_Hold_Source_WF;
1045:
1046: