DBA Data[Home] [Help]

APPS.PAY_DK_TC_DP_UPLOAD dependencies on FND_NUMBER

Line 397: if fnd_number.CANONICAL_TO_NUMBER(l_entry_value3) <=0 then

393: raise e_invalid_tax_card_type;
394: end if;
395:
396: if l_entry_value2 IN ('H','B') then
397: if fnd_number.CANONICAL_TO_NUMBER(l_entry_value3) <=0 then
398: raise e_tax_percentage_err;
399: end if;
400: end if;
401:

Line 403: if fnd_number.CANONICAL_TO_NUMBER(l_entry_value3) < 0 then

399: end if;
400: end if;
401:
402: if l_entry_value2 = 'F' then
403: if fnd_number.CANONICAL_TO_NUMBER(l_entry_value3) < 0 then
404: raise e_tax_percentage_err;
405: end if;
406: end if;
407:

Line 1065: -- p_entry_value3 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value3)/100;

1061: --p_entry_value9 := substr( p_line ,150,7); /* Serial number for e-Tax card */
1062: p_entry_value9 := 'UPLOAD COMPLETE';
1063:
1064: -- Considering the last two digits as decimal digits.
1065: -- p_entry_value3 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value3)/100;
1066: p_entry_value4 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value4)/100;
1067: p_entry_value5 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value5)/100;
1068: p_entry_value6 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value6)/100;
1069: p_entry_value7 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value7)/100;

Line 1066: p_entry_value4 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value4)/100;

1062: p_entry_value9 := 'UPLOAD COMPLETE';
1063:
1064: -- Considering the last two digits as decimal digits.
1065: -- p_entry_value3 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value3)/100;
1066: p_entry_value4 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value4)/100;
1067: p_entry_value5 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value5)/100;
1068: p_entry_value6 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value6)/100;
1069: p_entry_value7 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value7)/100;
1070: p_entry_value8 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value8)/100;

Line 1067: p_entry_value5 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value5)/100;

1063:
1064: -- Considering the last two digits as decimal digits.
1065: -- p_entry_value3 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value3)/100;
1066: p_entry_value4 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value4)/100;
1067: p_entry_value5 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value5)/100;
1068: p_entry_value6 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value6)/100;
1069: p_entry_value7 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value7)/100;
1070: p_entry_value8 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value8)/100;
1071:

Line 1068: p_entry_value6 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value6)/100;

1064: -- Considering the last two digits as decimal digits.
1065: -- p_entry_value3 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value3)/100;
1066: p_entry_value4 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value4)/100;
1067: p_entry_value5 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value5)/100;
1068: p_entry_value6 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value6)/100;
1069: p_entry_value7 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value7)/100;
1070: p_entry_value8 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value8)/100;
1071:
1072: ELSIF l_indvnr = '0607' OR l_indvnr = '0619' THEN

Line 1069: p_entry_value7 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value7)/100;

1065: -- p_entry_value3 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value3)/100;
1066: p_entry_value4 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value4)/100;
1067: p_entry_value5 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value5)/100;
1068: p_entry_value6 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value6)/100;
1069: p_entry_value7 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value7)/100;
1070: p_entry_value8 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value8)/100;
1071:
1072: ELSIF l_indvnr = '0607' OR l_indvnr = '0619' THEN
1073: null;

Line 1070: p_entry_value8 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value8)/100;

1066: p_entry_value4 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value4)/100;
1067: p_entry_value5 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value5)/100;
1068: p_entry_value6 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value6)/100;
1069: p_entry_value7 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value7)/100;
1070: p_entry_value8 := fnd_number.CANONICAL_TO_NUMBER(p_entry_value8)/100;
1071:
1072: ELSIF l_indvnr = '0607' OR l_indvnr = '0619' THEN
1073: null;
1074: ELSE