DBA Data[Home] [Help]

APPS.CSP_PL_SHIP_UTIL dependencies on MTL_PARAMETERS

Line 218: from mtl_parameters

214: ELSE
215: IF p_validation_level = fnd_api.g_valid_level_full THEN
216: BEGIN
217: select organization_id into l_check_existence
218: from mtl_parameters
219: where organization_id = p_organization_id;
220: EXCEPTION
221: WHEN NO_DATA_FOUND THEN
222: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');

Line 229: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);

225: WHEN OTHERS THEN
226: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
227: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
228: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
229: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
230: FND_MSG_PUB.ADD;
231: RAISE EXCP_USER_DEFINED;
232: END;
233: END IF;

Line 641: from mtl_parameters

637: ELSE
638: IF p_validation_level = fnd_api.g_valid_level_full THEN
639: BEGIN
640: select organization_id into l_check_existence
641: from mtl_parameters
642: where organization_id = p_organization_id;
643: EXCEPTION
644: WHEN NO_DATA_FOUND THEN
645: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');

Line 652: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);

648: WHEN OTHERS THEN
649: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
650: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
651: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
652: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
653: FND_MSG_PUB.ADD;
654: RAISE EXCP_USER_DEFINED;
655: END;
656: END IF;

Line 940: from mtl_parameters

936: ELSE
937: IF p_validation_level = fnd_api.g_valid_level_full THEN
938: BEGIN
939: select organization_id into l_check_existence
940: from mtl_parameters
941: where organization_id = p_organization_id;
942: EXCEPTION
943: WHEN NO_DATA_FOUND THEN
944: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');

Line 951: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);

947: WHEN OTHERS THEN
948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
949: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
950: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
951: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
952: FND_MSG_PUB.ADD;
953: RAISE EXCP_USER_DEFINED;
954: END;
955: END IF;