APPS.MTL_CATEGORIES_PKG dependencies on APP_EXCEPTION

Line 365: app_exception.raise_exception;

361: fetch c into recinfo;
362: if (c%notfound) then
363: close c;
364: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
365: app_exception.raise_exception;
366: end if;
367: close c;
368:
369: if ( (recinfo.STRUCTURE_ID = X_STRUCTURE_ID)

Line 464: app_exception.raise_exception;

460: ) then
461: null;
462: else
463: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
464: app_exception.raise_exception;
465: end if;
466:
467: for tlinfo in c1 loop
468: if (tlinfo.BASELANG = 'Y') then

Line 475: app_exception.raise_exception;

471: ) then
472: null;
473: else
474: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
475: app_exception.raise_exception;
476: end if;
477: end if;
478: end loop;
479:

Line 641: APP_EXCEPTION.Raise_Exception;

637: USING IN X_CATEGORY_ID, IN X_STRUCTURE_ID, OUT l_return_Status, OUT l_msg_count, OUT l_msg_data;
638:
639: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
640: FND_MESSAGE.Set_Encoded (l_msg_data);
641: APP_EXCEPTION.Raise_Exception;
642: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
643: FND_MESSAGE.Set_Encoded (l_msg_data);
644: APP_EXCEPTION.Raise_Exception;
645: END IF;

Line 644: APP_EXCEPTION.Raise_Exception;

640: FND_MESSAGE.Set_Encoded (l_msg_data);
641: APP_EXCEPTION.Raise_Exception;
642: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
643: FND_MESSAGE.Set_Encoded (l_msg_data);
644: APP_EXCEPTION.Raise_Exception;
645: END IF;
646:
647: END IF;
648:

Line 689: app_exception.raise_exception;

685: begin
686:
687: /*
688: fnd_message.set_name('INV', 'CANNOT_DELETE_RECORD');
689: app_exception.raise_exception;
690: */
691: raise_application_error( -20000, 'CANNOT_DELETE_RECORD' );
692:
693: -- This code is for future use when decided to validate

Line 850: app_exception.raise_exception;

846: fnd_message.set_token('REASON','Default category set for ' || x_upload_to_functional_area || ' functional area does not exist');
847: ELSE
848: fnd_message.set_token('REASON','Flex structure does not exist');
849: END IF;
850: app_exception.raise_exception;
851: END;
852:
853: -- find out the category_id based on the structure_id and the concat segments
854: BEGIN

Line 865: app_exception.raise_exception;

861: WHEN NO_DATA_FOUND THEN
862: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');
863: fnd_message.set_token('ROUTINE','Category Migration');
864: fnd_message.set_token('REASON','Category does not exist');
865: app_exception.raise_exception;
866: END;
867:
868: UPDATE mtl_categories_tl
869: SET description = NVL(x_description, description)

Line 1016: app_exception.raise_exception;

1012: fnd_message.set_token('REASON','Default category set for ' || x_upload_to_functional_area || ' does not exist ');
1013: else
1014: fnd_message.set_token('REASON','Flex structure does not exist ');
1015: end if;
1016: app_exception.raise_exception;
1017: END;
1018:
1019: -- IF (l_category_set_id IS NOT NULL)
1020: -- THEN

Line 1210: APP_EXCEPTION.RAISE_EXCEPTION;

1206: END LOOP;
1207: FND_MESSAGE.SET_NAME('FND','GENERIC-INTERNAL ERROR');
1208: FND_MESSAGE.SET_TOKEN('ROUTINE','Category Migration');
1209: FND_MESSAGE.SET_TOKEN('REASON',l_messages);
1210: APP_EXCEPTION.RAISE_EXCEPTION;
1211: END IF;
1212: -- END IF;
1213: END Load_Row;
1214: