DBA Data[Home] [Help]

APPS.GR_ITEM_DISCLOSURES_PKG dependencies on FND_API

Line 87: IF FND_API.To_Boolean(l_key_exists) THEN

83: 'F',
84: l_rowid,
85: l_key_exists);
86:
87: IF FND_API.To_Boolean(l_key_exists) THEN
88: RAISE Item_Exists_Error;
89: END IF;
90:
91: INSERT INTO gr_item_disclosures

Line 129: IF FND_API.To_Boolean(l_key_exists) THEN

125: 'F',
126: l_rowid,
127: l_key_exists);
128:
129: IF FND_API.To_Boolean(l_key_exists) THEN
130: x_rowid := l_rowid;
131: ELSE
132: RAISE Row_Missing_Error;
133: END IF;

Line 137: IF FND_API.To_Boolean(p_commit) THEN

133: END IF;
134:
135: /* Check the commit flag and if set, then commit the work. */
136:
137: IF FND_API.To_Boolean(p_commit) THEN
138: COMMIT WORK;
139: END IF;
140:
141: EXCEPTION

Line 152: IF FND_API.To_Boolean(p_called_by_form) THEN

148: 'GR_FOREIGN_KEY_ERROR');
149: FND_MESSAGE.SET_TOKEN('TEXT',
150: l_msg_data,
151: FALSE);
152: IF FND_API.To_Boolean(p_called_by_form) THEN
153: APP_EXCEPTION.Raise_Exception;
154: ELSE
155: x_msg_data := FND_MESSAGE.Get;
156: END IF;

Line 167: IF FND_API.To_Boolean(p_called_by_form) THEN

163: 'GR_RECORD_EXISTS');
164: FND_MESSAGE.SET_TOKEN('CODE',
165: l_msg_token,
166: FALSE);
167: IF FND_API.To_Boolean(p_called_by_form) THEN
168: APP_EXCEPTION.Raise_Exception;
169: ELSE
170: x_msg_data := FND_MESSAGE.Get;
171: END IF;

Line 182: IF FND_API.To_Boolean(p_called_by_form) THEN

178: 'GR_NO_RECORD_INSERTED');
179: FND_MESSAGE.SET_TOKEN('CODE',
180: l_msg_token,
181: FALSE);
182: IF FND_API.To_Boolean(p_called_by_form) THEN
183: APP_EXCEPTION.Raise_Exception;
184: ELSE
185: x_msg_data := FND_MESSAGE.Get;
186: END IF;

Line 198: IF FND_API.To_Boolean(p_called_by_form) THEN

194: 'GR_UNEXPECTED_ERROR');
195: FND_MESSAGE.SET_TOKEN('TEXT',
196: l_msg_token,
197: FALSE);
198: IF FND_API.To_Boolean(p_called_by_form) THEN
199: APP_EXCEPTION.Raise_Exception;
200: ELSE
201: x_msg_data := FND_MESSAGE.Get;
202: END IF;

Line 297: IF FND_API.To_Boolean(p_commit) THEN

293: END IF;
294:
295: /* Check the commit flag and if set, then commit the work. */
296:
297: IF FND_API.To_Boolean(p_commit) THEN
298: COMMIT WORK;
299: END IF;
300:
301: EXCEPTION

Line 312: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 327: IF FND_API.To_Boolean(p_called_by_form) THEN

323: 'GR_NO_RECORD_INSERTED');
324: FND_MESSAGE.SET_TOKEN('CODE',
325: l_msg_token,
326: FALSE);
327: IF FND_API.To_Boolean(p_called_by_form) THEN
328: APP_EXCEPTION.Raise_Exception;
329: ELSE
330: x_msg_data := FND_MESSAGE.Get;
331: END IF;

Line 343: IF FND_API.To_Boolean(p_called_by_form) THEN

339: 'GR_UNEXPECTED_ERROR');
340: FND_MESSAGE.SET_TOKEN('TEXT',
341: l_msg_token,
342: FALSE);
343: IF FND_API.To_Boolean(p_called_by_form) THEN
344: APP_EXCEPTION.Raise_Exception;
345: ELSE
346: x_msg_data := FND_MESSAGE.Get;
347: END IF;

Line 418: IF FND_API.To_Boolean(p_commit) THEN

414: RAISE No_Data_Found_Error;
415: END IF;
416: CLOSE c_lock_discs;
417:
418: IF FND_API.To_Boolean(p_commit) THEN
419: COMMIT WORK;
420: END IF;
421:
422: EXCEPTION

Line 432: IF FND_API.To_Boolean(p_called_by_form) THEN

428: 'GR_RECORD_NOT_FOUND');
429: FND_MESSAGE.SET_TOKEN('CODE',
430: l_msg_token,
431: FALSE);
432: IF FND_API.To_Boolean(p_called_by_form) THEN
433: APP_EXCEPTION.Raise_Exception;
434: ELSE
435: x_msg_data := FND_MESSAGE.Get;
436: END IF;

Line 444: IF FND_API.To_Boolean(p_called_by_form) THEN

440: x_return_status := 'E';
441: x_oracle_error := APP_EXCEPTION.Get_Code;
442: FND_MESSAGE.SET_NAME('GR',
443: 'GR_ROW_IS_LOCKED');
444: IF FND_API.To_Boolean(p_called_by_form) THEN
445: APP_EXCEPTION.Raise_Exception;
446: ELSE
447: x_msg_data := FND_MESSAGE.Get;
448: END IF;

Line 460: IF FND_API.To_Boolean(p_called_by_form) THEN

456: 'GR_UNEXPECTED_ERROR');
457: FND_MESSAGE.SET_TOKEN('TEXT',
458: l_msg_token,
459: FALSE);
460: IF FND_API.To_Boolean(p_called_by_form) THEN
461: APP_EXCEPTION.Raise_Exception;
462: ELSE
463: x_msg_data := FND_MESSAGE.Get;
464: END IF;

Line 547: IF FND_API.TO_Boolean(p_commit) THEN

543: WHERE rowid = p_rowid;
544:
545: /* Check the commit flag and if set, then commit the work. */
546:
547: IF FND_API.TO_Boolean(p_commit) THEN
548: COMMIT WORK;
549: END IF;
550:
551: EXCEPTION

Line 558: IF FND_API.To_Boolean(p_called_by_form) THEN

554: ROLLBACK TO SAVEPOINT Delete_Row;
555: x_return_status := l_return_status;
556: x_oracle_error := l_oracle_error;
557: x_msg_data := l_msg_data;
558: IF FND_API.To_Boolean(p_called_by_form) THEN
559: APP_EXCEPTION.Raise_Exception;
560: END IF;
561:
562: WHEN Row_Missing_Error THEN

Line 571: IF FND_API.To_Boolean(p_called_by_form) THEN

567: 'GR_RECORD_NOT_FOUND');
568: FND_MESSAGE.SET_TOKEN('CODE',
569: l_msg_token,
570: FALSE);
571: IF FND_API.To_Boolean(p_called_by_form) THEN
572: APP_EXCEPTION.Raise_Exception;
573: ELSE
574: x_msg_data := FND_MESSAGE.Get;
575: END IF;

Line 588: IF FND_API.To_Boolean(p_called_by_form) THEN

584: 'GR_UNEXPECTED_ERROR');
585: FND_MESSAGE.SET_TOKEN('TEXT',
586: l_msg_token,
587: FALSE);
588: IF FND_API.To_Boolean(p_called_by_form) THEN
589: APP_EXCEPTION.Raise_Exception;
590: ELSE
591: x_msg_data := FND_MESSAGE.Get;
592: END IF;

Line 630: IF FND_API.To_Boolean(p_commit) THEN

626:
627: DELETE FROM gr_item_disclosures
628: WHERE item_code = p_item_code;
629:
630: IF FND_API.To_Boolean(p_commit) THEN
631: COMMIT WORK;
632: END IF;
633:
634: EXCEPTION

Line 646: IF FND_API.To_Boolean(p_called_by_form) THEN

642: 'GR_UNEXPECTED_ERROR');
643: FND_MESSAGE.SET_TOKEN('TEXT',
644: l_msg_token,
645: FALSE);
646: IF FND_API.To_Boolean(p_called_by_form) THEN
647: APP_EXCEPTION.Raise_Exception;
648: ELSE
649: x_msg_data := FND_MESSAGE.Get;
650: END IF;

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

708: 'F',
709: l_rowid,
710: l_key_exists);
711:
712: IF NOT FND_API.To_Boolean(l_key_exists) THEN
713: x_return_status := 'E';
714: FND_MESSAGE.SET_NAME('GR',
715: 'GR_RECORD_NOT_FOUND');
716: FND_MESSAGE.SET_TOKEN('CODE',

Line 815: IF FND_API.To_Boolean(p_called_by_form) THEN

811: 'GR_UNEXPECTED_ERROR');
812: FND_MESSAGE.SET_TOKEN('TEXT',
813: l_msg_data,
814: FALSE);
815: IF FND_API.To_Boolean(p_called_by_form) THEN
816: APP_EXCEPTION.Raise_Exception;
817: ELSE
818: x_msg_data := FND_MESSAGE.Get;
819: END IF;

Line 875: IF FND_API.To_Boolean(p_called_by_form) THEN

871: 'GR_UNEXPECTED_ERROR');
872: FND_MESSAGE.SET_TOKEN('TEXT',
873: l_msg_data,
874: FALSE);
875: IF FND_API.To_Boolean(p_called_by_form) THEN
876: APP_EXCEPTION.Raise_Exception;
877: END IF;
878:
879: END Check_Primary_Key;