DBA Data[Home] [Help]

APPS.AP_WEB_VALIDATE_UTIL dependencies on AP_WEB_DB_UTIL_PKG

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

784: l_date_format := nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'));
785:
786: -- Update the calling sequence
787: --
788: IF (NOT AP_WEB_DB_UTIL_PKG.GetFormattedSysDate(l_date_format, l_last_receipt)) THEN
789: NULL;
790: END IF;
791:
792: current_calling_sequence := 'AP_WEB_VALIDATE_UTIL.ValidateReportHeader';

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

1442: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_VALIDATE_UTIL', 'start ValidateExpLineCoreFields');
1443: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;
1444:
1445: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_FIXED');
1446: l_fixed_msg := AP_WEB_DB_UTIL_PKG.jsPrepString(fnd_message.get_encoded(), TRUE);
1447:
1448: l_reimbcurr_format := FND_CURRENCY.get_format_mask(p_report_header_info.reimbursement_currency_code, 30);
1449:
1450: if (p_report_header_info.transaction_currency_type = 'reimbursement') then

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

1682: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1683: l_dailyAmount := null; -- initialize it since it will be used later!
1684: if (p_report_line_info.daily_amount IS NOT NULL) then
1685: BEGIN
1686: l_dailyAmount := AP_WEB_DB_UTIL_PKG.CharToNumber(p_report_line_info.daily_amount);
1687: if CheckNum(l_dailyAmount, p_exp_error, p_receiptcount,
1688: C_DAmount_Prompt, p_allow_credit_lines, FALSE) then
1689: -- p_report_line_info.daily_amount := to_char(l_num);
1690: NULL;

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

1710: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1711: l_receiptAmount := null; -- initialize it since it will be used later
1712: BEGIN
1713: if (p_report_line_info.receipt_amount is not NULL) then
1714: l_receiptAmount := AP_WEB_DB_UTIL_PKG.CharToNumber(p_report_line_info.receipt_amount);
1715: if CheckNum(l_receiptAmount, p_exp_error, p_receiptcount,
1716: C_RecAmt_Prompt, p_allow_credit_lines, FALSE) then
1717: --
1718: -- If l_dailyAmount and l_receiptAmount are both not null and zero then

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

1931: --
1932: if (p_report_line_info.amount is not null and
1933: p_report_line_info.itemization_parent_id <> '-1') then
1934: BEGIN
1935: l_num := AP_WEB_DB_UTIL_PKG.CharToNumber(p_report_line_info.amount);
1936: if CheckNum(l_num, p_exp_error, p_receiptcount,
1937: C_Amount_Prompt, p_allow_credit_lines, FALSE) then
1938: --
1939: -- If Amount does not match value calculated from Daily amount,