43: x_ship_to_org_id := l_site_use_id;
44: Exception
45: When Others Then
46: x_ship_to_org_id := NULL;
47: fnd_message.set_name ('ONT', 'OE_OI_ORG_NOT_FOUND');
48: fnd_message.set_token ('SITE_USAGE', 'SHIP-TO');
49: fnd_message.set_token ('ADDRESS_ID', p_address_id);
50: oe_msg_pub.add;
51: End Get_Ship_To_Org_Id;
44: Exception
45: When Others Then
46: x_ship_to_org_id := NULL;
47: fnd_message.set_name ('ONT', 'OE_OI_ORG_NOT_FOUND');
48: fnd_message.set_token ('SITE_USAGE', 'SHIP-TO');
49: fnd_message.set_token ('ADDRESS_ID', p_address_id);
50: oe_msg_pub.add;
51: End Get_Ship_To_Org_Id;
52:
45: When Others Then
46: x_ship_to_org_id := NULL;
47: fnd_message.set_name ('ONT', 'OE_OI_ORG_NOT_FOUND');
48: fnd_message.set_token ('SITE_USAGE', 'SHIP-TO');
49: fnd_message.set_token ('ADDRESS_ID', p_address_id);
50: oe_msg_pub.add;
51: End Get_Ship_To_Org_Id;
52:
53:
78: x_bill_to_org_id := l_site_use_id;
79: Exception
80: When Others Then
81: x_bill_to_org_id := NULL;
82: fnd_message.set_name ('ONT', 'OE_OI_ORG_NOT_FOUND');
83: fnd_message.set_token ('SITE_USAGE', 'BILL-TO');
84: fnd_message.set_token ('ADDRESS_ID', p_address_id);
85: oe_msg_pub.add;
86: End Get_Bill_To_Org_Id;
79: Exception
80: When Others Then
81: x_bill_to_org_id := NULL;
82: fnd_message.set_name ('ONT', 'OE_OI_ORG_NOT_FOUND');
83: fnd_message.set_token ('SITE_USAGE', 'BILL-TO');
84: fnd_message.set_token ('ADDRESS_ID', p_address_id);
85: oe_msg_pub.add;
86: End Get_Bill_To_Org_Id;
87:
80: When Others Then
81: x_bill_to_org_id := NULL;
82: fnd_message.set_name ('ONT', 'OE_OI_ORG_NOT_FOUND');
83: fnd_message.set_token ('SITE_USAGE', 'BILL-TO');
84: fnd_message.set_token ('ADDRESS_ID', p_address_id);
85: oe_msg_pub.add;
86: End Get_Bill_To_Org_Id;
87:
88: Procedure Get_Sold_To_Org_Id(
109: x_sold_to_org_id := l_sold_to_org_id;
110: Exception
111: When Others Then
112: x_sold_to_org_id := NULL;
113: fnd_message.set_name ('ONT', 'OE_OI_ORG_NOT_FOUND');
114: fnd_message.set_token ('SITE_USAGE', 'SOLD-TO');
115: fnd_message.set_token ('ADDRESS_ID', p_address_id);
116: oe_msg_pub.add;
117: End Get_Sold_To_Org_Id;
110: Exception
111: When Others Then
112: x_sold_to_org_id := NULL;
113: fnd_message.set_name ('ONT', 'OE_OI_ORG_NOT_FOUND');
114: fnd_message.set_token ('SITE_USAGE', 'SOLD-TO');
115: fnd_message.set_token ('ADDRESS_ID', p_address_id);
116: oe_msg_pub.add;
117: End Get_Sold_To_Org_Id;
118:
111: When Others Then
112: x_sold_to_org_id := NULL;
113: fnd_message.set_name ('ONT', 'OE_OI_ORG_NOT_FOUND');
114: fnd_message.set_token ('SITE_USAGE', 'SOLD-TO');
115: fnd_message.set_token ('ADDRESS_ID', p_address_id);
116: oe_msg_pub.add;
117: End Get_Sold_To_Org_Id;
118:
119: Procedure Get_Sold_To_Edi_Loc(
150: END IF;
151: Exception
152: When Others Then
153: x_edi_location_code := Null;
154: fnd_message.set_name ('ONT', 'OE_OI_EDI_LOC_NOT_FOUND');
155: fnd_message.set_token ('EDI_LOCATION', 'SOLD-TO');
156: fnd_message.set_token ('SITE_USAGE', p_sold_to_org_id);
157: oe_msg_pub.add;
158:
151: Exception
152: When Others Then
153: x_edi_location_code := Null;
154: fnd_message.set_name ('ONT', 'OE_OI_EDI_LOC_NOT_FOUND');
155: fnd_message.set_token ('EDI_LOCATION', 'SOLD-TO');
156: fnd_message.set_token ('SITE_USAGE', p_sold_to_org_id);
157: oe_msg_pub.add;
158:
159: End Get_Sold_To_Edi_Loc;
152: When Others Then
153: x_edi_location_code := Null;
154: fnd_message.set_name ('ONT', 'OE_OI_EDI_LOC_NOT_FOUND');
155: fnd_message.set_token ('EDI_LOCATION', 'SOLD-TO');
156: fnd_message.set_token ('SITE_USAGE', p_sold_to_org_id);
157: oe_msg_pub.add;
158:
159: End Get_Sold_To_Edi_Loc;
160:
334:
335: Exception
336: When Others Then
337: x_edi_location_code := Null;
338: fnd_message.set_name ('ONT', 'OE_OI_EDI_LOC_NOT_FOUND');
339: fnd_message.set_token ('EDI_LOCATION', 'SHIP-FROM');
340: fnd_message.set_token ('SITE_USAGE', p_ship_from_org_id);
341: oe_msg_pub.add;
342: End Get_Ship_From_Edi_Loc;
335: Exception
336: When Others Then
337: x_edi_location_code := Null;
338: fnd_message.set_name ('ONT', 'OE_OI_EDI_LOC_NOT_FOUND');
339: fnd_message.set_token ('EDI_LOCATION', 'SHIP-FROM');
340: fnd_message.set_token ('SITE_USAGE', p_ship_from_org_id);
341: oe_msg_pub.add;
342: End Get_Ship_From_Edi_Loc;
343:
336: When Others Then
337: x_edi_location_code := Null;
338: fnd_message.set_name ('ONT', 'OE_OI_EDI_LOC_NOT_FOUND');
339: fnd_message.set_token ('EDI_LOCATION', 'SHIP-FROM');
340: fnd_message.set_token ('SITE_USAGE', p_ship_from_org_id);
341: oe_msg_pub.add;
342: End Get_Ship_From_Edi_Loc;
343:
344: -- {
918: IF p_level_code = 'H' THEN
919: IF l_insert_level = 'N' THEN
920: l_raise_event := 'Y';
921: l_status := 'ERROR'; -- bug 3578502, CLN needs this recorded as an error
922: FND_MESSAGE.SET_NAME('ONT','OE_OI_CSO_REJECTED_HEADER');
923: l_message_text := FND_MESSAGE.GET;
924: END IF;
925: ELSIF p_level_code = 'L' THEN
926: IF l_insert_level = 'N'
919: IF l_insert_level = 'N' THEN
920: l_raise_event := 'Y';
921: l_status := 'ERROR'; -- bug 3578502, CLN needs this recorded as an error
922: FND_MESSAGE.SET_NAME('ONT','OE_OI_CSO_REJECTED_HEADER');
923: l_message_text := FND_MESSAGE.GET;
924: END IF;
925: ELSIF p_level_code = 'L' THEN
926: IF l_insert_level = 'N'
927: AND p_event_raised_flag = 'N' THEN
926: IF l_insert_level = 'N'
927: AND p_event_raised_flag = 'N' THEN
928: l_raise_event := 'Y';
929: l_status := 'ACTIVE';
930: FND_MESSAGE.SET_NAME('ONT','OE_OI_CSO_REJECTED_LINE');
931: l_message_text := FND_MESSAGE.GET;
932: END IF;
933: END IF;
934:
927: AND p_event_raised_flag = 'N' THEN
928: l_raise_event := 'Y';
929: l_status := 'ACTIVE';
930: FND_MESSAGE.SET_NAME('ONT','OE_OI_CSO_REJECTED_LINE');
931: l_message_text := FND_MESSAGE.GET;
932: END IF;
933: END IF;
934:
935: IF l_raise_event = 'Y' THEN