DBA Data[Home] [Help]

APPS.GR_PROPERTIES_B_PKG dependencies on FND_API

Line 74: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 111: IF FND_API.To_Boolean(l_key_exists) THEN

107: 'F',
108: l_rowid,
109: l_key_exists);
110:
111: IF FND_API.To_Boolean(l_key_exists) THEN
112: x_rowid := l_rowid;
113: ELSE
114: RAISE Row_Missing_Error;
115: END IF;

Line 119: IF FND_API.To_Boolean(p_commit) THEN

115: END IF;
116:
117: /* Check the commit flag and if set, then commit the work. */
118:
119: IF FND_API.To_Boolean(p_commit) THEN
120: COMMIT WORK;
121: END IF;
122:
123: EXCEPTION

Line 134: IF FND_API.To_Boolean(p_called_by_form) THEN

130: 'GR_FOREIGN_KEY_ERROR');
131: FND_MESSAGE.SET_TOKEN('TEXT',
132: l_msg_data,
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_RECORD_EXISTS');
146: FND_MESSAGE.SET_TOKEN('CODE',
147: p_property_id,
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 164: IF FND_API.To_Boolean(p_called_by_form) THEN

160: 'GR_NO_RECORD_INSERTED');
161: FND_MESSAGE.SET_TOKEN('CODE',
162: p_property_id,
163: FALSE);
164: IF FND_API.To_Boolean(p_called_by_form) THEN
165: APP_EXCEPTION.Raise_Exception;
166: ELSE
167: x_msg_data := FND_MESSAGE.Get;
168: END IF;

Line 180: IF FND_API.To_Boolean(p_called_by_form) THEN

176: 'GR_UNEXPECTED_ERROR');
177: FND_MESSAGE.SET_TOKEN('TEXT',
178: l_msg_data,
179: FALSE);
180: IF FND_API.To_Boolean(p_called_by_form) THEN
181: APP_EXCEPTION.Raise_Exception;
182: ELSE
183: x_msg_data := FND_MESSAGE.Get;
184: END IF;

Line 267: IF FND_API.To_Boolean(p_commit) THEN

263: END IF;
264:
265: /* Check the commit flag and if set, then commit the work. */
266:
267: IF FND_API.To_Boolean(p_commit) THEN
268: COMMIT WORK;
269: END IF;
270:
271: EXCEPTION

Line 282: IF FND_API.To_Boolean(p_called_by_form) THEN

278: 'GR_FOREIGN_KEY_ERROR');
279: FND_MESSAGE.SET_TOKEN('TEXT',
280: l_msg_data,
281: FALSE);
282: IF FND_API.To_Boolean(p_called_by_form) THEN
283: APP_EXCEPTION.Raise_Exception;
284: ELSE
285: x_msg_data := FND_MESSAGE.Get;
286: END IF;

Line 297: IF FND_API.To_Boolean(p_called_by_form) THEN

293: 'GR_NO_RECORD_INSERTED');
294: FND_MESSAGE.SET_TOKEN('CODE',
295: p_property_id,
296: FALSE);
297: IF FND_API.To_Boolean(p_called_by_form) THEN
298: APP_EXCEPTION.Raise_Exception;
299: ELSE
300: x_msg_data := FND_MESSAGE.Get;
301: END IF;

Line 313: IF FND_API.To_Boolean(p_called_by_form) THEN

309: 'GR_UNEXPECTED_ERROR');
310: FND_MESSAGE.SET_TOKEN('TEXT',
311: l_msg_data,
312: FALSE);
313: IF FND_API.To_Boolean(p_called_by_form) THEN
314: APP_EXCEPTION.Raise_Exception;
315: ELSE
316: x_msg_data := FND_MESSAGE.Get;
317: END IF;

Line 384: IF FND_API.To_Boolean(p_commit) THEN

380: RAISE No_Data_Found_Error;
381: END IF;
382: CLOSE c_lock_properties;
383:
384: IF FND_API.To_Boolean(p_commit) THEN
385: COMMIT WORK;
386: END IF;
387:
388: EXCEPTION

Line 398: IF FND_API.To_Boolean(p_called_by_form) THEN

394: 'GR_RECORD_NOT_FOUND');
395: FND_MESSAGE.SET_TOKEN('CODE',
396: p_property_id,
397: FALSE);
398: IF FND_API.To_Boolean(p_called_by_form) THEN
399: APP_EXCEPTION.Raise_Exception;
400: ELSE
401: x_msg_data := FND_MESSAGE.Get;
402: END IF;

Line 410: IF FND_API.To_Boolean(p_called_by_form) THEN

406: x_return_status := 'E';
407: x_oracle_error := APP_EXCEPTION.Get_Code;
408: FND_MESSAGE.SET_NAME('GR',
409: 'GR_ROW_IS_LOCKED');
410: IF FND_API.To_Boolean(p_called_by_form) THEN
411: APP_EXCEPTION.Raise_Exception;
412: ELSE
413: x_msg_data := FND_MESSAGE.Get;
414: END IF;

Line 426: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 503: IF FND_API.TO_Boolean(p_commit) THEN

499: WHERE rowid = p_rowid;
500:
501: /* Check the commit flag and if set, then commit the work. */
502:
503: IF FND_API.TO_Boolean(p_commit) THEN
504: COMMIT WORK;
505: END IF;
506:
507: EXCEPTION

Line 513: IF FND_API.To_Boolean(p_called_by_form) THEN

509: WHEN Check_Integrity_Error THEN
510: ROLLBACK TO SAVEPOINT Delete_Row;
511: x_return_status := l_return_status;
512: x_oracle_error := l_oracle_error;
513: IF FND_API.To_Boolean(p_called_by_form) THEN
514: APP_EXCEPTION.Raise_Exception;
515: ELSE
516: x_msg_data := FND_MESSAGE.Get;
517: END IF;

Line 528: IF FND_API.To_Boolean(p_called_by_form) THEN

524: 'GR_RECORD_NOT_FOUND');
525: FND_MESSAGE.SET_TOKEN('CODE',
526: p_property_id,
527: FALSE);
528: IF FND_API.To_Boolean(p_called_by_form) THEN
529: APP_EXCEPTION.Raise_Exception;
530: ELSE
531: x_msg_data := FND_MESSAGE.Get;
532: END IF;

Line 545: IF FND_API.To_Boolean(p_called_by_form) THEN

541: 'GR_UNEXPECTED_ERROR');
542: FND_MESSAGE.SET_TOKEN('TEXT',
543: l_msg_data,
544: FALSE);
545: IF FND_API.To_Boolean(p_called_by_form) THEN
546: APP_EXCEPTION.Raise_Exception;
547: ELSE
548: x_msg_data := FND_MESSAGE.Get;
549: END IF;

Line 694: IF FND_API.To_Boolean(p_called_by_form) THEN

690: FALSE);
691: FND_MESSAGE.SET_TOKEN('TABLES',
692: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
693: FALSE);
694: IF FND_API.To_Boolean(p_called_by_form) THEN
695: APP_EXCEPTION.Raise_Exception;
696: ELSE
697: x_msg_data := FND_MESSAGE.Get;
698: END IF;

Line 709: IF FND_API.To_Boolean(p_called_by_form) THEN

705: 'GR_UNEXPECTED_ERROR');
706: FND_MESSAGE.SET_TOKEN('TEXT',
707: l_msg_data,
708: FALSE);
709: IF FND_API.To_Boolean(p_called_by_form) THEN
710: APP_EXCEPTION.Raise_Exception;
711: ELSE
712: x_msg_data := FND_MESSAGE.Get;
713: END IF;

Line 765: IF FND_API.To_Boolean(p_called_by_form) THEN

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