216: l_warehouse_type := 'CMS';
217: ELSE
218: l_warehouse_type := NULL;
219: IF (p_msg_display = 'Y' ) THEN
220: FND_MESSAGE.Set_Name('WSH', 'WSH_CARR_NOT_MANIFEST_ENABLED');
221: FND_MESSAGE.Set_Token('ENTITY_NAME', l_entity_name);
222: FND_MESSAGE.Set_Token('ENTITY_ID', l_entity_id);
223: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
224: END IF;
217: ELSE
218: l_warehouse_type := NULL;
219: IF (p_msg_display = 'Y' ) THEN
220: FND_MESSAGE.Set_Name('WSH', 'WSH_CARR_NOT_MANIFEST_ENABLED');
221: FND_MESSAGE.Set_Token('ENTITY_NAME', l_entity_name);
222: FND_MESSAGE.Set_Token('ENTITY_ID', l_entity_id);
223: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
224: END IF;
225: END IF;
218: l_warehouse_type := NULL;
219: IF (p_msg_display = 'Y' ) THEN
220: FND_MESSAGE.Set_Name('WSH', 'WSH_CARR_NOT_MANIFEST_ENABLED');
221: FND_MESSAGE.Set_Token('ENTITY_NAME', l_entity_name);
222: FND_MESSAGE.Set_Token('ENTITY_ID', l_entity_id);
223: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
224: END IF;
225: END IF;
226: END IF ;
528: l_del_name:= l_txn_hist_record.entity_number;
529:
530: IF (instrb(l_Event_Key,'TPW') <> 0 ) THEN --{
531: IF (p_txn_hist_record.action_type='A' ) THEN
532: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_TPW_NOTIFY');
533: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
534: l_subject := FND_MESSAGE.get;
535: ELSE
536: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_TPW_NOTIFY');
529:
530: IF (instrb(l_Event_Key,'TPW') <> 0 ) THEN --{
531: IF (p_txn_hist_record.action_type='A' ) THEN
532: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_TPW_NOTIFY');
533: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
534: l_subject := FND_MESSAGE.get;
535: ELSE
536: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_TPW_NOTIFY');
537: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
530: IF (instrb(l_Event_Key,'TPW') <> 0 ) THEN --{
531: IF (p_txn_hist_record.action_type='A' ) THEN
532: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_TPW_NOTIFY');
533: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
534: l_subject := FND_MESSAGE.get;
535: ELSE
536: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_TPW_NOTIFY');
537: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
538: l_subject := FND_MESSAGE.get;
532: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_TPW_NOTIFY');
533: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
534: l_subject := FND_MESSAGE.get;
535: ELSE
536: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_TPW_NOTIFY');
537: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
538: l_subject := FND_MESSAGE.get;
539: END IF;
540: ELSIF (instrb(l_Event_Key,'CMS') <> 0) THEN --}{
533: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
534: l_subject := FND_MESSAGE.get;
535: ELSE
536: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_TPW_NOTIFY');
537: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
538: l_subject := FND_MESSAGE.get;
539: END IF;
540: ELSIF (instrb(l_Event_Key,'CMS') <> 0) THEN --}{
541: IF (p_txn_hist_record.action_type='A' ) THEN
534: l_subject := FND_MESSAGE.get;
535: ELSE
536: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_TPW_NOTIFY');
537: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
538: l_subject := FND_MESSAGE.get;
539: END IF;
540: ELSIF (instrb(l_Event_Key,'CMS') <> 0) THEN --}{
541: IF (p_txn_hist_record.action_type='A' ) THEN
542: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_CMS_NOTIFY');
538: l_subject := FND_MESSAGE.get;
539: END IF;
540: ELSIF (instrb(l_Event_Key,'CMS') <> 0) THEN --}{
541: IF (p_txn_hist_record.action_type='A' ) THEN
542: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_CMS_NOTIFY');
543: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
544: l_subject := FND_MESSAGE.get;
545: ELSE
546: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_CMS_NOTIFY');
539: END IF;
540: ELSIF (instrb(l_Event_Key,'CMS') <> 0) THEN --}{
541: IF (p_txn_hist_record.action_type='A' ) THEN
542: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_CMS_NOTIFY');
543: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
544: l_subject := FND_MESSAGE.get;
545: ELSE
546: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_CMS_NOTIFY');
547: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
540: ELSIF (instrb(l_Event_Key,'CMS') <> 0) THEN --}{
541: IF (p_txn_hist_record.action_type='A' ) THEN
542: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_CMS_NOTIFY');
543: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
544: l_subject := FND_MESSAGE.get;
545: ELSE
546: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_CMS_NOTIFY');
547: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
548: l_subject := FND_MESSAGE.get;
542: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_CMS_NOTIFY');
543: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
544: l_subject := FND_MESSAGE.get;
545: ELSE
546: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_CMS_NOTIFY');
547: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
548: l_subject := FND_MESSAGE.get;
549: END IF;
550: --Fulfillment BAtch XML Project
543: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
544: l_subject := FND_MESSAGE.get;
545: ELSE
546: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_CMS_NOTIFY');
547: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
548: l_subject := FND_MESSAGE.get;
549: END IF;
550: --Fulfillment BAtch XML Project
551: ELSIF (instrb(l_Event_Key,'TW2') <> 0) THEN
544: l_subject := FND_MESSAGE.get;
545: ELSE
546: FND_MESSAGE.SET_NAME('WSH', 'WSH_SRC_CMS_NOTIFY');
547: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
548: l_subject := FND_MESSAGE.get;
549: END IF;
550: --Fulfillment BAtch XML Project
551: ELSIF (instrb(l_Event_Key,'TW2') <> 0) THEN
552: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_BATCH_NOTIFY');
548: l_subject := FND_MESSAGE.get;
549: END IF;
550: --Fulfillment BAtch XML Project
551: ELSIF (instrb(l_Event_Key,'TW2') <> 0) THEN
552: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_BATCH_NOTIFY');
553: FND_MESSAGE.SET_TOKEN('BATCH_NAME', l_del_name);
554: l_subject := FND_MESSAGE.get;
555: select organization_code into l_org_code from mtl_parameters where organization_id = l_txn_hist_record.Trading_Partner_ID;
556: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_BATCH_NOTIFY_BODY');
549: END IF;
550: --Fulfillment BAtch XML Project
551: ELSIF (instrb(l_Event_Key,'TW2') <> 0) THEN
552: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_BATCH_NOTIFY');
553: FND_MESSAGE.SET_TOKEN('BATCH_NAME', l_del_name);
554: l_subject := FND_MESSAGE.get;
555: select organization_code into l_org_code from mtl_parameters where organization_id = l_txn_hist_record.Trading_Partner_ID;
556: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_BATCH_NOTIFY_BODY');
557: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', l_org_code);
550: --Fulfillment BAtch XML Project
551: ELSIF (instrb(l_Event_Key,'TW2') <> 0) THEN
552: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_BATCH_NOTIFY');
553: FND_MESSAGE.SET_TOKEN('BATCH_NAME', l_del_name);
554: l_subject := FND_MESSAGE.get;
555: select organization_code into l_org_code from mtl_parameters where organization_id = l_txn_hist_record.Trading_Partner_ID;
556: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_BATCH_NOTIFY_BODY');
557: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', l_org_code);
558: FND_MESSAGE.SET_TOKEN('ITEM_KEY', l_Event_Key);
552: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_BATCH_NOTIFY');
553: FND_MESSAGE.SET_TOKEN('BATCH_NAME', l_del_name);
554: l_subject := FND_MESSAGE.get;
555: select organization_code into l_org_code from mtl_parameters where organization_id = l_txn_hist_record.Trading_Partner_ID;
556: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_BATCH_NOTIFY_BODY');
557: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', l_org_code);
558: FND_MESSAGE.SET_TOKEN('ITEM_KEY', l_Event_Key);
559: l_body_text := FND_MESSAGE.get;
560: /*IF l_debug_on THEN
553: FND_MESSAGE.SET_TOKEN('BATCH_NAME', l_del_name);
554: l_subject := FND_MESSAGE.get;
555: select organization_code into l_org_code from mtl_parameters where organization_id = l_txn_hist_record.Trading_Partner_ID;
556: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_BATCH_NOTIFY_BODY');
557: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', l_org_code);
558: FND_MESSAGE.SET_TOKEN('ITEM_KEY', l_Event_Key);
559: l_body_text := FND_MESSAGE.get;
560: /*IF l_debug_on THEN
561: wsh_debug_sv.log (l_module_name, 'l_body_text' , l_body_text);
554: l_subject := FND_MESSAGE.get;
555: select organization_code into l_org_code from mtl_parameters where organization_id = l_txn_hist_record.Trading_Partner_ID;
556: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_BATCH_NOTIFY_BODY');
557: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', l_org_code);
558: FND_MESSAGE.SET_TOKEN('ITEM_KEY', l_Event_Key);
559: l_body_text := FND_MESSAGE.get;
560: /*IF l_debug_on THEN
561: wsh_debug_sv.log (l_module_name, 'l_body_text' , l_body_text);
562: END IF;*/
555: select organization_code into l_org_code from mtl_parameters where organization_id = l_txn_hist_record.Trading_Partner_ID;
556: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_BATCH_NOTIFY_BODY');
557: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', l_org_code);
558: FND_MESSAGE.SET_TOKEN('ITEM_KEY', l_Event_Key);
559: l_body_text := FND_MESSAGE.get;
560: /*IF l_debug_on THEN
561: wsh_debug_sv.log (l_module_name, 'l_body_text' , l_body_text);
562: END IF;*/
563: WF_EVENT.AddParameterToList (p_name => 'BODY_TEXT',