151: L_LOCATION_ID := Null;
152: End;
153:
154: If L_LOCATION_ID is null Then
155: fnd_message.set_name('CSP','CSP_SUBINV_NO_SHIPTO_LOCATION');
156: fnd_message.set_token('SUBINV',Rec.SECONDARY_INVENTORY);
157: fnd_msg_pub.add;
158: If fnd_msg_pub.count_msg > 0 Then
159: FOR i IN REVERSE 1..fnd_msg_pub.count_msg
152: End;
153:
154: If L_LOCATION_ID is null Then
155: fnd_message.set_name('CSP','CSP_SUBINV_NO_SHIPTO_LOCATION');
156: fnd_message.set_token('SUBINV',Rec.SECONDARY_INVENTORY);
157: fnd_msg_pub.add;
158: If fnd_msg_pub.count_msg > 0 Then
159: FOR i IN REVERSE 1..fnd_msg_pub.count_msg
160: Loop
197: when no_data_found then
198: l_org_name := Null;
199: End;
200:
201: fnd_message.set_name('CSP','CSP_ORG_NO_SHIPTO_LOCATION');
202: fnd_message.set_token('ORG',l_org_name);
203: fnd_msg_pub.add;
204: If fnd_msg_pub.count_msg > 0 Then
205: FOR i IN REVERSE 1..fnd_msg_pub.count_msg
198: l_org_name := Null;
199: End;
200:
201: fnd_message.set_name('CSP','CSP_ORG_NO_SHIPTO_LOCATION');
202: fnd_message.set_token('ORG',l_org_name);
203: fnd_msg_pub.add;
204: If fnd_msg_pub.count_msg > 0 Then
205: FOR i IN REVERSE 1..fnd_msg_pub.count_msg
206: Loop