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_NAME_PROPERTIES_PUB dependencies on FND_API

Line 42: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

38: RETURN l_debug;
39: END set_debug_flag;
40: PROCEDURE FIELD_NAME_PROPERTIES
41: ( p_api_version IN NUMBER
42: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
43: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
44: , p_action IN VARCHAR2
45: , p_object IN VARCHAR2
46: , p_property_id IN VARCHAR2

Line 43: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

39: END set_debug_flag;
40: PROCEDURE FIELD_NAME_PROPERTIES
41: ( p_api_version IN NUMBER
42: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
43: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
44: , p_action IN VARCHAR2
45: , p_object IN VARCHAR2
46: , p_property_id IN VARCHAR2
47: , p_property_type_indicator IN VARCHAR2

Line 140: IF NOT FND_API.Compatible_API_CALL

136: -- SAVEPOINT FIELD_NAME_PROPERTIES;
137:
138: /* Standard call to check for call compatibility. */
139:
140: IF NOT FND_API.Compatible_API_CALL
141: (l_api_version , p_api_version , l_api_name , G_PKG_NAME)
142: THEN
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;

Line 143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

139:
140: IF NOT FND_API.Compatible_API_CALL
141: (l_api_version , p_api_version , l_api_name , G_PKG_NAME)
142: THEN
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145:
146: /* Initialize message list if p_int_msg_list is set TRUE. */
147: IF FND_API.to_boolean(p_init_msg_list)

Line 147: IF FND_API.to_boolean(p_init_msg_list)

143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145:
146: /* Initialize message list if p_int_msg_list is set TRUE. */
147: IF FND_API.to_boolean(p_init_msg_list)
148: THEN
149: FND_MSG_PUB.Initialize;
150: END IF;
151:

Line 154: x_return_status := FND_API.G_RET_STS_SUCCESS;

150: END IF;
151:
152: -- Initialize API return Parameters
153: gmd_debug.log_initialize('PAL euro trash');
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155:
156: -- IF (l_debug = 'Y') THEN
157: -- gmd_debug.log_initialize('GR FIELD NAME CLASSES API');
158: -- END IF;

Line 168: RAISE FND_API.G_EXC_ERROR;

164: IF p_action is NULL or p_action not in ('I','U','D') then
165: --GMD_API_PUB.Log_Message('GR_INVALID_ACTION');
166: FND_MESSAGE.SET_NAME('GR',
167: 'GR_INVALID_ACTION');
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;
170:
171: IF p_object is NULL or p_object not in ('C','L','V') then
172: --GMD_API_PUB.Log_Message('GR_INVALID_OBJECT');

Line 175: RAISE FND_API.G_EXC_ERROR;

171: IF p_object is NULL or p_object not in ('C','L','V') then
172: --GMD_API_PUB.Log_Message('GR_INVALID_OBJECT');
173: FND_MESSAGE.SET_NAME('GR',
174: 'GR_INVALID_OBJECT');
175: RAISE FND_API.G_EXC_ERROR;
176: END IF;
177:
178:
179: IF p_property_id is NULL then

Line 183: RAISE FND_API.G_EXC_ERROR;

179: IF p_property_id is NULL then
180: -- GMD_API_PUB.Log_Message('SY_FIELDNAME');
181: FND_MESSAGE.SET_NAME('GMA',
182: 'SY_FIELDNAME');
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186: -- check Decimal precision is not > 6 if input -- 8208515
187: -- If an invalid value is passed in, an error message will be written to the log file.

Line 192: RAISE FND_API.G_EXC_ERROR;

188: IF p_precision is not NULL and p_precision > 6 then
189: GMD_API_PUB.Log_Message('GR_INVALID_PRECISION');
190: FND_MESSAGE.SET_NAME('GR',
191: 'GR_INVALID_PRECISION');
192: RAISE FND_API.G_EXC_ERROR;
193: END IF;
194:
195: -- end 8208515
196:

Line 224: RAISE FND_API.G_EXC_ERROR;

220: --GMD_API_PUB.Log_Message('SY_FIELDNAME');
221: FND_MESSAGE.SET_NAME('GMA',
222: 'SY_FIELDNAME');
223:
224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226: -- Validate that Property Type is set to either Flag, Numeric, Alphanumeric, Date, Risk Phrase or Safety Phrase.
227: -- If an invalid value is passed in, an error message will be written to the log file.
228: IF p_property_type_indicator not in ('F','N','A','D','R','S') then

Line 233: RAISE FND_API.G_EXC_ERROR;

229: GMD_API_PUB.Log_Message('SY_INVALID_TYPE');
230: FND_MESSAGE.SET_NAME('GMA',
231: 'SY_INVALID_TYPE');
232:
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;
235:
236: -- Decimal precision is only valid for a type of numeric
237: -- If an invalid value is passed in, an error message will be written to the log file.

Line 242: RAISE FND_API.G_EXC_ERROR;

238: IF p_property_type_indicator <> 'N' and p_precision is not NULL then
239: GMD_API_PUB.Log_Message('GR_INVALID_PRECISION');
240: FND_MESSAGE.SET_NAME('GR',
241: 'GR_INVALID_PRECISION');
242: RAISE FND_API.G_EXC_ERROR;
243: END IF;
244:
245: -- If minimum and maximum values are sent in, they must be validated against each other
246: -- (e.g. min can't be greater than max).

Line 254: RAISE FND_API.G_EXC_ERROR;

250: IF (p_range_min > p_range_max ) or ( p_range_max < p_range_min ) then
251: GMD_API_PUB.Log_Message('GR_INVALID_RANGE');
252: FND_MESSAGE.SET_NAME('GR',
253: 'GR_INVALID_RANGE');
254: RAISE FND_API.G_EXC_ERROR;
255: END IF;
256: END IF; -- IF p_range_min is not null and p_range_max is not null then
257:
258: -- The values for Property Id, Property Type, Length,

Line 481: IF FND_API.To_Boolean(l_key_exists) THEN

477: 'F',
478: row_id,
479: l_key_exists);
480:
481: IF FND_API.To_Boolean(l_key_exists) THEN
482: l_msg_token := p_property_id || ' ' || p_language || ' ' || l_value;
483: RAISE LT_Exists_Error;
484: END IF;
485:

Line 810: IF x_return_status IN (FND_API.G_RET_STS_SUCCESS) AND (FND_API.To_Boolean( p_commit ) ) THEN

806:
807: END IF; -- IF p_object = 'C' then
808:
809: END IF; -- IF p_action = 'I' then
810: IF x_return_status IN (FND_API.G_RET_STS_SUCCESS) AND (FND_API.To_Boolean( p_commit ) ) THEN
811: Commit;
812: END IF;
813:
814: EXCEPTION

Line 816: x_return_status := FND_API.G_RET_STS_ERROR;

812: END IF;
813:
814: EXCEPTION
815: WHEN LBins_err THEN
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
818: --x_msg_data := msg_data;
819: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
820: , p_count => x_msg_count

Line 819: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

815: WHEN LBins_err THEN
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
818: --x_msg_data := msg_data;
819: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
820: , p_count => x_msg_count
821: , p_data => x_msg_data);
822:
823: WHEN LCins_err THEN

Line 825: x_return_status := FND_API.G_RET_STS_ERROR;

821: , p_data => x_msg_data);
822:
823: WHEN LCins_err THEN
824:
825: x_return_status := FND_API.G_RET_STS_ERROR;
826: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
827: --x_msg_data := msg_data;
828: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
829: , p_count => x_msg_count

Line 828: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

824:
825: x_return_status := FND_API.G_RET_STS_ERROR;
826: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
827: --x_msg_data := msg_data;
828: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
829: , p_count => x_msg_count
830: , p_data => x_msg_data);
831:
832: WHEN LTadd_err THEN

Line 833: x_return_status := FND_API.G_RET_STS_ERROR;

829: , p_count => x_msg_count
830: , p_data => x_msg_data);
831:
832: WHEN LTadd_err THEN
833: x_return_status := FND_API.G_RET_STS_ERROR;
834: --ROLLBACK TO SAVEPOINT FIELD_NAME_PROPERTIES;
835: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
836: P_data => x_msg_data);
837:

Line 848: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

844: FND_MESSAGE.SET_TOKEN('CODE',
845: l_msg_token,
846: FALSE);
847: FND_MSG_PUB.ADD;
848: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
849: , p_count => x_msg_count
850: , p_data => x_msg_data);
851:
852: WHEN LT_Exists_Error THEN

Line 861: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

857: FND_MESSAGE.SET_TOKEN('CODE',
858: l_msg_token,
859: FALSE);
860: FND_MSG_PUB.ADD;
861: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
862: , p_count => x_msg_count
863: , p_data => x_msg_data);
864:
865:

Line 866: WHEN FND_API.G_EXC_ERROR THEN

862: , p_count => x_msg_count
863: , p_data => x_msg_data);
864:
865:
866: WHEN FND_API.G_EXC_ERROR THEN
867: --ROLLBACK TO SAVEPOINT FIELD_NAME_PROPERTIES;
868: x_return_status := FND_API.G_RET_STS_ERROR;
869: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
870: , p_count => x_msg_count

Line 868: x_return_status := FND_API.G_RET_STS_ERROR;

864:
865:
866: WHEN FND_API.G_EXC_ERROR THEN
867: --ROLLBACK TO SAVEPOINT FIELD_NAME_PROPERTIES;
868: x_return_status := FND_API.G_RET_STS_ERROR;
869: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
870: , p_count => x_msg_count
871: , p_data => x_msg_data
872: );

Line 869: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

865:
866: WHEN FND_API.G_EXC_ERROR THEN
867: --ROLLBACK TO SAVEPOINT FIELD_NAME_PROPERTIES;
868: x_return_status := FND_API.G_RET_STS_ERROR;
869: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
870: , p_count => x_msg_count
871: , p_data => x_msg_data
872: );
873: x_msg_data := FND_MESSAGE.Get;

Line 875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

871: , p_data => x_msg_data
872: );
873: x_msg_data := FND_MESSAGE.Get;
874:
875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
876: --ROLLBACK TO SAVEPOINT FIELD_NAME_PROPERTIES;
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
878: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
879: , p_count => x_msg_count

Line 877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

873: x_msg_data := FND_MESSAGE.Get;
874:
875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
876: --ROLLBACK TO SAVEPOINT FIELD_NAME_PROPERTIES;
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
878: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
879: , p_count => x_msg_count
880: , p_data => x_msg_data
881: );

Line 878: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

874:
875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
876: --ROLLBACK TO SAVEPOINT FIELD_NAME_PROPERTIES;
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
878: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
879: , p_count => x_msg_count
880: , p_data => x_msg_data
881: );
882:

Line 884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

880: , p_data => x_msg_data
881: );
882:
883: WHEN OTHERS THEN
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: --ROLLBACK TO SAVEPOINT FIELD_NAME_PROPERTIES;
886: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
887: , l_api_name
888: );

Line 890: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

886: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
887: , l_api_name
888: );
889:
890: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
891: , p_count => x_msg_count
892: , p_data => x_msg_data
893: );
894: