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.GR_FIELD_NAMES_PUB dependencies on GR_LABELS_TL

Line 116: FROM gr_labels_tl_v

112: FROM fnd_languages
113: WHERE installed_flag IN ('I', 'B')
114: AND language_code not in
115: (SELECT language
116: FROM gr_labels_tl_v
117: WHERE label_code = p_field_name);
118:
119: /* Label Class Codes */
120:

Line 382: GR_LABELS_TL_PKG.INSERT_ROW(

378:
379: --source lang and lang input
380:
381:
382: GR_LABELS_TL_PKG.INSERT_ROW(
383: P_COMMIT => 'F'
384: ,P_CALLED_BY_FORM => 'F'
385: ,P_LABEL_CODE => p_field_name
386: ,P_LANGUAGE => P_LANGUAGE

Line 415: -- insert a row into gr_labels_tl for every language installed

411: RAISE LBTLadd_err;
412: END IF;
413:
414:
415: -- insert a row into gr_labels_tl for every language installed
416:
417: OPEN Cur_count_language;
418: FETCH Cur_count_language INTO l_missing_count;
419: CLOSE Cur_count_language;

Line 421: GR_LABELS_TL_PKG.add_language

417: OPEN Cur_count_language;
418: FETCH Cur_count_language INTO l_missing_count;
419: CLOSE Cur_count_language;
420: IF l_missing_count > 0 THEN
421: GR_LABELS_TL_PKG.add_language
422: (p_commit => 'F',
423: p_called_by_form => 'F',
424: p_label_code => p_field_name,
425: p_language => p_language,

Line 435: GMD_API_PUB.Log_Message('GR_LABELS_TL_PKG_ADD_LANG');

431: dbms_output.put_line(' oracle_error => ' || oracle_error);
432: dbms_output.put_line(' return_status => ' || return_status); */
433:
434: IF return_status <> 'S' THEN
435: GMD_API_PUB.Log_Message('GR_LABELS_TL_PKG_ADD_LANG');
436: FND_MESSAGE.SET_NAME('GR',
437: 'GR_LABELS_TL_PKG_ADD_LANG');
438: GMD_API_PUB.Log_Message(msg_data);
439: RAISE LTadd_err;

Line 437: 'GR_LABELS_TL_PKG_ADD_LANG');

433:
434: IF return_status <> 'S' THEN
435: GMD_API_PUB.Log_Message('GR_LABELS_TL_PKG_ADD_LANG');
436: FND_MESSAGE.SET_NAME('GR',
437: 'GR_LABELS_TL_PKG_ADD_LANG');
438: GMD_API_PUB.Log_Message(msg_data);
439: RAISE LTadd_err;
440: END IF;
441:

Line 528: -- Validate that the value of Language for the specified property does not exist in the table GR_LABELS_TL.

524: RAISE Row_Missing_Error;
525: END IF;
526: CLOSE c_get_field_name;
527:
528: -- Validate that the value of Language for the specified property does not exist in the table GR_LABELS_TL.
529: -- If it does, write an error to the log file.
530: GR_LABELS_TL_PKG.Check_Primary_Key(
531: p_field_name,
532: p_language,

Line 530: GR_LABELS_TL_PKG.Check_Primary_Key(

526: CLOSE c_get_field_name;
527:
528: -- Validate that the value of Language for the specified property does not exist in the table GR_LABELS_TL.
529: -- If it does, write an error to the log file.
530: GR_LABELS_TL_PKG.Check_Primary_Key(
531: p_field_name,
532: p_language,
533: 'F',
534: row_id,

Line 544: GR_LABELS_TL_PKG.INSERT_ROW(

540: END IF;
541:
542: -- insert row for source lang and lang input
543:
544: GR_LABELS_TL_PKG.INSERT_ROW(
545: P_COMMIT => 'F'
546: ,P_CALLED_BY_FORM => 'F'
547: ,P_LABEL_CODE => p_field_name
548: ,P_LANGUAGE => P_LANGUAGE

Line 746: -- the GR_LABELS_TL table, an error will be written to the log file.

742: END IF;
743: CLOSE c_get_language;
744:
745: -- If the record for the specified field name code and language does not exist in
746: -- the GR_LABELS_TL table, an error will be written to the log file.
747:
748: GR_LABELS_TL_PKG.Check_Primary_Key(
749: p_field_name,
750: p_language,

Line 748: GR_LABELS_TL_PKG.Check_Primary_Key(

744:
745: -- If the record for the specified field name code and language does not exist in
746: -- the GR_LABELS_TL table, an error will be written to the log file.
747:
748: GR_LABELS_TL_PKG.Check_Primary_Key(
749: p_field_name,
750: p_language,
751: 'F',
752: row_id,

Line 762: UPDATE gr_labels_tl

758: END IF;
759:
760: -- update description lang input
761:
762: UPDATE gr_labels_tl
763: SET label_description = p_description,
764: source_lang = p_source_language,
765: last_updated_by = FND_GLOBAL.USER_ID,
766: last_update_date = SYSDATE,

Line 858: -- -- Delete all of the property related records in the GR_LABELS_B, GR_LABELS_TL and GR_LABEL_PROPERTIES tables.

854:
855:
856:
857: IF p_object = 'C' then
858: -- -- Delete all of the property related records in the GR_LABELS_B, GR_LABELS_TL and GR_LABEL_PROPERTIES tables.
859:
860: gr_labels_tl_pkg.delete_rows
861: (p_commit => 'F',
862: p_called_by_form => 'F',

Line 860: gr_labels_tl_pkg.delete_rows

856:
857: IF p_object = 'C' then
858: -- -- Delete all of the property related records in the GR_LABELS_B, GR_LABELS_TL and GR_LABEL_PROPERTIES tables.
859:
860: gr_labels_tl_pkg.delete_rows
861: (p_commit => 'F',
862: p_called_by_form => 'F',
863: p_label_code => p_field_name,
864: x_return_status => return_status,

Line 869: GMD_API_PUB.Log_Message('GR_LABELS_TL_PKG_DEL_ROWS');

865: x_oracle_error => oracle_error,
866: x_msg_data => msg_data);
867:
868: IF return_status <> FND_API.g_ret_sts_success THEN
869: GMD_API_PUB.Log_Message('GR_LABELS_TL_PKG_DEL_ROWS');
870: FND_MESSAGE.SET_NAME('GR',
871: 'GR_LABELS_TL_PKG_DEL_ROWS');
872: l_msg_token := p_field_name;
873: RAISE LTL_del_err;

Line 871: 'GR_LABELS_TL_PKG_DEL_ROWS');

867:
868: IF return_status <> FND_API.g_ret_sts_success THEN
869: GMD_API_PUB.Log_Message('GR_LABELS_TL_PKG_DEL_ROWS');
870: FND_MESSAGE.SET_NAME('GR',
871: 'GR_LABELS_TL_PKG_DEL_ROWS');
872: l_msg_token := p_field_name;
873: RAISE LTL_del_err;
874: END IF;
875:

Line 927: -- the GR_LABELS_TL table, an error will be written to the log file.

923: END IF;
924: CLOSE c_get_language;
925:
926: -- If the record for the specified field name code and language does not exist in
927: -- the GR_LABELS_TL table, an error will be written to the log file.
928: GR_LABELS_TL_PKG.Check_Primary_Key(
929: p_field_name,
930: p_language,
931: 'F',

Line 928: GR_LABELS_TL_PKG.Check_Primary_Key(

924: CLOSE c_get_language;
925:
926: -- If the record for the specified field name code and language does not exist in
927: -- the GR_LABELS_TL table, an error will be written to the log file.
928: GR_LABELS_TL_PKG.Check_Primary_Key(
929: p_field_name,
930: p_language,
931: 'F',
932: row_id,

Line 942: delete gr_labels_tl

938: END IF;
939:
940: -- delete update description lang input
941:
942: delete gr_labels_tl
943: WHERE label_code = p_field_name
944: and language = p_language;
945: IF SQL%NOTFOUND THEN
946: l_msg_token := p_field_name || ' ' || p_language;