DBA Data[Home] [Help]

APPS.GR_FIELD_NAME_CLASSES_PUB dependencies on FND_API

Line 170: IF NOT FND_API.Compatible_API_CALL

166: -- SAVEPOINT FIELD_NAME_CLASSES;
167:
168: /* Standard call to check for call compatibility. */
169:
170: IF NOT FND_API.Compatible_API_CALL
171: (l_api_version , p_api_version , l_api_name , G_PKG_NAME)
172: THEN
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: END IF;

Line 173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

169:
170: IF NOT FND_API.Compatible_API_CALL
171: (l_api_version , p_api_version , l_api_name , G_PKG_NAME)
172: THEN
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: END IF;
175:
176: /* Initialize message list if p_int_msg_list is set TRUE. */
177: IF FND_API.to_boolean(p_init_msg_list)

Line 177: IF FND_API.to_boolean(p_init_msg_list)

173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: END IF;
175:
176: /* Initialize message list if p_int_msg_list is set TRUE. */
177: IF FND_API.to_boolean(p_init_msg_list)
178: THEN
179: FND_MSG_PUB.Initialize;
180: END IF;
181:

Line 184: x_return_status := FND_API.G_RET_STS_SUCCESS;

180: END IF;
181:
182: -- Initialize API return Parameters
183: gmd_debug.log_initialize('PAL euro trash');
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: -- IF (l_debug = 'Y') THEN
187: -- gmd_debug.log_initialize('GR FIELD NAME CLASSES API');
188: -- END IF;

Line 197: RAISE FND_API.G_EXC_ERROR;

193:
194: IF p_action is NULL or p_action not in ('I','U','D') then
195: FND_MESSAGE.SET_NAME('GR',
196: 'GR_INVALID_ACTION');
197: RAISE FND_API.G_EXC_ERROR;
198: END IF;
199:
200: IF p_object is NULL or p_object not in ('C','L','R') then
201: FND_MESSAGE.SET_NAME('GR',

Line 203: RAISE FND_API.G_EXC_ERROR;

199:
200: IF p_object is NULL or p_object not in ('C','L','R') then
201: FND_MESSAGE.SET_NAME('GR',
202: 'GR_INVALID_OBJECT');
203: RAISE FND_API.G_EXC_ERROR;
204: END IF;
205:
206:
207: IF p_field_name_class is NULL then

Line 210: RAISE FND_API.G_EXC_ERROR;

206:
207: IF p_field_name_class is NULL then
208: FND_MESSAGE.SET_NAME('GMA',
209: 'SY_FIELDNAME');
210: RAISE FND_API.G_EXC_ERROR;
211: END IF;
212:
213: IF p_action = 'I' then
214:

Line 238: RAISE FND_API.G_EXC_ERROR;

234: -- and an error message will be written to the log file if any of the values are null.
235: IF p_language is NULL or p_source_language is NULL or p_description is null or p_form_block is NULL then
236: FND_MESSAGE.SET_NAME('GMA',
237: 'SY_FIELDNAME');
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240:
241: -- Validate that Form Block is set to either Properties, Risk Phrases, Safety Phrases or Names.
242: -- If an invalid value is passed in, an error message will be written to the log file.

Line 246: RAISE FND_API.G_EXC_ERROR;

242: -- If an invalid value is passed in, an error message will be written to the log file.
243: IF p_form_block not in ('Properties','Risk Phrases','Safety Phrases','Names') then
244: FND_MESSAGE.SET_NAME('GMA',
245: 'SY_INVALID_TYPE');
246: RAISE FND_API.G_EXC_ERROR;
247:
248: END IF;
249:
250: -- 7293765

Line 518: RAISE FND_API.G_EXC_ERROR;

514: --If neither is sent in, a 'Responsibility required' error message will be written to the log file.
515: IF l_responsibility_id is NULL and l_responsibility is NULL then
516: FND_MESSAGE.SET_NAME('GMA',
517: 'SY_FIELDNAME');
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520:
521: -- If a responsibility name is sent in, the responsibility id will be retrieved from FND_RESPONSIBILITY_VL.
522: -- If a responsibility id is sent in, it is validated against the FND_RESPONSIBILITY table.

Line 643: RAISE FND_API.G_EXC_ERROR;

639: -- If an invalid value is passed in, an error message will be written to the log file.
640: IF p_form_block not in ('Properties','Risk Phrases','Safety Phrases','Names') then
641: FND_MESSAGE.SET_NAME('GMA',
642: 'SY_INVALID_TYPE');
643: RAISE FND_API.G_EXC_ERROR;
644:
645: END IF;
646:
647: -- 7293765

Line 829: IF return_status <> FND_API.g_ret_sts_success THEN

825: x_return_status => return_status,
826: x_oracle_error => oracle_error,
827: x_msg_data => msg_data);
828:
829: IF return_status <> FND_API.g_ret_sts_success THEN
830: GMD_API_PUB.Log_Message('GR_LABEL_CLASS_DEL_LANG_ERROR');
831: FND_MESSAGE.SET_NAME('GR',
832: 'GR_LABEL_CLASS_DEL_LANG_ERROR');
833: FND_MSG_PUB.ADD;

Line 979: x_return_status := FND_API.G_RET_STS_ERROR;

975:
976:
977: EXCEPTION
978: WHEN LBins_err THEN
979: x_return_status := FND_API.G_RET_STS_ERROR;
980: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
981: --x_msg_data := msg_data;
982: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
983: , p_count => x_msg_count

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

978: WHEN LBins_err THEN
979: x_return_status := FND_API.G_RET_STS_ERROR;
980: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
981: --x_msg_data := msg_data;
982: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
983: , p_count => x_msg_count
984: , p_data => x_msg_data);
985:
986: WHEN LCins_err THEN

Line 988: x_return_status := FND_API.G_RET_STS_ERROR;

984: , p_data => x_msg_data);
985:
986: WHEN LCins_err THEN
987:
988: x_return_status := FND_API.G_RET_STS_ERROR;
989: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
990: --x_msg_data := msg_data;
991: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
992: , p_count => x_msg_count

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

987:
988: x_return_status := FND_API.G_RET_STS_ERROR;
989: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
990: --x_msg_data := msg_data;
991: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
992: , p_count => x_msg_count
993: , p_data => x_msg_data);
994:
995: WHEN LTadd_err THEN

Line 996: x_return_status := FND_API.G_RET_STS_ERROR;

992: , p_count => x_msg_count
993: , p_data => x_msg_data);
994:
995: WHEN LTadd_err THEN
996: x_return_status := FND_API.G_RET_STS_ERROR;
997: --ROLLBACK TO SAVEPOINT FIELD_NAME_CLASSES;
998: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
999: P_data => x_msg_data);
1000:

Line 1002: x_return_status := FND_API.G_RET_STS_ERROR;

998: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
999: P_data => x_msg_data);
1000:
1001: WHEN LTL_del_err THEN
1002: x_return_status := FND_API.G_RET_STS_ERROR;
1003: -- ROLLBACK TO SAVEPOINT FIELD_NAME_CLASSES;
1004: --x_msg_data := msg_data;
1005: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1006: , p_count => x_msg_count

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

1001: WHEN LTL_del_err THEN
1002: x_return_status := FND_API.G_RET_STS_ERROR;
1003: -- ROLLBACK TO SAVEPOINT FIELD_NAME_CLASSES;
1004: --x_msg_data := msg_data;
1005: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1006: , p_count => x_msg_count
1007: , p_data => x_msg_data);
1008:
1009: WHEN Row_Missing_Error THEN

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

1015: FND_MESSAGE.SET_TOKEN('CODE',
1016: l_msg_token,
1017: FALSE);
1018: FND_MSG_PUB.ADD;
1019: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1020: , p_count => x_msg_count
1021: , p_data => x_msg_data);
1022:
1023: WHEN LT_Exists_Error THEN

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

1030: l_msg_token,
1031: FALSE);
1032: FND_MSG_PUB.ADD;
1033:
1034: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1035: , p_count => x_msg_count
1036: , p_data => x_msg_data);
1037:
1038:

Line 1039: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1041: x_return_status := FND_API.G_RET_STS_ERROR;

1037:
1038:
1039: WHEN FND_API.G_EXC_ERROR THEN
1040: --ROLLBACK TO SAVEPOINT FIELD_NAME_CLASSES;
1041: x_return_status := FND_API.G_RET_STS_ERROR;
1042: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1043: , p_count => x_msg_count
1044: , p_data => x_msg_data
1045: );

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

1038:
1039: WHEN FND_API.G_EXC_ERROR THEN
1040: --ROLLBACK TO SAVEPOINT FIELD_NAME_CLASSES;
1041: x_return_status := FND_API.G_RET_STS_ERROR;
1042: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1043: , p_count => x_msg_count
1044: , p_data => x_msg_data
1045: );
1046: x_msg_data := FND_MESSAGE.Get;

Line 1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1044: , p_data => x_msg_data
1045: );
1046: x_msg_data := FND_MESSAGE.Get;
1047:
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: --ROLLBACK TO SAVEPOINT FIELD_NAME_CLASSES;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1052: , p_count => x_msg_count

Line 1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1046: x_msg_data := FND_MESSAGE.Get;
1047:
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: --ROLLBACK TO SAVEPOINT FIELD_NAME_CLASSES;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1052: , p_count => x_msg_count
1053: , p_data => x_msg_data
1054: );

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

1047:
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: --ROLLBACK TO SAVEPOINT FIELD_NAME_CLASSES;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1052: , p_count => x_msg_count
1053: , p_data => x_msg_data
1054: );
1055:

Line 1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1053: , p_data => x_msg_data
1054: );
1055:
1056: WHEN OTHERS THEN
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1058: --ROLLBACK TO SAVEPOINT FIELD_NAME_CLASSES;
1059: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1060: , l_api_name
1061: );

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

1059: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1060: , l_api_name
1061: );
1062:
1063: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1064: , p_count => x_msg_count
1065: , p_data => x_msg_data
1066: );
1067: