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

Line 83: FND_MSG_PUB.initialize;

79: END IF;
80:
81: -- Initialize message list if p_init_msg_list is set to TRUE.
82: IF FND_API.to_Boolean(p_init_msg_list) THEN
83: FND_MSG_PUB.initialize;
84: END IF;
85: -- Initialize API return status to success
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87: ------------------+

Line 107: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

103: AND org_id = l_org_id;
104:
105: IF l_count >= 1 THEN
106: -- Ensure that a mapping type must be unique.
107: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
108: THEN
109: fnd_message.set_name('CN', 'CL_UNIQUE_MAPPING_TYPE');
110: fnd_msg_pub.add;
111: END IF;

Line 110: fnd_msg_pub.add;

106: -- Ensure that a mapping type must be unique.
107: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
108: THEN
109: fnd_message.set_name('CN', 'CL_UNIQUE_MAPPING_TYPE');
110: fnd_msg_pub.add;
111: END IF;
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114:

Line 302: FND_MSG_PUB.Count_And_Get

298: --IF FND_API.To_Boolean( p_commit ) THEN
299: -- COMMIT WORK;
300: --END IF;
301: -- Standard call to get message count and if count is 1, get message info.
302: FND_MSG_PUB.Count_And_Get
303: (p_count => x_msg_count ,
304: p_data => x_msg_data ,
305: p_encoded => FND_API.G_FALSE);
306:

Line 396: FND_MSG_PUB.Count_And_Get

392: EXCEPTION
393: WHEN FND_API.G_EXC_ERROR THEN
394: ROLLBACK TO Create_Map;
395: x_return_status := FND_API.G_RET_STS_ERROR ;
396: FND_MSG_PUB.Count_And_Get
397: (p_count => x_msg_count,
398: p_data => x_msg_data,
399: p_encoded => FND_API.G_FALSE);
400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 403: FND_MSG_PUB.Count_And_Get

399: p_encoded => FND_API.G_FALSE);
400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
401: ROLLBACK TO Create_Map;
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
403: FND_MSG_PUB.Count_And_Get
404: (p_count => x_msg_count,
405: p_data => x_msg_data,
406: p_encoded => FND_API.G_FALSE);
407: WHEN OTHERS THEN

Line 410: IF FND_MSG_PUB.Check_Msg_Level

406: p_encoded => FND_API.G_FALSE);
407: WHEN OTHERS THEN
408: ROLLBACK TO Create_Map;
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: IF FND_MSG_PUB.Check_Msg_Level
411: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
412: FND_MSG_PUB.Add_Exc_Msg
413: (G_PKG_NAME,
414: l_api_name );

Line 411: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

407: WHEN OTHERS THEN
408: ROLLBACK TO Create_Map;
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: IF FND_MSG_PUB.Check_Msg_Level
411: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
412: FND_MSG_PUB.Add_Exc_Msg
413: (G_PKG_NAME,
414: l_api_name );
415: END IF;

Line 412: FND_MSG_PUB.Add_Exc_Msg

408: ROLLBACK TO Create_Map;
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: IF FND_MSG_PUB.Check_Msg_Level
411: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
412: FND_MSG_PUB.Add_Exc_Msg
413: (G_PKG_NAME,
414: l_api_name );
415: END IF;
416: FND_MSG_PUB.Count_And_Get

Line 416: FND_MSG_PUB.Count_And_Get

412: FND_MSG_PUB.Add_Exc_Msg
413: (G_PKG_NAME,
414: l_api_name );
415: END IF;
416: FND_MSG_PUB.Count_And_Get
417: (p_count => x_msg_count,
418: p_data => x_msg_data,
419: p_encoded => FND_API.G_FALSE);
420: END Create_Map;

Line 483: FND_MSG_PUB.initialize;

479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
480: END IF;
481: -- Initialize message list if p_init_msg_list is set to TRUE.
482: IF FND_API.to_Boolean( p_init_msg_list ) THEN
483: FND_MSG_PUB.initialize;
484: END IF;
485: -- Initialize API return status to success
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487:

Line 592: FND_MSG_PUB.Count_And_Get

588: --IF FND_API.To_Boolean( p_commit ) THEN
589: -- COMMIT WORK;
590: --END IF;
591: -- Standard call to get message count and if count is 1, get message info.
592: FND_MSG_PUB.Count_And_Get
593: (p_count => x_msg_count ,
594: p_data => x_msg_data ,
595: p_encoded => FND_API.G_FALSE);
596: EXCEPTION

Line 600: FND_MSG_PUB.Count_And_Get

596: EXCEPTION
597: WHEN FND_API.G_EXC_ERROR THEN
598: ROLLBACK TO Delete_Map;
599: x_return_status := FND_API.G_RET_STS_ERROR ;
600: FND_MSG_PUB.Count_And_Get
601: (p_count => x_msg_count,
602: p_data => x_msg_data,
603: p_encoded => FND_API.G_FALSE);
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 607: FND_MSG_PUB.Count_And_Get

603: p_encoded => FND_API.G_FALSE);
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: ROLLBACK TO Delete_Map;
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: FND_MSG_PUB.Count_And_Get
608: (p_count => x_msg_count,
609: p_data => x_msg_data,
610: p_encoded => FND_API.G_FALSE);
611: WHEN OTHERS THEN

Line 614: IF FND_MSG_PUB.Check_Msg_Level

610: p_encoded => FND_API.G_FALSE);
611: WHEN OTHERS THEN
612: ROLLBACK TO Delete_Map;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
614: IF FND_MSG_PUB.Check_Msg_Level
615: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
616: FND_MSG_PUB.Add_Exc_Msg
617: (G_PKG_NAME,
618: l_api_name );

Line 615: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

611: WHEN OTHERS THEN
612: ROLLBACK TO Delete_Map;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
614: IF FND_MSG_PUB.Check_Msg_Level
615: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
616: FND_MSG_PUB.Add_Exc_Msg
617: (G_PKG_NAME,
618: l_api_name );
619: END IF;

Line 616: FND_MSG_PUB.Add_Exc_Msg

612: ROLLBACK TO Delete_Map;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
614: IF FND_MSG_PUB.Check_Msg_Level
615: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
616: FND_MSG_PUB.Add_Exc_Msg
617: (G_PKG_NAME,
618: l_api_name );
619: END IF;
620: FND_MSG_PUB.Count_And_Get

Line 620: FND_MSG_PUB.Count_And_Get

616: FND_MSG_PUB.Add_Exc_Msg
617: (G_PKG_NAME,
618: l_api_name );
619: END IF;
620: FND_MSG_PUB.Count_And_Get
621: (p_count => x_msg_count,
622: p_data => x_msg_data,
623: p_encoded => FND_API.G_FALSE);
624: END Delete_Map;

Line 681: FND_MSG_PUB.initialize;

677: END IF;
678:
679: -- Initialize message list if p_init_msg_list is set to TRUE.
680: IF FND_API.to_Boolean( p_init_msg_list ) THEN
681: FND_MSG_PUB.initialize;
682: END IF;
683:
684: -- Initialize API return status to success
685: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 700: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

696:
697: IF (l_ovn_obj_number <> p_object_version_number)
698: THEN
699:
700: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
701: THEN
702: fnd_message.set_name('CN', 'CL_INVALID_OVN');
703: fnd_msg_pub.add;
704: END IF;

Line 703: fnd_msg_pub.add;

699:
700: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
701: THEN
702: fnd_message.set_name('CN', 'CL_INVALID_OVN');
703: fnd_msg_pub.add;
704: END IF;
705:
706: RAISE FND_API.G_EXC_ERROR;
707:

Line 727: FND_MSG_PUB.Count_And_Get

723: OBJECT_VALUE = p_object_value
724: WHERE OBJECT_ID = p_object_id
725: AND org_id = l_org_id;
726:
727: FND_MSG_PUB.Count_And_Get
728: (p_count => x_msg_count ,
729: p_data => x_msg_data ,
730: p_encoded => FND_API.G_FALSE );
731: EXCEPTION

Line 735: FND_MSG_PUB.Count_And_Get(

731: EXCEPTION
732: WHEN FND_API.G_EXC_ERROR THEN
733: ROLLBACK TO update_trx_source_sv;
734: x_return_status := FND_API.G_RET_STS_ERROR ;
735: FND_MSG_PUB.Count_And_Get(
736: p_count => x_msg_count ,
737: p_data => x_msg_data ,
738: p_encoded => FND_API.G_FALSE);
739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 742: FND_MSG_PUB.Count_And_Get(

738: p_encoded => FND_API.G_FALSE);
739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
740: ROLLBACK TO update_trx_source_sv;
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
742: FND_MSG_PUB.Count_And_Get(
743: p_count => x_msg_count ,
744: p_data => x_msg_data ,
745: p_encoded => FND_API.G_FALSE);
746: WHEN OTHERS THEN

Line 749: IF FND_MSG_PUB.Check_Msg_Level(

745: p_encoded => FND_API.G_FALSE);
746: WHEN OTHERS THEN
747: ROLLBACK TO update_trx_source_sv;
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
749: IF FND_MSG_PUB.Check_Msg_Level(
750: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
751: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
752: END IF;
753: FND_MSG_PUB.Count_And_Get(

Line 750: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

746: WHEN OTHERS THEN
747: ROLLBACK TO update_trx_source_sv;
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
749: IF FND_MSG_PUB.Check_Msg_Level(
750: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
751: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
752: END IF;
753: FND_MSG_PUB.Count_And_Get(
754: p_count => x_msg_count ,

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

747: ROLLBACK TO update_trx_source_sv;
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
749: IF FND_MSG_PUB.Check_Msg_Level(
750: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
751: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
752: END IF;
753: FND_MSG_PUB.Count_And_Get(
754: p_count => x_msg_count ,
755: p_data => x_msg_data ,

Line 753: FND_MSG_PUB.Count_And_Get(

749: IF FND_MSG_PUB.Check_Msg_Level(
750: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
751: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
752: END IF;
753: FND_MSG_PUB.Count_And_Get(
754: p_count => x_msg_count ,
755: p_data => x_msg_data ,
756: p_encoded => FND_API.G_FALSE);
757:

Line 815: FND_MSG_PUB.initialize;

811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
812: END IF;
813: -- Initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean( p_init_msg_list ) THEN
815: FND_MSG_PUB.initialize;
816: END IF;
817: -- Initialize API return status to success
818: x_return_status := FND_API.G_RET_STS_SUCCESS;
819: -- API Body Begin

Line 830: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

826:
827:
828: if (l_object_version_number <> p_object_version_number) THEN
829:
830: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
831: THEN
832: fnd_message.set_name('CN', 'CL_INVALID_OVN');
833: fnd_msg_pub.add;
834: END IF;

Line 833: fnd_msg_pub.add;

829:
830: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
831: THEN
832: fnd_message.set_name('CN', 'CL_INVALID_OVN');
833: fnd_msg_pub.add;
834: END IF;
835: RAISE FND_API.G_EXC_ERROR;
836:
837: end if;

Line 882: FND_MSG_PUB.Count_And_Get

878: --IF FND_API.To_Boolean( p_commit ) THEN
879: -- COMMIT WORK;
880: --END IF;
881: -- Standard call to get message count and if count is 1, get message info.
882: FND_MSG_PUB.Count_And_Get
883: (p_count => x_msg_count ,
884: p_data => x_msg_data ,
885: p_encoded => FND_API.G_FALSE );
886: EXCEPTION

Line 890: FND_MSG_PUB.Count_And_Get(

886: EXCEPTION
887: WHEN FND_API.G_EXC_ERROR THEN
888: ROLLBACK TO update_trx_source_sv;
889: x_return_status := FND_API.G_RET_STS_ERROR ;
890: FND_MSG_PUB.Count_And_Get(
891: p_count => x_msg_count ,
892: p_data => x_msg_data ,
893: p_encoded => FND_API.G_FALSE);
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 897: FND_MSG_PUB.Count_And_Get(

893: p_encoded => FND_API.G_FALSE);
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
895: ROLLBACK TO update_trx_source_sv;
896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
897: FND_MSG_PUB.Count_And_Get(
898: p_count => x_msg_count ,
899: p_data => x_msg_data ,
900: p_encoded => FND_API.G_FALSE);
901: WHEN OTHERS THEN

Line 904: IF FND_MSG_PUB.Check_Msg_Level(

900: p_encoded => FND_API.G_FALSE);
901: WHEN OTHERS THEN
902: ROLLBACK TO update_trx_source_sv;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
904: IF FND_MSG_PUB.Check_Msg_Level(
905: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
906: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
907: END IF;
908: FND_MSG_PUB.Count_And_Get(

Line 905: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

901: WHEN OTHERS THEN
902: ROLLBACK TO update_trx_source_sv;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
904: IF FND_MSG_PUB.Check_Msg_Level(
905: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
906: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
907: END IF;
908: FND_MSG_PUB.Count_And_Get(
909: p_count => x_msg_count ,

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

902: ROLLBACK TO update_trx_source_sv;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
904: IF FND_MSG_PUB.Check_Msg_Level(
905: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
906: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
907: END IF;
908: FND_MSG_PUB.Count_And_Get(
909: p_count => x_msg_count ,
910: p_data => x_msg_data ,

Line 908: FND_MSG_PUB.Count_And_Get(

904: IF FND_MSG_PUB.Check_Msg_Level(
905: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
906: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
907: END IF;
908: FND_MSG_PUB.Count_And_Get(
909: p_count => x_msg_count ,
910: p_data => x_msg_data ,
911: p_encoded => FND_API.G_FALSE);
912: END Update_Map;

Line 960: FND_MSG_PUB.initialize;

956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
957: END IF;
958: -- Initialize message list if p_init_msg_list is set to TRUE.
959: IF FND_API.to_Boolean( p_init_msg_list ) THEN
960: FND_MSG_PUB.initialize;
961: END IF;
962: -- Initialize API return status to success
963: x_return_status := FND_API.G_RET_STS_SUCCESS;
964:

Line 1018: FND_MSG_PUB.Count_And_Get

1014: --IF FND_API.To_Boolean( p_commit ) THEN
1015: -- COMMIT WORK;
1016: --END IF;
1017: -- Standard call to get message count and if count is 1, get message info.
1018: FND_MSG_PUB.Count_And_Get
1019: (p_count => x_msg_count ,
1020: p_data => x_msg_data ,
1021: p_encoded => FND_API.G_FALSE);
1022: EXCEPTION

Line 1026: FND_MSG_PUB.Count_And_Get

1022: EXCEPTION
1023: WHEN FND_API.G_EXC_ERROR THEN
1024: ROLLBACK TO Create_Table_Map_Object;
1025: x_return_status := FND_API.G_RET_STS_ERROR ;
1026: FND_MSG_PUB.Count_And_Get
1027: (p_count => x_msg_count,
1028: p_data => x_msg_data,
1029: p_encoded => FND_API.G_FALSE);
1030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1033: FND_MSG_PUB.Count_And_Get

1029: p_encoded => FND_API.G_FALSE);
1030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1031: ROLLBACK TO Create_Table_Map_Object;
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1033: FND_MSG_PUB.Count_And_Get
1034: (p_count => x_msg_count,
1035: p_data => x_msg_data,
1036: p_encoded => FND_API.G_FALSE);
1037: WHEN OTHERS THEN

Line 1040: IF FND_MSG_PUB.Check_Msg_Level

1036: p_encoded => FND_API.G_FALSE);
1037: WHEN OTHERS THEN
1038: ROLLBACK TO Create_Table_Map_Object;
1039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1040: IF FND_MSG_PUB.Check_Msg_Level
1041: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1042: FND_MSG_PUB.Add_Exc_Msg
1043: (G_PKG_NAME,
1044: l_api_name );

Line 1041: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1037: WHEN OTHERS THEN
1038: ROLLBACK TO Create_Table_Map_Object;
1039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1040: IF FND_MSG_PUB.Check_Msg_Level
1041: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1042: FND_MSG_PUB.Add_Exc_Msg
1043: (G_PKG_NAME,
1044: l_api_name );
1045: END IF;

Line 1042: FND_MSG_PUB.Add_Exc_Msg

1038: ROLLBACK TO Create_Table_Map_Object;
1039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1040: IF FND_MSG_PUB.Check_Msg_Level
1041: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1042: FND_MSG_PUB.Add_Exc_Msg
1043: (G_PKG_NAME,
1044: l_api_name );
1045: END IF;
1046: FND_MSG_PUB.Count_And_Get

Line 1046: FND_MSG_PUB.Count_And_Get

1042: FND_MSG_PUB.Add_Exc_Msg
1043: (G_PKG_NAME,
1044: l_api_name );
1045: END IF;
1046: FND_MSG_PUB.Count_And_Get
1047: (p_count => x_msg_count,
1048: p_data => x_msg_data,
1049: p_encoded => FND_API.G_FALSE);
1050: END Create_Table_Map_Object;

Line 1095: FND_MSG_PUB.initialize;

1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: END IF;
1093: -- Initialize message list if p_init_msg_list is set to TRUE.
1094: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1095: FND_MSG_PUB.initialize;
1096: END IF;
1097: -- Initialize API return status to success
1098: x_return_status := FND_API.G_RET_STS_SUCCESS;
1099: -------------------+

Line 1123: FND_MSG_PUB.Count_And_Get

1119: --IF FND_API.To_Boolean( p_commit ) THEN
1120: -- COMMIT WORK;
1121: --END IF;
1122: -- Standard call to get message count and if count is 1, get message info.
1123: FND_MSG_PUB.Count_And_Get
1124: (p_count => x_msg_count ,
1125: p_data => x_msg_data ,
1126: p_encoded => FND_API.G_FALSE);
1127: EXCEPTION

Line 1131: FND_MSG_PUB.Count_And_Get

1127: EXCEPTION
1128: WHEN FND_API.G_EXC_ERROR THEN
1129: ROLLBACK TO Delete_Table_Map_Object;
1130: x_return_status := FND_API.G_RET_STS_ERROR ;
1131: FND_MSG_PUB.Count_And_Get
1132: (p_count => x_msg_count,
1133: p_data => x_msg_data,
1134: p_encoded => FND_API.G_FALSE);
1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1138: FND_MSG_PUB.Count_And_Get

1134: p_encoded => FND_API.G_FALSE);
1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1136: ROLLBACK TO Delete_Table_Map_Object;
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1138: FND_MSG_PUB.Count_And_Get
1139: (p_count => x_msg_count,
1140: p_data => x_msg_data,
1141: p_encoded => FND_API.G_FALSE);
1142: WHEN OTHERS THEN

Line 1145: IF FND_MSG_PUB.Check_Msg_Level

1141: p_encoded => FND_API.G_FALSE);
1142: WHEN OTHERS THEN
1143: ROLLBACK TO Delete_Table_Map_Object;
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: IF FND_MSG_PUB.Check_Msg_Level
1146: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1147: FND_MSG_PUB.Add_Exc_Msg
1148: (G_PKG_NAME,
1149: l_api_name );

Line 1146: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1142: WHEN OTHERS THEN
1143: ROLLBACK TO Delete_Table_Map_Object;
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: IF FND_MSG_PUB.Check_Msg_Level
1146: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1147: FND_MSG_PUB.Add_Exc_Msg
1148: (G_PKG_NAME,
1149: l_api_name );
1150: END IF;

Line 1147: FND_MSG_PUB.Add_Exc_Msg

1143: ROLLBACK TO Delete_Table_Map_Object;
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: IF FND_MSG_PUB.Check_Msg_Level
1146: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1147: FND_MSG_PUB.Add_Exc_Msg
1148: (G_PKG_NAME,
1149: l_api_name );
1150: END IF;
1151: FND_MSG_PUB.Count_And_Get

Line 1151: FND_MSG_PUB.Count_And_Get

1147: FND_MSG_PUB.Add_Exc_Msg
1148: (G_PKG_NAME,
1149: l_api_name );
1150: END IF;
1151: FND_MSG_PUB.Count_And_Get
1152: (p_count => x_msg_count,
1153: p_data => x_msg_data,
1154: p_encoded => FND_API.G_FALSE);
1155: END Delete_Table_Map_Object;

Line 1208: FND_MSG_PUB.initialize;

1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: END IF;
1206: -- Initialize message list if p_init_msg_list is set to TRUE.
1207: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1208: FND_MSG_PUB.initialize;
1209: END IF;
1210: -- Initialize API return status to success
1211: x_return_status := FND_API.G_RET_STS_SUCCESS;
1212: -------------------+

Line 1290: FND_MSG_PUB.Count_And_Get

1286: IF FND_API.To_Boolean( p_commit ) THEN
1287: COMMIT WORK;
1288: END IF;
1289: -- Standard call to get message count and if count is 1, get message info.
1290: FND_MSG_PUB.Count_And_Get
1291: (p_count => x_msg_count ,
1292: p_data => x_msg_data ,
1293: p_encoded => FND_API.G_FALSE);
1294: EXCEPTION

Line 1298: FND_MSG_PUB.Count_And_Get

1294: EXCEPTION
1295: WHEN FND_API.G_EXC_ERROR THEN
1296: ROLLBACK TO Get_SQL_Clauses;
1297: x_return_status := FND_API.G_RET_STS_ERROR ;
1298: FND_MSG_PUB.Count_And_Get
1299: (p_count => x_msg_count,
1300: p_data => x_msg_data,
1301: p_encoded => FND_API.G_FALSE);
1302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1305: FND_MSG_PUB.Count_And_Get

1301: p_encoded => FND_API.G_FALSE);
1302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1303: ROLLBACK TO Get_SQL_Clauses;
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1305: FND_MSG_PUB.Count_And_Get
1306: (p_count => x_msg_count,
1307: p_data => x_msg_data,
1308: p_encoded => FND_API.G_FALSE);
1309: WHEN OTHERS THEN

Line 1312: IF FND_MSG_PUB.Check_Msg_Level

1308: p_encoded => FND_API.G_FALSE);
1309: WHEN OTHERS THEN
1310: ROLLBACK TO Get_SQL_Clauses;
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1312: IF FND_MSG_PUB.Check_Msg_Level
1313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1314: FND_MSG_PUB.Add_Exc_Msg
1315: (G_PKG_NAME,
1316: l_api_name );

Line 1313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1309: WHEN OTHERS THEN
1310: ROLLBACK TO Get_SQL_Clauses;
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1312: IF FND_MSG_PUB.Check_Msg_Level
1313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1314: FND_MSG_PUB.Add_Exc_Msg
1315: (G_PKG_NAME,
1316: l_api_name );
1317: END IF;

Line 1314: FND_MSG_PUB.Add_Exc_Msg

1310: ROLLBACK TO Get_SQL_Clauses;
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1312: IF FND_MSG_PUB.Check_Msg_Level
1313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1314: FND_MSG_PUB.Add_Exc_Msg
1315: (G_PKG_NAME,
1316: l_api_name );
1317: END IF;
1318: FND_MSG_PUB.Count_And_Get

Line 1318: FND_MSG_PUB.Count_And_Get

1314: FND_MSG_PUB.Add_Exc_Msg
1315: (G_PKG_NAME,
1316: l_api_name );
1317: END IF;
1318: FND_MSG_PUB.Count_And_Get
1319: (p_count => x_msg_count,
1320: p_data => x_msg_data,
1321: p_encoded => FND_API.G_FALSE);
1322: END Get_SQL_Clauses;