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

Line 1011: FND_MESSAGE.SET_NAME('WSH', l_exception_name);

1007: ELSE
1008: l_exception_name := 'WSH_PICK_XDOCK';
1009: END IF;
1010:
1011: FND_MESSAGE.SET_NAME('WSH', l_exception_name);
1012: l_message := FND_MESSAGE.GET;
1013: l_exception_return_status := NULL;
1014: l_exception_msg_count := NULL;
1015: l_exception_msg_data := NULL;

Line 1012: l_message := FND_MESSAGE.GET;

1008: l_exception_name := 'WSH_PICK_XDOCK';
1009: END IF;
1010:
1011: FND_MESSAGE.SET_NAME('WSH', l_exception_name);
1012: l_message := FND_MESSAGE.GET;
1013: l_exception_return_status := NULL;
1014: l_exception_msg_count := NULL;
1015: l_exception_msg_data := NULL;
1016: l_dummy_exception_id := NULL;

Line 1511: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');

1507: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1508: END IF;
1509: l_item_name := WSH_UTIL_CORE.Get_Item_Name(WSH_PR_CRITERIA.release_table(i).inventory_item_id,
1510: WSH_PR_CRITERIA.release_table(i).organization_id);
1511: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
1512: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
1513: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
1514: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
1515: l_message := FND_MESSAGE.GET;

Line 1512: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);

1508: END IF;
1509: l_item_name := WSH_UTIL_CORE.Get_Item_Name(WSH_PR_CRITERIA.release_table(i).inventory_item_id,
1510: WSH_PR_CRITERIA.release_table(i).organization_id);
1511: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
1512: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
1513: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
1514: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
1515: l_message := FND_MESSAGE.GET;
1516: l_exception_return_status := NULL;

Line 1513: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);

1509: l_item_name := WSH_UTIL_CORE.Get_Item_Name(WSH_PR_CRITERIA.release_table(i).inventory_item_id,
1510: WSH_PR_CRITERIA.release_table(i).organization_id);
1511: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
1512: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
1513: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
1514: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
1515: l_message := FND_MESSAGE.GET;
1516: l_exception_return_status := NULL;
1517: l_exception_msg_count := NULL;

Line 1514: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);

1510: WSH_PR_CRITERIA.release_table(i).organization_id);
1511: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
1512: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
1513: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
1514: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
1515: l_message := FND_MESSAGE.GET;
1516: l_exception_return_status := NULL;
1517: l_exception_msg_count := NULL;
1518: l_exception_msg_data := NULL;

Line 1515: l_message := FND_MESSAGE.GET;

1511: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
1512: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
1513: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
1514: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
1515: l_message := FND_MESSAGE.GET;
1516: l_exception_return_status := NULL;
1517: l_exception_msg_count := NULL;
1518: l_exception_msg_data := NULL;
1519: l_dummy_exception_id := NULL;

Line 2901: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');

2897: END IF;
2898: l_item_name := WSH_UTIL_CORE.Get_Item_Name(
2899: WSH_PR_CRITERIA.release_table(i).inventory_item_id,
2900: WSH_PR_CRITERIA.release_table(i).organization_id);
2901: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
2902: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
2903: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
2904: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
2905: l_message := FND_MESSAGE.GET;

Line 2902: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);

2898: l_item_name := WSH_UTIL_CORE.Get_Item_Name(
2899: WSH_PR_CRITERIA.release_table(i).inventory_item_id,
2900: WSH_PR_CRITERIA.release_table(i).organization_id);
2901: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
2902: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
2903: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
2904: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
2905: l_message := FND_MESSAGE.GET;
2906: l_exception_return_status := NULL;

Line 2903: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);

2899: WSH_PR_CRITERIA.release_table(i).inventory_item_id,
2900: WSH_PR_CRITERIA.release_table(i).organization_id);
2901: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
2902: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
2903: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
2904: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
2905: l_message := FND_MESSAGE.GET;
2906: l_exception_return_status := NULL;
2907: l_exception_msg_count := NULL;

Line 2904: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);

2900: WSH_PR_CRITERIA.release_table(i).organization_id);
2901: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
2902: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
2903: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
2904: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
2905: l_message := FND_MESSAGE.GET;
2906: l_exception_return_status := NULL;
2907: l_exception_msg_count := NULL;
2908: l_exception_msg_data := NULL;

Line 2905: l_message := FND_MESSAGE.GET;

2901: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
2902: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
2903: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
2904: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
2905: l_message := FND_MESSAGE.GET;
2906: l_exception_return_status := NULL;
2907: l_exception_msg_count := NULL;
2908: l_exception_msg_data := NULL;
2909: l_dummy_exception_id := NULL;

Line 5079: FND_MESSAGE.SET_NAME('WSH', 'WSH_RATE_CREATE_DEL');

5075: WHILE j is not NULL LOOP
5076: OPEN c_get_location(l_out_param_rec.failed_delivery_id_list(j));
5077: FETCH c_get_location INTO l_excp_location_id;
5078: CLOSE c_get_location;
5079: FND_MESSAGE.SET_NAME('WSH', 'WSH_RATE_CREATE_DEL');
5080: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',to_char(l_out_param_rec.failed_delivery_id_list(j)));
5081: l_message := FND_MESSAGE.Get;
5082: l_dummy_exception_id := NULL;
5083: wsh_xc_util.log_exception(

Line 5080: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',to_char(l_out_param_rec.failed_delivery_id_list(j)));

5076: OPEN c_get_location(l_out_param_rec.failed_delivery_id_list(j));
5077: FETCH c_get_location INTO l_excp_location_id;
5078: CLOSE c_get_location;
5079: FND_MESSAGE.SET_NAME('WSH', 'WSH_RATE_CREATE_DEL');
5080: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',to_char(l_out_param_rec.failed_delivery_id_list(j)));
5081: l_message := FND_MESSAGE.Get;
5082: l_dummy_exception_id := NULL;
5083: wsh_xc_util.log_exception(
5084: p_api_version => 1.0,

Line 5081: l_message := FND_MESSAGE.Get;

5077: FETCH c_get_location INTO l_excp_location_id;
5078: CLOSE c_get_location;
5079: FND_MESSAGE.SET_NAME('WSH', 'WSH_RATE_CREATE_DEL');
5080: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',to_char(l_out_param_rec.failed_delivery_id_list(j)));
5081: l_message := FND_MESSAGE.Get;
5082: l_dummy_exception_id := NULL;
5083: wsh_xc_util.log_exception(
5084: p_api_version => 1.0,
5085: x_return_status => l_return_status,

Line 5494: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');

5490: IF l_debug_on THEN
5491: WSH_DEBUG_SV.logmsg(l_module_name,'Child Request id :' ||l_child_req_ids(j)||' Status :'||l_dev_status);
5492: END IF;
5493:
5494: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
5495: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
5496: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
5497: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
5498: j := l_child_req_ids.NEXT(j);

Line 5495: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));

5491: WSH_DEBUG_SV.logmsg(l_module_name,'Child Request id :' ||l_child_req_ids(j)||' Status :'||l_dev_status);
5492: END IF;
5493:
5494: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
5495: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
5496: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
5497: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
5498: j := l_child_req_ids.NEXT(j);
5499: END LOOP;

Line 5496: FND_MESSAGE.SET_TOKEN('STATUS', l_status);

5492: END IF;
5493:
5494: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
5495: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
5496: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
5497: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
5498: j := l_child_req_ids.NEXT(j);
5499: END LOOP;
5500:

Line 5497: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);

5493:
5494: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
5495: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
5496: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
5497: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
5498: j := l_child_req_ids.NEXT(j);
5499: END LOOP;
5500:
5501: IF ( G_BACKORDERED ) THEN

Line 6150: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');

6146: IF l_debug_on THEN
6147: WSH_DEBUG_SV.logmsg(l_module_name,'Child Request id :' ||l_child_req_ids(j)||' Status :'||l_dev_status);
6148: END IF;
6149:
6150: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
6151: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
6152: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
6153: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
6154: j := l_child_req_ids.NEXT(j);

Line 6151: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));

6147: WSH_DEBUG_SV.logmsg(l_module_name,'Child Request id :' ||l_child_req_ids(j)||' Status :'||l_dev_status);
6148: END IF;
6149:
6150: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
6151: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
6152: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
6153: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
6154: j := l_child_req_ids.NEXT(j);
6155: END LOOP;

Line 6152: FND_MESSAGE.SET_TOKEN('STATUS', l_status);

6148: END IF;
6149:
6150: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
6151: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
6152: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
6153: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
6154: j := l_child_req_ids.NEXT(j);
6155: END LOOP;
6156:

Line 6153: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);

6149:
6150: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
6151: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
6152: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
6153: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
6154: j := l_child_req_ids.NEXT(j);
6155: END LOOP;
6156:
6157: IF ( G_BACKORDERED ) THEN

Line 7296: FND_MESSAGE.SET_NAME('WSH','WSH_PR_NULL_IDS');

7292: END IF;
7293: ELSE
7294: --Non of pick release entity passed.
7295: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7296: FND_MESSAGE.SET_NAME('WSH','WSH_PR_NULL_IDS');
7297: WSH_UTIL_CORE.Add_Message(x_return_status);
7298: IF l_debug_on THEN
7299: WSH_DEBUG_SV.pop(l_module_name);
7300: END IF;

Line 7364: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AUTOPICK_FOR_ORG');

7360:
7361: IF l_pickconfirm_required <> 2 THEN
7362: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_del_org);
7363: -- set warning for org
7364: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AUTOPICK_FOR_ORG');
7365: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7366: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7367: WSH_UTIL_CORE.Add_Message(x_return_status);
7368: l_num_warn := l_num_warn + 1;

Line 7365: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

7361: IF l_pickconfirm_required <> 2 THEN
7362: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_del_org);
7363: -- set warning for org
7364: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AUTOPICK_FOR_ORG');
7365: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7366: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7367: WSH_UTIL_CORE.Add_Message(x_return_status);
7368: l_num_warn := l_num_warn + 1;
7369: END IF;

Line 7378: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SC_RULE_FOR_ORG');

7374:
7375: IF l_ship_confirm_rule_id IS NULL THEN
7376: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_del_org);
7377: -- set warning for org
7378: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SC_RULE_FOR_ORG');
7379: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7380: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7381: WSH_UTIL_CORE.Add_Message(x_return_status);
7382: l_num_warn := l_num_warn + 1;

Line 7379: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

7375: IF l_ship_confirm_rule_id IS NULL THEN
7376: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_del_org);
7377: -- set warning for org
7378: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SC_RULE_FOR_ORG');
7379: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7380: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7381: WSH_UTIL_CORE.Add_Message(x_return_status);
7382: l_num_warn := l_num_warn + 1;
7383: END IF;

Line 7395: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AP_LEVEL_FOR_ORG');

7391:
7392: IF NVL(l_autopack_level,0) = 0 THEN
7393: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_del_org);
7394: -- set warning for org
7395: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AP_LEVEL_FOR_ORG');
7396: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7397: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7398: WSH_UTIL_CORE.Add_Message(x_return_status);
7399: l_num_warn := l_num_warn + 1;

Line 7396: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

7392: IF NVL(l_autopack_level,0) = 0 THEN
7393: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_del_org);
7394: -- set warning for org
7395: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AP_LEVEL_FOR_ORG');
7396: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7397: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7398: WSH_UTIL_CORE.Add_Message(x_return_status);
7399: l_num_warn := l_num_warn + 1;
7400: END IF;

Line 7643: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SC_RULE_FOR_ORG');

7639: EXIT when check_detail_for_SC%NOTFOUND;
7640: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_warn_org);
7641: -- set warning for org
7642: IF l_ship_confirm_rule_id IS NULL THEN
7643: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SC_RULE_FOR_ORG');
7644: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7645: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7646: WSH_UTIL_CORE.Add_Message(x_return_status);
7647: l_num_warn := l_num_warn + 1;

Line 7644: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

7640: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_warn_org);
7641: -- set warning for org
7642: IF l_ship_confirm_rule_id IS NULL THEN
7643: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SC_RULE_FOR_ORG');
7644: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7645: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7646: WSH_UTIL_CORE.Add_Message(x_return_status);
7647: l_num_warn := l_num_warn + 1;
7648: END IF;

Line 7650: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AUTOPICK_FOR_ORG');

7646: WSH_UTIL_CORE.Add_Message(x_return_status);
7647: l_num_warn := l_num_warn + 1;
7648: END IF;
7649: IF NVL(l_pickconfirm_required,0) <> 2 THEN
7650: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AUTOPICK_FOR_ORG');
7651: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7652: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7653: WSH_UTIL_CORE.Add_Message(x_return_status);
7654: l_num_warn := l_num_warn + 1;

Line 7651: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

7647: l_num_warn := l_num_warn + 1;
7648: END IF;
7649: IF NVL(l_pickconfirm_required,0) <> 2 THEN
7650: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AUTOPICK_FOR_ORG');
7651: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7652: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7653: WSH_UTIL_CORE.Add_Message(x_return_status);
7654: l_num_warn := l_num_warn + 1;
7655: END IF;

Line 7660: FND_MESSAGE.SET_NAME('WSH','WSH_NO_DELS_FOR_ORG');

7656: IF NVL(l_autocreate_del_flag, 'N') <> 'Y' THEN
7657: OPEN check_unassigned_dels(l_warn_org, l_batch_id);
7658: FETCH check_unassigned_dels INTO l_assigned;
7659: IF check_unassigned_dels%FOUND THEN
7660: FND_MESSAGE.SET_NAME('WSH','WSH_NO_DELS_FOR_ORG');
7661: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7662: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7663: WSH_UTIL_CORE.Add_Message(x_return_status);
7664: l_num_warn := l_num_warn + 1;

Line 7661: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

7657: OPEN check_unassigned_dels(l_warn_org, l_batch_id);
7658: FETCH check_unassigned_dels INTO l_assigned;
7659: IF check_unassigned_dels%FOUND THEN
7660: FND_MESSAGE.SET_NAME('WSH','WSH_NO_DELS_FOR_ORG');
7661: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7662: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7663: WSH_UTIL_CORE.Add_Message(x_return_status);
7664: l_num_warn := l_num_warn + 1;
7665: END IF;

Line 7680: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AP_LEVEL_FOR_ORG');

7676: FETCH check_detail_for_AP into l_warn_org;
7677: EXIT when check_detail_for_AP%NOTFOUND;
7678: -- set message for org
7679: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_warn_org);
7680: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AP_LEVEL_FOR_ORG');
7681: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7682: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7683: WSH_UTIL_CORE.Add_Message(x_return_status);
7684: l_num_warn := l_num_warn + 1;

Line 7681: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

7677: EXIT when check_detail_for_AP%NOTFOUND;
7678: -- set message for org
7679: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_warn_org);
7680: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AP_LEVEL_FOR_ORG');
7681: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7682: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7683: WSH_UTIL_CORE.Add_Message(x_return_status);
7684: l_num_warn := l_num_warn + 1;
7685: END LOOP;

Line 7704: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_FAILED');

7700: p_num_workers => 1, -- Always 1
7701: p_commit => 'N');
7702: IF (x_request_ids(l_index) = 0) THEN
7703: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7704: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_FAILED');
7705: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);
7706: FND_MESSAGE.SET_TOKEN('NAME',l_name);
7707: WSH_UTIL_CORE.Add_Message(x_return_status);
7708: l_count_fail := l_count_fail + 1;

Line 7705: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);

7701: p_commit => 'N');
7702: IF (x_request_ids(l_index) = 0) THEN
7703: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7704: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_FAILED');
7705: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);
7706: FND_MESSAGE.SET_TOKEN('NAME',l_name);
7707: WSH_UTIL_CORE.Add_Message(x_return_status);
7708: l_count_fail := l_count_fail + 1;
7709: ELSE

Line 7706: FND_MESSAGE.SET_TOKEN('NAME',l_name);

7702: IF (x_request_ids(l_index) = 0) THEN
7703: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7704: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_FAILED');
7705: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);
7706: FND_MESSAGE.SET_TOKEN('NAME',l_name);
7707: WSH_UTIL_CORE.Add_Message(x_return_status);
7708: l_count_fail := l_count_fail + 1;
7709: ELSE
7710: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 7711: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_SUCCESS');

7707: WSH_UTIL_CORE.Add_Message(x_return_status);
7708: l_count_fail := l_count_fail + 1;
7709: ELSE
7710: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7711: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_SUCCESS');
7712: --change for Bug#3379553
7713: -- FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);
7714: -- FND_MESSAGE.SET_TOKEN('NAME',l_name);
7715: --End of change for Bug#3379553

Line 7713: -- FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);

7709: ELSE
7710: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7711: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_SUCCESS');
7712: --change for Bug#3379553
7713: -- FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);
7714: -- FND_MESSAGE.SET_TOKEN('NAME',l_name);
7715: --End of change for Bug#3379553
7716: FND_MESSAGE.SET_TOKEN('REQUEST_ID', to_char(x_request_ids(l_index)));
7717: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 7714: -- FND_MESSAGE.SET_TOKEN('NAME',l_name);

7710: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7711: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_SUCCESS');
7712: --change for Bug#3379553
7713: -- FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);
7714: -- FND_MESSAGE.SET_TOKEN('NAME',l_name);
7715: --End of change for Bug#3379553
7716: FND_MESSAGE.SET_TOKEN('REQUEST_ID', to_char(x_request_ids(l_index)));
7717: WSH_UTIL_CORE.Add_Message(x_return_status);
7718: l_count_succ := l_count_succ + 1;

Line 7716: FND_MESSAGE.SET_TOKEN('REQUEST_ID', to_char(x_request_ids(l_index)));

7712: --change for Bug#3379553
7713: -- FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);
7714: -- FND_MESSAGE.SET_TOKEN('NAME',l_name);
7715: --End of change for Bug#3379553
7716: FND_MESSAGE.SET_TOKEN('REQUEST_ID', to_char(x_request_ids(l_index)));
7717: WSH_UTIL_CORE.Add_Message(x_return_status);
7718: l_count_succ := l_count_succ + 1;
7719: END IF;
7720:

Line 7765: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_SUMMARY');

7761:
7762:
7763:
7764: -- Summary message
7765: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_SUMMARY');
7766: FND_MESSAGE.SET_TOKEN('SUCCESS',to_char(l_count_succ));
7767: FND_MESSAGE.SET_TOKEN('FAIL',to_char(l_count_fail));
7768: WSH_UTIL_CORE.Add_Message(x_return_status);
7769:

Line 7766: FND_MESSAGE.SET_TOKEN('SUCCESS',to_char(l_count_succ));

7762:
7763:
7764: -- Summary message
7765: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_SUMMARY');
7766: FND_MESSAGE.SET_TOKEN('SUCCESS',to_char(l_count_succ));
7767: FND_MESSAGE.SET_TOKEN('FAIL',to_char(l_count_fail));
7768: WSH_UTIL_CORE.Add_Message(x_return_status);
7769:
7770: IF ((l_num_warn > 0) and (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)) THEN

Line 7767: FND_MESSAGE.SET_TOKEN('FAIL',to_char(l_count_fail));

7763:
7764: -- Summary message
7765: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_SUMMARY');
7766: FND_MESSAGE.SET_TOKEN('SUCCESS',to_char(l_count_succ));
7767: FND_MESSAGE.SET_TOKEN('FAIL',to_char(l_count_fail));
7768: WSH_UTIL_CORE.Add_Message(x_return_status);
7769:
7770: IF ((l_num_warn > 0) and (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)) THEN
7771:

Line 7773: FND_MESSAGE.SET_NAME('WSH','WSH_QS_LAUNCH_SUMMARY');

7769:
7770: IF ((l_num_warn > 0) and (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)) THEN
7771:
7772: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7773: FND_MESSAGE.SET_NAME('WSH','WSH_QS_LAUNCH_SUMMARY');
7774: WSH_UTIL_CORE.Add_Message(x_return_status);
7775:
7776: END IF;
7777: --

Line 7800: FND_MESSAGE.SET_NAME('WSH','WSH_PR_INVALID_DETAIL');

7796: END IF;
7797: --
7798:
7799: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7800: FND_MESSAGE.SET_NAME('WSH','WSH_PR_INVALID_DETAIL');
7801: FND_MESSAGE.SET_TOKEN('detail',to_char(l_detail_id));
7802: WSH_UTIL_CORE.Add_Message(x_return_status);
7803: --
7804: -- Debug Statements

Line 7801: FND_MESSAGE.SET_TOKEN('detail',to_char(l_detail_id));

7797: --
7798:
7799: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7800: FND_MESSAGE.SET_NAME('WSH','WSH_PR_INVALID_DETAIL');
7801: FND_MESSAGE.SET_TOKEN('detail',to_char(l_detail_id));
7802: WSH_UTIL_CORE.Add_Message(x_return_status);
7803: --
7804: -- Debug Statements
7805: --

Line 7821: FND_MESSAGE.SET_NAME('WSH','WSH_PR_INVALID_ENTITY');

7817: END IF;
7818: --
7819:
7820: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7821: FND_MESSAGE.SET_NAME('WSH','WSH_PR_INVALID_ENTITY');
7822: FND_MESSAGE.SET_TOKEN('entity_type',lower(l_type));
7823: IF l_type = 'Trip' THEN
7824: l_entity_id := l_trip_id;
7825: ELSIF l_type = 'Stop' THEN

Line 7822: FND_MESSAGE.SET_TOKEN('entity_type',lower(l_type));

7818: --
7819:
7820: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7821: FND_MESSAGE.SET_NAME('WSH','WSH_PR_INVALID_ENTITY');
7822: FND_MESSAGE.SET_TOKEN('entity_type',lower(l_type));
7823: IF l_type = 'Trip' THEN
7824: l_entity_id := l_trip_id;
7825: ELSIF l_type = 'Stop' THEN
7826: l_entity_id := l_stop_id;

Line 7830: FND_MESSAGE.SET_TOKEN('entity_id',l_entity_id);

7826: l_entity_id := l_stop_id;
7827: ELSIF l_type = 'Delivery' THEN
7828: l_entity_id := l_delivery_id;
7829: END IF;
7830: FND_MESSAGE.SET_TOKEN('entity_id',l_entity_id);
7831: WSH_UTIL_CORE.Add_Message(x_return_status);
7832: --
7833: -- Debug Statements
7834: --

Line 8283: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CALENDAR_DATE');

8279: FETCH get_org_code
8280: INTO v_org_code;
8281: CLOSE get_org_code;
8282: v_Date := null;
8283: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CALENDAR_DATE');
8284: FND_MESSAGE.SET_TOKEN('NAME',p_PickRule);
8285: FND_MESSAGE.SET_TOKEN('CALENDAR',p_CalCode);
8286: FND_MESSAGE.SET_TOKEN('WAREHOUSE',v_org_code);
8287: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 8284: FND_MESSAGE.SET_TOKEN('NAME',p_PickRule);

8280: INTO v_org_code;
8281: CLOSE get_org_code;
8282: v_Date := null;
8283: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CALENDAR_DATE');
8284: FND_MESSAGE.SET_TOKEN('NAME',p_PickRule);
8285: FND_MESSAGE.SET_TOKEN('CALENDAR',p_CalCode);
8286: FND_MESSAGE.SET_TOKEN('WAREHOUSE',v_org_code);
8287: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8288: RAISE e_return;

Line 8285: FND_MESSAGE.SET_TOKEN('CALENDAR',p_CalCode);

8281: CLOSE get_org_code;
8282: v_Date := null;
8283: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CALENDAR_DATE');
8284: FND_MESSAGE.SET_TOKEN('NAME',p_PickRule);
8285: FND_MESSAGE.SET_TOKEN('CALENDAR',p_CalCode);
8286: FND_MESSAGE.SET_TOKEN('WAREHOUSE',v_org_code);
8287: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8288: RAISE e_return;
8289: EXIT;

Line 8286: FND_MESSAGE.SET_TOKEN('WAREHOUSE',v_org_code);

8282: v_Date := null;
8283: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CALENDAR_DATE');
8284: FND_MESSAGE.SET_TOKEN('NAME',p_PickRule);
8285: FND_MESSAGE.SET_TOKEN('CALENDAR',p_CalCode);
8286: FND_MESSAGE.SET_TOKEN('WAREHOUSE',v_org_code);
8287: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8288: RAISE e_return;
8289: EXIT;
8290: