APPS.CSP_TO_FORM_MOHEADERS dependencies on ORG_FREIGHT_TL

Line 155: FROM org_freight_tl

151: IF nvl(p_carrier, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
152: -- Validate whether the p_carrier exists.
153: BEGIN
154: SELECT distinct freight_code INTO l_carrier
155: FROM org_freight_tl
156: WHERE freight_code = p_carrier
157: AND organization_id = (SELECT organization_id FROM mtl_txn_request_headers
158: WHERE header_id = p_header_id);
159: EXCEPTION

Line 169: fnd_message.set_token('TABLE', 'ORG_FREIGHT_TL', FALSE);

165: WHEN OTHERS THEN
166: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
167: fnd_message.set_token('ERR_FIELD', 'p_carrier', FALSE);
168: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
169: fnd_message.set_token('TABLE', 'ORG_FREIGHT_TL', FALSE);
170: FND_MSG_PUB.ADD;
171: RAISE EXCP_USER_DEFINED;
172: END;
173: END IF;

Line 230: FROM org_freight_tl

226: IF nvl(p_carrier, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
227: -- Validate whether the p_carrier exists.
228: BEGIN
229: SELECT distinct freight_code INTO l_carrier
230: FROM org_freight_tl
231: WHERE freight_code = p_carrier
232: AND organization_id = (SELECT organization_id FROM mtl_txn_request_headers
233: WHERE header_id = p_header_id);
234: EXCEPTION

Line 244: fnd_message.set_token('TABLE', 'ORG_FREIGHT_TL', FALSE);

240: WHEN OTHERS THEN
241: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
242: fnd_message.set_token('ERR_FIELD', 'p_carrier', FALSE);
243: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
244: fnd_message.set_token('TABLE', 'ORG_FREIGHT_TL', FALSE);
245: FND_MSG_PUB.ADD;
246: RAISE EXCP_USER_DEFINED;
247: END;
248: END IF;