DBA Data[Home] [Help]

APPS.PAY_EBRA_DIAGNOSTICS dependencies on FND_FILE

Line 851: fnd_file.put_line(fnd_file.output, formated_header_string(

847:
848: lvc_balance_status := gv_invalid;
849:
850: /* Print Header for the FIle */
851: fnd_file.put_line(fnd_file.output, formated_header_string(
852: gv_title || ':- ( ' || lvc_date_time || ' )'
853: ,p_output_file_type
854: ));
855:

Line 859: fnd_file.put_line(fnd_file.output, formated_header_string(

855:
856:
857: /* Leave 4 blank line */
858: for i in 1..4 LOOP
859: fnd_file.put_line(fnd_file.output, formated_header_string(
860: ' '
861: ,p_output_file_type
862: ));
863: END LOOP;

Line 883: fnd_file.put_line(fnd_file.output, formated_header_string(

879:
880:
881: /* STEP 2: Run Balance Status Section */
882:
883: fnd_file.put_line(fnd_file.output, formated_header_string(
884: gv_title_sec1 || ' '
885: ,p_output_file_type
886: ));
887:

Line 889: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

885: ,p_output_file_type
886: ));
887:
888: IF p_output_file_type ='HTML' THEN
889: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
890: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
891: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
892: END IF;
893:

Line 890: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

886: ));
887:
888: IF p_output_file_type ='HTML' THEN
889: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
890: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
891: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
892: END IF;
893:
894: /* Write the column Header */

Line 891: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

887:
888: IF p_output_file_type ='HTML' THEN
889: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
890: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
891: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
892: END IF;
893:
894: /* Write the column Header */
895:

Line 896: fnd_file.put_line(fnd_file.output,formated_header_sec1( p_output_file_type));

892: END IF;
893:
894: /* Write the column Header */
895:
896: fnd_file.put_line(fnd_file.output,formated_header_sec1( p_output_file_type));
897:
898: IF p_output_file_type ='HTML' THEN
899: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
900: END IF;

Line 899: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

895:
896: fnd_file.put_line(fnd_file.output,formated_header_sec1( p_output_file_type));
897:
898: IF p_output_file_type ='HTML' THEN
899: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
900: END IF;
901:
902: FOR i in c_run_balance_status(lvn_business_Group_id) LOOP
903:

Line 916: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

912: if p_output_file_type ='HTML' then
913: lv_data_row := '

' || lv_data_row || '' ;
914: end if;
915: hr_utility.trace(lv_data_row);
916: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
917: END LOOP ;
918:
919: IF p_output_file_type ='HTML' THEN
920: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

Line 920: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

916: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
917: END LOOP ;
918:
919: IF p_output_file_type ='HTML' THEN
920: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
921: END IF;
922:
923:
924: /* STEP 3: FOR the SEEDED Attribute */

Line 927: fnd_file.put_line(fnd_file.output, formated_header_string(

923:
924: /* STEP 3: FOR the SEEDED Attribute */
925: /* Leave 4 blank line */
926: FOR i in 1..4 LOOP
927: fnd_file.put_line(fnd_file.output, formated_header_string(
928: ' '
929: ,p_output_file_type
930: ));
931: END LOOP;

Line 933: fnd_file.put_line(fnd_file.output, formated_header_string(

929: ,p_output_file_type
930: ));
931: END LOOP;
932:
933: fnd_file.put_line(fnd_file.output, formated_header_string(
934: gv_title_sec2 || ' '
935: ,p_output_file_type
936: ));
937:

Line 939: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

935: ,p_output_file_type
936: ));
937:
938: IF p_output_file_type ='HTML' THEN
939: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
941: END IF;
942:
943: /* Write the column Header */

Line 940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

936: ));
937:
938: IF p_output_file_type ='HTML' THEN
939: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
941: END IF;
942:
943: /* Write the column Header */
944:

Line 945: fnd_file.put_line(fnd_file.output,formated_header_sec2( p_output_file_type));

941: END IF;
942:
943: /* Write the column Header */
944:
945: fnd_file.put_line(fnd_file.output,formated_header_sec2( p_output_file_type));
946:
947: IF p_output_file_type ='HTML' THEN
948: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
949: END IF;

Line 948: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

944:
945: fnd_file.put_line(fnd_file.output,formated_header_sec2( p_output_file_type));
946:
947: IF p_output_file_type ='HTML' THEN
948: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
949: END IF;
950:
951: For i in c_seeded_att( lvc_legislation_code ) loop
952: hr_utility.trace( 'Attribute name :- ' || i.attribute_name);

Line 984: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

980: if p_output_file_type ='HTML' then
981: lv_data_row := '

' || lv_data_row || '' ;
982: end if;
983: hr_utility.trace(lv_data_row);
984: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
985:
986:
987: END LOOP ; /* c_seeded_att */
988:

Line 1022: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

1018: if p_output_file_type ='HTML' then
1019: lv_data_row := '

' || lv_data_row || '' ;
1020: end if;
1021: hr_utility.trace(lv_data_row);
1022: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1023:
1024:
1025: END LOOP ; /* c_userdef_att */
1026:

Line 1028: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

1024:
1025: END LOOP ; /* c_userdef_att */
1026:
1027: IF p_output_file_type ='HTML' THEN
1028: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1029: END IF;
1030:
1031:
1032:

Line 1040: fnd_file.put_line(fnd_file.output, formated_header_string(

1036:
1037: IF p_attribute_balance = 'Y' THEN
1038:
1039: FOR i in 1..4 LOOP
1040: fnd_file.put_line(fnd_file.output, formated_header_string(
1041: ' '
1042: ,p_output_file_type
1043: ));
1044: END LOOP;

Line 1046: fnd_file.put_line(fnd_file.output, formated_header_string(

1042: ,p_output_file_type
1043: ));
1044: END LOOP;
1045:
1046: fnd_file.put_line(fnd_file.output, formated_header_string(
1047: gv_title_sec3 || ' '
1048: ,p_output_file_type
1049: ));
1050:

Line 1052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1048: ,p_output_file_type
1049: ));
1050:
1051: IF p_output_file_type ='HTML' THEN
1052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1053: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1054: END IF;
1055:
1056: /* Write the column Header */

Line 1053: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

1049: ));
1050:
1051: IF p_output_file_type ='HTML' THEN
1052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1053: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1054: END IF;
1055:
1056: /* Write the column Header */
1057:

Line 1058: fnd_file.put_line(fnd_file.output,formated_header_sec3( p_output_file_type));

1054: END IF;
1055:
1056: /* Write the column Header */
1057:
1058: fnd_file.put_line(fnd_file.output,formated_header_sec3( p_output_file_type));
1059:
1060: IF p_output_file_type ='HTML' THEN
1061: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1062: END IF;

Line 1061: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1057:
1058: fnd_file.put_line(fnd_file.output,formated_header_sec3( p_output_file_type));
1059:
1060: IF p_output_file_type ='HTML' THEN
1061: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1062: END IF;
1063:
1064: For i in c_seeded_att( lvc_legislation_code ) loop
1065: hr_utility.trace( 'Attribute name :- ' || i.attribute_name);

Line 1082: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

1078: if p_output_file_type ='HTML' then
1079: lv_data_row := '

' || lv_data_row || '' ;
1080: end if;
1081: hr_utility.trace(lv_data_row);
1082: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1083: END LOOP;
1084:
1085: END LOOP ; /* c_seeded_att */
1086:

Line 1105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

1101: if p_output_file_type ='HTML' then
1102: lv_data_row := '

' || lv_data_row || '' ;
1103: end if;
1104: hr_utility.trace(lv_data_row);
1105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1106: END LOOP;
1107:
1108: END LOOP ; /* c_userdef_att */
1109:

Line 1111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

1107:
1108: END LOOP ; /* c_userdef_att */
1109:
1110: IF p_output_file_type ='HTML' THEN
1111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1112:
1113: END IF;
1114:
1115: END IF ; /* IF p_attribute_balance = 'Y' */

Line 1129: fnd_file.put_line(fnd_file.output, formated_header_string(

1125: lvn_count := lvn_count +1;
1126: /* Print only first time */
1127: IF lvn_count = 1 THEN
1128:
1129: fnd_file.put_line(fnd_file.output, formated_header_string(
1130: gv_title_sec4 || ' '
1131: ,p_output_file_type
1132: ));
1133:

Line 1137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1133:
1134:
1135:
1136: IF p_output_file_type ='HTML' THEN
1137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1139: END IF;
1140:
1141: /* Write the column Header */

Line 1138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

1134:
1135:
1136: IF p_output_file_type ='HTML' THEN
1137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1139: END IF;
1140:
1141: /* Write the column Header */
1142:

Line 1143: fnd_file.put_line(fnd_file.output,formated_header_sec4( p_output_file_type));

1139: END IF;
1140:
1141: /* Write the column Header */
1142:
1143: fnd_file.put_line(fnd_file.output,formated_header_sec4( p_output_file_type));
1144:
1145: IF p_output_file_type ='HTML' THEN
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1147: END IF;

Line 1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1142:
1143: fnd_file.put_line(fnd_file.output,formated_header_sec4( p_output_file_type));
1144:
1145: IF p_output_file_type ='HTML' THEN
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1147: END IF;
1148:
1149: END IF; /* lvn_count */
1150:

Line 1164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

1160: if p_output_file_type ='HTML' then
1161: lv_data_row := '

' || lv_data_row || '' ;
1162: end if;
1163: hr_utility.trace(lv_data_row);
1164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1165:
1166:
1167: END LOOP; /* c_attrib_details */
1168:

Line 1171: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

1167: END LOOP; /* c_attrib_details */
1168:
1169:
1170: IF p_output_file_type ='HTML' THEN
1171: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1172: END IF;
1173:
1174: IF p_output_file_type ='HTML' THEN
1175: UPDATE fnd_concurrent_requests