DBA Data[Home] [Help]

APPS.GR_RISK_SAFETY_PHRASES_PUB dependencies on FND_API

Line 40: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

36: END set_debug_flag;
37:
38: PROCEDURE RISK_SAFETY_PHRASES
39: ( p_api_version IN NUMBER
40: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
41: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
42: , p_action IN VARCHAR2
43: , p_object IN VARCHAR2
44: , p_phrase_type IN VARCHAR2

Line 41: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

37:
38: PROCEDURE RISK_SAFETY_PHRASES
39: ( p_api_version IN NUMBER
40: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
41: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
42: , p_action IN VARCHAR2
43: , p_object IN VARCHAR2
44: , p_phrase_type IN VARCHAR2
45: , p_phrase_code IN VARCHAR2

Line 163: IF NOT FND_API.Compatible_API_CALL

159: L_MSG_TOKEN VARCHAR2(100);
160: BEGIN
161: /* Standard call to check for call compatibility. */
162:
163: IF NOT FND_API.Compatible_API_CALL
164: (l_api_version , p_api_version , l_api_name , G_PKG_NAME) THEN
165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
166: END IF;
167:

Line 165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 169: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 174: x_return_status := FND_API.G_RET_STS_SUCCESS;

170: FND_MSG_PUB.Initialize;
171: END IF;
172:
173: -- Initialize API return Parameters
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175:
176: /* check mandatory inputs */
177:
178: IF p_action is NULL or p_action not in ('I','U','D') then

Line 180: RAISE FND_API.G_EXC_ERROR;

176: /* check mandatory inputs */
177:
178: IF p_action is NULL or p_action not in ('I','U','D') then
179: FND_MESSAGE.SET_NAME('GR','GR_INVALID_ACTION');
180: RAISE FND_API.G_EXC_ERROR;
181: END IF;
182:
183: IF p_object is NULL or p_object not in ('C','L') then
184: FND_MESSAGE.SET_NAME('GR','GR_INVALID_OBJECT');

Line 185: RAISE FND_API.G_EXC_ERROR;

181: END IF;
182:
183: IF p_object is NULL or p_object not in ('C','L') then
184: FND_MESSAGE.SET_NAME('GR','GR_INVALID_OBJECT');
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
188: IF p_phrase_type is NULL or p_phrase_type not in ('R','S') then
189: FND_MESSAGE.SET_NAME('GR','GR_INVALID_PHRASE');

Line 190: RAISE FND_API.G_EXC_ERROR;

186: END IF;
187:
188: IF p_phrase_type is NULL or p_phrase_type not in ('R','S') then
189: FND_MESSAGE.SET_NAME('GR','GR_INVALID_PHRASE');
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192:
193: IF p_phrase_code is NULL then
194: FND_MESSAGE.SET_NAME('GMA','SY_FIELDNAME');

Line 195: RAISE FND_API.G_EXC_ERROR;

191: END IF;
192:
193: IF p_phrase_code is NULL then
194: FND_MESSAGE.SET_NAME('GMA','SY_FIELDNAME');
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;
197:
198: IF p_action = 'I' then
199: -- Language, Source Language and Description values are required

Line 203: RAISE FND_API.G_EXC_ERROR;

199: -- Language, Source Language and Description values are required
200: -- and an error message will be written to the log file if any of the values are null.
201: IF p_language is NULL or p_source_language is NULL or p_phrase_text is null then
202: FND_MESSAGE.SET_NAME('GMA','SY_FIELDNAME');
203: RAISE FND_API.G_EXC_ERROR;
204: END IF;
205:
206: IF p_phrase_type = 'S' THEN
207: IF p_object = 'C' then

Line 847: IF (p_commit = FND_API.G_TRUE) THEN

843: END IF;
844: END IF;
845: END IF; -- IF p_action = 'I' then
846: IF (X_RETURN_STATUS = 'S') THEN
847: IF (p_commit = FND_API.G_TRUE) THEN
848: COMMIT;
849: END IF;
850: END IF;
851: EXCEPTION

Line 853: x_return_status := FND_API.G_RET_STS_ERROR;

849: END IF;
850: END IF;
851: EXCEPTION
852: WHEN LBins_err THEN
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
855: --x_msg_data := msg_data;
856: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
857: , p_count => x_msg_count

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

852: WHEN LBins_err THEN
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
855: --x_msg_data := msg_data;
856: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
857: , p_count => x_msg_count
858: , p_data => x_msg_data);
859:
860: WHEN LCins_err THEN

Line 861: x_return_status := FND_API.G_RET_STS_ERROR;

857: , p_count => x_msg_count
858: , p_data => x_msg_data);
859:
860: WHEN LCins_err THEN
861: x_return_status := FND_API.G_RET_STS_ERROR;
862: -- ROLLBACK TO SAVEPOINT FIELD_NAMES;
863: --x_msg_data := msg_data;
864: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
865: , p_count => x_msg_count

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

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

Line 868: WHEN FND_API.G_EXC_ERROR THEN

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

Line 869: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

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

877: oracle_error := APP_EXCEPTION.Get_Code;
878: FND_MESSAGE.SET_NAME('GR','GR_RECORD_EXISTS');
879: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
880: FND_MSG_PUB.ADD;
881: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
882: , p_count => x_msg_count
883: , p_data => x_msg_data);
884:
885: WHEN LTadd_err THEN

Line 886: x_return_status := FND_API.G_RET_STS_ERROR;

882: , p_count => x_msg_count
883: , p_data => x_msg_data);
884:
885: WHEN LTadd_err THEN
886: x_return_status := FND_API.G_RET_STS_ERROR;
887: --ROLLBACK TO SAVEPOINT FIELD_NAME_CLASSES;
888: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
889: P_data => x_msg_data);
890:

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

892: x_return_status := 'E';
893: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
894: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
895: FND_MSG_PUB.ADD;
896: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
897: , p_count => x_msg_count
898: , p_data => x_msg_data);
899:
900: WHEN OTHERS THEN

Line 901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

897: , p_count => x_msg_count
898: , p_data => x_msg_data);
899:
900: WHEN OTHERS THEN
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
903: , l_api_name);
904:
905: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

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

901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
903: , l_api_name);
904:
905: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
906: , p_count => x_msg_count
907: , p_data => x_msg_data);
908:
909: END RISK_SAFETY_PHRASES;