DBA Data[Home] [Help]

APPS.AP_WEB_DISC_PKG dependencies on FND_MESSAGE

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

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

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

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;

Line 156: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'Disc_GetPrompts');

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 */

Line 157: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');

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:

Line 158: FND_MESSAGE.SET_TOKEN('PARAMETERS', l_error);

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;

Line 396: -- Changed all occurances of FND_MESSAGE.get() with FND_MESSAGE.get_encoded() AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DISC_PKG', 'start parseExpReportHeader');

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

Line 398: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_EMPTY_REPORT');

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;

Line 400: p_errors(1).text := FND_MESSAGE.Get_encoded();

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:

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

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

Line 406: costcenter_invalid := FND_MESSAGE.Get;

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

Line 478: fnd_message.set_name('SQLAP','AP_WEB_DISCON_INVALID_CURR');

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

Line 479: fnd_message.set_token('curr', p_header.reimbursement_currency_code);

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

Line 482: fnd_message.get_encoded(),

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:

Line 489: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');

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

Line 490: fnd_message.set_token('MAXLEN', to_char(C_Purpose_Size));

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

Line 492: fnd_message.get_encoded(),

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;

Line 505: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');

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,

Line 506: fnd_message.set_token('MAXLEN', to_char(C_Xtemplate_Size));

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

Line 508: fnd_message.get_encoded(),

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;

Line 519: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');

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

Line 520: fnd_message.set_token('MAXLEN', to_char(C_Approver_Size));

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;

Line 522: fnd_message.get_encoded(),

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;

Line 531: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_LINE_NOT_FOUND');

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;

Line 533: fnd_message.get_encoded(),

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

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

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

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

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:

Line 544: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',format_error);

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

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

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

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

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;

Line 548: AP_WEB_UTILITIES_PKG.AddExpError(p_errors,fnd_message.get_encoded(),

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;

Line 587: fnd_message.set_name('SQLAP', 'AP_WEB_PURPOSE_REQUIRED');

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

Line 588: -- fnd_message.set_name('SQLAP', 'AP_WEB_SEL_BLANK_WRN');

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

Line 589: -- fnd_message.set_token('FIELD_NAME', purpose_prompt);

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;

Line 591: fnd_message.get_encoded(),

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:

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

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

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

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;

Line 625: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','parseExpReportHeader');

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

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

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

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

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

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

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',

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

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

Line 750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 752: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

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

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;

Line 771: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_FORMAT_ERR');

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;

Line 772: htp.title(fnd_message.get);

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:

Line 804: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_CANNOT_READ');

800: .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; }
801: ');
802:
803: htp.p('');
804: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_CANNOT_READ');
805: htp.p('' || fnd_message.get ||'
');
806: htp.ulistOpen;
807: for i in 1 .. p_format_errors.COUNT loop
808: htp.p('');

Line 805: htp.p('' || fnd_message.get ||'
');

801: ');
802:
803: htp.p('');
804: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_CANNOT_READ');
805: htp.p('' || fnd_message.get ||'
');
806: htp.ulistOpen;
807: for i in 1 .. p_format_errors.COUNT loop
808: htp.p('');
809: htp.listItem(p_format_errors(i));

Line 881: fnd_message.set_name('SQLAP', 'AP_WEB_SEL_BLANK_WRN');

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;

Line 882: fnd_message.set_token('FIELD_NAME',p_table(i).prompt_text);

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

Line 883: l_encd_mesg := fnd_message.get_encoded();

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

Line 884: fnd_message.set_encoded(l_encd_mesg);

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

Line 885: p_format_errors(j) := fnd_message.get;

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,

Line 886: fnd_message.set_encoded(l_encd_mesg);

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,

Line 899: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_DUP_FLD');

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;

Line 900: fnd_message.set_token('FIELD_NAME', p_table(i).prompt_text);

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

Line 901: l_encd_mesg := fnd_message.get_encoded();

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

Line 902: fnd_message.set_encoded(l_encd_mesg);

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

Line 903: p_format_errors(j) := fnd_message.get;

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,

Line 904: fnd_message.set_encoded(l_encd_mesg);

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,

Line 933: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_XTYPE_NOT_FOUND');

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

Line 934: l_encd_mesg := fnd_message.get_encoded();

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

Line 935: fnd_message.set_encoded(l_encd_mesg);

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

Line 936: p_format_errors(j) := fnd_message.get;

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,

Line 937: fnd_message.set_encoded(l_encd_mesg);

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,

Line 947: fnd_message.set_name('SQLAP', 'AP_WEB_DISCON_AMT_NOT_FOUND');

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

Line 948: l_encd_mesg := fnd_message.get_encoded();

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

Line 949: fnd_message.set_encoded(l_encd_mesg);

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

Line 950: p_format_errors(j) := fnd_message.get;

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,

Line 951: fnd_message.set_encoded(l_encd_mesg);

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,

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

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

Line 962: l_encd_mesg := fnd_message.get_encoded();

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

Line 963: fnd_message.set_encoded(l_encd_mesg);

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

Line 964: p_format_errors(j) := fnd_message.get;

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,

Line 965: fnd_message.set_encoded(l_encd_mesg);

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,

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

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

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

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;

Line 985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'ap_web_disc_format_error');

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:

Line 986: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','');

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;

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

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:

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

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,

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

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

Line 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;

Line 1056: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');

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,

Line 1057: fnd_message.set_token('MAXLEN',to_char(p_size));

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

Line 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:

Line 1253: fnd_message.set_name('SQLAP','OIE_DISC_MULTIPLE_COPY');

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,

Line 1255: fnd_message.get_encoded(),

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

Line 1277: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');

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,

Line 1278: fnd_message.set_token('MAXLEN','2000');

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

Line 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: --

Line 1334: fnd_message.set_name('SQLAP', 'AP_WEB_MAXLEN_WARNING');

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,

Line 1335: fnd_message.set_token('MAXLEN','300');

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

Line 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: --

Line 1416: fnd_message.set_name( 'SQLAP', 'AP_WEB_DISCON_INVALID_FULLYEAR');

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

Line 1417: fnd_message.set_token ( 'DATE', l_prompt_text);

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;

Line 1419: fnd_message.set_name('SQLAP','AP_WEB_INVALID_DATE');

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

Line 1420: fnd_message.set_token( 'format', nvl(icx_sec.g_date_format,icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')));

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(

Line 1428: fnd_message.get_encoded(),

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,

Line 1435: fnd_message.get_encoded(),

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;

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

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,

Line 1496: fnd_message.set_token('curr', p_receipts(rec_count).currency_code);

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,

Line 1501: fnd_message.get_encoded(),

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

Line 1547: fnd_message.set_name('SQLAP','AP_WEB_DISCON_MULTI_EXPTYPE');

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,

Line 1548: fnd_message.set_token('exptype', l_xtype_text);

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

Line 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;

Line 1591: fnd_message.set_name('SQLAP','AP_WEB_DISCON_INVALID_EXPTYPE');

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,

Line 1592: fnd_message.set_token('exptype', l_xtype_text);

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

Line 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;

Line 1668: fnd_message.set_name('SQLAP','AP_WEB_DISCON_DUP_FLD');

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,

Line 1669: fnd_message.set_token('Field_name', l_fld);

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

Line 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*/

Line 1709: fnd_message.set_name('SQLAP','AP_WEB_DISCON_MULTI_EXPTYPE');

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,

Line 1710: fnd_message.set_token('exptype', p_table(pos).prompt_text);

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

Line 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;

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

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

Line 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

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

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',

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

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

Line 1872: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 1874: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

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

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

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

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

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

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;

Line 2142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DiscValidateExpLines');

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;

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

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:

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

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,

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

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',

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

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

Line 2465: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 2467: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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:

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

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:

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

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

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

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';

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

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',

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

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.');

Line 2946: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 2948: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

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

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

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

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;

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

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;

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

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

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

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

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

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

Line 3514: fnd_message.set_name('SQLAP', 'OIE_FOREIGN_EXCH_RATE_ONE');

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,

Line 3516: fnd_message.get_encoded(),

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;

Line 3530: fnd_message.set_name('SQLAP', 'OIE_NEED_EXCH_RATE');

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,

Line 3532: fnd_message.get_encoded(),

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