150: l_count := l_count - 1;
151: END LOOP;
152: l_error := p_table.COUNT || '#' || l_error;
153:
154: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
155: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
156: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'Disc_GetPrompts');
157: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');
158: FND_MESSAGE.SET_TOKEN('PARAMETERS', l_error);
151: END LOOP;
152: l_error := p_table.COUNT || '#' || l_error;
153:
154: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
155: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
156: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'Disc_GetPrompts');
157: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');
158: FND_MESSAGE.SET_TOKEN('PARAMETERS', l_error);
159: APP_EXCEPTION.RAISE_EXCEPTION;
152: l_error := p_table.COUNT || '#' || l_error;
153:
154: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
155: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
156: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'Disc_GetPrompts');
157: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');
158: FND_MESSAGE.SET_TOKEN('PARAMETERS', l_error);
159: APP_EXCEPTION.RAISE_EXCEPTION;
160: end; /* when OTHERS */
153:
154: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
155: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
156: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'Disc_GetPrompts');
157: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');
158: FND_MESSAGE.SET_TOKEN('PARAMETERS', l_error);
159: APP_EXCEPTION.RAISE_EXCEPTION;
160: end; /* when OTHERS */
161:
154: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
155: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
156: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'Disc_GetPrompts');
157: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');
158: FND_MESSAGE.SET_TOKEN('PARAMETERS', l_error);
159: APP_EXCEPTION.RAISE_EXCEPTION;
160: end; /* when OTHERS */
161:
162: END Disc_GetPrompts;
392:
393:
394: BEGIN
395:
396: -- Changed all occurances of FND_MESSAGE.get() with FND_MESSAGE.get_encoded() AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DISC_PKG', 'start parseExpReportHeader');
397:
398: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_EMPTY_REPORT');
399: if (p_text is null) then
400: p_errors(1).text := FND_MESSAGE.Get_encoded();
394: BEGIN
395:
396: -- Changed all occurances of FND_MESSAGE.get() with FND_MESSAGE.get_encoded() AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DISC_PKG', 'start parseExpReportHeader');
397:
398: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_EMPTY_REPORT');
399: if (p_text is null) then
400: p_errors(1).text := FND_MESSAGE.Get_encoded();
401: p_errors(1).type := AP_WEB_UTILITIES_PKG.C_WarningMessageType;
402: return;
396: -- Changed all occurances of FND_MESSAGE.get() with FND_MESSAGE.get_encoded() AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DISC_PKG', 'start parseExpReportHeader');
397:
398: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_EMPTY_REPORT');
399: if (p_text is null) then
400: p_errors(1).text := FND_MESSAGE.Get_encoded();
401: p_errors(1).type := AP_WEB_UTILITIES_PKG.C_WarningMessageType;
402: return;
403: end if;
404:
401: p_errors(1).type := AP_WEB_UTILITIES_PKG.C_WarningMessageType;
402: return;
403: end if;
404:
405: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_COST_CENTER_INVALID');
406: costcenter_invalid := FND_MESSAGE.Get;
407:
408: debug_info := 'Getting Header fields';
409: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_DISC_PKG', debug_info);
402: return;
403: end if;
404:
405: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_COST_CENTER_INVALID');
406: costcenter_invalid := FND_MESSAGE.Get;
407:
408: debug_info := 'Getting Header fields';
409: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_DISC_PKG', debug_info);
410: LOOP
474: p_header.reimbursement_currency_code := l_value;
475: -- Check whether the reimbursement currency is valid: bug 1871756
476: if (p_header.reimbursement_currency_code IS NOT NULL) then
477: if (NOT isValidCurrency (p_header.reimbursement_currency_code)) then
478: fnd_message.set_name('SQLAP','AP_WEB_DISCON_INVALID_CURR');
479: fnd_message.set_token('curr', p_header.reimbursement_currency_code);
480:
481: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
482: fnd_message.get_encoded(),
475: -- Check whether the reimbursement currency is valid: bug 1871756
476: if (p_header.reimbursement_currency_code IS NOT NULL) then
477: if (NOT isValidCurrency (p_header.reimbursement_currency_code)) then
478: fnd_message.set_name('SQLAP','AP_WEB_DISCON_INVALID_CURR');
479: fnd_message.set_token('curr', p_header.reimbursement_currency_code);
480:
481: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
482: fnd_message.get_encoded(),
483: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
478: fnd_message.set_name('SQLAP','AP_WEB_DISCON_INVALID_CURR');
479: fnd_message.set_token('curr', p_header.reimbursement_currency_code);
480:
481: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
482: fnd_message.get_encoded(),
483: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
484: end if;
485: end if;
486:
485: end if;
486:
487: elsif (l_label_code = 'AP_WEB_PURPOSE') then
488: if (length(l_value) > C_Purpose_Size) then
489: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');
490: fnd_message.set_token('MAXLEN', to_char(C_Purpose_Size));
491: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
492: fnd_message.get_encoded(),
493: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
486:
487: elsif (l_label_code = 'AP_WEB_PURPOSE') then
488: if (length(l_value) > C_Purpose_Size) then
489: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');
490: fnd_message.set_token('MAXLEN', to_char(C_Purpose_Size));
491: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
492: fnd_message.get_encoded(),
493: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
494: p_header.purpose := substr(l_value, 1, C_Purpose_Size);
488: if (length(l_value) > C_Purpose_Size) then
489: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');
490: fnd_message.set_token('MAXLEN', to_char(C_Purpose_Size));
491: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
492: fnd_message.get_encoded(),
493: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
494: p_header.purpose := substr(l_value, 1, C_Purpose_Size);
495: else
496: p_header.purpose := l_value;
501: p_header.template_name := l_value;
502: EXCEPTION
503: WHEN VALUE_ERROR then
504: p_header.template_name := substr(l_value, 1, C_Xtemplate_Size);
505: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');
506: fnd_message.set_token('MAXLEN', to_char(C_Xtemplate_Size));
507: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
508: fnd_message.get_encoded(),
509: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
502: EXCEPTION
503: WHEN VALUE_ERROR then
504: p_header.template_name := substr(l_value, 1, C_Xtemplate_Size);
505: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');
506: fnd_message.set_token('MAXLEN', to_char(C_Xtemplate_Size));
507: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
508: fnd_message.get_encoded(),
509: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
510: 'TEMPLATE');
504: p_header.template_name := substr(l_value, 1, C_Xtemplate_Size);
505: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');
506: fnd_message.set_token('MAXLEN', to_char(C_Xtemplate_Size));
507: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
508: fnd_message.get_encoded(),
509: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
510: 'TEMPLATE');
511: END;
512: template_prompt := l_label_text;
515: l_appr := l_value;
516: EXCEPTION
517: when VALUE_ERROR then
518: l_appr := substr(l_value, 1, C_Approver_Size);
519: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');
520: fnd_message.set_token('MAXLEN', to_char(C_Approver_Size));
521: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
522: fnd_message.get_encoded(),
523: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
516: EXCEPTION
517: when VALUE_ERROR then
518: l_appr := substr(l_value, 1, C_Approver_Size);
519: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');
520: fnd_message.set_token('MAXLEN', to_char(C_Approver_Size));
521: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
522: fnd_message.get_encoded(),
523: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
524: END;
518: l_appr := substr(l_value, 1, C_Approver_Size);
519: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');
520: fnd_message.set_token('MAXLEN', to_char(C_Approver_Size));
521: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
522: fnd_message.get_encoded(),
523: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
524: END;
525: approver_prompt := l_label_text;
526: p_header.override_approver_name := l_appr;
527:
528: end if;
529: end if; /* l_label_index <> 0 */
530: if (p_text is null) then
531: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_LINE_NOT_FOUND');
532: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
533: fnd_message.get_encoded(),
534: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
535: exit;
529: end if; /* l_label_index <> 0 */
530: if (p_text is null) then
531: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_LINE_NOT_FOUND');
532: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
533: fnd_message.get_encoded(),
534: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
535: exit;
536: end if;
537: EXCEPTION
538: when OTHERS then
539: begin
540: --JMARY Calling the AP_DEBUG error message instead of the concatenated string that was passed.
541:
542: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
543: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
544: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',format_error);
545: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
546: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
539: begin
540: --JMARY Calling the AP_DEBUG error message instead of the concatenated string that was passed.
541:
542: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
543: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
544: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',format_error);
545: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
546: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
547:
540: --JMARY Calling the AP_DEBUG error message instead of the concatenated string that was passed.
541:
542: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
543: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
544: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',format_error);
545: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
546: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
547:
548: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,fnd_message.get_encoded(),
541:
542: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
543: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
544: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',format_error);
545: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
546: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
547:
548: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,fnd_message.get_encoded(),
549: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
542: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
543: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
544: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',format_error);
545: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
546: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
547:
548: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,fnd_message.get_encoded(),
549: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
550: end;
544: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',format_error);
545: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
546: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
547:
548: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,fnd_message.get_encoded(),
549: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
550: end;
551: END;
552: END LOOP;
583: p_apps_id => null);
584: if (pp_required = 'Y') then
585: if (p_header.purpose is null) then
586: -- 4087170 : msg for purpose req is shown twice, each is different
587: fnd_message.set_name('SQLAP', 'AP_WEB_PURPOSE_REQUIRED');
588: -- fnd_message.set_name('SQLAP', 'AP_WEB_SEL_BLANK_WRN');
589: -- fnd_message.set_token('FIELD_NAME', purpose_prompt);
590: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
591: fnd_message.get_encoded(),
584: if (pp_required = 'Y') then
585: if (p_header.purpose is null) then
586: -- 4087170 : msg for purpose req is shown twice, each is different
587: fnd_message.set_name('SQLAP', 'AP_WEB_PURPOSE_REQUIRED');
588: -- fnd_message.set_name('SQLAP', 'AP_WEB_SEL_BLANK_WRN');
589: -- fnd_message.set_token('FIELD_NAME', purpose_prompt);
590: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
591: fnd_message.get_encoded(),
592: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
585: if (p_header.purpose is null) then
586: -- 4087170 : msg for purpose req is shown twice, each is different
587: fnd_message.set_name('SQLAP', 'AP_WEB_PURPOSE_REQUIRED');
588: -- fnd_message.set_name('SQLAP', 'AP_WEB_SEL_BLANK_WRN');
589: -- fnd_message.set_token('FIELD_NAME', purpose_prompt);
590: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
591: fnd_message.get_encoded(),
592: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
593: end if;
587: fnd_message.set_name('SQLAP', 'AP_WEB_PURPOSE_REQUIRED');
588: -- fnd_message.set_name('SQLAP', 'AP_WEB_SEL_BLANK_WRN');
589: -- fnd_message.set_token('FIELD_NAME', purpose_prompt);
590: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
591: fnd_message.get_encoded(),
592: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
593: end if;
594: end if;
595:
619:
620: EXCEPTION
621: WHEN OTHERS THEN
622: IF (SQLCODE <> -20001) THEN
623: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
624: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
625: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','parseExpReportHeader');
626: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
627: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
620: EXCEPTION
621: WHEN OTHERS THEN
622: IF (SQLCODE <> -20001) THEN
623: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
624: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
625: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','parseExpReportHeader');
626: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
627: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
628: APP_EXCEPTION.RAISE_EXCEPTION;
621: WHEN OTHERS THEN
622: IF (SQLCODE <> -20001) THEN
623: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
624: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
625: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','parseExpReportHeader');
626: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
627: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
628: APP_EXCEPTION.RAISE_EXCEPTION;
629: ELSE
622: IF (SQLCODE <> -20001) THEN
623: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
624: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
625: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','parseExpReportHeader');
626: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
627: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
628: APP_EXCEPTION.RAISE_EXCEPTION;
629: ELSE
630: -- Do not need to set the token since it has been done in the
623: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
624: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
625: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','parseExpReportHeader');
626: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
627: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
628: APP_EXCEPTION.RAISE_EXCEPTION;
629: ELSE
630: -- Do not need to set the token since it has been done in the
631: -- child process
744: END LOOP;
745:
746: EXCEPTION
747: when OTHERS then
748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
751: current_calling_sequence);
752: FND_MESSAGE.SET_TOKEN('PARAMETERS',
745:
746: EXCEPTION
747: when OTHERS then
748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
751: current_calling_sequence);
752: FND_MESSAGE.SET_TOKEN('PARAMETERS',
753: 'l_line = ' || l_line);
746: EXCEPTION
747: when OTHERS then
748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
751: current_calling_sequence);
752: FND_MESSAGE.SET_TOKEN('PARAMETERS',
753: 'l_line = ' || l_line);
754: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
751: current_calling_sequence);
752: FND_MESSAGE.SET_TOKEN('PARAMETERS',
753: 'l_line = ' || l_line);
754: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
755: APP_EXCEPTION.RAISE_EXCEPTION;
756: -- AP_WEB_DISC_UNEXP_ERR(SQLCODE || '@@' || l_line);
750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
751: current_calling_sequence);
752: FND_MESSAGE.SET_TOKEN('PARAMETERS',
753: 'l_line = ' || l_line);
754: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
755: APP_EXCEPTION.RAISE_EXCEPTION;
756: -- AP_WEB_DISC_UNEXP_ERR(SQLCODE || '@@' || l_line);
757:
758: END AP_WEB_DISC_Val_Rec_Headers;
767: BEGIN
768: htp.p('
769: htp.p('');
770: htp.headOpen;
771: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_FORMAT_ERR');
772: htp.title(fnd_message.get);
773:
774: icx_util.copyright;
775: js.scriptOpen;
768: htp.p('
769: htp.p('');
770: htp.headOpen;
771: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_FORMAT_ERR');
772: htp.title(fnd_message.get);
773:
774: icx_util.copyright;
775: js.scriptOpen;
776:
800: .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; }
801: ');
802:
803: htp.p('
801: ');
802:
803: htp.p('
877: -- Required field but not found
878: --
879: elsif ((p_table(i).required = 'H') OR (p_table(i).required = 'R')) then
880: j := p_format_errors.COUNT+1;
881: fnd_message.set_name('SQLAP', 'AP_WEB_SEL_BLANK_WRN');
882: fnd_message.set_token('FIELD_NAME',p_table(i).prompt_text);
883: l_encd_mesg := fnd_message.get_encoded();
884: fnd_message.set_encoded(l_encd_mesg);
885: p_format_errors(j) := fnd_message.get;
878: --
879: elsif ((p_table(i).required = 'H') OR (p_table(i).required = 'R')) then
880: j := p_format_errors.COUNT+1;
881: fnd_message.set_name('SQLAP', 'AP_WEB_SEL_BLANK_WRN');
882: fnd_message.set_token('FIELD_NAME',p_table(i).prompt_text);
883: l_encd_mesg := fnd_message.get_encoded();
884: fnd_message.set_encoded(l_encd_mesg);
885: p_format_errors(j) := fnd_message.get;
886: fnd_message.set_encoded(l_encd_mesg);
879: elsif ((p_table(i).required = 'H') OR (p_table(i).required = 'R')) then
880: j := p_format_errors.COUNT+1;
881: fnd_message.set_name('SQLAP', 'AP_WEB_SEL_BLANK_WRN');
882: fnd_message.set_token('FIELD_NAME',p_table(i).prompt_text);
883: l_encd_mesg := fnd_message.get_encoded();
884: fnd_message.set_encoded(l_encd_mesg);
885: p_format_errors(j) := fnd_message.get;
886: fnd_message.set_encoded(l_encd_mesg);
887: fnd_msg_pub.add();
880: j := p_format_errors.COUNT+1;
881: fnd_message.set_name('SQLAP', 'AP_WEB_SEL_BLANK_WRN');
882: fnd_message.set_token('FIELD_NAME',p_table(i).prompt_text);
883: l_encd_mesg := fnd_message.get_encoded();
884: fnd_message.set_encoded(l_encd_mesg);
885: p_format_errors(j) := fnd_message.get;
886: fnd_message.set_encoded(l_encd_mesg);
887: fnd_msg_pub.add();
888: -- Added for bug 2132994
881: fnd_message.set_name('SQLAP', 'AP_WEB_SEL_BLANK_WRN');
882: fnd_message.set_token('FIELD_NAME',p_table(i).prompt_text);
883: l_encd_mesg := fnd_message.get_encoded();
884: fnd_message.set_encoded(l_encd_mesg);
885: p_format_errors(j) := fnd_message.get;
886: fnd_message.set_encoded(l_encd_mesg);
887: fnd_msg_pub.add();
888: -- Added for bug 2132994
889: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
882: fnd_message.set_token('FIELD_NAME',p_table(i).prompt_text);
883: l_encd_mesg := fnd_message.get_encoded();
884: fnd_message.set_encoded(l_encd_mesg);
885: p_format_errors(j) := fnd_message.get;
886: fnd_message.set_encoded(l_encd_mesg);
887: fnd_msg_pub.add();
888: -- Added for bug 2132994
889: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
890: l_encd_mesg,
895: -- Duplicate field
896: --
897: elsif (p_table(i).duplicate = 'Y') then
898: j := p_format_errors.COUNT+1;
899: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_DUP_FLD');
900: fnd_message.set_token('FIELD_NAME', p_table(i).prompt_text);
901: l_encd_mesg := fnd_message.get_encoded();
902: fnd_message.set_encoded(l_encd_mesg);
903: p_format_errors(j) := fnd_message.get;
896: --
897: elsif (p_table(i).duplicate = 'Y') then
898: j := p_format_errors.COUNT+1;
899: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_DUP_FLD');
900: fnd_message.set_token('FIELD_NAME', p_table(i).prompt_text);
901: l_encd_mesg := fnd_message.get_encoded();
902: fnd_message.set_encoded(l_encd_mesg);
903: p_format_errors(j) := fnd_message.get;
904: fnd_message.set_encoded(l_encd_mesg);
897: elsif (p_table(i).duplicate = 'Y') then
898: j := p_format_errors.COUNT+1;
899: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_DUP_FLD');
900: fnd_message.set_token('FIELD_NAME', p_table(i).prompt_text);
901: l_encd_mesg := fnd_message.get_encoded();
902: fnd_message.set_encoded(l_encd_mesg);
903: p_format_errors(j) := fnd_message.get;
904: fnd_message.set_encoded(l_encd_mesg);
905: fnd_msg_pub.add();
898: j := p_format_errors.COUNT+1;
899: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_DUP_FLD');
900: fnd_message.set_token('FIELD_NAME', p_table(i).prompt_text);
901: l_encd_mesg := fnd_message.get_encoded();
902: fnd_message.set_encoded(l_encd_mesg);
903: p_format_errors(j) := fnd_message.get;
904: fnd_message.set_encoded(l_encd_mesg);
905: fnd_msg_pub.add();
906: -- Added for bug 2132994
899: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_DUP_FLD');
900: fnd_message.set_token('FIELD_NAME', p_table(i).prompt_text);
901: l_encd_mesg := fnd_message.get_encoded();
902: fnd_message.set_encoded(l_encd_mesg);
903: p_format_errors(j) := fnd_message.get;
904: fnd_message.set_encoded(l_encd_mesg);
905: fnd_msg_pub.add();
906: -- Added for bug 2132994
907: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
900: fnd_message.set_token('FIELD_NAME', p_table(i).prompt_text);
901: l_encd_mesg := fnd_message.get_encoded();
902: fnd_message.set_encoded(l_encd_mesg);
903: p_format_errors(j) := fnd_message.get;
904: fnd_message.set_encoded(l_encd_mesg);
905: fnd_msg_pub.add();
906: -- Added for bug 2132994
907: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
908: l_encd_mesg,
929: -- Expense type
930: --
931: if (exptype_found = false) then
932: j:=p_format_errors.COUNT+1;
933: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_XTYPE_NOT_FOUND');
934: l_encd_mesg := fnd_message.get_encoded();
935: fnd_message.set_encoded(l_encd_mesg);
936: p_format_errors(j) := fnd_message.get;
937: fnd_message.set_encoded(l_encd_mesg);
930: --
931: if (exptype_found = false) then
932: j:=p_format_errors.COUNT+1;
933: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_XTYPE_NOT_FOUND');
934: l_encd_mesg := fnd_message.get_encoded();
935: fnd_message.set_encoded(l_encd_mesg);
936: p_format_errors(j) := fnd_message.get;
937: fnd_message.set_encoded(l_encd_mesg);
938: fnd_msg_pub.add();
931: if (exptype_found = false) then
932: j:=p_format_errors.COUNT+1;
933: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_XTYPE_NOT_FOUND');
934: l_encd_mesg := fnd_message.get_encoded();
935: fnd_message.set_encoded(l_encd_mesg);
936: p_format_errors(j) := fnd_message.get;
937: fnd_message.set_encoded(l_encd_mesg);
938: fnd_msg_pub.add();
939: -- Added for bug 2132994
932: j:=p_format_errors.COUNT+1;
933: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_XTYPE_NOT_FOUND');
934: l_encd_mesg := fnd_message.get_encoded();
935: fnd_message.set_encoded(l_encd_mesg);
936: p_format_errors(j) := fnd_message.get;
937: fnd_message.set_encoded(l_encd_mesg);
938: fnd_msg_pub.add();
939: -- Added for bug 2132994
940: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
933: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_XTYPE_NOT_FOUND');
934: l_encd_mesg := fnd_message.get_encoded();
935: fnd_message.set_encoded(l_encd_mesg);
936: p_format_errors(j) := fnd_message.get;
937: fnd_message.set_encoded(l_encd_mesg);
938: fnd_msg_pub.add();
939: -- Added for bug 2132994
940: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
941: l_encd_mesg,
943: -- p_format_errors(j) := no_exptype_found;
944: -- RecAmount or DailyAmount
945: elsif (amt_found = false) then
946: j:=p_format_errors.COUNT+1;
947: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_AMT_NOT_FOUND');
948: l_encd_mesg := fnd_message.get_encoded();
949: fnd_message.set_encoded(l_encd_mesg);
950: p_format_errors(j) := fnd_message.get;
951: fnd_message.set_encoded(l_encd_mesg);
944: -- RecAmount or DailyAmount
945: elsif (amt_found = false) then
946: j:=p_format_errors.COUNT+1;
947: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_AMT_NOT_FOUND');
948: l_encd_mesg := fnd_message.get_encoded();
949: fnd_message.set_encoded(l_encd_mesg);
950: p_format_errors(j) := fnd_message.get;
951: fnd_message.set_encoded(l_encd_mesg);
952: fnd_msg_pub.add();
945: elsif (amt_found = false) then
946: j:=p_format_errors.COUNT+1;
947: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_AMT_NOT_FOUND');
948: l_encd_mesg := fnd_message.get_encoded();
949: fnd_message.set_encoded(l_encd_mesg);
950: p_format_errors(j) := fnd_message.get;
951: fnd_message.set_encoded(l_encd_mesg);
952: fnd_msg_pub.add();
953: -- Added for bug 2132994
946: j:=p_format_errors.COUNT+1;
947: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_AMT_NOT_FOUND');
948: l_encd_mesg := fnd_message.get_encoded();
949: fnd_message.set_encoded(l_encd_mesg);
950: p_format_errors(j) := fnd_message.get;
951: fnd_message.set_encoded(l_encd_mesg);
952: fnd_msg_pub.add();
953: -- Added for bug 2132994
954: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
947: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_AMT_NOT_FOUND');
948: l_encd_mesg := fnd_message.get_encoded();
949: fnd_message.set_encoded(l_encd_mesg);
950: p_format_errors(j) := fnd_message.get;
951: fnd_message.set_encoded(l_encd_mesg);
952: fnd_msg_pub.add();
953: -- Added for bug 2132994
954: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
955: l_encd_mesg,
957: -- p_format_errors(j) := no_amt_found;
958: -- Currency and Rate
959: elsif ((recCurr_found = true) AND (rate_found = false)) then
960: j:=p_format_errors.COUNT+1;
961: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_RATE_NOT_FOUND');
962: l_encd_mesg := fnd_message.get_encoded();
963: fnd_message.set_encoded(l_encd_mesg);
964: p_format_errors(j) := fnd_message.get;
965: fnd_message.set_encoded(l_encd_mesg);
958: -- Currency and Rate
959: elsif ((recCurr_found = true) AND (rate_found = false)) then
960: j:=p_format_errors.COUNT+1;
961: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_RATE_NOT_FOUND');
962: l_encd_mesg := fnd_message.get_encoded();
963: fnd_message.set_encoded(l_encd_mesg);
964: p_format_errors(j) := fnd_message.get;
965: fnd_message.set_encoded(l_encd_mesg);
966: fnd_msg_pub.add();
959: elsif ((recCurr_found = true) AND (rate_found = false)) then
960: j:=p_format_errors.COUNT+1;
961: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_RATE_NOT_FOUND');
962: l_encd_mesg := fnd_message.get_encoded();
963: fnd_message.set_encoded(l_encd_mesg);
964: p_format_errors(j) := fnd_message.get;
965: fnd_message.set_encoded(l_encd_mesg);
966: fnd_msg_pub.add();
967: -- Added for bug 2132994
960: j:=p_format_errors.COUNT+1;
961: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_RATE_NOT_FOUND');
962: l_encd_mesg := fnd_message.get_encoded();
963: fnd_message.set_encoded(l_encd_mesg);
964: p_format_errors(j) := fnd_message.get;
965: fnd_message.set_encoded(l_encd_mesg);
966: fnd_msg_pub.add();
967: -- Added for bug 2132994
968: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
961: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_RATE_NOT_FOUND');
962: l_encd_mesg := fnd_message.get_encoded();
963: fnd_message.set_encoded(l_encd_mesg);
964: p_format_errors(j) := fnd_message.get;
965: fnd_message.set_encoded(l_encd_mesg);
966: fnd_msg_pub.add();
967: -- Added for bug 2132994
968: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
969: l_encd_mesg,
979: WHEN OTHERS THEN
980: --JMARY Replaced AP_WEB_DISC_UNEXP_ERR with APP_EXCEPTION.RAISE_EXCEPTION
981: -- Using the AP_DEBUG instaed of the error concatenation.
982:
983: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
984: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ap_web_disc_format_error');
986: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');
987: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
980: --JMARY Replaced AP_WEB_DISC_UNEXP_ERR with APP_EXCEPTION.RAISE_EXCEPTION
981: -- Using the AP_DEBUG instaed of the error concatenation.
982:
983: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
984: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ap_web_disc_format_error');
986: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');
987: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
988: APP_EXCEPTION.RAISE_EXCEPTION;
981: -- Using the AP_DEBUG instaed of the error concatenation.
982:
983: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
984: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ap_web_disc_format_error');
986: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');
987: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
988: APP_EXCEPTION.RAISE_EXCEPTION;
989:
982:
983: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
984: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ap_web_disc_format_error');
986: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');
987: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
988: APP_EXCEPTION.RAISE_EXCEPTION;
989:
990: END ap_web_disc_format_error;
983: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
984: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ap_web_disc_format_error');
986: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');
987: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
988: APP_EXCEPTION.RAISE_EXCEPTION;
989:
990: END ap_web_disc_format_error;
991:
1023: p_index in number,
1024: p_prompt in varchar2) Return Boolean IS
1025: BEGIN
1026: if (p_num < 0) then
1027: fnd_message.set_name('SQLAP', 'AP_WEB_NOT_POS_NUM');
1028: fnd_message.set_token('VALUE', to_char(p_num));
1029: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1030: P_index,
1031: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1024: p_prompt in varchar2) Return Boolean IS
1025: BEGIN
1026: if (p_num < 0) then
1027: fnd_message.set_name('SQLAP', 'AP_WEB_NOT_POS_NUM');
1028: fnd_message.set_token('VALUE', to_char(p_num));
1029: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1030: P_index,
1031: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1032: fnd_message.get_encoded(),
1028: fnd_message.set_token('VALUE', to_char(p_num));
1029: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1030: P_index,
1031: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1032: fnd_message.get_encoded(),
1033: p_prompt);
1034: return false;
1035: end if; /* p_num < 0 */
1036: return true;
1052: truncated, and the client-size Javascript also guarantee the
1053: size of the string, user should never see it the 2nd time.
1054: */
1055: p_fld := substr(p_fld, 1, p_size);
1056: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');
1057: fnd_message.set_token('MAXLEN',to_char(p_size));
1058: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1059: p_rec_count,
1060: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1053: size of the string, user should never see it the 2nd time.
1054: */
1055: p_fld := substr(p_fld, 1, p_size);
1056: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');
1057: fnd_message.set_token('MAXLEN',to_char(p_size));
1058: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1059: p_rec_count,
1060: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1061: fnd_message.get_encoded(),
1057: fnd_message.set_token('MAXLEN',to_char(p_size));
1058: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1059: p_rec_count,
1060: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1061: fnd_message.get_encoded(),
1062: p_prompt_index);
1063:
1064: end if;
1065:
1249: end if;
1250: /*Bug No: 3075093 - Check if spreadsheet data pasted multiple times */
1251: if (l_multiple_copy_check = true) then
1252: p_error_type := C_setupError;
1253: fnd_message.set_name('SQLAP','OIE_DISC_MULTIPLE_COPY');
1254: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
1255: fnd_message.get_encoded(),
1256: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1257: null,
1251: if (l_multiple_copy_check = true) then
1252: p_error_type := C_setupError;
1253: fnd_message.set_name('SQLAP','OIE_DISC_MULTIPLE_COPY');
1254: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,
1255: fnd_message.get_encoded(),
1256: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1257: null,
1258: 0,
1259: AP_WEB_UTILITIES_PKG.C_OtherMessageCategory, AP_WEB_UTILITIES_PKG.IsMobileApp);
1273: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_DISC_PKG', debug_info);
1274: GetLine(p_exp, l_line);
1275: EXCEPTION
1276: when VALUE_ERROR then
1277: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');
1278: fnd_message.set_token('MAXLEN','2000');
1279: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1280: rec_count,
1281: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1274: GetLine(p_exp, l_line);
1275: EXCEPTION
1276: when VALUE_ERROR then
1277: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');
1278: fnd_message.set_token('MAXLEN','2000');
1279: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1280: rec_count,
1281: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1282: fnd_message.get_encoded(),
1278: fnd_message.set_token('MAXLEN','2000');
1279: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1280: rec_count,
1281: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1282: fnd_message.get_encoded(),
1283: C_RecCurr_Prompt);
1284:
1285: END;
1286: --
1330: GetField(l_line, l_fld);
1331: l_fld := rtrim(l_fld);
1332: EXCEPTION
1333: when VALUE_ERROR then
1334: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');
1335: fnd_message.set_token('MAXLEN','300');
1336: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1337: rec_count,
1338: AP_WEB_UTILITIES_PKG.C_WarningMessageType,
1331: l_fld := rtrim(l_fld);
1332: EXCEPTION
1333: when VALUE_ERROR then
1334: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');
1335: fnd_message.set_token('MAXLEN','300');
1336: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1337: rec_count,
1338: AP_WEB_UTILITIES_PKG.C_WarningMessageType,
1339: fnd_message.get_encoded());
1335: fnd_message.set_token('MAXLEN','300');
1336: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1337: rec_count,
1338: AP_WEB_UTILITIES_PKG.C_WarningMessageType,
1339: fnd_message.get_encoded());
1340: END;
1341: --
1342: -- pos 1 (Line column) has to be a number and can't be NULL.
1343: --
1412:
1413: EXCEPTION
1414: WHEN OTHERS THEN
1415: IF ( SQLCODE = -1841 ) THEN
1416: fnd_message.set_name( 'SQLAP', 'AP_WEB_DISCON_INVALID_FULLYEAR');
1417: fnd_message.set_token ( 'DATE', l_prompt_text);
1418: ELSE
1419: fnd_message.set_name('SQLAP','AP_WEB_INVALID_DATE');
1420: fnd_message.set_token( 'format', nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')));
1413: EXCEPTION
1414: WHEN OTHERS THEN
1415: IF ( SQLCODE = -1841 ) THEN
1416: fnd_message.set_name( 'SQLAP', 'AP_WEB_DISCON_INVALID_FULLYEAR');
1417: fnd_message.set_token ( 'DATE', l_prompt_text);
1418: ELSE
1419: fnd_message.set_name('SQLAP','AP_WEB_INVALID_DATE');
1420: fnd_message.set_token( 'format', nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')));
1421: END IF;
1415: IF ( SQLCODE = -1841 ) THEN
1416: fnd_message.set_name( 'SQLAP', 'AP_WEB_DISCON_INVALID_FULLYEAR');
1417: fnd_message.set_token ( 'DATE', l_prompt_text);
1418: ELSE
1419: fnd_message.set_name('SQLAP','AP_WEB_INVALID_DATE');
1420: fnd_message.set_token( 'format', nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')));
1421: END IF;
1422:
1423: IF ( l_prompt_code = 'AP_WEB_START_DATE' ) THEN
1416: fnd_message.set_name( 'SQLAP', 'AP_WEB_DISCON_INVALID_FULLYEAR');
1417: fnd_message.set_token ( 'DATE', l_prompt_text);
1418: ELSE
1419: fnd_message.set_name('SQLAP','AP_WEB_INVALID_DATE');
1420: fnd_message.set_token( 'format', nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')));
1421: END IF;
1422:
1423: IF ( l_prompt_code = 'AP_WEB_START_DATE' ) THEN
1424: AP_WEB_UTILITIES_PKG.AddMessage(
1424: AP_WEB_UTILITIES_PKG.AddMessage(
1425: P_Receipt_Errors,
1426: rec_count,
1427: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1428: fnd_message.get_encoded(),
1429: C_Date1_Prompt);
1430: ELSE
1431: AP_WEB_UTILITIES_PKG.AddMessage(
1432: P_Receipt_Errors,
1431: AP_WEB_UTILITIES_PKG.AddMessage(
1432: P_Receipt_Errors,
1433: rec_count,
1434: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1435: fnd_message.get_encoded(),
1436: C_Date2_Prompt);
1437: END IF;
1438:
1439: END;
1491: curr_found := true;
1492: end if;
1493: -- Currency not valid
1494: if (NOT curr_found) then
1495: fnd_message.set_name('SQLAP','AP_WEB_DISCON_INVALID_CURR');
1496: fnd_message.set_token('curr', p_receipts(rec_count).currency_code);
1497:
1498: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1499: rec_count,
1492: end if;
1493: -- Currency not valid
1494: if (NOT curr_found) then
1495: fnd_message.set_name('SQLAP','AP_WEB_DISCON_INVALID_CURR');
1496: fnd_message.set_token('curr', p_receipts(rec_count).currency_code);
1497:
1498: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1499: rec_count,
1500: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1497:
1498: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1499: rec_count,
1500: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1501: fnd_message.get_encoded(),
1502: C_RecCurr_Prompt);
1503: p_error_type := C_setupError;
1504: end if;
1505: else
1543: -- Record multiple exptype error.
1544: ------------------------------------------
1545: debug_info := 'reporting multi expense type error';
1546: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_DISC_PKG', debug_info);
1547: fnd_message.set_name('SQLAP','AP_WEB_DISCON_MULTI_EXPTYPE');
1548: fnd_message.set_token('exptype', l_xtype_text);
1549: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1550: rec_count,
1551: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1544: ------------------------------------------
1545: debug_info := 'reporting multi expense type error';
1546: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_DISC_PKG', debug_info);
1547: fnd_message.set_name('SQLAP','AP_WEB_DISCON_MULTI_EXPTYPE');
1548: fnd_message.set_token('exptype', l_xtype_text);
1549: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1550: rec_count,
1551: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1552: fnd_message.get_encoded(),
1548: fnd_message.set_token('exptype', l_xtype_text);
1549: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1550: rec_count,
1551: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1552: fnd_message.get_encoded(),
1553: C_Exptype_Prompt);
1554: p_error_type := C_setupError;
1555:
1556: end if;
1587: end if;
1588: EXCEPTION
1589: WHEN OTHERS THEN
1590: p_receipts(rec_count).parameter_id := null;
1591: fnd_message.set_name('SQLAP','AP_WEB_DISCON_INVALID_EXPTYPE');
1592: fnd_message.set_token('exptype', l_xtype_text);
1593: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1594: rec_count,
1595: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1588: EXCEPTION
1589: WHEN OTHERS THEN
1590: p_receipts(rec_count).parameter_id := null;
1591: fnd_message.set_name('SQLAP','AP_WEB_DISCON_INVALID_EXPTYPE');
1592: fnd_message.set_token('exptype', l_xtype_text);
1593: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1594: rec_count,
1595: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1596: fnd_message.get_encoded(),
1592: fnd_message.set_token('exptype', l_xtype_text);
1593: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1594: rec_count,
1595: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1596: fnd_message.get_encoded(),
1597: C_Exptype_Prompt);
1598: p_error_type := C_setupError;
1599:
1600: END;
1664: else -- done with this receipt
1665: null;
1666: end if;
1667: else -- duplicate prompt
1668: fnd_message.set_name('SQLAP','AP_WEB_DISCON_DUP_FLD');
1669: fnd_message.set_token('Field_name', l_fld);
1670: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1671: rec_count,
1672: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1665: null;
1666: end if;
1667: else -- duplicate prompt
1668: fnd_message.set_name('SQLAP','AP_WEB_DISCON_DUP_FLD');
1669: fnd_message.set_token('Field_name', l_fld);
1670: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1671: rec_count,
1672: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1673: fnd_message.get_encoded(),
1669: fnd_message.set_token('Field_name', l_fld);
1670: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1671: rec_count,
1672: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1673: fnd_message.get_encoded(),
1674: C_Exptype_Prompt);
1675: p_error_type := C_setupError;
1676: if (l_line is not null) then
1677: GetField(l_line, l_fld); /* get the value and ignore it*/
1705: l_number := to_number(l_prompt_code);
1706: if (l_fld is not null) then
1707: if ((p_receipts(rec_count).parameter_id is not null) AND
1708: (p_receipts(rec_count).parameter_id <> l_prompt_code)) then
1709: fnd_message.set_name('SQLAP','AP_WEB_DISCON_MULTI_EXPTYPE');
1710: fnd_message.set_token('exptype', p_table(pos).prompt_text);
1711: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1712: rec_count,
1713: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1706: if (l_fld is not null) then
1707: if ((p_receipts(rec_count).parameter_id is not null) AND
1708: (p_receipts(rec_count).parameter_id <> l_prompt_code)) then
1709: fnd_message.set_name('SQLAP','AP_WEB_DISCON_MULTI_EXPTYPE');
1710: fnd_message.set_token('exptype', p_table(pos).prompt_text);
1711: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1712: rec_count,
1713: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1714: fnd_message.get_encoded(),
1710: fnd_message.set_token('exptype', p_table(pos).prompt_text);
1711: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1712: rec_count,
1713: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1714: fnd_message.get_encoded(),
1715: C_Exptype_Prompt);
1716: p_error_type := C_setupError;
1717: else
1718: p_receipts(rec_count).parameter_id := l_prompt_code;
1824: -- check if expense type is provided. The reason that we don't do this right after
1825: -- processing expense type is not efficient since all the blank lines would be processed!
1826: -- The best way is to rewrite this module!(Quan 1/26/99)
1827: if (l_xtype_text is null) then
1828: fnd_message.set_name('SQLAP', 'AP_WEB_EXPENSE_TYPE_REQUIRED');
1829: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1830: rec_count,
1831: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1832: fnd_message.get_encoded(),
1828: fnd_message.set_name('SQLAP', 'AP_WEB_EXPENSE_TYPE_REQUIRED');
1829: AP_WEB_UTILITIES_PKG.AddMessage(P_Receipt_Errors,
1830: rec_count,
1831: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1832: fnd_message.get_encoded(),
1833: C_Exptype_Prompt);
1834: end if;
1835: end if;
1836: exception
1866: BEGIN
1867: -- JMARY Added a check for -20001
1868:
1869: IF (SQLCODE <> -20001) THEN
1870: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1871: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1872: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1873: current_calling_sequence);
1874: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1867: -- JMARY Added a check for -20001
1868:
1869: IF (SQLCODE <> -20001) THEN
1870: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1871: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1872: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1873: current_calling_sequence);
1874: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1875: 'l_line = ' || l_line);
1868:
1869: IF (SQLCODE <> -20001) THEN
1870: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1871: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1872: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1873: current_calling_sequence);
1874: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1875: 'l_line = ' || l_line);
1876: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1870: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1871: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1872: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1873: current_calling_sequence);
1874: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1875: 'l_line = ' || l_line);
1876: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1877: APP_EXCEPTION.RAISE_EXCEPTION;
1878: ELSE
1872: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1873: current_calling_sequence);
1874: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1875: 'l_line = ' || l_line);
1876: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1877: APP_EXCEPTION.RAISE_EXCEPTION;
1878: ELSE
1879: -- Do not need to set the token since it has been done in the
1880: -- child process
2136: EXCEPTION
2137: WHEN OTHERS THEN
2138: -- Using the AP_EBUG instead of the concatenated error text
2139:
2140: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2141: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DiscValidateExpLines');
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');
2144: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
2137: WHEN OTHERS THEN
2138: -- Using the AP_EBUG instead of the concatenated error text
2139:
2140: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2141: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DiscValidateExpLines');
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');
2144: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
2145: APP_EXCEPTION.RAISE_EXCEPTION;
2138: -- Using the AP_EBUG instead of the concatenated error text
2139:
2140: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2141: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DiscValidateExpLines');
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');
2144: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
2145: APP_EXCEPTION.RAISE_EXCEPTION;
2146: END discValidateExpLines;
2139:
2140: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2141: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DiscValidateExpLines');
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');
2144: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
2145: APP_EXCEPTION.RAISE_EXCEPTION;
2146: END discValidateExpLines;
2147:
2140: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2141: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DiscValidateExpLines');
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');
2144: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
2145: APP_EXCEPTION.RAISE_EXCEPTION;
2146: END discValidateExpLines;
2147:
2148: PROCEDURE Serialize(P_IsSessionProjectEnabled IN VARCHAR2,
2459: ReportLine := l_line;
2460:
2461: exception
2462: when OTHERS then
2463: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2464: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2465: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2466: current_calling_sequence);
2467: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2460:
2461: exception
2462: when OTHERS then
2463: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2464: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2465: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2466: current_calling_sequence);
2467: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2468: 'l_line = ' || l_line);
2461: exception
2462: when OTHERS then
2463: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2464: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2465: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2466: current_calling_sequence);
2467: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2468: 'l_line = ' || l_line);
2469: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2463: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2464: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2465: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2466: current_calling_sequence);
2467: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2468: 'l_line = ' || l_line);
2469: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2470: APP_EXCEPTION.RAISE_EXCEPTION;
2471:
2465: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2466: current_calling_sequence);
2467: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2468: 'l_line = ' || l_line);
2469: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2470: APP_EXCEPTION.RAISE_EXCEPTION;
2471:
2472: END Serialize;
2473:
2726: /*Bug 1842255 : Return if the template itself is invalid. */
2727: IF (l_terror_exists = TRUE) then
2728: p_error_type := C_setupError;
2729: if (p_techstack = C_oldstack) then
2730: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_TEMP_INVALID');
2731: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2732: end if;
2733: return;
2734: ELSE
2727: IF (l_terror_exists = TRUE) then
2728: p_error_type := C_setupError;
2729: if (p_techstack = C_oldstack) then
2730: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_TEMP_INVALID');
2731: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2732: end if;
2733: return;
2734: ELSE
2735: debug_info := 'get expense type';
2940: -- JMARY Added the -20001 check
2941: -- Check for teckstack to support both the UI's
2942:
2943: IF (SQLCODE <> -20001) THEN
2944: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2945: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2946: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2947: 'ParseExpReport');
2948: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2941: -- Check for teckstack to support both the UI's
2942:
2943: IF (SQLCODE <> -20001) THEN
2944: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2945: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2946: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2947: 'ParseExpReport');
2948: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2949: 'None passed.');
2942:
2943: IF (SQLCODE <> -20001) THEN
2944: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2945: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2946: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2947: 'ParseExpReport');
2948: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2949: 'None passed.');
2950: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2944: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2945: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2946: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2947: 'ParseExpReport');
2948: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2949: 'None passed.');
2950: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2951: END IF;
2952: IF (p_techstack = C_oldstack) THEN
2946: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2947: 'ParseExpReport');
2948: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2949: 'None passed.');
2950: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2951: END IF;
2952: IF (p_techstack = C_oldstack) THEN
2953: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2954: ELSE
2949: 'None passed.');
2950: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2951: END IF;
2952: IF (p_techstack = C_oldstack) THEN
2953: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2954: ELSE
2955: APP_EXCEPTION.RAISE_EXCEPTION;
2956: END IF;
2957: END;
3373: EXCEPTION
3374: WHEN OTHERS THEN
3375: -- JMARY Replaced AP_WEB_UTILITIES_PKG.DisplayException with APP_EXCEPTION.RAISE_EXCPETION
3376: IF (SQLCODE <> -20001) THEN
3377: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3378: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3379: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3380: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3381: APP_EXCEPTION.RAISE_EXCEPTION;
3374: WHEN OTHERS THEN
3375: -- JMARY Replaced AP_WEB_UTILITIES_PKG.DisplayException with APP_EXCEPTION.RAISE_EXCPETION
3376: IF (SQLCODE <> -20001) THEN
3377: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3378: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3379: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3380: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3381: APP_EXCEPTION.RAISE_EXCEPTION;
3382: ELSE
3375: -- JMARY Replaced AP_WEB_UTILITIES_PKG.DisplayException with APP_EXCEPTION.RAISE_EXCPETION
3376: IF (SQLCODE <> -20001) THEN
3377: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3378: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3379: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3380: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3381: APP_EXCEPTION.RAISE_EXCEPTION;
3382: ELSE
3383: -- Do not need to set the token since it has been done in the
3376: IF (SQLCODE <> -20001) THEN
3377: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3378: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3379: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3380: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3381: APP_EXCEPTION.RAISE_EXCEPTION;
3382: ELSE
3383: -- Do not need to set the token since it has been done in the
3384: -- child process
3510: END IF;
3511:
3512: -- Output error message if it is not a fixed rate
3513: IF (l_is_fixed_rate = 'N') THEN
3514: fnd_message.set_name('SQLAP', 'OIE_FOREIGN_EXCH_RATE_ONE');
3515: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
3516: fnd_message.get_encoded(),
3517: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
3518: C_Rate_Prompt,
3512: -- Output error message if it is not a fixed rate
3513: IF (l_is_fixed_rate = 'N') THEN
3514: fnd_message.set_name('SQLAP', 'OIE_FOREIGN_EXCH_RATE_ONE');
3515: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
3516: fnd_message.get_encoded(),
3517: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
3518: C_Rate_Prompt,
3519: rec_count);
3520: END IF;
3526: (l_policyRateOptions.default_exchange_rates = 'U' AND
3527: l_userPrefs.default_exchange_rate_flag = 'N')) ) THEN
3528:
3529: -- Output error message
3530: fnd_message.set_name('SQLAP', 'OIE_NEED_EXCH_RATE');
3531: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
3532: fnd_message.get_encoded(),
3533: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
3534: C_Rate_Prompt,
3528:
3529: -- Output error message
3530: fnd_message.set_name('SQLAP', 'OIE_NEED_EXCH_RATE');
3531: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
3532: fnd_message.get_encoded(),
3533: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
3534: C_Rate_Prompt,
3535: rec_count);
3536: END IF; -- rate