DBA Data[Home] [Help]

APPS.AMV_AQ_UTILITY_PVT dependencies on STANDARD

Line 324: -- Standard call to check for call compatibility.

320: --
321: l_admin_flag VARCHAR2(1);
322: --
323: BEGIN
324: -- Standard call to check for call compatibility.
325: SAVEPOINT Add_Queue_Pvt;
326: IF NOT FND_API.Compatible_API_Call (
327: l_api_version,
328: p_api_version,

Line 382: --Standard check of commit

378: p_queue_table_name => p_queue_table_name,
379: p_queue_name => p_queue_name,
380: p_payload_obj_type => p_payload_obj_type
381: );
382: --Standard check of commit
383: IF FND_API.To_Boolean ( p_commit ) THEN
384: COMMIT WORK;
385: END IF;
386: --Standard call to get message count and if count=1, get the message

Line 386: --Standard call to get message count and if count=1, get the message

382: --Standard check of commit
383: IF FND_API.To_Boolean ( p_commit ) THEN
384: COMMIT WORK;
385: END IF;
386: --Standard call to get message count and if count=1, get the message
387: FND_MSG_PUB.Count_And_Get (
388: p_count => x_msg_count,
389: p_data => x_msg_data
390: );

Line 395: -- Standard call to get message count and if count=1, get the message

391: EXCEPTION
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393: ROLLBACK TO Add_Queue_Pvt;
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395: -- Standard call to get message count and if count=1, get the message
396: FND_MSG_PUB.Count_And_Get (
397: p_count => x_msg_count,
398: p_data => x_msg_data
399: );

Line 403: -- Standard call to get message count and if count=1, get the message

399: );
400: WHEN FND_API.G_EXC_ERROR THEN
401: ROLLBACK TO Add_Queue_Pvt;
402: x_return_status := FND_API.G_RET_STS_ERROR;
403: -- Standard call to get message count and if count=1, get the message
404: FND_MSG_PUB.Count_And_Get (
405: p_count => x_msg_count,
406: p_data => x_msg_data
407: );

Line 414: -- Standard call to get message count and if count=1, get the message

410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
412: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
413: END IF;
414: -- Standard call to get message count and if count=1, get the message
415: FND_MSG_PUB.Count_And_Get (
416: p_count => x_msg_count,
417: p_data => x_msg_data
418: );

Line 443: -- Standard call to check for call compatibility.

439: l_current_user_status VARCHAR2(80);
440: --
441: l_admin_flag VARCHAR2(1);
442: BEGIN
443: -- Standard call to check for call compatibility.
444: SAVEPOINT Delete_Queue_Pvt;
445: IF NOT FND_API.Compatible_API_Call (
446: l_api_version,
447: p_api_version,

Line 500: --Standard check of commit

496: (
497: p_queue_table_name => p_queue_table_name,
498: p_queue_name => p_queue_name
499: );
500: --Standard check of commit
501: IF FND_API.To_Boolean ( p_commit ) THEN
502: COMMIT WORK;
503: END IF;
504: --Standard call to get message count and if count=1, get the message

Line 504: --Standard call to get message count and if count=1, get the message

500: --Standard check of commit
501: IF FND_API.To_Boolean ( p_commit ) THEN
502: COMMIT WORK;
503: END IF;
504: --Standard call to get message count and if count=1, get the message
505: FND_MSG_PUB.Count_And_Get (
506: p_count => x_msg_count,
507: p_data => x_msg_data
508: );

Line 513: -- Standard call to get message count and if count=1, get the message

509: EXCEPTION
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: ROLLBACK TO Delete_Queue_Pvt;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513: -- Standard call to get message count and if count=1, get the message
514: FND_MSG_PUB.Count_And_Get (
515: p_count => x_msg_count,
516: p_data => x_msg_data
517: );

Line 521: -- Standard call to get message count and if count=1, get the message

517: );
518: WHEN FND_API.G_EXC_ERROR THEN
519: ROLLBACK TO Delete_Queue_Pvt;
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: -- Standard call to get message count and if count=1, get the message
522: FND_MSG_PUB.Count_And_Get (
523: p_count => x_msg_count,
524: p_data => x_msg_data
525: );

Line 532: -- Standard call to get message count and if count=1, get the message

528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
530: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
531: END IF;
532: -- Standard call to get message count and if count=1, get the message
533: FND_MSG_PUB.Count_And_Get (
534: p_count => x_msg_count,
535: p_data => x_msg_data
536: );

Line 560: -- Standard call to check for call compatibility.

556: l_current_user_status VARCHAR2(80);
557: --
558: l_admin_flag VARCHAR2(1);
559: BEGIN
560: -- Standard call to check for call compatibility.
561: SAVEPOINT Enqueue_Message_Pvt;
562: IF NOT FND_API.Compatible_API_Call (
563: l_api_version,
564: p_api_version,

Line 616: --Standard check of commit

612: Enqueue_Message
613: (
614: p_message_obj => p_message_obj
615: );
616: --Standard check of commit
617: IF FND_API.To_Boolean ( p_commit ) THEN
618: COMMIT WORK;
619: END IF;
620: --Standard call to get message count and if count=1, get the message

Line 620: --Standard call to get message count and if count=1, get the message

616: --Standard check of commit
617: IF FND_API.To_Boolean ( p_commit ) THEN
618: COMMIT WORK;
619: END IF;
620: --Standard call to get message count and if count=1, get the message
621: FND_MSG_PUB.Count_And_Get (
622: p_count => x_msg_count,
623: p_data => x_msg_data
624: );

Line 629: -- Standard call to get message count and if count=1, get the message

625: EXCEPTION
626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
627: ROLLBACK TO Enqueue_Message_Pvt;
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: -- Standard call to get message count and if count=1, get the message
630: FND_MSG_PUB.Count_And_Get (
631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );

Line 637: -- Standard call to get message count and if count=1, get the message

633: );
634: WHEN FND_API.G_EXC_ERROR THEN
635: ROLLBACK TO Enqueue_Message_Pvt;
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: -- Standard call to get message count and if count=1, get the message
638: FND_MSG_PUB.Count_And_Get (
639: p_count => x_msg_count,
640: p_data => x_msg_data
641: );

Line 648: -- Standard call to get message count and if count=1, get the message

644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
645: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
646: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
647: END IF;
648: -- Standard call to get message count and if count=1, get the message
649: FND_MSG_PUB.Count_And_Get (
650: p_count => x_msg_count,
651: p_data => x_msg_data
652: );

Line 677: -- Standard call to check for call compatibility.

673: l_current_user_status VARCHAR2(80);
674: --
675: l_admin_flag VARCHAR2(1);
676: BEGIN
677: -- Standard call to check for call compatibility.
678: SAVEPOINT Delete_Queue_Pvt;
679: IF NOT FND_API.Compatible_API_Call (
680: l_api_version,
681: p_api_version,

Line 734: --Standard check of commit

730: (
731: p_delete_flag => p_delete_flag,
732: x_message_obj => x_message_obj
733: );
734: --Standard check of commit
735: IF FND_API.To_Boolean ( p_commit ) THEN
736: COMMIT WORK;
737: END IF;
738: --Standard call to get message count and if count=1, get the message

Line 738: --Standard call to get message count and if count=1, get the message

734: --Standard check of commit
735: IF FND_API.To_Boolean ( p_commit ) THEN
736: COMMIT WORK;
737: END IF;
738: --Standard call to get message count and if count=1, get the message
739: FND_MSG_PUB.Count_And_Get (
740: p_count => x_msg_count,
741: p_data => x_msg_data
742: );

Line 747: -- Standard call to get message count and if count=1, get the message

743: EXCEPTION
744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745: ROLLBACK TO Delete_Queue_Pvt;
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
747: -- Standard call to get message count and if count=1, get the message
748: FND_MSG_PUB.Count_And_Get (
749: p_count => x_msg_count,
750: p_data => x_msg_data
751: );

Line 755: -- Standard call to get message count and if count=1, get the message

751: );
752: WHEN FND_API.G_EXC_ERROR THEN
753: ROLLBACK TO Delete_Queue_Pvt;
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: -- Standard call to get message count and if count=1, get the message
756: FND_MSG_PUB.Count_And_Get (
757: p_count => x_msg_count,
758: p_data => x_msg_data
759: );

Line 766: -- Standard call to get message count and if count=1, get the message

762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
763: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
764: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
765: END IF;
766: -- Standard call to get message count and if count=1, get the message
767: FND_MSG_PUB.Count_And_Get (
768: p_count => x_msg_count,
769: p_data => x_msg_data
770: );