DBA Data[Home] [Help]

APPS.IGS_EN_NSC_PKG dependencies on FND_MSG_PUB

Line 557: FND_MSG_PUB.Add;

553: IF (g_debug_mode) THEN
554: Put_Debug_Msg('NSC condition error');
555: END IF;
556: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_NSC_NO_STUDENTS');
557: FND_MSG_PUB.Add;
558: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
559: RAISE FND_API.G_EXC_ERROR;
560: END IF;
561: l_student_data.student_id:=NULL;

Line 786: --FND_MSG_PUB.Add;

782: Put_Debug_Msg('Raising exception NO_STUDENTS_FOUND');
783: END IF;
784:
785: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_NSC_NO_STUDENTS');
786: --FND_MSG_PUB.Add;
787: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
788: RAISE FND_API.G_EXC_ERROR;
789:
790: END IF;

Line 818: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

814: x_rowid => l_rowid
815: );
816:
817: end if;
818: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
819: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
820: END IF;
821: COMMIT;
822: Put_Debug_Msg('returning false');

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

815: );
816:
817: end if;
818: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
819: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
820: END IF;
821: COMMIT;
822: Put_Debug_Msg('returning false');
823: RETURN FALSE;

Line 829: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

825: EXCEPTION
826: WHEN OTHERS THEN
827: ROLLBACK TO DELETE_SNAPSHOT;
828: Put_Debug_Msg('ERROR while deleting snapshot id ' ||l_snapshot_id);
829: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
830: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
831: END IF;
832: RETURN FALSE;
833: END;

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

826: WHEN OTHERS THEN
827: ROLLBACK TO DELETE_SNAPSHOT;
828: Put_Debug_Msg('ERROR while deleting snapshot id ' ||l_snapshot_id);
829: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
830: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
831: END IF;
832: RETURN FALSE;
833: END;
834: END;

Line 880: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

876:
877: WHEN OTHERS THEN
878: ROLLBACK TO Print_Snapshot;
879: Put_Debug_Msg('OTHERS'||sqlerrm);
880: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
881: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
882: END IF;
883:
884: RETURN FALSE;

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

877: WHEN OTHERS THEN
878: ROLLBACK TO Print_Snapshot;
879: Put_Debug_Msg('OTHERS'||sqlerrm);
880: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
881: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
882: END IF;
883:
884: RETURN FALSE;
885:

Line 953: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

949: WHEN OTHERS THEN
950:
951: retcode := 2;
952:
953: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
954: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
955: END IF;
956:
957: Generate_Message;

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

950:
951: retcode := 2;
952:
953: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
954: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
955: END IF;
956:
957: Generate_Message;
958:

Line 1027: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

1023: WHEN OTHERS THEN
1024:
1025: retcode := 2;
1026:
1027: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1028: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1029: END IF;
1030:
1031: Generate_Message;

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

1024:
1025: retcode := 2;
1026:
1027: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1028: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1029: END IF;
1030:
1031: Generate_Message;
1032:

Line 1093: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

1089: WHEN OTHERS THEN
1090:
1091: retcode := 2;
1092:
1093: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1094: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1095: END IF;
1096:
1097: Generate_Message;

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

1090:
1091: retcode := 2;
1092:
1093: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1094: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1095: END IF;
1096:
1097: Generate_Message;
1098:

Line 1110: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

1106: l_msg_data VARCHAR2(2000);
1107:
1108: BEGIN
1109:
1110: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
1111: p_data => l_msg_data );
1112:
1113: IF (l_msg_count > 0) THEN
1114: l_msg_data := '';

Line 1116: l_msg_data := FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

1112:
1113: IF (l_msg_count > 0) THEN
1114: l_msg_data := '';
1115: FOR l_cur IN 1..l_msg_count LOOP
1116: l_msg_data := FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
1117: put_debug_msg(l_msg_data);
1118: fnd_file.put_line (FND_FILE.LOG, l_msg_data);
1119: END LOOP;
1120: ELSE