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.HZ_IMP_DNB_POSTPROC_PKG dependencies on FND_API

Line 44: RAISE FND_API.G_EXC_ERROR;

40: RETURN l_return_status;
41: EXCEPTION
42: WHEN UTL_FILE.invalid_path THEN
43: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UTL_FILE.FOPEN - invalid path');
44: RAISE FND_API.G_EXC_ERROR;
45: WHEN UTL_FILE.invalid_mode THEN
46: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UTL_FILE.FOPEN - invalid mode');
47: RAISE FND_API.G_EXC_ERROR;
48: WHEN UTL_FILE.invalid_operation THEN

Line 47: RAISE FND_API.G_EXC_ERROR;

43: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UTL_FILE.FOPEN - invalid path');
44: RAISE FND_API.G_EXC_ERROR;
45: WHEN UTL_FILE.invalid_mode THEN
46: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UTL_FILE.FOPEN - invalid mode');
47: RAISE FND_API.G_EXC_ERROR;
48: WHEN UTL_FILE.invalid_operation THEN
49: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UTL_FILE.FOPEN - invalid operation');
50: -- this only means that file did not even get created
51: -- that is, all the records were successfull

Line 56: RAISE FND_API.G_EXC_ERROR;

52: l_return_status := FALSE;
53: RETURN l_return_status;
54: WHEN UTL_FILE.invalid_maxlinesize THEN
55: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UTL_FILE.FOPEN - invalid max line size');
56: RAISE FND_API.G_EXC_ERROR;
57: WHEN others THEN
58: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END file_populated;

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UTL_FILE.FOPEN - invalid max line size');
56: RAISE FND_API.G_EXC_ERROR;
57: WHEN others THEN
58: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END file_populated;
61:
62:
63: PROCEDURE POST_PROCESSING (

Line 92: l_return_status := FND_API.G_RET_STS_SUCCESS;

88: --Standard start of API savepoint
89: SAVEPOINT dnb_adapter_pp;
90:
91: --Initialize API return status to success.
92: l_return_status := FND_API.G_RET_STS_SUCCESS;
93: retcode := 0;
94:
95: FND_FILE.PUT_LINE(FND_FILE.LOG, ' bfr calling api batchid:'||p_batchid);
96:

Line 102: p_init_msg_list => FND_API.G_TRUE,

98: l_tmp := to_number(p_batchid);
99:
100: -- 2. Call batch activate api.
101: HZ_IMP_BATCH_SUMMARY_V2PUB.activate_batch (
102: p_init_msg_list => FND_API.G_TRUE,
103: p_batch_id => p_batchid,
104: x_return_status => l_return_status,
105: x_msg_count => l_msg_count,
106: x_msg_data => l_error_message);

Line 111: WHEN FND_API.G_RET_STS_ERROR THEN

107:
108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'batch sumry api ret status:'||l_return_status);
109:
110: CASE l_return_status
111: WHEN FND_API.G_RET_STS_ERROR THEN
112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'HZ_IMP_BATCH_SUMMARY_V2PUB.activate_batch errored');
113: RAISE FND_API.G_EXC_ERROR;
114: WHEN FND_API.G_RET_STS_UNEXP_ERROR THEN
115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'HZ_IMP_BATCH_SUMMARY_V2PUB.activate_batch errored unexpectedly');

Line 113: RAISE FND_API.G_EXC_ERROR;

109:
110: CASE l_return_status
111: WHEN FND_API.G_RET_STS_ERROR THEN
112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'HZ_IMP_BATCH_SUMMARY_V2PUB.activate_batch errored');
113: RAISE FND_API.G_EXC_ERROR;
114: WHEN FND_API.G_RET_STS_UNEXP_ERROR THEN
115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'HZ_IMP_BATCH_SUMMARY_V2PUB.activate_batch errored unexpectedly');
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: WHEN FND_API.G_RET_STS_SUCCESS THEN

Line 114: WHEN FND_API.G_RET_STS_UNEXP_ERROR THEN

110: CASE l_return_status
111: WHEN FND_API.G_RET_STS_ERROR THEN
112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'HZ_IMP_BATCH_SUMMARY_V2PUB.activate_batch errored');
113: RAISE FND_API.G_EXC_ERROR;
114: WHEN FND_API.G_RET_STS_UNEXP_ERROR THEN
115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'HZ_IMP_BATCH_SUMMARY_V2PUB.activate_batch errored unexpectedly');
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: WHEN FND_API.G_RET_STS_SUCCESS THEN
118: retcode := 0;

Line 116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'HZ_IMP_BATCH_SUMMARY_V2PUB.activate_batch errored');
113: RAISE FND_API.G_EXC_ERROR;
114: WHEN FND_API.G_RET_STS_UNEXP_ERROR THEN
115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'HZ_IMP_BATCH_SUMMARY_V2PUB.activate_batch errored unexpectedly');
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: WHEN FND_API.G_RET_STS_SUCCESS THEN
118: retcode := 0;
119: -- check to see if the user has any bad data in bad file.
120: BEGIN

Line 117: WHEN FND_API.G_RET_STS_SUCCESS THEN

113: RAISE FND_API.G_EXC_ERROR;
114: WHEN FND_API.G_RET_STS_UNEXP_ERROR THEN
115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'HZ_IMP_BATCH_SUMMARY_V2PUB.activate_batch errored unexpectedly');
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: WHEN FND_API.G_RET_STS_SUCCESS THEN
118: retcode := 0;
119: -- check to see if the user has any bad data in bad file.
120: BEGIN
121: SELECT ARGUMENT1, ARGUMENT4 --, ARGUMENT5

Line 151: WHEN FND_API.G_EXC_ERROR THEN

147: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch Id is NULL.Pass a valid batch id');
148: end if;
149:
150: EXCEPTION
151: WHEN FND_API.G_EXC_ERROR THEN
152: ROLLBACK TO dnb_adapter_pp;
153: retcode := 1;
154: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Expected Error Occured');
155: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------------------');

Line 164: p_encoded => FND_API.G_FALSE);

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);
167: END LOOP;
168: FND_FILE.close;

Line 169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

165: errbuf := l_error_message;
166: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_message);
167: END LOOP;
168: FND_FILE.close;
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: ROLLBACK TO dnb_adapter_pp;
171: retcode := 2;
172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UnExpected Error Occured');
173: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------------------');

Line 182: p_encoded => FND_API.G_FALSE);

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);
185: END LOOP;
186: FND_FILE.close;

Line 198: p_encoded => FND_API.G_FALSE);

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);
201: END LOOP;
202: FND_FILE.close;