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
196: when no_data_found then
197: l_org_name := Null;
198: End;
199:
200: fnd_message.set_name('CSP','CSP_ORG_NO_SHIPTO_LOCATION');
201: fnd_message.set_token('ORG',l_org_name);
202: fnd_msg_pub.add;
203: If fnd_msg_pub.count_msg > 0 Then
204: FOR i IN REVERSE 1..fnd_msg_pub.count_msg
197: l_org_name := Null;
198: End;
199:
200: fnd_message.set_name('CSP','CSP_ORG_NO_SHIPTO_LOCATION');
201: fnd_message.set_token('ORG',l_org_name);
202: fnd_msg_pub.add;
203: If fnd_msg_pub.count_msg > 0 Then
204: FOR i IN REVERSE 1..fnd_msg_pub.count_msg
205: Loop