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_ORDER_FEEDBACK_PUB dependencies on FND_API

Line 29: -- Default = FND_API.G_FALSE

25: --
26: -- Standard IN Parameters:
27: -- p_api_version IN NUMBER Required
28: -- p_init_msg_list IN VARCHAR2 Optional
29: -- Default = FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Optional
31: -- Default = FND_API.G_FALSE
32: --
33: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:

Line 31: -- Default = FND_API.G_FALSE

27: -- p_api_version IN NUMBER Required
28: -- p_init_msg_list IN VARCHAR2 Optional
29: -- Default = FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Optional
31: -- Default = FND_API.G_FALSE
32: --
33: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
34: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
35: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

106:
107: PROCEDURE UPDATE_NOTICE
108: (
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
113: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
114: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

107: PROCEDURE UPDATE_NOTICE
108: (
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
113: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
114: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
115: p_header_rec IN OE_Order_PUB.Header_Rec_Type :=

Line 212: IF NOT FND_API.Compatible_API_Call (l_api_version ,

208: SAVEPOINT UPDATE_NOTICE_PUB;
209:
210: -- Standard call to check for call compatibility.
211:
212: IF NOT FND_API.Compatible_API_Call (l_api_version ,
213: p_api_version ,
214: l_api_name ,
215: G_PKG_NAME ) THEN
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

212: IF NOT FND_API.Compatible_API_Call (l_api_version ,
213: p_api_version ,
214: l_api_name ,
215: G_PKG_NAME ) THEN
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: END IF;
218:
219: -- Initialize message list if p_init_msg_list is set to TRUE.
220:

Line 221: IF FND_API.to_Boolean( p_init_msg_list ) THEN

217: END IF;
218:
219: -- Initialize message list if p_init_msg_list is set to TRUE.
220:
221: IF FND_API.to_Boolean( p_init_msg_list ) THEN
222: FND_MSG_PUB.initialize;
223: END IF;
224:
225: -- Initialize API return status to success

Line 227: x_return_status := FND_API.G_RET_STS_SUCCESS;

223: END IF;
224:
225: -- Initialize API return status to success
226:
227: x_return_status := FND_API.G_RET_STS_SUCCESS;
228:
229: -- UPDATE_NOTICE API specific input parameter validation logic
230: -- none
231:

Line 302: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

298: x_msg_count => x_msg_count ,
299: x_msg_data => x_msg_data
300: );
301:
302: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
303: THEN
304: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
305: THEN
306: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');

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

306: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
307: FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_CUHK.Update_Notice_PRE', FALSE);
308: FND_MSG_PUB.ADD;
309: END IF;
310: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;

Line 311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

307: FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_CUHK.Update_Notice_PRE', FALSE);
308: FND_MSG_PUB.ADD;
309: END IF;
310: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315: END IF;

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

308: FND_MSG_PUB.ADD;
309: END IF;
310: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315: END IF;
316:

Line 313: RAISE FND_API.G_EXC_ERROR;

309: END IF;
310: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315: END IF;
316:
317: END IF; -- customer pre processing

Line 356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

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

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

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

Line 365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 367: RAISE FND_API.G_EXC_ERROR;

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

Line 376: p_init_msg_list => FND_API.G_FALSE,

372: -- end of 3042254.
373:
374: ASO_ORDER_FEEDBACK_UPDATE_PVT.UPDATE_NOTICE(
375: p_api_version => 1.0,
376: p_init_msg_list => FND_API.G_FALSE,
377: p_commit => FND_API.G_FALSE,
378: x_return_status => x_return_status,
379: x_msg_count => x_msg_count,
380: x_msg_data => x_msg_data,

Line 377: p_commit => FND_API.G_FALSE,

373:
374: ASO_ORDER_FEEDBACK_UPDATE_PVT.UPDATE_NOTICE(
375: p_api_version => 1.0,
376: p_init_msg_list => FND_API.G_FALSE,
377: p_commit => FND_API.G_FALSE,
378: x_return_status => x_return_status,
379: x_msg_count => x_msg_count,
380: x_msg_data => x_msg_data,
381: p_queue_type => 'OF_QUEUE',

Line 412: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

408: p_action_request_tbl => p_action_request_tbl
409: );
410:
411:
412: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
413: ROLLBACK TO UPDATE_NOTICE_PUB;
414: RETURN;
415: END IF;
416:

Line 456: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

452: x_msg_count => x_msg_count ,
453: x_msg_data => x_msg_data
454: );
455:
456: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
457: THEN
458: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
459: THEN
460: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');

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

460: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
461: FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_CUHK.Update_Notice_POST', FALSE);
462: FND_MSG_PUB.ADD;
463: END IF;
464: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;

Line 465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

461: FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_CUHK.Update_Notice_POST', FALSE);
462: FND_MSG_PUB.ADD;
463: END IF;
464: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469: END IF;

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

462: FND_MSG_PUB.ADD;
463: END IF;
464: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469: END IF;
470:

Line 467: RAISE FND_API.G_EXC_ERROR;

463: END IF;
464: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469: END IF;
470:
471: END IF; -- customer pre processing

Line 510: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

506: x_msg_count => x_msg_count ,
507: x_msg_data => x_msg_data
508: );
509:
510: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
511: THEN
512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
513: THEN
514: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');

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

514: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
515: FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_VUHK.Update_Notice_POST', FALSE);
516: FND_MSG_PUB.ADD;
517: END IF;
518: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
520: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;

Line 519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

515: FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_VUHK.Update_Notice_POST', FALSE);
516: FND_MSG_PUB.ADD;
517: END IF;
518: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
520: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523: END IF;

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

516: FND_MSG_PUB.ADD;
517: END IF;
518: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
520: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523: END IF;
524:

Line 521: RAISE FND_API.G_EXC_ERROR;

517: END IF;
518: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
520: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523: END IF;
524:
525: END IF; -- vertical hook

Line 533: IF FND_API.To_Boolean( p_commit ) THEN

529: -- End of API Body
530:
531: -- Standard check of p_commit.
532:
533: IF FND_API.To_Boolean( p_commit ) THEN
534: COMMIT WORK;
535: END IF;
536:
537: -- Standard call to get message count and if count is 1, get message info.

Line 546: WHEN FND_API.G_EXC_ERROR THEN

542: );
543:
544: EXCEPTION
545:
546: WHEN FND_API.G_EXC_ERROR THEN
547: ROLLBACK TO UPDATE_NOTICE_PUB;
548: x_return_status := FND_API.G_RET_STS_ERROR ;
549: FND_MSG_PUB.Count_And_Get
550: (p_count => x_msg_count ,

Line 548: x_return_status := FND_API.G_RET_STS_ERROR ;

544: EXCEPTION
545:
546: WHEN FND_API.G_EXC_ERROR THEN
547: ROLLBACK TO UPDATE_NOTICE_PUB;
548: x_return_status := FND_API.G_RET_STS_ERROR ;
549: FND_MSG_PUB.Count_And_Get
550: (p_count => x_msg_count ,
551: p_data => x_msg_data
552: );

Line 553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

549: FND_MSG_PUB.Count_And_Get
550: (p_count => x_msg_count ,
551: p_data => x_msg_data
552: );
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: ROLLBACK TO UPDATE_NOTICE_PUB;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
556: FND_MSG_PUB.Count_And_Get
557: (p_count => x_msg_count ,

Line 555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

551: p_data => x_msg_data
552: );
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: ROLLBACK TO UPDATE_NOTICE_PUB;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
556: FND_MSG_PUB.Count_And_Get
557: (p_count => x_msg_count ,
558: p_data => x_msg_data
559: );

Line 562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

558: p_data => x_msg_data
559: );
560: WHEN OTHERS THEN
561: ROLLBACK TO UPDATE_NOTICE_PUB;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
564: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
565: END IF;
566: FND_MSG_PUB.Count_And_Get

Line 586: -- Default = FND_API.G_FALSE

582: --
583: -- Standard IN Parameters:
584: -- p_api_version IN NUMBER Required
585: -- p_init_msg_list IN VARCHAR2 Optional
586: -- Default = FND_API.G_FALSE
587: -- p_commit IN VARCHAR2 Optional
588: -- Default = FND_API.G_FALSE
589: --
590: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:

Line 588: -- Default = FND_API.G_FALSE

584: -- p_api_version IN NUMBER Required
585: -- p_init_msg_list IN VARCHAR2 Optional
586: -- Default = FND_API.G_FALSE
587: -- p_commit IN VARCHAR2 Optional
588: -- Default = FND_API.G_FALSE
589: --
590: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
591: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
592: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 641: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

637:
638: PROCEDURE GET_NOTICE
639: (
640: p_api_version IN NUMBER,
641: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
642: p_commit IN VARCHAR2 := FND_API.G_FALSE,
643: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
644: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
645: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

638: PROCEDURE GET_NOTICE
639: (
640: p_api_version IN NUMBER,
641: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
642: p_commit IN VARCHAR2 := FND_API.G_FALSE,
643: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
644: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
645: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
646: p_app_short_name IN VARCHAR2,

Line 691: IF NOT FND_API.Compatible_API_Call (l_api_version ,

687: SAVEPOINT GET_NOTICE_PUB;
688:
689: -- Standard call to check for call compatibility.
690:
691: IF NOT FND_API.Compatible_API_Call (l_api_version ,
692: p_api_version ,
693: l_api_name ,
694: G_PKG_NAME ) THEN
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

691: IF NOT FND_API.Compatible_API_Call (l_api_version ,
692: p_api_version ,
693: l_api_name ,
694: G_PKG_NAME ) THEN
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: END IF;
697:
698: -- Initialize message list if p_init_msg_list is set to TRUE.
699:

Line 700: IF FND_API.to_Boolean( p_init_msg_list ) THEN

696: END IF;
697:
698: -- Initialize message list if p_init_msg_list is set to TRUE.
699:
700: IF FND_API.to_Boolean( p_init_msg_list ) THEN
701: FND_MSG_PUB.initialize;
702: END IF;
703:
704: -- Initialize API return status to success

Line 706: x_return_status := FND_API.G_RET_STS_SUCCESS;

702: END IF;
703:
704: -- Initialize API return status to success
705:
706: x_return_status := FND_API.G_RET_STS_SUCCESS;
707:
708: -- GET_NOTICE API specific input parameter validation logic
709:
710: -- need to check that p_app_short_name (required param) is passed in

Line 734: p_init_msg_list => FND_API.G_FALSE,

730:
731:
732: ASO_ORDER_FEEDBACK_GET_PVT.GET_NOTICE(
733: p_api_version => 1.0,
734: p_init_msg_list => FND_API.G_FALSE,
735: p_commit => FND_API.G_FALSE,
736: x_return_status => x_return_status,
737: x_msg_count => x_msg_count,
738: x_msg_data => x_msg_data,

Line 735: p_commit => FND_API.G_FALSE,

731:
732: ASO_ORDER_FEEDBACK_GET_PVT.GET_NOTICE(
733: p_api_version => 1.0,
734: p_init_msg_list => FND_API.G_FALSE,
735: p_commit => FND_API.G_FALSE,
736: x_return_status => x_return_status,
737: x_msg_count => x_msg_count,
738: x_msg_data => x_msg_data,
739: p_app_short_name => p_app_short_name,

Line 773: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

769: x_old_Lot_Serial_tbl => x_old_Lot_Serial_tbl,
770: x_action_request_tbl => x_action_request_tbl
771: );
772:
773: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
774: ROLLBACK TO GET_NOTICE_PUB;
775: RETURN;
776: END IF;
777:

Line 782: IF FND_API.To_Boolean( p_commit ) THEN

778: -- End of API Body
779:
780: -- Standard check of p_commit.
781:
782: IF FND_API.To_Boolean( p_commit ) THEN
783: COMMIT WORK;
784: END IF;
785:
786: -- Standard call to get message count and if count is 1, get message info.

Line 795: WHEN FND_API.G_EXC_ERROR THEN

791: );
792:
793: EXCEPTION
794:
795: WHEN FND_API.G_EXC_ERROR THEN
796: ROLLBACK TO GET_NOTICE_PUB;
797: x_return_status := FND_API.G_RET_STS_ERROR ;
798: FND_MSG_PUB.Count_And_Get
799: (p_count => x_msg_count ,

Line 797: x_return_status := FND_API.G_RET_STS_ERROR ;

793: EXCEPTION
794:
795: WHEN FND_API.G_EXC_ERROR THEN
796: ROLLBACK TO GET_NOTICE_PUB;
797: x_return_status := FND_API.G_RET_STS_ERROR ;
798: FND_MSG_PUB.Count_And_Get
799: (p_count => x_msg_count ,
800: p_data => x_msg_data
801: );

Line 802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

798: FND_MSG_PUB.Count_And_Get
799: (p_count => x_msg_count ,
800: p_data => x_msg_data
801: );
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: ROLLBACK TO GET_NOTICE_PUB;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
805: FND_MSG_PUB.Count_And_Get
806: (p_count => x_msg_count ,

Line 804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

800: p_data => x_msg_data
801: );
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: ROLLBACK TO GET_NOTICE_PUB;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
805: FND_MSG_PUB.Count_And_Get
806: (p_count => x_msg_count ,
807: p_data => x_msg_data
808: );

Line 811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

807: p_data => x_msg_data
808: );
809: WHEN OTHERS THEN
810: ROLLBACK TO GET_NOTICE_PUB;
811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
813: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
814: END IF;
815: FND_MSG_PUB.Count_And_Get

Line 840: -- Default = FND_API.G_FALSE

836: --
837: -- Standard IN Parameters:
838: -- p_api_version IN NUMBER Required
839: -- p_init_msg_list IN VARCHAR2 Optional
840: -- Default = FND_API.G_FALSE
841: -- p_commit IN VARCHAR2 Optional
842: -- Default = FND_API.G_FALSE
843: --
844: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:

Line 842: -- Default = FND_API.G_FALSE

838: -- p_api_version IN NUMBER Required
839: -- p_init_msg_list IN VARCHAR2 Optional
840: -- Default = FND_API.G_FALSE
841: -- p_commit IN VARCHAR2 Optional
842: -- Default = FND_API.G_FALSE
843: --
844: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
845: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
846: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 924: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

920:
921: PROCEDURE HANDLE_EXCEPTION
922: (
923: p_api_version IN NUMBER,
924: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
925: p_commit IN VARCHAR2 := FND_API.G_FALSE,
926: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
927: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
928: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

921: PROCEDURE HANDLE_EXCEPTION
922: (
923: p_api_version IN NUMBER,
924: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
925: p_commit IN VARCHAR2 := FND_API.G_FALSE,
926: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
927: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
928: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
929: p_app_short_name IN VARCHAR2,

Line 998: IF NOT FND_API.Compatible_API_Call (l_api_version ,

994: SAVEPOINT HANDLE_EXCEPTION_PUB;
995:
996: -- Standard call to check for call compatibility.
997:
998: IF NOT FND_API.Compatible_API_Call (l_api_version ,
999: p_api_version ,
1000: l_api_name ,
1001: G_PKG_NAME ) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

998: IF NOT FND_API.Compatible_API_Call (l_api_version ,
999: p_api_version ,
1000: l_api_name ,
1001: G_PKG_NAME ) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: END IF;
1004:
1005: -- Initialize message list if p_init_msg_list is set to TRUE.
1006:

Line 1007: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1003: END IF;
1004:
1005: -- Initialize message list if p_init_msg_list is set to TRUE.
1006:
1007: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1008: FND_MSG_PUB.initialize;
1009: END IF;
1010:
1011: -- Initialize API return status to success

Line 1013: x_return_status := FND_API.G_RET_STS_SUCCESS;

1009: END IF;
1010:
1011: -- Initialize API return status to success
1012:
1013: x_return_status := FND_API.G_RET_STS_SUCCESS;
1014:
1015: -- HANDLE_EXCEPTION API specific input parameter validation logic
1016: -- need to check that p_app_short_name (required param) is passed in
1017:

Line 1041: p_init_msg_list => FND_API.G_FALSE,

1037:
1038:
1039: ASO_ORDER_FEEDBACK_UPDATE_PVT.UPDATE_NOTICE(
1040: p_api_version => 1.0,
1041: p_init_msg_list => FND_API.G_FALSE,
1042: p_commit => FND_API.G_FALSE,
1043: x_return_status => x_return_status,
1044: x_msg_count => x_msg_count,
1045: x_msg_data => x_msg_data,

Line 1042: p_commit => FND_API.G_FALSE,

1038:
1039: ASO_ORDER_FEEDBACK_UPDATE_PVT.UPDATE_NOTICE(
1040: p_api_version => 1.0,
1041: p_init_msg_list => FND_API.G_FALSE,
1042: p_commit => FND_API.G_FALSE,
1043: x_return_status => x_return_status,
1044: x_msg_count => x_msg_count,
1045: x_msg_data => x_msg_data,
1046: p_app_short_name => p_app_short_name,

Line 1078: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1074: p_action_request_tbl => p_action_request_tbl
1075: );
1076:
1077:
1078: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1079: ROLLBACK TO HANDLE_EXCEPTION_PUB;
1080: RETURN;
1081: END IF;
1082:

Line 1087: IF FND_API.To_Boolean( p_commit ) THEN

1083: -- End of API Body
1084:
1085: -- Standard check of p_commit.
1086:
1087: IF FND_API.To_Boolean( p_commit ) THEN
1088: COMMIT WORK;
1089: END IF;
1090:
1091: -- Standard call to get message count and if count is 1, get message info.

Line 1100: WHEN FND_API.G_EXC_ERROR THEN

1096: );
1097:
1098: EXCEPTION
1099:
1100: WHEN FND_API.G_EXC_ERROR THEN
1101: ROLLBACK TO HANDLE_EXCEPTION_PUB;
1102: x_return_status := FND_API.G_RET_STS_ERROR ;
1103: FND_MSG_PUB.Count_And_Get
1104: (p_count => x_msg_count ,

Line 1102: x_return_status := FND_API.G_RET_STS_ERROR ;

1098: EXCEPTION
1099:
1100: WHEN FND_API.G_EXC_ERROR THEN
1101: ROLLBACK TO HANDLE_EXCEPTION_PUB;
1102: x_return_status := FND_API.G_RET_STS_ERROR ;
1103: FND_MSG_PUB.Count_And_Get
1104: (p_count => x_msg_count ,
1105: p_data => x_msg_data
1106: );

Line 1107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1103: FND_MSG_PUB.Count_And_Get
1104: (p_count => x_msg_count ,
1105: p_data => x_msg_data
1106: );
1107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1108: ROLLBACK TO HANDLE_EXCEPTION_PUB;
1109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1110: FND_MSG_PUB.Count_And_Get
1111: (p_count => x_msg_count ,

Line 1109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1105: p_data => x_msg_data
1106: );
1107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1108: ROLLBACK TO HANDLE_EXCEPTION_PUB;
1109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1110: FND_MSG_PUB.Count_And_Get
1111: (p_count => x_msg_count ,
1112: p_data => x_msg_data
1113: );

Line 1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1112: p_data => x_msg_data
1113: );
1114: WHEN OTHERS THEN
1115: ROLLBACK TO HANDLE_EXCEPTION_PUB;
1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1117: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1118: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1119: END IF;
1120: FND_MSG_PUB.Count_And_Get

Line 1141: -- Default = FND_API.G_FALSE

1137: --
1138: -- Standard IN Parameters:
1139: -- p_api_version IN NUMBER Required
1140: -- p_init_msg_list IN VARCHAR2 Optional
1141: -- Default = FND_API.G_FALSE
1142: -- p_commit IN VARCHAR2 Optional
1143: -- Default = FND_API.G_FALSE
1144: --
1145: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:

Line 1143: -- Default = FND_API.G_FALSE

1139: -- p_api_version IN NUMBER Required
1140: -- p_init_msg_list IN VARCHAR2 Optional
1141: -- Default = FND_API.G_FALSE
1142: -- p_commit IN VARCHAR2 Optional
1143: -- Default = FND_API.G_FALSE
1144: --
1145: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
1146: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
1147: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 1200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1196:
1197: PROCEDURE GET_EXCEPTION
1198: (
1199: p_api_version IN NUMBER,
1200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1202: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1203: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1204: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

1197: PROCEDURE GET_EXCEPTION
1198: (
1199: p_api_version IN NUMBER,
1200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1202: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1203: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1204: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1205: p_app_short_name IN VARCHAR2,

Line 1250: IF NOT FND_API.Compatible_API_Call (l_api_version ,

1246: SAVEPOINT GET_EXCEPTION_PUB;
1247:
1248: -- Standard call to check for call compatibility.
1249:
1250: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1251: p_api_version ,
1252: l_api_name ,
1253: G_PKG_NAME ) THEN
1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1250: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1251: p_api_version ,
1252: l_api_name ,
1253: G_PKG_NAME ) THEN
1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1255: END IF;
1256:
1257: -- Initialize message list if p_init_msg_list is set to TRUE.
1258:

Line 1259: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1255: END IF;
1256:
1257: -- Initialize message list if p_init_msg_list is set to TRUE.
1258:
1259: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1260: FND_MSG_PUB.initialize;
1261: END IF;
1262:
1263: -- Initialize API return status to success

Line 1265: x_return_status := FND_API.G_RET_STS_SUCCESS;

1261: END IF;
1262:
1263: -- Initialize API return status to success
1264:
1265: x_return_status := FND_API.G_RET_STS_SUCCESS;
1266:
1267: -- GET_EXCEPTION API specific input parameter validation logic
1268:
1269: -- need to check that p_app_short_name (required param) is passed in

Line 1293: p_init_msg_list => FND_API.G_FALSE,

1289:
1290:
1291: ASO_ORDER_FEEDBACK_GET_PVT.GET_NOTICE(
1292: p_api_version => 1.0,
1293: p_init_msg_list => FND_API.G_FALSE,
1294: p_commit => FND_API.G_FALSE,
1295: x_return_status => x_return_status,
1296: x_msg_count => x_msg_count,
1297: x_msg_data => x_msg_data,

Line 1294: p_commit => FND_API.G_FALSE,

1290:
1291: ASO_ORDER_FEEDBACK_GET_PVT.GET_NOTICE(
1292: p_api_version => 1.0,
1293: p_init_msg_list => FND_API.G_FALSE,
1294: p_commit => FND_API.G_FALSE,
1295: x_return_status => x_return_status,
1296: x_msg_count => x_msg_count,
1297: x_msg_data => x_msg_data,
1298: p_app_short_name => p_app_short_name,

Line 1333: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1329: x_old_Lot_Serial_tbl => x_old_Lot_Serial_tbl,
1330: x_action_request_tbl => x_action_request_tbl
1331: );
1332:
1333: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1334: ROLLBACK TO GET_EXCEPTION_PUB;
1335: RETURN;
1336: END IF;
1337:

Line 1342: IF FND_API.To_Boolean( p_commit ) THEN

1338: -- End of API Body
1339:
1340: -- Standard check of p_commit.
1341:
1342: IF FND_API.To_Boolean( p_commit ) THEN
1343: COMMIT WORK;
1344: END IF;
1345:
1346: -- Standard call to get message count and if count is 1, get message info.

Line 1355: WHEN FND_API.G_EXC_ERROR THEN

1351: );
1352:
1353: EXCEPTION
1354:
1355: WHEN FND_API.G_EXC_ERROR THEN
1356: ROLLBACK TO GET_EXCEPTION_PUB;
1357: x_return_status := FND_API.G_RET_STS_ERROR ;
1358: FND_MSG_PUB.Count_And_Get
1359: (p_count => x_msg_count ,

Line 1357: x_return_status := FND_API.G_RET_STS_ERROR ;

1353: EXCEPTION
1354:
1355: WHEN FND_API.G_EXC_ERROR THEN
1356: ROLLBACK TO GET_EXCEPTION_PUB;
1357: x_return_status := FND_API.G_RET_STS_ERROR ;
1358: FND_MSG_PUB.Count_And_Get
1359: (p_count => x_msg_count ,
1360: p_data => x_msg_data
1361: );

Line 1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1358: FND_MSG_PUB.Count_And_Get
1359: (p_count => x_msg_count ,
1360: p_data => x_msg_data
1361: );
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1363: ROLLBACK TO GET_EXCEPTION_PUB;
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1365: FND_MSG_PUB.Count_And_Get
1366: (p_count => x_msg_count ,

Line 1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1360: p_data => x_msg_data
1361: );
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1363: ROLLBACK TO GET_EXCEPTION_PUB;
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1365: FND_MSG_PUB.Count_And_Get
1366: (p_count => x_msg_count ,
1367: p_data => x_msg_data
1368: );

Line 1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1367: p_data => x_msg_data
1368: );
1369: WHEN OTHERS THEN
1370: ROLLBACK TO GET_EXCEPTION_PUB;
1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1372: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1373: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1374: END IF;
1375: FND_MSG_PUB.Count_And_Get