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

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

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

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

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

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

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

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

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

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

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

646: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_COST_CENTER_INVALID');
647: else
648: FND_MESSAGE.SET_NAME('SQLAP','AP_OME_COST_CENTER_ERROR');
649: end if;
650: p_cs_error:= fnd_message.get_encoded();
651: end if;
652: end if;
653:
654: END ValidateCostCenter;

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

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

Line 834: fnd_message.get_encoded(),

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

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

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

Line 877: fnd_message.get_encoded(),

873: IF ( ExpReportHeaderInfo.override_approver_name IS NULL ) THEN
874: fnd_message.set_name('SQLAP','AP_WEB_DISCON_OVERRIDER_CC');
875: AP_WEB_UTILITIES_PKG.AddExpError(
876: p_error,
877: fnd_message.get_encoded(),
878: AP_WEB_UTILITIES_PKG.C_ErrorMessageType ,
879: null,
880: 0,
881: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, l_IsMobileApp);

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

923: -- Validate Cost Center
924: debug_info := 'Validate Cost Center';
925: IF ( ExpReportHeaderInfo.cost_center IS NULL ) THEN
926: if (not l_IsMobileApp) then
927: fnd_message.set_name( 'SQLAP', 'AP_WEB_COST_CENTER_INVALID' );
928: else
929: fnd_message.set_name( 'SQLAP', 'AP_OME_COST_CENTER_ERROR' );
930: end if;
931: AP_WEB_UTILITIES_PKG.AddExpError(

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

925: IF ( ExpReportHeaderInfo.cost_center IS NULL ) THEN
926: if (not l_IsMobileApp) then
927: fnd_message.set_name( 'SQLAP', 'AP_WEB_COST_CENTER_INVALID' );
928: else
929: fnd_message.set_name( 'SQLAP', 'AP_OME_COST_CENTER_ERROR' );
930: end if;
931: AP_WEB_UTILITIES_PKG.AddExpError(
932: p_error,
933: fnd_message.get_encoded(),

Line 933: fnd_message.get_encoded(),

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

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

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

Line 972: fnd_message.get_encoded(),

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

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

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

Line 994: fnd_message.get_encoded(),

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

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

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

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

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

Line 1025: fnd_message.get_encoded(),

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

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

1030: EXCEPTION
1031: WHEN OTHERS THEN
1032: -- JMARY have to handle this error for NEWUI
1033: BEGIN
1034: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1035: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1036: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1037: current_calling_sequence);
1038:

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

1031: WHEN OTHERS THEN
1032: -- JMARY have to handle this error for NEWUI
1033: BEGIN
1034: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1035: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1036: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1037: current_calling_sequence);
1038:
1039: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 1036: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

1032: -- JMARY have to handle this error for NEWUI
1033: BEGIN
1034: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1035: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1036: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1037: current_calling_sequence);
1038:
1039: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1040:

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

1035: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1036: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1037: current_calling_sequence);
1038:
1039: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1040:
1041: APP_EXCEPTION.RAISE_EXCEPTION;
1042: END;
1043: END ValidateHeaderNoValidSession;

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

1359: EXCEPTION
1360: WHEN OTHERS THEN
1361: BEGIN
1362: IF (SQLCODE <> -20001) THEN
1363: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1364: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1365: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1366: 'ValidateExpLineCustomFields');
1367: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

1360: WHEN OTHERS THEN
1361: BEGIN
1362: IF (SQLCODE <> -20001) THEN
1363: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1364: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1365: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1366: 'ValidateExpLineCustomFields');
1367: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1368: 'None passed.');

Line 1365: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

1361: BEGIN
1362: IF (SQLCODE <> -20001) THEN
1363: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1364: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1365: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1366: 'ValidateExpLineCustomFields');
1367: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1368: 'None passed.');
1369: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 1367: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1363: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1364: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1365: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1366: 'ValidateExpLineCustomFields');
1367: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1368: 'None passed.');
1369: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1370: END IF;
1371: APP_EXCEPTION.RAISE_EXCEPTION;

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

1365: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1366: 'ValidateExpLineCustomFields');
1367: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1368: 'None passed.');
1369: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1370: END IF;
1371: APP_EXCEPTION.RAISE_EXCEPTION;
1372: END;
1373: END ValidateExpLineCustomFields;

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

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

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

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

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

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

Line 1482: fnd_message.get_encoded(),

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

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

1491:
1492: -- Check whether year is Valid
1493: if (NOT IsValidYear(l_date1_temp) AND (p_report_line_info.category_code <> 'PER_DIEM') )THEN
1494: l_dates_ok := false;
1495: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR');
1496: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1497: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1498: fnd_message.get_encoded(),
1499: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

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

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

Line 1498: fnd_message.get_encoded(),

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

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

1514: end if;
1515: EXCEPTION
1516: when OTHERS then
1517: l_dates_ok := false;
1518: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_START_DATE_INVALID');
1519: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);
1520: FND_MESSAGE.SET_TOKEN('PROPER_FORMAT', to_char(sysdate, l_date_format));
1521: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1522: fnd_message.get_encoded(),

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

1515: EXCEPTION
1516: when OTHERS then
1517: l_dates_ok := false;
1518: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_START_DATE_INVALID');
1519: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);
1520: FND_MESSAGE.SET_TOKEN('PROPER_FORMAT', to_char(sysdate, l_date_format));
1521: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1522: fnd_message.get_encoded(),
1523: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

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

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

Line 1522: fnd_message.get_encoded(),

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

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

1546: -- Bug 6392916 (sodash)
1547: -- Checking whether the start date is valid
1548: if (NOT IsValidYear(l_date1_temp)) THEN
1549: l_dates_ok := false;
1550: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR_START_DATE');
1551: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1552: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1553: fnd_message.get_encoded(),
1554: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

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

1547: -- Checking whether the start date is valid
1548: if (NOT IsValidYear(l_date1_temp)) THEN
1549: l_dates_ok := false;
1550: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR_START_DATE');
1551: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1552: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1553: fnd_message.get_encoded(),
1554: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1555: C_Date1_Prompt,

Line 1553: fnd_message.get_encoded(),

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

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

1562: if (l_time_based_entry_flag='Y' AND
1563: p_report_line_info.end_date IS NOT NULL AND
1564: NOT IsValidYear(l_date2_temp)) THEN
1565: l_dates_ok := false;
1566: fnd_message.set_name('SQLAP', 'OIE_INVALID_YEAR_END_DATE');
1567: fnd_message.set_token('MINIMUM_YEAR', to_char(C_MinimumYear));
1568: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1569: fnd_message.get_encoded(),
1570: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

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

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

Line 1569: fnd_message.get_encoded(),

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

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

1582: end if;
1583: EXCEPTION
1584: when OTHERS then
1585: l_dates_ok := false;
1586: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_END_DATE_INVALID');
1587: FND_MESSAGE.SET_TOKEN('END_DATE', p_report_line_info.end_date);
1588: FND_MESSAGE.SET_TOKEN('PROPER_FORMAT', to_char(sysdate, l_date_format));
1589: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1590: fnd_message.get_encoded(),

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

1583: EXCEPTION
1584: when OTHERS then
1585: l_dates_ok := false;
1586: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_END_DATE_INVALID');
1587: FND_MESSAGE.SET_TOKEN('END_DATE', p_report_line_info.end_date);
1588: FND_MESSAGE.SET_TOKEN('PROPER_FORMAT', to_char(sysdate, l_date_format));
1589: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1590: fnd_message.get_encoded(),
1591: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

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

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

Line 1590: fnd_message.get_encoded(),

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

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

1601: debug_info:= 'Day1 < Day2?';
1602: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1603: if (l_dates_ok) then
1604: if (l_date1_temp > nvl(l_date2_temp, l_date1_temp)) then
1605: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_START_AFTER_END');
1606: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);
1607: FND_MESSAGE.SET_TOKEN('END_DATE', p_report_line_info.end_date);
1608: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1609: fnd_message.get_encoded(),

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

1602: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', debug_info);
1603: if (l_dates_ok) then
1604: if (l_date1_temp > nvl(l_date2_temp, l_date1_temp)) then
1605: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_START_AFTER_END');
1606: FND_MESSAGE.SET_TOKEN('START_DATE', p_report_line_info.start_date);
1607: FND_MESSAGE.SET_TOKEN('END_DATE', p_report_line_info.end_date);
1608: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1609: fnd_message.get_encoded(),
1610: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

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

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

Line 1609: fnd_message.get_encoded(),

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

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

1651: -- We DO want to make sure the number of days matches with
1652: -- the real range of dates.
1653: elsif ((l_date2_temp - l_date1_temp + 1) <> l_num)
1654: then
1655: fnd_message.set_name('SQLAP', 'AP_WEB_WRONG_NUM_OF_DAYS');
1656: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1657: fnd_message.get_encoded(),
1658: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1659: C_Days_Prompt,

Line 1657: fnd_message.get_encoded(),

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

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

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

Line 1668: fnd_message.get_encoded(),

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

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

1690: NULL;
1691: end if;
1692: EXCEPTION
1693: when OTHERS then
1694: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_DAILY_AMOUNT_INVALID');
1695: p_report_line_info.daily_amount := null;
1696: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1697: fnd_message.get_encoded(),
1698: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

Line 1697: fnd_message.get_encoded(),

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

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

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

Line 1733: fnd_message.get_encoded(),

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

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

1756:
1757: if (NOT WithinTolerance (l_receiptAmount,
1758: AP_UTILITIES_PKG.AP_ROUND_CURRENCY(l_receiptAmount,
1759: p_report_line_info.currency_code))) then
1760: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_CURRENCY_NO_DECIMALS');
1761: FND_MESSAGE.SET_TOKEN('RECEIPT_CURRENCY',
1762: p_report_line_info.currency_code);
1763: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1764: fnd_message.get_encoded(),

Line 1761: FND_MESSAGE.SET_TOKEN('RECEIPT_CURRENCY',

1757: if (NOT WithinTolerance (l_receiptAmount,
1758: AP_UTILITIES_PKG.AP_ROUND_CURRENCY(l_receiptAmount,
1759: p_report_line_info.currency_code))) then
1760: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_CURRENCY_NO_DECIMALS');
1761: FND_MESSAGE.SET_TOKEN('RECEIPT_CURRENCY',
1762: p_report_line_info.currency_code);
1763: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1764: fnd_message.get_encoded(),
1765: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

Line 1764: fnd_message.get_encoded(),

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

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

1771: end if; /* CheckNum */
1772: end if;
1773: EXCEPTION
1774: when OTHERS then
1775: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RECEIPT_AMOUNT_INVALID');
1776: p_report_line_info.receipt_amount := null;
1777: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1778: fnd_message.get_encoded(),
1779: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

Line 1778: fnd_message.get_encoded(),

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

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

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

Line 1842: fnd_message.get_encoded(),

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

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

1854: end if; /* if l_rate_exists */
1855:
1856: EXCEPTION
1857: when OTHERS then
1858: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_RATE_INVALID');
1859: p_report_line_info.rate := null;
1860: AP_WEB_UTILITIES_PKG.AddExpError(p_exp_error,
1861: fnd_message.get_encoded(),
1862: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

Line 1861: fnd_message.get_encoded(),

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

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

1966: ELSE
1967: l_cal_amount_method := '*';
1968: END IF;
1969:
1970: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_TOTAL_AMT_INCORRECT');
1971: FND_MESSAGE.SET_TOKEN('Total_Amount',
1972: p_report_line_info.amount);
1973: FND_MESSAGE.SET_TOKEN('receipt_amount',to_char(l_orig_num));
1974: FND_MESSAGE.SET_TOKEN('amount_method',l_cal_amount_method);

Line 1971: FND_MESSAGE.SET_TOKEN('Total_Amount',

1967: l_cal_amount_method := '*';
1968: END IF;
1969:
1970: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_TOTAL_AMT_INCORRECT');
1971: FND_MESSAGE.SET_TOKEN('Total_Amount',
1972: p_report_line_info.amount);
1973: FND_MESSAGE.SET_TOKEN('receipt_amount',to_char(l_orig_num));
1974: FND_MESSAGE.SET_TOKEN('amount_method',l_cal_amount_method);
1975: FND_MESSAGE.SET_TOKEN('rate',to_char(l_rate));

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

1969:
1970: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_TOTAL_AMT_INCORRECT');
1971: FND_MESSAGE.SET_TOKEN('Total_Amount',
1972: p_report_line_info.amount);
1973: FND_MESSAGE.SET_TOKEN('receipt_amount',to_char(l_orig_num));
1974: FND_MESSAGE.SET_TOKEN('amount_method',l_cal_amount_method);
1975: FND_MESSAGE.SET_TOKEN('rate',to_char(l_rate));
1976: FND_MESSAGE.SET_TOKEN('result',to_char(l_amount));
1977:

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

1970: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_TOTAL_AMT_INCORRECT');
1971: FND_MESSAGE.SET_TOKEN('Total_Amount',
1972: p_report_line_info.amount);
1973: FND_MESSAGE.SET_TOKEN('receipt_amount',to_char(l_orig_num));
1974: FND_MESSAGE.SET_TOKEN('amount_method',l_cal_amount_method);
1975: FND_MESSAGE.SET_TOKEN('rate',to_char(l_rate));
1976: FND_MESSAGE.SET_TOKEN('result',to_char(l_amount));
1977:
1978: -- JMARY Have to create a new message for this error

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

1971: FND_MESSAGE.SET_TOKEN('Total_Amount',
1972: p_report_line_info.amount);
1973: FND_MESSAGE.SET_TOKEN('receipt_amount',to_char(l_orig_num));
1974: FND_MESSAGE.SET_TOKEN('amount_method',l_cal_amount_method);
1975: FND_MESSAGE.SET_TOKEN('rate',to_char(l_rate));
1976: FND_MESSAGE.SET_TOKEN('result',to_char(l_amount));
1977:
1978: -- JMARY Have to create a new message for this error
1979: AP_WEB_UTILITIES_PKG.AddExpError(

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

1972: p_report_line_info.amount);
1973: FND_MESSAGE.SET_TOKEN('receipt_amount',to_char(l_orig_num));
1974: FND_MESSAGE.SET_TOKEN('amount_method',l_cal_amount_method);
1975: FND_MESSAGE.SET_TOKEN('rate',to_char(l_rate));
1976: FND_MESSAGE.SET_TOKEN('result',to_char(l_amount));
1977:
1978: -- JMARY Have to create a new message for this error
1979: AP_WEB_UTILITIES_PKG.AddExpError(
1980: p_exp_error,

Line 1981: fnd_message.get_encoded(),

1977:
1978: -- JMARY Have to create a new message for this error
1979: AP_WEB_UTILITIES_PKG.AddExpError(
1980: p_exp_error,
1981: fnd_message.get_encoded(),
1982: -- || TO_CHAR(l_orig_num) || l_cal_amount_method || TO_CHAR(l_rate) || '=' ||TO_CHAR(l_amount) ,
1983: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1984: C_Amount_Prompt,
1985: p_receiptcount,

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

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

Line 2000: fnd_message.get_encoded(),

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

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

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

Line 2013: fnd_message.get_encoded(),

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

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

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

Line 2028: fnd_message.get_encoded(),

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

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

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

Line 2063: fnd_message.get_encoded(),

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

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

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

Line 2087: fnd_message.get_encoded(),

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

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

2099: EXCEPTION
2100: WHEN OTHERS THEN
2101: BEGIN
2102: IF (SQLCODE <> -20001) THEN
2103: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2104: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2105: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2106: 'ValidateExpLineCoreFields');
2107: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

2100: WHEN OTHERS THEN
2101: BEGIN
2102: IF (SQLCODE <> -20001) THEN
2103: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2104: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2105: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2106: 'ValidateExpLineCoreFields');
2107: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2108: 'None passed.');

Line 2105: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

2101: BEGIN
2102: IF (SQLCODE <> -20001) THEN
2103: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2104: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2105: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2106: 'ValidateExpLineCoreFields');
2107: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2108: 'None passed.');
2109: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 2107: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2103: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2104: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2105: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2106: 'ValidateExpLineCoreFields');
2107: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2108: 'None passed.');
2109: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2110: END IF;
2111:

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

2105: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2106: 'ValidateExpLineCoreFields');
2107: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2108: 'None passed.');
2109: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2110: END IF;
2111:
2112: APP_EXCEPTION.RAISE_EXCEPTION;
2113: END;

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

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

Line 2526: fnd_message.get_encoded(),

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

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

2551: EXCEPTION
2552: WHEN OTHERS THEN
2553: BEGIN
2554: IF (SQLCODE <> -20001) THEN
2555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2556: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2557: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2558: 'ValidateExpLine');
2559: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

2552: WHEN OTHERS THEN
2553: BEGIN
2554: IF (SQLCODE <> -20001) THEN
2555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2556: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2557: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2558: 'ValidateExpLine');
2559: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2560: 'None passed.');

Line 2557: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

2553: BEGIN
2554: IF (SQLCODE <> -20001) THEN
2555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2556: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2557: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2558: 'ValidateExpLine');
2559: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2560: 'None passed.');
2561: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 2559: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2556: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2557: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2558: 'ValidateExpLine');
2559: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2560: 'None passed.');
2561: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2562: END IF;
2563: APP_EXCEPTION.RAISE_EXCEPTION;

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

2557: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2558: 'ValidateExpLine');
2559: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2560: 'None passed.');
2561: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2562: END IF;
2563: APP_EXCEPTION.RAISE_EXCEPTION;
2564: END;
2565: END ValidateExpLine;

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

2701:
2702: EXCEPTION
2703: WHEN OTHERS THEN
2704: BEGIN
2705: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2706: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2707: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_CurrentCallingSequence);
2708: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
2709: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_DebugInfo);

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

2702: EXCEPTION
2703: WHEN OTHERS THEN
2704: BEGIN
2705: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2706: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2707: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_CurrentCallingSequence);
2708: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
2709: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_DebugInfo);
2710: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);

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

2703: WHEN OTHERS THEN
2704: BEGIN
2705: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2706: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2707: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_CurrentCallingSequence);
2708: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
2709: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_DebugInfo);
2710: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2711: END;

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

2704: BEGIN
2705: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2706: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2707: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_CurrentCallingSequence);
2708: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
2709: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_DebugInfo);
2710: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2711: END;
2712:

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

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

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

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

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

2733: EXCEPTION
2734: WHEN OTHERS THEN
2735: BEGIN
2736: IF (SQLCODE <> -20001) THEN
2737: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2738: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2739: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2740: 'initJustificationRequiredArray');
2741: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

2734: WHEN OTHERS THEN
2735: BEGIN
2736: IF (SQLCODE <> -20001) THEN
2737: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2738: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2739: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2740: 'initJustificationRequiredArray');
2741: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2742: 'None passed.');

Line 2739: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

2735: BEGIN
2736: IF (SQLCODE <> -20001) THEN
2737: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2738: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2739: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2740: 'initJustificationRequiredArray');
2741: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2742: 'None passed.');
2743: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 2741: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2737: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2738: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2739: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2740: 'initJustificationRequiredArray');
2741: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2742: 'None passed.');
2743: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2744: END IF;
2745: APP_EXCEPTION.RAISE_EXCEPTION;

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

2739: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2740: 'initJustificationRequiredArray');
2741: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2742: 'None passed.');
2743: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2744: END IF;
2745: APP_EXCEPTION.RAISE_EXCEPTION;
2746: END;
2747: END initJustificationRequiredArray;