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_MESSAGE

Line 196: fnd_message.set_name('PSP', 'PSP_PI_BATCH_IN_PROGRESS');

192: retCode := 0;
193: Exception
194: -- Enh. fix 2094036
195: WHEN RECORD_ALREADY_LOCKED THEN
196: fnd_message.set_name('PSP', 'PSP_PI_BATCH_IN_PROGRESS');
197: fnd_message.set_token('BATCH_NAME', v_batch_name);
198: l_dist_message := fnd_message.get;
199: errbuf := l_error_api_name || fnd_global.local_chr(10) || l_dist_message;
200: retcode:= 2;

Line 197: fnd_message.set_token('BATCH_NAME', v_batch_name);

193: Exception
194: -- Enh. fix 2094036
195: WHEN RECORD_ALREADY_LOCKED THEN
196: fnd_message.set_name('PSP', 'PSP_PI_BATCH_IN_PROGRESS');
197: fnd_message.set_token('BATCH_NAME', v_batch_name);
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

Line 198: l_dist_message := fnd_message.get;

194: -- Enh. fix 2094036
195: WHEN RECORD_ALREADY_LOCKED THEN
196: fnd_message.set_name('PSP', 'PSP_PI_BATCH_IN_PROGRESS');
197: fnd_message.set_token('BATCH_NAME', v_batch_name);
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

Line 207: fnd_message.set_name('PSP','PSP_PI_IMPORT_GENERAL');

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);
209: l_dist_message := fnd_message.get;
210: errbuf := substr(l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10) || l_dist_message, 1, 232);
211: retCode := 2;

Line 208: fnd_message.set_token('PROCEDURE_NAME',l_error_api_name);

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);
209: l_dist_message := fnd_message.get;
210: errbuf := substr(l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10) || l_dist_message, 1, 232);
211: retCode := 2;
212: rollback;

Line 209: l_dist_message := fnd_message.get;

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);
209: l_dist_message := fnd_message.get;
210: errbuf := substr(l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10) || l_dist_message, 1, 232);
211: retCode := 2;
212: rollback;
213:

Line 222: fnd_message.set_name('PSP','PSP_PI_IMPORT_GENERAL');

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);
224: l_dist_message := fnd_message.get;
225:
226: errbuf := substr(l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10) || l_dist_message, 1, 232);

Line 223: fnd_message.set_token('PROCEDURE_NAME',l_error_api_name);

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);
224: l_dist_message := fnd_message.get;
225:
226: errbuf := substr(l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10) || l_dist_message, 1, 232);
227: retCode := 2;

Line 224: l_dist_message := fnd_message.get;

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);
224: l_dist_message := fnd_message.get;
225:
226: errbuf := substr(l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10) || l_dist_message, 1, 232);
227: retCode := 2;
228: rollback;

Line 284: FND_MESSAGE.SET_NAME('PSP', 'PSP_PI_INVALID_RECORDS');

280: If n_Valid_Records > 0 Then
281:
282: -- dbms_output.put_line('Records are not all valid in this batch. Please validate the records
283: -- Non_Orcl Maintenance screen');
284: FND_MESSAGE.SET_NAME('PSP', 'PSP_PI_INVALID_RECORDS');
285: FND_MESSAGE.SET_TOKEN('BATCH_NAME', v_Batch_Name);
286: return (1);
287: Else
288: -- dbms_output.put_line('Server side validation done successfully. Now, on to import

Line 285: FND_MESSAGE.SET_TOKEN('BATCH_NAME', v_Batch_Name);

281:
282: -- dbms_output.put_line('Records are not all valid in this batch. Please validate the records
283: -- Non_Orcl Maintenance screen');
284: FND_MESSAGE.SET_NAME('PSP', 'PSP_PI_INVALID_RECORDS');
285: FND_MESSAGE.SET_TOKEN('BATCH_NAME', v_Batch_Name);
286: return (1);
287: Else
288: -- dbms_output.put_line('Server side validation done successfully. Now, on to import
289: -- process.');

Line 366: fnd_message.set_name('PSP','PSP_PI_MULTPL_PAYROLLS');

362: when too_many_rows then
363: -- dbms_output.put_line('Too many Payroll IDs returned for the Batch ' ||
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

Line 367: fnd_message.set_token('BATCH_NAME',v_batch_name);

363: -- dbms_output.put_line('Too many Payroll IDs returned for the Batch ' ||
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');

Line 371: fnd_message.set_name('PSP','PSP_PI_NO_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);
373: fnd_msg_pub.add;
374: return 1;
375: End;

Line 372: 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);
373: fnd_msg_pub.add;
374: return 1;
375: End;
376:

Line 554: fnd_message.set_name('PSP','PSP_PI_MULTPL_PAYROLL_CNTRL_ID');

550: and set_of_books_id = v_set_of_books_id;
551:
552: EXCEPTION
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;

Line 555: fnd_message.set_token('PAYROLL_PERIOD_ID', to_char(Lines_Record_Agg.Payroll_Period_ID));

551:
552: EXCEPTION
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;

Line 556: fnd_message.set_token( 'PAYROLL_SOURCE_CODE', Lines_Record_Agg.Payroll_Source_Code);

552: EXCEPTION
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

Line 572: fnd_message.set_name('PSP', 'PSP_PI_INV_PAYROLL_FOR_PERIOD');

568: and BATCH_NAME = v_Batch_Name;
569: -- dbms_output.put_line('Payroll ID ' || to_Char(n_Payroll_ID) || ' obtained');
570: EXCEPTION
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;

Line 573: fnd_message.set_token('PAYROLL_PERIOD', to_char(Lines_Record_Agg.Payroll_Period_ID));

569: -- dbms_output.put_line('Payroll ID ' || to_Char(n_Payroll_ID) || ' obtained');
570: EXCEPTION
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;

Line 574: fnd_message.set_token('PAYROLL_SOURCE', Lines_Record_Agg.Payroll_Source_Code);

570: EXCEPTION
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:

Line 600: fnd_message.set_name('PSP', 'PSP_PI_MUL_REC_FOR_PER_ASS_EL');

596: and SUB_LINE_END_DATE = Lines_Record_Agg.Sub_Line_End_Date
597: and BATCH_NAME = v_Batch_Name;
598: EXCEPTION
599: when OTHERS then
600: fnd_message.set_name('PSP', 'PSP_PI_MUL_REC_FOR_PER_ASS_EL');
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));

Line 601: fnd_message.set_token('PAYROLL_PERIOD', to_char(Lines_Record_Agg.Payroll_Period_ID));

597: and BATCH_NAME = v_Batch_Name;
598: EXCEPTION
599: when OTHERS then
600: fnd_message.set_name('PSP', 'PSP_PI_MUL_REC_FOR_PER_ASS_EL');
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;

Line 602: fnd_message.set_token('PAYROLL_SOURCE', Lines_Record_Agg.Payroll_Source_Code);

598: EXCEPTION
599: when OTHERS then
600: fnd_message.set_name('PSP', 'PSP_PI_MUL_REC_FOR_PER_ASS_EL');
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;

Line 603: fnd_message.set_token('ASSIGNMENT', to_char(Lines_Record_Agg.Assignment_ID));

599: when OTHERS then
600: fnd_message.set_name('PSP', 'PSP_PI_MUL_REC_FOR_PER_ASS_EL');
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;

Line 604: fnd_message.set_token('ELEMENT_TYPE', to_char(Lines_Record_Agg.Element_Type_ID));

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

Line 634: fnd_message.set_name('PSP', 'PSP_PI_INVALID_SET_OF_BOOKS');

630: If (v_Set_Of_Books_ID IS NULL) or (to_number(v_Set_Of_Books_ID) <> n_Set_Of_Books_ID) Then
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:

Line 645: fnd_message.set_name('PSP', 'PSP_INVALID_GL_CCID');

641: x_GL_CCID => n_GL_Code_Combination_ID);
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: ******************************************************************************************/

Line 660: fnd_message.set_name('PSP', 'PSP_NO_CLEARING_ACCOUNT');

656: and a.payroll_id = n_payroll_id; -- Added for bug 5592964
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:

Line 667: fnd_message.set_name('PSP', 'PSP_NO_CLEARING_ACCOUNT');

663: End If;
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:

Line 678: fnd_message.set_name('PSP', 'PSP_PI_INVALID_SET_OF_BOOKS');

674: If (v_Set_Of_Books_ID IS NULL) Then
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);

Line 954: fnd_message.set_name('PSP', 'PSP_PI_INVALID_BATCH_NAME');

950: END LOOP;
951: Close C1;
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;

Line 955: fnd_message.set_token('PSP_BATCH_NAME', C1_Batch_Name);

951: Close C1;
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:

Line 990: fnd_message.set_name ('PSP','PSP_PI_INVALID_CURRENCY');

986: FETCH Count_currency_code_cur into l_count_currency;
987: CLOSE Count_currency_code_cur;
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;

Line 991: fnd_message.set_token('BATCH_NAME',v_batch_name);

987: CLOSE Count_currency_code_cur;
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: