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_VENDOR_PARTY_MERGE_PKG dependencies on FND_MESSAGE

Line 493: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CHG');

489: IF l_debug_on THEN
490: WSH_DEBUG_SV.logmsg(l_module_name, 'Logging SF code change exception');
491: END IF;
492: --
493: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CHG');
494: fnd_message.set_token( 'L_LOCATION_CODE' , g_LocChangeTab(i).old_loc_code);
495: fnd_message.set_token( 'L_NEW_LOCATION_CODE', g_LocChangeTab(i).new_loc_code);
496: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );
497: l_msg := FND_MESSAGE.GET;

Line 494: fnd_message.set_token( 'L_LOCATION_CODE' , g_LocChangeTab(i).old_loc_code);

490: WSH_DEBUG_SV.logmsg(l_module_name, 'Logging SF code change exception');
491: END IF;
492: --
493: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CHG');
494: fnd_message.set_token( 'L_LOCATION_CODE' , g_LocChangeTab(i).old_loc_code);
495: fnd_message.set_token( 'L_NEW_LOCATION_CODE', g_LocChangeTab(i).new_loc_code);
496: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );
497: l_msg := FND_MESSAGE.GET;
498: WSH_UTIL_CORE.printMsg(l_msg);

Line 495: fnd_message.set_token( 'L_NEW_LOCATION_CODE', g_LocChangeTab(i).new_loc_code);

491: END IF;
492: --
493: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CHG');
494: fnd_message.set_token( 'L_LOCATION_CODE' , g_LocChangeTab(i).old_loc_code);
495: fnd_message.set_token( 'L_NEW_LOCATION_CODE', g_LocChangeTab(i).new_loc_code);
496: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );
497: l_msg := FND_MESSAGE.GET;
498: WSH_UTIL_CORE.printMsg(l_msg);
499: --

Line 496: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );

492: --
493: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CHG');
494: fnd_message.set_token( 'L_LOCATION_CODE' , g_LocChangeTab(i).old_loc_code);
495: fnd_message.set_token( 'L_NEW_LOCATION_CODE', g_LocChangeTab(i).new_loc_code);
496: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );
497: l_msg := FND_MESSAGE.GET;
498: WSH_UTIL_CORE.printMsg(l_msg);
499: --
500: IF l_debug_on THEN

Line 497: l_msg := FND_MESSAGE.GET;

493: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CHG');
494: fnd_message.set_token( 'L_LOCATION_CODE' , g_LocChangeTab(i).old_loc_code);
495: fnd_message.set_token( 'L_NEW_LOCATION_CODE', g_LocChangeTab(i).new_loc_code);
496: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );
497: l_msg := FND_MESSAGE.GET;
498: WSH_UTIL_CORE.printMsg(l_msg);
499: --
500: IF l_debug_on THEN
501: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 621: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CONFLICT' );

617: OPEN get_supplier_name ( p_vendor_id => p_to_vendor_id ) ;
618: FETCH get_supplier_name INTO l_supplier_name;
619: CLOSE get_supplier_name;
620: --
621: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CONFLICT' );
622: fnd_message.set_token( 'LOC_CODE', l_location_code );
623: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name );
624: l_msg := FND_MESSAGE.GET;
625: wsh_util_core.printMsg( l_msg );

Line 622: fnd_message.set_token( 'LOC_CODE', l_location_code );

618: FETCH get_supplier_name INTO l_supplier_name;
619: CLOSE get_supplier_name;
620: --
621: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CONFLICT' );
622: fnd_message.set_token( 'LOC_CODE', l_location_code );
623: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name );
624: l_msg := FND_MESSAGE.GET;
625: wsh_util_core.printMsg( l_msg );
626: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 623: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name );

619: CLOSE get_supplier_name;
620: --
621: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CONFLICT' );
622: fnd_message.set_token( 'LOC_CODE', l_location_code );
623: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name );
624: l_msg := FND_MESSAGE.GET;
625: wsh_util_core.printMsg( l_msg );
626: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
627: --

Line 624: l_msg := FND_MESSAGE.GET;

620: --
621: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CONFLICT' );
622: fnd_message.set_token( 'LOC_CODE', l_location_code );
623: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name );
624: l_msg := FND_MESSAGE.GET;
625: wsh_util_core.printMsg( l_msg );
626: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
627: --
628: IF l_debug_on THEN

Line 752: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CHG' );

748: g_LocChangeTab(l_count).new_loc_code := l_new_location_code;
749: --
750: -- Log an exception against delivery, if the SF location changes
751: --
752: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CHG' );
753: fnd_message.set_token( 'L_LOCATION_CODE' , l_location_code );
754: fnd_message.set_token( 'L_NEW_LOCATION_CODE', l_new_location_code );
755: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );
756: l_msg := FND_MESSAGE.GET;

Line 753: fnd_message.set_token( 'L_LOCATION_CODE' , l_location_code );

749: --
750: -- Log an exception against delivery, if the SF location changes
751: --
752: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CHG' );
753: fnd_message.set_token( 'L_LOCATION_CODE' , l_location_code );
754: fnd_message.set_token( 'L_NEW_LOCATION_CODE', l_new_location_code );
755: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );
756: l_msg := FND_MESSAGE.GET;
757: WSH_UTIL_CORE.printMsg(l_msg);

Line 754: fnd_message.set_token( 'L_NEW_LOCATION_CODE', l_new_location_code );

750: -- Log an exception against delivery, if the SF location changes
751: --
752: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CHG' );
753: fnd_message.set_token( 'L_LOCATION_CODE' , l_location_code );
754: fnd_message.set_token( 'L_NEW_LOCATION_CODE', l_new_location_code );
755: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );
756: l_msg := FND_MESSAGE.GET;
757: WSH_UTIL_CORE.printMsg(l_msg);
758: --

Line 755: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );

751: --
752: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CHG' );
753: fnd_message.set_token( 'L_LOCATION_CODE' , l_location_code );
754: fnd_message.set_token( 'L_NEW_LOCATION_CODE', l_new_location_code );
755: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );
756: l_msg := FND_MESSAGE.GET;
757: WSH_UTIL_CORE.printMsg(l_msg);
758: --
759: IF l_debug_on THEN

Line 756: l_msg := FND_MESSAGE.GET;

752: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CHG' );
753: fnd_message.set_token( 'L_LOCATION_CODE' , l_location_code );
754: fnd_message.set_token( 'L_NEW_LOCATION_CODE', l_new_location_code );
755: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );
756: l_msg := FND_MESSAGE.GET;
757: WSH_UTIL_CORE.printMsg(l_msg);
758: --
759: IF l_debug_on THEN
760: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1385: fnd_message.set_name ( 'WSH', 'WSH_IB_DEL_SP_SITE_CAL_ASGN' );

1381: END IF;
1382:
1383: IF check_site_calendar_rec.freight_code IS NULL THEN
1384: --{
1385: fnd_message.set_name ( 'WSH', 'WSH_IB_DEL_SP_SITE_CAL_ASGN' );
1386: ELSE
1387: fnd_message.set_name ( 'WSH', 'WSH_IB_DEL_SP_SITE_FC_CAL_ASGN' );
1388: fnd_message.set_token( 'FREIGHT_CODE' , check_site_calendar_rec.freight_code );
1389: --}

Line 1387: fnd_message.set_name ( 'WSH', 'WSH_IB_DEL_SP_SITE_FC_CAL_ASGN' );

1383: IF check_site_calendar_rec.freight_code IS NULL THEN
1384: --{
1385: fnd_message.set_name ( 'WSH', 'WSH_IB_DEL_SP_SITE_CAL_ASGN' );
1386: ELSE
1387: fnd_message.set_name ( 'WSH', 'WSH_IB_DEL_SP_SITE_FC_CAL_ASGN' );
1388: fnd_message.set_token( 'FREIGHT_CODE' , check_site_calendar_rec.freight_code );
1389: --}
1390: END IF;
1391: fnd_message.set_token( 'SUPPLIER_NAME' , p_from_supplier_name );

Line 1388: fnd_message.set_token( 'FREIGHT_CODE' , check_site_calendar_rec.freight_code );

1384: --{
1385: fnd_message.set_name ( 'WSH', 'WSH_IB_DEL_SP_SITE_CAL_ASGN' );
1386: ELSE
1387: fnd_message.set_name ( 'WSH', 'WSH_IB_DEL_SP_SITE_FC_CAL_ASGN' );
1388: fnd_message.set_token( 'FREIGHT_CODE' , check_site_calendar_rec.freight_code );
1389: --}
1390: END IF;
1391: fnd_message.set_token( 'SUPPLIER_NAME' , p_from_supplier_name );
1392: fnd_message.set_token( 'CAL_TYPE' , check_site_calendar_rec.calendar_type );

Line 1391: fnd_message.set_token( 'SUPPLIER_NAME' , p_from_supplier_name );

1387: fnd_message.set_name ( 'WSH', 'WSH_IB_DEL_SP_SITE_FC_CAL_ASGN' );
1388: fnd_message.set_token( 'FREIGHT_CODE' , check_site_calendar_rec.freight_code );
1389: --}
1390: END IF;
1391: fnd_message.set_token( 'SUPPLIER_NAME' , p_from_supplier_name );
1392: fnd_message.set_token( 'CAL_TYPE' , check_site_calendar_rec.calendar_type );
1393: fnd_message.set_token( 'SITE_CODE' , check_site_calendar_rec.vendor_site_code );
1394: l_msg := FND_MESSAGE.GET;
1395: wsh_util_core.printMsg( l_msg );

Line 1392: fnd_message.set_token( 'CAL_TYPE' , check_site_calendar_rec.calendar_type );

1388: fnd_message.set_token( 'FREIGHT_CODE' , check_site_calendar_rec.freight_code );
1389: --}
1390: END IF;
1391: fnd_message.set_token( 'SUPPLIER_NAME' , p_from_supplier_name );
1392: fnd_message.set_token( 'CAL_TYPE' , check_site_calendar_rec.calendar_type );
1393: fnd_message.set_token( 'SITE_CODE' , check_site_calendar_rec.vendor_site_code );
1394: l_msg := FND_MESSAGE.GET;
1395: wsh_util_core.printMsg( l_msg );
1396: --}

Line 1393: fnd_message.set_token( 'SITE_CODE' , check_site_calendar_rec.vendor_site_code );

1389: --}
1390: END IF;
1391: fnd_message.set_token( 'SUPPLIER_NAME' , p_from_supplier_name );
1392: fnd_message.set_token( 'CAL_TYPE' , check_site_calendar_rec.calendar_type );
1393: fnd_message.set_token( 'SITE_CODE' , check_site_calendar_rec.vendor_site_code );
1394: l_msg := FND_MESSAGE.GET;
1395: wsh_util_core.printMsg( l_msg );
1396: --}
1397: END IF;--IF (check_dup_assignment%NOTFOUND)

Line 1394: l_msg := FND_MESSAGE.GET;

1390: END IF;
1391: fnd_message.set_token( 'SUPPLIER_NAME' , p_from_supplier_name );
1392: fnd_message.set_token( 'CAL_TYPE' , check_site_calendar_rec.calendar_type );
1393: fnd_message.set_token( 'SITE_CODE' , check_site_calendar_rec.vendor_site_code );
1394: l_msg := FND_MESSAGE.GET;
1395: wsh_util_core.printMsg( l_msg );
1396: --}
1397: END IF;--IF (check_dup_assignment%NOTFOUND)
1398:

Line 1758: fnd_message.set_name ( 'WSH', 'WSH_IB_VENDOR_NOT_EXISTS' );

1754: --{
1755: WSH_DEBUG_SV.logmsg(l_module_name,'Error : No Record exists in PO_VENDOR for vendor id : ' || p_from_id, WSH_DEBUG_SV.C_STMT_LEVEL);
1756: --}
1757: END IF;
1758: fnd_message.set_name ( 'WSH', 'WSH_IB_VENDOR_NOT_EXISTS' );
1759: fnd_message.set_token( 'VENDOR_ID' , to_char(p_from_id) );
1760: l_msg := FND_MESSAGE.GET;
1761: wsh_util_core.printMsg( l_msg );
1762: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1759: fnd_message.set_token( 'VENDOR_ID' , to_char(p_from_id) );

1755: WSH_DEBUG_SV.logmsg(l_module_name,'Error : No Record exists in PO_VENDOR for vendor id : ' || p_from_id, WSH_DEBUG_SV.C_STMT_LEVEL);
1756: --}
1757: END IF;
1758: fnd_message.set_name ( 'WSH', 'WSH_IB_VENDOR_NOT_EXISTS' );
1759: fnd_message.set_token( 'VENDOR_ID' , to_char(p_from_id) );
1760: l_msg := FND_MESSAGE.GET;
1761: wsh_util_core.printMsg( l_msg );
1762: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1763: --

Line 1760: l_msg := FND_MESSAGE.GET;

1756: --}
1757: END IF;
1758: fnd_message.set_name ( 'WSH', 'WSH_IB_VENDOR_NOT_EXISTS' );
1759: fnd_message.set_token( 'VENDOR_ID' , to_char(p_from_id) );
1760: l_msg := FND_MESSAGE.GET;
1761: wsh_util_core.printMsg( l_msg );
1762: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1763: --
1764: IF l_debug_on THEN

Line 1883: fnd_message.set_name ( 'WSH', 'WSH_IB_DLY_DET_UPDT_MISMATCH' );

1879: WSH_DEBUG_SV.log(l_module_name, 'Updated WDD records with vendor/vendor site', p_to_id || ' - ' || p_To_site_id);
1880: WSH_DEBUG_SV.logmsg( l_module_name,'Out of ' || l_dd_list.count || ' delivery details, only ' || sql%rowcount || ' were updated.', WSH_DEBUG_SV.C_STMT_LEVEL);
1881: --}
1882: END IF;
1883: fnd_message.set_name ( 'WSH', 'WSH_IB_DLY_DET_UPDT_MISMATCH' );
1884: fnd_message.set_token( 'NUM_DETAILS_AFFECTED' , to_char(l_dd_list.count) );
1885: fnd_message.set_token( 'NUM_DETAILS_UPDATED' , to_char(SQL%ROWCOUNT) );
1886: l_msg := FND_MESSAGE.GET;
1887: wsh_util_core.printMsg( l_msg );

Line 1884: fnd_message.set_token( 'NUM_DETAILS_AFFECTED' , to_char(l_dd_list.count) );

1880: WSH_DEBUG_SV.logmsg( l_module_name,'Out of ' || l_dd_list.count || ' delivery details, only ' || sql%rowcount || ' were updated.', WSH_DEBUG_SV.C_STMT_LEVEL);
1881: --}
1882: END IF;
1883: fnd_message.set_name ( 'WSH', 'WSH_IB_DLY_DET_UPDT_MISMATCH' );
1884: fnd_message.set_token( 'NUM_DETAILS_AFFECTED' , to_char(l_dd_list.count) );
1885: fnd_message.set_token( 'NUM_DETAILS_UPDATED' , to_char(SQL%ROWCOUNT) );
1886: l_msg := FND_MESSAGE.GET;
1887: wsh_util_core.printMsg( l_msg );
1888: --}

Line 1885: fnd_message.set_token( 'NUM_DETAILS_UPDATED' , to_char(SQL%ROWCOUNT) );

1881: --}
1882: END IF;
1883: fnd_message.set_name ( 'WSH', 'WSH_IB_DLY_DET_UPDT_MISMATCH' );
1884: fnd_message.set_token( 'NUM_DETAILS_AFFECTED' , to_char(l_dd_list.count) );
1885: fnd_message.set_token( 'NUM_DETAILS_UPDATED' , to_char(SQL%ROWCOUNT) );
1886: l_msg := FND_MESSAGE.GET;
1887: wsh_util_core.printMsg( l_msg );
1888: --}
1889: END IF;

Line 1886: l_msg := FND_MESSAGE.GET;

1882: END IF;
1883: fnd_message.set_name ( 'WSH', 'WSH_IB_DLY_DET_UPDT_MISMATCH' );
1884: fnd_message.set_token( 'NUM_DETAILS_AFFECTED' , to_char(l_dd_list.count) );
1885: fnd_message.set_token( 'NUM_DETAILS_UPDATED' , to_char(SQL%ROWCOUNT) );
1886: l_msg := FND_MESSAGE.GET;
1887: wsh_util_core.printMsg( l_msg );
1888: --}
1889: END IF;
1890: IF l_debug_on THEN

Line 2264: fnd_message.set_name ( 'WSH', 'WSH_IB_RR_NUMBER_CONFLICT' );

2260: IF l_new_rr_id IS NULL AND l_new_rr_number IS NULL THEN
2261: --{
2262: --
2263: --
2264: fnd_message.set_name ( 'WSH', 'WSH_IB_RR_NUMBER_CONFLICT' );
2265: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name);
2266: l_msg := FND_MESSAGE.GET;
2267: wsh_util_core.printMsg( l_msg );
2268:

Line 2265: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name);

2261: --{
2262: --
2263: --
2264: fnd_message.set_name ( 'WSH', 'WSH_IB_RR_NUMBER_CONFLICT' );
2265: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name);
2266: l_msg := FND_MESSAGE.GET;
2267: wsh_util_core.printMsg( l_msg );
2268:
2269: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2266: l_msg := FND_MESSAGE.GET;

2262: --
2263: --
2264: fnd_message.set_name ( 'WSH', 'WSH_IB_RR_NUMBER_CONFLICT' );
2265: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name);
2266: l_msg := FND_MESSAGE.GET;
2267: wsh_util_core.printMsg( l_msg );
2268:
2269: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2270: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN

Line 2359: fnd_message.set_name ( 'WSH', 'WSH_IB_RR_NUMBER_CHG' );

2355: -- Log an exception against delivery, if the routing req number has changed
2356: --
2357: IF (l_new_rr_number <> l_dlvy_rr_rec.rr_number) THEN
2358: --{
2359: fnd_message.set_name ( 'WSH', 'WSH_IB_RR_NUMBER_CHG' );
2360: fnd_message.set_token('OLD_RR_NUMBER',to_char(l_dlvy_rr_rec.rr_number));
2361: fnd_message.set_token( 'NEW_RR_NUMBER', to_char( l_new_rr_number ) );
2362: fnd_message.set_token( 'DELIVERY_NAME', l_dlvy_rr_rec.name );
2363: l_msg := FND_MESSAGE.GET;

Line 2360: fnd_message.set_token('OLD_RR_NUMBER',to_char(l_dlvy_rr_rec.rr_number));

2356: --
2357: IF (l_new_rr_number <> l_dlvy_rr_rec.rr_number) THEN
2358: --{
2359: fnd_message.set_name ( 'WSH', 'WSH_IB_RR_NUMBER_CHG' );
2360: fnd_message.set_token('OLD_RR_NUMBER',to_char(l_dlvy_rr_rec.rr_number));
2361: fnd_message.set_token( 'NEW_RR_NUMBER', to_char( l_new_rr_number ) );
2362: fnd_message.set_token( 'DELIVERY_NAME', l_dlvy_rr_rec.name );
2363: l_msg := FND_MESSAGE.GET;
2364: --

Line 2361: fnd_message.set_token( 'NEW_RR_NUMBER', to_char( l_new_rr_number ) );

2357: IF (l_new_rr_number <> l_dlvy_rr_rec.rr_number) THEN
2358: --{
2359: fnd_message.set_name ( 'WSH', 'WSH_IB_RR_NUMBER_CHG' );
2360: fnd_message.set_token('OLD_RR_NUMBER',to_char(l_dlvy_rr_rec.rr_number));
2361: fnd_message.set_token( 'NEW_RR_NUMBER', to_char( l_new_rr_number ) );
2362: fnd_message.set_token( 'DELIVERY_NAME', l_dlvy_rr_rec.name );
2363: l_msg := FND_MESSAGE.GET;
2364: --
2365: WSH_UTIL_CORE.printMsg(l_msg);

Line 2362: fnd_message.set_token( 'DELIVERY_NAME', l_dlvy_rr_rec.name );

2358: --{
2359: fnd_message.set_name ( 'WSH', 'WSH_IB_RR_NUMBER_CHG' );
2360: fnd_message.set_token('OLD_RR_NUMBER',to_char(l_dlvy_rr_rec.rr_number));
2361: fnd_message.set_token( 'NEW_RR_NUMBER', to_char( l_new_rr_number ) );
2362: fnd_message.set_token( 'DELIVERY_NAME', l_dlvy_rr_rec.name );
2363: l_msg := FND_MESSAGE.GET;
2364: --
2365: WSH_UTIL_CORE.printMsg(l_msg);
2366: --

Line 2363: l_msg := FND_MESSAGE.GET;

2359: fnd_message.set_name ( 'WSH', 'WSH_IB_RR_NUMBER_CHG' );
2360: fnd_message.set_token('OLD_RR_NUMBER',to_char(l_dlvy_rr_rec.rr_number));
2361: fnd_message.set_token( 'NEW_RR_NUMBER', to_char( l_new_rr_number ) );
2362: fnd_message.set_token( 'DELIVERY_NAME', l_dlvy_rr_rec.name );
2363: l_msg := FND_MESSAGE.GET;
2364: --
2365: WSH_UTIL_CORE.printMsg(l_msg);
2366: --
2367: l_exception_id := NULL;

Line 3832: FND_MESSAGE.Set_Name ('WSH', l_message_name );

3828: END IF;
3829:
3830:
3831: l_message_name := 'WSH_VMRG_UNASSIGN_CONTAINER';
3832: FND_MESSAGE.Set_Name ('WSH', l_message_name );
3833: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
3834: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
3835: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_detail_id(i) );
3836:

Line 3833: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );

3829:
3830:
3831: l_message_name := 'WSH_VMRG_UNASSIGN_CONTAINER';
3832: FND_MESSAGE.Set_Name ('WSH', l_message_name );
3833: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
3834: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
3835: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_detail_id(i) );
3836:
3837: l_message_text := FND_MESSAGE.Get;

Line 3834: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );

3830:
3831: l_message_name := 'WSH_VMRG_UNASSIGN_CONTAINER';
3832: FND_MESSAGE.Set_Name ('WSH', l_message_name );
3833: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
3834: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
3835: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_detail_id(i) );
3836:
3837: l_message_text := FND_MESSAGE.Get;
3838:

Line 3835: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_detail_id(i) );

3831: l_message_name := 'WSH_VMRG_UNASSIGN_CONTAINER';
3832: FND_MESSAGE.Set_Name ('WSH', l_message_name );
3833: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
3834: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
3835: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_detail_id(i) );
3836:
3837: l_message_text := FND_MESSAGE.Get;
3838:
3839: l_return_status := NULL;

Line 3837: l_message_text := FND_MESSAGE.Get;

3833: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
3834: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
3835: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_detail_id(i) );
3836:
3837: l_message_text := FND_MESSAGE.Get;
3838:
3839: l_return_status := NULL;
3840: l_msg_count := NULL;
3841: l_msg_data := NULL;

Line 4038: FND_MESSAGE.Set_Name ('WSH', l_message_name );

4034: END IF;
4035:
4036:
4037: l_message_name := 'WSH_VMRG_UNASSIGN_CONTAINER';
4038: FND_MESSAGE.Set_Name ('WSH', l_message_name );
4039: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
4040: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
4041: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_detail_id(i) );
4042:

Line 4039: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );

4035:
4036:
4037: l_message_name := 'WSH_VMRG_UNASSIGN_CONTAINER';
4038: FND_MESSAGE.Set_Name ('WSH', l_message_name );
4039: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
4040: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
4041: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_detail_id(i) );
4042:
4043: l_message_text := FND_MESSAGE.Get;

Line 4040: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );

4036:
4037: l_message_name := 'WSH_VMRG_UNASSIGN_CONTAINER';
4038: FND_MESSAGE.Set_Name ('WSH', l_message_name );
4039: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
4040: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
4041: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_detail_id(i) );
4042:
4043: l_message_text := FND_MESSAGE.Get;
4044:

Line 4041: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_detail_id(i) );

4037: l_message_name := 'WSH_VMRG_UNASSIGN_CONTAINER';
4038: FND_MESSAGE.Set_Name ('WSH', l_message_name );
4039: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
4040: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
4041: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_detail_id(i) );
4042:
4043: l_message_text := FND_MESSAGE.Get;
4044:
4045: l_return_status := NULL;

Line 4043: l_message_text := FND_MESSAGE.Get;

4039: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
4040: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
4041: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_detail_id(i) );
4042:
4043: l_message_text := FND_MESSAGE.Get;
4044:
4045: l_return_status := NULL;
4046: l_msg_count := NULL;
4047: l_msg_data := NULL;

Line 4084: FND_MESSAGE.Set_Name ('WSH', l_message_name );

4080: IF l_debug_on THEN
4081: WSH_DEBUG_SV.log(l_module_name, 'Logging Exception against the container');
4082: END IF;
4083:
4084: FND_MESSAGE.Set_Name ('WSH', l_message_name );
4085: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
4086: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
4087: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_Detail_Id(i) );
4088:

Line 4085: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );

4081: WSH_DEBUG_SV.log(l_module_name, 'Logging Exception against the container');
4082: END IF;
4083:
4084: FND_MESSAGE.Set_Name ('WSH', l_message_name );
4085: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
4086: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
4087: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_Detail_Id(i) );
4088:
4089: l_message_text := FND_MESSAGE.Get;

Line 4086: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );

4082: END IF;
4083:
4084: FND_MESSAGE.Set_Name ('WSH', l_message_name );
4085: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
4086: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
4087: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_Detail_Id(i) );
4088:
4089: l_message_text := FND_MESSAGE.Get;
4090:

Line 4087: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_Detail_Id(i) );

4083:
4084: FND_MESSAGE.Set_Name ('WSH', l_message_name );
4085: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
4086: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
4087: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_Detail_Id(i) );
4088:
4089: l_message_text := FND_MESSAGE.Get;
4090:
4091: l_return_status := NULL;

Line 4089: l_message_text := FND_MESSAGE.Get;

4085: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
4086: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
4087: FND_MESSAGE.Set_Token ('DELIVERY_DETAIL_ID', l_delivery_Detail_Id(i) );
4088:
4089: l_message_text := FND_MESSAGE.Get;
4090:
4091: l_return_status := NULL;
4092: l_msg_count := NULL;
4093: l_msg_data := NULL;

Line 4293: FND_MESSAGE.Set_Name ('WSH', l_message_name );

4289: -- 'WSH_VMRG_UNASSIGN_STOP' against stop from which delivery
4290: --are un-assigned.
4291: l_message_name := 'WSH_VMRG_UNASSIGN_STOP';
4292: FOR I IN l_wdl_rowid.FIRST..l_wdl_rowid.LAST LOOP
4293: FND_MESSAGE.Set_Name ('WSH', l_message_name );
4294: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
4295: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
4296: FND_MESSAGE.Set_Token ('DELIVERY_ID', l_delivery_id(i) );
4297:

Line 4294: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );

4290: --are un-assigned.
4291: l_message_name := 'WSH_VMRG_UNASSIGN_STOP';
4292: FOR I IN l_wdl_rowid.FIRST..l_wdl_rowid.LAST LOOP
4293: FND_MESSAGE.Set_Name ('WSH', l_message_name );
4294: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
4295: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
4296: FND_MESSAGE.Set_Token ('DELIVERY_ID', l_delivery_id(i) );
4297:
4298: l_message_text := FND_MESSAGE.Get;

Line 4295: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );

4291: l_message_name := 'WSH_VMRG_UNASSIGN_STOP';
4292: FOR I IN l_wdl_rowid.FIRST..l_wdl_rowid.LAST LOOP
4293: FND_MESSAGE.Set_Name ('WSH', l_message_name );
4294: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
4295: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
4296: FND_MESSAGE.Set_Token ('DELIVERY_ID', l_delivery_id(i) );
4297:
4298: l_message_text := FND_MESSAGE.Get;
4299:

Line 4296: FND_MESSAGE.Set_Token ('DELIVERY_ID', l_delivery_id(i) );

4292: FOR I IN l_wdl_rowid.FIRST..l_wdl_rowid.LAST LOOP
4293: FND_MESSAGE.Set_Name ('WSH', l_message_name );
4294: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
4295: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
4296: FND_MESSAGE.Set_Token ('DELIVERY_ID', l_delivery_id(i) );
4297:
4298: l_message_text := FND_MESSAGE.Get;
4299:
4300: l_return_status := NULL;

Line 4298: l_message_text := FND_MESSAGE.Get;

4294: FND_MESSAGE.Set_Token ('PS1', l_from_party_site_use_id );
4295: FND_MESSAGE.Set_Token ('PS2', l_to_party_site_use_id );
4296: FND_MESSAGE.Set_Token ('DELIVERY_ID', l_delivery_id(i) );
4297:
4298: l_message_text := FND_MESSAGE.Get;
4299:
4300: l_return_status := NULL;
4301: l_msg_count := NULL;
4302: l_msg_data := NULL;