DBA Data[Home] [Help]

APPS.GR_PHRASE_CONFLICTS_PKG dependencies on FND_API

Line 69: IF FND_API.To_Boolean(l_key_exists) THEN

65: 'F',
66: l_rowid,
67: l_key_exists);
68:
69: IF FND_API.To_Boolean(l_key_exists) THEN
70: RAISE Label_Exists_Error;
71: END IF;
72:
73: INSERT INTO gr_phrase_conflicts

Line 101: IF FND_API.To_Boolean(l_key_exists) THEN

97: 'F',
98: l_rowid,
99: l_key_exists);
100:
101: IF FND_API.To_Boolean(l_key_exists) THEN
102: x_rowid := l_rowid;
103: ELSE
104: RAISE Row_Missing_Error;
105: END IF;

Line 109: IF FND_API.To_Boolean(p_commit) THEN

105: END IF;
106:
107: /* Check the commit flag and if set, then commit the work. */
108:
109: IF FND_API.To_Boolean(p_commit) THEN
110: COMMIT WORK;
111: END IF;
112:
113: EXCEPTION

Line 124: IF FND_API.To_Boolean(p_called_by_form) THEN

120: 'GR_FOREIGN_KEY_ERROR');
121: FND_MESSAGE.SET_TOKEN('TEXT',
122: l_msg_data,
123: FALSE);
124: IF FND_API.To_Boolean(p_called_by_form) THEN
125: APP_EXCEPTION.Raise_Exception;
126: ELSE
127: x_msg_data := FND_MESSAGE.Get;
128: END IF;

Line 139: IF FND_API.To_Boolean(p_called_by_form) THEN

135: 'GR_RECORD_EXISTS');
136: FND_MESSAGE.SET_TOKEN('CODE',
137: p_phrase_code,
138: FALSE);
139: IF FND_API.To_Boolean(p_called_by_form) THEN
140: APP_EXCEPTION.Raise_Exception;
141: ELSE
142: x_msg_data := FND_MESSAGE.Get;
143: END IF;

Line 154: IF FND_API.To_Boolean(p_called_by_form) THEN

150: 'GR_NO_RECORD_INSERTED');
151: FND_MESSAGE.SET_TOKEN('CODE',
152: p_phrase_code,
153: FALSE);
154: IF FND_API.To_Boolean(p_called_by_form) THEN
155: APP_EXCEPTION.Raise_Exception;
156: ELSE
157: x_msg_data := FND_MESSAGE.Get;
158: END IF;

Line 170: IF FND_API.To_Boolean(p_called_by_form) THEN

166: 'GR_UNEXPECTED_ERROR');
167: FND_MESSAGE.SET_TOKEN('TEXT',
168: l_msg_data,
169: FALSE);
170: IF FND_API.To_Boolean(p_called_by_form) THEN
171: APP_EXCEPTION.Raise_Exception;
172: ELSE
173: x_msg_data := FND_MESSAGE.Get;
174: END IF;

Line 248: IF FND_API.To_Boolean(p_commit) THEN

244: END IF;
245:
246: /* Check the commit flag and if set, then commit the work. */
247:
248: IF FND_API.To_Boolean(p_commit) THEN
249: COMMIT WORK;
250: END IF;
251:
252: EXCEPTION

Line 263: IF FND_API.To_Boolean(p_called_by_form) THEN

259: 'GR_FOREIGN_KEY_ERROR');
260: FND_MESSAGE.SET_TOKEN('TEXT',
261: l_msg_data,
262: FALSE);
263: IF FND_API.To_Boolean(p_called_by_form) THEN
264: APP_EXCEPTION.Raise_Exception;
265: ELSE
266: x_msg_data := FND_MESSAGE.Get;
267: END IF;

Line 278: IF FND_API.To_Boolean(p_called_by_form) THEN

274: 'GR_NO_RECORD_INSERTED');
275: FND_MESSAGE.SET_TOKEN('CODE',
276: p_phrase_code,
277: FALSE);
278: IF FND_API.To_Boolean(p_called_by_form) THEN
279: APP_EXCEPTION.Raise_Exception;
280: ELSE
281: x_msg_data := FND_MESSAGE.Get;
282: END IF;

Line 294: IF FND_API.To_Boolean(p_called_by_form) THEN

290: 'GR_UNEXPECTED_ERROR');
291: FND_MESSAGE.SET_TOKEN('TEXT',
292: l_msg_data,
293: FALSE);
294: IF FND_API.To_Boolean(p_called_by_form) THEN
295: APP_EXCEPTION.Raise_Exception;
296: ELSE
297: x_msg_data := FND_MESSAGE.Get;
298: END IF;

Line 363: IF FND_API.To_Boolean(p_commit) THEN

359: RAISE No_Data_Found_Error;
360: END IF;
361: CLOSE c_lock_conflicts;
362:
363: IF FND_API.To_Boolean(p_commit) THEN
364: COMMIT WORK;
365: END IF;
366:
367: EXCEPTION

Line 377: IF FND_API.To_Boolean(p_called_by_form) THEN

373: 'GR_RECORD_NOT_FOUND');
374: FND_MESSAGE.SET_TOKEN('CODE',
375: p_phrase_code,
376: FALSE);
377: IF FND_API.To_Boolean(p_called_by_form) THEN
378: APP_EXCEPTION.Raise_Exception;
379: ELSE
380: x_msg_data := FND_MESSAGE.Get;
381: END IF;

Line 389: IF FND_API.To_Boolean(p_called_by_form) THEN

385: x_return_status := 'E';
386: x_oracle_error := APP_EXCEPTION.Get_Code;
387: FND_MESSAGE.SET_NAME('GR',
388: 'GR_ROW_IS_LOCKED');
389: IF FND_API.To_Boolean(p_called_by_form) THEN
390: APP_EXCEPTION.Raise_Exception;
391: ELSE
392: x_msg_data := FND_MESSAGE.Get;
393: END IF;

Line 405: IF FND_API.To_Boolean(p_called_by_form) THEN

401: 'GR_UNEXPECTED_ERROR');
402: FND_MESSAGE.SET_TOKEN('TEXT',
403: l_msg_data,
404: FALSE);
405: IF FND_API.To_Boolean(p_called_by_form) THEN
406: APP_EXCEPTION.Raise_Exception;
407: ELSE
408: x_msg_data := FND_MESSAGE.Get;
409: END IF;

Line 476: IF FND_API.TO_Boolean(p_commit) THEN

472: WHERE rowid = p_rowid;
473:
474: /* Check the commit flag and if set, then commit the work. */
475:
476: IF FND_API.TO_Boolean(p_commit) THEN
477: COMMIT WORK;
478: END IF;
479:
480: EXCEPTION

Line 486: IF FND_API.To_Boolean(p_called_by_form) THEN

482: WHEN Check_Integrity_Error THEN
483: ROLLBACK TO SAVEPOINT Delete_Row;
484: x_return_status := l_return_status;
485: x_oracle_error := l_oracle_error;
486: IF FND_API.To_Boolean(p_called_by_form) THEN
487: APP_EXCEPTION.Raise_Exception;
488: ELSE
489: x_msg_data := FND_MESSAGE.Get;
490: END IF;

Line 501: IF FND_API.To_Boolean(p_called_by_form) THEN

497: 'GR_RECORD_NOT_FOUND');
498: FND_MESSAGE.SET_TOKEN('CODE',
499: p_phrase_code,
500: FALSE);
501: IF FND_API.To_Boolean(p_called_by_form) THEN
502: APP_EXCEPTION.Raise_Exception;
503: ELSE
504: x_msg_data := FND_MESSAGE.Get;
505: END IF;

Line 518: IF FND_API.To_Boolean(p_called_by_form) THEN

514: 'GR_UNEXPECTED_ERROR');
515: FND_MESSAGE.SET_TOKEN('TEXT',
516: l_msg_data,
517: FALSE);
518: IF FND_API.To_Boolean(p_called_by_form) THEN
519: APP_EXCEPTION.Raise_Exception;
520: ELSE
521: x_msg_data := FND_MESSAGE.Get;
522: END IF;

Line 560: IF FND_API.To_Boolean(p_commit) THEN

556:
557: DELETE FROM gr_phrase_conflicts
558: WHERE phrase_code = p_phrase_code;
559:
560: IF FND_API.To_Boolean(p_commit) THEN
561: COMMIT WORK;
562: END IF;
563:
564: EXCEPTION

Line 576: IF FND_API.To_Boolean(p_called_by_form) THEN

572: 'GR_UNEXPECTED_ERROR');
573: FND_MESSAGE.SET_TOKEN('TEXT',
574: l_msg_token,
575: FALSE);
576: IF FND_API.To_Boolean(p_called_by_form) THEN
577: APP_EXCEPTION.Raise_Exception;
578: ELSE
579: x_msg_data := FND_MESSAGE.Get;
580: END IF;

Line 624: IF NOT FND_API.To_Boolean(l_key_exists) THEN

620: 'F',
621: l_rowid,
622: l_key_exists);
623:
624: IF NOT FND_API.To_Boolean(l_key_exists) THEN
625: x_return_status := 'E';
626: FND_MESSAGE.SET_NAME('GR',
627: 'GR_RECORD_NOT_FOUND');
628: FND_MESSAGE.SET_TOKEN('CODE',

Line 643: IF NOT FND_API.To_Boolean(l_key_exists) THEN

639: 'F',
640: l_rowid,
641: l_key_exists);
642:
643: IF NOT FND_API.To_Boolean(l_key_exists) THEN
644: x_return_status := 'E';
645: FND_MESSAGE.SET_NAME('GR',
646: 'GR_RECORD_NOT_FOUND');
647: FND_MESSAGE.SET_TOKEN('CODE',

Line 663: IF NOT FND_API.To_Boolean(l_key_exists) THEN

659: 'F',
660: l_rowid,
661: l_key_exists);
662:
663: IF NOT FND_API.To_Boolean(l_key_exists) THEN
664: x_return_status := 'E';
665: FND_MESSAGE.SET_NAME('GR',
666: 'GR_RECORD_NOT_FOUND');
667: FND_MESSAGE.SET_TOKEN('CODE',

Line 747: IF FND_API.To_Boolean(p_called_by_form) THEN

743: 'GR_UNEXPECTED_ERROR');
744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_data,
746: FALSE);
747: IF FND_API.To_Boolean(p_called_by_form) THEN
748: APP_EXCEPTION.Raise_Exception;
749: ELSE
750: x_msg_data := FND_MESSAGE.Get;
751: END IF;

Line 806: IF FND_API.To_Boolean(p_called_by_form) THEN

802: 'GR_UNEXPECTED_ERROR');
803: FND_MESSAGE.SET_TOKEN('TEXT',
804: l_msg_data,
805: FALSE);
806: IF FND_API.To_Boolean(p_called_by_form) THEN
807: APP_EXCEPTION.Raise_Exception;
808: END IF;
809:
810: END Check_Primary_Key;