DBA Data[Home] [Help]

APPS.GR_FIELD_NAME_MASKS_TL_PKG dependencies on FND_API

Line 110: IF FND_API.To_Boolean(l_key_exists) THEN

106: 'F',
107: l_rowid,
108: l_key_exists);
109:
110: IF FND_API.To_Boolean(l_key_exists) THEN
111: RAISE Item_Exists_Error;
112: END IF;
113:
114: INSERT INTO gr_item_field_name_masks_tl

Line 150: IF FND_API.To_Boolean(l_key_exists) THEN

146: 'F',
147: l_rowid,
148: l_key_exists);
149:
150: IF FND_API.To_Boolean(l_key_exists) THEN
151: x_rowid := l_rowid;
152: ELSE
153: RAISE Row_Missing_Error;
154: END IF;

Line 158: IF FND_API.To_Boolean(p_commit) THEN

154: END IF;
155:
156: /* Check the commit flag and if set, then commit the work. */
157:
158: IF FND_API.To_Boolean(p_commit) THEN
159: COMMIT WORK;
160: END IF;
161:
162: EXCEPTION

Line 173: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 188: IF FND_API.To_Boolean(p_called_by_form) THEN

184: 'GR_RECORD_EXISTS');
185: FND_MESSAGE.SET_TOKEN('CODE',
186: p_item_code,
187: FALSE);
188: IF FND_API.To_Boolean(p_called_by_form) THEN
189: APP_EXCEPTION.Raise_Exception;
190: ELSE
191: x_msg_data := FND_MESSAGE.Get;
192: END IF;

Line 204: IF FND_API.To_Boolean(p_called_by_form) THEN

200: FND_MESSAGE.SET_TOKEN('CODE',
201: p_item_code,
202: FALSE);
203: x_msg_data := FND_MESSAGE.Get;
204: IF FND_API.To_Boolean(p_called_by_form) THEN
205: APP_EXCEPTION.Raise_Exception;
206: ELSE
207: x_msg_data := FND_MESSAGE.Get;
208: END IF;

Line 220: IF FND_API.To_Boolean(p_called_by_form) THEN

216: 'GR_UNEXPECTED_ERROR');
217: FND_MESSAGE.SET_TOKEN('TEXT',
218: l_msg_data,
219: FALSE);
220: IF FND_API.To_Boolean(p_called_by_form) THEN
221: APP_EXCEPTION.Raise_Exception;
222: ELSE
223: x_msg_data := FND_MESSAGE.Get;
224: END IF;

Line 337: IF FND_API.To_Boolean(p_commit) THEN

333: END IF;
334:
335: /* Check if do the commit */
336:
337: IF FND_API.To_Boolean(p_commit) THEN
338: COMMIT WORK;
339: END IF;
340:
341: EXCEPTION

Line 352: IF FND_API.To_Boolean(p_called_by_form) THEN

348: 'GR_FOREIGN_KEY_ERROR');
349: FND_MESSAGE.SET_TOKEN('TEXT',
350: l_msg_data,
351: FALSE);
352: IF FND_API.To_Boolean(p_called_by_form) THEN
353: APP_EXCEPTION.Raise_Exception;
354: ELSE
355: x_msg_data := FND_MESSAGE.Get;
356: END IF;

Line 367: IF FND_API.To_Boolean(p_called_by_form) THEN

363: 'GR_NO_RECORD_INSERTED');
364: FND_MESSAGE.SET_TOKEN('CODE',
365: p_item_code,
366: FALSE);
367: IF FND_API.To_Boolean(p_called_by_form) THEN
368: APP_EXCEPTION.Raise_Exception;
369: ELSE
370: x_msg_data := FND_MESSAGE.Get;
371: END IF;

Line 383: IF FND_API.To_Boolean(p_called_by_form) THEN

379: 'GR_UNEXPECTED_ERROR');
380: FND_MESSAGE.SET_TOKEN('TEXT',
381: l_msg_data,
382: FALSE);
383: IF FND_API.To_Boolean(p_called_by_form) THEN
384: APP_EXCEPTION.Raise_Exception;
385: ELSE
386: x_msg_data := FND_MESSAGE.Get;
387: END IF;

Line 588: IF FND_API.To_Boolean(p_commit) THEN

584: END LOOP;
585: END IF;
586: CLOSE c_get_installed_languages;
587:
588: IF FND_API.To_Boolean(p_commit) THEN
589: COMMIT WORK;
590: END IF;
591:
592: EXCEPTION

Line 603: IF FND_API.To_Boolean(p_called_by_form) THEN

599: 'GR_RECORD_NOT_FOUND');
600: FND_MESSAGE.SET_TOKEN('CODE',
601: l_msg_token,
602: FALSE);
603: IF FND_API.To_Boolean(p_called_by_form) THEN
604: APP_EXCEPTION.Raise_Exception;
605: ELSE
606: x_msg_data := FND_MESSAGE.Get;
607: END IF;

Line 619: IF FND_API.To_Boolean(p_called_by_form) THEN

615: 'GR_UNEXPECTED_ERROR');
616: FND_MESSAGE.SET_TOKEN('TEXT',
617: l_msg_token||SQLERRM,
618: FALSE);
619: IF FND_API.To_Boolean(p_called_by_form) THEN
620: APP_EXCEPTION.Raise_Exception;
621: ELSE
622: x_msg_data := FND_MESSAGE.Get;
623: END IF;

Line 724: IF FND_API.To_Boolean(p_commit) THEN

720: IF LockEinRcd.last_update_date <> p_last_update_date THEN
721: RAISE RECORD_CHANGED_ERROR;
722: END IF;
723:
724: IF FND_API.To_Boolean(p_commit) THEN
725: COMMIT WORK;
726: END IF;
727:
728: EXCEPTION

Line 738: IF FND_API.To_Boolean(p_called_by_form) THEN

734: 'GR_RECORD_NOT_FOUND');
735: FND_MESSAGE.SET_TOKEN('CODE',
736: p_item_code,
737: FALSE);
738: IF FND_API.To_Boolean(p_called_by_form) THEN
739: APP_EXCEPTION.Raise_Exception;
740: ELSE
741: x_msg_data := FND_MESSAGE.Get;
742: END IF;

Line 748: IF FND_API.To_Boolean(p_called_by_form) THEN

744: ROLLBACK TO SAVEPOINT Lock_Row;
745: X_return_status := 'E';
746: FND_MESSAGE.SET_NAME('FND',
747: 'FORM_RECORD_CHANGED');
748: IF FND_API.To_Boolean(p_called_by_form) THEN
749: APP_EXCEPTION.Raise_Exception;
750: ELSE
751: x_msg_data := FND_MESSAGE.Get;
752: END IF;

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

753: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
754: ROLLBACK TO SAVEPOINT Lock_Row;
755: x_return_status := 'L';
756: x_oracle_error := APP_EXCEPTION.Get_Code;
757: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
758: FND_MESSAGE.SET_NAME('GR',
759: 'GR_ROW_IS_LOCKED');
760: x_msg_data := FND_MESSAGE.Get;
761: END IF;

Line 772: IF FND_API.To_Boolean(p_called_by_form) THEN

768: 'GR_UNEXPECTED_ERROR');
769: FND_MESSAGE.SET_TOKEN('TEXT',
770: l_msg_data,
771: FALSE);
772: IF FND_API.To_Boolean(p_called_by_form) THEN
773: APP_EXCEPTION.Raise_Exception;
774: ELSE
775: x_msg_data := FND_MESSAGE.Get;
776: END IF;

Line 846: IF FND_API.TO_Boolean(p_commit) THEN

842: WHERE rowid = p_rowid;
843:
844: /* Check the commit flag and if set, then commit the work. */
845:
846: IF FND_API.TO_Boolean(p_commit) THEN
847: COMMIT WORK;
848: END IF;
849:
850: EXCEPTION

Line 861: IF FND_API.To_Boolean(p_called_by_form) THEN

857: 'GR_RECORD_NOT_FOUND');
858: FND_MESSAGE.SET_TOKEN('CODE',
859: p_item_code,
860: FALSE);
861: IF FND_API.To_Boolean(p_called_by_form) THEN
862: APP_EXCEPTION.Raise_Exception;
863: ELSE
864: x_msg_data := FND_MESSAGE.Get;
865: END IF;

Line 877: IF FND_API.To_Boolean(p_called_by_form) THEN

873: 'GR_UNEXPECTED_ERROR');
874: FND_MESSAGE.SET_TOKEN('TEXT',
875: l_msg_data,
876: FALSE);
877: IF FND_API.To_Boolean(p_called_by_form) THEN
878: APP_EXCEPTION.Raise_Exception;
879: ELSE
880: x_msg_data := FND_MESSAGE.Get;
881: END IF;

Line 941: IF FND_API.To_Boolean(p_commit) THEN

937:
938: DELETE FROM gr_item_field_name_masks_tl
939: WHERE item_code = p_item_code;
940:
941: IF FND_API.To_Boolean(p_commit) THEN
942: COMMIT WORK;
943: END IF;
944:
945: EXCEPTION

Line 957: IF FND_API.To_Boolean(p_called_by_form) THEN

953: 'GR_UNEXPECTED_ERROR');
954: FND_MESSAGE.SET_TOKEN('TEXT',
955: l_msg_token||SQLERRM,
956: FALSE);
957: IF FND_API.To_Boolean(p_called_by_form) THEN
958: APP_EXCEPTION.Raise_Exception;
959: ELSE
960: x_msg_data := FND_MESSAGE.Get;
961: 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;