DBA Data[Home] [Help]

APPS.WSH_BATCH_PROCESS dependencies on FND_FILE

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

2962: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
2963: p_lookup_code => p_select_criteria.delivery_lines_status,
2964: p_lookup_type => 'WSH_PD_DEL_LINE_STATUS' );
2965: FND_MESSAGE.SET_TOKEN('DETAILS_STATUS', l_msg_string);
2966: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
2967:
2968: WSH_UTIL_CORE.PrintMsg(' Delivery Lines Status: '|| p_select_criteria.delivery_lines_status);
2969: END IF;
2970:

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

2972: IF p_select_criteria.organization_id IS NOT NULL THEN
2973: l_sc_WHERE := l_sc_WHERE ||'AND wdd.organization_id = :x_organization_id ';
2974: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
2975: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_select_criteria.organization_id));
2976: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
2977:
2978: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| p_select_criteria.organization_id);
2979: END IF;
2980:

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

2990:
2991:
2992: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
2993: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
2994: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
2995:
2996: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
2997: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
2998: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);

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

2994: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
2995:
2996: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
2997: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
2998: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
2999:
3000: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3001: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3002:

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

3005: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled >= :x_scheduled_ship_date_lo ';
3006:
3007: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
3008: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3009: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3010: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3011:
3012: ELSE
3013: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);

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

3013: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);
3014: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled <= :x_scheduled_ship_date_hi ';
3015: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3016: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3017: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3018: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3019: END IF;
3020: END IF;
3021:

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

3030:
3031: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3032: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3033:
3034: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3035:
3036: WSH_UTIL_CORE.PrintMsg(' Ship to Location ID: '|| to_char(p_select_criteria.ship_to_loc_id));
3037: END IF;
3038:

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

3049: p_lookup_code => p_select_criteria.source_code,
3050: p_lookup_type => 'WSH_PD_SOURCE_SYSTEM' );
3051: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SOURCE_SYSTEM');
3052: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', l_msg_string);
3053: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3054: WSH_UTIL_CORE.PrintMsg(' Source System: '|| p_select_criteria.source_code);
3055: ELSE
3056: l_sc_WHERE := l_sc_WHERE ||'AND wdd.source_code in (''OE'', ''OKE'') ';
3057: END IF;

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

3068: CLOSE get_customer_name;
3069:
3070: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3071: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3072: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3073:
3074: WSH_UTIL_CORE.PrintMsg(' Customer ID: '|| p_select_criteria.customer_id);
3075: END IF;
3076:

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

3082: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3083: p_lookup_code => p_select_criteria.ship_method_code,
3084: p_lookup_type => 'SHIP_METHOD' );
3085: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_msg_string);
3086: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3087: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_select_criteria.ship_method_code);
3088: END IF;
3089:
3090: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');

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

3088: END IF;
3089:
3090: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
3091: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(p_select_criteria.log_level));
3092: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3093: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| p_select_criteria.log_level);
3094:
3095: l_sc_FINAL := 'SELECT ' ||l_sc_SELECT||' FROM '||l_sc_FROM||' WHERE '||l_sc_WHERE ;
3096:

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

3645: WSH_UTIL_CORE.Set_Log_Level(l_log_level);
3646:
3647:
3648: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PARM');
3649: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3650: FND_FILE.put_line(FND_FILE.output,'====================');
3651:
3652: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PROCESSED_ENTITIES');
3653: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(

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

3646:
3647:
3648: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PARM');
3649: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3650: FND_FILE.put_line(FND_FILE.output,'====================');
3651:
3652: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PROCESSED_ENTITIES');
3653: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3654: p_lookup_code => p_entity_type,

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

3653: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3654: p_lookup_code => p_entity_type,
3655: p_lookup_type => 'WSH_PD_ENTITY' );
3656: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE', l_msg_string);
3657: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3658:
3659:
3660: -- print required input parameters
3661: WSH_UTIL_CORE.PrintMsg('Input Parameters: ' );

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

3663:
3664: IF p_entity_type = 'D' THEN
3665: --
3666: IF WSH_UTIL_CORE.TP_Is_Installed = 'Y' THEN
3667: FND_FILE.put_line(FND_FILE.output, ' ');
3668: FND_FILE.put_line(FND_FILE.output, ' ');
3669: -- print the summary results of auto create trips action
3670: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_TRIP_CONSOLIDATION');
3671: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

3664: IF p_entity_type = 'D' THEN
3665: --
3666: IF WSH_UTIL_CORE.TP_Is_Installed = 'Y' THEN
3667: FND_FILE.put_line(FND_FILE.output, ' ');
3668: FND_FILE.put_line(FND_FILE.output, ' ');
3669: -- print the summary results of auto create trips action
3670: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_TRIP_CONSOLIDATION');
3671: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3672: WSH_UTIL_CORE.PrintMsg('Trip Consolidation is disabled because Transportation Planning is installed. ');

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

3667: FND_FILE.put_line(FND_FILE.output, ' ');
3668: FND_FILE.put_line(FND_FILE.output, ' ');
3669: -- print the summary results of auto create trips action
3670: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_TRIP_CONSOLIDATION');
3671: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3672: WSH_UTIL_CORE.PrintMsg('Trip Consolidation is disabled because Transportation Planning is installed. ');
3673: ELSE
3674: --
3675: l_pickup_date_lo := fnd_date.canonical_to_date(p_pickup_date_lo);

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

3680: -- bug 3319789
3681: IF p_scheduled_ship_date_lo is not NULL OR
3682: p_scheduled_ship_date_hi is not NULL THEN
3683: FND_MESSAGE.SET_NAME('WSH', 'WSH_SCHD_DATE_NOT_ALLOWED');
3684: FND_FILE.put_line(FND_FILE.output,' ');
3685: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3686: 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.');
3687: raise Parameters_ERR;
3688: END IF;

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

3681: IF p_scheduled_ship_date_lo is not NULL OR
3682: p_scheduled_ship_date_hi is not NULL THEN
3683: FND_MESSAGE.SET_NAME('WSH', 'WSH_SCHD_DATE_NOT_ALLOWED');
3684: FND_FILE.put_line(FND_FILE.output,' ');
3685: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3686: 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.');
3687: raise Parameters_ERR;
3688: END IF;
3689:

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

3726: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3727: p_lookup_code => p_deliveries_status,
3728: p_lookup_type => 'WSH_PD_DEL_STATUS' );
3729: FND_MESSAGE.SET_TOKEN('DELIVERIES_STATUS', l_msg_string);
3730: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3731: WSH_UTIL_CORE.PrintMsg(' Deliveries Status: '|| l_deliveries_status);
3732: END IF;
3733:
3734: IF p_pickup_date_lo IS NOT NULL THEN

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

3733:
3734: IF p_pickup_date_lo IS NOT NULL THEN
3735: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_LO');
3736: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3737: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3738: WSH_UTIL_CORE.PrintMsg(' Pick Up Date Start: '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3739: END IF;
3740:
3741: IF p_pickup_date_hi IS NOT NULL THEN

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

3740:
3741: IF p_pickup_date_hi IS NOT NULL THEN
3742: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_HI');
3743: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3744: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3745: WSH_UTIL_CORE.PrintMsg(' Pick Up Date End: '|| to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3746: END IF;
3747:
3748: -- bug 3332670

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

3751: IF l_pickup_date_hi < l_pickup_date_lo THEN
3752: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_RANGE');
3753: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3754: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3755: FND_FILE.put_line(FND_FILE.output,' ');
3756: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3757: 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'));
3758: raise Parameters_ERR;
3759: END IF;

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

3752: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_PICKUP_DATE_RANGE');
3753: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_LO', to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3754: FND_MESSAGE.SET_TOKEN('PICKUP_DATE_HI', to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3755: FND_FILE.put_line(FND_FILE.output,' ');
3756: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3757: 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'));
3758: raise Parameters_ERR;
3759: END IF;
3760: END IF;

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

3761:
3762: IF p_dropoff_date_lo IS NOT NULL THEN
3763: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_LO');
3764: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3765: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3766: WSH_UTIL_CORE.PrintMsg(' Drop Off Date Start: '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3767: END IF;
3768:
3769: IF p_dropoff_date_hi IS NOT NULL THEN

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

3768:
3769: IF p_dropoff_date_hi IS NOT NULL THEN
3770: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_HI');
3771: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3772: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3773: WSH_UTIL_CORE.PrintMsg(' Drop Off Date End: '|| to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3774: END IF;
3775:
3776: -- bug 3332670

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

3779: IF l_dropoff_date_hi < l_dropoff_date_lo THEN
3780: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_RANGE');
3781: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3782: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3783: FND_FILE.put_line(FND_FILE.output,' ');
3784: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3785: 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'));
3786: raise Parameters_ERR;
3787: END IF;

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

3780: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DROPOFF_DATE_RANGE');
3781: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_LO', to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3782: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE_HI', to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3783: FND_FILE.put_line(FND_FILE.output,' ');
3784: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3785: 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'));
3786: raise Parameters_ERR;
3787: END IF;
3788: END IF;

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

3789:
3790: IF p_organization_id IS NOT NULL THEN
3791: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_ORGANIZATION');
3792: FND_MESSAGE.SET_TOKEN('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(p_organization_id));
3793: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3794: WSH_UTIL_CORE.PrintMsg(' Organization ID: '|| to_char(p_organization_id));
3795: END IF;
3796:
3797: IF p_customer_id IS NOT NULL THEN

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

3801: CLOSE get_customer_name;
3802:
3803: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_CUSTOMER');
3804: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_msg_string);
3805: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3806: --bug fix 3286811
3807: WSH_UTIL_CORE.PrintMsg(' Customer ID: '|| (p_customer_id));
3808: END IF;
3809:

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

3814: 1, 80);
3815:
3816: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SHIP_TO');
3817: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_msg_string);
3818: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3819: WSH_UTIL_CORE.PrintMsg(' Ship to Location ID: '|| to_char(p_ship_to_loc_id));
3820: END IF;
3821:
3822: IF p_ship_method_code IS NOT NULL THEN

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

3826: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3827: p_lookup_code => p_ship_method_code,
3828: p_lookup_type => 'SHIP_METHOD' );
3829: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_msg_string);
3830: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3831: WSH_UTIL_CORE.PrintMsg(' Ship Method Code: '|| p_ship_method_code);
3832: END IF;
3833:
3834: IF l_grp_ship_method IS NOT NULL THEN

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

3837: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3838: p_lookup_code => l_grp_ship_method,
3839: p_lookup_type => 'YES_NO' );
3840: FND_MESSAGE.SET_TOKEN('GRP_SHIP_METHOD', l_msg_string);
3841: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3842: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship Method: '|| l_grp_ship_method);
3843: END IF;
3844:
3845: IF l_grp_ship_from IS NOT NULL THEN

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

3848: l_msg_string := WSH_XC_UTIL.Get_Lookup_Meaning(
3849: p_lookup_code => l_grp_ship_from,
3850: p_lookup_type => 'YES_NO' );
3851: FND_MESSAGE.SET_TOKEN('GRP_SHIP_FROM', l_msg_string);
3852: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3853: WSH_UTIL_CORE.PrintMsg(' Group Deliveries by Ship from Organization: '|| l_grp_ship_from);
3854: END IF;
3855:
3856: IF l_max_del_number IS NOT NULL THEN

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

3855:
3856: IF l_max_del_number IS NOT NULL THEN
3857: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MAX_DEL_NUMBER');
3858: FND_MESSAGE.SET_TOKEN('MAX_DEL_NUMBER', to_char(l_max_del_number));
3859: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3860: WSH_UTIL_CORE.PrintMsg(' Maximum Number of Deliveries per Trip: '|| to_char(l_max_del_number));
3861: END IF;
3862:
3863: IF l_log_level IS NOT NULL THEN

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

3862:
3863: IF l_log_level IS NOT NULL THEN
3864: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_LOG_LEVEL');
3865: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(l_log_level));
3866: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3867: WSH_UTIL_CORE.PrintMsg(' Log Level: '|| l_log_level );
3868: END IF;
3869:
3870: IF l_debug_on THEN

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

3890: x_Trips => l_trip_num,
3891: x_return_status => l_return_status);
3892:
3893: -- print the summary results of auto create trips action
3894: FND_FILE.put_line(FND_FILE.output,' ');
3895: FND_FILE.put_line(FND_FILE.output,' ');
3896: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3898: FND_FILE.put_line(FND_FILE.output,'====================');

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

3891: x_return_status => l_return_status);
3892:
3893: -- print the summary results of auto create trips action
3894: FND_FILE.put_line(FND_FILE.output,' ');
3895: FND_FILE.put_line(FND_FILE.output,' ');
3896: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3898: FND_FILE.put_line(FND_FILE.output,'====================');
3899:

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

3893: -- print the summary results of auto create trips action
3894: FND_FILE.put_line(FND_FILE.output,' ');
3895: FND_FILE.put_line(FND_FILE.output,' ');
3896: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3898: FND_FILE.put_line(FND_FILE.output,'====================');
3899:
3900: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
3901: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));

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

3894: FND_FILE.put_line(FND_FILE.output,' ');
3895: FND_FILE.put_line(FND_FILE.output,' ');
3896: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
3897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3898: FND_FILE.put_line(FND_FILE.output,'====================');
3899:
3900: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
3901: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));
3902: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

3898: FND_FILE.put_line(FND_FILE.output,'====================');
3899:
3900: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_SELECTED');
3901: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_num));
3902: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3903:
3904: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
3905: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
3906: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

3902: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3903:
3904: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_GROUPED');
3905: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(l_del_grouped_num));
3906: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3907:
3908: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');
3909: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRIPS', to_char(l_trip_num));
3910: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

3906: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3907:
3908: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_TRIPS_CREATED');
3909: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRIPS', to_char(l_trip_num));
3910: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3911:
3912: WSH_UTIL_CORE.PrintDateTime;
3913: WSH_UTIL_CORE.PrintMsg('Summary: ');
3914: WSH_UTIL_CORE.PrintMsg(to_char(l_del_num)|| ' deliveries selected for processing');

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

3926: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3927: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_WARNING');
3928: END IF;
3929:
3930: FND_FILE.put_line(FND_FILE.output,' ');
3931: FND_FILE.put_line(FND_FILE.output,' ');
3932: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3933:
3934: -- print warning or error messages Process_Delivery_Lines_Batch

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

3927: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_WARNING');
3928: END IF;
3929:
3930: FND_FILE.put_line(FND_FILE.output,' ');
3931: FND_FILE.put_line(FND_FILE.output,' ');
3932: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3933:
3934: -- print warning or error messages Process_Delivery_Lines_Batch
3935: l_msg_count := FND_MSG_PUB.count_msg;

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

3928: END IF;
3929:
3930: FND_FILE.put_line(FND_FILE.output,' ');
3931: FND_FILE.put_line(FND_FILE.output,' ');
3932: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3933:
3934: -- print warning or error messages Process_Delivery_Lines_Batch
3935: l_msg_count := FND_MSG_PUB.count_msg;
3936:

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

3935: l_msg_count := FND_MSG_PUB.count_msg;
3936:
3937: IF l_msg_count > 0 THEN
3938: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
3939: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3940: FND_FILE.put_line(FND_FILE.output,'====================');
3941: WSH_UTIL_CORE.PrintMsg('List of Messages: ');
3942: WSH_UTIL_CORE.PrintMsg('====================');
3943: FOR i in 1..l_msg_count LOOP

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

3936:
3937: IF l_msg_count > 0 THEN
3938: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
3939: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3940: FND_FILE.put_line(FND_FILE.output,'====================');
3941: WSH_UTIL_CORE.PrintMsg('List of Messages: ');
3942: WSH_UTIL_CORE.PrintMsg('====================');
3943: FOR i in 1..l_msg_count LOOP
3944: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE,

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

3945: p_msg_index => i,
3946: p_data => l_buffer,
3947: p_msg_index_out => l_index_out);
3948: IF l_buffer IS NOT NULL THEN
3949: FND_FILE.put_line(FND_FILE.output,substrb(l_buffer,1,2000));
3950: WSH_UTIL_CORE.PrintMsg(substrb(l_buffer,1,2000));
3951: END IF;
3952: END LOOP;
3953:

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

3965: -- bug 3319789
3966: IF p_pickup_date_lo is not NULL OR
3967: p_pickup_date_hi is not NULL THEN
3968: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICKUP_DATE_NOT_ALLOWED');
3969: FND_FILE.put_line(FND_FILE.output,' ');
3970: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3971: 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.');
3972: raise Parameters_ERR;
3973: END IF;

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

3966: IF p_pickup_date_lo is not NULL OR
3967: p_pickup_date_hi is not NULL THEN
3968: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICKUP_DATE_NOT_ALLOWED');
3969: FND_FILE.put_line(FND_FILE.output,' ');
3970: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3971: 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.');
3972: raise Parameters_ERR;
3973: END IF;
3974:

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

3975: -- bug 3319789
3976: IF p_dropoff_date_lo is not NULL OR
3977: p_dropoff_date_hi is not NULL THEN
3978: FND_MESSAGE.SET_NAME('WSH', 'WSH_DROPOFF_DATE_NOT_ALLOWED');
3979: FND_FILE.put_line(FND_FILE.output,' ');
3980: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3981: 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.');
3982: raise Parameters_ERR;
3983: END IF;

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

3976: IF p_dropoff_date_lo is not NULL OR
3977: p_dropoff_date_hi is not NULL THEN
3978: FND_MESSAGE.SET_NAME('WSH', 'WSH_DROPOFF_DATE_NOT_ALLOWED');
3979: FND_FILE.put_line(FND_FILE.output,' ');
3980: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3981: 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.');
3982: raise Parameters_ERR;
3983: END IF;
3984:

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

3997: IF l_scheduled_date_hi < l_scheduled_date_lo THEN
3998: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
3999: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4000: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
4001: FND_FILE.put_line(FND_FILE.output,' ');
4002: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4003: 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'));
4004: raise Parameters_ERR;
4005: END IF;

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

3998: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
3999: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4000: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
4001: FND_FILE.put_line(FND_FILE.output,' ');
4002: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4003: 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'));
4004: raise Parameters_ERR;
4005: END IF;
4006: END IF;

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

4086: p_lookup_code => l_autocreate_deliveries,
4087: p_lookup_type => 'YES_NO');
4088: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AUTOCREATE_DEL');
4089: FND_MESSAGE.SET_TOKEN('AUTOCREATE_DEL', l_msg_string);
4090: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4091: END IF;
4092:
4093: IF l_ac_del_criteria is not NULL THEN
4094: l_msg_string := NULL;

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

4096: p_lookup_code => l_ac_del_criteria,
4097: p_lookup_type => 'WSH_AC_DEL_CRITERIA');
4098: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_AC_DEL_CRITERIA');
4099: FND_MESSAGE.SET_TOKEN('AC_DEL_CRITERIA', l_msg_string);
4100: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4101: END IF;
4102:
4103: IF l_append_deliveries is not NULL THEN
4104: l_msg_string := NULL;

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

4106: p_lookup_code => l_append_deliveries,
4107: p_lookup_type => 'YES_NO');
4108: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_APPEND_DEL');
4109: FND_MESSAGE.SET_TOKEN('APPEND_DEL', l_msg_string);
4110: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4111: END IF;
4112:
4113: -- populate the selection criteria record and call select_delivery_lines
4114: Select_Delivery_Lines(

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

4170: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_ERROR');
4171: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4172: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_WARNING');
4173: END IF;
4174: FND_FILE.put_line(FND_FILE.output,' ');
4175: FND_FILE.put_line(FND_FILE.output,' ');
4176: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4177:
4178: -- print warning or error messages Process_Delivery_Lines_Batch

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

4171: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4172: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_WARNING');
4173: END IF;
4174: FND_FILE.put_line(FND_FILE.output,' ');
4175: FND_FILE.put_line(FND_FILE.output,' ');
4176: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4177:
4178: -- print warning or error messages Process_Delivery_Lines_Batch
4179: l_msg_count := FND_MSG_PUB.count_msg;

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

4172: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DEL_DET_WARNING');
4173: END IF;
4174: FND_FILE.put_line(FND_FILE.output,' ');
4175: FND_FILE.put_line(FND_FILE.output,' ');
4176: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4177:
4178: -- print warning or error messages Process_Delivery_Lines_Batch
4179: l_msg_count := FND_MSG_PUB.count_msg;
4180:

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

4179: l_msg_count := FND_MSG_PUB.count_msg;
4180:
4181: IF l_msg_count > 0 THEN
4182: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
4183: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4184: FND_FILE.put_line(FND_FILE.output,'====================');
4185:
4186: WSH_UTIL_CORE.PrintMsg('====================');
4187: FOR i in 1..l_msg_count LOOP

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

4180:
4181: IF l_msg_count > 0 THEN
4182: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_MESSAGE_LIST');
4183: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4184: FND_FILE.put_line(FND_FILE.output,'====================');
4185:
4186: WSH_UTIL_CORE.PrintMsg('====================');
4187: FOR i in 1..l_msg_count LOOP
4188: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE,

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

4189: p_msg_index => i,
4190: p_data => l_buffer,
4191: p_msg_index_out => l_index_out);
4192: IF l_buffer IS NOT NULL THEN
4193: FND_FILE.put_line(FND_FILE.output,substrb(l_buffer,1,2000));
4194: WSH_UTIL_CORE.PrintMsg(substrb(l_buffer,1,2000));
4195: END IF;
4196: END LOOP;
4197:

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

4233: End Loop;
4234:
4235: -- print results of appending deliveries and autocreate deliveries
4236: -- print the summary results of auto create trips action
4237: FND_FILE.put_line(FND_FILE.output,' ');
4238: FND_FILE.put_line(FND_FILE.output,' ');
4239: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4240: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4241: FND_FILE.put_line(FND_FILE.output,'====================');

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

4234:
4235: -- print results of appending deliveries and autocreate deliveries
4236: -- print the summary results of auto create trips action
4237: FND_FILE.put_line(FND_FILE.output,' ');
4238: FND_FILE.put_line(FND_FILE.output,' ');
4239: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4240: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4241: FND_FILE.put_line(FND_FILE.output,'====================');
4242:

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

4236: -- print the summary results of auto create trips action
4237: FND_FILE.put_line(FND_FILE.output,' ');
4238: FND_FILE.put_line(FND_FILE.output,' ');
4239: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4240: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4241: FND_FILE.put_line(FND_FILE.output,'====================');
4242:
4243: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4244: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));

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

4237: FND_FILE.put_line(FND_FILE.output,' ');
4238: FND_FILE.put_line(FND_FILE.output,' ');
4239: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4240: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4241: FND_FILE.put_line(FND_FILE.output,'====================');
4242:
4243: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4244: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));
4245: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

4241: FND_FILE.put_line(FND_FILE.output,'====================');
4242:
4243: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4244: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_selected_det_count));
4245: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4246:
4247: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4248: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4249: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

4245: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4246:
4247: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_APPENDED');
4248: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_appended_det_num));
4249: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4250:
4251: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4252: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4253: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

4249: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4250:
4251: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_GROUPED');
4252: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(g_autocreate_del_det_num));
4253: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4254:
4255: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');
4256: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(g_new_del_num));
4257: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

4253: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4254:
4255: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DELIVERIES_CREATED');
4256: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DELIVERIES', to_char(g_new_del_num));
4257: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4258:
4259: WSH_UTIL_CORE.PrintDateTime;
4260: WSH_UTIL_CORE.PrintMsg('Summary: ');
4261: WSH_UTIL_CORE.PrintMsg(to_char(g_selected_det_count)|| ' delivery lines selected for processing');

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

4266:
4267:
4268: ELSE
4269: -- no delivery lines selected
4270: FND_FILE.put_line(FND_FILE.output,' ');
4271: FND_FILE.put_line(FND_FILE.output,' ');
4272: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4273: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4274: FND_FILE.put_line(FND_FILE.output,'====================');

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

4267:
4268: ELSE
4269: -- no delivery lines selected
4270: FND_FILE.put_line(FND_FILE.output,' ');
4271: FND_FILE.put_line(FND_FILE.output,' ');
4272: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4273: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4274: FND_FILE.put_line(FND_FILE.output,'====================');
4275:

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

4269: -- no delivery lines selected
4270: FND_FILE.put_line(FND_FILE.output,' ');
4271: FND_FILE.put_line(FND_FILE.output,' ');
4272: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4273: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4274: FND_FILE.put_line(FND_FILE.output,'====================');
4275:
4276: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4277: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(l_selected_det_tbl.count));

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

4270: FND_FILE.put_line(FND_FILE.output,' ');
4271: FND_FILE.put_line(FND_FILE.output,' ');
4272: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SUMMARY');
4273: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4274: FND_FILE.put_line(FND_FILE.output,'====================');
4275:
4276: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4277: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(l_selected_det_tbl.count));
4278: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

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

4274: FND_FILE.put_line(FND_FILE.output,'====================');
4275:
4276: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_DETAILS_SELECTED');
4277: FND_MESSAGE.SET_TOKEN('NUMBER_OF_DETAILS', to_char(l_selected_det_tbl.count));
4278: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
4279:
4280: WSH_UTIL_CORE.PrintDateTime;
4281: WSH_UTIL_CORE.PrintMsg('Summary: ');
4282: WSH_UTIL_CORE.PrintMsg(to_char(l_selected_det_tbl.count)|| ' delivery lines selected for processing');