APPS.HZ_IMP_DNB_POSTPROC_PKG dependencies on FND_MSG_PUB

Line 158: FND_MSG_PUB.Reset;

154: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Expected Error Occured');
155: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------------------');
156: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
157: FND_FILE.PUT_LINE(FND_FILE.LOG, 'batchid:'||p_batchid);
158: FND_MSG_PUB.Reset;
159: --FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
160: FOR i IN 1..l_msg_count LOOP
161: --l_error_message := FND_MESSAGE.get;
162: l_error_message := FND_MSG_PUB.Get(

Line 159: --FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

155: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------------------');
156: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
157: FND_FILE.PUT_LINE(FND_FILE.LOG, 'batchid:'||p_batchid);
158: FND_MSG_PUB.Reset;
159: --FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
160: FOR i IN 1..l_msg_count LOOP
161: --l_error_message := FND_MESSAGE.get;
162: l_error_message := FND_MSG_PUB.Get(
163: p_msg_index => i,

Line 162: l_error_message := FND_MSG_PUB.Get(

158: FND_MSG_PUB.Reset;
159: --FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
160: FOR i IN 1..l_msg_count LOOP
161: --l_error_message := FND_MESSAGE.get;
162: l_error_message := FND_MSG_PUB.Get(
163: p_msg_index => i,
164: p_encoded => FND_API.G_FALSE);
165: errbuf := l_error_message;
166: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_message);

Line 176: FND_MSG_PUB.Reset;

172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UnExpected Error Occured');
173: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------------------');
174: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'batchid:'||p_batchid);
176: FND_MSG_PUB.Reset;
177: --FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
178: FOR i IN 1..l_msg_count LOOP
179: --l_error_message := FND_MESSAGE.get;
180: l_error_message := FND_MSG_PUB.Get(

Line 177: --FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

173: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------------------');
174: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'batchid:'||p_batchid);
176: FND_MSG_PUB.Reset;
177: --FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
178: FOR i IN 1..l_msg_count LOOP
179: --l_error_message := FND_MESSAGE.get;
180: l_error_message := FND_MSG_PUB.Get(
181: p_msg_index => i,

Line 180: l_error_message := FND_MSG_PUB.Get(

176: FND_MSG_PUB.Reset;
177: --FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
178: FOR i IN 1..l_msg_count LOOP
179: --l_error_message := FND_MESSAGE.get;
180: l_error_message := FND_MSG_PUB.Get(
181: p_msg_index => i,
182: p_encoded => FND_API.G_FALSE);
183: errbuf := l_error_message;
184: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_message);

Line 194: FND_MSG_PUB.Reset;

190: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
191: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SQLERRM: ' || SQLERRM);
193: FND_FILE.PUT_LINE(FND_FILE.LOG, 'batchid:'||p_batchid);
194: FND_MSG_PUB.Reset;
195: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
196: l_error_message := FND_MSG_PUB.Get(
197: p_msg_index => i,
198: p_encoded => FND_API.G_FALSE);

Line 195: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

191: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SQLERRM: ' || SQLERRM);
193: FND_FILE.PUT_LINE(FND_FILE.LOG, 'batchid:'||p_batchid);
194: FND_MSG_PUB.Reset;
195: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
196: l_error_message := FND_MSG_PUB.Get(
197: p_msg_index => i,
198: p_encoded => FND_API.G_FALSE);
199: errbuf := l_error_message;

Line 196: l_error_message := FND_MSG_PUB.Get(

192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SQLERRM: ' || SQLERRM);
193: FND_FILE.PUT_LINE(FND_FILE.LOG, 'batchid:'||p_batchid);
194: FND_MSG_PUB.Reset;
195: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
196: l_error_message := FND_MSG_PUB.Get(
197: p_msg_index => i,
198: p_encoded => FND_API.G_FALSE);
199: errbuf := l_error_message;
200: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_message);