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.WSH_BATCH_PROCESS dependencies on FND_FILE

Line 3009: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3005: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3006: p_lookup_code => p_select_criteria.delivery_lines_status,
3007: p_lookup_type => 'WSH_PD_DEL_LINE_STATUS' );
3008: FND_MESSAGE.SET_TOKEN('DETAILS_STATUS', l_msg_string);
3009: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3010:
3011: WSH_UTIL_CORE.PrintMsg(' Delivery Lines Status: '|| p_select_criteria.delivery_lines_status);
3012: END IF;
3013:

Line 3019: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3015: IF p_select_criteria.organization_id IS NOT NULL THEN
3016: l_sc_WHERE := l_sc_WHERE ||'AND wdd.organization_id = :x_organization_id ';
3017: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
3018: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_select_criteria.organization_id));
3019: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3020:
3021: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| p_select_criteria.organization_id);
3022: END IF;
3023:

Line 3037: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);

3033:
3034:
3035: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
3036: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3037: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3038:
3039: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3040: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3041: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);

Line 3041: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);

3037: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3038:
3039: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3040: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3041: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3042:
3043: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3044: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3045:

Line 3052: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);

3048: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled >= :x_scheduled_ship_date_lo ';
3049:
3050: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
3051: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3052: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3053: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3054:
3055: ELSE
3056: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);

Line 3060: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);

3056: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);
3057: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled <= :x_scheduled_ship_date_hi ';
3058: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3059: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3060: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3061: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3062: END IF;
3063: END IF;
3064:

Line 3077: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3073:
3074: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3075: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3076:
3077: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3078:
3079: WSH_UTIL_CORE.PrintMsg(' Ship to Location ID: '|| to_char(p_select_criteria.ship_to_loc_id));
3080: END IF;
3081:

Line 3092: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3088: p_lookup_code => p_select_criteria.source_code,
3089: p_lookup_type => 'WSH_PD_SOURCE_SYSTEM' );
3090: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SOURCE_SYSTEM');
3091: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', l_msg_string);
3092: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3093: WSH_UTIL_CORE.PrintMsg(' Source System: '|| p_select_criteria.source_code);
3094: ELSE
3095: l_sc_WHERE := l_sc_WHERE ||'AND wdd.source_code = :x_source_code ';
3096: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(

Line 3101: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3097: p_lookup_code => p_select_criteria.source_code,
3098: p_lookup_type => 'SOURCE_SYSTEM' );
3099: FND_MESSAGE.SET_NAME('WSH', 'SOURCE_SYSTEM');
3100: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', l_msg_string);
3101: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3102: WSH_UTIL_CORE.PrintMsg(' Source System: '|| p_select_criteria.source_code);
3103: END IF;
3104:
3105: l_msg_string := NULL;

Line 3131: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3127: CLOSE get_customer_name;
3128:
3129: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3130: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3131: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3132:
3133: WSH_UTIL_CORE.PrintMsg(' Customer ID: '|| SubStr(p_select_criteria.customer_id,3)); --RTV changes
3134: END IF;
3135:

Line 3145: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3141: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3142: p_lookup_code => p_select_criteria.ship_method_code,
3143: p_lookup_type => 'SHIP_METHOD' );
3144: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_msg_string);
3145: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3146: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_select_criteria.ship_method_code);
3147: END IF;
3148:
3149: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');

Line 3151: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3147: END IF;
3148:
3149: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
3150: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(p_select_criteria.log_level));
3151: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3152: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| p_select_criteria.log_level);
3153: --
3154: -- LSP PROJECT : put client id in the where clause if it is part of selection criteria
3155: IF p_select_criteria.client_id IS NOT NULL THEN

Line 3172: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3168: END IF;
3169: END IF;
3170: FND_MESSAGE.SET_NAME('WSH', 'WSH_CLIENT');
3171: FND_MESSAGE.SET_TOKEN('CLIENT_NAME', l_msg_string);
3172: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3173: WSH_UTIL_CORE.PrintMsg(' Client ID: '|| p_select_criteria.client_id);
3174: END IF;
3175: -- LSP PROJECT : end
3176: --

Line 3762: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3758: WSH_UTIL_CORE.Set_Log_Level(l_log_level);
3759:
3760:
3761: FND_MESSAGE.SET_NAME('WSH','WSH_PD_PARM');
3762: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3763: FND_FILE.put_line(FND_FILE.output,'====================');
3764:
3765: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PROCESSED_ENTITIES');
3766: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(

Line 3763: FND_FILE.put_line(FND_FILE.output,'====================');

3759:
3760:
3761: FND_MESSAGE.SET_NAME('WSH','WSH_PD_PARM');
3762: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3763: FND_FILE.put_line(FND_FILE.output,'====================');
3764:
3765: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PROCESSED_ENTITIES');
3766: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3767: p_lookup_code => p_entity_type,

Line 3770: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3766: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3767: p_lookup_code => p_entity_type,
3768: p_lookup_type => 'WSH_PD_ENTITY' );
3769: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE', l_msg_string);
3770: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3771:
3772:
3773: -- print required input parameters
3774: WSH_UTIL_CORE.PrintMsg('Input Parameters: ' );

Line 3780: FND_FILE.put_line(FND_FILE.output, ' ');

3776:
3777: IF p_entity_type = 'D' THEN
3778: --
3779: IF WSH_UTIL_CORE.TP_Is_Installed = 'Y' THEN
3780: FND_FILE.put_line(FND_FILE.output, ' ');
3781: FND_FILE.put_line(FND_FILE.output, ' ');
3782: -- print the summary results of auto create trips action
3783: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_TRIP_CONSOLIDATION');
3784: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 3781: FND_FILE.put_line(FND_FILE.output, ' ');

3777: IF p_entity_type = 'D' THEN
3778: --
3779: IF WSH_UTIL_CORE.TP_Is_Installed = 'Y' THEN
3780: FND_FILE.put_line(FND_FILE.output, ' ');
3781: FND_FILE.put_line(FND_FILE.output, ' ');
3782: -- print the summary results of auto create trips action
3783: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_TRIP_CONSOLIDATION');
3784: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3785: WSH_UTIL_CORE.PrintMsg('Trip Consolidation is disabled because Transportation Planning is installed. ');

Line 3784: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3780: FND_FILE.put_line(FND_FILE.output, ' ');
3781: FND_FILE.put_line(FND_FILE.output, ' ');
3782: -- print the summary results of auto create trips action
3783: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_TRIP_CONSOLIDATION');
3784: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3785: WSH_UTIL_CORE.PrintMsg('Trip Consolidation is disabled because Transportation Planning is installed. ');
3786: ELSE
3787: --
3788: l_pickup_date_lo := fnd_date.canonical_to_date(p_pickup_date_lo);

Line 3797: FND_FILE.put_line(FND_FILE.output,' ');

3793: -- bug 3319789
3794: IF p_scheduled_ship_date_lo is not NULL OR
3795: p_scheduled_ship_date_hi is not NULL THEN
3796: FND_MESSAGE.SET_NAME('WSH', 'WSH_SCHD_DATE_NOT_ALLOWED');
3797: FND_FILE.put_line(FND_FILE.output,' ');
3798: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3799: WSH_UTIL_CORE.PrintMsg('Scheduled Ship Date parameters are not applicable for entity Deliveries Only. Please do not enter Sheduled Ship Date range when selecting entity Deliveries Only.');
3800: raise Parameters_ERR;
3801: END IF;

Line 3798: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3794: IF p_scheduled_ship_date_lo is not NULL OR
3795: p_scheduled_ship_date_hi is not NULL THEN
3796: FND_MESSAGE.SET_NAME('WSH', 'WSH_SCHD_DATE_NOT_ALLOWED');
3797: FND_FILE.put_line(FND_FILE.output,' ');
3798: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3799: WSH_UTIL_CORE.PrintMsg('Scheduled Ship Date parameters are not applicable for entity Deliveries Only. Please do not enter Sheduled Ship Date range when selecting entity Deliveries Only.');
3800: raise Parameters_ERR;
3801: END IF;
3802:

Line 3843: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3839: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3840: p_lookup_code => p_deliveries_status,
3841: p_lookup_type => 'WSH_PD_DEL_STATUS' );
3842: FND_MESSAGE.SET_TOKEN('DELIVERIES_STATUS', l_msg_string);
3843: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3844: WSH_UTIL_CORE.PrintMsg(' Deliveries Status: '|| l_deliveries_status);
3845: END IF;
3846:
3847: IF p_pickup_date_lo IS NOT NULL THEN

Line 3850: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3846:
3847: IF p_pickup_date_lo IS NOT NULL THEN
3848: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_LO');
3849: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3850: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3851: WSH_UTIL_CORE.PrintMsg(' Pick Up Date Start: '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3852: END IF;
3853:
3854: IF p_pickup_date_hi IS NOT NULL THEN

Line 3857: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3853:
3854: IF p_pickup_date_hi IS NOT NULL THEN
3855: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_HI');
3856: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3857: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3858: WSH_UTIL_CORE.PrintMsg(' Pick Up Date End: '|| to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3859: END IF;
3860:
3861: -- bug 3332670

Line 3868: FND_FILE.put_line(FND_FILE.output,' ');

3864: IF l_pickup_date_hi < l_pickup_date_lo THEN
3865: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_RANGE');
3866: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3867: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3868: FND_FILE.put_line(FND_FILE.output,' ');
3869: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3870: WSH_UTIL_CORE.PrintMsg('The end date of Pick Up Date range '||to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS')||' should not precede the start date '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3871: raise Parameters_ERR;
3872: END IF;

Line 3869: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3865: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_RANGE');
3866: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3867: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3868: FND_FILE.put_line(FND_FILE.output,' ');
3869: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3870: WSH_UTIL_CORE.PrintMsg('The end date of Pick Up Date range '||to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS')||' should not precede the start date '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3871: raise Parameters_ERR;
3872: END IF;
3873: END IF;

Line 3878: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3874:
3875: IF p_dropoff_date_lo IS NOT NULL THEN
3876: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_LO');
3877: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3878: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3879: WSH_UTIL_CORE.PrintMsg(' Drop Off Date Start: '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3880: END IF;
3881:
3882: IF p_dropoff_date_hi IS NOT NULL THEN

Line 3885: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3881:
3882: IF p_dropoff_date_hi IS NOT NULL THEN
3883: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_HI');
3884: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3885: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3886: WSH_UTIL_CORE.PrintMsg(' Drop Off Date End: '|| to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3887: END IF;
3888:
3889: -- bug 3332670

Line 3896: FND_FILE.put_line(FND_FILE.output,' ');

3892: IF l_dropoff_date_hi < l_dropoff_date_lo THEN
3893: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_RANGE');
3894: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3895: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3896: FND_FILE.put_line(FND_FILE.output,' ');
3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3898: WSH_UTIL_CORE.PrintMsg('The end date of Drop Off Date range '||to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS')||' should not precede the start date '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3899: raise Parameters_ERR;
3900: END IF;

Line 3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3893: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_RANGE');
3894: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3895: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3896: FND_FILE.put_line(FND_FILE.output,' ');
3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3898: WSH_UTIL_CORE.PrintMsg('The end date of Drop Off Date range '||to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS')||' should not precede the start date '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3899: raise Parameters_ERR;
3900: END IF;
3901: END IF;

Line 3921: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3917: END IF;
3918:
3919: FND_MESSAGE.SET_NAME('WSH', 'WSH_CLIENT');
3920: FND_MESSAGE.SET_TOKEN('CLIENT_NAME', l_msg_string);
3921: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3922: WSH_UTIL_CORE.PrintMsg(' Client ID: '|| (p_client_id));
3923: END IF;
3924: /*Modified R12.1.1 LSP PROJECT*/
3925:

Line 3929: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3925:
3926: IF p_organization_id IS NOT NULL THEN
3927: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
3928: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_organization_id));
3929: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3930: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| to_char(p_organization_id));
3931: END IF;
3932:
3933: IF p_customer_id IS NOT NULL THEN

Line 3941: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3937: CLOSE get_customer_name;
3938:
3939: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3940: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3941: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3942: --bug fix 3286811
3943: WSH_UTIL_CORE.PrintMsg(' Customer ID: '||(SubStr(p_customer_id,3))); --RTV changes
3944: END IF;
3945:

Line 3954: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3950: 1, 80);
3951:
3952: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3953: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3954: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3955: WSH_UTIL_CORE.PrintMsg(' Ship to Location ID: '|| to_char(p_ship_to_loc_id));
3956: END IF;
3957:
3958: IF p_ship_method_code IS NOT NULL THEN

Line 3966: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3962: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3963: p_lookup_code => p_ship_method_code,
3964: p_lookup_type => 'SHIP_METHOD' );
3965: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_msg_string);
3966: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3967: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_ship_method_code);
3968: END IF;
3969:
3970: IF l_grp_ship_method IS NOT NULL THEN

Line 3977: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3973: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3974: p_lookup_code => l_grp_ship_method,
3975: p_lookup_type => 'YES_NO' );
3976: FND_MESSAGE.SET_TOKEN('GRP_SHIP_METHOD', l_msg_string);
3977: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3978: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship Method: '|| l_grp_ship_method);
3979: END IF;
3980:
3981: IF l_grp_ship_from IS NOT NULL THEN

Line 3988: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3984: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3985: p_lookup_code => l_grp_ship_from,
3986: p_lookup_type => 'YES_NO' );
3987: FND_MESSAGE.SET_TOKEN('GRP_SHIP_FROM', l_msg_string);
3988: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3989: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship from Organization: '|| l_grp_ship_from);
3990: END IF;
3991:
3992: IF l_max_del_number IS NOT NULL THEN

Line 3995: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3991:
3992: IF l_max_del_number IS NOT NULL THEN
3993: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MAX_DEL_NUMBER');
3994: FND_MESSAGE.SET_TOKEN('MAX_DEL_NUMBER', to_char(l_max_del_number));
3995: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3996: WSH_UTIL_CORE.PrintMsg(' Maximum Number of Deliveries per Trip: '|| to_char(l_max_del_number));
3997: END IF;
3998:
3999: IF l_log_level IS NOT NULL THEN

Line 4002: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

3998:
3999: IF l_log_level IS NOT NULL THEN
4000: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
4001: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(l_log_level));
4002: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4003: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| l_log_level );
4004: END IF;
4005:
4006: IF l_debug_on THEN

Line 4031: FND_FILE.put_line(FND_FILE.output,' ');

4027: x_Trips => l_trip_num,
4028: x_return_status => l_return_status);
4029:
4030: -- print the summary results of auto create trips action
4031: FND_FILE.put_line(FND_FILE.output,' ');
4032: FND_FILE.put_line(FND_FILE.output,' ');
4033: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4034: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4035: FND_FILE.put_line(FND_FILE.output,'====================');

Line 4032: FND_FILE.put_line(FND_FILE.output,' ');

4028: x_return_status => l_return_status);
4029:
4030: -- print the summary results of auto create trips action
4031: FND_FILE.put_line(FND_FILE.output,' ');
4032: FND_FILE.put_line(FND_FILE.output,' ');
4033: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4034: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4035: FND_FILE.put_line(FND_FILE.output,'====================');
4036:

Line 4034: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4030: -- print the summary results of auto create trips action
4031: FND_FILE.put_line(FND_FILE.output,' ');
4032: FND_FILE.put_line(FND_FILE.output,' ');
4033: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4034: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4035: FND_FILE.put_line(FND_FILE.output,'====================');
4036:
4037: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
4038: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));

Line 4035: FND_FILE.put_line(FND_FILE.output,'====================');

4031: FND_FILE.put_line(FND_FILE.output,' ');
4032: FND_FILE.put_line(FND_FILE.output,' ');
4033: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4034: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4035: FND_FILE.put_line(FND_FILE.output,'====================');
4036:
4037: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
4038: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));
4039: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 4039: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4035: FND_FILE.put_line(FND_FILE.output,'====================');
4036:
4037: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
4038: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));
4039: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4040:
4041: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
4042: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
4043: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 4043: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4039: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4040:
4041: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
4042: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
4043: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4044:
4045: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');
4046: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRIPS', to_char(l_trip_num));
4047: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 4047: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4043: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4044:
4045: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');
4046: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRIPS', to_char(l_trip_num));
4047: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4048:
4049: WSH_UTIL_CORE.PrintDateTime;
4050: WSH_UTIL_CORE.PrintMsg('Summary: ');
4051: WSH_UTIL_CORE.PrintMsg(to_char(l_del_num)|| ' deliveries selected for processing');

Line 4067: FND_FILE.put_line(FND_FILE.output,' ');

4063: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4064: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_WARNING');
4065: END IF;
4066:
4067: FND_FILE.put_line(FND_FILE.output,' ');
4068: FND_FILE.put_line(FND_FILE.output,' ');
4069: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4070:
4071: -- print warning or error messages Process_Delivery_Lines_Batch

Line 4068: FND_FILE.put_line(FND_FILE.output,' ');

4064: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_WARNING');
4065: END IF;
4066:
4067: FND_FILE.put_line(FND_FILE.output,' ');
4068: FND_FILE.put_line(FND_FILE.output,' ');
4069: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4070:
4071: -- print warning or error messages Process_Delivery_Lines_Batch
4072: l_msg_count := FND_MSG_PUB.count_msg;

Line 4069: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4065: END IF;
4066:
4067: FND_FILE.put_line(FND_FILE.output,' ');
4068: FND_FILE.put_line(FND_FILE.output,' ');
4069: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4070:
4071: -- print warning or error messages Process_Delivery_Lines_Batch
4072: l_msg_count := FND_MSG_PUB.count_msg;
4073:

Line 4076: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4072: l_msg_count := FND_MSG_PUB.count_msg;
4073:
4074: IF l_msg_count > 0 THEN
4075: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
4076: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4077: FND_FILE.put_line(FND_FILE.output,'====================');
4078: WSH_UTIL_CORE.PrintMsg('List of Messages: ');
4079: WSH_UTIL_CORE.PrintMsg('====================');
4080: FOR i in 1..l_msg_count LOOP

Line 4077: FND_FILE.put_line(FND_FILE.output,'====================');

4073:
4074: IF l_msg_count > 0 THEN
4075: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
4076: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4077: FND_FILE.put_line(FND_FILE.output,'====================');
4078: WSH_UTIL_CORE.PrintMsg('List of Messages: ');
4079: WSH_UTIL_CORE.PrintMsg('====================');
4080: FOR i in 1..l_msg_count LOOP
4081: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE,

Line 4086: FND_FILE.put_line(FND_FILE.output,substrb(l_buffer,1,2000));

4082: p_msg_index => i,
4083: p_data => l_buffer,
4084: p_msg_index_out => l_index_out);
4085: IF l_buffer IS NOT NULL THEN
4086: FND_FILE.put_line(FND_FILE.output,substrb(l_buffer,1,2000));
4087: WSH_UTIL_CORE.PrintMsg(substrb(l_buffer,1,2000));
4088: END IF;
4089: END LOOP;
4090:

Line 4106: FND_FILE.put_line(FND_FILE.output,' ');

4102: -- bug 3319789
4103: IF p_pickup_date_lo is not NULL OR
4104: p_pickup_date_hi is not NULL THEN
4105: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICKUP_DATE_NOT_ALLOWED');
4106: FND_FILE.put_line(FND_FILE.output,' ');
4107: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4108: WSH_UTIL_CORE.PrintMsg('Pick Up Date parameters are not applicable for entity Delivery Lines Only. Please do not enter Pick Up Date range when selecting entity Delivery Lines Only.');
4109: raise Parameters_ERR;
4110: END IF;

Line 4107: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4103: IF p_pickup_date_lo is not NULL OR
4104: p_pickup_date_hi is not NULL THEN
4105: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICKUP_DATE_NOT_ALLOWED');
4106: FND_FILE.put_line(FND_FILE.output,' ');
4107: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4108: WSH_UTIL_CORE.PrintMsg('Pick Up Date parameters are not applicable for entity Delivery Lines Only. Please do not enter Pick Up Date range when selecting entity Delivery Lines Only.');
4109: raise Parameters_ERR;
4110: END IF;
4111:

Line 4116: FND_FILE.put_line(FND_FILE.output,' ');

4112: -- bug 3319789
4113: IF p_dropoff_date_lo is not NULL OR
4114: p_dropoff_date_hi is not NULL THEN
4115: FND_MESSAGE.SET_NAME('WSH', 'WSH_DROPOFF_DATE_NOT_ALLOWED');
4116: FND_FILE.put_line(FND_FILE.output,' ');
4117: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4118: WSH_UTIL_CORE.PrintMsg('Drop Off Date parameters are not applicable for entity Delivery Lines Only. Please do not enter Drop Off Date range when selecting entity Delivery Lines Only.');
4119: raise Parameters_ERR;
4120: END IF;

Line 4117: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4113: IF p_dropoff_date_lo is not NULL OR
4114: p_dropoff_date_hi is not NULL THEN
4115: FND_MESSAGE.SET_NAME('WSH', 'WSH_DROPOFF_DATE_NOT_ALLOWED');
4116: FND_FILE.put_line(FND_FILE.output,' ');
4117: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4118: WSH_UTIL_CORE.PrintMsg('Drop Off Date parameters are not applicable for entity Delivery Lines Only. Please do not enter Drop Off Date range when selecting entity Delivery Lines Only.');
4119: raise Parameters_ERR;
4120: END IF;
4121:

Line 4138: FND_FILE.put_line(FND_FILE.output,' ');

4134: IF l_scheduled_date_hi < l_scheduled_date_lo THEN
4135: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
4136: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4137: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
4138: FND_FILE.put_line(FND_FILE.output,' ');
4139: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4140: WSH_UTIL_CORE.PrintMsg('The end date of Scheduled Ship Date range '||to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS')||' should not precede the start date '|| to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4141: raise Parameters_ERR;
4142: END IF;

Line 4139: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4135: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
4136: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4137: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
4138: FND_FILE.put_line(FND_FILE.output,' ');
4139: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4140: WSH_UTIL_CORE.PrintMsg('The end date of Scheduled Ship Date range '||to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS')||' should not precede the start date '|| to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4141: raise Parameters_ERR;
4142: END IF;
4143: END IF;

Line 4228: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4224: p_lookup_code => l_autocreate_deliveries,
4225: p_lookup_type => 'YES_NO');
4226: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AUTOCREATE_DEL');
4227: FND_MESSAGE.SET_TOKEN('AUTOCREATE_DEL', l_msg_string);
4228: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4229: --Bug10353854
4230: IF ((l_ac_del_criteria is NULL OR l_ac_del_criteria = 'SP') and p_organization_id is not null and l_sp_ac_del_criteria is NOT NULL) THEN
4231: l_ac_del_criteria := l_sp_ac_del_criteria;
4232: END IF;

Line 4242: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4238: p_lookup_code => l_ac_del_criteria,
4239: p_lookup_type => 'WSH_AC_DEL_CRITERIA');
4240: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AC_DEL_CRITERIA');
4241: FND_MESSAGE.SET_TOKEN('AC_DEL_CRITERIA', l_msg_string);
4242: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4243: END IF;
4244:
4245: IF l_append_deliveries is not NULL THEN
4246: l_msg_string := NULL;

Line 4252: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4248: p_lookup_code => l_append_deliveries,
4249: p_lookup_type => 'YES_NO');
4250: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_APPEND_DEL');
4251: FND_MESSAGE.SET_TOKEN('APPEND_DEL', l_msg_string);
4252: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4253: END IF;
4254:
4255: -- populate the selection criteria record and call select_delivery_lines
4256: Select_Delivery_Lines(

Line 4327: FND_FILE.put_line(FND_FILE.output,' ');

4323: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_ERROR');
4324: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4325: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_WARNING');
4326: END IF;
4327: FND_FILE.put_line(FND_FILE.output,' ');
4328: FND_FILE.put_line(FND_FILE.output,' ');
4329: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4330:
4331: -- print warning or error messages Process_Delivery_Lines_Batch

Line 4328: FND_FILE.put_line(FND_FILE.output,' ');

4324: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4325: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_WARNING');
4326: END IF;
4327: FND_FILE.put_line(FND_FILE.output,' ');
4328: FND_FILE.put_line(FND_FILE.output,' ');
4329: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4330:
4331: -- print warning or error messages Process_Delivery_Lines_Batch
4332: l_msg_count := FND_MSG_PUB.count_msg;

Line 4329: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4325: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_WARNING');
4326: END IF;
4327: FND_FILE.put_line(FND_FILE.output,' ');
4328: FND_FILE.put_line(FND_FILE.output,' ');
4329: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4330:
4331: -- print warning or error messages Process_Delivery_Lines_Batch
4332: l_msg_count := FND_MSG_PUB.count_msg;
4333:

Line 4336: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4332: l_msg_count := FND_MSG_PUB.count_msg;
4333:
4334: IF l_msg_count > 0 THEN
4335: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
4336: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4337: FND_FILE.put_line(FND_FILE.output,'====================');
4338:
4339: WSH_UTIL_CORE.PrintMsg('====================');
4340: FOR i in 1..l_msg_count LOOP

Line 4337: FND_FILE.put_line(FND_FILE.output,'====================');

4333:
4334: IF l_msg_count > 0 THEN
4335: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
4336: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4337: FND_FILE.put_line(FND_FILE.output,'====================');
4338:
4339: WSH_UTIL_CORE.PrintMsg('====================');
4340: FOR i in 1..l_msg_count LOOP
4341: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE,

Line 4346: FND_FILE.put_line(FND_FILE.output,substrb(l_buffer,1,2000));

4342: p_msg_index => i,
4343: p_data => l_buffer,
4344: p_msg_index_out => l_index_out);
4345: IF l_buffer IS NOT NULL THEN
4346: FND_FILE.put_line(FND_FILE.output,substrb(l_buffer,1,2000));
4347: WSH_UTIL_CORE.PrintMsg(substrb(l_buffer,1,2000));
4348: END IF;
4349: END LOOP;
4350:

Line 4390: FND_FILE.put_line(FND_FILE.output,' ');

4386: End Loop;
4387:
4388: -- print results of appending deliveries and autocreate deliveries
4389: -- print the summary results of auto create trips action
4390: FND_FILE.put_line(FND_FILE.output,' ');
4391: FND_FILE.put_line(FND_FILE.output,' ');
4392: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4393: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4394: FND_FILE.put_line(FND_FILE.output,'====================');

Line 4391: FND_FILE.put_line(FND_FILE.output,' ');

4387:
4388: -- print results of appending deliveries and autocreate deliveries
4389: -- print the summary results of auto create trips action
4390: FND_FILE.put_line(FND_FILE.output,' ');
4391: FND_FILE.put_line(FND_FILE.output,' ');
4392: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4393: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4394: FND_FILE.put_line(FND_FILE.output,'====================');
4395:

Line 4393: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4389: -- print the summary results of auto create trips action
4390: FND_FILE.put_line(FND_FILE.output,' ');
4391: FND_FILE.put_line(FND_FILE.output,' ');
4392: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4393: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4394: FND_FILE.put_line(FND_FILE.output,'====================');
4395:
4396: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4397: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));

Line 4394: FND_FILE.put_line(FND_FILE.output,'====================');

4390: FND_FILE.put_line(FND_FILE.output,' ');
4391: FND_FILE.put_line(FND_FILE.output,' ');
4392: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4393: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4394: FND_FILE.put_line(FND_FILE.output,'====================');
4395:
4396: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4397: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));
4398: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 4398: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4394: FND_FILE.put_line(FND_FILE.output,'====================');
4395:
4396: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4397: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));
4398: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4399:
4400: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4401: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4402: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 4402: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4398: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4399:
4400: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4401: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4402: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4403:
4404: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4405: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4406: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 4406: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4402: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4403:
4404: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4405: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4406: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4407:
4408: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');
4409: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(g_new_del_num));
4410: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 4410: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4406: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4407:
4408: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');
4409: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(g_new_del_num));
4410: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4411:
4412: WSH_UTIL_CORE.PrintDateTime;
4413: WSH_UTIL_CORE.PrintMsg('Summary: ');
4414: WSH_UTIL_CORE.PrintMsg(to_char(g_selected_det_count)|| ' delivery lines selected for processing');

Line 4423: FND_FILE.put_line(FND_FILE.output,' ');

4419:
4420:
4421: ELSE
4422: -- no delivery lines selected
4423: FND_FILE.put_line(FND_FILE.output,' ');
4424: FND_FILE.put_line(FND_FILE.output,' ');
4425: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4426: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4427: FND_FILE.put_line(FND_FILE.output,'====================');

Line 4424: FND_FILE.put_line(FND_FILE.output,' ');

4420:
4421: ELSE
4422: -- no delivery lines selected
4423: FND_FILE.put_line(FND_FILE.output,' ');
4424: FND_FILE.put_line(FND_FILE.output,' ');
4425: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4426: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4427: FND_FILE.put_line(FND_FILE.output,'====================');
4428:

Line 4426: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4422: -- no delivery lines selected
4423: FND_FILE.put_line(FND_FILE.output,' ');
4424: FND_FILE.put_line(FND_FILE.output,' ');
4425: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4426: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4427: FND_FILE.put_line(FND_FILE.output,'====================');
4428:
4429: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4430: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(l_selected_det_tbl.count));

Line 4427: FND_FILE.put_line(FND_FILE.output,'====================');

4423: FND_FILE.put_line(FND_FILE.output,' ');
4424: FND_FILE.put_line(FND_FILE.output,' ');
4425: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4426: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4427: FND_FILE.put_line(FND_FILE.output,'====================');
4428:
4429: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4430: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(l_selected_det_tbl.count));
4431: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 4431: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

4427: FND_FILE.put_line(FND_FILE.output,'====================');
4428:
4429: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4430: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(l_selected_det_tbl.count));
4431: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4432:
4433: WSH_UTIL_CORE.PrintDateTime;
4434: WSH_UTIL_CORE.PrintMsg('Summary: ');
4435: WSH_UTIL_CORE.PrintMsg(to_char(l_selected_det_tbl.count)|| ' delivery lines selected for processing');