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.OE_SHIPPING_INTEGRATION_PVT dependencies on OE_BULK_WF_UTIL

Line 4793: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN

4789: IF g_debug_call > 0 THEN
4790: G_DEBUG_MSG := G_DEBUG_MSG || '201';
4791: END IF;
4792:
4793: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN
4794: IF l_debug_level > 0 THEN
4795: oe_debug_pub.add
4796: ('bulk call?? line id '|| OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4797: (OE_BULK_WF_UTIL.G_LINE_INDEX), 2);

Line 4797: (OE_BULK_WF_UTIL.G_LINE_INDEX), 2);

4793: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN
4794: IF l_debug_level > 0 THEN
4795: oe_debug_pub.add
4796: ('bulk call?? line id '|| OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4797: (OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
4798: END IF;
4799: END IF;
4800:
4801: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND

Line 4801: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND

4797: (OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
4798: END IF;
4799: END IF;
4800:
4801: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND
4802: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =
4803: p_line_id THEN
4804: IF l_debug_level > 0 THEN
4805: oe_debug_pub.add

Line 4802: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =

4798: END IF;
4799: END IF;
4800:
4801: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND
4802: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =
4803: p_line_id THEN
4804: IF l_debug_level > 0 THEN
4805: oe_debug_pub.add
4806: ('2 shipping bulk mode '|| OE_BULK_WF_UTIL.G_LINE_INDEX, 4);

Line 4806: ('2 shipping bulk mode '|| OE_BULK_WF_UTIL.G_LINE_INDEX, 4);

4802: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =
4803: p_line_id THEN
4804: IF l_debug_level > 0 THEN
4805: oe_debug_pub.add
4806: ('2 shipping bulk mode '|| OE_BULK_WF_UTIL.G_LINE_INDEX, 4);
4807: END IF;
4808:
4809: l_line_category_code := OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code
4810: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4810: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4806: ('2 shipping bulk mode '|| OE_BULK_WF_UTIL.G_LINE_INDEX, 4);
4807: END IF;
4808:
4809: l_line_category_code := OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code
4810: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4811:
4812: l_source_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.source_type_code
4813: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4814:

Line 4813: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4809: l_line_category_code := OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code
4810: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4811:
4812: l_source_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.source_type_code
4813: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4814:
4815: --oe_debug_pub.add('here 2: ', 2);
4816:
4817: l_ship_model_complete_flag

Line 4819: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4815: --oe_debug_pub.add('here 2: ', 2);
4816:
4817: l_ship_model_complete_flag
4818: := OE_BULK_ORDER_PVT.G_LINE_REC.ship_model_complete_flag
4819: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4820:
4821: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id
4822: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4823: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id

Line 4822: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4818: := OE_BULK_ORDER_PVT.G_LINE_REC.ship_model_complete_flag
4819: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4820:
4821: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id
4822: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4823: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id
4824: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4825:
4826: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id

Line 4824: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4820:
4821: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id
4822: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4823: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id
4824: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4825:
4826: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id
4827: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4828: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag

Line 4827: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4823: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id
4824: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4825:
4826: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id
4827: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4828: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag
4829: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4830:
4831: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag

Line 4829: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4825:
4826: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id
4827: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4828: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag
4829: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4830:
4831: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4832: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4833:

Line 4832: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4828: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag
4829: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4830:
4831: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4832: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4833:
4834: l_explosion_date := OE_BULK_ORDER_PVT.G_LINE_REC.explosion_date
4835: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4836:

Line 4835: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4831: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4832: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4833:
4834: l_explosion_date := OE_BULK_ORDER_PVT.G_LINE_REC.explosion_date
4835: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4836:
4837: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4838: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4839: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code

Line 4838: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4834: l_explosion_date := OE_BULK_ORDER_PVT.G_LINE_REC.explosion_date
4835: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4836:
4837: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4838: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4839: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code
4840: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4841: --oe_debug_pub.add('here 3: ', 2);
4842: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id

Line 4840: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4836:
4837: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4838: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4839: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code
4840: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4841: --oe_debug_pub.add('here 3: ', 2);
4842: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id
4843: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4844:

Line 4843: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4839: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code
4840: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4841: --oe_debug_pub.add('here 3: ', 2);
4842: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id
4843: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4844:
4845: --oe_debug_pub.add('here 4: ', 2);
4846: ELSE
4847: SELECT line_category_code,

Line 4923: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND

4919: IF g_debug_call > 0 THEN
4920: G_DEBUG_MSG := G_DEBUG_MSG || '205';
4921: END IF;
4922:
4923: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND
4924: OE_Code_Control.Code_Release_Level >= '110510' AND
4925: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =
4926: p_line_id THEN
4927: IF l_debug_level > 0 THEN

Line 4925: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =

4921: END IF;
4922:
4923: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND
4924: OE_Code_Control.Code_Release_Level >= '110510' AND
4925: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =
4926: p_line_id THEN
4927: IF l_debug_level > 0 THEN
4928: oe_debug_pub.add('3 shipping bulk mode',5);
4929: END IF;

Line 4932: (OE_BULK_WF_UTIL.G_LINE_INDEX) = 'Y' THEN

4928: oe_debug_pub.add('3 shipping bulk mode',5);
4929: END IF;
4930:
4931: IF OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4932: (OE_BULK_WF_UTIL.G_LINE_INDEX) = 'Y' THEN
4933:
4934: IF l_debug_level > 0 THEN
4935: oe_debug_pub.add
4936: (OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT,5);

Line 4988: (OE_BULK_WF_UTIL.G_LINE_INDEX) := 'Y';

4984: --------------------------------------------------------
4985: -- Assign values to this line
4986: --------------------------------------------------------
4987: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag
4988: (OE_BULK_WF_UTIL.G_LINE_INDEX) := 'Y';
4989:
4990: --oe_debug_pub.add('here 5: ', 2);
4991:
4992: l_count := OE_BULK_CACHE.Load_Item

Line 4995: (OE_BULK_WF_UTIL.G_LINE_INDEX)

4991:
4992: l_count := OE_BULK_CACHE.Load_Item
4993: ( p_key1
4994: => OE_BULK_ORDER_PVT.G_LINE_REC.inventory_item_id
4995: (OE_BULK_WF_UTIL.G_LINE_INDEX)
4996: ,p_key2
4997: => OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id
4998: (OE_BULK_WF_UTIL.G_LINE_INDEX));
4999:

Line 4998: (OE_BULK_WF_UTIL.G_LINE_INDEX));

4994: => OE_BULK_ORDER_PVT.G_LINE_REC.inventory_item_id
4995: (OE_BULK_WF_UTIL.G_LINE_INDEX)
4996: ,p_key2
4997: => OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id
4998: (OE_BULK_WF_UTIL.G_LINE_INDEX));
4999:
5000: --oe_debug_pub.add('here 5-1: '
5001: --|| OE_BULK_ORDER_PVT.G_LINE_REC.ordered_item_id
5002: --(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);

Line 5002: --(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);

4998: (OE_BULK_WF_UTIL.G_LINE_INDEX));
4999:
5000: --oe_debug_pub.add('here 5-1: '
5001: --|| OE_BULK_ORDER_PVT.G_LINE_REC.ordered_item_id
5002: --(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
5003:
5004: IF g_debug_call > 0 THEN
5005: G_DEBUG_MSG := G_DEBUG_MSG || '208';
5006: END IF;

Line 5009: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5005: G_DEBUG_MSG := G_DEBUG_MSG || '208';
5006: END IF;
5007:
5008: OE_BULK_ORDER_PVT.G_LINE_REC.item_description
5009: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5010: OE_BULK_CACHE.G_ITEM_TBL(l_count).item_description;
5011:
5012: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id
5013: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

Line 5013: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5009: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5010: OE_BULK_CACHE.G_ITEM_TBL(l_count).item_description;
5011:
5012: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id
5013: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5014: OE_BULK_CACHE.G_ITEM_TBL(l_count).hazard_class_id;
5015:
5016: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code
5017: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

Line 5017: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5013: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5014: OE_BULK_CACHE.G_ITEM_TBL(l_count).hazard_class_id;
5015:
5016: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code
5017: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5018: OE_BULK_CACHE.G_ITEM_TBL(l_count).weight_uom_code;
5019:
5020: --oe_debug_pub.add('here 6: ', 2);
5021:

Line 5023: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5019:
5020: --oe_debug_pub.add('here 6: ', 2);
5021:
5022: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code
5023: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5024: OE_BULK_CACHE.G_ITEM_TBL(l_count).volume_uom_code;
5025:
5026: --oe_debug_pub.add('here 6-1: ', 2);
5027:

Line 5029: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5025:
5026: --oe_debug_pub.add('here 6-1: ', 2);
5027:
5028: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom
5029: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5030: OE_BULK_CACHE.G_ITEM_TBL(l_count).primary_uom_code;
5031:
5032: --oe_debug_pub.add('here 6-2: ', 2);
5033:

Line 5035: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5031:
5032: --oe_debug_pub.add('here 6-2: ', 2);
5033:
5034: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight
5035: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5036: OE_BULK_CACHE.G_ITEM_TBL(l_count).unit_weight;
5037:
5038: --oe_debug_pub.add('here 6-3: ', 2);
5039:

Line 5041: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5037:
5038: --oe_debug_pub.add('here 6-3: ', 2);
5039:
5040: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume
5041: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5042: OE_BULK_CACHE.G_ITEM_TBL(l_count).unit_volume;
5043:
5044: --oe_debug_pub.add('here 6-4: ', 2);
5045:

Line 5047: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5043:
5044: --oe_debug_pub.add('here 6-4: ', 2);
5045:
5046: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag
5047: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5048: OE_BULK_CACHE.G_ITEM_TBL(l_count).pickable_flag;
5049:
5050: --oe_debug_pub.add('here 7: ', 2);
5051: --------------- from header/ xn types --------------------

Line 5054: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5050: --oe_debug_pub.add('here 7: ', 2);
5051: --------------- from header/ xn types --------------------
5052:
5053: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id
5054: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5055: OE_Bulk_Order_PVT.g_header_rec.sold_to_contact_id
5056: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5057:
5058: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number

Line 5056: (OE_BULK_WF_UTIL.G_HEADER_INDEX);

5052:
5053: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id
5054: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5055: OE_Bulk_Order_PVT.g_header_rec.sold_to_contact_id
5056: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5057:
5058: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number
5059: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5060: OE_Bulk_Order_PVT.g_header_rec.order_number

Line 5059: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5055: OE_Bulk_Order_PVT.g_header_rec.sold_to_contact_id
5056: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5057:
5058: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number
5059: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5060: OE_Bulk_Order_PVT.g_header_rec.order_number
5061: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5062:
5063: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code

Line 5061: (OE_BULK_WF_UTIL.G_HEADER_INDEX);

5057:
5058: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number
5059: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5060: OE_Bulk_Order_PVT.g_header_rec.order_number
5061: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5062:
5063: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code
5064: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5065: OE_Bulk_Order_PVT.g_header_rec.order_date_type_code

Line 5064: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5060: OE_Bulk_Order_PVT.g_header_rec.order_number
5061: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5062:
5063: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code
5064: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5065: OE_Bulk_Order_PVT.g_header_rec.order_date_type_code
5066: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5067:
5068: --oe_debug_pub.add('here 8: ', 2);

Line 5066: (OE_BULK_WF_UTIL.G_HEADER_INDEX);

5062:
5063: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code
5064: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5065: OE_Bulk_Order_PVT.g_header_rec.order_date_type_code
5066: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5067:
5068: --oe_debug_pub.add('here 8: ', 2);
5069: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id
5070: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

Line 5070: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5066: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5067:
5068: --oe_debug_pub.add('here 8: ', 2);
5069: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id
5070: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5071: OE_Bulk_Order_PVT.g_header_rec.order_type_id
5072: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5073:
5074: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code

Line 5072: (OE_BULK_WF_UTIL.G_HEADER_INDEX);

5068: --oe_debug_pub.add('here 8: ', 2);
5069: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id
5070: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5071: OE_Bulk_Order_PVT.g_header_rec.order_type_id
5072: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5073:
5074: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code
5075: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5076: OE_Bulk_Order_PVT.g_header_rec.transactional_curr_code

Line 5075: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5071: OE_Bulk_Order_PVT.g_header_rec.order_type_id
5072: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5073:
5074: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code
5075: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5076: OE_Bulk_Order_PVT.g_header_rec.transactional_curr_code
5077: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5078:
5079: l_count := OE_BULK_CACHE.Load_Order_Type

Line 5077: (OE_BULK_WF_UTIL.G_HEADER_INDEX);

5073:
5074: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code
5075: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5076: OE_Bulk_Order_PVT.g_header_rec.transactional_curr_code
5077: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5078:
5079: l_count := OE_BULK_CACHE.Load_Order_Type
5080: ( p_key
5081: => OE_BULK_ORDER_PVT.G_HEADER_REC.order_type_id

Line 5082: (OE_BULK_WF_UTIL.G_HEADER_INDEX));

5078:
5079: l_count := OE_BULK_CACHE.Load_Order_Type
5080: ( p_key
5081: => OE_BULK_ORDER_PVT.G_HEADER_REC.order_type_id
5082: (OE_BULK_WF_UTIL.G_HEADER_INDEX));
5083:
5084: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name
5085: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5086: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_count).name;

Line 5085: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5081: => OE_BULK_ORDER_PVT.G_HEADER_REC.order_type_id
5082: (OE_BULK_WF_UTIL.G_HEADER_INDEX));
5083:
5084: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name
5085: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5086: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_count).name;
5087:
5088: --oe_debug_pub.add('here 9: '|| OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
5089:

Line 5088: --oe_debug_pub.add('here 9: '|| OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);

5084: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name
5085: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5086: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_count).name;
5087:
5088: --oe_debug_pub.add('here 9: '|| OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
5089:
5090: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number
5091: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5092: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number

Line 5091: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5087:
5088: --oe_debug_pub.add('here 9: '|| OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
5089:
5090: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number
5091: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5092: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number
5093: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5094: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5095: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||

Line 5093: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||

5089:
5090: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number
5091: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5092: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number
5093: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5094: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5095: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5096: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5097: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||

Line 5095: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||

5091: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5092: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number
5093: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5094: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5095: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5096: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5097: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5098: OE_BULK_ORDER_PVT.G_LINE_REC.component_number
5099: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||

Line 5097: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||

5093: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5094: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5095: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5096: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5097: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5098: OE_BULK_ORDER_PVT.G_LINE_REC.component_number
5099: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5100: OE_BULK_ORDER_PVT.G_LINE_REC.service_number
5101: (OE_BULK_WF_UTIL.G_LINE_INDEX),'.');

Line 5099: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||

5095: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5096: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5097: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5098: OE_BULK_ORDER_PVT.G_LINE_REC.component_number
5099: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5100: OE_BULK_ORDER_PVT.G_LINE_REC.service_number
5101: (OE_BULK_WF_UTIL.G_LINE_INDEX),'.');
5102:
5103: --oe_debug_pub.add('here 10: ', 2);

Line 5101: (OE_BULK_WF_UTIL.G_LINE_INDEX),'.');

5097: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5098: OE_BULK_ORDER_PVT.G_LINE_REC.component_number
5099: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5100: OE_BULK_ORDER_PVT.G_LINE_REC.service_number
5101: (OE_BULK_WF_UTIL.G_LINE_INDEX),'.');
5102:
5103: --oe_debug_pub.add('here 10: ', 2);
5104:
5105: IF l_debug_level > 0 THEN

Line 5108: (OE_BULK_WF_UTIL.G_LINE_INDEX), 1 ) ;

5104:
5105: IF l_debug_level > 0 THEN
5106: oe_debug_pub.add('eligible for shipping '||
5107: OE_BULK_ORDER_PVT.G_LINE_REC.line_id
5108: (OE_BULK_WF_UTIL.G_LINE_INDEX), 1 ) ;
5109: END IF;
5110:
5111: END IF; -- if shippable
5112:

Line 6080: OE_BULK_WF_UTIL.G_LINE_INDEX := I;

6076: LOOP
6077: IF p_line_rec.shipping_interfaced_flag(I) is NULL AND
6078: p_line_rec.shippable_flag(I) = 'Y' THEN
6079:
6080: OE_BULK_WF_UTIL.G_LINE_INDEX := I;
6081:
6082: BEGIN
6083: WF_ENGINE.HandleError
6084: (itemtype => 'OEOL',

Line 6095: OE_BULK_WF_UTIL.G_LINE_INDEX := NULL;

6091: WHEN OTHERS THEN
6092: oe_debug_pub.add('Exception caught after Wf_engine.Handle_Error',5);
6093: END; -- Erroring out the WF table
6094:
6095: OE_BULK_WF_UTIL.G_LINE_INDEX := NULL;
6096: END IF; -- lines not shipping_interfaced
6097: p_line_rec.shipping_eligible_flag(I) := null;
6098: END LOOP;
6099: