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 FND_API

Line 161: IF NOT FND_API.Compatible_API_CALL

157: -- SAVEPOINT FIELD_NAMES;
158:
159: /* Standard call to check for call compatibility. */
160:
161: IF NOT FND_API.Compatible_API_CALL
162: (l_api_version , p_api_version , l_api_name , G_PKG_NAME)
163: THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;

Line 164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

160:
161: IF NOT FND_API.Compatible_API_CALL
162: (l_api_version , p_api_version , l_api_name , G_PKG_NAME)
163: THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
167: /* Initialize message list if p_int_msg_list is set TRUE. */
168: IF FND_API.to_boolean(p_init_msg_list)

Line 168: IF FND_API.to_boolean(p_init_msg_list)

164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
167: /* Initialize message list if p_int_msg_list is set TRUE. */
168: IF FND_API.to_boolean(p_init_msg_list)
169: THEN
170: FND_MSG_PUB.Initialize;
171: END IF;
172:

Line 175: x_return_status := FND_API.G_RET_STS_SUCCESS;

171: END IF;
172:
173: -- Initialize API return Parameters
174: gmd_debug.log_initialize('PAL euro trash');
175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176:
177: -- IF (l_debug = 'Y') THEN
178: -- gmd_debug.log_initialize('GR FIELD NAMES API');
179: -- END IF;

Line 188: RAISE FND_API.G_EXC_ERROR;

184:
185: IF p_action is NULL or p_action not in ('I','U','D') then
186: FND_MESSAGE.SET_NAME('GR',
187: 'GR_INVALID_ACTION');
188: RAISE FND_API.G_EXC_ERROR;
189: END IF;
190:
191: IF p_object is NULL or p_object not in ('C','L','P') then
192: FND_MESSAGE.SET_NAME('GR',

Line 194: RAISE FND_API.G_EXC_ERROR;

190:
191: IF p_object is NULL or p_object not in ('C','L','P') then
192: FND_MESSAGE.SET_NAME('GR',
193: 'GR_INVALID_OBJECT');
194: RAISE FND_API.G_EXC_ERROR;
195: END IF;
196:
197: --Will raise the error message if property type phrase is passed in.
198: FOR i IN 1 .. p_label_properties_tab.count LOOP

Line 206: RAISE FND_API.G_EXC_ERROR;

202: FETCH c_get_property_ind into l_prop_type_ind;
203: CLOSE c_get_property_ind;
204: IF (l_prop_type_ind = 'P') THEN
205: FND_MESSAGE.SET_NAME('GR','GR_PROPERTY_IND_INVALID');
206: RAISE FND_API.G_EXC_ERROR;
207: END IF;
208: END IF;
209: END LOOP;
210:

Line 214: RAISE FND_API.G_EXC_ERROR;

210:
211: IF p_field_name is NULL then
212: FND_MESSAGE.SET_NAME('GMA',
213: 'SY_FIELDNAME');
214: RAISE FND_API.G_EXC_ERROR;
215:
216: END IF;
217:
218: IF p_action = 'I' then

Line 229: RAISE FND_API.G_EXC_ERROR;

225: FETCH c_get_field_name INTO dummy;
226: IF NOT c_get_field_name%NOTFOUND THEN
227: CLOSE c_get_field_name;
228: GMD_API_PUB.Log_Message('PON_AUC_DUP_FIELD_NAME');
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231: CLOSE c_get_field_name;
232:
233:

Line 264: RAISE FND_API.G_EXC_ERROR;

260: FND_MESSAGE.SET_NAME('GR',
261: 'GR_CLASS_REQUIRED');
262: FND_MSG_PUB.ADD;
263: GMD_API_PUB.Log_Message('GR_CLASS_REQUIRED');
264: RAISE FND_API.G_EXC_ERROR;
265:
266: ELSE
267: /* Check the label class code */
268:

Line 286: RAISE FND_API.G_EXC_ERROR;

282: FND_MESSAGE.SET_NAME('GR',
283: 'GR_DESC_REQUIRED');
284: FND_MSG_PUB.ADD;
285: GMD_API_PUB.Log_Message('GR_DESC_REQUIRED');
286: RAISE FND_API.G_EXC_ERROR;
287: END IF;
288:
289: -- write to gr_labels_b table.
290:

Line 454: RAISE FND_API.G_EXC_ERROR;

450:
451: GMD_API_PUB.Log_Message('GR_FNAME_NOT_ASSOC');
452: FND_MESSAGE.SET_NAME('GR',
453: 'GR_FNAME_NOT_ASSOC');
454: RAISE FND_API.G_EXC_ERROR;
455: END IF;
456:
457:
458: -- load properties table input into gl_label_properties table

Line 501: IF return_status <> FND_API.g_ret_sts_success THEN

497: /* dbms_output.put_line(' msg_data => ' || msg_data);
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;

Line 537: IF FND_API.To_Boolean(l_key_exists) THEN

533: 'F',
534: row_id,
535: l_key_exists);
536:
537: IF FND_API.To_Boolean(l_key_exists) THEN
538: l_msg_token := p_field_name || ' ' || p_language;
539: RAISE LT_Exists_Error;
540: END IF;
541:

Line 646: IF return_status <> FND_API.g_ret_sts_success THEN

642: /* dbms_output.put_line(' msg_data => ' || msg_data);
643: dbms_output.put_line(' oracle_error => ' || oracle_error);
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;

Line 868: IF return_status <> FND_API.g_ret_sts_success THEN

864: x_return_status => return_status,
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;

Line 887: IF return_status <> FND_API.g_ret_sts_success THEN

883: x_return_status => return_status,
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;

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

1002: END IF; -- IF p_object = 'C' then
1003:
1004: END IF; -- IF p_action = 'I' then
1005:
1006: IF x_return_status IN (FND_API.G_RET_STS_SUCCESS) AND (FND_API.To_Boolean( p_commit ) ) THEN
1007: Commit;
1008: END IF;
1009:
1010: EXCEPTION

Line 1013: x_return_status := FND_API.G_RET_STS_ERROR;

1009:
1010: EXCEPTION
1011:
1012: WHEN LTadd_err THEN
1013: x_return_status := FND_API.G_RET_STS_ERROR;
1014: --ROLLBACK TO SAVEPOINT FIELD_NAMES;
1015: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
1016: P_data => x_msg_data);
1017:

Line 1019: x_return_status := FND_API.G_RET_STS_ERROR;

1015: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
1016: P_data => x_msg_data);
1017:
1018: WHEN LBins_err THEN
1019: x_return_status := FND_API.G_RET_STS_ERROR;
1020: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
1021: --x_msg_data := msg_data;
1022: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1023: , p_count => x_msg_count

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

1018: WHEN LBins_err THEN
1019: x_return_status := FND_API.G_RET_STS_ERROR;
1020: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
1021: --x_msg_data := msg_data;
1022: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1023: , p_count => x_msg_count
1024: , p_data => x_msg_data);
1025:
1026: WHEN LP_ins_err THEN

Line 1027: x_return_status := FND_API.G_RET_STS_ERROR;

1023: , p_count => x_msg_count
1024: , p_data => x_msg_data);
1025:
1026: WHEN LP_ins_err THEN
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
1029: --x_msg_data := msg_data;
1030: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1031: , p_count => x_msg_count

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

1026: WHEN LP_ins_err THEN
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
1029: --x_msg_data := msg_data;
1030: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1031: , p_count => x_msg_count
1032: , p_data => x_msg_data);
1033:
1034: WHEN LTL_del_err THEN

Line 1035: x_return_status := FND_API.G_RET_STS_ERROR;

1031: , p_count => x_msg_count
1032: , p_data => x_msg_data);
1033:
1034: WHEN LTL_del_err THEN
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
1037: --x_msg_data := msg_data;
1038: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1039: , p_count => x_msg_count

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

1034: WHEN LTL_del_err THEN
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
1037: --x_msg_data := msg_data;
1038: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1039: , p_count => x_msg_count
1040: , p_data => x_msg_data);
1041:
1042: WHEN LP_del_err THEN

Line 1043: x_return_status := FND_API.G_RET_STS_ERROR;

1039: , p_count => x_msg_count
1040: , p_data => x_msg_data);
1041:
1042: WHEN LP_del_err THEN
1043: x_return_status := FND_API.G_RET_STS_ERROR;
1044: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
1045: --x_msg_data := msg_data;
1046: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1047: , p_count => x_msg_count

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

1042: WHEN LP_del_err THEN
1043: x_return_status := FND_API.G_RET_STS_ERROR;
1044: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
1045: --x_msg_data := msg_data;
1046: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1047: , p_count => x_msg_count
1048: , p_data => x_msg_data);
1049: WHEN LBTLadd_err THEN
1050: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1050: x_return_status := FND_API.G_RET_STS_ERROR;

1046: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1047: , p_count => x_msg_count
1048: , p_data => x_msg_data);
1049: WHEN LBTLadd_err THEN
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: --ROLLBACK TO SAVEPOINT FIELD_NAMES;
1052: --x_msg_data := msg_data;
1053: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1054: , p_count => x_msg_count

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

1049: WHEN LBTLadd_err THEN
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: --ROLLBACK TO SAVEPOINT FIELD_NAMES;
1052: --x_msg_data := msg_data;
1053: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1054: , p_count => x_msg_count
1055: , p_data => x_msg_data);
1056:
1057: WHEN Row_Missing_Error THEN

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

1063: FND_MESSAGE.SET_TOKEN('CODE',
1064: l_msg_token,
1065: FALSE);
1066: FND_MSG_PUB.ADD;
1067: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1068: , p_count => x_msg_count
1069: , p_data => x_msg_data);
1070:
1071: WHEN LT_Exists_Error THEN

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

1078: l_msg_token,
1079: FALSE);
1080: FND_MSG_PUB.ADD;
1081:
1082: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1083: , p_count => x_msg_count
1084: , p_data => x_msg_data);
1085:
1086:

Line 1087: WHEN FND_API.G_EXC_ERROR THEN

1083: , p_count => x_msg_count
1084: , p_data => x_msg_data);
1085:
1086:
1087: WHEN FND_API.G_EXC_ERROR THEN
1088: --ROLLBACK TO SAVEPOINT FIELD_NAMES;
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1091: , p_count => x_msg_count

Line 1089: x_return_status := FND_API.G_RET_STS_ERROR;

1085:
1086:
1087: WHEN FND_API.G_EXC_ERROR THEN
1088: --ROLLBACK TO SAVEPOINT FIELD_NAMES;
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1091: , p_count => x_msg_count
1092: , p_data => x_msg_data
1093: );

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

1086:
1087: WHEN FND_API.G_EXC_ERROR THEN
1088: --ROLLBACK TO SAVEPOINT FIELD_NAMES;
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1091: , p_count => x_msg_count
1092: , p_data => x_msg_data
1093: );
1094: x_msg_data := FND_MESSAGE.Get;

Line 1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1092: , p_data => x_msg_data
1093: );
1094: x_msg_data := FND_MESSAGE.Get;
1095:
1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1097: --ROLLBACK TO SAVEPOINT FIELD_NAMES;
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1099: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1100: , p_count => x_msg_count

Line 1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1094: x_msg_data := FND_MESSAGE.Get;
1095:
1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1097: --ROLLBACK TO SAVEPOINT FIELD_NAMES;
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1099: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1100: , p_count => x_msg_count
1101: , p_data => x_msg_data
1102: );

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

1095:
1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1097: --ROLLBACK TO SAVEPOINT FIELD_NAMES;
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1099: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1100: , p_count => x_msg_count
1101: , p_data => x_msg_data
1102: );
1103:

Line 1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1101: , p_data => x_msg_data
1102: );
1103:
1104: WHEN OTHERS THEN
1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1106: --ROLLBACK TO SAVEPOINT FIELD_NAMES;
1107: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1108: , l_api_name
1109: );

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

1107: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1108: , l_api_name
1109: );
1110:
1111: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1112: , p_count => x_msg_count
1113: , p_data => x_msg_data
1114: );
1115: