eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_MPFS_PROCESS_PKG dependencies on FND_MESSAGE

Line 497: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

493:
494: WHEN OTHERS
495: THEN
496: IF ( g_unexp_level >= g_debug_level ) THEN
497: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
498: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
499: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
500: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
501: END IF;

Line 498: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

494: WHEN OTHERS
495: THEN
496: IF ( g_unexp_level >= g_debug_level ) THEN
497: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
498: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
499: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
500: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
501: END IF;
502: RAISE E_CC_NOT_FOUND;

Line 499: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

495: THEN
496: IF ( g_unexp_level >= g_debug_level ) THEN
497: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
498: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
499: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
500: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
501: END IF;
502: RAISE E_CC_NOT_FOUND;
503:

Line 756: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

752: EXCEPTION
753: WHEN OTHERS
754: THEN
755: IF ( g_unexp_level >= g_debug_level ) THEN
756: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
757: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
758: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
759: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
760: END IF;

Line 757: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

753: WHEN OTHERS
754: THEN
755: IF ( g_unexp_level >= g_debug_level ) THEN
756: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
757: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
758: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
759: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
760: END IF;
761: /*IF (g_debug_mode = 'Y') THEN

Line 758: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

754: THEN
755: IF ( g_unexp_level >= g_debug_level ) THEN
756: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
757: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
758: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
759: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
760: END IF;
761: /*IF (g_debug_mode = 'Y') THEN
762: Output_Debug (l_full_path, ' SQLERRM ' || SQLERRM);

Line 801: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

797:
798: WHEN OTHERS
799: THEN
800: IF ( g_unexp_level >= g_debug_level ) THEN
801: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
802: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
803: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
804: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
805: END IF;

Line 802: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

798: WHEN OTHERS
799: THEN
800: IF ( g_unexp_level >= g_debug_level ) THEN
801: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
802: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
803: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
804: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
805: END IF;
806: /* IF (g_debug_mode = 'Y') THEN

Line 803: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

799: THEN
800: IF ( g_unexp_level >= g_debug_level ) THEN
801: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
802: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
803: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
804: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
805: END IF;
806: /* IF (g_debug_mode = 'Y') THEN
807: Output_Debug (l_full_path, ' SQLERRM ' || SQLERRM);

Line 861: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

857:
858: WHEN NO_DATA_FOUND
859: THEN
860: IF ( g_unexp_level >= g_debug_level ) THEN
861: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
862: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
863: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
864: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
865: END IF;

Line 862: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

858: WHEN NO_DATA_FOUND
859: THEN
860: IF ( g_unexp_level >= g_debug_level ) THEN
861: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
862: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
863: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
864: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
865: END IF;
866: RETURN (FND_API.G_FALSE);

Line 863: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

859: THEN
860: IF ( g_unexp_level >= g_debug_level ) THEN
861: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
862: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
863: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
864: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
865: END IF;
866: RETURN (FND_API.G_FALSE);
867: END IS_GL_PERIOD_OPEN;

Line 912: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

908: EXCEPTION
909: WHEN NO_DATA_FOUND
910: THEN
911: IF ( g_unexp_level >= g_debug_level ) THEN
912: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
913: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
914: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
915: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
916: END IF;

Line 913: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

909: WHEN NO_DATA_FOUND
910: THEN
911: IF ( g_unexp_level >= g_debug_level ) THEN
912: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
913: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
914: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
915: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
916: END IF;
917: RETURN (FND_API.G_FALSE);

Line 914: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

910: THEN
911: IF ( g_unexp_level >= g_debug_level ) THEN
912: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
913: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
914: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
915: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
916: END IF;
917: RETURN (FND_API.G_FALSE);
918: END; /* End of IS_CC_PERIOD_OPEN Function */

Line 989: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DT_NOT_OPEN_GL_PRD');

985: IF FND_API.TO_BOOLEAN(l_gl_period_open )THEN
986: l_validated := FND_API.G_TRUE;
987: ELSE
988: p_exception := NULL;
989: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DT_NOT_OPEN_GL_PRD');
990: FND_MESSAGE.SET_TOKEN('TRANSFER_DT',TO_CHAR(p_transfer_date),TRUE);
991: IF(g_excep_level >= g_debug_level) THEN
992: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
993: END IF;

Line 990: FND_MESSAGE.SET_TOKEN('TRANSFER_DT',TO_CHAR(p_transfer_date),TRUE);

986: l_validated := FND_API.G_TRUE;
987: ELSE
988: p_exception := NULL;
989: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DT_NOT_OPEN_GL_PRD');
990: FND_MESSAGE.SET_TOKEN('TRANSFER_DT',TO_CHAR(p_transfer_date),TRUE);
991: IF(g_excep_level >= g_debug_level) THEN
992: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
993: END IF;
994: p_exception := FND_MESSAGE.GET;

Line 994: p_exception := FND_MESSAGE.GET;

990: FND_MESSAGE.SET_TOKEN('TRANSFER_DT',TO_CHAR(p_transfer_date),TRUE);
991: IF(g_excep_level >= g_debug_level) THEN
992: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
993: END IF;
994: p_exception := FND_MESSAGE.GET;
995: END IF;
996:
997: ELSE
998: l_validated := FND_API.G_TRUE;

Line 1002: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DT_NOT_OPEN_CC_PRD');

998: l_validated := FND_API.G_TRUE;
999: END IF;
1000: ELSE
1001: p_exception := NULL;
1002: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DT_NOT_OPEN_CC_PRD');
1003: FND_MESSAGE.SET_TOKEN('TRANSFER_DT',TO_CHAR(p_transfer_date),TRUE);
1004: IF(g_excep_level >= g_debug_level) THEN
1005: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1006: END IF;

Line 1003: FND_MESSAGE.SET_TOKEN('TRANSFER_DT',TO_CHAR(p_transfer_date),TRUE);

999: END IF;
1000: ELSE
1001: p_exception := NULL;
1002: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DT_NOT_OPEN_CC_PRD');
1003: FND_MESSAGE.SET_TOKEN('TRANSFER_DT',TO_CHAR(p_transfer_date),TRUE);
1004: IF(g_excep_level >= g_debug_level) THEN
1005: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1006: END IF;
1007: p_exception := FND_MESSAGE.GET;

Line 1007: p_exception := FND_MESSAGE.GET;

1003: FND_MESSAGE.SET_TOKEN('TRANSFER_DT',TO_CHAR(p_transfer_date),TRUE);
1004: IF(g_excep_level >= g_debug_level) THEN
1005: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1006: END IF;
1007: p_exception := FND_MESSAGE.GET;
1008: END IF;
1009:
1010: ELSE
1011: p_exception := NULL;

Line 1012: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TG_NOT_IN_SELECT_DT');

1008: END IF;
1009:
1010: ELSE
1011: p_exception := NULL;
1012: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TG_NOT_IN_SELECT_DT');
1013: FND_MESSAGE.SET_TOKEN('TARGET_DATE',TO_CHAR(p_target_date),TRUE);
1014: IF(g_excep_level >= g_debug_level) THEN
1015: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1016: END IF;

Line 1013: FND_MESSAGE.SET_TOKEN('TARGET_DATE',TO_CHAR(p_target_date),TRUE);

1009:
1010: ELSE
1011: p_exception := NULL;
1012: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TG_NOT_IN_SELECT_DT');
1013: FND_MESSAGE.SET_TOKEN('TARGET_DATE',TO_CHAR(p_target_date),TRUE);
1014: IF(g_excep_level >= g_debug_level) THEN
1015: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1016: END IF;
1017: p_exception := FND_MESSAGE.GET;

Line 1017: p_exception := FND_MESSAGE.GET;

1013: FND_MESSAGE.SET_TOKEN('TARGET_DATE',TO_CHAR(p_target_date),TRUE);
1014: IF(g_excep_level >= g_debug_level) THEN
1015: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1016: END IF;
1017: p_exception := FND_MESSAGE.GET;
1018: END IF;
1019: ELSE
1020: p_exception := NULL;
1021: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TG_DT_LESS_TX_DT');

Line 1021: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TG_DT_LESS_TX_DT');

1017: p_exception := FND_MESSAGE.GET;
1018: END IF;
1019: ELSE
1020: p_exception := NULL;
1021: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TG_DT_LESS_TX_DT');
1022: FND_MESSAGE.SET_TOKEN('TARGET_DATE',TO_CHAR(p_target_date),TRUE);
1023: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',TO_CHAR(p_transfer_date),TRUE);
1024: IF(g_excep_level >= g_debug_level) THEN
1025: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

Line 1022: FND_MESSAGE.SET_TOKEN('TARGET_DATE',TO_CHAR(p_target_date),TRUE);

1018: END IF;
1019: ELSE
1020: p_exception := NULL;
1021: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TG_DT_LESS_TX_DT');
1022: FND_MESSAGE.SET_TOKEN('TARGET_DATE',TO_CHAR(p_target_date),TRUE);
1023: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',TO_CHAR(p_transfer_date),TRUE);
1024: IF(g_excep_level >= g_debug_level) THEN
1025: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1026: END IF;

Line 1023: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',TO_CHAR(p_transfer_date),TRUE);

1019: ELSE
1020: p_exception := NULL;
1021: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TG_DT_LESS_TX_DT');
1022: FND_MESSAGE.SET_TOKEN('TARGET_DATE',TO_CHAR(p_target_date),TRUE);
1023: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',TO_CHAR(p_transfer_date),TRUE);
1024: IF(g_excep_level >= g_debug_level) THEN
1025: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1026: END IF;
1027: p_exception := FND_MESSAGE.GET;

Line 1027: p_exception := FND_MESSAGE.GET;

1023: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',TO_CHAR(p_transfer_date),TRUE);
1024: IF(g_excep_level >= g_debug_level) THEN
1025: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1026: END IF;
1027: p_exception := FND_MESSAGE.GET;
1028: END IF;
1029: ELSE
1030: p_exception := NULL;
1031: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DT_LESS_START_DT');

Line 1031: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DT_LESS_START_DT');

1027: p_exception := FND_MESSAGE.GET;
1028: END IF;
1029: ELSE
1030: p_exception := NULL;
1031: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DT_LESS_START_DT');
1032: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',TO_CHAR(p_transfer_date),TRUE);
1033: FND_MESSAGE.SET_TOKEN('START_DATE',TO_CHAR(p_start_date),TRUE);
1034: IF(g_excep_level >= g_debug_level) THEN
1035: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

Line 1032: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',TO_CHAR(p_transfer_date),TRUE);

1028: END IF;
1029: ELSE
1030: p_exception := NULL;
1031: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DT_LESS_START_DT');
1032: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',TO_CHAR(p_transfer_date),TRUE);
1033: FND_MESSAGE.SET_TOKEN('START_DATE',TO_CHAR(p_start_date),TRUE);
1034: IF(g_excep_level >= g_debug_level) THEN
1035: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1036: END IF;

Line 1033: FND_MESSAGE.SET_TOKEN('START_DATE',TO_CHAR(p_start_date),TRUE);

1029: ELSE
1030: p_exception := NULL;
1031: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DT_LESS_START_DT');
1032: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',TO_CHAR(p_transfer_date),TRUE);
1033: FND_MESSAGE.SET_TOKEN('START_DATE',TO_CHAR(p_start_date),TRUE);
1034: IF(g_excep_level >= g_debug_level) THEN
1035: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1036: END IF;
1037: p_exception := FND_MESSAGE.GET;

Line 1037: p_exception := FND_MESSAGE.GET;

1033: FND_MESSAGE.SET_TOKEN('START_DATE',TO_CHAR(p_start_date),TRUE);
1034: IF(g_excep_level >= g_debug_level) THEN
1035: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1036: END IF;
1037: p_exception := FND_MESSAGE.GET;
1038: END IF;
1039: ELSE
1040: p_exception := NULL;
1041: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DATE_NOT_IN_FISCAL');

Line 1041: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DATE_NOT_IN_FISCAL');

1037: p_exception := FND_MESSAGE.GET;
1038: END IF;
1039: ELSE
1040: p_exception := NULL;
1041: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DATE_NOT_IN_FISCAL');
1042: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',TO_CHAR(p_transfer_date),TRUE);
1043: IF(g_excep_level >= g_debug_level) THEN
1044: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1045: END IF;

Line 1042: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',TO_CHAR(p_transfer_date),TRUE);

1038: END IF;
1039: ELSE
1040: p_exception := NULL;
1041: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DATE_NOT_IN_FISCAL');
1042: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',TO_CHAR(p_transfer_date),TRUE);
1043: IF(g_excep_level >= g_debug_level) THEN
1044: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1045: END IF;
1046: p_exception := FND_MESSAGE.GET;

Line 1046: p_exception := FND_MESSAGE.GET;

1042: FND_MESSAGE.SET_TOKEN('TRANSFER_DATE',TO_CHAR(p_transfer_date),TRUE);
1043: IF(g_excep_level >= g_debug_level) THEN
1044: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1045: END IF;
1046: p_exception := FND_MESSAGE.GET;
1047: END IF;
1048: ELSE
1049: p_exception := NULL;
1050: FND_MESSAGE.SET_NAME('IGC','IGC_CC_START_DT_END_DT_FISCAL');

Line 1050: FND_MESSAGE.SET_NAME('IGC','IGC_CC_START_DT_END_DT_FISCAL');

1046: p_exception := FND_MESSAGE.GET;
1047: END IF;
1048: ELSE
1049: p_exception := NULL;
1050: FND_MESSAGE.SET_NAME('IGC','IGC_CC_START_DT_END_DT_FISCAL');
1051: FND_MESSAGE.SET_TOKEN('START_DATE',TO_CHAR(p_start_date),TRUE);
1052: FND_MESSAGE.SET_TOKEN('END_DATE',TO_CHAR(p_end_date),TRUE);
1053: IF(g_excep_level >= g_debug_level) THEN
1054: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

Line 1051: FND_MESSAGE.SET_TOKEN('START_DATE',TO_CHAR(p_start_date),TRUE);

1047: END IF;
1048: ELSE
1049: p_exception := NULL;
1050: FND_MESSAGE.SET_NAME('IGC','IGC_CC_START_DT_END_DT_FISCAL');
1051: FND_MESSAGE.SET_TOKEN('START_DATE',TO_CHAR(p_start_date),TRUE);
1052: FND_MESSAGE.SET_TOKEN('END_DATE',TO_CHAR(p_end_date),TRUE);
1053: IF(g_excep_level >= g_debug_level) THEN
1054: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1055: END IF;

Line 1052: FND_MESSAGE.SET_TOKEN('END_DATE',TO_CHAR(p_end_date),TRUE);

1048: ELSE
1049: p_exception := NULL;
1050: FND_MESSAGE.SET_NAME('IGC','IGC_CC_START_DT_END_DT_FISCAL');
1051: FND_MESSAGE.SET_TOKEN('START_DATE',TO_CHAR(p_start_date),TRUE);
1052: FND_MESSAGE.SET_TOKEN('END_DATE',TO_CHAR(p_end_date),TRUE);
1053: IF(g_excep_level >= g_debug_level) THEN
1054: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1055: END IF;
1056: p_exception := FND_MESSAGE.GET;

Line 1056: p_exception := FND_MESSAGE.GET;

1052: FND_MESSAGE.SET_TOKEN('END_DATE',TO_CHAR(p_end_date),TRUE);
1053: IF(g_excep_level >= g_debug_level) THEN
1054: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1055: END IF;
1056: p_exception := FND_MESSAGE.GET;
1057: END IF;
1058: ELSE
1059: p_exception := NULL;
1060: FND_MESSAGE.SET_NAME('IGC','IGC_CC_END_DT_LESS_START_DT');

Line 1060: FND_MESSAGE.SET_NAME('IGC','IGC_CC_END_DT_LESS_START_DT');

1056: p_exception := FND_MESSAGE.GET;
1057: END IF;
1058: ELSE
1059: p_exception := NULL;
1060: FND_MESSAGE.SET_NAME('IGC','IGC_CC_END_DT_LESS_START_DT');
1061: FND_MESSAGE.SET_TOKEN('START_DATE',TO_CHAR(p_start_date),TRUE);
1062: FND_MESSAGE.SET_TOKEN('END_DATE',TO_CHAR(p_end_date),TRUE);
1063: IF(g_excep_level >= g_debug_level) THEN
1064: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);

Line 1061: FND_MESSAGE.SET_TOKEN('START_DATE',TO_CHAR(p_start_date),TRUE);

1057: END IF;
1058: ELSE
1059: p_exception := NULL;
1060: FND_MESSAGE.SET_NAME('IGC','IGC_CC_END_DT_LESS_START_DT');
1061: FND_MESSAGE.SET_TOKEN('START_DATE',TO_CHAR(p_start_date),TRUE);
1062: FND_MESSAGE.SET_TOKEN('END_DATE',TO_CHAR(p_end_date),TRUE);
1063: IF(g_excep_level >= g_debug_level) THEN
1064: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1065: END IF;

Line 1062: FND_MESSAGE.SET_TOKEN('END_DATE',TO_CHAR(p_end_date),TRUE);

1058: ELSE
1059: p_exception := NULL;
1060: FND_MESSAGE.SET_NAME('IGC','IGC_CC_END_DT_LESS_START_DT');
1061: FND_MESSAGE.SET_TOKEN('START_DATE',TO_CHAR(p_start_date),TRUE);
1062: FND_MESSAGE.SET_TOKEN('END_DATE',TO_CHAR(p_end_date),TRUE);
1063: IF(g_excep_level >= g_debug_level) THEN
1064: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1065: END IF;
1066: p_exception := FND_MESSAGE.GET;

Line 1066: p_exception := FND_MESSAGE.GET;

1062: FND_MESSAGE.SET_TOKEN('END_DATE',TO_CHAR(p_end_date),TRUE);
1063: IF(g_excep_level >= g_debug_level) THEN
1064: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1065: END IF;
1066: p_exception := FND_MESSAGE.GET;
1067: END IF;
1068:
1069: IF FND_API.TO_BOOLEAN(l_validated) THEN
1070: p_result := FND_API.G_TRUE;

Line 1469: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_DET_PF_HST_INSERT');

1465: IF (g_debug_mode = 'Y') THEN
1466: Output_Debug (l_full_path, ' IGCCMPSB -- ************ Insert Payment Forecast History Failure '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1467: END IF;
1468: l_error_message := NULL;
1469: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_DET_PF_HST_INSERT');
1470: IF(g_excep_level >= g_debug_level) THEN
1471: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1472: END IF;
1473: l_error_message := FND_MESSAGE.GET;

Line 1473: l_error_message := FND_MESSAGE.GET;

1469: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_DET_PF_HST_INSERT');
1470: IF(g_excep_level >= g_debug_level) THEN
1471: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1472: END IF;
1473: l_error_message := FND_MESSAGE.GET;
1474: RETURN 'F';
1475: END IF;
1476: l_cc_pf_target.cc_det_pf_entered_amt := l_cc_pf_target.cc_det_pf_entered_amt +l_amt_shift_rec.amt_shift;
1477: l_cc_pf_target.cc_det_pf_func_amt := l_cc_pf_target.cc_det_pf_func_amt+l_amt_shift_rec.func_amt_shift;

Line 1540: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_DET_PF_UPDATE');

1536: IF (g_debug_mode = 'Y') THEN
1537: Output_Debug (l_full_path, ' IGCCMPSB -- ************ Update Payment Forecast Failure '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1538: END IF;
1539: l_error_message := NULL;
1540: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_DET_PF_UPDATE');
1541: IF(g_excep_level >= g_debug_level) THEN
1542: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1543: END IF;
1544: l_error_message := FND_MESSAGE.GET;

Line 1544: l_error_message := FND_MESSAGE.GET;

1540: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_DET_PF_UPDATE');
1541: IF(g_excep_level >= g_debug_level) THEN
1542: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1543: END IF;
1544: l_error_message := FND_MESSAGE.GET;
1545: RETURN 'F';
1546: END IF;
1547:
1548: END LOOP;

Line 1614: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_DET_PF_HST_INSERT');

1610: IF (g_debug_mode = 'Y') THEN
1611: Output_Debug (l_full_path, ' IGCCMPSB -- ************ Insert Payment Forecast history Failure '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1612: END IF;
1613: l_error_message := NULL;
1614: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_DET_PF_HST_INSERT');
1615: IF(g_excep_level >= g_debug_level) THEN
1616: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1617: END IF;
1618: l_error_message := FND_MESSAGE.GET;

Line 1618: l_error_message := FND_MESSAGE.GET;

1614: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_DET_PF_HST_INSERT');
1615: IF(g_excep_level >= g_debug_level) THEN
1616: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1617: END IF;
1618: l_error_message := FND_MESSAGE.GET;
1619: RETURN 'F';
1620: END IF;
1621:
1622: IF (l_cc_pmt_fcst_rec.cc_det_pf_date < p_transfer_date)

Line 1699: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_DET_PF_UPDATE');

1695: IF (g_debug_mode = 'Y') THEN
1696: Output_Debug (l_full_path, ' IGCCMPSB -- ************ Update Payment Forecast Failure '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1697: END IF;
1698: l_error_message := NULL;
1699: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_DET_PF_UPDATE');
1700: IF(g_excep_level >= g_debug_level) THEN
1701: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1702: END IF;
1703: l_error_message := FND_MESSAGE.GET;

Line 1703: l_error_message := FND_MESSAGE.GET;

1699: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_DET_PF_UPDATE');
1700: IF(g_excep_level >= g_debug_level) THEN
1701: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1702: END IF;
1703: l_error_message := FND_MESSAGE.GET;
1704: RETURN 'F';
1705: END IF;
1706:
1707: END LOOP;

Line 1791: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_HEADERS_UPDATE');

1787: IF (g_debug_mode = 'Y') THEN
1788: Output_Debug (l_full_path, ' IGCCMPSB -- ************ After Header Update Failure '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1789: END IF;
1790: l_error_message := NULL;
1791: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_HEADERS_UPDATE');
1792: IF(g_excep_level >= g_debug_level) THEN
1793: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1794: END IF;
1795: l_error_message := FND_MESSAGE.GET;

Line 1795: l_error_message := FND_MESSAGE.GET;

1791: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_HEADERS_UPDATE');
1792: IF(g_excep_level >= g_debug_level) THEN
1793: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1794: END IF;
1795: l_error_message := FND_MESSAGE.GET;
1796:
1797: RETURN 'F';
1798: END IF;
1799:

Line 1847: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_PO_UPDATE_FAILED');

1843: IF (g_debug_mode = 'Y') THEN
1844: Output_Debug (l_full_path, ' IGCCMPSB -- ************ After Update PO Failure '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1845: END IF;
1846: l_error_message := NULL;
1847: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_PO_UPDATE_FAILED');
1848: IF(g_excep_level >= g_debug_level) THEN
1849: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1850: END IF;
1851: l_error_message := FND_MESSAGE.GET;

Line 1851: l_error_message := FND_MESSAGE.GET;

1847: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_PO_UPDATE_FAILED');
1848: IF(g_excep_level >= g_debug_level) THEN
1849: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1850: END IF;
1851: l_error_message := FND_MESSAGE.GET;
1852:
1853: RETURN 'F';
1854: END IF;
1855: EXCEPTION

Line 1866: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_ACT_HIST_MSG');

1862:
1863: l_action_hist_msg := NULL;
1864: -- Fixed Bug 1632552
1865: /*
1866: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_ACT_HIST_MSG');
1867: l_action_hist_msg := FND_MESSAGE.GET;
1868:
1869: */
1870: IGC_CC_ACTIONS_PKG.Insert_Row(

Line 1867: l_action_hist_msg := FND_MESSAGE.GET;

1863: l_action_hist_msg := NULL;
1864: -- Fixed Bug 1632552
1865: /*
1866: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_ACT_HIST_MSG');
1867: l_action_hist_msg := FND_MESSAGE.GET;
1868:
1869: */
1870: IGC_CC_ACTIONS_PKG.Insert_Row(
1871: l_api_version,

Line 1900: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_ACTION_HST_INSERT');

1896: IF (g_debug_mode = 'Y') THEN
1897: Output_Debug (l_full_path, ' IGCCMPSB -- ************ After Insert Action History Failure '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1898: END IF;
1899: l_error_message := NULL;
1900: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_ACTION_HST_INSERT');
1901: IF(g_excep_level >= g_debug_level) THEN
1902: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1903: END IF;
1904: l_error_message := FND_MESSAGE.GET;

Line 1904: l_error_message := FND_MESSAGE.GET;

1900: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_ACTION_HST_INSERT');
1901: IF(g_excep_level >= g_debug_level) THEN
1902: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1903: END IF;
1904: l_error_message := FND_MESSAGE.GET;
1905: RETURN 'F';
1906: END IF;
1907:
1908: /* Update validation status, in temporary table*/

Line 1922: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

1918: /* IF (g_debug_mode = 'Y') THEN
1919: Output_Debug (l_full_path, ' SQLERRM ' || SQLERRM);
1920: END IF;*/
1921: IF ( g_unexp_level >= g_debug_level ) THEN
1922: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1923: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1924: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1925: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1926: END IF;

Line 1923: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1919: Output_Debug (l_full_path, ' SQLERRM ' || SQLERRM);
1920: END IF;*/
1921: IF ( g_unexp_level >= g_debug_level ) THEN
1922: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1923: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1924: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1925: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1926: END IF;
1927: l_error_message := NULL;

Line 1924: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1920: END IF;*/
1921: IF ( g_unexp_level >= g_debug_level ) THEN
1922: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1923: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1924: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1925: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1926: END IF;
1927: l_error_message := NULL;
1928: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_CC_UPDATE_FAILED');

Line 1928: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_CC_UPDATE_FAILED');

1924: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1925: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1926: END IF;
1927: l_error_message := NULL;
1928: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_CC_UPDATE_FAILED');
1929: IF(g_excep_level >= g_debug_level) THEN
1930: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1931: END IF;
1932: l_error_message := FND_MESSAGE.GET;

Line 1932: l_error_message := FND_MESSAGE.GET;

1928: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_CC_UPDATE_FAILED');
1929: IF(g_excep_level >= g_debug_level) THEN
1930: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1931: END IF;
1932: l_error_message := FND_MESSAGE.GET;
1933: RETURN 'F';
1934: END MPFS_UPDATE;
1935:
1936: /* Formatted on 2004/07/15 16:25 (Formatter Plus v4.8.0) */

Line 2322: fnd_message.set_name ('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');

2318: INTO l_option_name
2319: FROM igi_lookups
2320: WHERE lookup_code = 'CC' AND lookup_type = 'GCC_DESCRIPTION';
2321:
2322: fnd_message.set_name ('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
2323: fnd_message.set_token ('OPTION_NAME', l_option_name);
2324:
2325: IF (g_error_level >= g_debug_level)
2326: THEN

Line 2323: fnd_message.set_token ('OPTION_NAME', l_option_name);

2319: FROM igi_lookups
2320: WHERE lookup_code = 'CC' AND lookup_type = 'GCC_DESCRIPTION';
2321:
2322: fnd_message.set_name ('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
2323: fnd_message.set_token ('OPTION_NAME', l_option_name);
2324:
2325: IF (g_error_level >= g_debug_level)
2326: THEN
2327: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);

Line 2330: lv_message := fnd_message.get;

2326: THEN
2327: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);
2328: END IF;
2329:
2330: lv_message := fnd_message.get;
2331: errbuf := lv_message;
2332: retcode := 2;
2333: RETURN;
2334: END IF;

Line 2629: fnd_message.set_name ('IGC', 'IGC_CC_NO_RECORD_FOUND');

2625:
2626: IF c1%ROWCOUNT = 0
2627: THEN
2628: l_exception := NULL;
2629: fnd_message.set_name ('IGC', 'IGC_CC_NO_RECORD_FOUND');
2630:
2631: IF (g_error_level >= g_debug_level)
2632: THEN
2633: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);

Line 2636: l_exception := fnd_message.get;

2632: THEN
2633: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);
2634: END IF;
2635:
2636: l_exception := fnd_message.get;
2637:
2638: INSERT INTO igc_cc_process_exceptions
2639: (process_type, process_phase, cc_header_id,
2640: cc_acct_line_id, cc_det_pf_line_id,

Line 2748: fnd_message.set_name ('IGC', 'IGC_CC_NO_RECORD_FOUND');

2744: );
2745: END IF;
2746:
2747: l_exception := NULL;
2748: fnd_message.set_name ('IGC', 'IGC_CC_NO_RECORD_FOUND');
2749:
2750: IF (g_excep_level >= g_debug_level)
2751: THEN
2752: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

Line 2755: l_exception := fnd_message.get;

2751: THEN
2752: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
2753: END IF;
2754:
2755: l_exception := fnd_message.get;
2756:
2757: INSERT INTO igc_cc_process_exceptions
2758: (process_type, process_phase, cc_header_id,
2759: cc_acct_line_id, cc_det_pf_line_id,

Line 2853: fnd_message.set_name ('IGC', 'IGC_CC_NO_RECORD_FOUND');

2849:
2850: IF l_rec_found = 0 AND l_exception IS NULL
2851: THEN
2852: l_fail := fnd_api.g_true;
2853: fnd_message.set_name ('IGC', 'IGC_CC_NO_RECORD_FOUND');
2854:
2855: IF (g_excep_level >= g_debug_level)
2856: THEN
2857: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

Line 2860: l_exception := fnd_message.get;

2856: THEN
2857: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
2858: END IF;
2859:
2860: l_exception := fnd_message.get;
2861:
2862: INSERT INTO igc_cc_process_exceptions
2863: (process_type, process_phase, cc_header_id,
2864: cc_acct_line_id, cc_det_pf_line_id, exception_reason,

Line 2916: fnd_message.set_name ('IGC',

2912: EXCEPTION
2913: WHEN NO_DATA_FOUND
2914: THEN
2915: l_exception := NULL;
2916: fnd_message.set_name ('IGC',
2917: 'IGC_CC_MPFS_CC_IN_PROCESS');
2918: fnd_message.set_token ('NUMBER', v4.cc_num, TRUE);
2919: fnd_message.set_token ('PROCESS_TYPE',
2920: l_process_type,

Line 2918: fnd_message.set_token ('NUMBER', v4.cc_num, TRUE);

2914: THEN
2915: l_exception := NULL;
2916: fnd_message.set_name ('IGC',
2917: 'IGC_CC_MPFS_CC_IN_PROCESS');
2918: fnd_message.set_token ('NUMBER', v4.cc_num, TRUE);
2919: fnd_message.set_token ('PROCESS_TYPE',
2920: l_process_type,
2921: TRUE
2922: );

Line 2919: fnd_message.set_token ('PROCESS_TYPE',

2915: l_exception := NULL;
2916: fnd_message.set_name ('IGC',
2917: 'IGC_CC_MPFS_CC_IN_PROCESS');
2918: fnd_message.set_token ('NUMBER', v4.cc_num, TRUE);
2919: fnd_message.set_token ('PROCESS_TYPE',
2920: l_process_type,
2921: TRUE
2922: );
2923:

Line 2929: l_exception := fnd_message.get;

2925: THEN
2926: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
2927: END IF;
2928:
2929: l_exception := fnd_message.get;
2930:
2931: INSERT INTO igc_cc_process_exceptions
2932: (process_type, process_phase,
2933: cc_header_id, cc_acct_line_id,

Line 2980: fnd_message.set_name ('IGC',

2976: );
2977: END IF;
2978:
2979: l_exception := NULL;
2980: fnd_message.set_name ('IGC',
2981: 'IGC_CC_SOURCE_PF_DT_NOT_CC_PRD'
2982: );
2983: fnd_message.set_token ('SOURCE_PF_DT',
2984: TO_CHAR (v4.cc_det_pf_date),

Line 2983: fnd_message.set_token ('SOURCE_PF_DT',

2979: l_exception := NULL;
2980: fnd_message.set_name ('IGC',
2981: 'IGC_CC_SOURCE_PF_DT_NOT_CC_PRD'
2982: );
2983: fnd_message.set_token ('SOURCE_PF_DT',
2984: TO_CHAR (v4.cc_det_pf_date),
2985: TRUE
2986: );
2987:

Line 2993: l_exception := fnd_message.get;

2989: THEN
2990: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
2991: END IF;
2992:
2993: l_exception := fnd_message.get;
2994:
2995: INSERT INTO igc_cc_process_exceptions
2996: (process_type, process_phase,
2997: cc_header_id, cc_acct_line_id,

Line 3040: fnd_message.set_name ('IGC',

3036: );
3037: END IF;
3038:
3039: l_exception := NULL;
3040: fnd_message.set_name ('IGC',
3041: 'IGC_CC_SOURCE_PF_DT_NOT_OPEN'
3042: );
3043: fnd_message.set_token ('SOURCE_PF_DT',
3044: TO_CHAR (v4.cc_det_pf_date),

Line 3043: fnd_message.set_token ('SOURCE_PF_DT',

3039: l_exception := NULL;
3040: fnd_message.set_name ('IGC',
3041: 'IGC_CC_SOURCE_PF_DT_NOT_OPEN'
3042: );
3043: fnd_message.set_token ('SOURCE_PF_DT',
3044: TO_CHAR (v4.cc_det_pf_date),
3045: TRUE
3046: );
3047:

Line 3053: l_exception := fnd_message.get;

3049: THEN
3050: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
3051: END IF;
3052:
3053: l_exception := fnd_message.get;
3054:
3055: INSERT INTO igc_cc_process_exceptions
3056: (process_type, process_phase,
3057: cc_header_id, cc_acct_line_id,

Line 3095: fnd_message.set_name ('IGC',

3091: EXCEPTION
3092: WHEN NO_DATA_FOUND
3093: THEN
3094: l_exception := NULL;
3095: fnd_message.set_name ('IGC',
3096: 'IGC_CC_MPFS_TGT_PF_NOT_FOUND'
3097: );
3098: fnd_message.set_token ('CC_NUM', v4.cc_num, TRUE);
3099:

Line 3098: fnd_message.set_token ('CC_NUM', v4.cc_num, TRUE);

3094: l_exception := NULL;
3095: fnd_message.set_name ('IGC',
3096: 'IGC_CC_MPFS_TGT_PF_NOT_FOUND'
3097: );
3098: fnd_message.set_token ('CC_NUM', v4.cc_num, TRUE);
3099:
3100: IF (g_excep_level >= g_debug_level)
3101: THEN
3102: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

Line 3105: l_exception := fnd_message.get;

3101: THEN
3102: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
3103: END IF;
3104:
3105: l_exception := fnd_message.get;
3106:
3107: INSERT INTO igc_cc_process_exceptions
3108: (process_type, process_phase,
3109: cc_header_id, cc_acct_line_id,

Line 3147: fnd_message.set_name

3143: EXCEPTION
3144: WHEN NO_DATA_FOUND
3145: THEN
3146: l_exception := NULL;
3147: fnd_message.set_name
3148: ('IGC',
3149: 'IGC_CC_TARGET_PF_DT_NOT_CC_PRD'
3150: );
3151: fnd_message.set_token ('TARGET_PF_DT',

Line 3151: fnd_message.set_token ('TARGET_PF_DT',

3147: fnd_message.set_name
3148: ('IGC',
3149: 'IGC_CC_TARGET_PF_DT_NOT_CC_PRD'
3150: );
3151: fnd_message.set_token ('TARGET_PF_DT',
3152: TO_CHAR (v7.cc_det_pf_date),
3153: TRUE
3154: );
3155:

Line 3162: l_exception := fnd_message.get;

3158: fnd_log.MESSAGE (g_excep_level, l_full_path,
3159: FALSE);
3160: END IF;
3161:
3162: l_exception := fnd_message.get;
3163:
3164: INSERT INTO igc_cc_process_exceptions
3165: (process_type, process_phase,
3166: cc_header_id, cc_acct_line_id,

Line 3204: fnd_message.set_name

3200: EXCEPTION
3201: WHEN NO_DATA_FOUND
3202: THEN
3203: l_exception := NULL;
3204: fnd_message.set_name
3205: ('IGC',
3206: 'IGC_CC_TARGET_PF_DT_NOT_GL_PRD'
3207: );
3208: fnd_message.set_token ('TARGET_PF_DT',

Line 3208: fnd_message.set_token ('TARGET_PF_DT',

3204: fnd_message.set_name
3205: ('IGC',
3206: 'IGC_CC_TARGET_PF_DT_NOT_GL_PRD'
3207: );
3208: fnd_message.set_token ('TARGET_PF_DT',
3209: TO_CHAR (v7.cc_det_pf_date),
3210: TRUE
3211: );
3212:

Line 3219: l_exception := fnd_message.get;

3215: fnd_log.MESSAGE (g_excep_level, l_full_path,
3216: FALSE);
3217: END IF;
3218:
3219: l_exception := fnd_message.get;
3220:
3221: INSERT INTO igc_cc_process_exceptions
3222: (process_type, process_phase,
3223: cc_header_id, cc_acct_line_id,

Line 3261: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_TGT_PF_NOT_FOUND');

3257: FETCH C6 INTO V6;
3258: IF C6%ROWCOUNT=0 THEN
3259: l_target_pf_found := FND_API.G_FALSE;
3260: l_EXCEPTION := NULL;
3261: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_TGT_PF_NOT_FOUND');
3262: FND_MESSAGE.SET_TOKEN('CC_NUM',V4.cc_num,TRUE);
3263: l_EXCEPTION := FND_MESSAGE.GET;
3264: INSERT INTO igc_cc_process_exceptions
3265: (PROCESS_TYPE ,

Line 3262: FND_MESSAGE.SET_TOKEN('CC_NUM',V4.cc_num,TRUE);

3258: IF C6%ROWCOUNT=0 THEN
3259: l_target_pf_found := FND_API.G_FALSE;
3260: l_EXCEPTION := NULL;
3261: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_TGT_PF_NOT_FOUND');
3262: FND_MESSAGE.SET_TOKEN('CC_NUM',V4.cc_num,TRUE);
3263: l_EXCEPTION := FND_MESSAGE.GET;
3264: INSERT INTO igc_cc_process_exceptions
3265: (PROCESS_TYPE ,
3266: PROCESS_PHASE ,

Line 3263: l_EXCEPTION := FND_MESSAGE.GET;

3259: l_target_pf_found := FND_API.G_FALSE;
3260: l_EXCEPTION := NULL;
3261: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_TGT_PF_NOT_FOUND');
3262: FND_MESSAGE.SET_TOKEN('CC_NUM',V4.cc_num,TRUE);
3263: l_EXCEPTION := FND_MESSAGE.GET;
3264: INSERT INTO igc_cc_process_exceptions
3265: (PROCESS_TYPE ,
3266: PROCESS_PHASE ,
3267: CC_HEADER_ID ,

Line 3379: fnd_message.set_name ('IGC', 'IGC_CC_MPFS_CC_LOCKED');

3375:
3376: IF l_lock_cc_status = FALSE
3377: THEN
3378: l_exception := NULL;
3379: fnd_message.set_name ('IGC', 'IGC_CC_MPFS_CC_LOCKED');
3380: fnd_message.set_token ('CC_NUMBER', l_cc_num, TRUE);
3381:
3382: IF (g_excep_level >= g_debug_level)
3383: THEN

Line 3380: fnd_message.set_token ('CC_NUMBER', l_cc_num, TRUE);

3376: IF l_lock_cc_status = FALSE
3377: THEN
3378: l_exception := NULL;
3379: fnd_message.set_name ('IGC', 'IGC_CC_MPFS_CC_LOCKED');
3380: fnd_message.set_token ('CC_NUMBER', l_cc_num, TRUE);
3381:
3382: IF (g_excep_level >= g_debug_level)
3383: THEN
3384: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

Line 3387: l_exception := fnd_message.get;

3383: THEN
3384: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
3385: END IF;
3386:
3387: l_exception := fnd_message.get;
3388:
3389: IF (g_debug_mode = 'Y')
3390: THEN
3391: output_debug

Line 3446: fnd_message.set_name ('IGC', 'IGC_CC_MPFS_PO_LOCKED');

3442: );
3443: END IF;
3444:
3445: l_exception := NULL;
3446: fnd_message.set_name ('IGC', 'IGC_CC_MPFS_PO_LOCKED');
3447: fnd_message.set_token ('CC_NUMBER', l_cc_num, TRUE);
3448:
3449: IF (g_excep_level >= g_debug_level)
3450: THEN

Line 3447: fnd_message.set_token ('CC_NUMBER', l_cc_num, TRUE);

3443: END IF;
3444:
3445: l_exception := NULL;
3446: fnd_message.set_name ('IGC', 'IGC_CC_MPFS_PO_LOCKED');
3447: fnd_message.set_token ('CC_NUMBER', l_cc_num, TRUE);
3448:
3449: IF (g_excep_level >= g_debug_level)
3450: THEN
3451: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

Line 3454: l_exception := fnd_message.get;

3450: THEN
3451: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
3452: END IF;
3453:
3454: l_exception := fnd_message.get;
3455:
3456: INSERT INTO igc_cc_process_exceptions
3457: (process_type, process_phase, cc_header_id,
3458: cc_acct_line_id, cc_det_pf_line_id,

Line 3521: fnd_message.set_name ('IGC',

3517: EXCEPTION
3518: WHEN NO_DATA_FOUND
3519: THEN
3520: l_exception := NULL;
3521: fnd_message.set_name ('IGC',
3522: 'IGC_CC_MPFS_CC_IN_PROCESS'
3523: );
3524: fnd_message.set_token ('NUMBER', v4_1.cc_num, TRUE);
3525: fnd_message.set_token ('PROCESS_TYPE',

Line 3524: fnd_message.set_token ('NUMBER', v4_1.cc_num, TRUE);

3520: l_exception := NULL;
3521: fnd_message.set_name ('IGC',
3522: 'IGC_CC_MPFS_CC_IN_PROCESS'
3523: );
3524: fnd_message.set_token ('NUMBER', v4_1.cc_num, TRUE);
3525: fnd_message.set_token ('PROCESS_TYPE',
3526: l_process_type,
3527: TRUE
3528: );

Line 3525: fnd_message.set_token ('PROCESS_TYPE',

3521: fnd_message.set_name ('IGC',
3522: 'IGC_CC_MPFS_CC_IN_PROCESS'
3523: );
3524: fnd_message.set_token ('NUMBER', v4_1.cc_num, TRUE);
3525: fnd_message.set_token ('PROCESS_TYPE',
3526: l_process_type,
3527: TRUE
3528: );
3529:

Line 3536: l_exception := fnd_message.get;

3532: fnd_log.MESSAGE (g_excep_level, l_full_path,
3533: FALSE);
3534: END IF;
3535:
3536: l_exception := fnd_message.get;
3537:
3538: INSERT INTO igc_cc_process_exceptions
3539: (process_type, process_phase,
3540: cc_header_id, cc_acct_line_id,

Line 3607: fnd_message.set_name ('IGC',

3603: );
3604: END IF;
3605:
3606: l_exception := NULL;
3607: fnd_message.set_name ('IGC',
3608: 'IGC_CC_SOURCE_PF_DT_NOT_CC_PRD'
3609: );
3610: fnd_message.set_token ('SOURCE_PF_DT',
3611: TO_CHAR (v4_2.cc_det_pf_date),

Line 3610: fnd_message.set_token ('SOURCE_PF_DT',

3606: l_exception := NULL;
3607: fnd_message.set_name ('IGC',
3608: 'IGC_CC_SOURCE_PF_DT_NOT_CC_PRD'
3609: );
3610: fnd_message.set_token ('SOURCE_PF_DT',
3611: TO_CHAR (v4_2.cc_det_pf_date),
3612: TRUE
3613: );
3614: l_exception := fnd_message.get;

Line 3614: l_exception := fnd_message.get;

3610: fnd_message.set_token ('SOURCE_PF_DT',
3611: TO_CHAR (v4_2.cc_det_pf_date),
3612: TRUE
3613: );
3614: l_exception := fnd_message.get;
3615:
3616: INSERT INTO igc_cc_process_exceptions
3617: (process_type, process_phase,
3618: cc_header_id, cc_acct_line_id,

Line 3671: fnd_message.set_name ('IGC',

3667: );
3668: END IF;
3669:
3670: l_exception := NULL;
3671: fnd_message.set_name ('IGC',
3672: 'IGC_CC_SOURCE_PF_DT_NOT_OPEN'
3673: );
3674: fnd_message.set_token ('SOURCE_PF_DT',
3675: TO_CHAR (v4_2.cc_det_pf_date),

Line 3674: fnd_message.set_token ('SOURCE_PF_DT',

3670: l_exception := NULL;
3671: fnd_message.set_name ('IGC',
3672: 'IGC_CC_SOURCE_PF_DT_NOT_OPEN'
3673: );
3674: fnd_message.set_token ('SOURCE_PF_DT',
3675: TO_CHAR (v4_2.cc_det_pf_date),
3676: TRUE
3677: );
3678:

Line 3685: l_exception := fnd_message.get;

3681: fnd_log.MESSAGE (g_excep_level, l_full_path,
3682: FALSE);
3683: END IF;
3684:
3685: l_exception := fnd_message.get;
3686:
3687: INSERT INTO igc_cc_process_exceptions
3688: (process_type, process_phase,
3689: cc_header_id, cc_acct_line_id,

Line 3746: fnd_message.set_name ('IGC',

3742: EXCEPTION
3743: WHEN NO_DATA_FOUND
3744: THEN
3745: l_exception := NULL;
3746: fnd_message.set_name ('IGC',
3747: 'IGC_CC_MPFS_TGT_PF_NOT_FOUND'
3748: );
3749: fnd_message.set_token ('CC_NUM', v4_1.cc_num, TRUE);
3750:

Line 3749: fnd_message.set_token ('CC_NUM', v4_1.cc_num, TRUE);

3745: l_exception := NULL;
3746: fnd_message.set_name ('IGC',
3747: 'IGC_CC_MPFS_TGT_PF_NOT_FOUND'
3748: );
3749: fnd_message.set_token ('CC_NUM', v4_1.cc_num, TRUE);
3750:
3751: IF (g_excep_level >= g_debug_level)
3752: THEN
3753: fnd_log.MESSAGE (g_excep_level, l_full_path,

Line 3757: l_exception := fnd_message.get;

3753: fnd_log.MESSAGE (g_excep_level, l_full_path,
3754: FALSE);
3755: END IF;
3756:
3757: l_exception := fnd_message.get;
3758:
3759: INSERT INTO igc_cc_process_exceptions
3760: (process_type, process_phase,
3761: cc_header_id, cc_acct_line_id,

Line 3840: fnd_message.set_name

3836: EXCEPTION
3837: WHEN NO_DATA_FOUND
3838: THEN
3839: l_exception := NULL;
3840: fnd_message.set_name
3841: ('IGC',
3842: 'IGC_CC_TARGET_PF_DT_NOT_CC_PRD'
3843: );
3844: fnd_message.set_token ('TARGET_PF_DT',

Line 3844: fnd_message.set_token ('TARGET_PF_DT',

3840: fnd_message.set_name
3841: ('IGC',
3842: 'IGC_CC_TARGET_PF_DT_NOT_CC_PRD'
3843: );
3844: fnd_message.set_token ('TARGET_PF_DT',
3845: TO_CHAR (v7.cc_det_pf_date),
3846: TRUE
3847: );
3848:

Line 3857: l_exception := fnd_message.get;

3853: FALSE
3854: );
3855: END IF;
3856:
3857: l_exception := fnd_message.get;
3858:
3859: INSERT INTO igc_cc_process_exceptions
3860: (process_type, process_phase,
3861: cc_header_id, cc_acct_line_id,

Line 3929: fnd_message.set_name

3925: EXCEPTION
3926: WHEN NO_DATA_FOUND
3927: THEN
3928: l_exception := NULL;
3929: fnd_message.set_name
3930: ('IGC',
3931: 'IGC_CC_TARGET_PF_DT_NOT_GL_PRD'
3932: );
3933: fnd_message.set_token ('TARGET_PF_DT',

Line 3933: fnd_message.set_token ('TARGET_PF_DT',

3929: fnd_message.set_name
3930: ('IGC',
3931: 'IGC_CC_TARGET_PF_DT_NOT_GL_PRD'
3932: );
3933: fnd_message.set_token ('TARGET_PF_DT',
3934: TO_CHAR (v7.cc_det_pf_date),
3935: TRUE
3936: );
3937:

Line 3946: l_exception := fnd_message.get;

3942: FALSE
3943: );
3944: END IF;
3945:
3946: l_exception := fnd_message.get;
3947:
3948: INSERT INTO igc_cc_process_exceptions
3949: (process_type, process_phase,
3950: cc_header_id, cc_acct_line_id,

Line 3988: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_TGT_PF_NOT_FOUND');

3984: FETCH C6 INTO V6;
3985: IF C6%ROWCOUNT=0 THEN
3986: l_target_pf_found := FND_API.G_FALSE;
3987: l_EXCEPTION := NULL;
3988: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_TGT_PF_NOT_FOUND');
3989: FND_MESSAGE.SET_TOKEN('CC_NUM',V4.cc_num,TRUE);
3990: l_EXCEPTION := FND_MESSAGE.GET;
3991: INSERT INTO igc_cc_process_exceptions
3992: (PROCESS_TYPE ,

Line 3989: FND_MESSAGE.SET_TOKEN('CC_NUM',V4.cc_num,TRUE);

3985: IF C6%ROWCOUNT=0 THEN
3986: l_target_pf_found := FND_API.G_FALSE;
3987: l_EXCEPTION := NULL;
3988: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_TGT_PF_NOT_FOUND');
3989: FND_MESSAGE.SET_TOKEN('CC_NUM',V4.cc_num,TRUE);
3990: l_EXCEPTION := FND_MESSAGE.GET;
3991: INSERT INTO igc_cc_process_exceptions
3992: (PROCESS_TYPE ,
3993: PROCESS_PHASE ,

Line 3990: l_EXCEPTION := FND_MESSAGE.GET;

3986: l_target_pf_found := FND_API.G_FALSE;
3987: l_EXCEPTION := NULL;
3988: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_TGT_PF_NOT_FOUND');
3989: FND_MESSAGE.SET_TOKEN('CC_NUM',V4.cc_num,TRUE);
3990: l_EXCEPTION := FND_MESSAGE.GET;
3991: INSERT INTO igc_cc_process_exceptions
3992: (PROCESS_TYPE ,
3993: PROCESS_PHASE ,
3994: CC_HEADER_ID ,

Line 4260: fnd_message.set_name ('IGC', 'IGC_CC_FAILED_TO_ENCUMBER');

4256: );
4257: END IF;
4258:
4259: l_exception := NULL;
4260: fnd_message.set_name ('IGC', 'IGC_CC_FAILED_TO_ENCUMBER');
4261: fnd_message.set_token ('CC_NUM', v4.cc_num, TRUE);
4262:
4263: IF (g_error_level >= g_debug_level)
4264: THEN

Line 4261: fnd_message.set_token ('CC_NUM', v4.cc_num, TRUE);

4257: END IF;
4258:
4259: l_exception := NULL;
4260: fnd_message.set_name ('IGC', 'IGC_CC_FAILED_TO_ENCUMBER');
4261: fnd_message.set_token ('CC_NUM', v4.cc_num, TRUE);
4262:
4263: IF (g_error_level >= g_debug_level)
4264: THEN
4265: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);

Line 4268: l_exception := fnd_message.get;

4264: THEN
4265: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);
4266: END IF;
4267:
4268: l_exception := fnd_message.get;
4269:
4270: INSERT INTO igc_cc_process_exceptions
4271: (process_type, process_phase, cc_header_id,
4272: cc_acct_line_id, cc_det_pf_line_id,

Line 4365: fnd_message.set_name ('IGC', 'IGC_CC_PARAM_VALID_FAILED');

4361: l_org_id, l_sob_id, l_request_id1
4362: );
4363:
4364: l_exception := NULL;
4365: fnd_message.set_name ('IGC', 'IGC_CC_PARAM_VALID_FAILED');
4366:
4367: IF (g_error_level >= g_debug_level)
4368: THEN
4369: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);

Line 4372: l_exception := fnd_message.get;

4368: THEN
4369: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);
4370: END IF;
4371:
4372: l_exception := fnd_message.get;
4373:
4374: INSERT INTO igc_cc_process_exceptions
4375: (process_type, process_phase, cc_header_id,
4376: cc_acct_line_id, cc_det_pf_line_id, exception_reason,