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.DPP_APPROVAL_PVT dependencies on FND_MSG_PUB

Line 10: DPP_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

6:
7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9:
10: DPP_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
11: DPP_UNEXP_ERROR_ON BOOLEAN :=FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error);
12: DPP_ERROR_ON BOOLEAN := FND_MSG_PUB.check_msg_level(fnd_msg_pub.g_msg_lvl_error);
13: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
14:

Line 11: DPP_UNEXP_ERROR_ON BOOLEAN :=FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error);

7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9:
10: DPP_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
11: DPP_UNEXP_ERROR_ON BOOLEAN :=FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error);
12: DPP_ERROR_ON BOOLEAN := FND_MSG_PUB.check_msg_level(fnd_msg_pub.g_msg_lvl_error);
13: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
14:
15: --Defining Global Value as Update_user_status, parametes are already defined

Line 12: DPP_ERROR_ON BOOLEAN := FND_MSG_PUB.check_msg_level(fnd_msg_pub.g_msg_lvl_error);

8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9:
10: DPP_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
11: DPP_UNEXP_ERROR_ON BOOLEAN :=FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error);
12: DPP_ERROR_ON BOOLEAN := FND_MSG_PUB.check_msg_level(fnd_msg_pub.g_msg_lvl_error);
13: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
14:
15: --Defining Global Value as Update_user_status, parametes are already defined
16: G_FORWARD_USER NUMBER;

Line 13: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

9:
10: DPP_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
11: DPP_UNEXP_ERROR_ON BOOLEAN :=FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error);
12: DPP_ERROR_ON BOOLEAN := FND_MSG_PUB.check_msg_level(fnd_msg_pub.g_msg_lvl_error);
13: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
14:
15: --Defining Global Value as Update_user_status, parametes are already defined
16: G_FORWARD_USER NUMBER;
17:

Line 144: FND_MSG_PUB.initialize;

140: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Start');
141:
142: --Initialize message list if p_init_msg_list is TRUE.
143: IF FND_API.To_Boolean (p_init_msg_list) THEN
144: FND_MSG_PUB.initialize;
145: END IF;
146: -- Initialize API return status to sucess
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:

Line 298: FND_MSG_PUB.Count_And_Get (

294:
295: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');
296:
297: --Standard call to get message count and if count=1, get the message
298: FND_MSG_PUB.Count_And_Get (
299: p_encoded => FND_API.G_FALSE,
300: p_count => x_msg_count,
301: p_data => x_msg_data
302: );

Line 308: FND_MSG_PUB.Count_And_Get (

304: WHEN FND_API.G_EXC_ERROR THEN
305: ROLLBACK TO Update_User_Action_PVT;
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: -- Standard call to get message count and if count=1, get the message
308: FND_MSG_PUB.Count_And_Get (
309: p_encoded => FND_API.G_FALSE,
310: p_count => x_msg_count,
311: p_data => x_msg_data
312: );

Line 315: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

311: p_data => x_msg_data
312: );
313: IF x_msg_count > 1 THEN
314: FOR I IN 1..x_msg_count LOOP
315: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
316: END LOOP;
317: END IF;
318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
319: ROLLBACK TO Update_User_Action_PVT;

Line 322: FND_MSG_PUB.Count_And_Get (

318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
319: ROLLBACK TO Update_User_Action_PVT;
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: -- Standard call to get message count and if count=1, get the message
322: FND_MSG_PUB.Count_And_Get (
323: p_encoded => FND_API.G_FALSE,
324: p_count => x_msg_count,
325: p_data => x_msg_data
326: );

Line 329: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

325: p_data => x_msg_data
326: );
327: IF x_msg_count > 1 THEN
328: FOR I IN 1..x_msg_count LOOP
329: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
330: END LOOP;
331: END IF;
332: WHEN OTHERS THEN
333: ROLLBACK TO Update_User_Action_PVT;

Line 337: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

333: ROLLBACK TO Update_User_Action_PVT;
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335: IF DPP_UNEXP_ERROR_ON
336: THEN
337: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
338: END IF;
339: -- Standard call to get message count and if count=1, get the message
340: FND_MSG_PUB.Count_And_Get (
341: p_encoded => FND_API.G_FALSE,

Line 340: FND_MSG_PUB.Count_And_Get (

336: THEN
337: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
338: END IF;
339: -- Standard call to get message count and if count=1, get the message
340: FND_MSG_PUB.Count_And_Get (
341: p_encoded => FND_API.G_FALSE,
342: p_count => x_msg_count,
343: p_data => x_msg_data
344: );

Line 347: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

343: p_data => x_msg_data
344: );
345: IF x_msg_count > 1 THEN
346: FOR I IN 1..x_msg_count LOOP
347: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
348: END LOOP;
349: END IF;
350: --
351: END Update_User_Action;

Line 413: FND_MSG_PUB.initialize;

409: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Start');
410:
411: --Initialize message list if p_init_msg_list is TRUE.
412: IF FND_API.To_Boolean (p_init_msg_list) THEN
413: FND_MSG_PUB.initialize;
414: END IF;
415: -- Initialize API return status to sucess
416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417:

Line 532: FND_MSG_PUB.Count_And_Get (

528: END LOOP;
529: END IF;
530:
531: --Standard call to get message count and if count=1, get the message
532: FND_MSG_PUB.Count_And_Get (
533: p_encoded => FND_API.G_FALSE,
534: p_count => x_msg_count,
535: p_data => x_msg_data
536: );

Line 542: FND_MSG_PUB.Count_And_Get (

538: WHEN FND_API.G_EXC_ERROR THEN
539: ROLLBACK TO Get_Approvers_PVT;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: -- Standard call to get message count and if count=1, get the message
542: FND_MSG_PUB.Count_And_Get (
543: p_encoded => FND_API.G_FALSE,
544: p_count => x_msg_count,
545: p_data => x_msg_data
546: );

Line 549: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

545: p_data => x_msg_data
546: );
547: IF x_msg_count > 1 THEN
548: FOR I IN 1..x_msg_count LOOP
549: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
550: END LOOP;
551: END IF;
552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
553: ROLLBACK TO Get_Approvers_PVT;

Line 556: FND_MSG_PUB.Count_And_Get (

552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
553: ROLLBACK TO Get_Approvers_PVT;
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: -- Standard call to get message count and if count=1, get the message
556: FND_MSG_PUB.Count_And_Get (
557: p_encoded => FND_API.G_FALSE,
558: p_count => x_msg_count,
559: p_data => x_msg_data
560: );

Line 563: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

559: p_data => x_msg_data
560: );
561: IF x_msg_count > 1 THEN
562: FOR I IN 1..x_msg_count LOOP
563: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
564: END LOOP;
565: END IF;
566: WHEN OTHERS THEN
567: ROLLBACK TO Get_Approvers_PVT;

Line 571: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

567: ROLLBACK TO Get_Approvers_PVT;
568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
569: IF DPP_UNEXP_ERROR_ON
570: THEN
571: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
572: END IF;
573: -- Standard call to get message count and if count=1, get the message
574: FND_MSG_PUB.Count_And_Get (
575: p_encoded => FND_API.G_FALSE,

Line 574: FND_MSG_PUB.Count_And_Get (

570: THEN
571: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
572: END IF;
573: -- Standard call to get message count and if count=1, get the message
574: FND_MSG_PUB.Count_And_Get (
575: p_encoded => FND_API.G_FALSE,
576: p_count => x_msg_count,
577: p_data => x_msg_data
578: );

Line 581: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

577: p_data => x_msg_data
578: );
579: IF x_msg_count > 1 THEN
580: FOR I IN 1..x_msg_count LOOP
581: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
582: END LOOP;
583: END IF;
584: --
585: END Get_Approvers;

Line 638: FND_MSG_PUB.initialize;

634: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Start');
635:
636: --Initialize message list if p_init_msg_list is TRUE.
637: IF FND_API.To_Boolean (p_init_msg_list) THEN
638: FND_MSG_PUB.initialize;
639: END IF;
640: --Initialize API return status to sucess
641: x_return_status := FND_API.G_RET_STS_SUCCESS;
642:

Line 678: FND_MSG_PUB.add;

674: AND rownum <2;
675: EXCEPTION
676: WHEN NO_DATA_FOUND THEN
677: FND_MESSAGE.set_name('DPP', 'DPP_AME_NO_APP');
678: FND_MSG_PUB.add;
679: RAISE FND_API.G_EXC_ERROR;
680: WHEN OTHERS THEN
681: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
682: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');

Line 685: FND_MSG_PUB.add;

681: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
682: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');
683: fnd_message.set_token('ERRNO', sqlcode);
684: fnd_message.set_token('REASON', sqlerrm);
685: FND_MSG_PUB.add;
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: END;
688: p_approversOut(1).first_name := l_first_name;
689: p_approversOut(1).last_name := l_last_name;

Line 692: FND_MSG_PUB.add;

688: p_approversOut(1).first_name := l_first_name;
689: p_approversOut(1).last_name := l_last_name;
690: ELSE
691: FND_MESSAGE.set_name('DPP', 'DPP_AME_NO_APP');
692: FND_MSG_PUB.add;
693:
694: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'No default approver set for the object type : '||p_approval_rec.object_type);
695:
696: END IF;

Line 722: FND_MSG_PUB.add;

718: EXCEPTION
719: WHEN NO_DATA_FOUND THEN
720: l_approver_email := NULL;
721: FND_MESSAGE.set_name('DPP', 'DPP_NO_APP_DETAIL');
722: FND_MSG_PUB.add;
723: RAISE FND_API.G_EXC_ERROR;
724: WHEN OTHERS THEN
725: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
726: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');

Line 729: FND_MSG_PUB.add;

725: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
726: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');
727: fnd_message.set_token('ERRNO', sqlcode);
728: fnd_message.set_token('REASON', sqlerrm);
729: FND_MSG_PUB.add;
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END;
732: ELSE -- Both the person id and the user id are null
733:

Line 737: FND_MSG_PUB.add;

733:
734: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'No details retrieved for the Approver ');
735:
736: FND_MESSAGE.set_name('DPP', 'DPP_NO_APP_DETAIL');
737: FND_MSG_PUB.add;
738: l_approver_email := NULL;
739: END IF; --l_approversOut(i).person_id IS NOT NULL
740: --Retrieve the approval group name
741: BEGIN

Line 749: FND_MSG_PUB.add;

745: WHERE approval_group_id = l_approversOut(i).group_or_chain_id;
746: EXCEPTION
747: WHEN NO_DATA_FOUND THEN
748: FND_MESSAGE.set_name('DPP', 'DPP_NO_APP_GRP_DETAIL');
749: FND_MSG_PUB.add;
750: RAISE FND_API.G_EXC_ERROR;
751: WHEN OTHERS THEN
752: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
753: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');

Line 756: FND_MSG_PUB.add;

752: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
753: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');
754: fnd_message.set_token('ERRNO', sqlcode);
755: fnd_message.set_token('REASON', sqlerrm);
756: FND_MSG_PUB.add;
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END;
759: --Retrieve the order number
760: BEGIN

Line 769: FND_MSG_PUB.add;

765: AND orig_system_id = l_approversOut(i).orig_system_id; --nvl(l_approversOut(i).orig_system_id,l_approversOut(i).user_id);
766: EXCEPTION
767: WHEN NO_DATA_FOUND THEN
768: FND_MESSAGE.set_name('DPP', 'DPP_NO_APP_SEQ');
769: FND_MSG_PUB.add;
770: RAISE FND_API.G_EXC_ERROR;
771: WHEN OTHERS THEN
772: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
773: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');

Line 776: FND_MSG_PUB.add;

772: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
773: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');
774: fnd_message.set_token('ERRNO', sqlcode);
775: fnd_message.set_token('REASON', sqlerrm);
776: FND_MSG_PUB.add;
777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
778: END;
779: --Assign the approver details to the out variable
780: p_approversOut(i).user_id := l_approversOut(i).orig_system_id;

Line 801: FND_MSG_PUB.Count_And_Get (

797:
798: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');
799:
800: --Standard call to get message count and if count=1, get the message
801: FND_MSG_PUB.Count_And_Get (
802: p_encoded => FND_API.G_FALSE,
803: p_count => x_msg_count,
804: p_data => x_msg_data
805: );

Line 811: FND_MSG_PUB.Count_And_Get (

807: WHEN FND_API.G_EXC_ERROR THEN
808: ROLLBACK TO Get_AllApprovers_PVT;
809: x_return_status := FND_API.G_RET_STS_ERROR;
810: -- Standard call to get message count and if count=1, get the message
811: FND_MSG_PUB.Count_And_Get (
812: p_encoded => FND_API.G_FALSE,
813: p_count => x_msg_count,
814: p_data => x_msg_data
815: );

Line 818: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

814: p_data => x_msg_data
815: );
816: IF x_msg_count > 1 THEN
817: FOR I IN 1..x_msg_count LOOP
818: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
819: END LOOP;
820: END IF;
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: ROLLBACK TO Get_AllApprovers_PVT;

Line 825: FND_MSG_PUB.Count_And_Get (

821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: ROLLBACK TO Get_AllApprovers_PVT;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (
826: p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,
828: p_data => x_msg_data
829: );

Line 832: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

828: p_data => x_msg_data
829: );
830: IF x_msg_count > 1 THEN
831: FOR I IN 1..x_msg_count LOOP
832: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
833: END LOOP;
834: END IF;
835: WHEN OTHERS THEN
836: ROLLBACK TO Get_AllApprovers_PVT;

Line 840: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

836: ROLLBACK TO Get_AllApprovers_PVT;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: IF DPP_UNEXP_ERROR_ON
839: THEN
840: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
841: END IF;
842: -- Standard call to get message count and if count=1, get the message
843: FND_MSG_PUB.Count_And_Get (
844: p_encoded => FND_API.G_FALSE,

Line 843: FND_MSG_PUB.Count_And_Get (

839: THEN
840: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
841: END IF;
842: -- Standard call to get message count and if count=1, get the message
843: FND_MSG_PUB.Count_And_Get (
844: p_encoded => FND_API.G_FALSE,
845: p_count => x_msg_count,
846: p_data => x_msg_data
847: );

Line 850: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

846: p_data => x_msg_data
847: );
848: IF x_msg_count > 1 THEN
849: FOR I IN 1..x_msg_count LOOP
850: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
851: END LOOP;
852: END IF;
853: --
854: END Get_AllApprovers;

Line 901: FND_MSG_PUB.initialize;

897: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Start');
898:
899: --Initialize message list if p_init_msg_list is TRUE.
900: IF FND_API.To_Boolean (p_init_msg_list) THEN
901: FND_MSG_PUB.initialize;
902: END IF;
903: -- Initialize API return status to sucess
904: x_return_status := FND_API.G_RET_STS_SUCCESS;
905:

Line 917: FND_MSG_PUB.Count_And_Get (

913:
914: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');
915:
916: --Standard call to get message count and if count=1, get the message
917: FND_MSG_PUB.Count_And_Get (
918: p_encoded => FND_API.G_FALSE,
919: p_count => x_msg_count,
920: p_data => x_msg_data
921: );

Line 927: FND_MSG_PUB.Count_And_Get (

923: WHEN FND_API.G_EXC_ERROR THEN
924: ROLLBACK TO Clear_All_Approvals_PVT;
925: x_return_status := FND_API.G_RET_STS_ERROR;
926: -- Standard call to get message count and if count=1, get the message
927: FND_MSG_PUB.Count_And_Get (
928: p_encoded => FND_API.G_FALSE,
929: p_count => x_msg_count,
930: p_data => x_msg_data
931: );

Line 934: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

930: p_data => x_msg_data
931: );
932: IF x_msg_count > 1 THEN
933: FOR I IN 1..x_msg_count LOOP
934: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
935: END LOOP;
936: END IF;
937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
938: ROLLBACK TO Clear_All_Approvals_PVT;

Line 941: FND_MSG_PUB.Count_And_Get (

937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
938: ROLLBACK TO Clear_All_Approvals_PVT;
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
940: -- Standard call to get message count and if count=1, get the message
941: FND_MSG_PUB.Count_And_Get (
942: p_encoded => FND_API.G_FALSE,
943: p_count => x_msg_count,
944: p_data => x_msg_data
945: );

Line 948: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

944: p_data => x_msg_data
945: );
946: IF x_msg_count > 1 THEN
947: FOR I IN 1..x_msg_count LOOP
948: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
949: END LOOP;
950: END IF;
951: WHEN OTHERS THEN
952: ROLLBACK TO Clear_All_Approvals_PVT;

Line 956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

952: ROLLBACK TO Clear_All_Approvals_PVT;
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: IF DPP_UNEXP_ERROR_ON
955: THEN
956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
957: END IF;
958: -- Standard call to get message count and if count=1, get the message
959: FND_MSG_PUB.Count_And_Get (
960: p_encoded => FND_API.G_FALSE,

Line 959: FND_MSG_PUB.Count_And_Get (

955: THEN
956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
957: END IF;
958: -- Standard call to get message count and if count=1, get the message
959: FND_MSG_PUB.Count_And_Get (
960: p_encoded => FND_API.G_FALSE,
961: p_count => x_msg_count,
962: p_data => x_msg_data
963: );

Line 966: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

962: p_data => x_msg_data
963: );
964: IF x_msg_count > 1 THEN
965: FOR I IN 1..x_msg_count LOOP
966: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
967: END LOOP;
968: END IF;
969: --
970: END Clear_All_Approvals;

Line 1020: FND_MSG_PUB.initialize;

1016: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Start');
1017:
1018: --Initialize message list if p_init_msg_list is TRUE.
1019: IF FND_API.To_Boolean (p_init_msg_list) THEN
1020: FND_MSG_PUB.initialize;
1021: END IF;
1022: -- Initialize API return status to sucess
1023: x_return_status := FND_API.G_RET_STS_SUCCESS;
1024:

Line 1133: FND_MSG_PUB.Count_And_Get (

1129:
1130: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');
1131:
1132: --Standard call to get message count and if count=1, get the message
1133: FND_MSG_PUB.Count_And_Get (
1134: p_encoded => FND_API.G_FALSE,
1135: p_count => x_msg_count,
1136: p_data => x_msg_data
1137: );

Line 1143: FND_MSG_PUB.Count_And_Get (

1139: WHEN FND_API.G_EXC_ERROR THEN
1140: ROLLBACK TO Add_Access_PVT;
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142: -- Standard call to get message count and if count=1, get the message
1143: FND_MSG_PUB.Count_And_Get (
1144: p_encoded => FND_API.G_FALSE,
1145: p_count => x_msg_count,
1146: p_data => x_msg_data
1147: );

Line 1150: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1146: p_data => x_msg_data
1147: );
1148: IF x_msg_count > 1 THEN
1149: FOR I IN 1..x_msg_count LOOP
1150: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1151: END LOOP;
1152: END IF;
1153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1154: ROLLBACK TO Add_Access_PVT;

Line 1157: FND_MSG_PUB.Count_And_Get (

1153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1154: ROLLBACK TO Add_Access_PVT;
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1156: -- Standard call to get message count and if count=1, get the message
1157: FND_MSG_PUB.Count_And_Get (
1158: p_encoded => FND_API.G_FALSE,
1159: p_count => x_msg_count,
1160: p_data => x_msg_data
1161: );

Line 1164: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1160: p_data => x_msg_data
1161: );
1162: IF x_msg_count > 1 THEN
1163: FOR I IN 1..x_msg_count LOOP
1164: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1165: END LOOP;
1166: END IF;
1167: WHEN OTHERS THEN
1168: ROLLBACK TO Add_Access_PVT;

Line 1172: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1168: ROLLBACK TO Add_Access_PVT;
1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1170: IF DPP_UNEXP_ERROR_ON
1171: THEN
1172: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1173: END IF;
1174: -- Standard call to get message count and if count=1, get the message
1175: FND_MSG_PUB.Count_And_Get (
1176: p_encoded => FND_API.G_FALSE,

Line 1175: FND_MSG_PUB.Count_And_Get (

1171: THEN
1172: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1173: END IF;
1174: -- Standard call to get message count and if count=1, get the message
1175: FND_MSG_PUB.Count_And_Get (
1176: p_encoded => FND_API.G_FALSE,
1177: p_count => x_msg_count,
1178: p_data => x_msg_data
1179: );

Line 1182: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1178: p_data => x_msg_data
1179: );
1180: IF x_msg_count > 1 THEN
1181: FOR I IN 1..x_msg_count LOOP
1182: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1183: END LOOP;
1184: END IF;
1185: --
1186: END Add_Access;

Line 1241: FND_MSG_PUB.Add;

1237: -- Debug Message
1238: IF G_DEBUG THEN
1239: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1240: FND_MESSAGE.Set_Token('TEXT',l_api_name||': Start');
1241: FND_MSG_PUB.Add;
1242: END IF;
1243: --Initialize message list if p_init_msg_list is TRUE.
1244: IF FND_API.To_Boolean (p_init_msg_list) THEN
1245: FND_MSG_PUB.initialize;

Line 1245: FND_MSG_PUB.initialize;

1241: FND_MSG_PUB.Add;
1242: END IF;
1243: --Initialize message list if p_init_msg_list is TRUE.
1244: IF FND_API.To_Boolean (p_init_msg_list) THEN
1245: FND_MSG_PUB.initialize;
1246: END IF;
1247: -- Initialize API return status to sucess
1248: x_return_status := FND_API.G_RET_STS_SUCCESS;
1249:

Line 1283: FND_MSG_PUB.Count_And_Get (

1279:
1280: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');
1281:
1282: --Standard call to get message count and if count=1, get the message
1283: FND_MSG_PUB.Count_And_Get (
1284: p_encoded => FND_API.G_FALSE,
1285: p_count => x_msg_count,
1286: p_data => x_msg_data
1287: );

Line 1293: FND_MSG_PUB.Count_And_Get (

1289: WHEN FND_API.G_EXC_ERROR THEN
1290: ROLLBACK TO Revoke_Access_PVT;
1291: x_return_status := FND_API.G_RET_STS_ERROR;
1292: -- Standard call to get message count and if count=1, get the message
1293: FND_MSG_PUB.Count_And_Get (
1294: p_encoded => FND_API.G_FALSE,
1295: p_count => x_msg_count,
1296: p_data => x_msg_data
1297: );

Line 1300: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1296: p_data => x_msg_data
1297: );
1298: IF x_msg_count > 1 THEN
1299: FOR I IN 1..x_msg_count LOOP
1300: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1301: END LOOP;
1302: END IF;
1303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1304: ROLLBACK TO Revoke_Access_PVT;

Line 1307: FND_MSG_PUB.Count_And_Get (

1303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1304: ROLLBACK TO Revoke_Access_PVT;
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306: -- Standard call to get message count and if count=1, get the message
1307: FND_MSG_PUB.Count_And_Get (
1308: p_encoded => FND_API.G_FALSE,
1309: p_count => x_msg_count,
1310: p_data => x_msg_data
1311: );

Line 1314: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1310: p_data => x_msg_data
1311: );
1312: IF x_msg_count > 1 THEN
1313: FOR I IN 1..x_msg_count LOOP
1314: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1315: END LOOP;
1316: END IF;
1317: WHEN OTHERS THEN
1318: ROLLBACK TO Revoke_Access_PVT;

Line 1322: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1318: ROLLBACK TO Revoke_Access_PVT;
1319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1320: IF DPP_UNEXP_ERROR_ON
1321: THEN
1322: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1323: END IF;
1324: -- Standard call to get message count and if count=1, get the message
1325: FND_MSG_PUB.Count_And_Get (
1326: p_encoded => FND_API.G_FALSE,

Line 1325: FND_MSG_PUB.Count_And_Get (

1321: THEN
1322: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1323: END IF;
1324: -- Standard call to get message count and if count=1, get the message
1325: FND_MSG_PUB.Count_And_Get (
1326: p_encoded => FND_API.G_FALSE,
1327: p_count => x_msg_count,
1328: p_data => x_msg_data
1329: );

Line 1332: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1328: p_data => x_msg_data
1329: );
1330: IF x_msg_count > 1 THEN
1331: FOR I IN 1..x_msg_count LOOP
1332: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1333: END LOOP;
1334: END IF;
1335: --
1336: END Revoke_Access;

Line 1529: FND_MSG_PUB.Count_And_Get (

1525: WHEN FND_API.G_EXC_ERROR THEN
1526: ROLLBACK TO Raise_Event_PVT;
1527: x_return_status := FND_API.G_RET_STS_ERROR;
1528: -- Standard call to get message count and if count=1, get the message
1529: FND_MSG_PUB.Count_And_Get (
1530: p_encoded => FND_API.G_FALSE,
1531: p_count => x_msg_count,
1532: p_data => x_msg_data
1533: );

Line 1536: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1532: p_data => x_msg_data
1533: );
1534: IF x_msg_count > 1 THEN
1535: FOR I IN 1..x_msg_count LOOP
1536: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1537: END LOOP;
1538: END IF;
1539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1540: ROLLBACK TO Raise_Event_PVT;

Line 1543: FND_MSG_PUB.Count_And_Get (

1539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1540: ROLLBACK TO Raise_Event_PVT;
1541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1542: -- Standard call to get message count and if count=1, get the message
1543: FND_MSG_PUB.Count_And_Get (
1544: p_encoded => FND_API.G_FALSE,
1545: p_count => x_msg_count,
1546: p_data => x_msg_data
1547: );

Line 1550: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1546: p_data => x_msg_data
1547: );
1548: IF x_msg_count > 1 THEN
1549: FOR I IN 1..x_msg_count LOOP
1550: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1551: END LOOP;
1552: END IF;
1553: WHEN OTHERS THEN
1554: ROLLBACK TO Raise_Event_PVT;

Line 1558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1554: ROLLBACK TO Raise_Event_PVT;
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1556: IF DPP_UNEXP_ERROR_ON
1557: THEN
1558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1559: END IF;
1560: -- Standard call to get message count and if count=1, get the message
1561: FND_MSG_PUB.Count_And_Get (
1562: p_encoded => FND_API.G_FALSE,

Line 1561: FND_MSG_PUB.Count_And_Get (

1557: THEN
1558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1559: END IF;
1560: -- Standard call to get message count and if count=1, get the message
1561: FND_MSG_PUB.Count_And_Get (
1562: p_encoded => FND_API.G_FALSE,
1563: p_count => x_msg_count,
1564: p_data => x_msg_data
1565: );

Line 1568: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1564: p_data => x_msg_data
1565: );
1566: IF x_msg_count > 1 THEN
1567: FOR I IN 1..x_msg_count LOOP
1568: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1569: END LOOP;
1570: END IF;
1571: --
1572: END Raise_Event;

Line 1666: FND_MSG_PUB.initialize;

1662: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Start');
1663:
1664: --Initialize message list if p_init_msg_list is TRUE.
1665: IF FND_API.To_Boolean (p_init_msg_list) THEN
1666: FND_MSG_PUB.initialize;
1667: END IF;
1668: -- Initialize API return status to sucess
1669: x_return_status := FND_API.G_RET_STS_SUCCESS;
1670:

Line 1783: FND_MSG_PUB.Count_And_Get (

1779:
1780: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');
1781:
1782: --Standard call to get message count and if count=1, get the message
1783: FND_MSG_PUB.Count_And_Get (
1784: p_encoded => FND_API.G_FALSE,
1785: p_count => x_msg_count,
1786: p_data => x_msg_data
1787: );

Line 1793: FND_MSG_PUB.Count_And_Get (

1789: WHEN FND_API.G_EXC_ERROR THEN
1790: ROLLBACK TO Send_Notification_PVT;
1791: x_return_status := FND_API.G_RET_STS_ERROR;
1792: -- Standard call to get message count and if count=1, get the message
1793: FND_MSG_PUB.Count_And_Get (
1794: p_encoded => FND_API.G_FALSE,
1795: p_count => x_msg_count,
1796: p_data => x_msg_data
1797: );

Line 1800: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1796: p_data => x_msg_data
1797: );
1798: IF x_msg_count > 1 THEN
1799: FOR I IN 1..x_msg_count LOOP
1800: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1801: END LOOP;
1802: END IF;
1803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1804: ROLLBACK TO Send_Notification_PVT;

Line 1807: FND_MSG_PUB.Count_And_Get (

1803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1804: ROLLBACK TO Send_Notification_PVT;
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1806: -- Standard call to get message count and if count=1, get the message
1807: FND_MSG_PUB.Count_And_Get (
1808: p_encoded => FND_API.G_FALSE,
1809: p_count => x_msg_count,
1810: p_data => x_msg_data
1811: );

Line 1814: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1810: p_data => x_msg_data
1811: );
1812: IF x_msg_count > 1 THEN
1813: FOR I IN 1..x_msg_count LOOP
1814: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1815: END LOOP;
1816: END IF;
1817: WHEN OTHERS THEN
1818: ROLLBACK TO Send_Notification_PVT;

Line 1822: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1818: ROLLBACK TO Send_Notification_PVT;
1819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1820: IF DPP_UNEXP_ERROR_ON
1821: THEN
1822: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1823: END IF;
1824: -- Standard call to get message count and if count=1, get the message
1825: FND_MSG_PUB.Count_And_Get (
1826: p_encoded => FND_API.G_FALSE,

Line 1825: FND_MSG_PUB.Count_And_Get (

1821: THEN
1822: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1823: END IF;
1824: -- Standard call to get message count and if count=1, get the message
1825: FND_MSG_PUB.Count_And_Get (
1826: p_encoded => FND_API.G_FALSE,
1827: p_count => x_msg_count,
1828: p_data => x_msg_data
1829: );

Line 1832: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1828: p_data => x_msg_data
1829: );
1830: IF x_msg_count > 1 THEN
1831: FOR I IN 1..x_msg_count LOOP
1832: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1833: END LOOP;
1834: END IF;
1835: --
1836: END Send_Notification;

Line 1902: FND_MSG_PUB.initialize;

1898: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Start');
1899:
1900: --Initialize message list if p_init_msg_list is TRUE.
1901: IF FND_API.To_Boolean (p_init_msg_list) THEN
1902: FND_MSG_PUB.initialize;
1903: END IF;
1904: x_return_status := FND_API.G_RET_STS_SUCCESS;
1905:
1906: --Retrieve the details of the transaction

Line 1922: FND_MSG_PUB.add;

1918: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1919: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');
1920: fnd_message.set_token('ERRNO', sqlcode);
1921: fnd_message.set_token('REASON', 'Invalid Transaction Header ID');
1922: FND_MSG_PUB.add;
1923: RAISE FND_API.G_EXC_ERROR;
1924: WHEN OTHERS THEN
1925: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1926: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');

Line 1929: FND_MSG_PUB.add;

1925: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1926: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');
1927: fnd_message.set_token('ERRNO', sqlcode);
1928: fnd_message.set_token('REASON', sqlerrm);
1929: FND_MSG_PUB.add;
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END;
1932: -- Update AME/approval tbl of users action and revoke access to existing approvers
1933:

Line 2110: FND_MSG_PUB.add;

2106: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2107: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');
2108: fnd_message.set_token('ERRNO', sqlcode);
2109: fnd_message.set_token('REASON', sqlerrm);
2110: FND_MSG_PUB.add;
2111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2112: END;
2113: --Call the Initiate execution process program to make the transaction Active
2114: DPP_EXECUTIONPROCESS_PVT.Initiate_ExecutionProcess(errbuff,

Line 2146: FND_MSG_PUB.Count_And_Get (

2142:
2143: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');
2144:
2145: --Standard call to get message count and if count=1, get the message
2146: FND_MSG_PUB.Count_And_Get (
2147: p_encoded => FND_API.G_FALSE,
2148: p_count => x_msg_count,
2149: p_data => x_msg_data
2150: );

Line 2157: FND_MSG_PUB.Count_And_Get (

2153: WHEN FND_API.G_EXC_ERROR THEN
2154: ROLLBACK TO Process_User_Action_PVT;
2155: x_return_status := FND_API.G_RET_STS_ERROR;
2156: -- Standard call to get message count and if count=1, get the message
2157: FND_MSG_PUB.Count_And_Get (
2158: p_encoded => FND_API.G_FALSE,
2159: p_count => x_msg_count,
2160: p_data => x_msg_data
2161: );

Line 2164: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

2160: p_data => x_msg_data
2161: );
2162: IF x_msg_count > 1 THEN
2163: FOR I IN 1..x_msg_count LOOP
2164: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
2165: END LOOP;
2166: END IF;
2167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2168: ROLLBACK TO Process_User_Action_PVT;

Line 2171: FND_MSG_PUB.Count_And_Get (

2167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2168: ROLLBACK TO Process_User_Action_PVT;
2169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2170: -- Standard call to get message count and if count=1, get the message
2171: FND_MSG_PUB.Count_And_Get (
2172: p_encoded => FND_API.G_FALSE,
2173: p_count => x_msg_count,
2174: p_data => x_msg_data
2175: );

Line 2178: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

2174: p_data => x_msg_data
2175: );
2176: IF x_msg_count > 1 THEN
2177: FOR I IN 1..x_msg_count LOOP
2178: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
2179: END LOOP;
2180: END IF;
2181: WHEN OTHERS THEN
2182: ROLLBACK TO Process_User_Action_PVT;

Line 2186: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2182: ROLLBACK TO Process_User_Action_PVT;
2183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2184: IF DPP_UNEXP_ERROR_ON
2185: THEN
2186: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2187: END IF;
2188: -- Standard call to get message count and if count=1, get the message
2189: FND_MSG_PUB.Count_And_Get (
2190: p_encoded => FND_API.G_FALSE,

Line 2189: FND_MSG_PUB.Count_And_Get (

2185: THEN
2186: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2187: END IF;
2188: -- Standard call to get message count and if count=1, get the message
2189: FND_MSG_PUB.Count_And_Get (
2190: p_encoded => FND_API.G_FALSE,
2191: p_count => x_msg_count,
2192: p_data => x_msg_data
2193: );

Line 2196: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

2192: p_data => x_msg_data
2193: );
2194: IF x_msg_count > 1 THEN
2195: FOR I IN 1..x_msg_count LOOP
2196: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
2197: END LOOP;
2198: END IF;
2199: --
2200: END Process_User_Action;