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 1031: FND_MESSAGE.SET_NAME('WSH', l_exception_name);

1027: ELSE
1028: l_exception_name := 'WSH_PICK_XDOCK';
1029: END IF;
1030:
1031: FND_MESSAGE.SET_NAME('WSH', l_exception_name);
1032: l_message := FND_MESSAGE.GET;
1033: l_exception_return_status := NULL;
1034: l_exception_msg_count := NULL;
1035: l_exception_msg_data := NULL;

Line 1032: l_message := FND_MESSAGE.GET;

1028: l_exception_name := 'WSH_PICK_XDOCK';
1029: END IF;
1030:
1031: FND_MESSAGE.SET_NAME('WSH', l_exception_name);
1032: l_message := FND_MESSAGE.GET;
1033: l_exception_return_status := NULL;
1034: l_exception_msg_count := NULL;
1035: l_exception_msg_data := NULL;
1036: l_dummy_exception_id := NULL;

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

1568: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1569: END IF;
1570: l_item_name := WSH_UTIL_CORE.Get_Item_Name(WSH_PR_CRITERIA.release_table(i).inventory_item_id,
1571: WSH_PR_CRITERIA.release_table(i).organization_id);
1572: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
1573: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
1574: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
1575: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
1576: l_message := FND_MESSAGE.GET;

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

1569: END IF;
1570: l_item_name := WSH_UTIL_CORE.Get_Item_Name(WSH_PR_CRITERIA.release_table(i).inventory_item_id,
1571: WSH_PR_CRITERIA.release_table(i).organization_id);
1572: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
1573: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
1574: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
1575: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
1576: l_message := FND_MESSAGE.GET;
1577: l_exception_return_status := NULL;

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

1570: l_item_name := WSH_UTIL_CORE.Get_Item_Name(WSH_PR_CRITERIA.release_table(i).inventory_item_id,
1571: WSH_PR_CRITERIA.release_table(i).organization_id);
1572: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
1573: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
1574: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
1575: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
1576: l_message := FND_MESSAGE.GET;
1577: l_exception_return_status := NULL;
1578: l_exception_msg_count := NULL;

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

1571: WSH_PR_CRITERIA.release_table(i).organization_id);
1572: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
1573: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
1574: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
1575: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
1576: l_message := FND_MESSAGE.GET;
1577: l_exception_return_status := NULL;
1578: l_exception_msg_count := NULL;
1579: l_exception_msg_data := NULL;

Line 1576: l_message := FND_MESSAGE.GET;

1572: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
1573: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
1574: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
1575: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
1576: l_message := FND_MESSAGE.GET;
1577: l_exception_return_status := NULL;
1578: l_exception_msg_count := NULL;
1579: l_exception_msg_data := NULL;
1580: l_dummy_exception_id := NULL;

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

2971: END IF;
2972: l_item_name := WSH_UTIL_CORE.Get_Item_Name(
2973: WSH_PR_CRITERIA.release_table(i).inventory_item_id,
2974: WSH_PR_CRITERIA.release_table(i).organization_id);
2975: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
2976: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
2977: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
2978: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
2979: l_message := FND_MESSAGE.GET;

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

2972: l_item_name := WSH_UTIL_CORE.Get_Item_Name(
2973: WSH_PR_CRITERIA.release_table(i).inventory_item_id,
2974: WSH_PR_CRITERIA.release_table(i).organization_id);
2975: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
2976: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
2977: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
2978: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
2979: l_message := FND_MESSAGE.GET;
2980: l_exception_return_status := NULL;

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

2973: WSH_PR_CRITERIA.release_table(i).inventory_item_id,
2974: WSH_PR_CRITERIA.release_table(i).organization_id);
2975: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
2976: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
2977: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
2978: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
2979: l_message := FND_MESSAGE.GET;
2980: l_exception_return_status := NULL;
2981: l_exception_msg_count := NULL;

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

2974: WSH_PR_CRITERIA.release_table(i).organization_id);
2975: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
2976: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
2977: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
2978: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
2979: l_message := FND_MESSAGE.GET;
2980: l_exception_return_status := NULL;
2981: l_exception_msg_count := NULL;
2982: l_exception_msg_data := NULL;

Line 2979: l_message := FND_MESSAGE.GET;

2975: FND_MESSAGE.SET_NAME('WSH','WSH_INV_EXPECTED_ERROR');
2976: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
2977: FND_MESSAGE.SET_TOKEN('ORDER',WSH_PR_CRITERIA.release_table(i).source_header_number);
2978: FND_MESSAGE.SET_TOKEN('INVMESSAGE',l_message1);
2979: l_message := FND_MESSAGE.GET;
2980: l_exception_return_status := NULL;
2981: l_exception_msg_count := NULL;
2982: l_exception_msg_data := NULL;
2983: l_dummy_exception_id := NULL;

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

5177: WHILE j is not NULL LOOP
5178: OPEN c_get_location(l_out_param_rec.failed_delivery_id_list(j));
5179: FETCH c_get_location INTO l_excp_location_id;
5180: CLOSE c_get_location;
5181: FND_MESSAGE.SET_NAME('WSH', 'WSH_RATE_CREATE_DEL');
5182: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',to_char(l_out_param_rec.failed_delivery_id_list(j)));
5183: l_message := FND_MESSAGE.Get;
5184: l_dummy_exception_id := NULL;
5185: wsh_xc_util.log_exception(

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

5178: OPEN c_get_location(l_out_param_rec.failed_delivery_id_list(j));
5179: FETCH c_get_location INTO l_excp_location_id;
5180: CLOSE c_get_location;
5181: FND_MESSAGE.SET_NAME('WSH', 'WSH_RATE_CREATE_DEL');
5182: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',to_char(l_out_param_rec.failed_delivery_id_list(j)));
5183: l_message := FND_MESSAGE.Get;
5184: l_dummy_exception_id := NULL;
5185: wsh_xc_util.log_exception(
5186: p_api_version => 1.0,

Line 5183: l_message := FND_MESSAGE.Get;

5179: FETCH c_get_location INTO l_excp_location_id;
5180: CLOSE c_get_location;
5181: FND_MESSAGE.SET_NAME('WSH', 'WSH_RATE_CREATE_DEL');
5182: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',to_char(l_out_param_rec.failed_delivery_id_list(j)));
5183: l_message := FND_MESSAGE.Get;
5184: l_dummy_exception_id := NULL;
5185: wsh_xc_util.log_exception(
5186: p_api_version => 1.0,
5187: x_return_status => l_return_status,

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

5624: IF l_debug_on THEN
5625: WSH_DEBUG_SV.logmsg(l_module_name,'Child Request id :' ||l_child_req_ids(j)||' Status :'||l_dev_status);
5626: END IF;
5627:
5628: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
5629: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
5630: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
5631: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
5632: j := l_child_req_ids.NEXT(j);

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

5625: WSH_DEBUG_SV.logmsg(l_module_name,'Child Request id :' ||l_child_req_ids(j)||' Status :'||l_dev_status);
5626: END IF;
5627:
5628: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
5629: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
5630: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
5631: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
5632: j := l_child_req_ids.NEXT(j);
5633: END LOOP;

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

5626: END IF;
5627:
5628: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
5629: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
5630: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
5631: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
5632: j := l_child_req_ids.NEXT(j);
5633: END LOOP;
5634:

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

5627:
5628: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
5629: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
5630: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
5631: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
5632: j := l_child_req_ids.NEXT(j);
5633: END LOOP;
5634:
5635: IF ( G_BACKORDERED ) THEN

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

6281: IF l_debug_on THEN
6282: WSH_DEBUG_SV.logmsg(l_module_name,'Child Request id :' ||l_child_req_ids(j)||' Status :'||l_dev_status);
6283: END IF;
6284:
6285: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
6286: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
6287: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
6288: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
6289: j := l_child_req_ids.NEXT(j);

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

6282: WSH_DEBUG_SV.logmsg(l_module_name,'Child Request id :' ||l_child_req_ids(j)||' Status :'||l_dev_status);
6283: END IF;
6284:
6285: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
6286: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
6287: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
6288: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
6289: j := l_child_req_ids.NEXT(j);
6290: END LOOP;

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

6283: END IF;
6284:
6285: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
6286: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
6287: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
6288: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
6289: j := l_child_req_ids.NEXT(j);
6290: END LOOP;
6291:

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

6284:
6285: FND_MESSAGE.SET_NAME('WSH','WSH_CHILD_REQ_STATUS');
6286: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_child_req_ids(j)));
6287: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
6288: WSH_UTIL_CORE.PrintMsg(FND_MESSAGE.GET);
6289: j := l_child_req_ids.NEXT(j);
6290: END LOOP;
6291:
6292: IF ( G_BACKORDERED ) THEN

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

7435: END IF;
7436: ELSE
7437: --Non of pick release entity passed.
7438: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7439: FND_MESSAGE.SET_NAME('WSH','WSH_PR_NULL_IDS');
7440: WSH_UTIL_CORE.Add_Message(x_return_status);
7441: IF l_debug_on THEN
7442: WSH_DEBUG_SV.pop(l_module_name);
7443: END IF;

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

7503:
7504: IF l_pickconfirm_required <> 2 THEN
7505: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_del_org);
7506: -- set warning for org
7507: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AUTOPICK_FOR_ORG');
7508: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7509: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7510: WSH_UTIL_CORE.Add_Message(x_return_status);
7511: l_num_warn := l_num_warn + 1;

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

7504: IF l_pickconfirm_required <> 2 THEN
7505: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_del_org);
7506: -- set warning for org
7507: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AUTOPICK_FOR_ORG');
7508: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7509: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7510: WSH_UTIL_CORE.Add_Message(x_return_status);
7511: l_num_warn := l_num_warn + 1;
7512: END IF;

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

7517:
7518: IF l_ship_confirm_rule_id IS NULL THEN
7519: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_del_org);
7520: -- set warning for org
7521: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SC_RULE_FOR_ORG');
7522: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7523: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7524: WSH_UTIL_CORE.Add_Message(x_return_status);
7525: l_num_warn := l_num_warn + 1;

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

7518: IF l_ship_confirm_rule_id IS NULL THEN
7519: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_del_org);
7520: -- set warning for org
7521: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SC_RULE_FOR_ORG');
7522: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7523: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7524: WSH_UTIL_CORE.Add_Message(x_return_status);
7525: l_num_warn := l_num_warn + 1;
7526: END IF;

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

7534:
7535: IF NVL(l_autopack_level,0) = 0 THEN
7536: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_del_org);
7537: -- set warning for org
7538: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AP_LEVEL_FOR_ORG');
7539: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7540: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7541: WSH_UTIL_CORE.Add_Message(x_return_status);
7542: l_num_warn := l_num_warn + 1;

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

7535: IF NVL(l_autopack_level,0) = 0 THEN
7536: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_del_org);
7537: -- set warning for org
7538: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AP_LEVEL_FOR_ORG');
7539: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7540: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7541: WSH_UTIL_CORE.Add_Message(x_return_status);
7542: l_num_warn := l_num_warn + 1;
7543: END IF;

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

7785: EXIT when check_detail_for_SC%NOTFOUND;
7786: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_warn_org);
7787: -- set warning for org
7788: IF l_ship_confirm_rule_id IS NULL THEN
7789: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SC_RULE_FOR_ORG');
7790: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7791: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7792: WSH_UTIL_CORE.Add_Message(x_return_status);
7793: l_num_warn := l_num_warn + 1;

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

7786: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_warn_org);
7787: -- set warning for org
7788: IF l_ship_confirm_rule_id IS NULL THEN
7789: FND_MESSAGE.SET_NAME('WSH','WSH_NO_SC_RULE_FOR_ORG');
7790: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7791: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7792: WSH_UTIL_CORE.Add_Message(x_return_status);
7793: l_num_warn := l_num_warn + 1;
7794: END IF;

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

7792: WSH_UTIL_CORE.Add_Message(x_return_status);
7793: l_num_warn := l_num_warn + 1;
7794: END IF;
7795: IF NVL(l_pickconfirm_required,0) <> 2 THEN
7796: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AUTOPICK_FOR_ORG');
7797: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7798: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7799: WSH_UTIL_CORE.Add_Message(x_return_status);
7800: l_num_warn := l_num_warn + 1;

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

7793: l_num_warn := l_num_warn + 1;
7794: END IF;
7795: IF NVL(l_pickconfirm_required,0) <> 2 THEN
7796: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AUTOPICK_FOR_ORG');
7797: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7798: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7799: WSH_UTIL_CORE.Add_Message(x_return_status);
7800: l_num_warn := l_num_warn + 1;
7801: END IF;

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

7802: IF NVL(l_autocreate_del_flag, 'N') <> 'Y' THEN
7803: OPEN check_unassigned_dels(l_warn_org, l_batch_id);
7804: FETCH check_unassigned_dels INTO l_assigned;
7805: IF check_unassigned_dels%FOUND THEN
7806: FND_MESSAGE.SET_NAME('WSH','WSH_NO_DELS_FOR_ORG');
7807: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7808: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7809: WSH_UTIL_CORE.Add_Message(x_return_status);
7810: l_num_warn := l_num_warn + 1;

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

7803: OPEN check_unassigned_dels(l_warn_org, l_batch_id);
7804: FETCH check_unassigned_dels INTO l_assigned;
7805: IF check_unassigned_dels%FOUND THEN
7806: FND_MESSAGE.SET_NAME('WSH','WSH_NO_DELS_FOR_ORG');
7807: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7808: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7809: WSH_UTIL_CORE.Add_Message(x_return_status);
7810: l_num_warn := l_num_warn + 1;
7811: END IF;

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

7822: FETCH check_detail_for_AP into l_warn_org;
7823: EXIT when check_detail_for_AP%NOTFOUND;
7824: -- set message for org
7825: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_warn_org);
7826: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AP_LEVEL_FOR_ORG');
7827: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7828: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7829: WSH_UTIL_CORE.Add_Message(x_return_status);
7830: l_num_warn := l_num_warn + 1;

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

7823: EXIT when check_detail_for_AP%NOTFOUND;
7824: -- set message for org
7825: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_warn_org);
7826: FND_MESSAGE.SET_NAME('WSH','WSH_NO_AP_LEVEL_FOR_ORG');
7827: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
7828: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7829: WSH_UTIL_CORE.Add_Message(x_return_status);
7830: l_num_warn := l_num_warn + 1;
7831: END LOOP;

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

7846: p_num_workers => 1, -- Always 1
7847: p_commit => 'N');
7848: IF (x_request_ids(l_index) = 0) THEN
7849: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7850: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_FAILED');
7851: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);
7852: FND_MESSAGE.SET_TOKEN('NAME',l_name);
7853: WSH_UTIL_CORE.Add_Message(x_return_status);
7854: l_count_fail := l_count_fail + 1;

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

7847: p_commit => 'N');
7848: IF (x_request_ids(l_index) = 0) THEN
7849: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7850: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_FAILED');
7851: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);
7852: FND_MESSAGE.SET_TOKEN('NAME',l_name);
7853: WSH_UTIL_CORE.Add_Message(x_return_status);
7854: l_count_fail := l_count_fail + 1;
7855: ELSE

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

7848: IF (x_request_ids(l_index) = 0) THEN
7849: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7850: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_FAILED');
7851: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);
7852: FND_MESSAGE.SET_TOKEN('NAME',l_name);
7853: WSH_UTIL_CORE.Add_Message(x_return_status);
7854: l_count_fail := l_count_fail + 1;
7855: ELSE
7856: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

7853: WSH_UTIL_CORE.Add_Message(x_return_status);
7854: l_count_fail := l_count_fail + 1;
7855: ELSE
7856: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7857: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_SUCCESS');
7858: --change for Bug#3379553
7859: -- FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);
7860: -- FND_MESSAGE.SET_TOKEN('NAME',l_name);
7861: --End of change for Bug#3379553

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

7855: ELSE
7856: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7857: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_SUCCESS');
7858: --change for Bug#3379553
7859: -- FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);
7860: -- FND_MESSAGE.SET_TOKEN('NAME',l_name);
7861: --End of change for Bug#3379553
7862: FND_MESSAGE.SET_TOKEN('REQUEST_ID', to_char(x_request_ids(l_index)));
7863: WSH_UTIL_CORE.Add_Message(x_return_status);

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

7856: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7857: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_SUCCESS');
7858: --change for Bug#3379553
7859: -- FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);
7860: -- FND_MESSAGE.SET_TOKEN('NAME',l_name);
7861: --End of change for Bug#3379553
7862: FND_MESSAGE.SET_TOKEN('REQUEST_ID', to_char(x_request_ids(l_index)));
7863: WSH_UTIL_CORE.Add_Message(x_return_status);
7864: l_count_succ := l_count_succ + 1;

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

7858: --change for Bug#3379553
7859: -- FND_MESSAGE.SET_TOKEN('RELEASE_TYPE',l_type);
7860: -- FND_MESSAGE.SET_TOKEN('NAME',l_name);
7861: --End of change for Bug#3379553
7862: FND_MESSAGE.SET_TOKEN('REQUEST_ID', to_char(x_request_ids(l_index)));
7863: WSH_UTIL_CORE.Add_Message(x_return_status);
7864: l_count_succ := l_count_succ + 1;
7865: END IF;
7866:

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

7907:
7908:
7909:
7910: -- Summary message
7911: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_SUMMARY');
7912: FND_MESSAGE.SET_TOKEN('SUCCESS',to_char(l_count_succ));
7913: FND_MESSAGE.SET_TOKEN('FAIL',to_char(l_count_fail));
7914: WSH_UTIL_CORE.Add_Message(x_return_status);
7915:

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

7908:
7909:
7910: -- Summary message
7911: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_SUMMARY');
7912: FND_MESSAGE.SET_TOKEN('SUCCESS',to_char(l_count_succ));
7913: FND_MESSAGE.SET_TOKEN('FAIL',to_char(l_count_fail));
7914: WSH_UTIL_CORE.Add_Message(x_return_status);
7915:
7916: IF ((l_num_warn > 0) and (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)) THEN

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

7909:
7910: -- Summary message
7911: FND_MESSAGE.SET_NAME('WSH','WSH_PR_LAUNCH_SUMMARY');
7912: FND_MESSAGE.SET_TOKEN('SUCCESS',to_char(l_count_succ));
7913: FND_MESSAGE.SET_TOKEN('FAIL',to_char(l_count_fail));
7914: WSH_UTIL_CORE.Add_Message(x_return_status);
7915:
7916: IF ((l_num_warn > 0) and (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)) THEN
7917:

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

7915:
7916: IF ((l_num_warn > 0) and (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)) THEN
7917:
7918: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7919: FND_MESSAGE.SET_NAME('WSH','WSH_QS_LAUNCH_SUMMARY');
7920: WSH_UTIL_CORE.Add_Message(x_return_status);
7921:
7922: END IF;
7923: --

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

7942: END IF;
7943: --
7944:
7945: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7946: FND_MESSAGE.SET_NAME('WSH','WSH_PR_INVALID_DETAIL');
7947: FND_MESSAGE.SET_TOKEN('detail',to_char(l_detail_id));
7948: WSH_UTIL_CORE.Add_Message(x_return_status);
7949: --
7950: -- Debug Statements

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

7943: --
7944:
7945: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7946: FND_MESSAGE.SET_NAME('WSH','WSH_PR_INVALID_DETAIL');
7947: FND_MESSAGE.SET_TOKEN('detail',to_char(l_detail_id));
7948: WSH_UTIL_CORE.Add_Message(x_return_status);
7949: --
7950: -- Debug Statements
7951: --

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

7963: END IF;
7964: --
7965:
7966: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7967: FND_MESSAGE.SET_NAME('WSH','WSH_PR_INVALID_ENTITY');
7968: FND_MESSAGE.SET_TOKEN('entity_type',lower(l_type));
7969: IF l_type = 'Trip' THEN
7970: l_entity_id := l_trip_id;
7971: ELSIF l_type = 'Stop' THEN

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

7964: --
7965:
7966: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7967: FND_MESSAGE.SET_NAME('WSH','WSH_PR_INVALID_ENTITY');
7968: FND_MESSAGE.SET_TOKEN('entity_type',lower(l_type));
7969: IF l_type = 'Trip' THEN
7970: l_entity_id := l_trip_id;
7971: ELSIF l_type = 'Stop' THEN
7972: l_entity_id := l_stop_id;

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

7972: l_entity_id := l_stop_id;
7973: ELSIF l_type = 'Delivery' THEN
7974: l_entity_id := l_delivery_id;
7975: END IF;
7976: FND_MESSAGE.SET_TOKEN('entity_id',l_entity_id);
7977: WSH_UTIL_CORE.Add_Message(x_return_status);
7978: --
7979: -- Debug Statements
7980: --

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

8607: FETCH get_org_code
8608: INTO v_org_code;
8609: CLOSE get_org_code;
8610: v_Date := null;
8611: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CALENDAR_DATE');
8612: FND_MESSAGE.SET_TOKEN('NAME',p_PickRule);
8613: FND_MESSAGE.SET_TOKEN('CALENDAR',p_CalCode);
8614: FND_MESSAGE.SET_TOKEN('WAREHOUSE',v_org_code);
8615: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

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

8608: INTO v_org_code;
8609: CLOSE get_org_code;
8610: v_Date := null;
8611: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CALENDAR_DATE');
8612: FND_MESSAGE.SET_TOKEN('NAME',p_PickRule);
8613: FND_MESSAGE.SET_TOKEN('CALENDAR',p_CalCode);
8614: FND_MESSAGE.SET_TOKEN('WAREHOUSE',v_org_code);
8615: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8616: RAISE e_return;

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

8609: CLOSE get_org_code;
8610: v_Date := null;
8611: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CALENDAR_DATE');
8612: FND_MESSAGE.SET_TOKEN('NAME',p_PickRule);
8613: FND_MESSAGE.SET_TOKEN('CALENDAR',p_CalCode);
8614: FND_MESSAGE.SET_TOKEN('WAREHOUSE',v_org_code);
8615: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8616: RAISE e_return;
8617: EXIT;

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

8610: v_Date := null;
8611: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CALENDAR_DATE');
8612: FND_MESSAGE.SET_TOKEN('NAME',p_PickRule);
8613: FND_MESSAGE.SET_TOKEN('CALENDAR',p_CalCode);
8614: FND_MESSAGE.SET_TOKEN('WAREHOUSE',v_org_code);
8615: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8616: RAISE e_return;
8617: EXIT;
8618: