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_LABEL_PROPERTIES

Line 54: , p_label_properties_tab IN GR_FIELD_NAMES_PUB.gr_label_properties_tab_type

50: , p_technical_parameter_flag IN VARCHAR2
51: , p_language IN VARCHAR2
52: , p_source_language IN VARCHAR2
53: , p_description IN VARCHAR2
54: , p_label_properties_tab IN GR_FIELD_NAMES_PUB.gr_label_properties_tab_type
55: , x_return_status OUT NOCOPY VARCHAR2
56: , x_msg_count OUT NOCOPY NUMBER
57: , x_msg_data OUT NOCOPY VARCHAR2
58: )

Line 144: FROM gr_label_properties lp

140:
141: CURSOR c_get_label_properties_rowid
142: IS
143: SELECT lp.rowid
144: FROM gr_label_properties lp
145: WHERE lp.property_id = l_property_id
146: AND lp.label_code = p_field_name;
147: LabelTLRecord c_get_label_properties_rowid%ROWTYPE;
148:

Line 460: /* Loop through records in input table and insert into gr_label_properties table for each record*/

456:
457:
458: -- load properties table input into gl_label_properties table
459:
460: /* Loop through records in input table and insert into gr_label_properties table for each record*/
461:
462: FOR i IN 1 .. p_label_properties_tab.count LOOP
463: l_property_id := p_label_properties_tab(i).property_id;
464: IF p_label_properties_tab(i).property_id IS NOT NULL THEN

Line 479: GR_LABEL_PROPERTIES_PKG.Insert_Row

475:
476: CLOSE c_get_property_id;
477:
478: -- load properties table input into gl_label_properties table
479: GR_LABEL_PROPERTIES_PKG.Insert_Row
480: (p_commit => 'F',
481: p_called_by_form => 'F',
482: p_sequence_number => p_label_properties_tab(i).sequence_number,
483: p_property_id => l_property_id,

Line 502: GMD_API_PUB.Log_Message('GR_LABEL_PROPERTIES_PKG_INS_RO');

498: dbms_output.put_line(' oracle_error => ' || oracle_error);
499: dbms_output.put_line(' return_status => ' || return_status); */
500:
501: IF return_status <> FND_API.g_ret_sts_success THEN
502: GMD_API_PUB.Log_Message('GR_LABEL_PROPERTIES_PKG_INS_RO');
503: FND_MESSAGE.SET_NAME('GR',
504: 'GR_LABEL_PROPERTIES_PKG_INS_RO');
505: RAISE LP_ins_err;
506: END IF;

Line 504: 'GR_LABEL_PROPERTIES_PKG_INS_RO');

500:
501: IF return_status <> FND_API.g_ret_sts_success THEN
502: GMD_API_PUB.Log_Message('GR_LABEL_PROPERTIES_PKG_INS_RO');
503: FND_MESSAGE.SET_NAME('GR',
504: 'GR_LABEL_PROPERTIES_PKG_INS_RO');
505: RAISE LP_ins_err;
506: END IF;
507:
508: END IF; -- IF p_label_properties_tab(i).property_id IS NOT NULL THEN

Line 572: 'GR_LABEL_PROPERTIES_PKG_INS_RO');

568: IF (l_debug = 'Y') THEN
569: gmd_debug.put_line('error');
570: END IF;
571: FND_MESSAGE.SET_NAME('GR',
572: 'GR_LABEL_PROPERTIES_PKG_INS_RO');
573: GMD_API_PUB.Log_Message(msg_data);
574: RAISE LBTLadd_err;
575: END IF;
576:

Line 591: /* Loop through records in input table and insert into gr_label_properties table for each record*/

587: END IF;
588: CLOSE c_get_field_name;
589:
590:
591: /* Loop through records in input table and insert into gr_label_properties table for each record*/
592:
593: FOR i IN 1 .. p_label_properties_tab.count LOOP
594: l_property_id := p_label_properties_tab(i).property_id;
595: IF p_label_properties_tab(i).property_id IS NOT NULL THEN

Line 607: --Validate that the specified property does not exist in the table GR_LABEL_PROPERTIES.

603: RAISE Row_Missing_Error;
604: END IF;
605: CLOSE c_get_property_id;
606:
607: --Validate that the specified property does not exist in the table GR_LABEL_PROPERTIES.
608: -- If it does, write an error to the log file.
609:
610: OPEN c_get_label_properties_rowid;
611: FETCH c_get_label_properties_rowid INTO LabelTLRecord;

Line 624: GR_LABEL_PROPERTIES_PKG.Insert_Row

620: CLOSE c_get_label_properties_rowid;
621:
622:
623: -- load properties table input into gl_label_properties table
624: GR_LABEL_PROPERTIES_PKG.Insert_Row
625: (p_commit => 'F',
626: p_called_by_form => 'F',
627: p_sequence_number => p_label_properties_tab(i).sequence_number,
628: p_property_id => l_property_id,

Line 648: 'GR_LABEL_PROPERTIES_PKG_INS_RO');

644: dbms_output.put_line(' return_status => ' || return_status); */
645:
646: IF return_status <> FND_API.g_ret_sts_success THEN
647: FND_MESSAGE.SET_NAME('GR',
648: 'GR_LABEL_PROPERTIES_PKG_INS_RO');
649: GMD_API_PUB.Log_Message('GR_LABEL_PROPERTIES_PKG_INS_RO');
650: RAISE LP_ins_err;
651: END IF;
652:

Line 649: GMD_API_PUB.Log_Message('GR_LABEL_PROPERTIES_PKG_INS_RO');

645:
646: IF return_status <> FND_API.g_ret_sts_success THEN
647: FND_MESSAGE.SET_NAME('GR',
648: 'GR_LABEL_PROPERTIES_PKG_INS_RO');
649: GMD_API_PUB.Log_Message('GR_LABEL_PROPERTIES_PKG_INS_RO');
650: RAISE LP_ins_err;
651: END IF;
652:
653: END IF; -- IF p_label_properties_tab(i).property_id IS NOT NULL THEN

Line 780: Validate that the value of Property Id exists in the table GR_LABEL_PROPERTIES

776: ELSE -- object = P
777:
778:
779: /* Loop through records in input table
780: Validate that the value of Property Id exists in the table GR_LABEL_PROPERTIES
781: and is associated to the specified field name code If it does not, write an error to the log */
782:
783: FOR i IN 1 .. p_label_properties_tab.count LOOP
784: l_property_id := p_label_properties_tab(i).property_id;

Line 816: -- and display sequence will be updated to the GR_LABEL_PROPERTIES table

812:
813:
814:
815: -- The the non-null values for required flag
816: -- and display sequence will be updated to the GR_LABEL_PROPERTIES table
817: UPDATE gr_label_properties
818: SET sequence_number = l_sequence_number,
819: property_required = l_property_required,
820: last_updated_by = FND_GLOBAL.USER_ID,

Line 817: UPDATE gr_label_properties

813:
814:
815: -- The the non-null values for required flag
816: -- and display sequence will be updated to the GR_LABEL_PROPERTIES table
817: UPDATE gr_label_properties
818: SET sequence_number = l_sequence_number,
819: property_required = l_property_required,
820: last_updated_by = FND_GLOBAL.USER_ID,
821: 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 877: gr_label_properties_pkg.delete_rows

873: RAISE LTL_del_err;
874: END IF;
875:
876:
877: gr_label_properties_pkg.delete_rows
878: (p_commit => 'F',
879: p_called_by_form => 'T',
880: p_delete_option => 'L',
881: p_property_id => NULL,

Line 888: GMD_API_PUB.Log_Message('GR_LABEL_PROPERTIES_PKG_DEL_RO');

884: x_oracle_error => oracle_error,
885: x_msg_data => msg_data);
886:
887: IF return_status <> FND_API.g_ret_sts_success THEN
888: GMD_API_PUB.Log_Message('GR_LABEL_PROPERTIES_PKG_DEL_RO');
889: FND_MESSAGE.SET_NAME('GR',
890: 'GR_LABEL_PROPERTIES_PKG_DEL_RO');
891: RAISE LP_del_err;
892: END IF;

Line 890: 'GR_LABEL_PROPERTIES_PKG_DEL_RO');

886:
887: IF return_status <> FND_API.g_ret_sts_success THEN
888: GMD_API_PUB.Log_Message('GR_LABEL_PROPERTIES_PKG_DEL_RO');
889: FND_MESSAGE.SET_NAME('GR',
890: 'GR_LABEL_PROPERTIES_PKG_DEL_RO');
891: RAISE LP_del_err;
892: END IF;
893:
894: DELETE FROM gr_labels_b

Line 953: Validate that the value of Property Id exists in the table GR_LABEL_PROPERTIES

949:
950: ELSE -- object = P
951:
952: /* Loop through records in input table
953: Validate that the value of Property Id exists in the table GR_LABEL_PROPERTIES
954: and is associated to the specified field name code If it does not, write an error to the log */
955:
956: FOR i IN 1 .. p_label_properties_tab.count LOOP
957: l_property_id := p_label_properties_tab(i).property_id;

Line 986: -- Delete the record in GR_LABEL_PROPERTIES table for the specified field name and property id.

982: RAISE Row_Missing_Error;
983: END IF;
984: CLOSE c_get_label_properties_rowid;
985:
986: -- Delete the record in GR_LABEL_PROPERTIES table for the specified field name and property id.
987:
988: delete from gr_label_properties
989: WHERE property_id = l_property_id
990: and label_code = p_field_name;

Line 988: delete from gr_label_properties

984: CLOSE c_get_label_properties_rowid;
985:
986: -- Delete the record in GR_LABEL_PROPERTIES table for the specified field name and property id.
987:
988: delete from gr_label_properties
989: WHERE property_id = l_property_id
990: and label_code = p_field_name;
991:
992: IF SQL%NOTFOUND THEN