199: l_warehouse_type := 'CMS';
200: ELSE
201: l_warehouse_type := NULL;
202: IF (p_msg_display = 'Y' ) THEN
203: FND_MESSAGE.Set_Name('WSH', 'WSH_CARR_NOT_MANIFEST_ENABLED');
204: FND_MESSAGE.Set_Token('ENTITY_NAME', l_entity_name);
205: FND_MESSAGE.Set_Token('ENTITY_ID', l_entity_id);
206: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
207: END IF;
200: ELSE
201: l_warehouse_type := NULL;
202: IF (p_msg_display = 'Y' ) THEN
203: FND_MESSAGE.Set_Name('WSH', 'WSH_CARR_NOT_MANIFEST_ENABLED');
204: FND_MESSAGE.Set_Token('ENTITY_NAME', l_entity_name);
205: FND_MESSAGE.Set_Token('ENTITY_ID', l_entity_id);
206: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
207: END IF;
208: END IF;
201: l_warehouse_type := NULL;
202: IF (p_msg_display = 'Y' ) THEN
203: FND_MESSAGE.Set_Name('WSH', 'WSH_CARR_NOT_MANIFEST_ENABLED');
204: FND_MESSAGE.Set_Token('ENTITY_NAME', l_entity_name);
205: FND_MESSAGE.Set_Token('ENTITY_ID', l_entity_id);
206: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
207: END IF;
208: END IF;
209: END IF ;
453: l_del_name:= l_txn_hist_record.entity_number;
454:
455: IF (instrb(l_Event_Key,'TPW') <> 0 ) THEN --{
456: IF (p_txn_hist_record.action_type='A' ) THEN
457: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_TPW_NOTIFY');
458: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
459: l_subject := FND_MESSAGE.get;
460: ELSE
461: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_TPW_NOTIFY');
454:
455: IF (instrb(l_Event_Key,'TPW') <> 0 ) THEN --{
456: IF (p_txn_hist_record.action_type='A' ) THEN
457: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_TPW_NOTIFY');
458: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
459: l_subject := FND_MESSAGE.get;
460: ELSE
461: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_TPW_NOTIFY');
462: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
455: IF (instrb(l_Event_Key,'TPW') <> 0 ) THEN --{
456: IF (p_txn_hist_record.action_type='A' ) THEN
457: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_TPW_NOTIFY');
458: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
459: l_subject := FND_MESSAGE.get;
460: ELSE
461: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_TPW_NOTIFY');
462: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
463: l_subject := FND_MESSAGE.get;
457: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_TPW_NOTIFY');
458: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
459: l_subject := FND_MESSAGE.get;
460: ELSE
461: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_TPW_NOTIFY');
462: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
463: l_subject := FND_MESSAGE.get;
464: END IF;
465: ELSIF (instrb(l_Event_Key,'CMS') <> 0) THEN --}{
458: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
459: l_subject := FND_MESSAGE.get;
460: ELSE
461: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_TPW_NOTIFY');
462: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
463: l_subject := FND_MESSAGE.get;
464: END IF;
465: ELSIF (instrb(l_Event_Key,'CMS') <> 0) THEN --}{
466: IF (p_txn_hist_record.action_type='A' ) THEN
459: l_subject := FND_MESSAGE.get;
460: ELSE
461: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_TPW_NOTIFY');
462: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
463: l_subject := FND_MESSAGE.get;
464: END IF;
465: ELSIF (instrb(l_Event_Key,'CMS') <> 0) THEN --}{
466: IF (p_txn_hist_record.action_type='A' ) THEN
467: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_CMS_NOTIFY');
463: l_subject := FND_MESSAGE.get;
464: END IF;
465: ELSIF (instrb(l_Event_Key,'CMS') <> 0) THEN --}{
466: IF (p_txn_hist_record.action_type='A' ) THEN
467: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_CMS_NOTIFY');
468: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
469: l_subject := FND_MESSAGE.get;
470: ELSE
471: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_CMS_NOTIFY');
464: END IF;
465: ELSIF (instrb(l_Event_Key,'CMS') <> 0) THEN --}{
466: IF (p_txn_hist_record.action_type='A' ) THEN
467: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_CMS_NOTIFY');
468: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
469: l_subject := FND_MESSAGE.get;
470: ELSE
471: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_CMS_NOTIFY');
472: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
465: ELSIF (instrb(l_Event_Key,'CMS') <> 0) THEN --}{
466: IF (p_txn_hist_record.action_type='A' ) THEN
467: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_CMS_NOTIFY');
468: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
469: l_subject := FND_MESSAGE.get;
470: ELSE
471: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_CMS_NOTIFY');
472: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
473: l_subject := FND_MESSAGE.get;
467: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_CMS_NOTIFY');
468: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
469: l_subject := FND_MESSAGE.get;
470: ELSE
471: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_CMS_NOTIFY');
472: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
473: l_subject := FND_MESSAGE.get;
474: END IF;
475: END IF; --}
468: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
469: l_subject := FND_MESSAGE.get;
470: ELSE
471: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_CMS_NOTIFY');
472: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
473: l_subject := FND_MESSAGE.get;
474: END IF;
475: END IF; --}
476:
469: l_subject := FND_MESSAGE.get;
470: ELSE
471: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_CMS_NOTIFY');
472: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
473: l_subject := FND_MESSAGE.get;
474: END IF;
475: END IF; --}
476:
477: IF l_debug_on THEN