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 FND_MESSAGE

Line 57: fnd_message.set_name('SQLAP', 'AP_WEB_NOT_POS_NUM');

53: return TRUE;
54: else
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,

Line 58: fnd_message.set_token('VALUE', to_char(p_num));

54: else
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,

Line 60: fnd_message.get_encoded(),

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,
64: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 80: fnd_message.set_name('SQLAP', 'AP_WEB_NOT_POS_NUM');

76: p_absolute in boolean default FALSE) Return Boolean IS
77: BEGIN
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,

Line 81: fnd_message.set_token('VALUE', to_char(p_num));

77: BEGIN
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(),

Line 85: fnd_message.get_encoded(),

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;
89: end if; /* p_num < 0 */

Line 434: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

430: EXCEPTION
431: WHEN OTHERS THEN
432: BEGIN
433: IF (SQLCODE <> -20001) THEN
434: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
435: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
436: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
437: 'ValidateExpLinesCustomFields');
438: FND_MESSAGE.SET_TOKEN('PARAMETERS',

Line 435: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

431: WHEN OTHERS THEN
432: BEGIN
433: IF (SQLCODE <> -20001) THEN
434: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
435: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
436: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
437: 'ValidateExpLinesCustomFields');
438: FND_MESSAGE.SET_TOKEN('PARAMETERS',
439: 'None passed.');

Line 436: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

432: BEGIN
433: IF (SQLCODE <> -20001) THEN
434: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
435: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
436: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
437: 'ValidateExpLinesCustomFields');
438: FND_MESSAGE.SET_TOKEN('PARAMETERS',
439: 'None passed.');
440: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 438: FND_MESSAGE.SET_TOKEN('PARAMETERS',

434: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
435: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
436: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
437: 'ValidateExpLinesCustomFields');
438: FND_MESSAGE.SET_TOKEN('PARAMETERS',
439: 'None passed.');
440: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
441: END IF;
442:

Line 440: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

436: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
437: 'ValidateExpLinesCustomFields');
438: FND_MESSAGE.SET_TOKEN('PARAMETERS',
439: 'None passed.');
440: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
441: END IF;
442:
443: APP_EXCEPTION.RAISE_EXCEPTION;
444: END;

Line 535: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_TOO_MANY_APPROVERS');

531: END IF;
532: CLOSE l_approvers_cursor;
533:
534: if (l_approvercount > 1) then
535: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_TOO_MANY_APPROVERS');
536: p_ap_error:= fnd_message.get_encoded();
537: RETURN;
538: elsif (l_approvercount = 0) then
539: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_FOUND_NO_APPROVERS');

Line 536: p_ap_error:= fnd_message.get_encoded();

532: CLOSE l_approvers_cursor;
533:
534: if (l_approvercount > 1) then
535: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_TOO_MANY_APPROVERS');
536: p_ap_error:= fnd_message.get_encoded();
537: RETURN;
538: elsif (l_approvercount = 0) then
539: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_FOUND_NO_APPROVERS');
540: p_ap_error := fnd_message.get_encoded();

Line 539: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_FOUND_NO_APPROVERS');

535: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_TOO_MANY_APPROVERS');
536: p_ap_error:= fnd_message.get_encoded();
537: RETURN;
538: elsif (l_approvercount = 0) then
539: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_FOUND_NO_APPROVERS');
540: p_ap_error := fnd_message.get_encoded();
541: RETURN;
542: end if;
543:

Line 540: p_ap_error := fnd_message.get_encoded();

536: p_ap_error:= fnd_message.get_encoded();
537: RETURN;
538: elsif (l_approvercount = 0) then
539: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_FOUND_NO_APPROVERS');
540: p_ap_error := fnd_message.get_encoded();
541: RETURN;
542: end if;
543:
544: EXCEPTION

Line 546: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_TOO_MANY_APPROVERS');

542: end if;
543:
544: EXCEPTION
545: when TOO_MANY_ROWS then
546: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_TOO_MANY_APPROVERS');
547: p_ap_error:= fnd_message.get_encoded();
548: RETURN;
549: when NO_DATA_FOUND then
550: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_FOUND_NO_APPROVERS');

Line 547: p_ap_error:= fnd_message.get_encoded();

543:
544: EXCEPTION
545: when TOO_MANY_ROWS then
546: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_TOO_MANY_APPROVERS');
547: p_ap_error:= fnd_message.get_encoded();
548: RETURN;
549: when NO_DATA_FOUND then
550: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_FOUND_NO_APPROVERS');
551: p_ap_error := fnd_message.get_encoded();

Line 550: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_FOUND_NO_APPROVERS');

546: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_TOO_MANY_APPROVERS');
547: p_ap_error:= fnd_message.get_encoded();
548: RETURN;
549: when NO_DATA_FOUND then
550: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_FOUND_NO_APPROVERS');
551: p_ap_error := fnd_message.get_encoded();
552: RETURN;
553: WHEN OTHERS THEN
554: IF (SQLCODE <> -20001) THEN

Line 551: p_ap_error := fnd_message.get_encoded();

547: p_ap_error:= fnd_message.get_encoded();
548: RETURN;
549: when NO_DATA_FOUND then
550: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_FOUND_NO_APPROVERS');
551: p_ap_error := fnd_message.get_encoded();
552: RETURN;
553: WHEN OTHERS THEN
554: IF (SQLCODE <> -20001) THEN
555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

Line 555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

551: p_ap_error := fnd_message.get_encoded();
552: RETURN;
553: WHEN OTHERS THEN
554: IF (SQLCODE <> -20001) THEN
555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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','');

Line 556: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

552: RETURN;
553: WHEN OTHERS THEN
554: IF (SQLCODE <> -20001) THEN
555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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());

Line 557: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','ValidateApprover');

553: WHEN OTHERS THEN
554: IF (SQLCODE <> -20001) THEN
555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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;

Line 558: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

554: IF (SQLCODE <> -20001) THEN
555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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;

Line 559: FND_MESSAGE.SET_TOKEN('PARAMETERS','');

555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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

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 570: fnd_message.set_name('SQLAP', 'AP_WEB_PREP_CANNOT_APPROVE');

566: -- preparer and employee cannot be the approver
567: -- and hr.employee_id != to_number(p_employee_id);
568: -- Bug 3198236 : corrected error messages
569: if (l_ApproverID = AP_WEB_DB_HR_INT_PKG.getEmployeeID) then
570: fnd_message.set_name('SQLAP', 'AP_WEB_PREP_CANNOT_APPROVE');
571: p_ap_error := fnd_message.get_encoded();
572: elsif (l_ApproverID = to_number(p_employee_id)) then
573: fnd_message.set_name('SQLAP', 'AP_WEB_EMP_CANNOT_APPROVE');
574: p_ap_error := fnd_message.get_encoded();

Line 571: p_ap_error := fnd_message.get_encoded();

567: -- and hr.employee_id != to_number(p_employee_id);
568: -- Bug 3198236 : corrected error messages
569: if (l_ApproverID = AP_WEB_DB_HR_INT_PKG.getEmployeeID) then
570: fnd_message.set_name('SQLAP', 'AP_WEB_PREP_CANNOT_APPROVE');
571: p_ap_error := fnd_message.get_encoded();
572: elsif (l_ApproverID = to_number(p_employee_id)) then
573: fnd_message.set_name('SQLAP', 'AP_WEB_EMP_CANNOT_APPROVE');
574: p_ap_error := fnd_message.get_encoded();
575: else

Line 573: fnd_message.set_name('SQLAP', 'AP_WEB_EMP_CANNOT_APPROVE');

569: if (l_ApproverID = AP_WEB_DB_HR_INT_PKG.getEmployeeID) then
570: fnd_message.set_name('SQLAP', 'AP_WEB_PREP_CANNOT_APPROVE');
571: p_ap_error := fnd_message.get_encoded();
572: elsif (l_ApproverID = to_number(p_employee_id)) then
573: fnd_message.set_name('SQLAP', 'AP_WEB_EMP_CANNOT_APPROVE');
574: p_ap_error := fnd_message.get_encoded();
575: else
576: -- Assign the p_approverID only if there are no errors
577: p_approverID := to_char(l_approverid);

Line 574: p_ap_error := fnd_message.get_encoded();

570: fnd_message.set_name('SQLAP', 'AP_WEB_PREP_CANNOT_APPROVE');
571: p_ap_error := fnd_message.get_encoded();
572: elsif (l_ApproverID = to_number(p_employee_id)) then
573: fnd_message.set_name('SQLAP', 'AP_WEB_EMP_CANNOT_APPROVE');
574: p_ap_error := fnd_message.get_encoded();
575: else
576: -- Assign the p_approverID only if there are no errors
577: p_approverID := to_char(l_approverid);
578: p_approverName := l_approverfullname;

Line 624: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_COST_CENTER_INVALID');

620: -- custom error message is null
621: --
622: if (l_customError is null) then
623: if (not l_IsMobileApp) then
624: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_COST_CENTER_INVALID');
625: else
626: FND_MESSAGE.SET_NAME('SQLAP','AP_OME_COST_CENTER_ERROR');
627: end if;
628: p_cs_error:= fnd_message.get_encoded();

Line 626: FND_MESSAGE.SET_NAME('SQLAP','AP_OME_COST_CENTER_ERROR');

622: if (l_customError is null) then
623: if (not l_IsMobileApp) then
624: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_COST_CENTER_INVALID');
625: else
626: FND_MESSAGE.SET_NAME('SQLAP','AP_OME_COST_CENTER_ERROR');
627: end if;
628: p_cs_error:= fnd_message.get_encoded();
629: else
630: p_cs_error := l_customError;

Line 628: p_cs_error:= fnd_message.get_encoded();

624: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_COST_CENTER_INVALID');
625: else
626: FND_MESSAGE.SET_NAME('SQLAP','AP_OME_COST_CENTER_ERROR');
627: end if;
628: p_cs_error:= fnd_message.get_encoded();
629: else
630: p_cs_error := l_customError;
631: end if;
632: end if;

Line 649: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_COST_CENTER_INVALID');

645: --
646: -- Failed; set standard failure message.
647: --
648: if (not l_IsMobileApp) then
649: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_COST_CENTER_INVALID');
650: else
651: FND_MESSAGE.SET_NAME('SQLAP','AP_OME_COST_CENTER_ERROR');
652: end if;
653: p_cs_error:= fnd_message.get_encoded();

Line 651: FND_MESSAGE.SET_NAME('SQLAP','AP_OME_COST_CENTER_ERROR');

647: --
648: if (not l_IsMobileApp) then
649: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_COST_CENTER_INVALID');
650: else
651: FND_MESSAGE.SET_NAME('SQLAP','AP_OME_COST_CENTER_ERROR');
652: end if;
653: p_cs_error:= fnd_message.get_encoded();
654: end if;
655: end if;

Line 653: p_cs_error:= fnd_message.get_encoded();

649: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_COST_CENTER_INVALID');
650: else
651: FND_MESSAGE.SET_NAME('SQLAP','AP_OME_COST_CENTER_ERROR');
652: end if;
653: p_cs_error:= fnd_message.get_encoded();
654: end if;
655: end if;
656:
657: -- Bug: 5161664, Default Expense Account Validation.

Line 674: -- BuildAccount will in itself add to fnd message pub, initialize to avoid that

670: p_new_segments => l_default_emp_segments,
671: p_new_ccid => l_employee_ccid,
672: p_return_error_message => l_error_message);
673: IF (l_error_message IS NOT NULL) THEN
674: -- BuildAccount will in itself add to fnd message pub, initialize to avoid that
675: -- No side effects with initialize in Spread Sheet import, all error messages properly displayed.
676: fnd_msg_pub.initialize;
677: FND_MESSAGE.SET_NAME('SQLAP','OIE_DEA_VALIDATION_ERROR');
678: FND_MESSAGE.SET_TOKEN('VAL_ERROR', l_error_message);

Line 677: FND_MESSAGE.SET_NAME('SQLAP','OIE_DEA_VALIDATION_ERROR');

673: IF (l_error_message IS NOT NULL) THEN
674: -- BuildAccount will in itself add to fnd message pub, initialize to avoid that
675: -- No side effects with initialize in Spread Sheet import, all error messages properly displayed.
676: fnd_msg_pub.initialize;
677: FND_MESSAGE.SET_NAME('SQLAP','OIE_DEA_VALIDATION_ERROR');
678: FND_MESSAGE.SET_TOKEN('VAL_ERROR', l_error_message);
679: p_cs_error:= fnd_message.get_encoded();
680: END IF;
681: END IF;

Line 678: FND_MESSAGE.SET_TOKEN('VAL_ERROR', l_error_message);

674: -- BuildAccount will in itself add to fnd message pub, initialize to avoid that
675: -- No side effects with initialize in Spread Sheet import, all error messages properly displayed.
676: fnd_msg_pub.initialize;
677: FND_MESSAGE.SET_NAME('SQLAP','OIE_DEA_VALIDATION_ERROR');
678: FND_MESSAGE.SET_TOKEN('VAL_ERROR', l_error_message);
679: p_cs_error:= fnd_message.get_encoded();
680: END IF;
681: END IF;
682:

Line 679: p_cs_error:= fnd_message.get_encoded();

675: -- No side effects with initialize in Spread Sheet import, all error messages properly displayed.
676: fnd_msg_pub.initialize;
677: FND_MESSAGE.SET_NAME('SQLAP','OIE_DEA_VALIDATION_ERROR');
678: FND_MESSAGE.SET_TOKEN('VAL_ERROR', l_error_message);
679: p_cs_error:= fnd_message.get_encoded();
680: END IF;
681: END IF;
682:
683: EXCEPTION

Line 866: fnd_message.set_name('SQLAP', 'AP_WEB_OVERRIDER_REQUIRED');

862: p_apps_id => null );
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,

Line 868: fnd_message.get_encoded(),

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,
872: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 908: fnd_message.set_name('SQLAP','AP_WEB_DISCON_OVERRIDER_CC');

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');
909: AP_WEB_UTILITIES_PKG.AddExpError(
910: p_error,
911: fnd_message.get_encoded(),
912: AP_WEB_UTILITIES_PKG.C_ErrorMessageType ,

Line 911: fnd_message.get_encoded(),

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,
914: 0,
915: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 961: fnd_message.set_name( 'SQLAP', 'AP_WEB_COST_CENTER_INVALID' );

957: -- Validate Cost Center
958: debug_info := 'Validate Cost Center';
959: IF ( ExpReportHeaderInfo.cost_center IS NULL ) THEN
960: if (not l_IsMobileApp) then
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(

Line 963: fnd_message.set_name( 'SQLAP', 'AP_OME_COST_CENTER_ERROR' );

959: IF ( ExpReportHeaderInfo.cost_center IS NULL ) THEN
960: if (not l_IsMobileApp) then
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(),

Line 967: fnd_message.get_encoded(),

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',
970: 0,
971: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1004: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_TEMP_INVALID');

1000: END IF;
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',

Line 1006: fnd_message.get_encoded(),

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,
1010: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1025: FND_MESSAGE.SET_NAME( 'SQLAP','AP_WEB_LAST_RECDATE_INVALID' );

1021: END IF;
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,

Line 1028: fnd_message.get_encoded(),

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',
1031: 0,
1032: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1056: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_INVALID_REIMB_CURR');

1052:
1053: l_default_reimb_curr := nvl(l_vend_pay_curr, l_base_currency);
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);

Line 1057: FND_MESSAGE.SET_TOKEN('FUNCTIONAL_CURRENCY',l_default_reimb_curr);

1053: l_default_reimb_curr := nvl(l_vend_pay_curr, l_base_currency);
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;

Line 1059: fnd_message.get_encoded(),

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;
1063:

Line 1068: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: -- JMARY have to handle this error for NEWUI
1067: BEGIN
1068: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1069: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1070: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1071: current_calling_sequence);
1072:

Line 1069: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1065: WHEN OTHERS THEN
1066: -- JMARY have to handle this error for NEWUI
1067: BEGIN
1068: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1069: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1070: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1071: current_calling_sequence);
1072:
1073: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 1070: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

1066: -- JMARY have to handle this error for NEWUI
1067: BEGIN
1068: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1069: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1070: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1071: current_calling_sequence);
1072:
1073: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1074:

Line 1073: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

1069: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1070: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1071: current_calling_sequence);
1072:
1073: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1074:
1075: APP_EXCEPTION.RAISE_EXCEPTION;
1076: END;
1077: END ValidateHeaderNoValidSession;

Line 1397: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1393: EXCEPTION
1394: WHEN OTHERS THEN
1395: BEGIN
1396: IF (SQLCODE <> -20001) THEN
1397: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1398: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1399: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1400: 'ValidateExpLineCustomFields');
1401: FND_MESSAGE.SET_TOKEN('PARAMETERS',

Line 1398: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1394: WHEN OTHERS THEN
1395: BEGIN
1396: IF (SQLCODE <> -20001) THEN
1397: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1398: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1399: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1400: 'ValidateExpLineCustomFields');
1401: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1402: 'None passed.');

Line 1399: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

1395: BEGIN
1396: IF (SQLCODE <> -20001) THEN
1397: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1398: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1399: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1400: 'ValidateExpLineCustomFields');
1401: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1402: 'None passed.');
1403: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 1401: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1397: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1398: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1399: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1400: 'ValidateExpLineCustomFields');
1401: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1402: 'None passed.');
1403: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1404: END IF;
1405: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1403: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1399: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1400: 'ValidateExpLineCustomFields');
1401: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1402: 'None passed.');
1403: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1404: END IF;
1405: APP_EXCEPTION.RAISE_EXCEPTION;
1406: END;
1407: END ValidateExpLineCustomFields;

Line 1479: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_FIXED');

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:
1482: l_reimbcurr_format := FND_CURRENCY.get_format_mask(p_report_header_info.reimbursement_currency_code, 30);
1483:

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

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

Line 1514: fnd_message.set_name('SQLAP', 'AP_WEB_ST_DATE_FIRST');

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,
1516: fnd_message.get_encoded(),
1517: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1518: C_Date1_Prompt,

Line 1516: fnd_message.get_encoded(),

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,
1520: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1529: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR');

1525:
1526: -- Check whether year is Valid
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,

Line 1530: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));

1526: -- Check whether year is Valid
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,

Line 1532: fnd_message.get_encoded(),

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,
1536: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1552: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_START_DATE_INVALID');

1548: end if;
1549: EXCEPTION
1550: when OTHERS then
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(),

Line 1553: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);

1549: EXCEPTION
1550: when OTHERS then
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,

Line 1554: FND_MESSAGE.SET_TOKEN('PROPER_FORMAT', to_char(sysdate, l_date_format));

1550: when OTHERS then
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,

Line 1556: fnd_message.get_encoded(),

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,
1560: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1584: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR_START_DATE');

1580: -- Bug 6392916 (sodash)
1581: -- Checking whether the start date is valid
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,

Line 1585: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));

1581: -- Checking whether the start date is valid
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,

Line 1587: fnd_message.get_encoded(),

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,
1591: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1600: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR_END_DATE');

1596: if (l_time_based_entry_flag='Y' AND
1597: p_report_line_info.end_date IS NOT NULL AND
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,

Line 1601: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));

1597: p_report_line_info.end_date IS NOT NULL AND
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,

Line 1603: fnd_message.get_encoded(),

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,
1607: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1620: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_END_DATE_INVALID');

1616: end if;
1617: EXCEPTION
1618: when OTHERS then
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(),

Line 1621: FND_MESSAGE.SET_TOKEN('END_DATE', p_report_line_info.end_date);

1617: EXCEPTION
1618: when OTHERS then
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,

Line 1622: FND_MESSAGE.SET_TOKEN('PROPER_FORMAT', to_char(sysdate, l_date_format));

1618: when OTHERS then
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,

Line 1624: fnd_message.get_encoded(),

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,
1628: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1639: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_START_AFTER_END');

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);
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(),

Line 1640: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);

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);
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,

Line 1641: FND_MESSAGE.SET_TOKEN('END_DATE', p_report_line_info.end_date);

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);
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,

Line 1643: fnd_message.get_encoded(),

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,
1647: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1689: fnd_message.set_name('SQLAP', 'AP_WEB_WRONG_NUM_OF_DAYS');

1685: -- We DO want to make sure the number of days matches with
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,

Line 1691: fnd_message.get_encoded(),

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,
1695: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1700: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_DAYS_INVALID');

1696: end if;
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,

Line 1702: fnd_message.get_encoded(),

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,
1706: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1728: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_DAILY_AMOUNT_INVALID');

1724: NULL;
1725: end if;
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,

Line 1731: fnd_message.get_encoded(),

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,
1735: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1765: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RECEIPT_AMT_INCORRECT');

1761: l_amount := to_number(to_char(l_receiptAmount/l_num, l_reccurr_format));
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,

Line 1767: fnd_message.get_encoded(),

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,
1771: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1794: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_CURRENCY_NO_DECIMALS');

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);
1797: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1798: fnd_message.get_encoded(),

Line 1795: FND_MESSAGE.SET_TOKEN('RECEIPT_CURRENCY',

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);
1797: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1798: fnd_message.get_encoded(),
1799: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

Line 1798: fnd_message.get_encoded(),

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,
1802: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1809: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RECEIPT_AMOUNT_INVALID');

1805: end if; /* CheckNum */
1806: end if;
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,

Line 1812: fnd_message.get_encoded(),

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,
1816: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1874: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_SAMECURR_RATE');

1870: -- if RecCurr = p_report_header_info.reimbursement_currency_code, and rate <> 1, it's an 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,

Line 1876: fnd_message.get_encoded(),

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,
1880: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 1892: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RATE_INVALID');

1888: end if; /* if l_rate_exists */
1889:
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,

Line 1895: fnd_message.get_encoded(),

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,
1899: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 2004: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_TOTAL_AMT_INCORRECT');

2000: ELSE
2001: l_cal_amount_method := '*';
2002: END IF;
2003:
2004: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_TOTAL_AMT_INCORRECT');
2005: FND_MESSAGE.SET_TOKEN('Total_Amount',
2006: p_report_line_info.amount);
2007: FND_MESSAGE.SET_TOKEN('receipt_amount',to_char(l_orig_num));
2008: FND_MESSAGE.SET_TOKEN('amount_method',l_cal_amount_method);

Line 2005: FND_MESSAGE.SET_TOKEN('Total_Amount',

2001: l_cal_amount_method := '*';
2002: END IF;
2003:
2004: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_TOTAL_AMT_INCORRECT');
2005: FND_MESSAGE.SET_TOKEN('Total_Amount',
2006: p_report_line_info.amount);
2007: FND_MESSAGE.SET_TOKEN('receipt_amount',to_char(l_orig_num));
2008: FND_MESSAGE.SET_TOKEN('amount_method',l_cal_amount_method);
2009: FND_MESSAGE.SET_TOKEN('rate',to_char(l_rate));

Line 2007: FND_MESSAGE.SET_TOKEN('receipt_amount',to_char(l_orig_num));

2003:
2004: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_TOTAL_AMT_INCORRECT');
2005: FND_MESSAGE.SET_TOKEN('Total_Amount',
2006: p_report_line_info.amount);
2007: FND_MESSAGE.SET_TOKEN('receipt_amount',to_char(l_orig_num));
2008: FND_MESSAGE.SET_TOKEN('amount_method',l_cal_amount_method);
2009: FND_MESSAGE.SET_TOKEN('rate',to_char(l_rate));
2010: FND_MESSAGE.SET_TOKEN('result',to_char(l_amount));
2011:

Line 2008: FND_MESSAGE.SET_TOKEN('amount_method',l_cal_amount_method);

2004: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_TOTAL_AMT_INCORRECT');
2005: FND_MESSAGE.SET_TOKEN('Total_Amount',
2006: p_report_line_info.amount);
2007: FND_MESSAGE.SET_TOKEN('receipt_amount',to_char(l_orig_num));
2008: FND_MESSAGE.SET_TOKEN('amount_method',l_cal_amount_method);
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

Line 2009: FND_MESSAGE.SET_TOKEN('rate',to_char(l_rate));

2005: FND_MESSAGE.SET_TOKEN('Total_Amount',
2006: p_report_line_info.amount);
2007: FND_MESSAGE.SET_TOKEN('receipt_amount',to_char(l_orig_num));
2008: FND_MESSAGE.SET_TOKEN('amount_method',l_cal_amount_method);
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(

Line 2010: FND_MESSAGE.SET_TOKEN('result',to_char(l_amount));

2006: p_report_line_info.amount);
2007: FND_MESSAGE.SET_TOKEN('receipt_amount',to_char(l_orig_num));
2008: FND_MESSAGE.SET_TOKEN('amount_method',l_cal_amount_method);
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,

Line 2015: fnd_message.get_encoded(),

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,
2018: C_Amount_Prompt,
2019: p_receiptcount,

Line 2032: fnd_message.set_name('SQLAP','AP_WEB_FIXED_RATE_APPLIED');

2028: end if;
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,

Line 2034: fnd_message.get_encoded(),

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,
2038: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 2045: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_TOTAL_AMOUNT_INVALID');

2041: */
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,

Line 2047: fnd_message.get_encoded(),

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,
2051: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 2060: fnd_message.set_name('SQLAP', 'AP_WEB_TOTAL_REQUIRED');

2056: --
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,

Line 2062: fnd_message.get_encoded(),

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,
2066: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 2095: fnd_message.set_name('SQLAP', 'AP_WEB_EXPENSE_TYPE_REQUIRED');

2091: debug_info := 'Expense type';
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,

Line 2097: fnd_message.get_encoded(),

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,
2101: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 2119: fnd_message.set_name('SQLAP', 'AP_WEB_JUSTIFICATION_REQUIRED');

2115: exit;
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,

Line 2121: fnd_message.get_encoded(),

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,
2125: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

Line 2137: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

2133: EXCEPTION
2134: WHEN OTHERS THEN
2135: BEGIN
2136: IF (SQLCODE <> -20001) THEN
2137: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2138: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2139: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2140: 'ValidateExpLineCoreFields');
2141: FND_MESSAGE.SET_TOKEN('PARAMETERS',

Line 2138: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

2134: WHEN OTHERS THEN
2135: BEGIN
2136: IF (SQLCODE <> -20001) THEN
2137: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2138: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2139: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2140: 'ValidateExpLineCoreFields');
2141: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2142: 'None passed.');

Line 2139: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

2135: BEGIN
2136: IF (SQLCODE <> -20001) THEN
2137: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2138: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2139: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2140: 'ValidateExpLineCoreFields');
2141: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2142: 'None passed.');
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 2141: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2137: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2138: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2139: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2140: 'ValidateExpLineCoreFields');
2141: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2142: 'None passed.');
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2144: END IF;
2145:

Line 2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

2139: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2140: 'ValidateExpLineCoreFields');
2141: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2142: 'None passed.');
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2144: END IF;
2145:
2146: APP_EXCEPTION.RAISE_EXCEPTION;
2147: END;

Line 2558: fnd_message.set_name('SQLAP', 'OIE_DATA_CALCULATED_DIFFER');

2554: );
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',

Line 2560: fnd_message.get_encoded(),

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,
2564: AP_WEB_UTILITIES_PKG.C_DFFMessageCategory);

Line 2589: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

2585: EXCEPTION
2586: WHEN OTHERS THEN
2587: BEGIN
2588: IF (SQLCODE <> -20001) THEN
2589: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2590: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2591: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2592: 'ValidateExpLine');
2593: FND_MESSAGE.SET_TOKEN('PARAMETERS',

Line 2590: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

2586: WHEN OTHERS THEN
2587: BEGIN
2588: IF (SQLCODE <> -20001) THEN
2589: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2590: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2591: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2592: 'ValidateExpLine');
2593: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2594: 'None passed.');

Line 2591: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

2587: BEGIN
2588: IF (SQLCODE <> -20001) THEN
2589: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2590: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2591: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2592: 'ValidateExpLine');
2593: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2594: 'None passed.');
2595: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 2593: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2589: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2590: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2591: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2592: 'ValidateExpLine');
2593: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2594: 'None passed.');
2595: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2596: END IF;
2597: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2595: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

2591: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2592: 'ValidateExpLine');
2593: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2594: 'None passed.');
2595: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2596: END IF;
2597: APP_EXCEPTION.RAISE_EXCEPTION;
2598: END;
2599: END ValidateExpLine;

Line 2739: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

2735:
2736: EXCEPTION
2737: WHEN OTHERS THEN
2738: BEGIN
2739: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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);

Line 2740: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

2736: EXCEPTION
2737: WHEN OTHERS THEN
2738: BEGIN
2739: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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);

Line 2741: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_CurrentCallingSequence);

2737: WHEN OTHERS THEN
2738: BEGIN
2739: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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;

Line 2742: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');

2738: BEGIN
2739: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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:

Line 2743: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_DebugInfo);

2739: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
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;

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 2771: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

2767: EXCEPTION
2768: WHEN OTHERS THEN
2769: BEGIN
2770: IF (SQLCODE <> -20001) THEN
2771: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2772: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2773: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2774: 'initJustificationRequiredArray');
2775: FND_MESSAGE.SET_TOKEN('PARAMETERS',

Line 2772: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

2768: WHEN OTHERS THEN
2769: BEGIN
2770: IF (SQLCODE <> -20001) THEN
2771: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2772: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2773: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2774: 'initJustificationRequiredArray');
2775: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2776: 'None passed.');

Line 2773: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

2769: BEGIN
2770: IF (SQLCODE <> -20001) THEN
2771: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2772: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2773: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2774: 'initJustificationRequiredArray');
2775: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2776: 'None passed.');
2777: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 2775: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2771: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2772: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2773: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2774: 'initJustificationRequiredArray');
2775: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2776: 'None passed.');
2777: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2778: END IF;
2779: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2777: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

2773: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2774: 'initJustificationRequiredArray');
2775: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2776: 'None passed.');
2777: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2778: END IF;
2779: APP_EXCEPTION.RAISE_EXCEPTION;
2780: END;
2781: END initJustificationRequiredArray;