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 688: fnd_message.set_name('INV', 'CANNOT_DELETE_RECORD');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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