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.PJM_TRANSFER_SPEC_CHARGES_PKG dependencies on PJM_CONC

Line 74: PJM_CONC.put_line(fnd_message_cache.get);

70: Current_Time := sysdate;
71: fnd_message_cache.set_name('FND' , 'UTIL-CURRENT TIME');
72: fnd_message_cache.set_token('DATE' , fnd_date.date_to_displaydate(Current_Time));
73: fnd_message_cache.set_token('TIME' , to_char(Current_Time , 'HH24:MI:SS'));
74: PJM_CONC.put_line(fnd_message_cache.get);
75: PJM_CONC.new_line(1);
76: EXCEPTION
77: WHEN OTHERS THEN
78: NULL;

Line 75: PJM_CONC.new_line(1);

71: fnd_message_cache.set_name('FND' , 'UTIL-CURRENT TIME');
72: fnd_message_cache.set_token('DATE' , fnd_date.date_to_displaydate(Current_Time));
73: fnd_message_cache.set_token('TIME' , to_char(Current_Time , 'HH24:MI:SS'));
74: PJM_CONC.put_line(fnd_message_cache.get);
75: PJM_CONC.new_line(1);
76: EXCEPTION
77: WHEN OTHERS THEN
78: NULL;
79: END Timestamp;

Line 578: PJM_CONC.put_line(fnd_message.get || ' ...');

574: else l_trx_status_code := X_trx_status_code;
575: end if;
576:
577: fnd_message.set_name('PJM','CONC-APINV Spechrg Transfer');
578: PJM_CONC.put_line(fnd_message.get || ' ...');
579: PJM_CONC.new_line(1);
580:
581: PJM_CONC.put_line('[PROJECT_ID] = ' || X_Project_Id);
582: PJM_CONC.put_line('[START_DATE] = ' || X_Start_Date);

Line 579: PJM_CONC.new_line(1);

575: end if;
576:
577: fnd_message.set_name('PJM','CONC-APINV Spechrg Transfer');
578: PJM_CONC.put_line(fnd_message.get || ' ...');
579: PJM_CONC.new_line(1);
580:
581: PJM_CONC.put_line('[PROJECT_ID] = ' || X_Project_Id);
582: PJM_CONC.put_line('[START_DATE] = ' || X_Start_Date);
583: PJM_CONC.put_line('[END_DATE] = ' || X_End_Date);

Line 581: PJM_CONC.put_line('[PROJECT_ID] = ' || X_Project_Id);

577: fnd_message.set_name('PJM','CONC-APINV Spechrg Transfer');
578: PJM_CONC.put_line(fnd_message.get || ' ...');
579: PJM_CONC.new_line(1);
580:
581: PJM_CONC.put_line('[PROJECT_ID] = ' || X_Project_Id);
582: PJM_CONC.put_line('[START_DATE] = ' || X_Start_Date);
583: PJM_CONC.put_line('[END_DATE] = ' || X_End_Date);
584: PJM_CONC.put_line('[SUBMIT_TRX_IMPORT] = ' || X_Submit_Trx_Import);
585:

Line 582: PJM_CONC.put_line('[START_DATE] = ' || X_Start_Date);

578: PJM_CONC.put_line(fnd_message.get || ' ...');
579: PJM_CONC.new_line(1);
580:
581: PJM_CONC.put_line('[PROJECT_ID] = ' || X_Project_Id);
582: PJM_CONC.put_line('[START_DATE] = ' || X_Start_Date);
583: PJM_CONC.put_line('[END_DATE] = ' || X_End_Date);
584: PJM_CONC.put_line('[SUBMIT_TRX_IMPORT] = ' || X_Submit_Trx_Import);
585:
586: l_request_id := fnd_global.conc_request_id;

Line 583: PJM_CONC.put_line('[END_DATE] = ' || X_End_Date);

579: PJM_CONC.new_line(1);
580:
581: PJM_CONC.put_line('[PROJECT_ID] = ' || X_Project_Id);
582: PJM_CONC.put_line('[START_DATE] = ' || X_Start_Date);
583: PJM_CONC.put_line('[END_DATE] = ' || X_End_Date);
584: PJM_CONC.put_line('[SUBMIT_TRX_IMPORT] = ' || X_Submit_Trx_Import);
585:
586: l_request_id := fnd_global.conc_request_id;
587: l_user_id := fnd_global.user_id;

Line 584: PJM_CONC.put_line('[SUBMIT_TRX_IMPORT] = ' || X_Submit_Trx_Import);

580:
581: PJM_CONC.put_line('[PROJECT_ID] = ' || X_Project_Id);
582: PJM_CONC.put_line('[START_DATE] = ' || X_Start_Date);
583: PJM_CONC.put_line('[END_DATE] = ' || X_End_Date);
584: PJM_CONC.put_line('[SUBMIT_TRX_IMPORT] = ' || X_Submit_Trx_Import);
585:
586: l_request_id := fnd_global.conc_request_id;
587: l_user_id := fnd_global.user_id;
588: l_Start_Date := fnd_date.canonical_to_date(X_Start_Date);

Line 591: PJM_CONC.put_line('[REQUEST_ID] = ' || l_request_id);

587: l_user_id := fnd_global.user_id;
588: l_Start_Date := fnd_date.canonical_to_date(X_Start_Date);
589: l_End_Date := fnd_date.canonical_to_date(X_End_Date);
590:
591: PJM_CONC.put_line('[REQUEST_ID] = ' || l_request_id);
592: PJM_CONC.new_line(1);
593:
594: l_Freight_Exp_Comment := fnd_message.get_string('PJM','CONC-APINV FREIGHT');
595: l_Tax_Exp_Comment := fnd_message.get_string('PJM','CONC-APINV TAX');

Line 592: PJM_CONC.new_line(1);

588: l_Start_Date := fnd_date.canonical_to_date(X_Start_Date);
589: l_End_Date := fnd_date.canonical_to_date(X_End_Date);
590:
591: PJM_CONC.put_line('[REQUEST_ID] = ' || l_request_id);
592: PJM_CONC.new_line(1);
593:
594: l_Freight_Exp_Comment := fnd_message.get_string('PJM','CONC-APINV FREIGHT');
595: l_Tax_Exp_Comment := fnd_message.get_string('PJM','CONC-APINV TAX');
596: l_Misc_Exp_Comment := fnd_message.get_string('PJM','CONC-APINV MISC');

Line 600: PJM_CONC.put_line('Batch_Name = ' || l_batch_name);

596: l_Misc_Exp_Comment := fnd_message.get_string('PJM','CONC-APINV MISC');
597:
598: l_Batch_Name := PJM_Transfer_IPV_Pkg.batch_name;
599:
600: PJM_CONC.put_line('Batch_Name = ' || l_batch_name);
601: PJM_CONC.new_line(1);
602:
603: ----------------------------------------------------------------------------------
604: -- Get Accounting Currency Code

Line 601: PJM_CONC.new_line(1);

597:
598: l_Batch_Name := PJM_Transfer_IPV_Pkg.batch_name;
599:
600: PJM_CONC.put_line('Batch_Name = ' || l_batch_name);
601: PJM_CONC.new_line(1);
602:
603: ----------------------------------------------------------------------------------
604: -- Get Accounting Currency Code
605: ----------------------------------------------------------------------------------

Line 619: PJM_CONC.put_line(fnd_message.get || ' ...');

615: -- PA_Transaction_Interfaces
616: -----------------------------------------------------------------------------------
617:
618: fnd_message.set_name('PJM','CONC-APINV Start Loop');
619: PJM_CONC.put_line(fnd_message.get || ' ...');
620:
621: Timestamp;
622:
623: IF (X_Project_Id is not null) THEN

Line 647: PJM_CONC.put_line(' invoice_id ............ '||InvRec.Invoice_Id);

643: , InvRec.Destination_Type_Code
644: , InvRec.Project_Id );
645: END IF;
646:
647: PJM_CONC.put_line(' invoice_id ............ '||InvRec.Invoice_Id);
648: PJM_CONC.put_line(' line_num .............. '||
649: InvRec.Distribution_Line_Number);
650: PJM_CONC.put_line(' project_id ............ '||InvRec.Project_ID);
651: PJM_CONC.put_line(' task_id ............... '||l_Task_Id);

Line 648: PJM_CONC.put_line(' line_num .............. '||

644: , InvRec.Project_Id );
645: END IF;
646:
647: PJM_CONC.put_line(' invoice_id ............ '||InvRec.Invoice_Id);
648: PJM_CONC.put_line(' line_num .............. '||
649: InvRec.Distribution_Line_Number);
650: PJM_CONC.put_line(' project_id ............ '||InvRec.Project_ID);
651: PJM_CONC.put_line(' task_id ............... '||l_Task_Id);
652: PJM_CONC.put_line(' expenditure_org_id .... '||

Line 650: PJM_CONC.put_line(' project_id ............ '||InvRec.Project_ID);

646:
647: PJM_CONC.put_line(' invoice_id ............ '||InvRec.Invoice_Id);
648: PJM_CONC.put_line(' line_num .............. '||
649: InvRec.Distribution_Line_Number);
650: PJM_CONC.put_line(' project_id ............ '||InvRec.Project_ID);
651: PJM_CONC.put_line(' task_id ............... '||l_Task_Id);
652: PJM_CONC.put_line(' expenditure_org_id .... '||
653: InvRec.Expenditure_Organization_ID);
654: PJM_CONC.put_line(' line_type ............. '||

Line 651: PJM_CONC.put_line(' task_id ............... '||l_Task_Id);

647: PJM_CONC.put_line(' invoice_id ............ '||InvRec.Invoice_Id);
648: PJM_CONC.put_line(' line_num .............. '||
649: InvRec.Distribution_Line_Number);
650: PJM_CONC.put_line(' project_id ............ '||InvRec.Project_ID);
651: PJM_CONC.put_line(' task_id ............... '||l_Task_Id);
652: PJM_CONC.put_line(' expenditure_org_id .... '||
653: InvRec.Expenditure_Organization_ID);
654: PJM_CONC.put_line(' line_type ............. '||
655: InvRec.Distribution_Type);

Line 652: PJM_CONC.put_line(' expenditure_org_id .... '||

648: PJM_CONC.put_line(' line_num .............. '||
649: InvRec.Distribution_Line_Number);
650: PJM_CONC.put_line(' project_id ............ '||InvRec.Project_ID);
651: PJM_CONC.put_line(' task_id ............... '||l_Task_Id);
652: PJM_CONC.put_line(' expenditure_org_id .... '||
653: InvRec.Expenditure_Organization_ID);
654: PJM_CONC.put_line(' line_type ............. '||
655: InvRec.Distribution_Type);
656: PJM_CONC.new_line(1);

Line 654: PJM_CONC.put_line(' line_type ............. '||

650: PJM_CONC.put_line(' project_id ............ '||InvRec.Project_ID);
651: PJM_CONC.put_line(' task_id ............... '||l_Task_Id);
652: PJM_CONC.put_line(' expenditure_org_id .... '||
653: InvRec.Expenditure_Organization_ID);
654: PJM_CONC.put_line(' line_type ............. '||
655: InvRec.Distribution_Type);
656: PJM_CONC.new_line(1);
657:
658: Timestamp;

Line 656: PJM_CONC.new_line(1);

652: PJM_CONC.put_line(' expenditure_org_id .... '||
653: InvRec.Expenditure_Organization_ID);
654: PJM_CONC.put_line(' line_type ............. '||
655: InvRec.Distribution_Type);
656: PJM_CONC.new_line(1);
657:
658: Timestamp;
659:
660: ---------------------------------------------------------------------

Line 693: PJM_CONC.put_line(' expenditure_type ...... '||l_expenditure_type);

689: where pop.organization_id = InvRec.Expenditure_Organization_Id
690: and ppp.organization_id (+) = pop.organization_id
691: and ppp.project_id (+) = InvRec.Project_Id;
692:
693: PJM_CONC.put_line(' expenditure_type ...... '||l_expenditure_type);
694: PJM_CONC.put_line(' amount ................ '||
695: nvl(InvRec.Base_Amount, InvRec.Amount));
696: PJM_CONC.new_line(1);
697:

Line 694: PJM_CONC.put_line(' amount ................ '||

690: and ppp.organization_id (+) = pop.organization_id
691: and ppp.project_id (+) = InvRec.Project_Id;
692:
693: PJM_CONC.put_line(' expenditure_type ...... '||l_expenditure_type);
694: PJM_CONC.put_line(' amount ................ '||
695: nvl(InvRec.Base_Amount, InvRec.Amount));
696: PJM_CONC.new_line(1);
697:
698: l_progress := 30;

Line 696: PJM_CONC.new_line(1);

692:
693: PJM_CONC.put_line(' expenditure_type ...... '||l_expenditure_type);
694: PJM_CONC.put_line(' amount ................ '||
695: nvl(InvRec.Base_Amount, InvRec.Amount));
696: PJM_CONC.new_line(1);
697:
698: l_progress := 30;
699:
700: if ( l_expenditure_type is not null ) then

Line 759: PJM_CONC.put_line('... ' || fnd_message.get);

755: -- Insert into PA_TRANSACTION_INTERFACES table
756: -----------------------------------------------------------------------
757:
758: fnd_message.set_name('PJM','CONC-APINV Insert');
759: PJM_CONC.put_line('... ' || fnd_message.get);
760:
761: BEGIN
762:
763: l_progress := 60;

Line 889: PJM_CONC.put_line('... ' || fnd_message.get);

885: -- Update pa_addition_flag to 'Y' for successful invoice distributions
886: ------------------------------------------------------------------------
887:
888: fnd_message.set_name('PJM','CONC-APINV Flag Comp');
889: PJM_CONC.put_line('... ' || fnd_message.get);
890: PJM_CONC.new_line(1);
891:
892:
893: l_progress := 70;

Line 890: PJM_CONC.new_line(1);

886: ------------------------------------------------------------------------
887:
888: fnd_message.set_name('PJM','CONC-APINV Flag Comp');
889: PJM_CONC.put_line('... ' || fnd_message.get);
890: PJM_CONC.new_line(1);
891:
892:
893: l_progress := 70;
894:

Line 939: PJM_CONC.put_line(' invoice_id ............ '||InvRec.Invoice_Id);

935: , InvRec.Destination_Type_Code
936: , InvRec.Project_Id );
937: END IF;
938:
939: PJM_CONC.put_line(' invoice_id ............ '||InvRec.Invoice_Id);
940: PJM_CONC.put_line(' line_num .............. '||
941: InvRec.Distribution_Line_Number);
942: PJM_CONC.put_line(' project_id ............ '||InvRec.Project_ID);
943: PJM_CONC.put_line(' task_id ............... '||l_Task_Id);

Line 940: PJM_CONC.put_line(' line_num .............. '||

936: , InvRec.Project_Id );
937: END IF;
938:
939: PJM_CONC.put_line(' invoice_id ............ '||InvRec.Invoice_Id);
940: PJM_CONC.put_line(' line_num .............. '||
941: InvRec.Distribution_Line_Number);
942: PJM_CONC.put_line(' project_id ............ '||InvRec.Project_ID);
943: PJM_CONC.put_line(' task_id ............... '||l_Task_Id);
944: PJM_CONC.put_line(' expenditure_org_id .... '||

Line 942: PJM_CONC.put_line(' project_id ............ '||InvRec.Project_ID);

938:
939: PJM_CONC.put_line(' invoice_id ............ '||InvRec.Invoice_Id);
940: PJM_CONC.put_line(' line_num .............. '||
941: InvRec.Distribution_Line_Number);
942: PJM_CONC.put_line(' project_id ............ '||InvRec.Project_ID);
943: PJM_CONC.put_line(' task_id ............... '||l_Task_Id);
944: PJM_CONC.put_line(' expenditure_org_id .... '||
945: InvRec.Expenditure_Organization_ID);
946: PJM_CONC.put_line(' line_type ............. '||

Line 943: PJM_CONC.put_line(' task_id ............... '||l_Task_Id);

939: PJM_CONC.put_line(' invoice_id ............ '||InvRec.Invoice_Id);
940: PJM_CONC.put_line(' line_num .............. '||
941: InvRec.Distribution_Line_Number);
942: PJM_CONC.put_line(' project_id ............ '||InvRec.Project_ID);
943: PJM_CONC.put_line(' task_id ............... '||l_Task_Id);
944: PJM_CONC.put_line(' expenditure_org_id .... '||
945: InvRec.Expenditure_Organization_ID);
946: PJM_CONC.put_line(' line_type ............. '||
947: InvRec.Distribution_Type);

Line 944: PJM_CONC.put_line(' expenditure_org_id .... '||

940: PJM_CONC.put_line(' line_num .............. '||
941: InvRec.Distribution_Line_Number);
942: PJM_CONC.put_line(' project_id ............ '||InvRec.Project_ID);
943: PJM_CONC.put_line(' task_id ............... '||l_Task_Id);
944: PJM_CONC.put_line(' expenditure_org_id .... '||
945: InvRec.Expenditure_Organization_ID);
946: PJM_CONC.put_line(' line_type ............. '||
947: InvRec.Distribution_Type);
948: PJM_CONC.new_line(1);

Line 946: PJM_CONC.put_line(' line_type ............. '||

942: PJM_CONC.put_line(' project_id ............ '||InvRec.Project_ID);
943: PJM_CONC.put_line(' task_id ............... '||l_Task_Id);
944: PJM_CONC.put_line(' expenditure_org_id .... '||
945: InvRec.Expenditure_Organization_ID);
946: PJM_CONC.put_line(' line_type ............. '||
947: InvRec.Distribution_Type);
948: PJM_CONC.new_line(1);
949:
950: Timestamp;

Line 948: PJM_CONC.new_line(1);

944: PJM_CONC.put_line(' expenditure_org_id .... '||
945: InvRec.Expenditure_Organization_ID);
946: PJM_CONC.put_line(' line_type ............. '||
947: InvRec.Distribution_Type);
948: PJM_CONC.new_line(1);
949:
950: Timestamp;
951:
952: ---------------------------------------------------------------------

Line 985: PJM_CONC.put_line(' expenditure_type ...... '||l_expenditure_type);

981: where pop.organization_id = InvRec.Expenditure_Organization_Id
982: and ppp.organization_id (+) = pop.organization_id
983: and ppp.project_id (+) = InvRec.Project_Id;
984:
985: PJM_CONC.put_line(' expenditure_type ...... '||l_expenditure_type);
986: PJM_CONC.put_line(' amount ................ '||
987: nvl(InvRec.Base_Amount, InvRec.Amount));
988: PJM_CONC.new_line(1);
989:

Line 986: PJM_CONC.put_line(' amount ................ '||

982: and ppp.organization_id (+) = pop.organization_id
983: and ppp.project_id (+) = InvRec.Project_Id;
984:
985: PJM_CONC.put_line(' expenditure_type ...... '||l_expenditure_type);
986: PJM_CONC.put_line(' amount ................ '||
987: nvl(InvRec.Base_Amount, InvRec.Amount));
988: PJM_CONC.new_line(1);
989:
990: l_progress := 30;

Line 988: PJM_CONC.new_line(1);

984:
985: PJM_CONC.put_line(' expenditure_type ...... '||l_expenditure_type);
986: PJM_CONC.put_line(' amount ................ '||
987: nvl(InvRec.Base_Amount, InvRec.Amount));
988: PJM_CONC.new_line(1);
989:
990: l_progress := 30;
991:
992: if ( l_expenditure_type is not null ) then

Line 1051: PJM_CONC.put_line('... ' || fnd_message.get);

1047: -- Insert into PA_TRANSACTION_INTERFACES table
1048: -----------------------------------------------------------------------
1049:
1050: fnd_message.set_name('PJM','CONC-APINV Insert');
1051: PJM_CONC.put_line('... ' || fnd_message.get);
1052:
1053: BEGIN
1054:
1055: l_progress := 60;

Line 1181: PJM_CONC.put_line('... ' || fnd_message.get);

1177: -- Update pa_addition_flag to 'Y' for successful invoice distributions
1178: ------------------------------------------------------------------------
1179:
1180: fnd_message.set_name('PJM','CONC-APINV Flag Comp');
1181: PJM_CONC.put_line('... ' || fnd_message.get);
1182: PJM_CONC.new_line(1);
1183:
1184:
1185: l_progress := 70;

Line 1182: PJM_CONC.new_line(1);

1178: ------------------------------------------------------------------------
1179:
1180: fnd_message.set_name('PJM','CONC-APINV Flag Comp');
1181: PJM_CONC.put_line('... ' || fnd_message.get);
1182: PJM_CONC.new_line(1);
1183:
1184:
1185: l_progress := 70;
1186:

Line 1212: PJM_CONC.put_line(fnd_message.get || ' ...');

1208:
1209: COMMIT;
1210:
1211: fnd_message.set_name('PJM','CONC-APINV Finish Loop');
1212: PJM_CONC.put_line(fnd_message.get || ' ...');
1213: PJM_CONC.new_line(1);
1214:
1215: Timestamp;
1216:

Line 1213: PJM_CONC.new_line(1);

1209: COMMIT;
1210:
1211: fnd_message.set_name('PJM','CONC-APINV Finish Loop');
1212: PJM_CONC.put_line(fnd_message.get || ' ...');
1213: PJM_CONC.new_line(1);
1214:
1215: Timestamp;
1216:
1217: l_progress := 80;

Line 1227: retcode := PJM_CONC.G_conc_success;

1223: 'Inventory',
1224: l_Batch_Name);
1225: end if;
1226:
1227: retcode := PJM_CONC.G_conc_success;
1228: return;
1229:
1230:
1231: EXCEPTION

Line 1234: retcode := PJM_CONC.G_conc_failure;

1230:
1231: EXCEPTION
1232: when OTHERS then
1233: errbuf := 'SPC-'||l_progress||': '||sqlerrm;
1234: retcode := PJM_CONC.G_conc_failure;
1235: return;
1236:
1237: END Transfer_Spec_Charges_to_PA;
1238: