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.

[Home] [Help]

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 690: IF NOT FND_API.Compatible_API_Call (l_api_version ,

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

Line 694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 699: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 705: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 733: p_init_msg_list => FND_API.G_FALSE,

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

Line 734: p_commit => FND_API.G_FALSE,

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

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

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

Line 780: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 793: WHEN FND_API.G_EXC_ERROR THEN

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

Line 795: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 838: -- Default = FND_API.G_FALSE

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

Line 840: -- Default = FND_API.G_FALSE

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

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

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

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

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

Line 996: IF NOT FND_API.Compatible_API_Call (l_api_version ,

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

Line 1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1005: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 1011: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1039: p_init_msg_list => FND_API.G_FALSE,

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

Line 1040: p_commit => FND_API.G_FALSE,

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

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

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

Line 1085: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 1098: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1100: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1139: -- Default = FND_API.G_FALSE

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

Line 1141: -- Default = FND_API.G_FALSE

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

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

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

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

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

Line 1248: IF NOT FND_API.Compatible_API_Call (l_api_version ,

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

Line 1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1257: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 1263: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1291: p_init_msg_list => FND_API.G_FALSE,

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

Line 1292: p_commit => FND_API.G_FALSE,

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

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

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

Line 1340: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 1353: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1355: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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