DBA Data[Home] [Help]

APPS.AMS_GEN_SUP_LIST_PVT dependencies on FND_FILE

Line 48: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Suppression List Generation ');

44: AND STATUS_CODE NOT IN('ARCHIVED','CANCELLED');
45:
46: BEGIN
47:
48: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Suppression List Generation ');
49:
50: OPEN c_sup_list;
51: LOOP
52: FETCH c_sup_list INTO l_list_header_id,l_list_name ;

Line 55: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Suppression list Header Id : '||l_list_header_id );

51: LOOP
52: FETCH c_sup_list INTO l_list_header_id,l_list_name ;
53: EXIT WHEN c_sup_list%NOTFOUND;
54:
55: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Suppression list Header Id : '||l_list_header_id );
56: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Suppression list Header Name : '||l_list_name );
57:
58: errbuf:= 'Suppression List Generation';
59: retcode:=0;

Line 56: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Suppression list Header Name : '||l_list_name );

52: FETCH c_sup_list INTO l_list_header_id,l_list_name ;
53: EXIT WHEN c_sup_list%NOTFOUND;
54:
55: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Suppression list Header Id : '||l_list_header_id );
56: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Suppression list Header Name : '||l_list_name );
57:
58: errbuf:= 'Suppression List Generation';
59: retcode:=0;
60:

Line 78: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION in list gen package: AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');

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;
81: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
82: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);

Line 83: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : AMS_Gen_Sup_List_PVT.Schedule_Suppression_List '|| l_msg_data);

79:
80: l_msg_count := FND_MSG_PUB.count_msg;
81: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
82: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);
83: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : AMS_Gen_Sup_List_PVT.Schedule_Suppression_List '|| l_msg_data);
84: END LOOP;
85:
86: -- clear message buffer
87: l_return_status := FND_API.g_ret_sts_success ;

Line 95: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Suppression List Generation ');

91: END LOOP;
92: CLOSE c_sup_list;
93:
94:
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');

Line 102: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION in list gen package: AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');

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;
105: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
106: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);

Line 107: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : AMS_Gen_Sup_List_PVT.Schedule_Suppression_List '|| l_msg_data);

103:
104: l_msg_count := FND_MSG_PUB.count_msg;
105: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
106: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);
107: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : AMS_Gen_Sup_List_PVT.Schedule_Suppression_List '|| l_msg_data);
108: END LOOP;
109:
110: -- clear message buffer
111: FND_MSG_PUB.initialize;

Line 113: WHEN FND_FILE.UTL_FILE_ERROR THEN

109:
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

Line 118: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');

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 ');
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');

Line 119: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);

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 ');
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);