DBA Data[Home] [Help]

APPS.AP_WEB_VALIDATE_UTIL dependencies on AP_WEB_DB_UTIL_PKG

Line 685: AP_WEB_DB_UTIL_PKG.RaiseException('Validate Cost Center');

681: END IF;
682:
683: EXCEPTION
684: WHEN OTHERS THEN
685: AP_WEB_DB_UTIL_PKG.RaiseException('Validate Cost Center');
686: APP_EXCEPTION.RAISE_EXCEPTION;
687:
688: END ValidateCostCenter;
689:

Line 822: IF (NOT AP_WEB_DB_UTIL_PKG.GetFormattedSysDate(l_date_format, l_last_receipt)) THEN

818: l_date_format := nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'));
819:
820: -- Update the calling sequence
821: --
822: IF (NOT AP_WEB_DB_UTIL_PKG.GetFormattedSysDate(l_date_format, l_last_receipt)) THEN
823: NULL;
824: END IF;
825:
826: current_calling_sequence := 'AP_WEB_VALIDATE_UTIL.ValidateReportHeader';

Line 1480: l_fixed_msg := AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get_encoded(), TRUE);

1476: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_VALIDATE_UTIL', 'start ValidateExpLineCoreFields');
1477: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;
1478:
1479: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_FIXED');
1480: l_fixed_msg := AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get_encoded(), TRUE);
1481:
1482: l_reimbcurr_format := FND_CURRENCY.get_format_mask(p_report_header_info.reimbursement_currency_code, 30);
1483:
1484: if (p_report_header_info.transaction_currency_type = 'reimbursement') then

Line 1720: l_dailyAmount := AP_WEB_DB_UTIL_PKG.CharToNumber(p_report_line_info.daily_amount);

1716: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1717: l_dailyAmount := null; -- initialize it since it will be used later!
1718: if (p_report_line_info.daily_amount IS NOT NULL) then
1719: BEGIN
1720: l_dailyAmount := AP_WEB_DB_UTIL_PKG.CharToNumber(p_report_line_info.daily_amount);
1721: if CheckNum(l_dailyAmount, p_exp_error, p_receiptcount,
1722: C_DAmount_Prompt, p_allow_credit_lines, FALSE) then
1723: -- p_report_line_info.daily_amount := to_char(l_num);
1724: NULL;

Line 1748: l_receiptAmount := AP_WEB_DB_UTIL_PKG.CharToNumber(p_report_line_info.receipt_amount);

1744: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1745: l_receiptAmount := null; -- initialize it since it will be used later
1746: BEGIN
1747: if (p_report_line_info.receipt_amount is not NULL) then
1748: l_receiptAmount := AP_WEB_DB_UTIL_PKG.CharToNumber(p_report_line_info.receipt_amount);
1749: if CheckNum(l_receiptAmount, p_exp_error, p_receiptcount,
1750: C_RecAmt_Prompt, p_allow_credit_lines, FALSE) then
1751: --
1752: -- If l_dailyAmount and l_receiptAmount are both not null and zero then

Line 1969: l_num := AP_WEB_DB_UTIL_PKG.CharToNumber(p_report_line_info.amount);

1965: --
1966: if (p_report_line_info.amount is not null and
1967: p_report_line_info.itemization_parent_id <> '-1') then
1968: BEGIN
1969: l_num := AP_WEB_DB_UTIL_PKG.CharToNumber(p_report_line_info.amount);
1970: if CheckNum(l_num, p_exp_error, p_receiptcount,
1971: C_Amount_Prompt, p_allow_credit_lines, FALSE) then
1972: --
1973: -- If Amount does not match value calculated from Daily amount,