DBA Data[Home] [Help]

APPS.GR_PHRASE_GROUP_CODES_PKG dependencies on FND_API

Line 67: IF FND_API.To_Boolean(l_key_exists) THEN

63: 'F',
64: l_rowid,
65: l_key_exists);
66:
67: IF FND_API.To_Boolean(l_key_exists) THEN
68: RAISE Item_Exists_Error;
69: END IF;
70:
71: INSERT INTO gr_phrase_group_codes

Line 96: IF FND_API.To_Boolean(l_key_exists) THEN

92: 'F',
93: l_rowid,
94: l_key_exists);
95:
96: IF FND_API.To_Boolean(l_key_exists) THEN
97: x_rowid := l_rowid;
98: ELSE
99: RAISE Row_Missing_Error;
100: END IF;

Line 104: IF FND_API.To_Boolean(p_commit) THEN

100: END IF;
101:
102: /* Check the commit flag and if set, then commit the work. */
103:
104: IF FND_API.To_Boolean(p_commit) THEN
105: COMMIT WORK;
106: END IF;
107:
108: EXCEPTION

Line 119: IF FND_API.To_Boolean(p_called_by_form) THEN

115: 'GR_FOREIGN_KEY_ERROR');
116: FND_MESSAGE.SET_TOKEN('TEXT',
117: l_msg_data,
118: FALSE);
119: IF FND_API.To_Boolean(p_called_by_form) THEN
120: APP_EXCEPTION.Raise_Exception;
121: ELSE
122: x_msg_data := FND_MESSAGE.Get;
123: END IF;

Line 134: IF FND_API.To_Boolean(p_called_by_form) THEN

130: 'GR_RECORD_EXISTS');
131: FND_MESSAGE.SET_TOKEN('CODE',
132: p_phrase_group_code,
133: FALSE);
134: IF FND_API.To_Boolean(p_called_by_form) THEN
135: APP_EXCEPTION.Raise_Exception;
136: ELSE
137: x_msg_data := FND_MESSAGE.Get;
138: END IF;

Line 149: IF FND_API.To_Boolean(p_called_by_form) THEN

145: 'GR_NO_RECORD_INSERTED');
146: FND_MESSAGE.SET_TOKEN('CODE',
147: p_phrase_group_code,
148: FALSE);
149: IF FND_API.To_Boolean(p_called_by_form) THEN
150: APP_EXCEPTION.Raise_Exception;
151: ELSE
152: x_msg_data := FND_MESSAGE.Get;
153: END IF;

Line 165: IF FND_API.To_Boolean(p_called_by_form) THEN

161: 'GR_UNEXPECTED_ERROR');
162: FND_MESSAGE.SET_TOKEN('TEXT',
163: l_msg_data,
164: FALSE);
165: IF FND_API.To_Boolean(p_called_by_form) THEN
166: APP_EXCEPTION.Raise_Exception;
167: ELSE
168: x_msg_data := FND_MESSAGE.Get;
169: END IF;

Line 240: IF FND_API.To_Boolean(p_commit) THEN

236: END IF;
237:
238: /* Check the commit flag and if set, then commit the work. */
239:
240: IF FND_API.To_Boolean(p_commit) THEN
241: COMMIT WORK;
242: END IF;
243:
244: EXCEPTION

Line 255: IF FND_API.To_Boolean(p_called_by_form) THEN

251: 'GR_FOREIGN_KEY_ERROR');
252: FND_MESSAGE.SET_TOKEN('TEXT',
253: l_msg_data,
254: FALSE);
255: IF FND_API.To_Boolean(p_called_by_form) THEN
256: APP_EXCEPTION.Raise_Exception;
257: ELSE
258: x_msg_data := FND_MESSAGE.Get;
259: END IF;

Line 270: IF FND_API.To_Boolean(p_called_by_form) THEN

266: 'GR_NO_RECORD_INSERTED');
267: FND_MESSAGE.SET_TOKEN('CODE',
268: p_phrase_group_code,
269: FALSE);
270: IF FND_API.To_Boolean(p_called_by_form) THEN
271: APP_EXCEPTION.Raise_Exception;
272: ELSE
273: x_msg_data := FND_MESSAGE.Get;
274: END IF;

Line 286: IF FND_API.To_Boolean(p_called_by_form) THEN

282: 'GR_UNEXPECTED_ERROR');
283: FND_MESSAGE.SET_TOKEN('TEXT',
284: l_msg_data,
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 357: IF FND_API.To_Boolean(p_commit) THEN

353: IF LockGroupRcd.last_update_date <> p_last_update_date THEN
354: RAISE RECORD_CHANGED_ERROR;
355: END IF;
356:
357: IF FND_API.To_Boolean(p_commit) THEN
358: COMMIT WORK;
359: END IF;
360:
361: EXCEPTION

Line 371: IF FND_API.To_Boolean(p_called_by_form) THEN

367: 'GR_RECORD_NOT_FOUND');
368: FND_MESSAGE.SET_TOKEN('CODE',
369: p_phrase_group_code,
370: FALSE);
371: IF FND_API.To_Boolean(p_called_by_form) THEN
372: APP_EXCEPTION.Raise_Exception;
373: ELSE
374: x_msg_data := FND_MESSAGE.Get;
375: END IF;

Line 381: IF FND_API.To_Boolean(p_called_by_form) THEN

377: ROLLBACK TO SAVEPOINT Lock_Row;
378: X_return_status := 'E';
379: FND_MESSAGE.SET_NAME('FND',
380: 'FORM_RECORD_CHANGED');
381: IF FND_API.To_Boolean(p_called_by_form) THEN
382: APP_EXCEPTION.Raise_Exception;
383: ELSE
384: x_msg_data := FND_MESSAGE.Get;
385: END IF;

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

386: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
387: ROLLBACK TO SAVEPOINT Lock_Row;
388: x_return_status := 'L';
389: x_oracle_error := APP_EXCEPTION.Get_Code;
390: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
391: FND_MESSAGE.SET_NAME('GR',
392: 'GR_ROW_IS_LOCKED');
393: x_msg_data := FND_MESSAGE.Get;
394: 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 474: IF FND_API.TO_Boolean(p_commit) THEN

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

Line 484: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 499: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 516: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 688: IF FND_API.To_Boolean(p_called_by_form) THEN

684: FALSE);
685: FND_MESSAGE.SET_TOKEN('TABLES',
686: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
687: FALSE);
688: IF FND_API.To_Boolean(p_called_by_form) THEN
689: APP_EXCEPTION.Raise_Exception;
690: ELSE
691: x_msg_data := FND_MESSAGE.Get;
692: END IF;

Line 703: IF FND_API.To_Boolean(p_called_by_form) THEN

699: 'GR_UNEXPECTED_ERROR');
700: FND_MESSAGE.SET_TOKEN('TEXT',
701: l_msg_data,
702: FALSE);
703: IF FND_API.To_Boolean(p_called_by_form) THEN
704: APP_EXCEPTION.Raise_Exception;
705: ELSE
706: x_msg_data := FND_MESSAGE.Get;
707: END IF;

Line 758: IF FND_API.To_Boolean(p_called_by_form) THEN

754: 'GR_UNEXPECTED_ERROR');
755: FND_MESSAGE.SET_TOKEN('TEXT',
756: l_msg_data,
757: FALSE);
758: IF FND_API.To_Boolean(p_called_by_form) THEN
759: APP_EXCEPTION.Raise_Exception;
760: END IF;
761:
762: END Check_Primary_Key;