DBA Data[Home] [Help]

APPS.GR_PHRASE_GROUP_ASSOC_PKG dependencies on FND_API

Line 72: IF FND_API.To_Boolean(l_key_exists) THEN

68: 'F',
69: l_rowid,
70: l_key_exists);
71:
72: IF FND_API.To_Boolean(l_key_exists) THEN
73: RAISE Item_Exists_Error;
74: END IF;
75:
76: INSERT INTO gr_phrase_group_assoc

Line 106: IF FND_API.To_Boolean(l_key_exists) THEN

102: 'F',
103: l_rowid,
104: l_key_exists);
105:
106: IF FND_API.To_Boolean(l_key_exists) THEN
107: x_rowid := l_rowid;
108: ELSE
109: RAISE Row_Missing_Error;
110: END IF;

Line 114: IF FND_API.To_Boolean(p_commit) THEN

110: END IF;
111:
112: /* Check the commit flag and if set, then commit the work. */
113:
114: IF FND_API.To_Boolean(p_commit) THEN
115: COMMIT WORK;
116: END IF;
117:
118: EXCEPTION

Line 129: IF FND_API.To_Boolean(p_called_by_form) THEN

125: 'GR_FOREIGN_KEY_ERROR');
126: FND_MESSAGE.SET_TOKEN('TEXT',
127: l_msg_data,
128: FALSE);
129: IF FND_API.To_Boolean(p_called_by_form) THEN
130: APP_EXCEPTION.Raise_Exception;
131: ELSE
132: x_msg_data := FND_MESSAGE.Get;
133: END IF;

Line 144: IF FND_API.To_Boolean(p_called_by_form) THEN

140: 'GR_RECORD_EXISTS');
141: FND_MESSAGE.SET_TOKEN('CODE',
142: p_phrase_group_code || ' ' || p_phrase_code,
143: FALSE);
144: IF FND_API.To_Boolean(p_called_by_form) THEN
145: APP_EXCEPTION.Raise_Exception;
146: ELSE
147: x_msg_data := FND_MESSAGE.Get;
148: END IF;

Line 159: IF FND_API.To_Boolean(p_called_by_form) THEN

155: 'GR_NO_RECORD_INSERTED');
156: FND_MESSAGE.SET_TOKEN('CODE',
157: p_phrase_group_code || ' ' || p_phrase_code,
158: FALSE);
159: IF FND_API.To_Boolean(p_called_by_form) THEN
160: APP_EXCEPTION.Raise_Exception;
161: ELSE
162: x_msg_data := FND_MESSAGE.Get;
163: END IF;

Line 175: IF FND_API.To_Boolean(p_called_by_form) THEN

171: 'GR_UNEXPECTED_ERROR');
172: FND_MESSAGE.SET_TOKEN('TEXT',
173: l_msg_data,
174: FALSE);
175: IF FND_API.To_Boolean(p_called_by_form) THEN
176: APP_EXCEPTION.Raise_Exception;
177: ELSE
178: x_msg_data := FND_MESSAGE.Get;
179: END IF;

Line 256: IF FND_API.To_Boolean(p_commit) THEN

252: END IF;
253:
254: /* Check the commit flag and if set, then commit the work. */
255:
256: IF FND_API.To_Boolean(p_commit) THEN
257: COMMIT WORK;
258: END IF;
259:
260: EXCEPTION

Line 271: IF FND_API.To_Boolean(p_called_by_form) THEN

267: 'GR_FOREIGN_KEY_ERROR');
268: FND_MESSAGE.SET_TOKEN('TEXT',
269: l_msg_data,
270: FALSE);
271: IF FND_API.To_Boolean(p_called_by_form) THEN
272: APP_EXCEPTION.Raise_Exception;
273: ELSE
274: x_msg_data := FND_MESSAGE.Get;
275: END IF;

Line 286: IF FND_API.To_Boolean(p_called_by_form) THEN

282: 'GR_NO_RECORD_INSERTED');
283: FND_MESSAGE.SET_TOKEN('CODE',
284: p_phrase_group_code || ' ' || p_phrase_code,
285: FALSE);
286: IF FND_API.To_Boolean(p_called_by_form) THEN
287: APP_EXCEPTION.Raise_Exception;
288: ELSE
289: x_msg_data := FND_MESSAGE.Get;
290: END IF;

Line 302: IF FND_API.To_Boolean(p_called_by_form) THEN

298: 'GR_UNEXPECTED_ERROR');
299: FND_MESSAGE.SET_TOKEN('TEXT',
300: l_msg_data,
301: FALSE);
302: IF FND_API.To_Boolean(p_called_by_form) THEN
303: APP_EXCEPTION.Raise_Exception;
304: ELSE
305: x_msg_data := FND_MESSAGE.Get;
306: END IF;

Line 374: IF FND_API.To_Boolean(p_commit) THEN

370: IF LockGroupRcd.last_update_date <> p_last_update_date THEN
371: RAISE RECORD_CHANGED_ERROR;
372: END IF;
373:
374: IF FND_API.To_Boolean(p_commit) THEN
375: COMMIT WORK;
376: END IF;
377:
378: EXCEPTION

Line 388: IF FND_API.To_Boolean(p_called_by_form) THEN

384: 'GR_RECORD_NOT_FOUND');
385: FND_MESSAGE.SET_TOKEN('CODE',
386: p_phrase_group_code || ' ' || p_phrase_code,
387: FALSE);
388: IF FND_API.To_Boolean(p_called_by_form) THEN
389: APP_EXCEPTION.Raise_Exception;
390: ELSE
391: x_msg_data := FND_MESSAGE.Get;
392: END IF;

Line 399: IF FND_API.To_Boolean(p_called_by_form) THEN

395: ROLLBACK TO SAVEPOINT Lock_Row;
396: X_return_status := 'E';
397: FND_MESSAGE.SET_NAME('FND',
398: 'FORM_RECORD_CHANGED');
399: IF FND_API.To_Boolean(p_called_by_form) THEN
400: APP_EXCEPTION.Raise_Exception;
401: ELSE
402: x_msg_data := FND_MESSAGE.Get;
403: END IF;

Line 409: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

405: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
406: ROLLBACK TO SAVEPOINT Lock_Row;
407: x_return_status := 'L';
408: x_oracle_error := APP_EXCEPTION.Get_Code;
409: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
410: FND_MESSAGE.SET_NAME('GR',
411: 'GR_ROW_IS_LOCKED');
412: x_msg_data := FND_MESSAGE.Get;
413: END IF;

Line 425: IF FND_API.To_Boolean(p_called_by_form) THEN

421: 'GR_UNEXPECTED_ERROR');
422: FND_MESSAGE.SET_TOKEN('TEXT',
423: l_msg_data,
424: FALSE);
425: IF FND_API.To_Boolean(p_called_by_form) THEN
426: APP_EXCEPTION.Raise_Exception;
427: ELSE
428: x_msg_data := FND_MESSAGE.Get;
429: END IF;

Line 498: IF FND_API.TO_Boolean(p_commit) THEN

494: WHERE rowid = p_rowid;
495:
496: /* Check the commit flag and if set, then commit the work. */
497:
498: IF FND_API.TO_Boolean(p_commit) THEN
499: COMMIT WORK;
500: END IF;
501:
502: EXCEPTION

Line 508: IF FND_API.To_Boolean(p_called_by_form) THEN

504: WHEN Check_Integrity_Error THEN
505: ROLLBACK TO SAVEPOINT Delete_Row;
506: x_return_status := l_return_status;
507: x_oracle_error := l_oracle_error;
508: IF FND_API.To_Boolean(p_called_by_form) THEN
509: APP_EXCEPTION.Raise_Exception;
510: ELSE
511: x_msg_data := FND_MESSAGE.Get;
512: END IF;

Line 523: IF FND_API.To_Boolean(p_called_by_form) THEN

519: 'GR_RECORD_NOT_FOUND');
520: FND_MESSAGE.SET_TOKEN('CODE',
521: p_phrase_group_code || ' ' || p_phrase_code,
522: FALSE);
523: IF FND_API.To_Boolean(p_called_by_form) THEN
524: APP_EXCEPTION.Raise_Exception;
525: ELSE
526: x_msg_data := FND_MESSAGE.Get;
527: END IF;

Line 540: IF FND_API.To_Boolean(p_called_by_form) THEN

536: 'GR_UNEXPECTED_ERROR');
537: FND_MESSAGE.SET_TOKEN('TEXT',
538: l_msg_data,
539: FALSE);
540: IF FND_API.To_Boolean(p_called_by_form) THEN
541: APP_EXCEPTION.Raise_Exception;
542: ELSE
543: x_msg_data := FND_MESSAGE.Get;
544: END IF;

Line 582: IF FND_API.To_Boolean(p_commit) THEN

578:
579: DELETE FROM gr_phrase_group_assoc
580: WHERE phrase_group_code = p_phrase_group_code;
581:
582: IF FND_API.To_Boolean(p_commit) THEN
583: COMMIT WORK;
584: END IF;
585:
586: EXCEPTION

Line 598: IF FND_API.To_Boolean(p_called_by_form) THEN

594: 'GR_UNEXPECTED_ERROR');
595: FND_MESSAGE.SET_TOKEN('TEXT',
596: l_msg_token,
597: FALSE);
598: IF FND_API.To_Boolean(p_called_by_form) THEN
599: APP_EXCEPTION.Raise_Exception;
600: ELSE
601: x_msg_data := FND_MESSAGE.Get;
602: END IF;

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

645: 'F',
646: l_rowid,
647: l_key_exists);
648:
649: IF NOT FND_API.To_Boolean(l_key_exists) THEN
650: x_return_status := 'E';
651: FND_MESSAGE.SET_NAME('GR',
652: 'GR_RECORD_NOT_FOUND');
653: FND_MESSAGE.SET_TOKEN('CODE',

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

664: 'F',
665: l_rowid,
666: l_key_exists);
667:
668: IF NOT FND_API.To_Boolean(l_key_exists) THEN
669: x_return_status := 'E';
670: FND_MESSAGE.SET_NAME('GR',
671: 'GR_RECORD_NOT_FOUND');
672: 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 766: IF FND_API.To_Boolean(p_called_by_form) THEN

762: 'GR_UNEXPECTED_ERROR');
763: FND_MESSAGE.SET_TOKEN('TEXT',
764: l_msg_data,
765: FALSE);
766: IF FND_API.To_Boolean(p_called_by_form) THEN
767: APP_EXCEPTION.Raise_Exception;
768: ELSE
769: x_msg_data := FND_MESSAGE.Get;
770: END IF;

Line 824: IF FND_API.To_Boolean(p_called_by_form) THEN

820: 'GR_UNEXPECTED_ERROR');
821: FND_MESSAGE.SET_TOKEN('TEXT',
822: l_msg_data,
823: FALSE);
824: IF FND_API.To_Boolean(p_called_by_form) THEN
825: APP_EXCEPTION.Raise_Exception;
826: END IF;
827:
828: END Check_Primary_Key;