DBA Data[Home] [Help]

APPS.GR_LABEL_CLASSES_B_PKG dependencies on FND_API

Line 134: IF FND_API.To_Boolean(l_key_exists) THEN

130: 'F',
131: l_rowid,
132: l_key_exists);
133:
134: IF FND_API.To_Boolean(l_key_exists) THEN
135: RAISE Label_Exists_Error;
136: END IF;
137:
138: INSERT INTO gr_label_classes_b

Line 231: IF FND_API.To_Boolean(l_key_exists) THEN

227: 'F',
228: l_rowid,
229: l_key_exists);
230:
231: IF FND_API.To_Boolean(l_key_exists) THEN
232: x_rowid := l_rowid;
233: ELSE
234: RAISE Row_Missing_Error;
235: END IF;

Line 239: IF FND_API.To_Boolean(p_commit) THEN

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

Line 254: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 269: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 284: IF FND_API.To_Boolean(p_called_by_form) THEN

280: 'GR_NO_RECORD_INSERTED');
281: FND_MESSAGE.SET_TOKEN('CODE',
282: p_label_class_code,
283: FALSE);
284: IF FND_API.To_Boolean(p_called_by_form) THEN
285: APP_EXCEPTION.Raise_Exception;
286: ELSE
287: x_msg_data := FND_MESSAGE.Get;
288: END IF;

Line 300: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 477: IF FND_API.To_Boolean(p_commit) THEN

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

Line 492: IF FND_API.To_Boolean(p_called_by_form) THEN

488: 'GR_FOREIGN_KEY_ERROR');
489: FND_MESSAGE.SET_TOKEN('TEXT',
490: l_msg_data,
491: FALSE);
492: IF FND_API.To_Boolean(p_called_by_form) THEN
493: APP_EXCEPTION.Raise_Exception;
494: ELSE
495: x_msg_data := FND_MESSAGE.Get;
496: END IF;

Line 507: IF FND_API.To_Boolean(p_called_by_form) THEN

503: 'GR_NO_RECORD_INSERTED');
504: FND_MESSAGE.SET_TOKEN('CODE',
505: p_label_class_code,
506: FALSE);
507: IF FND_API.To_Boolean(p_called_by_form) THEN
508: APP_EXCEPTION.Raise_Exception;
509: ELSE
510: x_msg_data := FND_MESSAGE.Get;
511: END IF;

Line 523: IF FND_API.To_Boolean(p_called_by_form) THEN

519: 'GR_UNEXPECTED_ERROR');
520: FND_MESSAGE.SET_TOKEN('TEXT',
521: l_msg_data,
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 625: IF FND_API.To_Boolean(p_commit) THEN

621: RAISE No_Data_Found_Error;
622: END IF;
623: CLOSE c_lock_label_class;
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_RECORD_NOT_FOUND');
636: FND_MESSAGE.SET_TOKEN('CODE',
637: p_label_class_code,
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 651: IF FND_API.To_Boolean(p_called_by_form) THEN

647: x_return_status := 'E';
648: x_oracle_error := APP_EXCEPTION.Get_Code;
649: FND_MESSAGE.SET_NAME('GR',
650: 'GR_ROW_IS_LOCKED');
651: IF FND_API.To_Boolean(p_called_by_form) THEN
652: APP_EXCEPTION.Raise_Exception;
653: ELSE
654: x_msg_data := FND_MESSAGE.Get;
655: END IF;

Line 667: IF FND_API.To_Boolean(p_called_by_form) THEN

663: 'GR_UNEXPECTED_ERROR');
664: FND_MESSAGE.SET_TOKEN('TEXT',
665: l_msg_data,
666: FALSE);
667: IF FND_API.To_Boolean(p_called_by_form) THEN
668: APP_EXCEPTION.Raise_Exception;
669: ELSE
670: x_msg_data := FND_MESSAGE.Get;
671: END IF;

Line 804: IF FND_API.TO_Boolean(p_commit) THEN

800: WHERE rowid = p_rowid;
801:
802: /* Check the commit flag and if set, then commit the work. */
803:
804: IF FND_API.TO_Boolean(p_commit) THEN
805: COMMIT WORK;
806: END IF;
807:
808: EXCEPTION

Line 814: IF FND_API.To_Boolean(p_called_by_form) THEN

810: WHEN Check_Integrity_Error THEN
811: ROLLBACK TO SAVEPOINT Delete_Row;
812: x_return_status := l_return_status;
813: x_oracle_error := l_oracle_error;
814: IF FND_API.To_Boolean(p_called_by_form) THEN
815: APP_EXCEPTION.Raise_Exception;
816: ELSE
817: x_msg_data := FND_MESSAGE.Get;
818: END IF;

Line 829: IF FND_API.To_Boolean(p_called_by_form) THEN

825: 'GR_RECORD_NOT_FOUND');
826: FND_MESSAGE.SET_TOKEN('CODE',
827: p_label_class_code,
828: FALSE);
829: IF FND_API.To_Boolean(p_called_by_form) THEN
830: APP_EXCEPTION.Raise_Exception;
831: ELSE
832: x_msg_data := FND_MESSAGE.Get;
833: END IF;

Line 845: IF FND_API.To_Boolean(p_called_by_form) THEN

841: 'GR_UNEXPECTED_ERROR');
842: FND_MESSAGE.SET_TOKEN('TEXT',
843: l_msg_data,
844: FALSE);
845: IF FND_API.To_Boolean(p_called_by_form) THEN
846: APP_EXCEPTION.Raise_Exception;
847: ELSE
848: x_msg_data := FND_MESSAGE.Get;
849: END IF;

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

923: 'F',
924: l_rowid,
925: l_key_exists);
926:
927: IF NOT FND_API.To_Boolean(l_key_exists) THEN
928: x_return_status := 'E';
929: FND_MESSAGE.SET_NAME('GR',
930: 'GR_RECORD_NOT_FOUND');
931: FND_MESSAGE.SET_TOKEN('CODE',

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

943: 'F',
944: l_rowid,
945: l_key_exists);
946:
947: IF NOT FND_API.To_Boolean(l_key_exists) THEN
948: x_return_status := 'E';
949: FND_MESSAGE.SET_NAME('GR',
950: 'GR_RECORD_NOT_FOUND');
951: FND_MESSAGE.SET_TOKEN('CODE',

Line 1093: IF FND_API.To_Boolean(p_called_by_form) THEN

1089: 'GR_UNEXPECTED_ERROR');
1090: FND_MESSAGE.SET_TOKEN('TEXT',
1091: l_msg_data,
1092: FALSE);
1093: IF FND_API.To_Boolean(p_called_by_form) THEN
1094: APP_EXCEPTION.Raise_Exception;
1095: ELSE
1096: x_msg_data := FND_MESSAGE.Get;
1097: END IF;

Line 1149: IF FND_API.To_Boolean(p_called_by_form) THEN

1145: 'GR_UNEXPECTED_ERROR');
1146: FND_MESSAGE.SET_TOKEN('TEXT',
1147: l_msg_data,
1148: FALSE);
1149: IF FND_API.To_Boolean(p_called_by_form) THEN
1150: APP_EXCEPTION.Raise_Exception;
1151: END IF;
1152:
1153: END Check_Primary_Key;