72: return;
73: end if;
74: if (p_requested_quantity < 0) then
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: fnd_message.set_name('EAM','EAM_MR_NEGATIVE_REQ_QTY');
77: fnd_message.set_token('REQUESTED', to_char(p_requested_quantity) );
78: fnd_msg_pub.add;
79: FND_MSG_PUB.Count_And_Get(
80: p_count => x_msg_count,
73: end if;
74: if (p_requested_quantity < 0) then
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: fnd_message.set_name('EAM','EAM_MR_NEGATIVE_REQ_QTY');
77: fnd_message.set_token('REQUESTED', to_char(p_requested_quantity) );
78: fnd_msg_pub.add;
79: FND_MSG_PUB.Count_And_Get(
80: p_count => x_msg_count,
81: p_data => x_msg_data);
153: FND_MSG_PUB.Count_And_Get(
154: p_count => x_msg_count,
155: p_data => x_msg_data);
156: if (x_msg_count = 0 ) then --means not on stack, add it.
157: fnd_message.set_name('EAM','EAM_GENERIC_ERROR');
158: fnd_message.set_token('EAM_ERROR', l_msg_data );
159: fnd_msg_pub.add;
160: end if;
161: end if;
154: p_count => x_msg_count,
155: p_data => x_msg_data);
156: if (x_msg_count = 0 ) then --means not on stack, add it.
157: fnd_message.set_name('EAM','EAM_GENERIC_ERROR');
158: fnd_message.set_token('EAM_ERROR', l_msg_data );
159: fnd_msg_pub.add;
160: end if;
161: end if;
162:
166: where header_id = (select header_id from mtl_txn_request_headers
167: where request_number = x_request_number
168: and organization_id = p_organization_id);
169: if (l_partial_qty = 0) then
170: fnd_message.set_name('EAM','EAM_MR_NO_MATERIAL_AVAILABLE');
171: fnd_msg_pub.add;
172: else
173: fnd_message.set_name('EAM','EAM_MR_PARTIAL_ALLOCATION');
174: fnd_message.set_token('PARTIAL', to_char(l_partial_qty) );
169: if (l_partial_qty = 0) then
170: fnd_message.set_name('EAM','EAM_MR_NO_MATERIAL_AVAILABLE');
171: fnd_msg_pub.add;
172: else
173: fnd_message.set_name('EAM','EAM_MR_PARTIAL_ALLOCATION');
174: fnd_message.set_token('PARTIAL', to_char(l_partial_qty) );
175: fnd_message.set_token('REQUESTED', to_char(p_requested_quantity));
176: fnd_msg_pub.add;
177: end if;
170: fnd_message.set_name('EAM','EAM_MR_NO_MATERIAL_AVAILABLE');
171: fnd_msg_pub.add;
172: else
173: fnd_message.set_name('EAM','EAM_MR_PARTIAL_ALLOCATION');
174: fnd_message.set_token('PARTIAL', to_char(l_partial_qty) );
175: fnd_message.set_token('REQUESTED', to_char(p_requested_quantity));
176: fnd_msg_pub.add;
177: end if;
178: end if;
171: fnd_msg_pub.add;
172: else
173: fnd_message.set_name('EAM','EAM_MR_PARTIAL_ALLOCATION');
174: fnd_message.set_token('PARTIAL', to_char(l_partial_qty) );
175: fnd_message.set_token('REQUESTED', to_char(p_requested_quantity));
176: fnd_msg_pub.add;
177: end if;
178: end if;
179:
178: end if;
179:
180: if (x_return_status = FND_API.G_RET_STS_ERROR) then
181: if l_msg_data is null then --should not happen, just a safeguard
182: fnd_message.set_name('EAM','EAM_MR_ALLOCATION_FAILED');
183: fnd_msg_pub.add;
184: end if;
185: RAISE FND_API.G_EXC_ERROR;
186: end if;