DBA Data[Home] [Help]

APPS.AP_WEB_OA_DISC_PKG dependencies on FND_MESSAGE

Line 173: fnd_message.set_name('SQLAP','AP_WEB_DISC_ZERO_PROMPTS');

169: l_debug_info := 'Check for prompt array errors';
170: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_DISC_PKG', l_debug_info);
171: ------------------------------------------------------
172: IF l_temp_errors.count > 0 THEN
173: fnd_message.set_name('SQLAP','AP_WEB_DISC_ZERO_PROMPTS');
174: fnd_msg_pub.add();
175: p_error_type := AP_WEB_DISC_PKG.C_SetupError;
176: return;
177: END IF;

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

408:
409: EXCEPTION
410: WHEN OTHERS THEN
411: IF (SQLCODE <> -20001) THEN
412: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
413: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
414: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','OAExpReport');
415: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
416: FND_MESSAGE.SET_TOKEN('PARAMETERS','');

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

409: EXCEPTION
410: WHEN OTHERS THEN
411: IF (SQLCODE <> -20001) THEN
412: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
413: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
414: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','OAExpReport');
415: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
416: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
417: END IF;

Line 414: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','OAExpReport');

410: WHEN OTHERS THEN
411: IF (SQLCODE <> -20001) THEN
412: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
413: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
414: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','OAExpReport');
415: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
416: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
417: END IF;
418: FND_MSG_PUB.ADD();

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

411: IF (SQLCODE <> -20001) THEN
412: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
413: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
414: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','OAExpReport');
415: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
416: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
417: END IF;
418: FND_MSG_PUB.ADD();
419: p_error_type := AP_WEB_DISC_PKG.C_SetupError;

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

412: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
413: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
414: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','OAExpReport');
415: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
416: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
417: END IF;
418: FND_MSG_PUB.ADD();
419: p_error_type := AP_WEB_DISC_PKG.C_SetupError;
420: FND_MSG_PUB.COUNT_AND_GET(p_count => p_msg_count,

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

614: EXCEPTION
615: WHEN OTHERS THEN
616: DELETE FROM ap_web_disc_headers_gt;
617: DELETE FROM ap_web_disc_lines_gt;
618: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
619: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
620: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','OAExpReport');
621: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
622: FND_MESSAGE.SET_TOKEN('PARAMETERS','');

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

615: WHEN OTHERS THEN
616: DELETE FROM ap_web_disc_headers_gt;
617: DELETE FROM ap_web_disc_lines_gt;
618: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
619: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
620: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','OAExpReport');
621: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
622: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
623: APP_EXCEPTION.RAISE_EXCEPTION;

Line 620: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','OAExpReport');

616: DELETE FROM ap_web_disc_headers_gt;
617: DELETE FROM ap_web_disc_lines_gt;
618: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
619: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
620: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','OAExpReport');
621: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
622: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
623: APP_EXCEPTION.RAISE_EXCEPTION;
624: END OAInsertTempData;

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

617: DELETE FROM ap_web_disc_lines_gt;
618: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
619: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
620: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','OAExpReport');
621: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
622: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
623: APP_EXCEPTION.RAISE_EXCEPTION;
624: END OAInsertTempData;
625:

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

618: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
619: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
620: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','OAExpReport');
621: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
622: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
623: APP_EXCEPTION.RAISE_EXCEPTION;
624: END OAInsertTempData;
625:
626:

Line 664: fnd_message.set_name('SQLAP', 'OIE_GENERIC_MESSAGE');

660: v_index := p_header_errors.FIRST;
661: LOOP
662: --Check if there are any errors.
663: IF (p_header_errors(v_index).text IS NOT NULL) THEN
664: fnd_message.set_name('SQLAP', 'OIE_GENERIC_MESSAGE');
665: fnd_message.set_token ('MESSAGE', p_header_errors(v_index).text);
666: fnd_msg_pub.add();
667: END IF;
668:

Line 665: fnd_message.set_token ('MESSAGE', p_header_errors(v_index).text);

661: LOOP
662: --Check if there are any errors.
663: IF (p_header_errors(v_index).text IS NOT NULL) THEN
664: fnd_message.set_name('SQLAP', 'OIE_GENERIC_MESSAGE');
665: fnd_message.set_token ('MESSAGE', p_header_errors(v_index).text);
666: fnd_msg_pub.add();
667: END IF;
668:
669: EXIT WHEN v_index = p_header_errors.LAST;

Line 689: fnd_message.set_name('SQLAP', 'OIE_RECEIPT_LINE_ERROR');

685: IF (v_error_text_array(v_array_index) IS NOT NULL) THEN
686: v_error_text := v_error_text_array(v_array_index);
687:
688: -- Build line with error message
689: fnd_message.set_name('SQLAP', 'OIE_RECEIPT_LINE_ERROR');
690: fnd_message.set_token('LINE', to_char(v_index));
691: fnd_message.set_token('ERROR_MESSAGE', v_error_text);
692:
693: fnd_msg_pub.add();

Line 690: fnd_message.set_token('LINE', to_char(v_index));

686: v_error_text := v_error_text_array(v_array_index);
687:
688: -- Build line with error message
689: fnd_message.set_name('SQLAP', 'OIE_RECEIPT_LINE_ERROR');
690: fnd_message.set_token('LINE', to_char(v_index));
691: fnd_message.set_token('ERROR_MESSAGE', v_error_text);
692:
693: fnd_msg_pub.add();
694: END IF;

Line 691: fnd_message.set_token('ERROR_MESSAGE', v_error_text);

687:
688: -- Build line with error message
689: fnd_message.set_name('SQLAP', 'OIE_RECEIPT_LINE_ERROR');
690: fnd_message.set_token('LINE', to_char(v_index));
691: fnd_message.set_token('ERROR_MESSAGE', v_error_text);
692:
693: fnd_msg_pub.add();
694: END IF;
695:

Line 752: fnd_message.set_name('SQLAP', 'OIE_GENERIC_MESSAGE');

748: IF (v_warning_text_array(v_array_index) IS NOT NULL) THEN
749: v_warning_text := v_warning_text_array(v_array_index);
750:
751: -- Build line with error message
752: fnd_message.set_name('SQLAP', 'OIE_GENERIC_MESSAGE');
753: fnd_message.set_token('MESSAGE', v_warning_text);
754:
755: fnd_msg_pub.add();
756: END IF;

Line 753: fnd_message.set_token('MESSAGE', v_warning_text);

749: v_warning_text := v_warning_text_array(v_array_index);
750:
751: -- Build line with error message
752: fnd_message.set_name('SQLAP', 'OIE_GENERIC_MESSAGE');
753: fnd_message.set_token('MESSAGE', v_warning_text);
754:
755: fnd_msg_pub.add();
756: END IF;
757:

Line 926: fnd_message.set_name('SQLAP', 'AP_WEB_PA_PROJTASK_REQUIRED');

922: OR (IsGrantsEnabled() AND p_report_lines_info(rec_count).award_number IS NULL))) THEN
923:
924: IF (p_report_lines_info(rec_count).project_number IS NULL OR
925: p_report_lines_info(rec_count).task_number IS NULL) THEN
926: fnd_message.set_name('SQLAP', 'AP_WEB_PA_PROJTASK_REQUIRED');
927: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
928: fnd_message.get_encoded(),
929: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
930: null,

Line 928: fnd_message.get_encoded(),

924: IF (p_report_lines_info(rec_count).project_number IS NULL OR
925: p_report_lines_info(rec_count).task_number IS NULL) THEN
926: fnd_message.set_name('SQLAP', 'AP_WEB_PA_PROJTASK_REQUIRED');
927: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
928: fnd_message.get_encoded(),
929: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
930: null,
931: rec_count);
932: END IF;

Line 935: fnd_message.set_name('SQLAP', 'OIE_AWARD_REQUIRED');

931: rec_count);
932: END IF;
933: -- Award is required.
934: IF (IsGrantsEnabled() AND p_report_lines_info(rec_count).award_number IS NULL) THEN
935: fnd_message.set_name('SQLAP', 'OIE_AWARD_REQUIRED');
936: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
937: fnd_message.get_encoded(),
938: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
939: null,

Line 937: fnd_message.get_encoded(),

933: -- Award is required.
934: IF (IsGrantsEnabled() AND p_report_lines_info(rec_count).award_number IS NULL) THEN
935: fnd_message.set_name('SQLAP', 'OIE_AWARD_REQUIRED');
936: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
937: fnd_message.get_encoded(),
938: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
939: null,
940: rec_count);
941: END IF;

Line 952: fnd_message.set_name('SQLAP', 'AP_WEB_PA_PROJTASK_REQUIRED');

948: (IsGrantsEnabled() AND p_report_lines_info(rec_count).award_number is not null AND
949: (p_report_lines_info(rec_count).project_number IS NULL OR p_report_lines_info(rec_count).task_number IS NULL))) THEN
950:
951:
952: fnd_message.set_name('SQLAP', 'AP_WEB_PA_PROJTASK_REQUIRED');
953: l_return_error_message := fnd_message.get;
954: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
955: l_return_error_message,
956: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

Line 953: l_return_error_message := fnd_message.get;

949: (p_report_lines_info(rec_count).project_number IS NULL OR p_report_lines_info(rec_count).task_number IS NULL))) THEN
950:
951:
952: fnd_message.set_name('SQLAP', 'AP_WEB_PA_PROJTASK_REQUIRED');
953: l_return_error_message := fnd_message.get;
954: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
955: l_return_error_message,
956: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
957: 'SQLAP',

Line 1041: fnd_message.set_name('GMS', 'GMS_INVALID_AWARD');

1037: p_report_lines_info(rec_count).award_id,
1038: p_report_lines_info(rec_count).project_id,
1039: p_report_lines_info(rec_count).task_id)) THEN
1040:
1041: fnd_message.set_name('GMS', 'GMS_INVALID_AWARD');
1042: l_return_error_message := fnd_message.get;
1043: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
1044: l_return_error_message,
1045: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

Line 1042: l_return_error_message := fnd_message.get;

1038: p_report_lines_info(rec_count).project_id,
1039: p_report_lines_info(rec_count).task_id)) THEN
1040:
1041: fnd_message.set_name('GMS', 'GMS_INVALID_AWARD');
1042: l_return_error_message := fnd_message.get;
1043: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
1044: l_return_error_message,
1045: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1046: 'GMS',

Line 1100: fnd_message.set_name('GMS', 'GMS_INVALID_AWARD');

1096: p_report_lines_info(rec_count).award_id,
1097: p_report_lines_info(rec_count).project_id,
1098: p_report_lines_info(rec_count).task_id)) THEN
1099:
1100: fnd_message.set_name('GMS', 'GMS_INVALID_AWARD');
1101: l_return_error_message := fnd_message.get;
1102: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
1103: l_return_error_message,
1104: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

Line 1101: l_return_error_message := fnd_message.get;

1097: p_report_lines_info(rec_count).project_id,
1098: p_report_lines_info(rec_count).task_id)) THEN
1099:
1100: fnd_message.set_name('GMS', 'GMS_INVALID_AWARD');
1101: l_return_error_message := fnd_message.get;
1102: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
1103: l_return_error_message,
1104: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1105: 'GMS',

Line 1137: fnd_message.set_name('SQLAP', 'OIE_NON_PROJ_EXP');

1133: ELSE
1134: IF (p_report_lines_info(rec_count).project_number IS NOT NULL OR
1135: p_report_lines_info(rec_count).task_number IS NOT NULL OR
1136: p_report_lines_info(rec_count).award_number IS NOT NULL) THEN
1137: fnd_message.set_name('SQLAP', 'OIE_NON_PROJ_EXP');
1138: l_return_error_message := fnd_message.get;
1139: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
1140: l_return_error_message,
1141: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,

Line 1138: l_return_error_message := fnd_message.get;

1134: IF (p_report_lines_info(rec_count).project_number IS NOT NULL OR
1135: p_report_lines_info(rec_count).task_number IS NOT NULL OR
1136: p_report_lines_info(rec_count).award_number IS NOT NULL) THEN
1137: fnd_message.set_name('SQLAP', 'OIE_NON_PROJ_EXP');
1138: l_return_error_message := fnd_message.get;
1139: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
1140: l_return_error_message,
1141: AP_WEB_UTILITIES_PKG.C_ErrorMessageType,
1142: 'SQLAP',

Line 1615: fnd_message.set_name('SQLAP','OIE_DISC_PDM_REMOVE_VALUES');

1611:
1612:
1613: -- Display Milage / Per Diem error message, if applicable
1614: IF l_MPD_present THEN
1615: fnd_message.set_name('SQLAP','OIE_DISC_PDM_REMOVE_VALUES');
1616: AP_WEB_UTILITIES_PKG.AddExpError(p_header_errors,
1617: fnd_message.get_encoded(),
1618: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
1619: END IF;

Line 1617: fnd_message.get_encoded(),

1613: -- Display Milage / Per Diem error message, if applicable
1614: IF l_MPD_present THEN
1615: fnd_message.set_name('SQLAP','OIE_DISC_PDM_REMOVE_VALUES');
1616: AP_WEB_UTILITIES_PKG.AddExpError(p_header_errors,
1617: fnd_message.get_encoded(),
1618: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
1619: END IF;
1620:
1621: -- Merge errors with receipt error stack

Line 1680: fnd_message.set_name('SQLAP','OIE_ADDITIONAL_INFO_REQUIRED');

1676: 'I',
1677: sysdate,
1678: TRUE)) THEN
1679:
1680: fnd_message.set_name('SQLAP','OIE_ADDITIONAL_INFO_REQUIRED');
1681: --fnd_message.set_token ('MESSAGE', FND_FLEX_DESCVAL.error_message);
1682: AP_WEB_UTILITIES_PKG.AddExpError(p_header_errors,
1683: fnd_message.get_encoded(),
1684: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);

Line 1681: --fnd_message.set_token ('MESSAGE', FND_FLEX_DESCVAL.error_message);

1677: sysdate,
1678: TRUE)) THEN
1679:
1680: fnd_message.set_name('SQLAP','OIE_ADDITIONAL_INFO_REQUIRED');
1681: --fnd_message.set_token ('MESSAGE', FND_FLEX_DESCVAL.error_message);
1682: AP_WEB_UTILITIES_PKG.AddExpError(p_header_errors,
1683: fnd_message.get_encoded(),
1684: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
1685:

Line 1683: fnd_message.get_encoded(),

1679:
1680: fnd_message.set_name('SQLAP','OIE_ADDITIONAL_INFO_REQUIRED');
1681: --fnd_message.set_token ('MESSAGE', FND_FLEX_DESCVAL.error_message);
1682: AP_WEB_UTILITIES_PKG.AddExpError(p_header_errors,
1683: fnd_message.get_encoded(),
1684: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
1685:
1686: END IF;
1687: