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.

[Home] [Help]

APPS.OE_SHIPPING_INTEGRATION_PVT dependencies on OE_BULK_WF_UTIL

Line 4775: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN

4771: IF g_debug_call > 0 THEN
4772: G_DEBUG_MSG := G_DEBUG_MSG || '201';
4773: END IF;
4774:
4775: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN
4776: IF l_debug_level > 0 THEN
4777: oe_debug_pub.add
4778: ('bulk call?? line id '|| OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4779: (OE_BULK_WF_UTIL.G_LINE_INDEX), 2);

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

4775: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN
4776: IF l_debug_level > 0 THEN
4777: oe_debug_pub.add
4778: ('bulk call?? line id '|| OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4779: (OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
4780: END IF;
4781: END IF;
4782:
4783: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND

Line 4783: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND

4779: (OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
4780: END IF;
4781: END IF;
4782:
4783: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND
4784: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =
4785: p_line_id THEN
4786: IF l_debug_level > 0 THEN
4787: oe_debug_pub.add

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

4780: END IF;
4781: END IF;
4782:
4783: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND
4784: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =
4785: p_line_id THEN
4786: IF l_debug_level > 0 THEN
4787: oe_debug_pub.add
4788: ('2 shipping bulk mode '|| OE_BULK_WF_UTIL.G_LINE_INDEX, 4);

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

4784: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =
4785: p_line_id THEN
4786: IF l_debug_level > 0 THEN
4787: oe_debug_pub.add
4788: ('2 shipping bulk mode '|| OE_BULK_WF_UTIL.G_LINE_INDEX, 4);
4789: END IF;
4790:
4791: l_line_category_code := OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code
4792: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4792: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4788: ('2 shipping bulk mode '|| OE_BULK_WF_UTIL.G_LINE_INDEX, 4);
4789: END IF;
4790:
4791: l_line_category_code := OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code
4792: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4793:
4794: l_source_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.source_type_code
4795: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4796:

Line 4795: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4791: l_line_category_code := OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code
4792: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4793:
4794: l_source_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.source_type_code
4795: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4796:
4797: --oe_debug_pub.add('here 2: ', 2);
4798:
4799: l_ship_model_complete_flag

Line 4801: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4797: --oe_debug_pub.add('here 2: ', 2);
4798:
4799: l_ship_model_complete_flag
4800: := OE_BULK_ORDER_PVT.G_LINE_REC.ship_model_complete_flag
4801: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4802:
4803: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id
4804: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4805: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id

Line 4804: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4800: := OE_BULK_ORDER_PVT.G_LINE_REC.ship_model_complete_flag
4801: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4802:
4803: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id
4804: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4805: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id
4806: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4807:
4808: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id

Line 4806: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4802:
4803: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id
4804: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4805: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id
4806: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4807:
4808: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id
4809: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4810: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag

Line 4809: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4805: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id
4806: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4807:
4808: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id
4809: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4810: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag
4811: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4812:
4813: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag

Line 4811: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4807:
4808: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id
4809: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4810: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag
4811: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4812:
4813: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4814: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4815:

Line 4814: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4810: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag
4811: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4812:
4813: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4814: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4815:
4816: l_explosion_date := OE_BULK_ORDER_PVT.G_LINE_REC.explosion_date
4817: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4818:

Line 4817: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4813: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4814: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4815:
4816: l_explosion_date := OE_BULK_ORDER_PVT.G_LINE_REC.explosion_date
4817: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4818:
4819: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4820: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4821: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code

Line 4820: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4816: l_explosion_date := OE_BULK_ORDER_PVT.G_LINE_REC.explosion_date
4817: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4818:
4819: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4820: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4821: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code
4822: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4823: --oe_debug_pub.add('here 3: ', 2);
4824: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id

Line 4822: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4818:
4819: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4820: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4821: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code
4822: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4823: --oe_debug_pub.add('here 3: ', 2);
4824: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id
4825: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4826:

Line 4825: (OE_BULK_WF_UTIL.G_LINE_INDEX);

4821: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code
4822: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4823: --oe_debug_pub.add('here 3: ', 2);
4824: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id
4825: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4826:
4827: --oe_debug_pub.add('here 4: ', 2);
4828: ELSE
4829: SELECT line_category_code,

Line 4905: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND

4901: IF g_debug_call > 0 THEN
4902: G_DEBUG_MSG := G_DEBUG_MSG || '205';
4903: END IF;
4904:
4905: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND
4906: OE_Code_Control.Code_Release_Level >= '110510' AND
4907: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =
4908: p_line_id THEN
4909: IF l_debug_level > 0 THEN

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

4903: END IF;
4904:
4905: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND
4906: OE_Code_Control.Code_Release_Level >= '110510' AND
4907: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =
4908: p_line_id THEN
4909: IF l_debug_level > 0 THEN
4910: oe_debug_pub.add('3 shipping bulk mode',5);
4911: END IF;

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

4910: oe_debug_pub.add('3 shipping bulk mode',5);
4911: END IF;
4912:
4913: IF OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4914: (OE_BULK_WF_UTIL.G_LINE_INDEX) = 'Y' THEN
4915:
4916: IF l_debug_level > 0 THEN
4917: oe_debug_pub.add
4918: (OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT,5);

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

4966: --------------------------------------------------------
4967: -- Assign values to this line
4968: --------------------------------------------------------
4969: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag
4970: (OE_BULK_WF_UTIL.G_LINE_INDEX) := 'Y';
4971:
4972: --oe_debug_pub.add('here 5: ', 2);
4973:
4974: l_count := OE_BULK_CACHE.Load_Item

Line 4977: (OE_BULK_WF_UTIL.G_LINE_INDEX)

4973:
4974: l_count := OE_BULK_CACHE.Load_Item
4975: ( p_key1
4976: => OE_BULK_ORDER_PVT.G_LINE_REC.inventory_item_id
4977: (OE_BULK_WF_UTIL.G_LINE_INDEX)
4978: ,p_key2
4979: => OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id
4980: (OE_BULK_WF_UTIL.G_LINE_INDEX));
4981:

Line 4980: (OE_BULK_WF_UTIL.G_LINE_INDEX));

4976: => OE_BULK_ORDER_PVT.G_LINE_REC.inventory_item_id
4977: (OE_BULK_WF_UTIL.G_LINE_INDEX)
4978: ,p_key2
4979: => OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id
4980: (OE_BULK_WF_UTIL.G_LINE_INDEX));
4981:
4982: --oe_debug_pub.add('here 5-1: '
4983: --|| OE_BULK_ORDER_PVT.G_LINE_REC.ordered_item_id
4984: --(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);

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

4980: (OE_BULK_WF_UTIL.G_LINE_INDEX));
4981:
4982: --oe_debug_pub.add('here 5-1: '
4983: --|| OE_BULK_ORDER_PVT.G_LINE_REC.ordered_item_id
4984: --(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
4985:
4986: IF g_debug_call > 0 THEN
4987: G_DEBUG_MSG := G_DEBUG_MSG || '208';
4988: END IF;

Line 4991: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

4987: G_DEBUG_MSG := G_DEBUG_MSG || '208';
4988: END IF;
4989:
4990: OE_BULK_ORDER_PVT.G_LINE_REC.item_description
4991: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
4992: OE_BULK_CACHE.G_ITEM_TBL(l_count).item_description;
4993:
4994: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id
4995: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

Line 4995: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

4991: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
4992: OE_BULK_CACHE.G_ITEM_TBL(l_count).item_description;
4993:
4994: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id
4995: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
4996: OE_BULK_CACHE.G_ITEM_TBL(l_count).hazard_class_id;
4997:
4998: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code
4999: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

Line 4999: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

4995: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
4996: OE_BULK_CACHE.G_ITEM_TBL(l_count).hazard_class_id;
4997:
4998: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code
4999: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5000: OE_BULK_CACHE.G_ITEM_TBL(l_count).weight_uom_code;
5001:
5002: --oe_debug_pub.add('here 6: ', 2);
5003:

Line 5005: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5001:
5002: --oe_debug_pub.add('here 6: ', 2);
5003:
5004: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code
5005: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5006: OE_BULK_CACHE.G_ITEM_TBL(l_count).volume_uom_code;
5007:
5008: --oe_debug_pub.add('here 6-1: ', 2);
5009:

Line 5011: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5007:
5008: --oe_debug_pub.add('here 6-1: ', 2);
5009:
5010: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom
5011: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5012: OE_BULK_CACHE.G_ITEM_TBL(l_count).primary_uom_code;
5013:
5014: --oe_debug_pub.add('here 6-2: ', 2);
5015:

Line 5017: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

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

Line 5023: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

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

Line 5029: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5025:
5026: --oe_debug_pub.add('here 6-4: ', 2);
5027:
5028: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag
5029: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5030: OE_BULK_CACHE.G_ITEM_TBL(l_count).pickable_flag;
5031:
5032: --oe_debug_pub.add('here 7: ', 2);
5033: --------------- from header/ xn types --------------------

Line 5036: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5032: --oe_debug_pub.add('here 7: ', 2);
5033: --------------- from header/ xn types --------------------
5034:
5035: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id
5036: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5037: OE_Bulk_Order_PVT.g_header_rec.sold_to_contact_id
5038: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5039:
5040: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number

Line 5038: (OE_BULK_WF_UTIL.G_HEADER_INDEX);

5034:
5035: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id
5036: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5037: OE_Bulk_Order_PVT.g_header_rec.sold_to_contact_id
5038: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5039:
5040: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number
5041: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5042: OE_Bulk_Order_PVT.g_header_rec.order_number

Line 5041: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5037: OE_Bulk_Order_PVT.g_header_rec.sold_to_contact_id
5038: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5039:
5040: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number
5041: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5042: OE_Bulk_Order_PVT.g_header_rec.order_number
5043: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5044:
5045: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code

Line 5043: (OE_BULK_WF_UTIL.G_HEADER_INDEX);

5039:
5040: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number
5041: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5042: OE_Bulk_Order_PVT.g_header_rec.order_number
5043: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5044:
5045: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code
5046: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5047: OE_Bulk_Order_PVT.g_header_rec.order_date_type_code

Line 5046: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5042: OE_Bulk_Order_PVT.g_header_rec.order_number
5043: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5044:
5045: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code
5046: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5047: OE_Bulk_Order_PVT.g_header_rec.order_date_type_code
5048: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5049:
5050: --oe_debug_pub.add('here 8: ', 2);

Line 5048: (OE_BULK_WF_UTIL.G_HEADER_INDEX);

5044:
5045: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code
5046: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5047: OE_Bulk_Order_PVT.g_header_rec.order_date_type_code
5048: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5049:
5050: --oe_debug_pub.add('here 8: ', 2);
5051: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id
5052: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

Line 5052: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5048: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5049:
5050: --oe_debug_pub.add('here 8: ', 2);
5051: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id
5052: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5053: OE_Bulk_Order_PVT.g_header_rec.order_type_id
5054: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5055:
5056: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code

Line 5054: (OE_BULK_WF_UTIL.G_HEADER_INDEX);

5050: --oe_debug_pub.add('here 8: ', 2);
5051: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id
5052: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5053: OE_Bulk_Order_PVT.g_header_rec.order_type_id
5054: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5055:
5056: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code
5057: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5058: OE_Bulk_Order_PVT.g_header_rec.transactional_curr_code

Line 5057: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5053: OE_Bulk_Order_PVT.g_header_rec.order_type_id
5054: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5055:
5056: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code
5057: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5058: OE_Bulk_Order_PVT.g_header_rec.transactional_curr_code
5059: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5060:
5061: l_count := OE_BULK_CACHE.Load_Order_Type

Line 5059: (OE_BULK_WF_UTIL.G_HEADER_INDEX);

5055:
5056: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code
5057: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5058: OE_Bulk_Order_PVT.g_header_rec.transactional_curr_code
5059: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5060:
5061: l_count := OE_BULK_CACHE.Load_Order_Type
5062: ( p_key
5063: => OE_BULK_ORDER_PVT.G_HEADER_REC.order_type_id

Line 5064: (OE_BULK_WF_UTIL.G_HEADER_INDEX));

5060:
5061: l_count := OE_BULK_CACHE.Load_Order_Type
5062: ( p_key
5063: => OE_BULK_ORDER_PVT.G_HEADER_REC.order_type_id
5064: (OE_BULK_WF_UTIL.G_HEADER_INDEX));
5065:
5066: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name
5067: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5068: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_count).name;

Line 5067: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5063: => OE_BULK_ORDER_PVT.G_HEADER_REC.order_type_id
5064: (OE_BULK_WF_UTIL.G_HEADER_INDEX));
5065:
5066: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name
5067: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5068: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_count).name;
5069:
5070: --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);
5071:

Line 5070: --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);

5066: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name
5067: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5068: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_count).name;
5069:
5070: --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);
5071:
5072: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number
5073: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5074: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number

Line 5073: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

5069:
5070: --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);
5071:
5072: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number
5073: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5074: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number
5075: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5076: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5077: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||

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

5071:
5072: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number
5073: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5074: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number
5075: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5076: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5077: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5078: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5079: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||

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

5073: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5074: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number
5075: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5076: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5077: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5078: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5079: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5080: OE_BULK_ORDER_PVT.G_LINE_REC.component_number
5081: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||

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

5075: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5076: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5077: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5078: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5079: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5080: OE_BULK_ORDER_PVT.G_LINE_REC.component_number
5081: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5082: OE_BULK_ORDER_PVT.G_LINE_REC.service_number
5083: (OE_BULK_WF_UTIL.G_LINE_INDEX),'.');

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

5077: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5078: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5079: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5080: OE_BULK_ORDER_PVT.G_LINE_REC.component_number
5081: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5082: OE_BULK_ORDER_PVT.G_LINE_REC.service_number
5083: (OE_BULK_WF_UTIL.G_LINE_INDEX),'.');
5084:
5085: --oe_debug_pub.add('here 10: ', 2);

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

5079: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5080: OE_BULK_ORDER_PVT.G_LINE_REC.component_number
5081: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5082: OE_BULK_ORDER_PVT.G_LINE_REC.service_number
5083: (OE_BULK_WF_UTIL.G_LINE_INDEX),'.');
5084:
5085: --oe_debug_pub.add('here 10: ', 2);
5086:
5087: IF l_debug_level > 0 THEN

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

5086:
5087: IF l_debug_level > 0 THEN
5088: oe_debug_pub.add('eligible for shipping '||
5089: OE_BULK_ORDER_PVT.G_LINE_REC.line_id
5090: (OE_BULK_WF_UTIL.G_LINE_INDEX), 1 ) ;
5091: END IF;
5092:
5093: END IF; -- if shippable
5094:

Line 6055: OE_BULK_WF_UTIL.G_LINE_INDEX := I;

6051: LOOP
6052: IF p_line_rec.shipping_interfaced_flag(I) is NULL AND
6053: p_line_rec.shippable_flag(I) = 'Y' THEN
6054:
6055: OE_BULK_WF_UTIL.G_LINE_INDEX := I;
6056:
6057: BEGIN
6058: WF_ENGINE.HandleError
6059: (itemtype => 'OEOL',

Line 6070: OE_BULK_WF_UTIL.G_LINE_INDEX := NULL;

6066: WHEN OTHERS THEN
6067: oe_debug_pub.add('Exception caught after Wf_engine.Handle_Error',5);
6068: END; -- Erroring out the WF table
6069:
6070: OE_BULK_WF_UTIL.G_LINE_INDEX := NULL;
6071: END IF; -- lines not shipping_interfaced
6072: p_line_rec.shipping_eligible_flag(I) := null;
6073: END LOOP;
6074: