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.ENG_REV_COMPONENT_UTIL dependencies on FND_API

Line 29: IF l_rev_component_rec.supply_subinventory = FND_API.G_MISS_CHAR THEN

25: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=
26: p_Rev_Comp_Unexp_Rec;
27: BEGIN
28:
29: IF l_rev_component_rec.supply_subinventory = FND_API.G_MISS_CHAR THEN
30: l_rev_component_rec.supply_subinventory := NULL;
31: END IF;
32:
33: IF l_rev_component_rec.required_for_revenue = FND_API.G_MISS_NUM THEN

Line 33: IF l_rev_component_rec.required_for_revenue = FND_API.G_MISS_NUM THEN

29: IF l_rev_component_rec.supply_subinventory = FND_API.G_MISS_CHAR THEN
30: l_rev_component_rec.supply_subinventory := NULL;
31: END IF;
32:
33: IF l_rev_component_rec.required_for_revenue = FND_API.G_MISS_NUM THEN
34: l_rev_component_rec.required_for_revenue := NULL;
35: END IF;
36:
37: IF l_rev_component_rec.maximum_allowed_quantity = FND_API.G_MISS_NUM THEN

Line 37: IF l_rev_component_rec.maximum_allowed_quantity = FND_API.G_MISS_NUM THEN

33: IF l_rev_component_rec.required_for_revenue = FND_API.G_MISS_NUM THEN
34: l_rev_component_rec.required_for_revenue := NULL;
35: END IF;
36:
37: IF l_rev_component_rec.maximum_allowed_quantity = FND_API.G_MISS_NUM THEN
38: l_rev_component_rec.maximum_allowed_quantity := NULL;
39: END IF;
40:
41:

Line 42: IF l_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN

38: l_rev_component_rec.maximum_allowed_quantity := NULL;
39: END IF;
40:
41:
42: IF l_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN
43: l_rev_component_rec.wip_supply_type := NULL;
44: END IF;
45:
46: IF l_rev_component_rec.location_name = FND_API.G_MISS_NUM THEN

Line 46: IF l_rev_component_rec.location_name = FND_API.G_MISS_NUM THEN

42: IF l_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN
43: l_rev_component_rec.wip_supply_type := NULL;
44: END IF;
45:
46: IF l_rev_component_rec.location_name = FND_API.G_MISS_NUM THEN
47: l_rev_comp_unexp_rec.supply_locator_id := NULL;
48: END IF;
49:
50: IF l_rev_component_rec.operation_sequence_number = FND_API.G_MISS_NUM THEN

Line 50: IF l_rev_component_rec.operation_sequence_number = FND_API.G_MISS_NUM THEN

46: IF l_rev_component_rec.location_name = FND_API.G_MISS_NUM THEN
47: l_rev_comp_unexp_rec.supply_locator_id := NULL;
48: END IF;
49:
50: IF l_rev_component_rec.operation_sequence_number = FND_API.G_MISS_NUM THEN
51: l_rev_component_rec.operation_sequence_number := NULL;
52: END IF;
53:
54: IF l_rev_component_rec.item_sequence_number = FND_API.G_MISS_NUM THEN

Line 54: IF l_rev_component_rec.item_sequence_number = FND_API.G_MISS_NUM THEN

50: IF l_rev_component_rec.operation_sequence_number = FND_API.G_MISS_NUM THEN
51: l_rev_component_rec.operation_sequence_number := NULL;
52: END IF;
53:
54: IF l_rev_component_rec.item_sequence_number = FND_API.G_MISS_NUM THEN
55: l_rev_component_rec.item_sequence_number := NULL;
56: END IF;
57:
58: IF l_rev_component_rec.quantity_per_assembly = FND_API.G_MISS_NUM THEN

Line 58: IF l_rev_component_rec.quantity_per_assembly = FND_API.G_MISS_NUM THEN

54: IF l_rev_component_rec.item_sequence_number = FND_API.G_MISS_NUM THEN
55: l_rev_component_rec.item_sequence_number := NULL;
56: END IF;
57:
58: IF l_rev_component_rec.quantity_per_assembly = FND_API.G_MISS_NUM THEN
59: l_rev_component_rec.quantity_per_assembly := NULL;
60: END IF;
61:
62: IF l_rev_component_rec.projected_yield = FND_API.G_MISS_NUM THEN

Line 62: IF l_rev_component_rec.projected_yield = FND_API.G_MISS_NUM THEN

58: IF l_rev_component_rec.quantity_per_assembly = FND_API.G_MISS_NUM THEN
59: l_rev_component_rec.quantity_per_assembly := NULL;
60: END IF;
61:
62: IF l_rev_component_rec.projected_yield = FND_API.G_MISS_NUM THEN
63: l_rev_component_rec.projected_yield := NULL;
64: END IF;
65:
66: IF l_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN

Line 66: IF l_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN

62: IF l_rev_component_rec.projected_yield = FND_API.G_MISS_NUM THEN
63: l_rev_component_rec.projected_yield := NULL;
64: END IF;
65:
66: IF l_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN
67: l_rev_component_rec.comments := NULL;
68: END IF;
69:
70: IF l_rev_component_rec.start_effective_date = FND_API.G_MISS_DATE THEN

Line 70: IF l_rev_component_rec.start_effective_date = FND_API.G_MISS_DATE THEN

66: IF l_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN
67: l_rev_component_rec.comments := NULL;
68: END IF;
69:
70: IF l_rev_component_rec.start_effective_date = FND_API.G_MISS_DATE THEN
71: l_rev_component_rec.start_effective_date := NULL;
72: END IF;
73:
74: IF l_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN

Line 74: IF l_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN

70: IF l_rev_component_rec.start_effective_date = FND_API.G_MISS_DATE THEN
71: l_rev_component_rec.start_effective_date := NULL;
72: END IF;
73:
74: IF l_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN
75: l_rev_component_rec.disable_date := NULL;
76: END IF;
77:
78: IF l_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 78: IF l_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN

74: IF l_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN
75: l_rev_component_rec.disable_date := NULL;
76: END IF;
77:
78: IF l_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
79: l_rev_component_rec.attribute_category := NULL;
80: END IF;
81:
82: IF l_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 82: IF l_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

78: IF l_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
79: l_rev_component_rec.attribute_category := NULL;
80: END IF;
81:
82: IF l_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
83: l_rev_component_rec.attribute1 := NULL;
84: END IF;
85:
86: IF l_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 86: IF l_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

82: IF l_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
83: l_rev_component_rec.attribute1 := NULL;
84: END IF;
85:
86: IF l_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
87: l_rev_component_rec.attribute2 := NULL;
88: END IF;
89:
90: IF l_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 90: IF l_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

86: IF l_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
87: l_rev_component_rec.attribute2 := NULL;
88: END IF;
89:
90: IF l_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
91: l_rev_component_rec.attribute3 := NULL;
92: END IF;
93:
94: IF l_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 94: IF l_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

90: IF l_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
91: l_rev_component_rec.attribute3 := NULL;
92: END IF;
93:
94: IF l_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
95: l_rev_component_rec.attribute4 := NULL;
96: END IF;
97:
98: IF l_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 98: IF l_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

94: IF l_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
95: l_rev_component_rec.attribute4 := NULL;
96: END IF;
97:
98: IF l_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
99: l_rev_component_rec.attribute5 := NULL;
100: END IF;
101:
102: IF l_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 102: IF l_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

98: IF l_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
99: l_rev_component_rec.attribute5 := NULL;
100: END IF;
101:
102: IF l_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
103: l_rev_component_rec.attribute6 := NULL;
104: END IF;
105:
106: IF l_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 106: IF l_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

102: IF l_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
103: l_rev_component_rec.attribute6 := NULL;
104: END IF;
105:
106: IF l_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
107: l_rev_component_rec.attribute7 := NULL;
108: END IF;
109:
110: IF l_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 110: IF l_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

106: IF l_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
107: l_rev_component_rec.attribute7 := NULL;
108: END IF;
109:
110: IF l_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
111: l_rev_component_rec.attribute8 := NULL;
112: END IF;
113:
114: IF l_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 114: IF l_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

110: IF l_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
111: l_rev_component_rec.attribute8 := NULL;
112: END IF;
113:
114: IF l_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
115: l_rev_component_rec.attribute9 := NULL;
116: END IF;
117:
118: IF l_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 118: IF l_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

114: IF l_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
115: l_rev_component_rec.attribute9 := NULL;
116: END IF;
117:
118: IF l_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
119: l_rev_component_rec.attribute10 := NULL;
120: END IF;
121:
122: IF l_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 122: IF l_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

118: IF l_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
119: l_rev_component_rec.attribute10 := NULL;
120: END IF;
121:
122: IF l_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
123: l_rev_component_rec.attribute11 := NULL;
124: END IF;
125:
126: IF l_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 126: IF l_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN

122: IF l_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
123: l_rev_component_rec.attribute11 := NULL;
124: END IF;
125:
126: IF l_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
127: l_rev_component_rec.attribute12 := NULL;
128: END IF;
129:
130: IF l_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 130: IF l_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN

126: IF l_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
127: l_rev_component_rec.attribute12 := NULL;
128: END IF;
129:
130: IF l_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
131: l_rev_component_rec.attribute13 := NULL;
132: END IF;
133:
134: IF l_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 134: IF l_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN

130: IF l_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
131: l_rev_component_rec.attribute13 := NULL;
132: END IF;
133:
134: IF l_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
135: l_rev_component_rec.attribute14 := NULL;
136: END IF;
137:
138: IF l_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 138: IF l_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN

134: IF l_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
135: l_rev_component_rec.attribute14 := NULL;
136: END IF;
137:
138: IF l_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
139: l_rev_component_rec.attribute15 := NULL;
140: END IF;
141:
142: IF l_rev_component_rec.planning_percent = FND_API.G_MISS_NUM THEN

Line 142: IF l_rev_component_rec.planning_percent = FND_API.G_MISS_NUM THEN

138: IF l_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
139: l_rev_component_rec.attribute15 := NULL;
140: END IF;
141:
142: IF l_rev_component_rec.planning_percent = FND_API.G_MISS_NUM THEN
143: l_rev_component_rec.planning_percent := NULL;
144: END IF;
145:
146: IF l_rev_component_rec.quantity_related = FND_API.G_MISS_NUM THEN

Line 146: IF l_rev_component_rec.quantity_related = FND_API.G_MISS_NUM THEN

142: IF l_rev_component_rec.planning_percent = FND_API.G_MISS_NUM THEN
143: l_rev_component_rec.planning_percent := NULL;
144: END IF;
145:
146: IF l_rev_component_rec.quantity_related = FND_API.G_MISS_NUM THEN
147: l_rev_component_rec.quantity_related := NULL;
148: END IF;
149:
150: IF l_rev_component_rec.so_basis = FND_API.G_MISS_NUM THEN

Line 150: IF l_rev_component_rec.so_basis = FND_API.G_MISS_NUM THEN

146: IF l_rev_component_rec.quantity_related = FND_API.G_MISS_NUM THEN
147: l_rev_component_rec.quantity_related := NULL;
148: END IF;
149:
150: IF l_rev_component_rec.so_basis = FND_API.G_MISS_NUM THEN
151: l_rev_component_rec.so_basis := NULL;
152: END IF;
153:
154: IF l_rev_component_rec.optional = FND_API.G_MISS_NUM THEN

Line 154: IF l_rev_component_rec.optional = FND_API.G_MISS_NUM THEN

150: IF l_rev_component_rec.so_basis = FND_API.G_MISS_NUM THEN
151: l_rev_component_rec.so_basis := NULL;
152: END IF;
153:
154: IF l_rev_component_rec.optional = FND_API.G_MISS_NUM THEN
155: l_rev_component_rec.optional := NULL;
156: END IF;
157:
158: IF l_rev_component_rec.mutually_exclusive = FND_API.G_MISS_NUM THEN

Line 158: IF l_rev_component_rec.mutually_exclusive = FND_API.G_MISS_NUM THEN

154: IF l_rev_component_rec.optional = FND_API.G_MISS_NUM THEN
155: l_rev_component_rec.optional := NULL;
156: END IF;
157:
158: IF l_rev_component_rec.mutually_exclusive = FND_API.G_MISS_NUM THEN
159: l_rev_component_rec.mutually_exclusive := NULL;
160: END IF;
161:
162: IF l_rev_component_rec.include_in_cost_rollup = FND_API.G_MISS_NUM THEN

Line 162: IF l_rev_component_rec.include_in_cost_rollup = FND_API.G_MISS_NUM THEN

158: IF l_rev_component_rec.mutually_exclusive = FND_API.G_MISS_NUM THEN
159: l_rev_component_rec.mutually_exclusive := NULL;
160: END IF;
161:
162: IF l_rev_component_rec.include_in_cost_rollup = FND_API.G_MISS_NUM THEN
163: l_rev_component_rec.include_in_cost_rollup := NULL;
164: END IF;
165:
166: IF l_rev_component_rec.check_atp = FND_API.G_MISS_NUM THEN

Line 166: IF l_rev_component_rec.check_atp = FND_API.G_MISS_NUM THEN

162: IF l_rev_component_rec.include_in_cost_rollup = FND_API.G_MISS_NUM THEN
163: l_rev_component_rec.include_in_cost_rollup := NULL;
164: END IF;
165:
166: IF l_rev_component_rec.check_atp = FND_API.G_MISS_NUM THEN
167: l_rev_component_rec.check_atp := NULL;
168: END IF;
169:
170: IF l_rev_component_rec.shipping_allowed = FND_API.G_MISS_NUM THEN

Line 170: IF l_rev_component_rec.shipping_allowed = FND_API.G_MISS_NUM THEN

166: IF l_rev_component_rec.check_atp = FND_API.G_MISS_NUM THEN
167: l_rev_component_rec.check_atp := NULL;
168: END IF;
169:
170: IF l_rev_component_rec.shipping_allowed = FND_API.G_MISS_NUM THEN
171: l_rev_component_rec.shipping_allowed := NULL;
172: END IF;
173:
174: IF l_rev_component_rec.required_to_ship = FND_API.G_MISS_NUM THEN

Line 174: IF l_rev_component_rec.required_to_ship = FND_API.G_MISS_NUM THEN

170: IF l_rev_component_rec.shipping_allowed = FND_API.G_MISS_NUM THEN
171: l_rev_component_rec.shipping_allowed := NULL;
172: END IF;
173:
174: IF l_rev_component_rec.required_to_ship = FND_API.G_MISS_NUM THEN
175: l_rev_component_rec.required_to_ship := NULL;
176: END IF;
177:
178: IF l_rev_component_rec.include_on_ship_docs = FND_API.G_MISS_NUM THEN

Line 178: IF l_rev_component_rec.include_on_ship_docs = FND_API.G_MISS_NUM THEN

174: IF l_rev_component_rec.required_to_ship = FND_API.G_MISS_NUM THEN
175: l_rev_component_rec.required_to_ship := NULL;
176: END IF;
177:
178: IF l_rev_component_rec.include_on_ship_docs = FND_API.G_MISS_NUM THEN
179: l_rev_component_rec.include_on_ship_docs := NULL;
180: END IF;
181:
182: IF l_rev_component_rec.minimum_allowed_quantity = FND_API.G_MISS_NUM THEN

Line 182: IF l_rev_component_rec.minimum_allowed_quantity = FND_API.G_MISS_NUM THEN

178: IF l_rev_component_rec.include_on_ship_docs = FND_API.G_MISS_NUM THEN
179: l_rev_component_rec.include_on_ship_docs := NULL;
180: END IF;
181:
182: IF l_rev_component_rec.minimum_allowed_quantity = FND_API.G_MISS_NUM THEN
183: l_rev_component_rec.minimum_allowed_quantity := NULL;
184: END IF;
185:
186: x_Rev_Component_Rec := l_rev_component_rec;

Line 220: DECODE(p_rev_comp_Unexp_rec.supply_locator_id, FND_API.G_MISS_NUM,

216: , REQUIRED_FOR_REVENUE = p_rev_component_rec.required_for_revenue
217: , HIGH_QUANTITY = p_rev_component_rec.maximum_allowed_quantity
218: , WIP_SUPPLY_TYPE = p_rev_component_rec.wip_supply_type
219: , SUPPLY_LOCATOR_ID =
220: DECODE(p_rev_comp_Unexp_rec.supply_locator_id, FND_API.G_MISS_NUM,
221: NULL, p_rev_comp_Unexp_rec.supply_locator_id)
222: , OPERATION_SEQ_NUM =
223: DECODE(p_rev_component_rec.new_operation_sequence_number,
224: NULL,p_rev_component_rec.operation_sequence_number,

Line 274: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

270: p_rev_component_rec.to_end_item_unit_number
271: WHERE COMPONENT_SEQUENCE_ID = p_Rev_Comp_Unexp_Rec.component_sequence_id
272: ;
273:
274: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
275:
276: EXCEPTION
277:
278: WHEN OTHERS THEN

Line 294: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

290: );
291: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
292: END IF;
293:
294: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
295:
296: END Update_Row;
297:
298: /*****************************************************************************

Line 395: , DECODE(p_rev_comp_Unexp_rec.supply_locator_id, FND_API.G_MISS_NUM,

391: , p_rev_component_rec.maximum_allowed_quantity
392: , p_rev_comp_Unexp_rec.component_sequence_id
393: , Bom_Globals.Get_Prog_AppId
394: , p_rev_component_rec.wip_supply_type
395: , DECODE(p_rev_comp_Unexp_rec.supply_locator_id, FND_API.G_MISS_NUM,
396: NULL, p_rev_comp_Unexp_rec.supply_locator_id)
397: , p_rev_comp_Unexp_rec.bom_item_type
398: , p_rev_component_rec.operation_sequence_number
399: , p_rev_comp_Unexp_rec.component_item_id

Line 453: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

449: , p_rev_component_rec.from_end_item_unit_number
450: , p_rev_component_rec.to_end_item_unit_number
451: );
452:
453: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
454:
455: EXCEPTION
456:
457: WHEN OTHERS THEN

Line 474: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

470: );
471: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
472: END IF;
473:
474: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
475:
476: END Insert_Row;
477:
478: /****************************************************************************

Line 522: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

518:
519: DELETE from bom_substitute_components
520: WHERE component_Sequence_id = p_component_sequence_id;
521:
522: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
523: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
524:
525: EXCEPTION
526:

Line 539: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

535: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
536: );
537: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
538: END IF;
539: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
540: END Delete_Row;
541:
542: -- Function Query_Row
543:

Line 671: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR) =

667: WHERE component_item_id = p_component_item_id
668: AND effectivity_date = p_effectivity_date
669: AND operation_seq_num = p_operation_sequence_number
670: AND bill_sequence_id = p_bill_sequence_id
671: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR) =
672: NVL(p_from_end_item_number, FND_API.G_MISS_CHAR);
673: --dbms_output.put_line('Finished querying and assigning component record . . .');
674:
675: x_Return_Status := Bom_Globals.G_RECORD_FOUND;

Line 672: NVL(p_from_end_item_number, FND_API.G_MISS_CHAR);

668: AND effectivity_date = p_effectivity_date
669: AND operation_seq_num = p_operation_sequence_number
670: AND bill_sequence_id = p_bill_sequence_id
671: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR) =
672: NVL(p_from_end_item_number, FND_API.G_MISS_CHAR);
673: --dbms_output.put_line('Finished querying and assigning component record . . .');
674:
675: x_Return_Status := Bom_Globals.G_RECORD_FOUND;
676: x_Rev_Component_Rec := l_rev_component_rec;

Line 691: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

687: l_err_text := G_PKG_NAME || ' Utility (Component Query Row) '
688: || substrb(SQLERRM,1,200);
689: --dbms_output.put_line('Unexpected Error: ' || l_err_text);
690:
691: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
692:
693: END Query_Row;
694:
695: PROCEDURE Cancel_Component( p_component_sequence_id IN NUMBER

Line 743: l_return_status := FND_API.G_RET_STS_SUCCESS;

739:
740: BEGIN
741: l_rev_component_rec := p_rev_component_rec;
742: l_rev_comp_unexp_rec := p_rev_comp_unexp_rec;
743: l_return_status := FND_API.G_RET_STS_SUCCESS;
744:
745: IF l_Rev_Component_Rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE THEN
746:
747: --dbms_output.put_line('Test Harness: Executing Insert Row. . . ');