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

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

131:
132:
133: If Check_For_Valid_Batches(v_Batch_Name,v_business_group_id,v_set_of_books_id) <> 0 Then
134: l_error_api_name := 'INVALID BATCH';
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: End If;
137:
138:
139: -- ENH. fix 2916848

Line 151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

147: -- End of bug fix 3107800
148:
149: IF Check_for_valid_currency(v_batch_name,v_business_group_id,v_set_of_books_id) <> 0 Then
150: l_error_api_name := 'INVALID_CURRENCY';
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END IF;
153:
154:
155: l_currency_code := Get_Currency_For_Batch(v_batch_name,v_business_group_id,v_set_of_books_id);

Line 168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

164: If Perform_Validations(v_Batch_Name,v_business_group_id,v_set_of_books_id,l_precision,
165: l_ext_precision,l_currency_code) <> 0 Then
166: -- dbms_output.put_line('Errors occured during validation');
167: l_error_api_name := 'PERFORM VALIDATIONS';
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: End If;
170: -- Now, perform the IMPORT
171: -- Introduced l_precision,l_ext_precision l_currency_code variables for Bug 2916848
172:

Line 177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

173: If Perform_Import(v_Batch_Name,v_business_group_id,v_set_of_books_id,
174: l_precision,l_ext_precision,l_currency_code) <> 0 Then
175: -- dbms_output.put_line('Errors occured during Import process');
176: l_error_api_name := 'IMPORT PROCESS';
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: End If;
179: -- COMMIT;
180:
181: /* commit commented out to allow proper rollback in the event that problem occurs during change to_transfer

Line 188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

184: -- Finally, change the statuses of all records in this batch to TRANSFER
185: If Change_To_Transfer(v_Batch_Name) <> 0 Then
186: -- dbms_output.put_line('Unable to change the statuses of all records to TRANSFER');
187: l_error_api_name := 'CHANGE TO TRANSFER STATUS';
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: End If;
190:
191: COMMIT;
192: retCode := 0;

Line 202: when FND_API.G_EXC_UNEXPECTED_ERROR Then

198: l_dist_message := fnd_message.get;
199: errbuf := l_error_api_name || fnd_global.local_chr(10) || l_dist_message;
200: retcode:= 2;
201: -- End of Enh. fix 2094036
202: when FND_API.G_EXC_UNEXPECTED_ERROR Then
203: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
204: p_encoded => FND_API.G_FALSE,
205: p_data => l_msg_data,
206: p_msg_index_out => l_msg_count);

Line 204: p_encoded => FND_API.G_FALSE,

200: retcode:= 2;
201: -- End of Enh. fix 2094036
202: when FND_API.G_EXC_UNEXPECTED_ERROR Then
203: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
204: p_encoded => FND_API.G_FALSE,
205: p_data => l_msg_data,
206: p_msg_index_out => l_msg_count);
207: fnd_message.set_name('PSP','PSP_PI_IMPORT_GENERAL');
208: fnd_message.set_token('PROCEDURE_NAME',l_error_api_name);

Line 219: p_encoded => FND_API.G_FALSE,

215: when others then
216: -- dbms_output.put_line('Unknown Error ' || sqlerrm);
217: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA',l_error_api_name);
218: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
219: p_encoded => FND_API.G_FALSE,
220: p_data => l_msg_data,
221: p_msg_index_out => l_msg_count);
222: fnd_message.set_name('PSP','PSP_PI_IMPORT_GENERAL');
223: fnd_message.set_token('PROCEDURE_NAME',l_error_api_name);

Line 482: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

478: v_precision,v_ext_precision);
479: -- Introduced v_precision,v_ext_precision for import_payroll_lines call for bug 2916848
480:
481: If retVal <> 0 Then
482: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
483: Else
484: -- dbms_output.put_line('Import to Payroll Controls table done completely');
485: return 0;
486: End If;

Line 488: when FND_API.G_EXC_UNEXPECTED_ERROR Then

484: -- dbms_output.put_line('Import to Payroll Controls table done completely');
485: return 0;
486: End If;
487: EXCEPTION
488: when FND_API.G_EXC_UNEXPECTED_ERROR Then
489: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA','IMPORT_PERFORM_IMPORT');
490: return 3;
491: when OTHERS Then
492: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA','IMPORT_PERFORM_IMPORT');

Line 717: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

713: n_Payroll_Lines_ID, Lines_Record_Agg.Sub_Line_Start_Date,
714: Lines_Record_Agg.Sub_Line_End_Date,v_precision,v_ext_precision,
715: v_business_group_id); -- Introduced BG for bug 2908859
716: If retVal <> 0 Then
717: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
718: End If;
719: END LOOP;
720: return 0;
721: EXCEPTION

Line 722: when FND_API.G_EXC_UNEXPECTED_ERROR Then

718: End If;
719: END LOOP;
720: return 0;
721: EXCEPTION
722: when FND_API.G_EXC_UNEXPECTED_ERROR Then
723: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA', 'IMPORT_PAYROLL_LINES');
724: return 3;
725: when others then
726: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA', 'IMPORT_PAYROLL_LINES');

Line 827: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

823: l_attribute1, l_attribute2, l_attribute3, l_attribute4, l_attribute5,
824: l_attribute6, l_attribute7, l_attribute8, l_attribute9, l_attribute10);
825: if retVal <> 0 Then
826: -- dbms_output.put_line('Error occured while inserting sub-line');
827: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
828: else
829: -- dbms_output.put_line('Successfully imported Payroll Sub Line');
830: null;
831: end if;

Line 835: when FND_API.G_EXC_UNEXPECTED_ERROR Then

831: end if;
832: END LOOP;
833: return 0;
834: EXCEPTION
835: when FND_API.G_EXC_UNEXPECTED_ERROR Then
836: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA', 'PROCESS_PAYROLL_SUB_LINES');
837: return 3;
838: when others then
839: -- dbms_output.put_line('Error occured while processing sub-lines. Error Message' ||