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 598: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;

594:
595: BEGIN
596:
597:
598: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;
599:
600: --
601: -- Call custom cost center validation API
602: --

Line 743: p_Error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError

739:
740: ---------------------------------------------------------------
741: PROCEDURE ValidateReportHeader(
742: ExpReportHeaderInfo IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
743: p_Error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError
744:
745: ) IS
746: ---------------------------------------------------------------
747: l_FuncCode varchar2(50) := 'AP_WEB_EXPENSES';

Line 778: p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,

774: *----------------------------------------------------------------------------*/
775: PROCEDURE ValidateHeaderNoValidSession(
776: p_user_id IN NUMBER, -- 2242176, fnd user id
777: ExpReportHeaderInfo IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
778: p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
779: p_bFull_Approver_Validation IN BOOLEAN
780:
781: ) IS
782: ---------------------------------------------------------------

Line 813: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;

809: l_default_reimb_curr FND_CURRENCIES_VL.currency_code%TYPE;
810:
811: BEGIN
812:
813: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;
814:
815:
816: -- Get date mask
817: --Bug 3336823

Line 836: l_allow_overrider := AP_WEB_UTILITIES_PKG.value_specific(

832: debug_info := 'Validate Override Approver';
833:
834: -- Bug 3525089 : Setting up l_allow_overrider, so that if p_bFull_Approver_Validation = false
835: -- then ValidateApprover gets called
836: l_allow_overrider := AP_WEB_UTILITIES_PKG.value_specific(
837: p_name => 'AP_WEB_ALLOW_OVERRIDE_APPROVER',
838: p_user_id => p_user_id,
839: p_resp_id => null,
840: p_apps_id => null);

Line 844: l_overrider_CC := AP_WEB_UTILITIES_PKG.value_specific(

840: p_apps_id => null);
841:
842: IF (p_bFull_Approver_Validation) THEN
843:
844: l_overrider_CC := AP_WEB_UTILITIES_PKG.value_specific(
845: p_name => 'AP_WEB_APPROVER_REQ_CC',
846: p_user_id => p_user_id,
847: p_resp_id => null,
848: p_apps_id => null);

Line 852: AP_WEB_UTILITIES_PKG.GetEmployeeInfo(

848: p_apps_id => null);
849:
850: IF ( l_allow_overrider = 'Y' ) THEN
851: -- get the default cost center of the filer:
852: AP_WEB_UTILITIES_PKG.GetEmployeeInfo(
853: l_employee_name,
854: l_employee_num,
855: l_default_cost_center,
856: ExpReportHeaderInfo.employee_id );

Line 858: l_require_overrider := AP_WEB_UTILITIES_PKG.value_specific(

854: l_employee_num,
855: l_default_cost_center,
856: ExpReportHeaderInfo.employee_id );
857:
858: l_require_overrider := AP_WEB_UTILITIES_PKG.value_specific(
859: p_name => 'AP_WEB_OVERRIDE_APPR_REQ',
860: p_user_id => p_user_id,
861: p_resp_id => null,
862: p_apps_id => null );

Line 867: AP_WEB_UTILITIES_PKG.AddExpError(p_error,

863:
864: IF ( l_require_overrider = 'Y' OR l_require_overrider = 'D') THEN
865: IF ( ExpReportHeaderInfo.override_approver_name IS NULL ) THEN
866: fnd_message.set_name('SQLAP', 'AP_WEB_OVERRIDER_REQUIRED');
867: AP_WEB_UTILITIES_PKG.AddExpError(p_error,
868: fnd_message.get_encoded(),
869: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
870: null,
871: 0,

Line 869: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

865: IF ( ExpReportHeaderInfo.override_approver_name IS NULL ) THEN
866: fnd_message.set_name('SQLAP', 'AP_WEB_OVERRIDER_REQUIRED');
867: AP_WEB_UTILITIES_PKG.AddExpError(p_error,
868: fnd_message.get_encoded(),
869: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
870: null,
871: 0,
872: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
873: ELSE

Line 872: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

868: fnd_message.get_encoded(),
869: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
870: null,
871: 0,
872: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
873: ELSE
874: ValidateApprover(
875: ExpReportHeaderInfo.employee_id,
876: ExpReportHeaderInfo.override_approver_name,

Line 880: AP_WEB_UTILITIES_PKG.AddExpError(

876: ExpReportHeaderInfo.override_approver_name,
877: ExpReportHeaderInfo.override_approver_id,
878: l_ap_error );
879: IF ( l_ap_error IS NOT NULL ) THEN
880: AP_WEB_UTILITIES_PKG.AddExpError(
881: p_error,
882: l_ap_error,
883: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
884: 'AP_WEB_FULLNAME',

Line 883: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

879: IF ( l_ap_error IS NOT NULL ) THEN
880: AP_WEB_UTILITIES_PKG.AddExpError(
881: p_error,
882: l_ap_error,
883: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
884: 'AP_WEB_FULLNAME',
885: 0,
886: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
887: END IF;

Line 886: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

882: l_ap_error,
883: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
884: 'AP_WEB_FULLNAME',
885: 0,
886: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
887: END IF;
888:
889: END IF;
890: ELSIF (l_require_overrider = 'N' AND ExpReportHeaderInfo.override_approver_name IS NOT NULL) THEN

Line 898: AP_WEB_UTILITIES_PKG.AddExpError(

894: ExpReportHeaderInfo.override_approver_id,
895: l_ap_error );
896:
897: IF ( l_ap_error IS NOT NULL ) THEN
898: AP_WEB_UTILITIES_PKG.AddExpError(
899: p_error,
900: l_ap_error,
901: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
902: 'AP_WEB_FULLNAME',

Line 901: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

897: IF ( l_ap_error IS NOT NULL ) THEN
898: AP_WEB_UTILITIES_PKG.AddExpError(
899: p_error,
900: l_ap_error,
901: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
902: 'AP_WEB_FULLNAME',
903: 0,
904: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
905: END IF;

Line 904: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

900: l_ap_error,
901: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
902: 'AP_WEB_FULLNAME',
903: 0,
904: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
905: END IF;
906: ELSIF ( l_overrider_CC = 'Y' AND ExpReportHeaderInfo.cost_center <> l_default_cost_center ) THEN
907: IF ( ExpReportHeaderInfo.override_approver_name IS NULL ) THEN
908: fnd_message.set_name('SQLAP','AP_WEB_DISCON_OVERRIDER_CC');

Line 909: AP_WEB_UTILITIES_PKG.AddExpError(

905: END IF;
906: ELSIF ( l_overrider_CC = 'Y' AND ExpReportHeaderInfo.cost_center <> l_default_cost_center ) THEN
907: IF ( ExpReportHeaderInfo.override_approver_name IS NULL ) THEN
908: fnd_message.set_name('SQLAP','AP_WEB_DISCON_OVERRIDER_CC');
909: AP_WEB_UTILITIES_PKG.AddExpError(
910: p_error,
911: fnd_message.get_encoded(),
912: AP_WEB_UTILITIES_PKG.C_ErrorMessageType ,
913: null,

Line 912: AP_WEB_UTILITIES_PKG.C_ErrorMessageType ,

908: fnd_message.set_name('SQLAP','AP_WEB_DISCON_OVERRIDER_CC');
909: AP_WEB_UTILITIES_PKG.AddExpError(
910: p_error,
911: fnd_message.get_encoded(),
912: AP_WEB_UTILITIES_PKG.C_ErrorMessageType ,
913: null,
914: 0,
915: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
916: ELSE

Line 915: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

911: fnd_message.get_encoded(),
912: AP_WEB_UTILITIES_PKG.C_ErrorMessageType ,
913: null,
914: 0,
915: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
916: ELSE
917: ValidateApprover(
918: ExpReportHeaderInfo.employee_id,
919: ExpReportHeaderInfo.override_approver_name,

Line 924: AP_WEB_UTILITIES_PKG.AddExpError(

920: ExpReportHeaderInfo.override_approver_id,
921: l_ap_error );
922:
923: IF ( l_ap_error IS NOT NULL ) THEN
924: AP_WEB_UTILITIES_PKG.AddExpError(
925: p_error,
926: l_ap_error,
927: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
928: 'AP_WEB_FULLNAME',

Line 927: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

923: IF ( l_ap_error IS NOT NULL ) THEN
924: AP_WEB_UTILITIES_PKG.AddExpError(
925: p_error,
926: l_ap_error,
927: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
928: 'AP_WEB_FULLNAME',
929: 0,
930: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
931: END IF;

Line 930: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

926: l_ap_error,
927: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
928: 'AP_WEB_FULLNAME',
929: 0,
930: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
931: END IF;
932: END IF;
933: END IF;
934: END IF;

Line 946: AP_WEB_UTILITIES_PKG.AddExpError(

942: ExpReportHeaderInfo.override_approver_id,
943: l_ap_error );
944:
945: IF ( l_ap_error IS NOT NULL ) THEN
946: AP_WEB_UTILITIES_PKG.AddExpError(
947: p_error,
948: l_ap_error,
949: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
950: 'AP_WEB_FULLNAME',

Line 949: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

945: IF ( l_ap_error IS NOT NULL ) THEN
946: AP_WEB_UTILITIES_PKG.AddExpError(
947: p_error,
948: l_ap_error,
949: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
950: 'AP_WEB_FULLNAME',
951: 0,
952: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
953: END IF;

Line 952: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

948: l_ap_error,
949: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
950: 'AP_WEB_FULLNAME',
951: 0,
952: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
953: END IF;
954: END IF;
955: END IF;
956: END IF;

Line 965: AP_WEB_UTILITIES_PKG.AddExpError(

961: fnd_message.set_name( 'SQLAP', 'AP_WEB_COST_CENTER_INVALID' );
962: else
963: fnd_message.set_name( 'SQLAP', 'AP_OME_COST_CENTER_ERROR' );
964: end if;
965: AP_WEB_UTILITIES_PKG.AddExpError(
966: p_error,
967: fnd_message.get_encoded(),
968: AP_WEB_UTILITIES_PKG.C_errorMessageType,
969: 'txtCostCenter',

Line 968: AP_WEB_UTILITIES_PKG.C_errorMessageType,

964: end if;
965: AP_WEB_UTILITIES_PKG.AddExpError(
966: p_error,
967: fnd_message.get_encoded(),
968: AP_WEB_UTILITIES_PKG.C_errorMessageType,
969: 'txtCostCenter',
970: 0,
971: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
972: ELSE

Line 971: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

967: fnd_message.get_encoded(),
968: AP_WEB_UTILITIES_PKG.C_errorMessageType,
969: 'txtCostCenter',
970: 0,
971: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
972: ELSE
973: AP_WEB_VALIDATE_UTIL.ValidateCostCenter(
974: ExpReportHeaderInfo.cost_center,
975: l_cs_error,

Line 979: AP_WEB_UTILITIES_PKG.AddExpError(

975: l_cs_error,
976: ExpReportHeaderInfo.employee_id );
977:
978: IF ( l_cs_error IS NOT NULL ) THEN
979: AP_WEB_UTILITIES_PKG.AddExpError(
980: p_error,
981: l_cs_error,
982: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
983: 'txtCostCenter',

Line 982: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

978: IF ( l_cs_error IS NOT NULL ) THEN
979: AP_WEB_UTILITIES_PKG.AddExpError(
980: p_error,
981: l_cs_error,
982: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
983: 'txtCostCenter',
984: 0,
985: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory,
986: l_IsMobileApp);

Line 985: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory,

981: l_cs_error,
982: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
983: 'txtCostCenter',
984: 0,
985: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory,
986: l_IsMobileApp);
987: END IF;
988: END IF;
989:

Line 1005: AP_WEB_UTILITIES_PKG.AddExpError(p_error,

1001:
1002: EXCEPTION
1003: when OTHERS then
1004: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_TEMP_INVALID');
1005: AP_WEB_UTILITIES_PKG.AddExpError(p_error,
1006: fnd_message.get_encoded(),
1007: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1008: 'TEMPLATE',
1009: 0,

Line 1007: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1003: when OTHERS then
1004: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_TEMP_INVALID');
1005: AP_WEB_UTILITIES_PKG.AddExpError(p_error,
1006: fnd_message.get_encoded(),
1007: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1008: 'TEMPLATE',
1009: 0,
1010: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1011: END;

Line 1010: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1006: fnd_message.get_encoded(),
1007: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1008: 'TEMPLATE',
1009: 0,
1010: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1011: END;
1012:
1013: -- Validate Last Receipt Date
1014: debug_info := 'Validating Last Receipt Date';

Line 1026: AP_WEB_UTILITIES_PKG.AddExpError(

1022: END IF;
1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: FND_MESSAGE.SET_NAME( 'SQLAP','AP_WEB_LAST_RECDATE_INVALID' );
1026: AP_WEB_UTILITIES_PKG.AddExpError(
1027: p_error,
1028: fnd_message.get_encoded(),
1029: AP_WEB_UTILITIES_PKG.C_errorMessageType,
1030: 'popEmployeeID',

Line 1029: AP_WEB_UTILITIES_PKG.C_errorMessageType,

1025: FND_MESSAGE.SET_NAME( 'SQLAP','AP_WEB_LAST_RECDATE_INVALID' );
1026: AP_WEB_UTILITIES_PKG.AddExpError(
1027: p_error,
1028: fnd_message.get_encoded(),
1029: AP_WEB_UTILITIES_PKG.C_errorMessageType,
1030: 'popEmployeeID',
1031: 0,
1032: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1033:

Line 1032: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1028: fnd_message.get_encoded(),
1029: AP_WEB_UTILITIES_PKG.C_errorMessageType,
1030: 'popEmployeeID',
1031: 0,
1032: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1033:
1034: END;
1035:
1036: -- For bug fix 1865355

Line 1038: l_exp_reimb_curr_profile := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(

1034: END;
1035:
1036: -- For bug fix 1865355
1037: -- Validate reimbursement currency
1038: l_exp_reimb_curr_profile := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(
1039: p_name => 'AP_WEB_ALLOW_NON_BASE_REIMB',
1040: p_user_id => p_user_id,
1041: p_resp_id => null,
1042: p_apps_id => null);

Line 1058: AP_WEB_UTILITIES_PKG.AddExpError(p_error,

1054: IF ( ExpReportHeaderInfo.reimbursement_currency_code <> l_default_reimb_curr ) THEN
1055: ExpReportHeaderInfo.reimbursement_currency_code := l_default_reimb_curr;
1056: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_INVALID_REIMB_CURR');
1057: FND_MESSAGE.SET_TOKEN('FUNCTIONAL_CURRENCY',l_default_reimb_curr);
1058: AP_WEB_UTILITIES_PKG.AddExpError(p_error,
1059: fnd_message.get_encoded(),
1060: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
1061: END IF;
1062: END IF;

Line 1060: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);

1056: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_INVALID_REIMB_CURR');
1057: FND_MESSAGE.SET_TOKEN('FUNCTIONAL_CURRENCY',l_default_reimb_curr);
1058: AP_WEB_UTILITIES_PKG.AddExpError(p_error,
1059: fnd_message.get_encoded(),
1060: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
1061: END IF;
1062: END IF;
1063:
1064: EXCEPTION

Line 1120: p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,

1116: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1117: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1118: P_IsSessionTaxEnabled IN VARCHAR2,
1119: P_IsSessionProjectEnabled IN VARCHAR2,
1120: p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
1121: p_calculate_receipt_index IN BINARY_INTEGER,
1122: p_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
1123: p_receipts_with_errors_count IN OUT NOCOPY BINARY_INTEGER,
1124: p_DataDefaultedUpdateable IN OUT NOCOPY BOOLEAN,

Line 1122: p_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,

1118: P_IsSessionTaxEnabled IN VARCHAR2,
1119: P_IsSessionProjectEnabled IN VARCHAR2,
1120: p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
1121: p_calculate_receipt_index IN BINARY_INTEGER,
1122: p_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
1123: p_receipts_with_errors_count IN OUT NOCOPY BINARY_INTEGER,
1124: p_DataDefaultedUpdateable IN OUT NOCOPY BOOLEAN,
1125: p_bCalling_from_disconnected IN BOOLEAN,
1126: p_bForBlueGray IN BOOLEAN default FALSE,

Line 1171: l_error1 AP_WEB_UTILITIES_PKG.expError;

1167: V_Field2 NUMBER;
1168:
1169: V_AcctRawCost NUMBER; -- For PATC: Raw cost in functional currency
1170:
1171: l_error1 AP_WEB_UTILITIES_PKG.expError;
1172: l_error2 AP_WEB_UTILITIES_PKG.expError;
1173: l_invRate VARCHAR2(1) := 'N';
1174: l_calc_amt_enabled_for_disc BOOLEAN := FALSE;
1175:

Line 1172: l_error2 AP_WEB_UTILITIES_PKG.expError;

1168:
1169: V_AcctRawCost NUMBER; -- For PATC: Raw cost in functional currency
1170:
1171: l_error1 AP_WEB_UTILITIES_PKG.expError;
1172: l_error2 AP_WEB_UTILITIES_PKG.expError;
1173: l_invRate VARCHAR2(1) := 'N';
1174: l_calc_amt_enabled_for_disc BOOLEAN := FALSE;
1175:
1176: V_EnteredByUserID VARCHAR2(100);

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

1184: l_CostCenterErrorMsg VARCHAR2(2000) := NULL;
1185:
1186: BEGIN
1187:
1188: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', 'start ValidateExpLineCustomFields');
1189: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;
1190:
1191:
1192: -- Validate descriptive flexfields and call custom validation hook for both

Line 1189: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;

1185:
1186: BEGIN
1187:
1188: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', 'start ValidateExpLineCustomFields');
1189: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;
1190:
1191:
1192: -- Validate descriptive flexfields and call custom validation hook for both
1193: -- core and descriptive flexfields

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

1191:
1192: -- Validate descriptive flexfields and call custom validation hook for both
1193: -- core and descriptive flexfields
1194: l_debug_info := 'Validate desc flexfields and custom validation hook';
1195: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1196: IF p_report_header_info.number_max_flexfield > 0 THEN
1197:
1198: -- validate only if an expense type is specified
1199: IF p_report_line_info.parameter_id IS NOT NULL THEN

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

1199: IF p_report_line_info.parameter_id IS NOT NULL THEN
1200:
1201: -----------------------------------------------------
1202: l_debug_info := 'GetReceiptCustomFields';
1203: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1204: -----------------------------------------------------
1205:
1206: AP_WEB_DFLEX_PKG.GetReceiptCustomFields(l_receipt_custom_fields_array,
1207: p_receipt_index,

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

1222: p_custom15_array);
1223:
1224: -----------------------------------------------------
1225: l_debug_info := 'ValidateReceiptCustomFields';
1226: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1227: -----------------------------------------------------
1228: AP_WEB_DFLEX_PKG.ValidateReceiptCustomFields(p_userId,
1229: p_report_header_info,
1230: p_report_line_info,

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

1236: p_receipts_with_errors_count := p_receipts_with_errors_count + l_error1.COUNT;
1237:
1238: -- Call custom validation hook for both core and pseudo descriptive flexfields
1239: l_debug_info := 'Call custom validation hook for both core and pseudo descriptive flexfields';
1240: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1241: AP_WEB_CUST_DFLEX_PKG.CustomValidateLine(p_report_header_info,
1242: p_report_line_info,
1243: l_receipt_custom_fields_array,
1244: l_error2);

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

1244: l_error2);
1245:
1246: -----------------------------------------------------
1247: l_debug_info := 'PropogateReceiptCustFldsInfo';
1248: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1249: -----------------------------------------------------
1250: AP_WEB_DFLEX_PKG.PropogateReceiptCustFldsInfo(
1251: l_receipt_custom_fields_array,
1252: p_receipt_index,

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

1272: -- Call custom validation hook for both core and pseudo descriptive flexfields
1273: l_debug_info := 'Call custom validation hook';
1274: -- Bug: 6617094, Expense type is null in Custom Validation.
1275: AP_WEB_DFLEX_PKG.PopulateExpTypeInLineRec(p_report_line_info);
1276: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1277: AP_WEB_CUST_DFLEX_PKG.CustomValidateLine(p_report_header_info,
1278: p_report_line_info,
1279: l_receipt_custom_fields_array,
1280: l_error2);

Line 1360: l_invRate := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(

1356:
1357: ----------------------------------------------
1358: l_debug_info := 'Recalculate Amount';
1359: ----------------------------------------------
1360: l_invRate := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(
1361: p_name => 'DISPLAY_INVERSE_RATE',
1362: p_user_id => p_userId,
1363: p_resp_id => null,
1364: p_apps_id => null);

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

1385: END IF;
1386:
1387:
1388: --chiho:1346208:
1389: AP_WEB_UTILITIES_PKG.MergeExpErrors( p_errors, l_error1 );
1390:
1391: AP_WEB_UTILITIES_PKG.MergeExpErrors(p_errors, l_error2);
1392:
1393: EXCEPTION

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

1387:
1388: --chiho:1346208:
1389: AP_WEB_UTILITIES_PKG.MergeExpErrors( p_errors, l_error1 );
1390:
1391: AP_WEB_UTILITIES_PKG.MergeExpErrors(p_errors, l_error2);
1392:
1393: EXCEPTION
1394: WHEN OTHERS THEN
1395: BEGIN

Line 1433: p_exp_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError)

1429: p_allow_credit_lines IN BOOLEAN,
1430: p_justreq_array IN AP_WEB_PARENT_PKG.Number_Array,
1431: p_reimbcurr_precision IN FND_CURRENCIES_VL.PRECISION%TYPE,
1432: p_calculate_receipt_index IN BINARY_INTEGER,
1433: p_exp_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError)
1434: -----------------------------------------------------------------------------
1435: IS
1436:
1437: /* Note: p_receipt_errors might not be empty -- Validation in disconnected

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

1472: l_IsMobileApp boolean;
1473:
1474: BEGIN
1475:
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);

Line 1477: l_IsMobileApp := AP_WEB_UTILITIES_PKG.IsMobileApp;

1473:
1474: BEGIN
1475:
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:

Line 1492: l_inverse_rate_profile := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(

1488: --Bug 3336823
1489: l_date_format := nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'));
1490:
1491:
1492: l_inverse_rate_profile := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(
1493: p_name => 'DISPLAY_INVERSE_RATE',
1494: p_user_id => p_user_id,
1495: p_resp_id => null,
1496: p_apps_id => null);

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

1497:
1498: l_fixed_rate_applied := 'N';
1499:
1500: debug_info:='checking trans';
1501: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1502: l_dates_ok := true;
1503: if (p_report_header_info.transaction_currency_type = 'multi') then
1504: l_reccurr_format :=
1505: FND_CURRENCY.get_format_mask(p_report_line_info.currency_code, 30);

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

1507: --
1508: -- Check if Valid Start Date was entered
1509: --
1510: debug_info:='Check Start Date';
1511: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1512: if (p_report_line_info.start_date is null) then
1513: l_dates_ok := false;
1514: fnd_message.set_name('SQLAP', 'AP_WEB_ST_DATE_FIRST');
1515: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

Line 1515: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1511: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1512: if (p_report_line_info.start_date is null) then
1513: l_dates_ok := false;
1514: fnd_message.set_name('SQLAP', 'AP_WEB_ST_DATE_FIRST');
1515: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1516: fnd_message.get_encoded(),
1517: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1518: C_Date1_Prompt,
1519: p_receiptcount,

Line 1517: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1513: l_dates_ok := false;
1514: fnd_message.set_name('SQLAP', 'AP_WEB_ST_DATE_FIRST');
1515: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1516: fnd_message.get_encoded(),
1517: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1518: C_Date1_Prompt,
1519: p_receiptcount,
1520: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1521: else

Line 1520: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1516: fnd_message.get_encoded(),
1517: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1518: C_Date1_Prompt,
1519: p_receiptcount,
1520: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1521: else
1522: BEGIN
1523: --Bug 6054643: Removing the to_date conversion
1524: l_date1_temp := trunc(p_report_line_info.start_date);

Line 1531: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1527: if (NOT IsValidYear(l_date1_temp) AND (p_report_line_info.category_code <> 'PER_DIEM') )THEN
1528: l_dates_ok := false;
1529: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR');
1530: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1531: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1532: fnd_message.get_encoded(),
1533: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1534: C_Date1_Prompt,
1535: p_receiptcount,

Line 1533: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1529: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR');
1530: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1531: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1532: fnd_message.get_encoded(),
1533: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1534: C_Date1_Prompt,
1535: p_receiptcount,
1536: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1537: end if;

Line 1536: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1532: fnd_message.get_encoded(),
1533: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1534: C_Date1_Prompt,
1535: p_receiptcount,
1536: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1537: end if;
1538:
1539: l_acdate := l_date1_temp;
1540:

Line 1555: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1551: l_dates_ok := false;
1552: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_START_DATE_INVALID');
1553: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);
1554: FND_MESSAGE.SET_TOKEN('PROPER_FORMAT', to_char(sysdate, l_date_format));
1555: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1556: fnd_message.get_encoded(),
1557: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1558: C_Date1_Prompt,
1559: p_receiptcount,

Line 1557: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1553: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);
1554: FND_MESSAGE.SET_TOKEN('PROPER_FORMAT', to_char(sysdate, l_date_format));
1555: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1556: fnd_message.get_encoded(),
1557: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1558: C_Date1_Prompt,
1559: p_receiptcount,
1560: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1561:

Line 1560: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1556: fnd_message.get_encoded(),
1557: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1558: C_Date1_Prompt,
1559: p_receiptcount,
1560: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1561:
1562: END;
1563: end if; /* date 1 is null */
1564:

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

1565: --
1566: -- Check if Valid End Date was entered
1567: --
1568: debug_info := 'Check End Date';
1569: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1570: BEGIN
1571: --Bug 6054643: Removing the to_date conversion
1572: l_date2_temp := trunc(nvl(p_report_line_info.end_date, l_date1_temp));
1573:

Line 1586: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1582: if (NOT IsValidYear(l_date1_temp)) THEN
1583: l_dates_ok := false;
1584: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR_START_DATE');
1585: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1586: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1587: fnd_message.get_encoded(),
1588: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1589: C_Date1_Prompt,
1590: p_receiptcount,

Line 1588: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1584: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR_START_DATE');
1585: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1586: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1587: fnd_message.get_encoded(),
1588: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1589: C_Date1_Prompt,
1590: p_receiptcount,
1591: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1592: end if;

Line 1591: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1587: fnd_message.get_encoded(),
1588: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1589: C_Date1_Prompt,
1590: p_receiptcount,
1591: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1592: end if;
1593: -- Bug 6392916 (sodash)
1594: -- Checking whether entering the end date is compulsory for the Per Diem Schedule
1595: 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 1602: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1598: NOT IsValidYear(l_date2_temp)) THEN
1599: l_dates_ok := false;
1600: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR_END_DATE');
1601: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1602: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1603: fnd_message.get_encoded(),
1604: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1605: C_Date2_Prompt,
1606: p_receiptcount,

Line 1604: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1600: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR_END_DATE');
1601: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1602: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1603: fnd_message.get_encoded(),
1604: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1605: C_Date2_Prompt,
1606: p_receiptcount,
1607: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1608: end if;

Line 1607: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1603: fnd_message.get_encoded(),
1604: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1605: C_Date2_Prompt,
1606: p_receiptcount,
1607: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1608: end if;
1609: END IF;
1610:
1611: l_acdate := l_date2_temp;

Line 1623: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1619: l_dates_ok := false;
1620: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_END_DATE_INVALID');
1621: FND_MESSAGE.SET_TOKEN('END_DATE', p_report_line_info.end_date);
1622: FND_MESSAGE.SET_TOKEN('PROPER_FORMAT', to_char(sysdate, l_date_format));
1623: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1624: fnd_message.get_encoded(),
1625: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1626: C_Date2_Prompt,
1627: p_receiptcount,

Line 1625: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1621: FND_MESSAGE.SET_TOKEN('END_DATE', p_report_line_info.end_date);
1622: FND_MESSAGE.SET_TOKEN('PROPER_FORMAT', to_char(sysdate, l_date_format));
1623: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1624: fnd_message.get_encoded(),
1625: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1626: C_Date2_Prompt,
1627: p_receiptcount,
1628: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1629: END;

Line 1628: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1624: fnd_message.get_encoded(),
1625: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1626: C_Date2_Prompt,
1627: p_receiptcount,
1628: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1629: END;
1630:
1631: --
1632: -- Check if End Date falls on or after Start Date

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

1632: -- Check if End Date falls on or after Start Date
1633: -- Only do it when both dates' format is fine.
1634: --
1635: debug_info:= 'Day1 < Day2?';
1636: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1637: if (l_dates_ok) then
1638: if (l_date1_temp > nvl(l_date2_temp, l_date1_temp)) then
1639: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_START_AFTER_END');
1640: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);

Line 1642: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1638: if (l_date1_temp > nvl(l_date2_temp, l_date1_temp)) then
1639: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_START_AFTER_END');
1640: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);
1641: FND_MESSAGE.SET_TOKEN('END_DATE', p_report_line_info.end_date);
1642: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1643: fnd_message.get_encoded(),
1644: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1645: C_Date2_Prompt,
1646: p_receiptcount,

Line 1644: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1640: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);
1641: FND_MESSAGE.SET_TOKEN('END_DATE', p_report_line_info.end_date);
1642: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1643: fnd_message.get_encoded(),
1644: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1645: C_Date2_Prompt,
1646: p_receiptcount,
1647: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1648: end if;

Line 1647: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1643: fnd_message.get_encoded(),
1644: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1645: C_Date2_Prompt,
1646: p_receiptcount,
1647: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1648: end if;
1649: end if;
1650:
1651: --

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

1652: -- Check if Days is a valid number. And if days entered equals to
1653: -- actual different between the two dates.
1654: --
1655: debug_info := 'Check days';
1656: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1657: BEGIN
1658: l_num := to_number(p_report_line_info.days);
1659: if (l_dates_ok) then
1660: if (p_report_line_info.days is null) then

Line 1690: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1686: -- the real range of dates.
1687: elsif ((l_date2_temp - l_date1_temp + 1) <> l_num)
1688: then
1689: fnd_message.set_name('SQLAP', 'AP_WEB_WRONG_NUM_OF_DAYS');
1690: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1691: fnd_message.get_encoded(),
1692: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1693: C_Days_Prompt,
1694: p_receiptcount,

Line 1692: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1688: then
1689: fnd_message.set_name('SQLAP', 'AP_WEB_WRONG_NUM_OF_DAYS');
1690: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1691: fnd_message.get_encoded(),
1692: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1693: C_Days_Prompt,
1694: p_receiptcount,
1695: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1696: end if;

Line 1695: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1691: fnd_message.get_encoded(),
1692: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1693: C_Days_Prompt,
1694: p_receiptcount,
1695: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1696: end if;
1697: end if; /* l_dates_ok */
1698: EXCEPTION
1699: when OTHERS then

Line 1701: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1697: end if; /* l_dates_ok */
1698: EXCEPTION
1699: when OTHERS then
1700: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_DAYS_INVALID');
1701: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1702: fnd_message.get_encoded(),
1703: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1704: C_Days_Prompt,
1705: p_receiptcount,

Line 1703: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1699: when OTHERS then
1700: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_DAYS_INVALID');
1701: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1702: fnd_message.get_encoded(),
1703: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1704: C_Days_Prompt,
1705: p_receiptcount,
1706: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1707: END;

Line 1706: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1702: fnd_message.get_encoded(),
1703: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1704: C_Days_Prompt,
1705: p_receiptcount,
1706: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1707: END;
1708:
1709: debug_info := 'Check if the fields exist in the receipts array';
1710: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);

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

1706: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1707: END;
1708:
1709: debug_info := 'Check if the fields exist in the receipts array';
1710: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1711:
1712: --
1713: -- Check if Daily Amount is a valid number.
1714: --

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

1712: --
1713: -- Check if Daily Amount is a valid number.
1714: --
1715: debug_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);

Line 1730: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1726: EXCEPTION
1727: when OTHERS then
1728: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_DAILY_AMOUNT_INVALID');
1729: p_report_line_info.daily_amount := null;
1730: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1731: fnd_message.get_encoded(),
1732: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1733: C_DAmount_Prompt,
1734: p_receiptcount,

Line 1732: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1728: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_DAILY_AMOUNT_INVALID');
1729: p_report_line_info.daily_amount := null;
1730: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1731: fnd_message.get_encoded(),
1732: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1733: C_DAmount_Prompt,
1734: p_receiptcount,
1735: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1736:

Line 1735: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1731: fnd_message.get_encoded(),
1732: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1733: C_DAmount_Prompt,
1734: p_receiptcount,
1735: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1736:
1737: END;
1738: end if;
1739:

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

1740: --
1741: -- Check if Receipt Amount is a valid number.
1742: --
1743: debug_info := 'Check 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);

Line 1766: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1762: end if;
1763:
1764: if ((l_receiptAmount <> 0) AND (NOT WithinTolerance(l_dailyAmount, l_amount))) then
1765: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RECEIPT_AMT_INCORRECT');
1766: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1767: fnd_message.get_encoded(),
1768: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1769: C_RecAmt_Prompt,
1770: p_receiptcount,

Line 1768: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1764: if ((l_receiptAmount <> 0) AND (NOT WithinTolerance(l_dailyAmount, l_amount))) then
1765: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RECEIPT_AMT_INCORRECT');
1766: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1767: fnd_message.get_encoded(),
1768: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1769: C_RecAmt_Prompt,
1770: p_receiptcount,
1771: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1772: elsif (l_receiptAmount = 0) then

Line 1771: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1767: fnd_message.get_encoded(),
1768: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1769: C_RecAmt_Prompt,
1770: p_receiptcount,
1771: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1772: elsif (l_receiptAmount = 0) then
1773: if (l_dailyAmount <> 0) then -- dailyAmount is valid
1774: -- Could have been pre-seeded to 0 in spreadsheet. Null it
1775: -- out since don't want to mess with currency format.

Line 1792: AP_WEB_UTILITIES_PKG.OIE_ROUND_CURRENCY(l_receiptAmount,

1788: -- Check whether the receipt amount equals the rounded
1789: -- currency amount
1790:
1791: if (NOT WithinTolerance (l_receiptAmount,
1792: AP_WEB_UTILITIES_PKG.OIE_ROUND_CURRENCY(l_receiptAmount,
1793: p_report_line_info.currency_code))) then
1794: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_CURRENCY_NO_DECIMALS');
1795: FND_MESSAGE.SET_TOKEN('RECEIPT_CURRENCY',
1796: p_report_line_info.currency_code);

Line 1797: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1793: p_report_line_info.currency_code))) then
1794: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_CURRENCY_NO_DECIMALS');
1795: FND_MESSAGE.SET_TOKEN('RECEIPT_CURRENCY',
1796: p_report_line_info.currency_code);
1797: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1798: fnd_message.get_encoded(),
1799: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1800: C_RecAmt_Prompt,
1801: p_receiptcount,

Line 1799: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1795: FND_MESSAGE.SET_TOKEN('RECEIPT_CURRENCY',
1796: p_report_line_info.currency_code);
1797: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1798: fnd_message.get_encoded(),
1799: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1800: C_RecAmt_Prompt,
1801: p_receiptcount,
1802: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1803: end if; /* Rounding */

Line 1802: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1798: fnd_message.get_encoded(),
1799: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1800: C_RecAmt_Prompt,
1801: p_receiptcount,
1802: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1803: end if; /* Rounding */
1804:
1805: end if; /* CheckNum */
1806: end if;

Line 1811: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1807: EXCEPTION
1808: when OTHERS then
1809: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RECEIPT_AMOUNT_INVALID');
1810: p_report_line_info.receipt_amount := null;
1811: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1812: fnd_message.get_encoded(),
1813: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1814: C_RecAmt_Prompt,
1815: p_receiptcount,

Line 1813: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1809: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RECEIPT_AMOUNT_INVALID');
1810: p_report_line_info.receipt_amount := null;
1811: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1812: fnd_message.get_encoded(),
1813: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1814: C_RecAmt_Prompt,
1815: p_receiptcount,
1816: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1817:

Line 1816: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1812: fnd_message.get_encoded(),
1813: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1814: C_RecAmt_Prompt,
1815: p_receiptcount,
1816: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1817:
1818: END;
1819: -- chiho:bug#825307:extend the exception handling to include GL_CURRENCY_API.is_fixed_rate:
1820: BEGIN

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

1821: --
1822: -- Check if Rate is a valid number.
1823: --
1824: debug_info := 'Check rate';
1825: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1826: IF ((p_report_line_info.currency_code =
1827: p_report_header_info.reimbursement_currency_code) OR
1828: (p_report_line_info.currency_code = 'OTHER')) THEN
1829: l_is_fixed_rate := 'N';

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

1851: -- **** USED TO BE CheckPosNum
1852: if not CheckNum(l_num, p_exp_error,
1853: p_receiptcount, C_Rate_Prompt, TRUE, TRUE) then
1854: debug_info := 'rate is negative'; /* CheckPosNum is function */
1855: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1856: else
1857: IF (l_is_fixed_rate = 'Y') THEN
1858: p_report_line_info.rate:= '1'; -- Bug 1871739. Use '1' instead of l_fixed_msg
1859: ELSE

Line 1875: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1871: --
1872: if (nvl(p_report_line_info.currency_code, p_report_header_info.reimbursement_currency_code) = p_report_header_info.reimbursement_currency_code) then
1873: if ((l_num <> 1) or (l_num <> null)) then
1874: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_SAMECURR_RATE');
1875: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1876: fnd_message.get_encoded(),
1877: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1878: C_Rate_Prompt,
1879: p_receiptcount,

Line 1877: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1873: if ((l_num <> 1) or (l_num <> null)) then
1874: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_SAMECURR_RATE');
1875: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1876: fnd_message.get_encoded(),
1877: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1878: C_Rate_Prompt,
1879: p_receiptcount,
1880: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1881: -- Default rate to '1' since currency is not foreign.

Line 1880: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1876: fnd_message.get_encoded(),
1877: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1878: C_Rate_Prompt,
1879: p_receiptcount,
1880: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1881: -- Default rate to '1' since currency is not foreign.
1882: -- and adjust reimbursable amount
1883: p_report_line_info.rate:= '1'; -- Bug 2177344
1884: p_report_line_info.amount := p_report_line_info.receipt_amount;

Line 1894: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

1890: EXCEPTION
1891: when OTHERS then
1892: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RATE_INVALID');
1893: p_report_line_info.rate := null;
1894: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1895: fnd_message.get_encoded(),
1896: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1897: C_Rate_Prompt,
1898: p_receiptcount,

Line 1896: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

1892: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RATE_INVALID');
1893: p_report_line_info.rate := null;
1894: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1895: fnd_message.get_encoded(),
1896: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1897: C_Rate_Prompt,
1898: p_receiptcount,
1899: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1900: END;

Line 1899: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

1895: fnd_message.get_encoded(),
1896: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1897: C_Rate_Prompt,
1898: p_receiptcount,
1899: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
1900: END;
1901:
1902: --
1903: -- Check if (Total) Amount is a valid number.

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

1902: --
1903: -- Check if (Total) Amount is a valid number.
1904: --
1905: debug_info := 'Amount';
1906: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1907: -- Only do this check in non "Calculate Amount" custom field calculation
1908: -- case.
1909:
1910: if (NOT(p_calculate_receipt_index > 0) OR

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

1929: END IF;
1930:
1931: if ((l_rate > 0) AND (l_num is not null)) then
1932: debug_info := 'before calc l_amount';
1933: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1934: IF (l_is_fixed_rate = 'Y') THEN
1935: l_amount := GL_CURRENCY_API.convert_amount(
1936: p_report_line_info.currency_code,
1937: p_report_header_info.reimbursement_currency_code,

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

1950: /*** Round l_amount here. ***/
1951: END IF; /* if (l_is_fixed_rate = 'Y') */
1952: else
1953: debug_info := 'l_amount is null';
1954: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1955: l_amount := null;
1956: end if; /* l_rate > 0 */
1957:
1958: EXCEPTION

Line 2013: AP_WEB_UTILITIES_PKG.AddExpError(

2009: FND_MESSAGE.SET_TOKEN('rate',to_char(l_rate));
2010: FND_MESSAGE.SET_TOKEN('result',to_char(l_amount));
2011:
2012: -- JMARY Have to create a new message for this error
2013: AP_WEB_UTILITIES_PKG.AddExpError(
2014: p_exp_error,
2015: fnd_message.get_encoded(),
2016: -- || TO_CHAR(l_orig_num) || l_cal_amount_method || TO_CHAR(l_rate) || '=' ||TO_CHAR(l_amount) ,
2017: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

Line 2017: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

2013: AP_WEB_UTILITIES_PKG.AddExpError(
2014: p_exp_error,
2015: fnd_message.get_encoded(),
2016: -- || TO_CHAR(l_orig_num) || l_cal_amount_method || TO_CHAR(l_rate) || '=' ||TO_CHAR(l_amount) ,
2017: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2018: C_Amount_Prompt,
2019: p_receiptcount,
2020: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2021:

Line 2020: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

2016: -- || TO_CHAR(l_orig_num) || l_cal_amount_method || TO_CHAR(l_rate) || '=' ||TO_CHAR(l_amount) ,
2017: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2018: C_Amount_Prompt,
2019: p_receiptcount,
2020: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2021:
2022: elsif (l_num = 0) then
2023: -- It could be that 0 was pre-seeded in the spreadsheet. But
2024: -- need to make sure that the calculated amount is not zero.

Line 2033: AP_WEB_UTILITIES_PKG.AddExpError(P_Exp_Error,

2029:
2030: /*
2031: IF (l_fixed_rate_applied = 'Y') THEN
2032: fnd_message.set_name('SQLAP','AP_WEB_FIXED_RATE_APPLIED');
2033: AP_WEB_UTILITIES_PKG.AddExpError(P_Exp_Error,
2034: fnd_message.get_encoded(),
2035: AP_WEB_UTILITIES_PKG.C_WarningMessageType,
2036: C_Rate_Prompt,
2037: p_receiptcount,

Line 2035: AP_WEB_UTILITIES_PKG.C_WarningMessageType,

2031: IF (l_fixed_rate_applied = 'Y') THEN
2032: fnd_message.set_name('SQLAP','AP_WEB_FIXED_RATE_APPLIED');
2033: AP_WEB_UTILITIES_PKG.AddExpError(P_Exp_Error,
2034: fnd_message.get_encoded(),
2035: AP_WEB_UTILITIES_PKG.C_WarningMessageType,
2036: C_Rate_Prompt,
2037: p_receiptcount,
2038: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2039:

Line 2038: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

2034: fnd_message.get_encoded(),
2035: AP_WEB_UTILITIES_PKG.C_WarningMessageType,
2036: C_Rate_Prompt,
2037: p_receiptcount,
2038: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2039:
2040: END IF;
2041: */
2042: end if; /* CheckNum */

Line 2046: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

2042: end if; /* CheckNum */
2043: EXCEPTION
2044: when OTHERS then
2045: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_TOTAL_AMOUNT_INVALID');
2046: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
2047: fnd_message.get_encoded(),
2048: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2049: C_Amount_Prompt,
2050: p_receiptcount,

Line 2048: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

2044: when OTHERS then
2045: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_TOTAL_AMOUNT_INVALID');
2046: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
2047: fnd_message.get_encoded(),
2048: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2049: C_Amount_Prompt,
2050: p_receiptcount,
2051: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2052: END;

Line 2051: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

2047: fnd_message.get_encoded(),
2048: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2049: C_Amount_Prompt,
2050: p_receiptcount,
2051: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2052: END;
2053: --
2054: -- If it's null, report error if daily amount and receipt amount are
2055: -- also null. Otherwise, try to calculate total amount.

Line 2061: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

2057: else
2058: if ((p_report_line_info.amount is null) AND
2059: (p_report_line_info.receipt_amount is null)) then
2060: fnd_message.set_name('SQLAP', 'AP_WEB_TOTAL_REQUIRED');
2061: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
2062: fnd_message.get_encoded(),
2063: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2064: C_Amount_Prompt,
2065: p_receiptcount,

Line 2063: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

2059: (p_report_line_info.receipt_amount is null)) then
2060: fnd_message.set_name('SQLAP', 'AP_WEB_TOTAL_REQUIRED');
2061: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
2062: fnd_message.get_encoded(),
2063: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2064: C_Amount_Prompt,
2065: p_receiptcount,
2066: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2067: else

Line 2066: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

2062: fnd_message.get_encoded(),
2063: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2064: C_Amount_Prompt,
2065: p_receiptcount,
2066: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2067: else
2068: if (p_report_header_info.transaction_currency_type = 'reimbursement') then
2069: BEGIN
2070: l_num := to_number(p_report_line_info.amount);

Line 2096: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,

2092: BEGIN
2093: if (xtype_array(p_receiptcount) is null) then
2094: debug_info := 'No expense type selected';
2095: fnd_message.set_name('SQLAP', 'AP_WEB_EXPENSE_TYPE_REQUIRED');
2096: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
2097: fnd_message.get_encoded(),
2098: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2099: C_ExpType_Prompt,
2100: p_receiptcount,

Line 2098: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

2094: debug_info := 'No expense type selected';
2095: fnd_message.set_name('SQLAP', 'AP_WEB_EXPENSE_TYPE_REQUIRED');
2096: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
2097: fnd_message.get_encoded(),
2098: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2099: C_ExpType_Prompt,
2100: p_receiptcount,
2101: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2102: end if;

Line 2101: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

2097: fnd_message.get_encoded(),
2098: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2099: C_ExpType_Prompt,
2100: p_receiptcount,
2101: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2102: end if;
2103: END;
2104: */
2105:

Line 2120: AP_WEB_UTILITIES_PKG.AddExpError(P_Exp_Error,

2116: end if;
2117: if (to_number(p_report_line_info.parameter_id) = p_justreq_array(i)) then
2118:
2119: fnd_message.set_name('SQLAP', 'AP_WEB_JUSTIFICATION_REQUIRED');
2120: AP_WEB_UTILITIES_PKG.AddExpError(P_Exp_Error,
2121: fnd_message.get_encoded(),
2122: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2123: C_Just_Prompt,
2124: p_receiptcount,

Line 2122: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

2118:
2119: fnd_message.set_name('SQLAP', 'AP_WEB_JUSTIFICATION_REQUIRED');
2120: AP_WEB_UTILITIES_PKG.AddExpError(P_Exp_Error,
2121: fnd_message.get_encoded(),
2122: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2123: C_Just_Prompt,
2124: p_receiptcount,
2125: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2126: exit;

Line 2125: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

2121: fnd_message.get_encoded(),
2122: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
2123: C_Just_Prompt,
2124: p_receiptcount,
2125: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);
2126: exit;
2127: end if;
2128: i := i + 1;
2129: end loop;

Line 2187: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,

2183: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2184: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2185: p_has_core_field_errors OUT NOCOPY BOOLEAN,
2186: p_has_custom_field_errors OUT NOCOPY BOOLEAN,
2187: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
2188: p_receipts_with_errors_count IN OUT NOCOPY BINARY_INTEGER,
2189: p_IsSessionProjectEnabled IN VARCHAR2,
2190: p_calculate_receipt_index IN BINARY_INTEGER DEFAULT NULL,
2191: p_bCalling_from_disconnected IN BOOLEAN,

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

2237: -- procedure.
2238: --
2239:
2240: -- Clear p_receipts_errors_custom and p_receipts_errors
2241: AP_WEB_UTILITIES_PKG.InitMessages(l_receipt_count, p_receipts_errors);
2242:
2243: FOR i IN 1 .. l_Receipt_Count LOOP
2244: l_report_line_rec := p_report_line_info(i);
2245:

Line 2349: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,

2345: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2346: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2347: p_has_core_field_errors OUT NOCOPY BOOLEAN,
2348: p_has_custom_field_errors OUT NOCOPY BOOLEAN,
2349: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
2350: p_receipts_with_errors_count IN OUT NOCOPY BINARY_INTEGER,
2351: p_IsSessionProjectEnabled IN VARCHAR2,
2352: p_receipt_index IN BINARY_INTEGER, --needed to reference CustomN_Array
2353: p_calculate_receipt_index IN BINARY_INTEGER DEFAULT NULL,

Line 2387: l_errors AP_WEB_UTILITIES_PKG.expError;

2383: ------------------------------------------------------------------------
2384: IS
2385: l_receipts_with_errors_core BINARY_INTEGER;
2386: l_receipts_with_errors_custom BINARY_INTEGER;
2387: l_errors AP_WEB_UTILITIES_PKG.expError;
2388: l_errors_custom AP_WEB_UTILITIES_PKG.expError;
2389:
2390: V_IsSessionTaxEnabled VARCHAR2(1);
2391:

Line 2388: l_errors_custom AP_WEB_UTILITIES_PKG.expError;

2384: IS
2385: l_receipts_with_errors_core BINARY_INTEGER;
2386: l_receipts_with_errors_custom BINARY_INTEGER;
2387: l_errors AP_WEB_UTILITIES_PKG.expError;
2388: l_errors_custom AP_WEB_UTILITIES_PKG.expError;
2389:
2390: V_IsSessionTaxEnabled VARCHAR2(1);
2391:
2392: l_debug_info VARCHAR2(2000);

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

2409: l_DataDefaultedUpdateable BOOLEAN;
2410:
2411: BEGIN
2412:
2413: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_VALIDATE_UTIL', 'start validateExpLine');
2414:
2415: AP_WEB_DFLEX_PKG.IsSessionTaxEnabled(
2416: V_IsSessionTaxEnabled,
2417: p_userId); -- 2242176, fnd user id

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

2417: p_userId); -- 2242176, fnd user id
2418:
2419: -- validate core lines fields
2420: l_debug_info := 'ValidateExpLinesCoreFields';
2421: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2422:
2423: -- Bug 2204539: always allow credit line for credit card receipt
2424: if (p_report_line_info.cCardTrxnId is null) then
2425: l_allow_credit_lines_profile := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(

Line 2425: l_allow_credit_lines_profile := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(

2421: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2422:
2423: -- Bug 2204539: always allow credit line for credit card receipt
2424: if (p_report_line_info.cCardTrxnId is null) then
2425: l_allow_credit_lines_profile := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(
2426: p_name => 'AP_WEB_ALLOW_CREDIT_LINES',
2427: p_user_id => p_userId,
2428: p_resp_id => null,
2429: p_apps_id => null);

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

2455:
2456:
2457: -- validate flexfields
2458: l_debug_info := 'ValidateExpLinesCustomFields';
2459: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2460: l_receipts_with_errors_custom := 0;
2461:
2462: -- The following calcuations marked with "For PATC" were
2463: -- added for the R11i support for multicurrency in PA.

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

2472: -- For PATC: Get information about functional currency and exchange
2473: -- rate for the last receipt date. The last receipt date will be
2474: -- equal to sysdate.
2475: l_debug_info := 'Getting functional currency and exchange rate info';
2476: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2477:
2478: -- for bug 3452403, get default currency information from header
2479: V_SysInfoRec.base_currency := p_report_header_info.default_currency_code;
2480: V_SysInfoRec.default_exchange_rate_type := p_report_header_info.default_exchange_rate_type;

Line 2559: AP_WEB_UTILITIES_PKG.AddExpError(l_errors_custom,

2555:
2556: -- bug#2188075 - Updated the amount, display a warning to the user
2557: IF (l_DataDefaultedUpdateable) THEN
2558: fnd_message.set_name('SQLAP', 'OIE_DATA_CALCULATED_DIFFER');
2559: AP_WEB_UTILITIES_PKG.AddExpError(l_errors_custom,
2560: fnd_message.get_encoded(),
2561: AP_WEB_UTILITIES_PKG.C_WarningMessageType,
2562: 'FlexField',
2563: p_receipt_index,

Line 2561: AP_WEB_UTILITIES_PKG.C_WarningMessageType,

2557: IF (l_DataDefaultedUpdateable) THEN
2558: fnd_message.set_name('SQLAP', 'OIE_DATA_CALCULATED_DIFFER');
2559: AP_WEB_UTILITIES_PKG.AddExpError(l_errors_custom,
2560: fnd_message.get_encoded(),
2561: AP_WEB_UTILITIES_PKG.C_WarningMessageType,
2562: 'FlexField',
2563: p_receipt_index,
2564: AP_WEB_UTILITIES_PKG.C_DFFMessageCategory);
2565: END IF;

Line 2564: AP_WEB_UTILITIES_PKG.C_DFFMessageCategory);

2560: fnd_message.get_encoded(),
2561: AP_WEB_UTILITIES_PKG.C_WarningMessageType,
2562: 'FlexField',
2563: p_receipt_index,
2564: AP_WEB_UTILITIES_PKG.C_DFFMessageCategory);
2565: END IF;
2566:
2567:
2568: -- determine whether there were errors in the custom field

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

2569: p_has_core_field_errors := (l_receipts_with_errors_core > 0);
2570: p_has_custom_field_errors := (l_receipts_with_errors_custom > 0);
2571:
2572: l_debug_info := 'merge error stacks';
2573: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2574:
2575: AP_WEB_UTILITIES_PKG.MergeExpErrors(l_errors,
2576: l_errors_custom);
2577:

Line 2575: AP_WEB_UTILITIES_PKG.MergeExpErrors(l_errors,

2571:
2572: l_debug_info := 'merge error stacks';
2573: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2574:
2575: AP_WEB_UTILITIES_PKG.MergeExpErrors(l_errors,
2576: l_errors_custom);
2577:
2578: AP_WEB_UTILITIES_PKG.MergeErrors(l_errors,
2579: p_receipts_errors);

Line 2578: AP_WEB_UTILITIES_PKG.MergeErrors(l_errors,

2574:
2575: AP_WEB_UTILITIES_PKG.MergeExpErrors(l_errors,
2576: l_errors_custom);
2577:
2578: AP_WEB_UTILITIES_PKG.MergeErrors(l_errors,
2579: p_receipts_errors);
2580:
2581: p_receipts_with_errors_count :=
2582: AP_WEB_UTILITIES_PKG.NumOfReceiptWithError(p_receipts_errors);

Line 2582: AP_WEB_UTILITIES_PKG.NumOfReceiptWithError(p_receipts_errors);

2578: AP_WEB_UTILITIES_PKG.MergeErrors(l_errors,
2579: p_receipts_errors);
2580:
2581: p_receipts_with_errors_count :=
2582: AP_WEB_UTILITIES_PKG.NumOfReceiptWithError(p_receipts_errors);
2583:
2584:
2585: EXCEPTION
2586: WHEN OTHERS THEN

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

2740: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2741: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_CurrentCallingSequence);
2742: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
2743: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_DebugInfo);
2744: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2745: END;
2746:
2747: END MapColumnToCustomFields;
2748:

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

2752: l_just_required_cursor AP_WEB_DB_EXPTEMPLATE_PKG.JustificationExpTypeCursor;
2753: i INTEGER;
2754: BEGIN
2755: l_debug_info := 'Fill justification required array';
2756: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
2757: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetJustifReqdExpTypesCursor(l_just_required_cursor)) THEN
2758: i := 1;
2759: LOOP
2760: FETCH l_just_required_cursor INTO C_justreq_array(i);