DBA Data[Home] [Help]

APPS.GR_LABEL_PROPERTIES_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_label_properties

Line 117: IF FND_API.To_Boolean(l_key_exists) THEN

113: 'F',
114: l_rowid,
115: l_key_exists);
116:
117: IF FND_API.To_Boolean(l_key_exists) THEN
118: x_rowid := l_rowid;
119: ELSE
120: RAISE Row_Missing_Error;
121: END IF;

Line 125: IF FND_API.To_Boolean(p_commit) THEN

121: END IF;
122:
123: /* Check the commit flag and if set, then commit the work. */
124:
125: IF FND_API.To_Boolean(p_commit) THEN
126: COMMIT WORK;
127: END IF;
128:
129: EXCEPTION

Line 140: IF FND_API.To_Boolean(p_called_by_form) THEN

136: 'GR_FOREIGN_KEY_ERROR');
137: FND_MESSAGE.SET_TOKEN('TEXT',
138: l_msg_data,
139: FALSE);
140: IF FND_API.To_Boolean(p_called_by_form) THEN
141: APP_EXCEPTION.Raise_Exception;
142: ELSE
143: x_msg_data := FND_MESSAGE.Get;
144: END IF;

Line 156: IF FND_API.To_Boolean(p_called_by_form) THEN

152: 'GR_RECORD_EXISTS');
153: FND_MESSAGE.SET_TOKEN('CODE',
154: l_msg_token,
155: FALSE);
156: IF FND_API.To_Boolean(p_called_by_form) THEN
157: APP_EXCEPTION.Raise_Exception;
158: ELSE
159: x_msg_data := FND_MESSAGE.Get;
160: END IF;

Line 172: IF FND_API.To_Boolean(p_called_by_form) THEN

168: 'GR_NO_RECORD_INSERTED');
169: FND_MESSAGE.SET_TOKEN('CODE',
170: l_msg_token,
171: FALSE);
172: IF FND_API.To_Boolean(p_called_by_form) THEN
173: APP_EXCEPTION.Raise_Exception;
174: ELSE
175: x_msg_data := FND_MESSAGE.Get;
176: END IF;

Line 189: IF FND_API.To_Boolean(p_called_by_form) THEN

185: 'GR_UNEXPECTED_ERROR');
186: FND_MESSAGE.SET_TOKEN('TEXT',
187: l_msg_token||sqlerrm,
188: FALSE);
189: IF FND_API.To_Boolean(p_called_by_form) THEN
190: APP_EXCEPTION.Raise_Exception;
191: ELSE
192: x_msg_data := FND_MESSAGE.Get;
193: END IF;

Line 272: IF FND_API.To_Boolean(p_commit) THEN

268: END IF;
269:
270: /* Check the commit flag and if set, then commit the work. */
271:
272: IF FND_API.To_Boolean(p_commit) THEN
273: COMMIT WORK;
274: END IF;
275:
276: EXCEPTION

Line 287: IF FND_API.To_Boolean(p_called_by_form) THEN

283: 'GR_FOREIGN_KEY_ERROR');
284: FND_MESSAGE.SET_TOKEN('TEXT',
285: l_msg_data,
286: FALSE);
287: IF FND_API.To_Boolean(p_called_by_form) THEN
288: APP_EXCEPTION.Raise_Exception;
289: ELSE
290: x_msg_data := FND_MESSAGE.Get;
291: END IF;

Line 302: IF FND_API.To_Boolean(p_called_by_form) THEN

298: 'GR_NO_RECORD_INSERTED');
299: FND_MESSAGE.SET_TOKEN('CODE',
300: l_msg_token,
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 318: IF FND_API.To_Boolean(p_called_by_form) THEN

314: 'GR_UNEXPECTED_ERROR');
315: FND_MESSAGE.SET_TOKEN('TEXT',
316: l_msg_token||sqlerrm,
317: FALSE);
318: IF FND_API.To_Boolean(p_called_by_form) THEN
319: APP_EXCEPTION.Raise_Exception;
320: ELSE
321: x_msg_data := FND_MESSAGE.Get;
322: END IF;

Line 391: IF FND_API.To_Boolean(p_commit) THEN

387: RAISE No_Data_Found_Error;
388: END IF;
389: CLOSE c_lock_label_properties;
390:
391: IF FND_API.To_Boolean(p_commit) THEN
392: COMMIT WORK;
393: END IF;
394:
395: EXCEPTION

Line 405: IF FND_API.To_Boolean(p_called_by_form) THEN

401: 'GR_RECORD_NOT_FOUND');
402: FND_MESSAGE.SET_TOKEN('CODE',
403: l_msg_token,
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 417: IF FND_API.To_Boolean(p_called_by_form) THEN

413: x_return_status := 'E';
414: x_oracle_error := APP_EXCEPTION.Get_Code;
415: FND_MESSAGE.SET_NAME('GR',
416: 'GR_ROW_IS_LOCKED');
417: IF FND_API.To_Boolean(p_called_by_form) THEN
418: APP_EXCEPTION.Raise_Exception;
419: ELSE
420: x_msg_data := FND_MESSAGE.Get;
421: END IF;

Line 433: IF FND_API.To_Boolean(p_called_by_form) THEN

429: 'GR_UNEXPECTED_ERROR');
430: FND_MESSAGE.SET_TOKEN('TEXT',
431: l_msg_token||sqlerrm,
432: FALSE);
433: IF FND_API.To_Boolean(p_called_by_form) THEN
434: APP_EXCEPTION.Raise_Exception;
435: ELSE
436: x_msg_data := FND_MESSAGE.Get;
437: END IF;

Line 510: IF FND_API.TO_Boolean(p_commit) THEN

506: WHERE rowid = p_rowid;
507:
508: /* Check the commit flag and if set, then commit the work. */
509:
510: IF FND_API.TO_Boolean(p_commit) THEN
511: COMMIT WORK;
512: END IF;
513:
514: EXCEPTION

Line 520: IF FND_API.To_Boolean(p_called_by_form) THEN

516: WHEN Check_Integrity_Error THEN
517: ROLLBACK TO SAVEPOINT Delete_Row;
518: x_return_status := l_return_status;
519: x_oracle_error := l_oracle_error;
520: IF FND_API.To_Boolean(p_called_by_form) THEN
521: APP_EXCEPTION.Raise_Exception;
522: ELSE
523: x_msg_data := FND_MESSAGE.Get;
524: END IF;

Line 535: IF FND_API.To_Boolean(p_called_by_form) THEN

531: 'GR_RECORD_NOT_FOUND');
532: FND_MESSAGE.SET_TOKEN('CODE',
533: l_msg_token,
534: FALSE);
535: IF FND_API.To_Boolean(p_called_by_form) THEN
536: APP_EXCEPTION.Raise_Exception;
537: ELSE
538: x_msg_data := FND_MESSAGE.Get;
539: END IF;

Line 552: IF FND_API.To_Boolean(p_called_by_form) THEN

548: 'GR_UNEXPECTED_ERROR');
549: FND_MESSAGE.SET_TOKEN('TEXT',
550: l_msg_token||sqlerrm,
551: FALSE);
552: IF FND_API.To_Boolean(p_called_by_form) THEN
553: APP_EXCEPTION.Raise_Exception;
554: ELSE
555: x_msg_data := FND_MESSAGE.Get;
556: END IF;

Line 625: IF FND_API.To_Boolean(p_commit) THEN

621: l_msg_token := 'Invalid Delete Option';
622: RAISE Null_Delete_Option_Error;
623: END IF;
624:
625: IF FND_API.To_Boolean(p_commit) THEN
626: COMMIT WORK;
627: END IF;
628:
629: EXCEPTION

Line 639: IF FND_API.To_Boolean(p_called_by_form) THEN

635: 'GR_NULL_VALUE');
636: FND_MESSAGE.SET_TOKEN('CODE',
637: l_msg_token,
638: FALSE);
639: IF FND_API.To_Boolean(p_called_by_form) THEN
640: APP_EXCEPTION.Raise_Exception;
641: ELSE
642: x_msg_data := FND_MESSAGE.Get;
643: END IF;

Line 655: IF FND_API.To_Boolean(p_called_by_form) THEN

651: 'GR_UNEXPECTED_ERROR');
652: FND_MESSAGE.SET_TOKEN('TEXT',
653: l_msg_token||sqlerrm,
654: FALSE);
655: IF FND_API.To_Boolean(p_called_by_form) THEN
656: APP_EXCEPTION.Raise_Exception;
657: ELSE
658: x_msg_data := FND_MESSAGE.Get;
659: END IF;

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

704: 'F',
705: l_rowid,
706: l_key_exists);
707:
708: IF NOT FND_API.To_Boolean(l_key_exists) THEN
709: x_return_status := 'E';
710: l_msg_token := p_label_code || ' ';
711: END IF;
712:

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

718: 'F',
719: l_rowid,
720: l_key_exists);
721:
722: IF NOT FND_API.To_Boolean(l_key_exists) THEN
723: x_return_status := 'E';
724: l_msg_token := p_property_id;
725: END IF;
726:

Line 807: IF FND_API.To_Boolean(p_called_by_form) THEN

803: FND_MESSAGE.SET_TOKEN('TEXT',
804: l_msg_data,
805: FALSE);
806: x_msg_data := FND_MESSAGE.Get;
807: IF FND_API.To_Boolean(p_called_by_form) THEN
808: APP_EXCEPTION.Raise_Exception;
809: END IF;
810:
811: END Check_Integrity;

Line 868: IF FND_API.To_Boolean(p_called_by_form) THEN

864: 'GR_UNEXPECTED_ERROR');
865: FND_MESSAGE.SET_TOKEN('TEXT',
866: l_msg_data,
867: FALSE);
868: IF FND_API.To_Boolean(p_called_by_form) THEN
869: APP_EXCEPTION.Raise_Exception;
870: END IF;
871:
872: END Check_Primary_Key;