APPS.IGI_CIS2007_CDROM_PKG dependencies on FND_PROFILE

Line 405: l_awt_group_id := fnd_profile.VALUE(l_prof_net_wth);

401:
402: /* if CD-ROM subcontractor matches with AP_SUPPLIERS subcontractor and user asks for Upload also */
403: If (l_match_flag = 'M' And p_upl_option = 'U') Then
404: If (upper(C_Igi_Cis_Cdrom_Lines_Rec.tax_treatment) = 'NET') Then
405: l_awt_group_id := fnd_profile.VALUE(l_prof_net_wth);
406: Elsif (upper(C_Igi_Cis_Cdrom_Lines_Rec.tax_treatment) = 'GROSS') Then
407: l_awt_group_id := fnd_profile.VALUE(l_prof_gross_wth);
408: End If;
409:

Line 407: l_awt_group_id := fnd_profile.VALUE(l_prof_gross_wth);

403: If (l_match_flag = 'M' And p_upl_option = 'U') Then
404: If (upper(C_Igi_Cis_Cdrom_Lines_Rec.tax_treatment) = 'NET') Then
405: l_awt_group_id := fnd_profile.VALUE(l_prof_net_wth);
406: Elsif (upper(C_Igi_Cis_Cdrom_Lines_Rec.tax_treatment) = 'GROSS') Then
407: l_awt_group_id := fnd_profile.VALUE(l_prof_gross_wth);
408: End If;
409:
410: /* calling to update existing certificates .. */
411: /* Bug 5705187 */

Line 732: l_csv_file_name := fnd_profile.VALUE('IGI_CIS2007_CDROM_DATA_PATH');

728: 'Construction Industry Scheme : CD-ROM Data Upload Process Report');
729: fnd_file.put_line(fnd_file.output,
730: '----------------------------------------------------------------');
731: fnd_file.put_line(fnd_file.output,'');
732: l_csv_file_name := fnd_profile.VALUE('IGI_CIS2007_CDROM_DATA_PATH');
733: fnd_file.put_line(fnd_file.log, 'Upload Option: ' || p_upl_option);
734: fnd_file.put_line(fnd_file.log, 'CD-ROM csv file: ' || l_csv_file_name);
735: fnd_file.put_line(fnd_file.log, '');
736:

Line 738: If Trunc(sysdate) < trunc(to_date(fnd_profile.value('IGI_CIS2007_LIB_DATE'),'DD-MM-YYYY')) Then

734: fnd_file.put_line(fnd_file.log, 'CD-ROM csv file: ' || l_csv_file_name);
735: fnd_file.put_line(fnd_file.log, '');
736:
737: If P_Upl_Option = 'U' Then
738: If Trunc(sysdate) < trunc(to_date(fnd_profile.value('IGI_CIS2007_LIB_DATE'),'DD-MM-YYYY')) Then
739: For C_Upl_Meaning_Rec in C_Upl_Meaning Loop
740: l_meaning := C_Upl_Meaning_Rec.Meaning;
741: End Loop;
742: fnd_file.put_line(fnd_file.output,

Line 744: 'cannot be run before ' || to_char(to_date(fnd_profile.value('IGI_CIS2007_LIB_DATE'),

740: l_meaning := C_Upl_Meaning_Rec.Meaning;
741: End Loop;
742: fnd_file.put_line(fnd_file.output,
743: 'The ' || l_meaning || ' Option of the CD-ROM Data Upload Process ' ||
744: 'cannot be run before ' || to_char(to_date(fnd_profile.value('IGI_CIS2007_LIB_DATE'),
745: 'DD-MM-YYYY'), 'DD-MON-YYYY'));
746: Raise E_Update_Not_Allowed;
747: End If;
748: End If;