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 PSP_PI_IMPORT_DATA

Line 1: PACKAGE BODY PSP_PI_IMPORT_DATA AS

1: PACKAGE BODY PSP_PI_IMPORT_DATA AS
2: /* $Header: PSPPII2B.pls 120.3 2006/10/19 05:45:11 dpaudel noship $ */
3: /*********************************************************************************************
4: This package has been created for concurrent processing. This contains parameters
5: for errbuf and retCode. This has been modified on 05/08/98 by Al Arunachalam

Line 217: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA',l_error_api_name);

213:
214:
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);

Line 251: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA', 'Change_To_Transfer');

247: return 0;
248: Exception
249: when others then
250:
251: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA', 'Change_To_Transfer');
252: return 2;
253: End Change_To_Transfer;
254: /*******************************Perform_Validations***************************************
255: OBJ: This is a private procedure (called internally, from Import_Records). This

Line 489: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA','IMPORT_PERFORM_IMPORT');

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');
493: return 2;

Line 492: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA','IMPORT_PERFORM_IMPORT');

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');
493: return 2;
494: End Perform_Import;
495: /*****************************Import_Payroll_Lines***************************************
496: OBJ: This is a private procedure (called internally, from Perform_Import). This procedure

Line 723: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA', 'IMPORT_PAYROLL_LINES');

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');
727: return 2;

Line 726: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA', 'IMPORT_PAYROLL_LINES');

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');
727: return 2;
728: End Import_Payroll_Lines;
729: /*****************************Process_Payroll_Sub_Lines************************************
730: OBJ: This is a private procedure (called internally, from Import_Payroll_Lines). This procedure

Line 836: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA', 'PROCESS_PAYROLL_SUB_LINES');

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' ||
840: -- sqlerrm);

Line 841: 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' ||
840: -- sqlerrm);
841: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA', 'PROCESS_PAYROLL_SUB_LINES');
842: return 2;
843: END Process_Payroll_Sub_Lines;
844:
845: Function Import_Payroll_Sub_Lines(v_RowID IN OUT NOCOPY varchar2, n_Payroll_Sub_Lines_ID number,

Line 905: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA', 'IMPORT_PAYROLL_SUB_LINES');

901: Exception
902: when others then
903: -- dbms_output.put_line('Error occured while inserting sub-lines. Error Message' ||
904: -- sqlerrm);
905: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA', 'IMPORT_PAYROLL_SUB_LINES');
906: return 2;
907: End Import_Payroll_Sub_Lines;
908:
909:

Line 963: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA', 'PSP_PI_INVALID_BATCH_NAME');

959:
960: return 0;
961: Exception
962: when OTHERS then
963: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA', 'PSP_PI_INVALID_BATCH_NAME');
964: return 2;
965: End Check_For_Valid_Batches;
966:
967: -- Introduced the function check_for_valid_currency to check whether a batch has got more than one currency

Line 1001: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA','PSP_PI_INVALID_CURRENCY');

997:
998: EXCEPTION
999:
1000: when others then
1001: fnd_msg_pub.add_exc_msg('PSP_PI_IMPORT_DATA','PSP_PI_INVALID_CURRENCY');
1002: return 2;
1003:
1004: END Check_For_Valid_Currency;
1005: /**** end of check for valid currency *******/