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 688: app_exception.raise_exception;

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

Line 849: app_exception.raise_exception;

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

Line 864: app_exception.raise_exception;

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

Line 1015: app_exception.raise_exception;

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

Line 1207: APP_EXCEPTION.RAISE_EXCEPTION;

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