APPS.AMS_GEN_SUP_LIST_PVT dependencies on FND_MESSAGE

Line 75: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

71:
72: );
73:
74: IF l_return_status <> FND_API.g_ret_sts_success THEN
75: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
76: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
77: FND_MSG_PUB.Add;
78: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION in list gen package: AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');
79:

Line 76: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);

72: );
73:
74: IF l_return_status <> FND_API.g_ret_sts_success THEN
75: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
76: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
77: FND_MSG_PUB.Add;
78: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION in list gen package: AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');
79:
80: l_msg_count := FND_MSG_PUB.count_msg;

Line 99: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

95: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Suppression List Generation ');
96:
97: EXCEPTION
98: WHEN FND_API.G_EXC_ERROR THEN
99: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
100: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
101: FND_MSG_PUB.Add;
102: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION in list gen package: AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');
103:

Line 100: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);

96:
97: EXCEPTION
98: WHEN FND_API.G_EXC_ERROR THEN
99: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
100: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
101: FND_MSG_PUB.Add;
102: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION in list gen package: AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');
103:
104: l_msg_count := FND_MSG_PUB.count_msg;

Line 114: errbuf:= substr(FND_MESSAGE.get,1,254);

110: -- clear message buffer
111: FND_MSG_PUB.initialize;
112:
113: WHEN FND_FILE.UTL_FILE_ERROR THEN
114: errbuf:= substr(FND_MESSAGE.get,1,254);
115: retcode:=2;
116:
117: WHEN OTHERS THEN
118: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');

Line 122: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

118: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');
119: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
120: errbuf:= substr(SQLERRM,1,254);
121: retcode:=SQLCODE;
122: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
123: FND_MESSAGE.Set_Token('ROW','Error in Suppression List Generation ' || SQLERRM||' '||SQLCODE);
124:
125:
126: END Schedule_Suppression_List;

Line 123: FND_MESSAGE.Set_Token('ROW','Error in Suppression List Generation ' || SQLERRM||' '||SQLCODE);

119: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
120: errbuf:= substr(SQLERRM,1,254);
121: retcode:=SQLCODE;
122: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
123: FND_MESSAGE.Set_Token('ROW','Error in Suppression List Generation ' || SQLERRM||' '||SQLCODE);
124:
125:
126: END Schedule_Suppression_List;
127: