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_MSG_PUB

Line 116: -- Initialize the FND_MSG_PUB package

112: l_msg_data VARCHAR2(2000);
113: l_dist_message VARCHAR2(2000);
114: Begin
115:
116: -- Initialize the FND_MSG_PUB package
117: fnd_msg_pub.Initialize;
118:
119: -- Enh. fix 2094036
120: OPEN payroll_interface_check_cur;

Line 117: fnd_msg_pub.Initialize;

113: l_dist_message VARCHAR2(2000);
114: Begin
115:
116: -- Initialize the FND_MSG_PUB package
117: fnd_msg_pub.Initialize;
118:
119: -- Enh. fix 2094036
120: OPEN payroll_interface_check_cur;
121: FETCH payroll_interface_check_cur INTO l_payroll_interface_id;

Line 203: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,

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);
207: fnd_message.set_name('PSP','PSP_PI_IMPORT_GENERAL');

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 218: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,

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);
222: fnd_message.set_name('PSP','PSP_PI_IMPORT_GENERAL');

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 368: fnd_msg_pub.add;

364: -- v_batch_name || ' while creating control lines');
365:
366: fnd_message.set_name('PSP','PSP_PI_MULTPL_PAYROLLS');
367: fnd_message.set_token('BATCH_NAME',v_batch_name);
368: fnd_msg_pub.add;
369: return 1;
370: when no_data_found then
371: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLLS');
372: fnd_message.set_token('BATCH_NAME',v_batch_name);

Line 373: fnd_msg_pub.add;

369: return 1;
370: when no_data_found then
371: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLLS');
372: fnd_message.set_token('BATCH_NAME',v_batch_name);
373: fnd_msg_pub.add;
374: return 1;
375: End;
376:
377: -- Introduced the following code to fetch exchange_rate_type for Bug 2916848

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 557: fnd_msg_pub.add;

553: when too_many_rows then
554: fnd_message.set_name('PSP','PSP_PI_MULTPL_PAYROLL_CNTRL_ID');
555: fnd_message.set_token('PAYROLL_PERIOD_ID', to_char(Lines_Record_Agg.Payroll_Period_ID));
556: fnd_message.set_token( 'PAYROLL_SOURCE_CODE', Lines_Record_Agg.Payroll_Source_Code);
557: fnd_msg_pub.add;
558: return 1;
559: END;
560: /* Bug 4155144 - commented this block since the same check has already been done when inserting the control record
561: -- Obtain Payroll ID for a given Payroll Period and the non-oracle source code

Line 575: fnd_msg_pub.add;

571: when OTHERS then
572: fnd_message.set_name('PSP', 'PSP_PI_INV_PAYROLL_FOR_PERIOD');
573: fnd_message.set_token('PAYROLL_PERIOD', to_char(Lines_Record_Agg.Payroll_Period_ID));
574: fnd_message.set_token('PAYROLL_SOURCE', Lines_Record_Agg.Payroll_Source_Code);
575: fnd_msg_pub.add;
576: return 1;
577: END;
578:
579: */

Line 605: fnd_msg_pub.add;

601: fnd_message.set_token('PAYROLL_PERIOD', to_char(Lines_Record_Agg.Payroll_Period_ID));
602: fnd_message.set_token('PAYROLL_SOURCE', Lines_Record_Agg.Payroll_Source_Code);
603: fnd_message.set_token('ASSIGNMENT', to_char(Lines_Record_Agg.Assignment_ID));
604: fnd_message.set_token('ELEMENT_TYPE', to_char(Lines_Record_Agg.Element_Type_ID));
605: fnd_msg_pub.add;
606: return 1;
607: END;
608:
609: select Cost_Allocation_KeyFlex_ID

Line 635: fnd_msg_pub.add;

631: -- dbms_output.put_line('Profile value for Set of Books ID :' ||
632: -- v_Set_Of_Books_ID || ' does not match value from PAY_PAYROLLS_F. Cannot
633: -- proceed');
634: fnd_message.set_name('PSP', 'PSP_PI_INVALID_SET_OF_BOOKS');
635: fnd_msg_pub.add;
636: return 2;
637: End If;
638:
639: PSP_General.get_GL_CCID(P_Payroll_ID => n_Payroll_ID, P_Set_Of_Books_ID =>

Line 646: fnd_msg_pub.add;

642:
643: If n_GL_Code_Combination_ID IS NULL or n_GL_Code_Combination_ID = 0 Then
644: -- dbms_output.put_line('GL Code Combination ID is invalid. Cannot proceed');
645: fnd_message.set_name('PSP', 'PSP_INVALID_GL_CCID');
646: fnd_msg_pub.add;
647: return 2;
648: End If;
649: ******************************************************************************************/
650: Begin

Line 661: fnd_msg_pub.add;

657:
658: If n_GL_Code_Combination_ID IS NULL or n_GL_Code_Combination_ID = 0 Then
659: -- dbms_output.put_line('GL Code Combination ID is invalid. Cannot proceed');
660: fnd_message.set_name('PSP', 'PSP_NO_CLEARING_ACCOUNT');
661: fnd_msg_pub.add;
662: return 2;
663: End If;
664:
665: Exception

Line 668: fnd_msg_pub.add;

664:
665: Exception
666: when OTHERS Then
667: fnd_message.set_name('PSP', 'PSP_NO_CLEARING_ACCOUNT');
668: fnd_msg_pub.add;
669: return 2;
670: End;
671:
672: -- v_Set_Of_Books_ID := FND_Profile.Value('PSP_SET_OF_BOOKS');

Line 679: fnd_msg_pub.add;

675: -- dbms_output.put_line('Profile value for Set of Books ID :' ||
676: -- v_Set_Of_Books_ID || ' does not match value from PAY_PAYROLLS_F. Cannot
677: -- proceed');
678: fnd_message.set_name('PSP', 'PSP_PI_INVALID_SET_OF_BOOKS');
679: fnd_msg_pub.add;
680: return 2;
681: End If;
682: -- n_Set_Of_Books_ID := to_number(v_set_of_books_id);
683:

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 956: fnd_msg_pub.add;

952:
953: If C1_Batch_Name IS NOT NULL Then
954: fnd_message.set_name('PSP', 'PSP_PI_INVALID_BATCH_NAME');
955: fnd_message.set_token('PSP_BATCH_NAME', C1_Batch_Name);
956: fnd_msg_pub.add;
957: return 2;
958: End If;
959:
960: return 0;

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 992: fnd_msg_pub.add;

988:
989: IF (l_count_currency >1 ) then
990: fnd_message.set_name ('PSP','PSP_PI_INVALID_CURRENCY');
991: fnd_message.set_token('BATCH_NAME',v_batch_name);
992: fnd_msg_pub.add;
993: return 2;
994: END IF;
995:
996: return 0;

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 *******/