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.FTE_BULK_DTT_PKG dependencies on FND_MESSAGE

Line 199: x_error_msg_text := fnd_message.get;

195: WSH_DEBUG_SV.log(l_module_name,'x_request_id = ',x_request_id);
196: END IF;
197:
198:
199: x_error_msg_text := fnd_message.get;
200:
201: commit;
202:
203: IF l_debug_on THEN

Line 1611: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_TIME_FORMAT');

1607: --
1608: IF (utl_file.is_open(l_dtt_file)) THEN
1609: utl_file.fclose(l_dtt_file);
1610: END IF;
1611: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_TIME_FORMAT');
1612: x_return_status := 2;
1613: x_return_message := FND_MESSAGE.GET;
1614: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV TIME FORMAT. '||x_return_message);
1615:

Line 1613: x_return_message := FND_MESSAGE.GET;

1609: utl_file.fclose(l_dtt_file);
1610: END IF;
1611: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_TIME_FORMAT');
1612: x_return_status := 2;
1613: x_return_message := FND_MESSAGE.GET;
1614: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV TIME FORMAT. '||x_return_message);
1615:
1616: --
1617: -- Close the cursors

Line 1671: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_LINE_LENGTH');

1667: --
1668: IF (utl_file.is_open(l_dtt_file)) THEN
1669: utl_file.fclose(l_dtt_file);
1670: END IF;
1671: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_LINE_LENGTH');
1672: x_return_status := 2;
1673: x_return_message := FND_MESSAGE.GET;
1674: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV LINE LENGTH. '||x_return_message);
1675:

Line 1673: x_return_message := FND_MESSAGE.GET;

1669: utl_file.fclose(l_dtt_file);
1670: END IF;
1671: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_LINE_LENGTH');
1672: x_return_status := 2;
1673: x_return_message := FND_MESSAGE.GET;
1674: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV LINE LENGTH. '||x_return_message);
1675:
1676: --
1677: -- Close the cursors

Line 2478: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_TEMP_TIME_UOM');

2474:
2475: -- AXE
2476: EXCEPTION
2477: WHEN FTE_DIST_INV_TEMP_TIME_UOM THEN
2478: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_TEMP_TIME_UOM');
2479: x_return_status := 2;
2480: x_return_message := FND_MESSAGE.GET;
2481: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV TEMP TIME UOM. '||x_return_message);
2482: --

Line 2480: x_return_message := FND_MESSAGE.GET;

2476: EXCEPTION
2477: WHEN FTE_DIST_INV_TEMP_TIME_UOM THEN
2478: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_TEMP_TIME_UOM');
2479: x_return_status := 2;
2480: x_return_message := FND_MESSAGE.GET;
2481: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV TEMP TIME UOM. '||x_return_message);
2482: --
2483: -- Close the file
2484: --

Line 2538: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_TIME_UOM');

2534: RETURN;
2535:
2536:
2537: WHEN FTE_DIST_NO_TIME_UOM THEN
2538: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_TIME_UOM');
2539: x_return_status := 2;
2540: x_return_message := FND_MESSAGE.GET;
2541: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO TIME UOM. '||x_return_message);
2542: --

Line 2540: x_return_message := FND_MESSAGE.GET;

2536:
2537: WHEN FTE_DIST_NO_TIME_UOM THEN
2538: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_TIME_UOM');
2539: x_return_status := 2;
2540: x_return_message := FND_MESSAGE.GET;
2541: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO TIME UOM. '||x_return_message);
2542: --
2543: -- Close the file
2544: --

Line 2598: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_TEMP_DIST_UOM');

2594: RETURN;
2595:
2596:
2597: WHEN FTE_DIST_INV_TEMP_DIST_UOM THEN
2598: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_TEMP_DIST_UOM');
2599: x_return_status := 2;
2600: x_return_message := FND_MESSAGE.GET;
2601: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV TEMP DIST UOM. '||x_return_message);
2602: --

Line 2600: x_return_message := FND_MESSAGE.GET;

2596:
2597: WHEN FTE_DIST_INV_TEMP_DIST_UOM THEN
2598: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_TEMP_DIST_UOM');
2599: x_return_status := 2;
2600: x_return_message := FND_MESSAGE.GET;
2601: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV TEMP DIST UOM. '||x_return_message);
2602: --
2603: -- Close the file
2604: --

Line 2659: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_DISTANCE_UOM');

2655:
2656:
2657:
2658: WHEN FTE_DIST_NO_DISTANCE_UOM THEN
2659: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_DISTANCE_UOM');
2660: x_return_status := 2;
2661: x_return_message := FND_MESSAGE.GET;
2662: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO DISTANCE UOM. '||x_return_message);
2663: --

Line 2661: x_return_message := FND_MESSAGE.GET;

2657:
2658: WHEN FTE_DIST_NO_DISTANCE_UOM THEN
2659: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_DISTANCE_UOM');
2660: x_return_status := 2;
2661: x_return_message := FND_MESSAGE.GET;
2662: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO DISTANCE UOM. '||x_return_message);
2663: --
2664: -- Close the file
2665: --

Line 2720: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_ORIG_DEST_LOAD_ERR');

2716:
2717:
2718:
2719: WHEN FTE_DIST_ORIG_DEST_LOAD_ERR THEN
2720: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_ORIG_DEST_LOAD_ERR');
2721: x_return_status := 2;
2722: x_return_message := FND_MESSAGE.GET;
2723: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - ORIG DEST LOAD ERR. '||x_return_message);
2724: --

Line 2722: x_return_message := FND_MESSAGE.GET;

2718:
2719: WHEN FTE_DIST_ORIG_DEST_LOAD_ERR THEN
2720: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_ORIG_DEST_LOAD_ERR');
2721: x_return_status := 2;
2722: x_return_message := FND_MESSAGE.GET;
2723: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - ORIG DEST LOAD ERR. '||x_return_message);
2724: --
2725: -- Close the file
2726: --

Line 2781: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_LESS_FILE_LINES');

2777:
2778:
2779:
2780: WHEN FTE_DIST_LESS_FILE_LINES THEN
2781: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_LESS_FILE_LINES');
2782: x_return_status := 2;
2783: x_return_message := FND_MESSAGE.GET;
2784: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - LESS FILE LINES. '||x_return_message);
2785: --

Line 2783: x_return_message := FND_MESSAGE.GET;

2779:
2780: WHEN FTE_DIST_LESS_FILE_LINES THEN
2781: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_LESS_FILE_LINES');
2782: x_return_status := 2;
2783: x_return_message := FND_MESSAGE.GET;
2784: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - LESS FILE LINES. '||x_return_message);
2785: --
2786: -- Close the file
2787: --

Line 2841: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_MANY_FILE_LINES');

2837: RETURN;
2838:
2839:
2840: WHEN FTE_DIST_MANY_FILE_LINES THEN
2841: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_MANY_FILE_LINES');
2842: x_return_status := 2;
2843: x_return_message := FND_MESSAGE.GET;
2844: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - TOO MANY FILE LINES. '||x_return_message);
2845: --

Line 2843: x_return_message := FND_MESSAGE.GET;

2839:
2840: WHEN FTE_DIST_MANY_FILE_LINES THEN
2841: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_MANY_FILE_LINES');
2842: x_return_status := 2;
2843: x_return_message := FND_MESSAGE.GET;
2844: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - TOO MANY FILE LINES. '||x_return_message);
2845: --
2846: -- Close the file
2847: --

Line 2902: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_FILE_NAME');

2898:
2899:
2900:
2901: WHEN FTE_DIST_NULL_FILE_NAME THEN
2902: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_FILE_NAME');
2903: x_return_status := 2;
2904: x_return_message := FND_MESSAGE.GET;
2905: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NULL FILE NAME. '||x_return_message);
2906: --

Line 2904: x_return_message := FND_MESSAGE.GET;

2900:
2901: WHEN FTE_DIST_NULL_FILE_NAME THEN
2902: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_FILE_NAME');
2903: x_return_status := 2;
2904: x_return_message := FND_MESSAGE.GET;
2905: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NULL FILE NAME. '||x_return_message);
2906: --
2907: -- Close the file
2908: --

Line 2963: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_FILE_LENGTH');

2959:
2960:
2961:
2962: WHEN FTE_DIST_INV_FILENAME_LGTH THEN
2963: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_FILE_LENGTH');
2964: x_return_status := 2;
2965: x_return_message := FND_MESSAGE.GET;
2966: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INVALID FILE LENGTH. '||x_return_message);
2967: --

Line 2965: x_return_message := FND_MESSAGE.GET;

2961:
2962: WHEN FTE_DIST_INV_FILENAME_LGTH THEN
2963: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_FILE_LENGTH');
2964: x_return_status := 2;
2965: x_return_message := FND_MESSAGE.GET;
2966: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INVALID FILE LENGTH. '||x_return_message);
2967: --
2968: -- Close the file
2969: --

Line 3022: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILE_DOWNLOAD');

3018: --
3019: RETURN;
3020:
3021: WHEN FTE_DIST_NO_FILE_DOWNLOAD THEN
3022: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILE_DOWNLOAD');
3023: x_return_status := 2;
3024: x_return_message := FND_MESSAGE.GET;
3025: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO FILE DOWNLOAD. '||x_return_message);
3026: --

Line 3024: x_return_message := FND_MESSAGE.GET;

3020:
3021: WHEN FTE_DIST_NO_FILE_DOWNLOAD THEN
3022: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILE_DOWNLOAD');
3023: x_return_status := 2;
3024: x_return_message := FND_MESSAGE.GET;
3025: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO FILE DOWNLOAD. '||x_return_message);
3026: --
3027: -- Close the file
3028: --

Line 3081: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILE_TEMPLATE');

3077: --
3078: RETURN;
3079:
3080: WHEN FTE_DIST_NO_FILE_TEMPLATE THEN
3081: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILE_TEMPLATE');
3082: x_return_status := 2;
3083: x_return_message := FND_MESSAGE.GET;
3084: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO FILE TEMPLATE. '||x_return_message);
3085: --

Line 3083: x_return_message := FND_MESSAGE.GET;

3079:
3080: WHEN FTE_DIST_NO_FILE_TEMPLATE THEN
3081: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILE_TEMPLATE');
3082: x_return_status := 2;
3083: x_return_message := FND_MESSAGE.GET;
3084: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO FILE TEMPLATE. '||x_return_message);
3085: --
3086: -- Close the file
3087: --

Line 3140: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILE_DOWNLOAD_DATE');

3136:
3137:
3138:
3139: WHEN FTE_DIST_NO_FILE_DOWNLOAD_DATE THEN
3140: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILE_DOWNLOAD_DATE');
3141: x_return_status := 2;
3142: x_return_message := FND_MESSAGE.GET;
3143: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO FILE DOWNLOAD_DATE. '||x_return_message);
3144: --

Line 3142: x_return_message := FND_MESSAGE.GET;

3138:
3139: WHEN FTE_DIST_NO_FILE_DOWNLOAD_DATE THEN
3140: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILE_DOWNLOAD_DATE');
3141: x_return_status := 2;
3142: x_return_message := FND_MESSAGE.GET;
3143: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO FILE DOWNLOAD_DATE. '||x_return_message);
3144: --
3145: -- Close the file
3146: --

Line 3198: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_FILE_UPLOAD_DONE_PREV');

3194: RETURN;
3195:
3196:
3197: WHEN FTE_DIST_FILE_UPLOAD_DONE_PREV THEN
3198: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_FILE_UPLOAD_DONE_PREV');
3199: x_return_status := 2;
3200: x_return_message := FND_MESSAGE.GET;
3201: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - PREVIOUS FILE UPLOAD EXISTS. '||x_return_message);
3202: --

Line 3200: x_return_message := FND_MESSAGE.GET;

3196:
3197: WHEN FTE_DIST_FILE_UPLOAD_DONE_PREV THEN
3198: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_FILE_UPLOAD_DONE_PREV');
3199: x_return_status := 2;
3200: x_return_message := FND_MESSAGE.GET;
3201: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - PREVIOUS FILE UPLOAD EXISTS. '||x_return_message);
3202: --
3203: -- Close the file
3204: --

Line 3256: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_DOWNLOAD_LINES');

3252: RETURN;
3253:
3254:
3255: WHEN FTE_DIST_NO_DOWNLOAD_LINES THEN
3256: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_DOWNLOAD_LINES');
3257: x_return_status := 2;
3258: x_return_message := FND_MESSAGE.GET;
3259: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO DOWNLOAD LINES. '||x_return_message);
3260: --

Line 3258: x_return_message := FND_MESSAGE.GET;

3254:
3255: WHEN FTE_DIST_NO_DOWNLOAD_LINES THEN
3256: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_DOWNLOAD_LINES');
3257: x_return_status := 2;
3258: x_return_message := FND_MESSAGE.GET;
3259: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO DOWNLOAD LINES. '||x_return_message);
3260: --
3261: -- Close the file
3262: --

Line 3314: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_DIST_COL_NO_DATA');

3310: RETURN;
3311:
3312:
3313: WHEN FTE_DIST_RET_DIST_COL_NO_DATA THEN
3314: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_DIST_COL_NO_DATA');
3315: x_return_status := 2;
3316: x_return_message := FND_MESSAGE.GET;
3317: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO RETURN DISTANCE COLUMN DATA. '||x_return_message);
3318: --

Line 3316: x_return_message := FND_MESSAGE.GET;

3312:
3313: WHEN FTE_DIST_RET_DIST_COL_NO_DATA THEN
3314: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_DIST_COL_NO_DATA');
3315: x_return_status := 2;
3316: x_return_message := FND_MESSAGE.GET;
3317: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO RETURN DISTANCE COLUMN DATA. '||x_return_message);
3318: --
3319: -- Close the file
3320: --

Line 3371: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_TIME_COL_NO_DATA');

3367: --
3368: RETURN;
3369:
3370: WHEN FTE_DIST_RET_TIME_COL_NO_DATA THEN
3371: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_TIME_COL_NO_DATA');
3372: x_return_status := 2;
3373: x_return_message := FND_MESSAGE.GET;
3374: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO RETURN TIME COLUMN DATA. '||x_return_message);
3375: --

Line 3373: x_return_message := FND_MESSAGE.GET;

3369:
3370: WHEN FTE_DIST_RET_TIME_COL_NO_DATA THEN
3371: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_TIME_COL_NO_DATA');
3372: x_return_status := 2;
3373: x_return_message := FND_MESSAGE.GET;
3374: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO RETURN TIME COLUMN DATA. '||x_return_message);
3375: --
3376: -- Close the file
3377: --

Line 3429: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_RET_COL_ENABLED');

3425: RETURN;
3426:
3427:
3428: WHEN FTE_DIST_NO_RET_COL_ENABLED THEN
3429: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_RET_COL_ENABLED');
3430: x_return_status := 2;
3431: x_return_message := FND_MESSAGE.GET;
3432: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO RETURN COLUMNS ENABLED. '||x_return_message);
3433: --

Line 3431: x_return_message := FND_MESSAGE.GET;

3427:
3428: WHEN FTE_DIST_NO_RET_COL_ENABLED THEN
3429: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_RET_COL_ENABLED');
3430: x_return_status := 2;
3431: x_return_message := FND_MESSAGE.GET;
3432: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO RETURN COLUMNS ENABLED. '||x_return_message);
3433: --
3434: -- Close the file
3435: --