eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_VALIDATE_UTIL dependencies on AP_WEB_UTILITIES_PKG

Line 40: p_errors in out nocopy AP_WEB_UTILITIES_PKG.expError,

36:
37:
38: Function CheckNum
39: (p_num in number,
40: p_errors in out nocopy AP_WEB_UTILITIES_PKG.expError,
41: p_index in number,
42: p_prompt in varchar2,
43: p_allow_negative in boolean default TRUE,
44: p_absolute in boolean default FALSE) Return Boolean IS

Line 50: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;

46: l_IsMobileApp boolean;
47:
48: BEGIN
49:
50: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;
51:
52: if (p_allow_negative) then
53: return TRUE;
54: else

Line 59: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,

55: if (((p_num < 0) AND (NOT p_absolute)) OR
56: ((p_num <= 0) AND (p_absolute))) then
57: fnd_message.set_name('SQLAP', 'AP_WEB_NOT_POS_NUM');
58: fnd_message.set_token('VALUE', to_char(p_num));
59: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
60: fnd_message.get_encoded(),
61: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
62: p_prompt,
63: p_index,

Line 61: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

57: fnd_message.set_name('SQLAP', 'AP_WEB_NOT_POS_NUM');
58: fnd_message.set_token('VALUE', to_char(p_num));
59: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
60: fnd_message.get_encoded(),
61: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
62: p_prompt,
63: p_index,
64: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
65: return false;

Line 64: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

60: fnd_message.get_encoded(),
61: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
62: p_prompt,
63: p_index,
64: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
65: return false;
66: end if; /* p_num < 0 */
67: end if;
68: return true;

Line 73: p_receipt_errors in out nocopy AP_WEB_UTILITIES_PKG.receipt_error_stack,

69: END CheckNum;
70:
71: Function CheckPosNum
72: (p_num in number,
73: p_receipt_errors in out nocopy AP_WEB_UTILITIES_PKG.receipt_error_stack,
74: p_index in number,
75: p_prompt in varchar2,
76: p_absolute in boolean default FALSE) Return Boolean IS
77: BEGIN

Line 82: AP_WEB_UTILITIES_PKG.AddMessage(p_receipt_errors,

78: if (((p_num < 0) AND (NOT p_absolute)) OR
79: ((p_num <= 0) AND (p_absolute))) then
80: fnd_message.set_name('SQLAP', 'AP_WEB_NOT_POS_NUM');
81: fnd_message.set_token('VALUE', to_char(p_num));
82: AP_WEB_UTILITIES_PKG.AddMessage(p_receipt_errors,
83: p_index,
84: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
85: fnd_message.get_encoded(),
86: p_prompt);

Line 84: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

80: fnd_message.set_name('SQLAP', 'AP_WEB_NOT_POS_NUM');
81: fnd_message.set_token('VALUE', to_char(p_num));
82: AP_WEB_UTILITIES_PKG.AddMessage(p_receipt_errors,
83: p_index,
84: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
85: fnd_message.get_encoded(),
86: p_prompt);
87:
88: return false;

Line 173: p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,

169: p_num_max_flex_field IN NUMBER,
170: P_IsSessionTaxEnabled IN VARCHAR2,
171: P_IsSessionProjectEnabled IN VARCHAR2,
172: p_receipts_count IN BINARY_INTEGER,
173: p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
174: p_receipts_with_errors_count IN OUT NOCOPY BINARY_INTEGER,
175: p_calculate_receipt_index IN BINARY_INTEGER,
176: p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
177: p_addon_rates IN OIE_ADDON_RATES_T DEFAULT NuLL,

Line 176: p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,

172: p_receipts_count IN BINARY_INTEGER,
173: p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
174: p_receipts_with_errors_count IN OUT NOCOPY BINARY_INTEGER,
175: p_calculate_receipt_index IN BINARY_INTEGER,
176: p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
177: p_addon_rates IN OIE_ADDON_RATES_T DEFAULT NuLL,
178: p_report_line_id IN NUMBER DEFAULT NULL,
179: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
180: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,

Line 227: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;

223: l_vend_pay_curr_name AP_WEB_DB_COUNTRY_PKG.curr_name;
224:
225: BEGIN
226:
227: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;
228:
229: IF (p_receipts_count = 0) THEN
230: RETURN;
231: END IF;

Line 560: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get_encoded());

556: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
557: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','ValidateApprover');
558: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
559: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
560: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get_encoded());
561: END IF;
562: END;
563: END IF; -- IF (p_approverID IS NOT NULL) THEN
564:

Line 595: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;

591:
592: BEGIN
593:
594:
595: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;
596:
597: --
598: -- Call custom cost center validation API
599: --

Line 709: p_Error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError

705:
706: ---------------------------------------------------------------
707: PROCEDURE ValidateReportHeader(
708: ExpReportHeaderInfo IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
709: p_Error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError
710:
711: ) IS
712: ---------------------------------------------------------------
713: l_FuncCode varchar2(50) := 'AP_WEB_EXPENSES';

Line 744: p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,

740: *----------------------------------------------------------------------------*/
741: PROCEDURE ValidateHeaderNoValidSession(
742: p_user_id IN NUMBER, -- 2242176, fnd user id
743: ExpReportHeaderInfo IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
744: p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
745: p_bFull_Approver_Validation IN BOOLEAN
746:
747: ) IS
748: ---------------------------------------------------------------

Line 779: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;

775: l_default_reimb_curr FND_CURRENCIES_VL.currency_code%TYPE;
776:
777: BEGIN
778:
779: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;
780:
781:
782: -- Get date mask
783: --Bug 3336823

Line 802: l_allow_overrider := AP_WEB_UTILITIES_PKG.value_specific(

798: debug_info := 'Validate Override Approver';
799:
800: -- Bug 3525089 : Setting up l_allow_overrider, so that if p_bFull_Approver_Validation = false
801: -- then ValidateApprover gets called
802: l_allow_overrider := AP_WEB_UTILITIES_PKG.value_specific(
803: p_name => 'AP_WEB_ALLOW_OVERRIDE_APPROVER',
804: p_user_id => p_user_id,
805: p_resp_id => null,
806: p_apps_id => null);

Line 810: l_overrider_CC := AP_WEB_UTILITIES_PKG.value_specific(

806: p_apps_id => null);
807:
808: IF (p_bFull_Approver_Validation) THEN
809:
810: l_overrider_CC := AP_WEB_UTILITIES_PKG.value_specific(
811: p_name => 'AP_WEB_APPROVER_REQ_CC',
812: p_user_id => p_user_id,
813: p_resp_id => null,
814: p_apps_id => null);

Line 818: AP_WEB_UTILITIES_PKG.GetEmployeeInfo(

814: p_apps_id => null);
815:
816: IF ( l_allow_overrider = 'Y' ) THEN
817: -- get the default cost center of the filer:
818: AP_WEB_UTILITIES_PKG.GetEmployeeInfo(
819: l_employee_name,
820: l_employee_num,
821: l_default_cost_center,
822: ExpReportHeaderInfo.employee_id );

Line 824: l_require_overrider := AP_WEB_UTILITIES_PKG.value_specific(

820: l_employee_num,
821: l_default_cost_center,
822: ExpReportHeaderInfo.employee_id );
823:
824: l_require_overrider := AP_WEB_UTILITIES_PKG.value_specific(
825: p_name => 'AP_WEB_OVERRIDE_APPR_REQ',
826: p_user_id => p_user_id,
827: p_resp_id => null,
828: p_apps_id => null );

Line 833: AP_WEB_UTILITIES_PKG.AddExpError(p_error,

829:
830: IF ( l_require_overrider = 'Y' OR l_require_overrider = 'D') THEN
831: IF ( ExpReportHeaderInfo.override_approver_name IS NULL ) THEN
832: fnd_message.set_name('SQLAP', 'AP_WEB_OVERRIDER_REQUIRED');
833: AP_WEB_UTILITIES_PKG.AddExpError(p_error,
834: fnd_message.get_encoded(),
835: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
836: null,
837: 0,

Line 835: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

831: IF ( ExpReportHeaderInfo.override_approver_name IS NULL ) THEN
832: fnd_message.set_name('SQLAP', 'AP_WEB_OVERRIDER_REQUIRED');
833: AP_WEB_UTILITIES_PKG.AddExpError(p_error,
834: fnd_message.get_encoded(),
835: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
836: null,
837: 0,
838: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
839: ELSE

Line 838: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

834: fnd_message.get_encoded(),
835: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
836: null,
837: 0,
838: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
839: ELSE
840: ValidateApprover(
841: ExpReportHeaderInfo.employee_id,
842: ExpReportHeaderInfo.override_approver_name,

Line 846: AP_WEB_UTILITIES_PKG.AddExpError(

842: ExpReportHeaderInfo.override_approver_name,
843: ExpReportHeaderInfo.override_approver_id,
844: l_ap_error );
845: IF ( l_ap_error IS NOT NULL ) THEN
846: AP_WEB_UTILITIES_PKG.AddExpError(
847: p_error,
848: l_ap_error,
849: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
850: 'AP_WEB_FULLNAME',

Line 849: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

845: IF ( l_ap_error IS NOT NULL ) THEN
846: AP_WEB_UTILITIES_PKG.AddExpError(
847: p_error,
848: l_ap_error,
849: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
850: 'AP_WEB_FULLNAME',
851: 0,
852: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
853: END IF;

Line 852: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

848: l_ap_error,
849: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
850: 'AP_WEB_FULLNAME',
851: 0,
852: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
853: END IF;
854:
855: END IF;
856: ELSIF (l_require_overrider = 'N' AND ExpReportHeaderInfo.override_approver_name IS NOT NULL) THEN

Line 864: AP_WEB_UTILITIES_PKG.AddExpError(

860: ExpReportHeaderInfo.override_approver_id,
861: l_ap_error );
862:
863: IF ( l_ap_error IS NOT NULL ) THEN
864: AP_WEB_UTILITIES_PKG.AddExpError(
865: p_error,
866: l_ap_error,
867: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
868: 'AP_WEB_FULLNAME',

Line 867: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

863: IF ( l_ap_error IS NOT NULL ) THEN
864: AP_WEB_UTILITIES_PKG.AddExpError(
865: p_error,
866: l_ap_error,
867: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
868: 'AP_WEB_FULLNAME',
869: 0,
870: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
871: END IF;

Line 870: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

866: l_ap_error,
867: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
868: 'AP_WEB_FULLNAME',
869: 0,
870: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
871: END IF;
872: ELSIF ( l_overrider_CC = 'Y' AND ExpReportHeaderInfo.cost_center <> l_default_cost_center ) THEN
873: IF ( ExpReportHeaderInfo.override_approver_name IS NULL ) THEN
874: fnd_message.set_name('SQLAP','AP_WEB_DISCON_OVERRIDER_CC');

Line 875: AP_WEB_UTILITIES_PKG.AddExpError(

871: END IF;
872: ELSIF ( l_overrider_CC = 'Y' AND ExpReportHeaderInfo.cost_center <> l_default_cost_center ) THEN
873: IF ( ExpReportHeaderInfo.override_approver_name IS NULL ) THEN
874: fnd_message.set_name('SQLAP','AP_WEB_DISCON_OVERRIDER_CC');
875: AP_WEB_UTILITIES_PKG.AddExpError(
876: p_error,
877: fnd_message.get_encoded(),
878: AP_WEB_UTILITIES_PKG.C_ErrorMessageType ,
879: null,

Line 878: AP_WEB_UTILITIES_PKG.C_ErrorMessageType ,

874: fnd_message.set_name('SQLAP','AP_WEB_DISCON_OVERRIDER_CC');
875: AP_WEB_UTILITIES_PKG.AddExpError(
876: p_error,
877: fnd_message.get_encoded(),
878: AP_WEB_UTILITIES_PKG.C_ErrorMessageType ,
879: null,
880: 0,
881: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
882: ELSE

Line 881: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

877: fnd_message.get_encoded(),
878: AP_WEB_UTILITIES_PKG.C_ErrorMessageType ,
879: null,
880: 0,
881: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
882: ELSE
883: ValidateApprover(
884: ExpReportHeaderInfo.employee_id,
885: ExpReportHeaderInfo.override_approver_name,

Line 890: AP_WEB_UTILITIES_PKG.AddExpError(

886: ExpReportHeaderInfo.override_approver_id,
887: l_ap_error );
888:
889: IF ( l_ap_error IS NOT NULL ) THEN
890: AP_WEB_UTILITIES_PKG.AddExpError(
891: p_error,
892: l_ap_error,
893: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
894: 'AP_WEB_FULLNAME',

Line 893: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

889: IF ( l_ap_error IS NOT NULL ) THEN
890: AP_WEB_UTILITIES_PKG.AddExpError(
891: p_error,
892: l_ap_error,
893: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
894: 'AP_WEB_FULLNAME',
895: 0,
896: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
897: END IF;

Line 896: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

892: l_ap_error,
893: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
894: 'AP_WEB_FULLNAME',
895: 0,
896: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
897: END IF;
898: END IF;
899: END IF;
900: END IF;

Line 912: AP_WEB_UTILITIES_PKG.AddExpError(

908: ExpReportHeaderInfo.override_approver_id,
909: l_ap_error );
910:
911: IF ( l_ap_error IS NOT NULL ) THEN
912: AP_WEB_UTILITIES_PKG.AddExpError(
913: p_error,
914: l_ap_error,
915: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
916: 'AP_WEB_FULLNAME',

Line 915: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

911: IF ( l_ap_error IS NOT NULL ) THEN
912: AP_WEB_UTILITIES_PKG.AddExpError(
913: p_error,
914: l_ap_error,
915: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
916: 'AP_WEB_FULLNAME',
917: 0,
918: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
919: END IF;

Line 918: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

914: l_ap_error,
915: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
916: 'AP_WEB_FULLNAME',
917: 0,
918: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
919: END IF;
920: END IF;
921: END IF;
922: END IF;

Line 931: AP_WEB_UTILITIES_PKG.AddExpError(

927: fnd_message.set_name( 'SQLAP', 'AP_WEB_COST_CENTER_INVALID' );
928: else
929: fnd_message.set_name( 'SQLAP', 'AP_OME_COST_CENTER_ERROR' );
930: end if;
931: AP_WEB_UTILITIES_PKG.AddExpError(
932: p_error,
933: fnd_message.get_encoded(),
934: AP_WEB_UTILITIES_PKG.C_errorMessageType,
935: 'txtCostCenter',

Line 934: AP_WEB_UTILITIES_PKG.C_errorMessageType,

930: end if;
931: AP_WEB_UTILITIES_PKG.AddExpError(
932: p_error,
933: fnd_message.get_encoded(),
934: AP_WEB_UTILITIES_PKG.C_errorMessageType,
935: 'txtCostCenter',
936: 0,
937: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
938: ELSE

Line 937: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

933: fnd_message.get_encoded(),
934: AP_WEB_UTILITIES_PKG.C_errorMessageType,
935: 'txtCostCenter',
936: 0,
937: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
938: ELSE
939: AP_WEB_VALIDATE_UTIL.ValidateCostCenter(
940: ExpReportHeaderInfo.cost_center,
941: l_cs_error,

Line 945: AP_WEB_UTILITIES_PKG.AddExpError(

941: l_cs_error,
942: ExpReportHeaderInfo.employee_id );
943:
944: IF ( l_cs_error IS NOT NULL ) THEN
945: AP_WEB_UTILITIES_PKG.AddExpError(
946: p_error,
947: l_cs_error,
948: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
949: 'txtCostCenter',

Line 948: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

944: IF ( l_cs_error IS NOT NULL ) THEN
945: AP_WEB_UTILITIES_PKG.AddExpError(
946: p_error,
947: l_cs_error,
948: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
949: 'txtCostCenter',
950: 0,
951: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory,
952: l_IsMobileApp);

Line 951: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory,

947: l_cs_error,
948: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
949: 'txtCostCenter',
950: 0,
951: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory,
952: l_IsMobileApp);
953: END IF;
954: END IF;
955:

Line 971: AP_WEB_UTILITIES_PKG.AddExpError(p_error,

967:
968: EXCEPTION
969: when OTHERS then
970: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_TEMP_INVALID');
971: AP_WEB_UTILITIES_PKG.AddExpError(p_error,
972: fnd_message.get_encoded(),
973: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
974: 'TEMPLATE',
975: 0,

Line 973: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

969: when OTHERS then
970: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_TEMP_INVALID');
971: AP_WEB_UTILITIES_PKG.AddExpError(p_error,
972: fnd_message.get_encoded(),
973: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
974: 'TEMPLATE',
975: 0,
976: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
977: END;

Line 976: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

972: fnd_message.get_encoded(),
973: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
974: 'TEMPLATE',
975: 0,
976: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
977: END;
978:
979: -- Validate Last Receipt Date
980: debug_info := 'Validating Last Receipt Date';

Line 992: AP_WEB_UTILITIES_PKG.AddExpError(

988: END IF;
989: EXCEPTION
990: WHEN OTHERS THEN
991: FND_MESSAGE.SET_NAME( 'SQLAP','AP_WEB_LAST_RECDATE_INVALID' );
992: AP_WEB_UTILITIES_PKG.AddExpError(
993: p_error,
994: fnd_message.get_encoded(),
995: AP_WEB_UTILITIES_PKG.C_errorMessageType,
996: 'popEmployeeID',

Line 995: AP_WEB_UTILITIES_PKG.C_errorMessageType,

991: FND_MESSAGE.SET_NAME( 'SQLAP','AP_WEB_LAST_RECDATE_INVALID' );
992: AP_WEB_UTILITIES_PKG.AddExpError(
993: p_error,
994: fnd_message.get_encoded(),
995: AP_WEB_UTILITIES_PKG.C_errorMessageType,
996: 'popEmployeeID',
997: 0,
998: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
999:

Line 998: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

994: fnd_message.get_encoded(),
995: AP_WEB_UTILITIES_PKG.C_errorMessageType,
996: 'popEmployeeID',
997: 0,
998: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
999:
1000: END;
1001:
1002: -- For bug fix 1865355

Line 1004: l_exp_reimb_curr_profile := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(

1000: END;
1001:
1002: -- For bug fix 1865355
1003: -- Validate reimbursement currency
1004: l_exp_reimb_curr_profile := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(
1005: p_name => 'AP_WEB_ALLOW_NON_BASE_REIMB',
1006: p_user_id => p_user_id,
1007: p_resp_id => null,
1008: p_apps_id => null);

Line 1024: AP_WEB_UTILITIES_PKG.AddExpError(p_error,

1020: IF ( ExpReportHeaderInfo.reimbursement_currency_code <> l_default_reimb_curr ) THEN
1021: ExpReportHeaderInfo.reimbursement_currency_code := l_default_reimb_curr;
1022: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_INVALID_REIMB_CURR');
1023: FND_MESSAGE.SET_TOKEN('FUNCTIONAL_CURRENCY',l_default_reimb_curr);
1024: AP_WEB_UTILITIES_PKG.AddExpError(p_error,
1025: fnd_message.get_encoded(),
1026: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
1027: END IF;
1028: END IF;

Line 1026: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);

1022: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_INVALID_REIMB_CURR');
1023: FND_MESSAGE.SET_TOKEN('FUNCTIONAL_CURRENCY',l_default_reimb_curr);
1024: AP_WEB_UTILITIES_PKG.AddExpError(p_error,
1025: fnd_message.get_encoded(),
1026: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
1027: END IF;
1028: END IF;
1029:
1030: EXCEPTION

Line 1086: p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,

1082: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1083: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1084: P_IsSessionTaxEnabled IN VARCHAR2,
1085: P_IsSessionProjectEnabled IN VARCHAR2,
1086: p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
1087: p_calculate_receipt_index IN BINARY_INTEGER,
1088: p_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
1089: p_receipts_with_errors_count IN OUT NOCOPY BINARY_INTEGER,
1090: p_DataDefaultedUpdateable IN OUT NOCOPY BOOLEAN,

Line 1088: p_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,

1084: P_IsSessionTaxEnabled IN VARCHAR2,
1085: P_IsSessionProjectEnabled IN VARCHAR2,
1086: p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
1087: p_calculate_receipt_index IN BINARY_INTEGER,
1088: p_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
1089: p_receipts_with_errors_count IN OUT NOCOPY BINARY_INTEGER,
1090: p_DataDefaultedUpdateable IN OUT NOCOPY BOOLEAN,
1091: p_bCalling_from_disconnected IN BOOLEAN,
1092: p_bForBlueGray IN BOOLEAN default FALSE,

Line 1137: l_error1 AP_WEB_UTILITIES_PKG.expError;

1133: V_Field2 NUMBER;
1134:
1135: V_AcctRawCost NUMBER; -- For PATC: Raw cost in functional currency
1136:
1137: l_error1 AP_WEB_UTILITIES_PKG.expError;
1138: l_error2 AP_WEB_UTILITIES_PKG.expError;
1139: l_invRate VARCHAR2(1) := 'N';
1140: l_calc_amt_enabled_for_disc BOOLEAN := FALSE;
1141:

Line 1138: l_error2 AP_WEB_UTILITIES_PKG.expError;

1134:
1135: V_AcctRawCost NUMBER; -- For PATC: Raw cost in functional currency
1136:
1137: l_error1 AP_WEB_UTILITIES_PKG.expError;
1138: l_error2 AP_WEB_UTILITIES_PKG.expError;
1139: l_invRate VARCHAR2(1) := 'N';
1140: l_calc_amt_enabled_for_disc BOOLEAN := FALSE;
1141:
1142: V_EnteredByUserID VARCHAR2(100);

Line 1154: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', 'start ValidateExpLineCustomFields');

1150: l_CostCenterErrorMsg VARCHAR2(2000) := NULL;
1151:
1152: BEGIN
1153:
1154: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', 'start ValidateExpLineCustomFields');
1155: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;
1156:
1157:
1158: -- Validate descriptive flexfields and call custom validation hook for both

Line 1155: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;

1151:
1152: BEGIN
1153:
1154: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', 'start ValidateExpLineCustomFields');
1155: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;
1156:
1157:
1158: -- Validate descriptive flexfields and call custom validation hook for both
1159: -- core and descriptive flexfields

Line 1161: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);

1157:
1158: -- Validate descriptive flexfields and call custom validation hook for both
1159: -- core and descriptive flexfields
1160: l_debug_info := 'Validate desc flexfields and custom validation hook';
1161: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1162: IF p_report_header_info.number_max_flexfield > 0 THEN
1163:
1164: -- validate only if an expense type is specified
1165: IF p_report_line_info.parameter_id IS NOT NULL THEN

Line 1169: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);

1165: IF p_report_line_info.parameter_id IS NOT NULL THEN
1166:
1167: -----------------------------------------------------
1168: l_debug_info := 'GetReceiptCustomFields';
1169: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1170: -----------------------------------------------------
1171:
1172: AP_WEB_DFLEX_PKG.GetReceiptCustomFields(l_receipt_custom_fields_array,
1173: p_receipt_index,

Line 1192: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);

1188: p_custom15_array);
1189:
1190: -----------------------------------------------------
1191: l_debug_info := 'ValidateReceiptCustomFields';
1192: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1193: -----------------------------------------------------
1194: AP_WEB_DFLEX_PKG.ValidateReceiptCustomFields(p_userId,
1195: p_report_header_info,
1196: p_report_line_info,

Line 1206: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);

1202: p_receipts_with_errors_count := p_receipts_with_errors_count + l_error1.COUNT;
1203:
1204: -- Call custom validation hook for both core and pseudo descriptive flexfields
1205: l_debug_info := 'Call custom validation hook for both core and pseudo descriptive flexfields';
1206: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1207: AP_WEB_CUST_DFLEX_PKG.CustomValidateLine(p_report_header_info,
1208: p_report_line_info,
1209: l_receipt_custom_fields_array,
1210: l_error2);

Line 1214: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);

1210: l_error2);
1211:
1212: -----------------------------------------------------
1213: l_debug_info := 'PropogateReceiptCustFldsInfo';
1214: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1215: -----------------------------------------------------
1216: AP_WEB_DFLEX_PKG.PropogateReceiptCustFldsInfo(
1217: l_receipt_custom_fields_array,
1218: p_receipt_index,

Line 1242: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);

1238: -- Call custom validation hook for both core and pseudo descriptive flexfields
1239: l_debug_info := 'Call custom validation hook';
1240: -- Bug: 6617094, Expense type is null in Custom Validation.
1241: AP_WEB_DFLEX_PKG.PopulateExpTypeInLineRec(p_report_line_info);
1242: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1243: AP_WEB_CUST_DFLEX_PKG.CustomValidateLine(p_report_header_info,
1244: p_report_line_info,
1245: l_receipt_custom_fields_array,
1246: l_error2);

Line 1326: l_invRate := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(

1322:
1323: ----------------------------------------------
1324: l_debug_info := 'Recalculate Amount';
1325: ----------------------------------------------
1326: l_invRate := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(
1327: p_name => 'DISPLAY_INVERSE_RATE',
1328: p_user_id => p_userId,
1329: p_resp_id => null,
1330: p_apps_id => null);

Line 1355: AP_WEB_UTILITIES_PKG.MergeExpErrors( p_errors, l_error1 );

1351: END IF;
1352:
1353:
1354: --chiho:1346208:
1355: AP_WEB_UTILITIES_PKG.MergeExpErrors( p_errors, l_error1 );
1356:
1357: AP_WEB_UTILITIES_PKG.MergeExpErrors(p_errors, l_error2);
1358:
1359: EXCEPTION

Line 1357: AP_WEB_UTILITIES_PKG.MergeExpErrors(p_errors, l_error2);

1353:
1354: --chiho:1346208:
1355: AP_WEB_UTILITIES_PKG.MergeExpErrors( p_errors, l_error1 );
1356:
1357: AP_WEB_UTILITIES_PKG.MergeExpErrors(p_errors, l_error2);
1358:
1359: EXCEPTION
1360: WHEN OTHERS THEN
1361: BEGIN

Line 1399: p_exp_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError)

1395: p_allow_credit_lines IN BOOLEAN,
1396: p_justreq_array IN AP_WEB_PARENT_PKG.Number_Array,
1397: p_reimbcurr_precision IN FND_CURRENCIES_VL.PRECISION%TYPE,
1398: p_calculate_receipt_index IN BINARY_INTEGER,
1399: p_exp_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError)
1400: -----------------------------------------------------------------------------
1401: IS
1402:
1403: /* Note: p_receipt_errors might not be empty -- Validation in disconnected

Line 1442: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_VALIDATE_UTIL', 'start ValidateExpLineCoreFields');

1438: l_IsMobileApp boolean;
1439:
1440: BEGIN
1441:
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);

Line 1443: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;

1439:
1440: BEGIN
1441:
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:

Line 1458: l_inverse_rate_profile := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(

1454: --Bug 3336823
1455: l_date_format := nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'));
1456:
1457:
1458: l_inverse_rate_profile := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(
1459: p_name => 'DISPLAY_INVERSE_RATE',
1460: p_user_id => p_user_id,
1461: p_resp_id => null,
1462: p_apps_id => null);

Line 1467: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);

1463:
1464: l_fixed_rate_applied := 'N';
1465:
1466: debug_info:='checking trans';
1467: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1468: l_dates_ok := true;
1469: if (p_report_header_info.transaction_currency_type = 'multi') then
1470: l_reccurr_format :=
1471: FND_CURRENCY.get_format_mask(p_report_line_info.currency_code, 30);

Line 1477: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);

1473: --
1474: -- Check if Valid Start Date was entered
1475: --
1476: debug_info:='Check Start Date';
1477: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1478: if (p_report_line_info.start_date is null) then
1479: l_dates_ok := false;
1480: fnd_message.set_name('SQLAP', 'AP_WEB_ST_DATE_FIRST');
1481: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

Line 1481: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1477: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1478: if (p_report_line_info.start_date is null) then
1479: l_dates_ok := false;
1480: fnd_message.set_name('SQLAP', 'AP_WEB_ST_DATE_FIRST');
1481: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1482: fnd_message.get_encoded(),
1483: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1484: C_Date1_Prompt,
1485: p_receiptcount,

Line 1483: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1479: l_dates_ok := false;
1480: fnd_message.set_name('SQLAP', 'AP_WEB_ST_DATE_FIRST');
1481: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1482: fnd_message.get_encoded(),
1483: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1484: C_Date1_Prompt,
1485: p_receiptcount,
1486: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1487: else

Line 1486: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1482: fnd_message.get_encoded(),
1483: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1484: C_Date1_Prompt,
1485: p_receiptcount,
1486: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1487: else
1488: BEGIN
1489: --Bug 6054643: Removing the to_date conversion
1490: l_date1_temp := trunc(p_report_line_info.start_date);

Line 1497: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1493: if (NOT IsValidYear(l_date1_temp) AND (p_report_line_info.category_code <> 'PER_DIEM') )THEN
1494: l_dates_ok := false;
1495: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR');
1496: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1497: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1498: fnd_message.get_encoded(),
1499: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1500: C_Date1_Prompt,
1501: p_receiptcount,

Line 1499: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1495: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR');
1496: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1497: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1498: fnd_message.get_encoded(),
1499: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1500: C_Date1_Prompt,
1501: p_receiptcount,
1502: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1503: end if;

Line 1502: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1498: fnd_message.get_encoded(),
1499: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1500: C_Date1_Prompt,
1501: p_receiptcount,
1502: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1503: end if;
1504:
1505: l_acdate := l_date1_temp;
1506:

Line 1521: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1517: l_dates_ok := false;
1518: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_START_DATE_INVALID');
1519: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);
1520: FND_MESSAGE.SET_TOKEN('PROPER_FORMAT', to_char(sysdate, l_date_format));
1521: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1522: fnd_message.get_encoded(),
1523: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1524: C_Date1_Prompt,
1525: p_receiptcount,

Line 1523: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1519: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);
1520: FND_MESSAGE.SET_TOKEN('PROPER_FORMAT', to_char(sysdate, l_date_format));
1521: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1522: fnd_message.get_encoded(),
1523: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1524: C_Date1_Prompt,
1525: p_receiptcount,
1526: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1527:

Line 1526: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1522: fnd_message.get_encoded(),
1523: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1524: C_Date1_Prompt,
1525: p_receiptcount,
1526: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1527:
1528: END;
1529: end if; /* date 1 is null */
1530:

Line 1535: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);

1531: --
1532: -- Check if Valid End Date was entered
1533: --
1534: debug_info := 'Check End Date';
1535: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1536: BEGIN
1537: --Bug 6054643: Removing the to_date conversion
1538: l_date2_temp := trunc(nvl(p_report_line_info.end_date, l_date1_temp));
1539:

Line 1552: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1548: if (NOT IsValidYear(l_date1_temp)) THEN
1549: l_dates_ok := false;
1550: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR_START_DATE');
1551: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1552: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1553: fnd_message.get_encoded(),
1554: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1555: C_Date1_Prompt,
1556: p_receiptcount,

Line 1554: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1550: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR_START_DATE');
1551: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1552: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1553: fnd_message.get_encoded(),
1554: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1555: C_Date1_Prompt,
1556: p_receiptcount,
1557: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1558: end if;

Line 1557: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1553: fnd_message.get_encoded(),
1554: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1555: C_Date1_Prompt,
1556: p_receiptcount,
1557: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1558: end if;
1559: -- Bug 6392916 (sodash)
1560: -- Checking whether entering the end date is compulsory for the Per Diem Schedule
1561: select TIME_BASED_ENTRY_FLAG into l_time_based_entry_flag from AP_POL_HEADERS aph, AP_EXPENSE_REPORT_PARAMS_ALL param where aph.POLICY_ID = param.COMPANY_POLICY_ID and param.PARAMETER_ID = p_report_line_info.parameter_id;

Line 1568: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1564: NOT IsValidYear(l_date2_temp)) THEN
1565: l_dates_ok := false;
1566: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR_END_DATE');
1567: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1568: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1569: fnd_message.get_encoded(),
1570: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1571: C_Date2_Prompt,
1572: p_receiptcount,

Line 1570: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1566: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR_END_DATE');
1567: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1568: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1569: fnd_message.get_encoded(),
1570: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1571: C_Date2_Prompt,
1572: p_receiptcount,
1573: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1574: end if;

Line 1573: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1569: fnd_message.get_encoded(),
1570: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1571: C_Date2_Prompt,
1572: p_receiptcount,
1573: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1574: end if;
1575: END IF;
1576:
1577: l_acdate := l_date2_temp;

Line 1589: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1585: l_dates_ok := false;
1586: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_END_DATE_INVALID');
1587: FND_MESSAGE.SET_TOKEN('END_DATE', p_report_line_info.end_date);
1588: FND_MESSAGE.SET_TOKEN('PROPER_FORMAT', to_char(sysdate, l_date_format));
1589: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1590: fnd_message.get_encoded(),
1591: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1592: C_Date2_Prompt,
1593: p_receiptcount,

Line 1591: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1587: FND_MESSAGE.SET_TOKEN('END_DATE', p_report_line_info.end_date);
1588: FND_MESSAGE.SET_TOKEN('PROPER_FORMAT', to_char(sysdate, l_date_format));
1589: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1590: fnd_message.get_encoded(),
1591: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1592: C_Date2_Prompt,
1593: p_receiptcount,
1594: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1595: END;

Line 1594: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1590: fnd_message.get_encoded(),
1591: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1592: C_Date2_Prompt,
1593: p_receiptcount,
1594: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1595: END;
1596:
1597: --
1598: -- Check if End Date falls on or after Start Date

Line 1602: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);

1598: -- Check if End Date falls on or after Start Date
1599: -- Only do it when both dates' format is fine.
1600: --
1601: debug_info:= 'Day1 < Day2?';
1602: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1603: if (l_dates_ok) then
1604: if (l_date1_temp > nvl(l_date2_temp, l_date1_temp)) then
1605: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_START_AFTER_END');
1606: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);

Line 1608: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1604: if (l_date1_temp > nvl(l_date2_temp, l_date1_temp)) then
1605: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_START_AFTER_END');
1606: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);
1607: FND_MESSAGE.SET_TOKEN('END_DATE', p_report_line_info.end_date);
1608: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1609: fnd_message.get_encoded(),
1610: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1611: C_Date2_Prompt,
1612: p_receiptcount,

Line 1610: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1606: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);
1607: FND_MESSAGE.SET_TOKEN('END_DATE', p_report_line_info.end_date);
1608: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1609: fnd_message.get_encoded(),
1610: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1611: C_Date2_Prompt,
1612: p_receiptcount,
1613: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1614: end if;

Line 1613: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1609: fnd_message.get_encoded(),
1610: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1611: C_Date2_Prompt,
1612: p_receiptcount,
1613: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1614: end if;
1615: end if;
1616:
1617: --

Line 1622: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);

1618: -- Check if Days is a valid number. And if days entered equals to
1619: -- actual different between the two dates.
1620: --
1621: debug_info := 'Check days';
1622: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1623: BEGIN
1624: l_num := to_number(p_report_line_info.days);
1625: if (l_dates_ok) then
1626: if (p_report_line_info.days is null) then

Line 1656: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1652: -- the real range of dates.
1653: elsif ((l_date2_temp - l_date1_temp + 1) <> l_num)
1654: then
1655: fnd_message.set_name('SQLAP', 'AP_WEB_WRONG_NUM_OF_DAYS');
1656: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1657: fnd_message.get_encoded(),
1658: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1659: C_Days_Prompt,
1660: p_receiptcount,

Line 1658: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1654: then
1655: fnd_message.set_name('SQLAP', 'AP_WEB_WRONG_NUM_OF_DAYS');
1656: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1657: fnd_message.get_encoded(),
1658: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1659: C_Days_Prompt,
1660: p_receiptcount,
1661: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1662: end if;

Line 1661: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1657: fnd_message.get_encoded(),
1658: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1659: C_Days_Prompt,
1660: p_receiptcount,
1661: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1662: end if;
1663: end if; /* l_dates_ok */
1664: EXCEPTION
1665: when OTHERS then

Line 1667: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1663: end if; /* l_dates_ok */
1664: EXCEPTION
1665: when OTHERS then
1666: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_DAYS_INVALID');
1667: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1668: fnd_message.get_encoded(),
1669: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1670: C_Days_Prompt,
1671: p_receiptcount,

Line 1669: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1665: when OTHERS then
1666: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_DAYS_INVALID');
1667: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1668: fnd_message.get_encoded(),
1669: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1670: C_Days_Prompt,
1671: p_receiptcount,
1672: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1673: END;

Line 1672: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1668: fnd_message.get_encoded(),
1669: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1670: C_Days_Prompt,
1671: p_receiptcount,
1672: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1673: END;
1674:
1675: debug_info := 'Check if the fields exist in the receipts array';
1676: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);

Line 1676: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);

1672: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1673: END;
1674:
1675: debug_info := 'Check if the fields exist in the receipts array';
1676: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1677:
1678: --
1679: -- Check if Daily Amount is a valid number.
1680: --

Line 1682: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);

1678: --
1679: -- Check if Daily Amount is a valid number.
1680: --
1681: debug_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);

Line 1696: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1692: EXCEPTION
1693: when OTHERS then
1694: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_DAILY_AMOUNT_INVALID');
1695: p_report_line_info.daily_amount := null;
1696: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1697: fnd_message.get_encoded(),
1698: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1699: C_DAmount_Prompt,
1700: p_receiptcount,

Line 1698: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1694: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_DAILY_AMOUNT_INVALID');
1695: p_report_line_info.daily_amount := null;
1696: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1697: fnd_message.get_encoded(),
1698: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1699: C_DAmount_Prompt,
1700: p_receiptcount,
1701: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1702:

Line 1701: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1697: fnd_message.get_encoded(),
1698: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1699: C_DAmount_Prompt,
1700: p_receiptcount,
1701: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1702:
1703: END;
1704: end if;
1705:

Line 1710: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);

1706: --
1707: -- Check if Receipt Amount is a valid number.
1708: --
1709: debug_info := 'Check 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);

Line 1732: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1728: end if;
1729:
1730: if ((l_receiptAmount <> 0) AND (NOT WithinTolerance(l_dailyAmount, l_amount))) then
1731: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RECEIPT_AMT_INCORRECT');
1732: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1733: fnd_message.get_encoded(),
1734: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1735: C_RecAmt_Prompt,
1736: p_receiptcount,

Line 1734: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1730: if ((l_receiptAmount <> 0) AND (NOT WithinTolerance(l_dailyAmount, l_amount))) then
1731: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RECEIPT_AMT_INCORRECT');
1732: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1733: fnd_message.get_encoded(),
1734: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1735: C_RecAmt_Prompt,
1736: p_receiptcount,
1737: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1738: elsif (l_receiptAmount = 0) then

Line 1737: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1733: fnd_message.get_encoded(),
1734: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1735: C_RecAmt_Prompt,
1736: p_receiptcount,
1737: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1738: elsif (l_receiptAmount = 0) then
1739: if (l_dailyAmount <> 0) then -- dailyAmount is valid
1740: -- Could have been pre-seeded to 0 in spreadsheet. Null it
1741: -- out since don't want to mess with currency format.

Line 1763: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1759: p_report_line_info.currency_code))) then
1760: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_CURRENCY_NO_DECIMALS');
1761: FND_MESSAGE.SET_TOKEN('RECEIPT_CURRENCY',
1762: p_report_line_info.currency_code);
1763: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1764: fnd_message.get_encoded(),
1765: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1766: C_RecAmt_Prompt,
1767: p_receiptcount,

Line 1765: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1761: FND_MESSAGE.SET_TOKEN('RECEIPT_CURRENCY',
1762: p_report_line_info.currency_code);
1763: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1764: fnd_message.get_encoded(),
1765: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1766: C_RecAmt_Prompt,
1767: p_receiptcount,
1768: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1769: end if; /* Rounding */

Line 1768: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1764: fnd_message.get_encoded(),
1765: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1766: C_RecAmt_Prompt,
1767: p_receiptcount,
1768: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1769: end if; /* Rounding */
1770:
1771: end if; /* CheckNum */
1772: end if;

Line 1777: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1773: EXCEPTION
1774: when OTHERS then
1775: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RECEIPT_AMOUNT_INVALID');
1776: p_report_line_info.receipt_amount := null;
1777: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1778: fnd_message.get_encoded(),
1779: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1780: C_RecAmt_Prompt,
1781: p_receiptcount,

Line 1779: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1775: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RECEIPT_AMOUNT_INVALID');
1776: p_report_line_info.receipt_amount := null;
1777: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1778: fnd_message.get_encoded(),
1779: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1780: C_RecAmt_Prompt,
1781: p_receiptcount,
1782: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1783:

Line 1782: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1778: fnd_message.get_encoded(),
1779: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1780: C_RecAmt_Prompt,
1781: p_receiptcount,
1782: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1783:
1784: END;
1785: -- chiho:bug#825307:extend the exception handling to include GL_CURRENCY_API.is_fixed_rate:
1786: BEGIN

Line 1791: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);

1787: --
1788: -- Check if Rate is a valid number.
1789: --
1790: debug_info := 'Check rate';
1791: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1792: IF ((p_report_line_info.currency_code =
1793: p_report_header_info.reimbursement_currency_code) OR
1794: (p_report_line_info.currency_code = 'OTHER')) THEN
1795: l_is_fixed_rate := 'N';

Line 1821: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);

1817: -- **** USED TO BE CheckPosNum
1818: if not CheckNum(l_num, p_exp_error,
1819: p_receiptcount, C_Rate_Prompt, TRUE, TRUE) then
1820: debug_info := 'rate is negative'; /* CheckPosNum is function */
1821: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1822: else
1823: IF (l_is_fixed_rate = 'Y') THEN
1824: p_report_line_info.rate:= '1'; -- Bug 1871739. Use '1' instead of l_fixed_msg
1825: ELSE

Line 1841: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1837: --
1838: if (nvl(p_report_line_info.currency_code, p_report_header_info.reimbursement_currency_code) = p_report_header_info.reimbursement_currency_code) then
1839: if ((l_num <> 1) or (l_num <> null)) then
1840: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_SAMECURR_RATE');
1841: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1842: fnd_message.get_encoded(),
1843: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1844: C_Rate_Prompt,
1845: p_receiptcount,

Line 1843: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1839: if ((l_num <> 1) or (l_num <> null)) then
1840: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_SAMECURR_RATE');
1841: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1842: fnd_message.get_encoded(),
1843: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1844: C_Rate_Prompt,
1845: p_receiptcount,
1846: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1847: -- Default rate to '1' since currency is not foreign.

Line 1846: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1842: fnd_message.get_encoded(),
1843: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1844: C_Rate_Prompt,
1845: p_receiptcount,
1846: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1847: -- Default rate to '1' since currency is not foreign.
1848: -- and adjust reimbursable amount
1849: p_report_line_info.rate:= '1'; -- Bug 2177344
1850: p_report_line_info.amount := p_report_line_info.receipt_amount;

Line 1860: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1856: EXCEPTION
1857: when OTHERS then
1858: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RATE_INVALID');
1859: p_report_line_info.rate := null;
1860: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1861: fnd_message.get_encoded(),
1862: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1863: C_Rate_Prompt,
1864: p_receiptcount,

Line 1862: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1858: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RATE_INVALID');
1859: p_report_line_info.rate := null;
1860: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1861: fnd_message.get_encoded(),
1862: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1863: C_Rate_Prompt,
1864: p_receiptcount,
1865: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1866: END;

Line 1865: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1861: fnd_message.get_encoded(),
1862: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1863: C_Rate_Prompt,
1864: p_receiptcount,
1865: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1866: END;
1867:
1868: --
1869: -- Check if (Total) Amount is a valid number.

Line 1872: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);

1868: --
1869: -- Check if (Total) Amount is a valid number.
1870: --
1871: debug_info := 'Amount';
1872: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1873: -- Only do this check in non "Calculate Amount" custom field calculation
1874: -- case.
1875:
1876: if (NOT(p_calculate_receipt_index > 0) OR

Line 1899: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);

1895: END IF;
1896:
1897: if ((l_rate > 0) AND (l_num is not null)) then
1898: debug_info := 'before calc l_amount';
1899: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1900: IF (l_is_fixed_rate = 'Y') THEN
1901: l_amount := GL_CURRENCY_API.convert_amount(
1902: p_report_line_info.currency_code,
1903: p_report_header_info.reimbursement_currency_code,

Line 1920: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);

1916: /*** Round l_amount here. ***/
1917: END IF; /* if (l_is_fixed_rate = 'Y') */
1918: else
1919: debug_info := 'l_amount is null';
1920: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1921: l_amount := null;
1922: end if; /* l_rate > 0 */
1923:
1924: EXCEPTION

Line 1979: AP_WEB_UTILITIES_PKG.AddExpError(

1975: FND_MESSAGE.SET_TOKEN('rate',to_char(l_rate));
1976: FND_MESSAGE.SET_TOKEN('result',to_char(l_amount));
1977:
1978: -- JMARY Have to create a new message for this error
1979: AP_WEB_UTILITIES_PKG.AddExpError(
1980: p_exp_error,
1981: fnd_message.get_encoded(),
1982: -- || TO_CHAR(l_orig_num) || l_cal_amount_method || TO_CHAR(l_rate) || '=' ||TO_CHAR(l_amount) ,
1983: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

Line 1983: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1979: AP_WEB_UTILITIES_PKG.AddExpError(
1980: p_exp_error,
1981: fnd_message.get_encoded(),
1982: -- || TO_CHAR(l_orig_num) || l_cal_amount_method || TO_CHAR(l_rate) || '=' ||TO_CHAR(l_amount) ,
1983: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1984: C_Amount_Prompt,
1985: p_receiptcount,
1986: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1987:

Line 1986: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1982: -- || TO_CHAR(l_orig_num) || l_cal_amount_method || TO_CHAR(l_rate) || '=' ||TO_CHAR(l_amount) ,
1983: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1984: C_Amount_Prompt,
1985: p_receiptcount,
1986: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1987:
1988: elsif (l_num = 0) then
1989: -- It could be that 0 was pre-seeded in the spreadsheet. But
1990: -- need to make sure that the calculated amount is not zero.

Line 1999: AP_WEB_UTILITIES_PKG.AddExpError(P_Exp_Error,

1995:
1996: /*
1997: IF (l_fixed_rate_applied = 'Y') THEN
1998: fnd_message.set_name('SQLAP','AP_WEB_FIXED_RATE_APPLIED');
1999: AP_WEB_UTILITIES_PKG.AddExpError(P_Exp_Error,
2000: fnd_message.get_encoded(),
2001: AP_WEB_UTILITIES_PKG.C_WarningMessageType,
2002: C_Rate_Prompt,
2003: p_receiptcount,

Line 2001: AP_WEB_UTILITIES_PKG.C_WarningMessageType,

1997: IF (l_fixed_rate_applied = 'Y') THEN
1998: fnd_message.set_name('SQLAP','AP_WEB_FIXED_RATE_APPLIED');
1999: AP_WEB_UTILITIES_PKG.AddExpError(P_Exp_Error,
2000: fnd_message.get_encoded(),
2001: AP_WEB_UTILITIES_PKG.C_WarningMessageType,
2002: C_Rate_Prompt,
2003: p_receiptcount,
2004: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2005:

Line 2004: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

2000: fnd_message.get_encoded(),
2001: AP_WEB_UTILITIES_PKG.C_WarningMessageType,
2002: C_Rate_Prompt,
2003: p_receiptcount,
2004: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2005:
2006: END IF;
2007: */
2008: end if; /* CheckNum */

Line 2012: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

2008: end if; /* CheckNum */
2009: EXCEPTION
2010: when OTHERS then
2011: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_TOTAL_AMOUNT_INVALID');
2012: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
2013: fnd_message.get_encoded(),
2014: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2015: C_Amount_Prompt,
2016: p_receiptcount,

Line 2014: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

2010: when OTHERS then
2011: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_TOTAL_AMOUNT_INVALID');
2012: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
2013: fnd_message.get_encoded(),
2014: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2015: C_Amount_Prompt,
2016: p_receiptcount,
2017: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2018: END;

Line 2017: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

2013: fnd_message.get_encoded(),
2014: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2015: C_Amount_Prompt,
2016: p_receiptcount,
2017: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2018: END;
2019: --
2020: -- If it's null, report error if daily amount and receipt amount are
2021: -- also null. Otherwise, try to calculate total amount.

Line 2027: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

2023: else
2024: if ((p_report_line_info.amount is null) AND
2025: (p_report_line_info.receipt_amount is null)) then
2026: fnd_message.set_name('SQLAP', 'AP_WEB_TOTAL_REQUIRED');
2027: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
2028: fnd_message.get_encoded(),
2029: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2030: C_Amount_Prompt,
2031: p_receiptcount,

Line 2029: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

2025: (p_report_line_info.receipt_amount is null)) then
2026: fnd_message.set_name('SQLAP', 'AP_WEB_TOTAL_REQUIRED');
2027: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
2028: fnd_message.get_encoded(),
2029: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2030: C_Amount_Prompt,
2031: p_receiptcount,
2032: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2033: else

Line 2032: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

2028: fnd_message.get_encoded(),
2029: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2030: C_Amount_Prompt,
2031: p_receiptcount,
2032: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2033: else
2034: if (p_report_header_info.transaction_currency_type = 'reimbursement') then
2035: BEGIN
2036: l_num := to_number(p_report_line_info.amount);

Line 2062: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

2058: BEGIN
2059: if (xtype_array(p_receiptcount) is null) then
2060: debug_info := 'No expense type selected';
2061: fnd_message.set_name('SQLAP', 'AP_WEB_EXPENSE_TYPE_REQUIRED');
2062: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
2063: fnd_message.get_encoded(),
2064: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2065: C_ExpType_Prompt,
2066: p_receiptcount,

Line 2064: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

2060: debug_info := 'No expense type selected';
2061: fnd_message.set_name('SQLAP', 'AP_WEB_EXPENSE_TYPE_REQUIRED');
2062: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
2063: fnd_message.get_encoded(),
2064: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2065: C_ExpType_Prompt,
2066: p_receiptcount,
2067: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2068: end if;

Line 2067: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

2063: fnd_message.get_encoded(),
2064: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2065: C_ExpType_Prompt,
2066: p_receiptcount,
2067: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2068: end if;
2069: END;
2070: */
2071:

Line 2086: AP_WEB_UTILITIES_PKG.AddExpError(P_Exp_Error,

2082: end if;
2083: if (to_number(p_report_line_info.parameter_id) = p_justreq_array(i)) then
2084:
2085: fnd_message.set_name('SQLAP', 'AP_WEB_JUSTIFICATION_REQUIRED');
2086: AP_WEB_UTILITIES_PKG.AddExpError(P_Exp_Error,
2087: fnd_message.get_encoded(),
2088: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2089: C_Just_Prompt,
2090: p_receiptcount,

Line 2088: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

2084:
2085: fnd_message.set_name('SQLAP', 'AP_WEB_JUSTIFICATION_REQUIRED');
2086: AP_WEB_UTILITIES_PKG.AddExpError(P_Exp_Error,
2087: fnd_message.get_encoded(),
2088: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2089: C_Just_Prompt,
2090: p_receiptcount,
2091: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2092: exit;

Line 2091: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

2087: fnd_message.get_encoded(),
2088: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2089: C_Just_Prompt,
2090: p_receiptcount,
2091: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2092: exit;
2093: end if;
2094: i := i + 1;
2095: end loop;

Line 2153: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,

2149: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2150: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2151: p_has_core_field_errors OUT NOCOPY BOOLEAN,
2152: p_has_custom_field_errors OUT NOCOPY BOOLEAN,
2153: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
2154: p_receipts_with_errors_count IN OUT NOCOPY BINARY_INTEGER,
2155: p_IsSessionProjectEnabled IN VARCHAR2,
2156: p_calculate_receipt_index IN BINARY_INTEGER DEFAULT NULL,
2157: p_bCalling_from_disconnected IN BOOLEAN,

Line 2207: AP_WEB_UTILITIES_PKG.InitMessages(l_receipt_count, p_receipts_errors);

2203: -- procedure.
2204: --
2205:
2206: -- Clear p_receipts_errors_custom and p_receipts_errors
2207: AP_WEB_UTILITIES_PKG.InitMessages(l_receipt_count, p_receipts_errors);
2208:
2209: FOR i IN 1 .. l_Receipt_Count LOOP
2210: l_report_line_rec := p_report_line_info(i);
2211:

Line 2315: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,

2311: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2312: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2313: p_has_core_field_errors OUT NOCOPY BOOLEAN,
2314: p_has_custom_field_errors OUT NOCOPY BOOLEAN,
2315: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
2316: p_receipts_with_errors_count IN OUT NOCOPY BINARY_INTEGER,
2317: p_IsSessionProjectEnabled IN VARCHAR2,
2318: p_receipt_index IN BINARY_INTEGER, --needed to reference CustomN_Array
2319: p_calculate_receipt_index IN BINARY_INTEGER DEFAULT NULL,

Line 2353: l_errors AP_WEB_UTILITIES_PKG.expError;

2349: ------------------------------------------------------------------------
2350: IS
2351: l_receipts_with_errors_core BINARY_INTEGER;
2352: l_receipts_with_errors_custom BINARY_INTEGER;
2353: l_errors AP_WEB_UTILITIES_PKG.expError;
2354: l_errors_custom AP_WEB_UTILITIES_PKG.expError;
2355:
2356: V_IsSessionTaxEnabled VARCHAR2(1);
2357:

Line 2354: l_errors_custom AP_WEB_UTILITIES_PKG.expError;

2350: IS
2351: l_receipts_with_errors_core BINARY_INTEGER;
2352: l_receipts_with_errors_custom BINARY_INTEGER;
2353: l_errors AP_WEB_UTILITIES_PKG.expError;
2354: l_errors_custom AP_WEB_UTILITIES_PKG.expError;
2355:
2356: V_IsSessionTaxEnabled VARCHAR2(1);
2357:
2358: l_debug_info VARCHAR2(2000);

Line 2379: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_VALIDATE_UTIL', 'start validateExpLine');

2375: l_DataDefaultedUpdateable BOOLEAN;
2376:
2377: BEGIN
2378:
2379: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_VALIDATE_UTIL', 'start validateExpLine');
2380:
2381: AP_WEB_DFLEX_PKG.IsSessionTaxEnabled(
2382: V_IsSessionTaxEnabled,
2383: p_userId); -- 2242176, fnd user id

Line 2387: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);

2383: p_userId); -- 2242176, fnd user id
2384:
2385: -- validate core lines fields
2386: l_debug_info := 'ValidateExpLinesCoreFields';
2387: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2388:
2389: -- Bug 2204539: always allow credit line for credit card receipt
2390: if (p_report_line_info.cCardTrxnId is null) then
2391: l_allow_credit_lines_profile := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(

Line 2391: l_allow_credit_lines_profile := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(

2387: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2388:
2389: -- Bug 2204539: always allow credit line for credit card receipt
2390: if (p_report_line_info.cCardTrxnId is null) then
2391: l_allow_credit_lines_profile := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(
2392: p_name => 'AP_WEB_ALLOW_CREDIT_LINES',
2393: p_user_id => p_userId,
2394: p_resp_id => null,
2395: p_apps_id => null);

Line 2425: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);

2421:
2422:
2423: -- validate flexfields
2424: l_debug_info := 'ValidateExpLinesCustomFields';
2425: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2426: l_receipts_with_errors_custom := 0;
2427:
2428: -- The following calcuations marked with "For PATC" were
2429: -- added for the R11i support for multicurrency in PA.

Line 2442: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);

2438: -- For PATC: Get information about functional currency and exchange
2439: -- rate for the last receipt date. The last receipt date will be
2440: -- equal to sysdate.
2441: l_debug_info := 'Getting functional currency and exchange rate info';
2442: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2443:
2444: -- for bug 3452403, get default currency information from header
2445: V_SysInfoRec.base_currency := p_report_header_info.default_currency_code;
2446: V_SysInfoRec.default_exchange_rate_type := p_report_header_info.default_exchange_rate_type;

Line 2525: AP_WEB_UTILITIES_PKG.AddExpError(l_errors_custom,

2521:
2522: -- bug#2188075 - Updated the amount, display a warning to the user
2523: IF (l_DataDefaultedUpdateable) THEN
2524: fnd_message.set_name('SQLAP', 'OIE_DATA_CALCULATED_DIFFER');
2525: AP_WEB_UTILITIES_PKG.AddExpError(l_errors_custom,
2526: fnd_message.get_encoded(),
2527: AP_WEB_UTILITIES_PKG.C_WarningMessageType,
2528: 'FlexField',
2529: p_receipt_index,

Line 2527: AP_WEB_UTILITIES_PKG.C_WarningMessageType,

2523: IF (l_DataDefaultedUpdateable) THEN
2524: fnd_message.set_name('SQLAP', 'OIE_DATA_CALCULATED_DIFFER');
2525: AP_WEB_UTILITIES_PKG.AddExpError(l_errors_custom,
2526: fnd_message.get_encoded(),
2527: AP_WEB_UTILITIES_PKG.C_WarningMessageType,
2528: 'FlexField',
2529: p_receipt_index,
2530: AP_WEB_UTILITIES_PKG.C_DFFMessageCategory);
2531: END IF;

Line 2530: AP_WEB_UTILITIES_PKG.C_DFFMessageCategory);

2526: fnd_message.get_encoded(),
2527: AP_WEB_UTILITIES_PKG.C_WarningMessageType,
2528: 'FlexField',
2529: p_receipt_index,
2530: AP_WEB_UTILITIES_PKG.C_DFFMessageCategory);
2531: END IF;
2532:
2533:
2534: -- determine whether there were errors in the custom field

Line 2539: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);

2535: p_has_core_field_errors := (l_receipts_with_errors_core > 0);
2536: p_has_custom_field_errors := (l_receipts_with_errors_custom > 0);
2537:
2538: l_debug_info := 'merge error stacks';
2539: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2540:
2541: AP_WEB_UTILITIES_PKG.MergeExpErrors(l_errors,
2542: l_errors_custom);
2543:

Line 2541: AP_WEB_UTILITIES_PKG.MergeExpErrors(l_errors,

2537:
2538: l_debug_info := 'merge error stacks';
2539: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2540:
2541: AP_WEB_UTILITIES_PKG.MergeExpErrors(l_errors,
2542: l_errors_custom);
2543:
2544: AP_WEB_UTILITIES_PKG.MergeErrors(l_errors,
2545: p_receipts_errors);

Line 2544: AP_WEB_UTILITIES_PKG.MergeErrors(l_errors,

2540:
2541: AP_WEB_UTILITIES_PKG.MergeExpErrors(l_errors,
2542: l_errors_custom);
2543:
2544: AP_WEB_UTILITIES_PKG.MergeErrors(l_errors,
2545: p_receipts_errors);
2546:
2547: p_receipts_with_errors_count :=
2548: AP_WEB_UTILITIES_PKG.NumOfReceiptWithError(p_receipts_errors);

Line 2548: AP_WEB_UTILITIES_PKG.NumOfReceiptWithError(p_receipts_errors);

2544: AP_WEB_UTILITIES_PKG.MergeErrors(l_errors,
2545: p_receipts_errors);
2546:
2547: p_receipts_with_errors_count :=
2548: AP_WEB_UTILITIES_PKG.NumOfReceiptWithError(p_receipts_errors);
2549:
2550:
2551: EXCEPTION
2552: WHEN OTHERS THEN

Line 2710: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);

2706: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2707: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_CurrentCallingSequence);
2708: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
2709: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_DebugInfo);
2710: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2711: END;
2712:
2713: END MapColumnToCustomFields;
2714:

Line 2722: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);

2718: l_just_required_cursor AP_WEB_DB_EXPTEMPLATE_PKG.JustificationExpTypeCursor;
2719: i INTEGER;
2720: BEGIN
2721: l_debug_info := 'Fill justification required array';
2722: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2723: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetJustifReqdExpTypesCursor(l_just_required_cursor)) THEN
2724: i := 1;
2725: LOOP
2726: FETCH l_just_required_cursor INTO C_justreq_array(i);