eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_CATEGORIES_PKG dependencies on FND_MESSAGE

Line 364: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

360: open c;
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:

Line 463: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

459: -- OR ((recinfo.REQUEST_ID is null) AND (X_REQUEST_ID is null)))
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

Line 474: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

470: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
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;

Line 640: FND_MESSAGE.Set_Encoded (l_msg_data);

636: ' END;'
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;

Line 643: FND_MESSAGE.Set_Encoded (l_msg_data);

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;
646:
647: END IF;

Line 687: fnd_message.set_name('INV', 'CANNOT_DELETE_RECORD');

683: ) is
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:

Line 842: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');

838: AND LANGUAGE = 'US'; -- userenv('LANG'); Bug 6859576 */
839: END IF;
840: EXCEPTION
841: WHEN NO_DATA_FOUND THEN
842: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');
843: fnd_message.set_token('ROUTINE','Category Migration');
844: IF x_upload_to_functional_area = 'Y' THEN
845: fnd_message.set_token('REASON','Default category set for ' || x_upload_to_functional_area || ' functional area does not exist');
846: ELSE

Line 843: fnd_message.set_token('ROUTINE','Category Migration');

839: END IF;
840: EXCEPTION
841: WHEN NO_DATA_FOUND THEN
842: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');
843: fnd_message.set_token('ROUTINE','Category Migration');
844: IF x_upload_to_functional_area = 'Y' THEN
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');

Line 845: fnd_message.set_token('REASON','Default category set for ' || x_upload_to_functional_area || ' functional area does not exist');

841: WHEN NO_DATA_FOUND THEN
842: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');
843: fnd_message.set_token('ROUTINE','Category Migration');
844: IF x_upload_to_functional_area = 'Y' THEN
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;

Line 847: fnd_message.set_token('REASON','Flex structure does not exist');

843: fnd_message.set_token('ROUTINE','Category Migration');
844: IF x_upload_to_functional_area = 'Y' THEN
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:

Line 861: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');

857: WHERE structure_id = l_structure_id
858: AND concatenated_segments = x_category_name;
859: 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;

Line 862: fnd_message.set_token('ROUTINE','Category Migration');

858: AND concatenated_segments = x_category_name;
859: 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:

Line 863: fnd_message.set_token('REASON','Category does not exist');

859: 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

Line 1008: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');

1004: END IF;
1005:
1006: EXCEPTION
1007: WHEN NO_DATA_FOUND THEN
1008: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');
1009: fnd_message.set_token('ROUTINE','Category Migration');
1010: if x_upload_to_functional_area = '-1' then
1011: fnd_message.set_token('REASON','Default category set for ' || x_upload_to_functional_area || ' does not exist ');
1012: else

Line 1009: fnd_message.set_token('ROUTINE','Category Migration');

1005:
1006: EXCEPTION
1007: WHEN NO_DATA_FOUND THEN
1008: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');
1009: fnd_message.set_token('ROUTINE','Category Migration');
1010: if x_upload_to_functional_area = '-1' then
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 ');

Line 1011: fnd_message.set_token('REASON','Default category set for ' || x_upload_to_functional_area || ' does not exist ');

1007: WHEN NO_DATA_FOUND THEN
1008: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');
1009: fnd_message.set_token('ROUTINE','Category Migration');
1010: if x_upload_to_functional_area = '-1' then
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;

Line 1013: fnd_message.set_token('REASON','Flex structure does not exist ');

1009: fnd_message.set_token('ROUTINE','Category Migration');
1010: if x_upload_to_functional_area = '-1' then
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:

Line 1150: FND_MESSAGE.SET_NAME('FND','GENERIC-INTERNAL ERROR');

1146: P_CATEGORY_REC => l_category_rec,
1147: X_CATEGORY_ID => l_new_catg_id ) ;
1148:
1149: ELSE
1150: FND_MESSAGE.SET_NAME('FND','GENERIC-INTERNAL ERROR');
1151: FND_MESSAGE.SET_TOKEN('ROUTINE','Category Migration');
1152: FND_MESSAGE.SET_TOKEN('REASON','Disabled category cannot be created');
1153: END IF; -- IF (DISABLE_DATE > SYSDATE) THEN
1154:

Line 1151: FND_MESSAGE.SET_TOKEN('ROUTINE','Category Migration');

1147: X_CATEGORY_ID => l_new_catg_id ) ;
1148:
1149: ELSE
1150: FND_MESSAGE.SET_NAME('FND','GENERIC-INTERNAL ERROR');
1151: FND_MESSAGE.SET_TOKEN('ROUTINE','Category Migration');
1152: FND_MESSAGE.SET_TOKEN('REASON','Disabled category cannot be created');
1153: END IF; -- IF (DISABLE_DATE > SYSDATE) THEN
1154:
1155: ELSE

Line 1152: FND_MESSAGE.SET_TOKEN('REASON','Disabled category cannot be created');

1148:
1149: ELSE
1150: FND_MESSAGE.SET_NAME('FND','GENERIC-INTERNAL ERROR');
1151: FND_MESSAGE.SET_TOKEN('ROUTINE','Category Migration');
1152: FND_MESSAGE.SET_TOKEN('REASON','Disabled category cannot be created');
1153: END IF; -- IF (DISABLE_DATE > SYSDATE) THEN
1154:
1155: ELSE
1156:

Line 1175: FND_MESSAGE.SET_NAME('FND','GENERIC-INTERNAL ERROR');

1171: err_text,
1172: l_structure_id); /*Added l_structure_id for bug 8288281*/
1173: IF(l_flex_status <> 0)
1174: THEN
1175: FND_MESSAGE.SET_NAME('FND','GENERIC-INTERNAL ERROR');
1176: FND_MESSAGE.SET_TOKEN('ROUTINE','Category Migration');
1177: FND_MESSAGE.SET_TOKEN('REASON','Category to be updated not found.');
1178: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
1179: END IF;

Line 1176: FND_MESSAGE.SET_TOKEN('ROUTINE','Category Migration');

1172: l_structure_id); /*Added l_structure_id for bug 8288281*/
1173: IF(l_flex_status <> 0)
1174: THEN
1175: FND_MESSAGE.SET_NAME('FND','GENERIC-INTERNAL ERROR');
1176: FND_MESSAGE.SET_TOKEN('ROUTINE','Category Migration');
1177: FND_MESSAGE.SET_TOKEN('REASON','Category to be updated not found.');
1178: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
1179: END IF;
1180:

Line 1177: FND_MESSAGE.SET_TOKEN('REASON','Category to be updated not found.');

1173: IF(l_flex_status <> 0)
1174: THEN
1175: FND_MESSAGE.SET_NAME('FND','GENERIC-INTERNAL ERROR');
1176: FND_MESSAGE.SET_TOKEN('ROUTINE','Category Migration');
1177: FND_MESSAGE.SET_TOKEN('REASON','Category to be updated not found.');
1178: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
1179: END IF;
1180:
1181:

Line 1204: FND_MESSAGE.SET_NAME('FND','GENERIC-INTERNAL ERROR');

1200: , p_data => l_msg_data);
1201: FOR K IN 1 .. l_msg_count LOOP
1202: l_messages := l_messages || fnd_msg_pub.get( p_msg_index => k, p_encoded => 'F') || ';';
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;

Line 1205: FND_MESSAGE.SET_TOKEN('ROUTINE','Category Migration');

1201: FOR K IN 1 .. l_msg_count LOOP
1202: l_messages := l_messages || fnd_msg_pub.get( p_msg_index => k, p_encoded => 'F') || ';';
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;

Line 1206: FND_MESSAGE.SET_TOKEN('REASON',l_messages);

1202: l_messages := l_messages || fnd_msg_pub.get( p_msg_index => k, p_encoded => 'F') || ';';
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;