DBA Data[Home] [Help]

APPS.GR_DOCUMENT_RTK_PKG dependencies on FND_API

Line 71: IF FND_API.To_Boolean(l_key_exists) THEN

67: 'F',
68: l_rowid,
69: l_key_exists);
70:
71: IF FND_API.To_Boolean(l_key_exists) THEN
72: RAISE Label_Exists_Error;
73: END IF;
74:
75: INSERT INTO gr_document_rtk

Line 104: IF FND_API.To_Boolean(l_key_exists) THEN

100: 'F',
101: l_rowid,
102: l_key_exists);
103:
104: IF FND_API.To_Boolean(l_key_exists) THEN
105: x_rowid := l_rowid;
106: ELSE
107: RAISE Row_Missing_Error;
108: END IF;

Line 112: IF FND_API.To_Boolean(p_commit) THEN

108: END IF;
109:
110: /* Check the commit flag and if set, then commit the work. */
111:
112: IF FND_API.To_Boolean(p_commit) THEN
113: COMMIT WORK;
114: END IF;
115:
116: EXCEPTION

Line 127: IF FND_API.To_Boolean(p_called_by_form) THEN

123: 'GR_FOREIGN_KEY_ERROR');
124: FND_MESSAGE.SET_TOKEN('TEXT',
125: l_msg_data,
126: FALSE);
127: IF FND_API.To_Boolean(p_called_by_form) THEN
128: APP_EXCEPTION.Raise_Exception;
129: ELSE
130: x_msg_data := FND_MESSAGE.Get;
131: END IF;

Line 142: IF FND_API.To_Boolean(p_called_by_form) THEN

138: 'GR_RECORD_EXISTS');
139: FND_MESSAGE.SET_TOKEN('CODE',
140: p_document_code,
141: FALSE);
142: IF FND_API.To_Boolean(p_called_by_form) THEN
143: APP_EXCEPTION.Raise_Exception;
144: ELSE
145: x_msg_data := FND_MESSAGE.Get;
146: END IF;

Line 157: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 173: IF FND_API.To_Boolean(p_called_by_form) THEN

169: 'GR_UNEXPECTED_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 254: IF FND_API.To_Boolean(p_commit) THEN

250: END IF;
251:
252: /* Check the commit flag and if set, then commit the work. */
253:
254: IF FND_API.To_Boolean(p_commit) THEN
255: COMMIT WORK;
256: END IF;
257:
258: EXCEPTION

Line 269: IF FND_API.To_Boolean(p_called_by_form) THEN

265: 'GR_FOREIGN_KEY_ERROR');
266: FND_MESSAGE.SET_TOKEN('TEXT',
267: l_msg_data,
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_document_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 370: IF FND_API.To_Boolean(p_commit) THEN

366: RAISE No_Data_Found_Error;
367: END IF;
368: CLOSE c_lock_document;
369:
370: IF FND_API.To_Boolean(p_commit) THEN
371: COMMIT WORK;
372: END IF;
373:
374: EXCEPTION

Line 384: IF FND_API.To_Boolean(p_called_by_form) THEN

380: 'GR_RECORD_NOT_FOUND');
381: FND_MESSAGE.SET_TOKEN('CODE',
382: p_document_code,
383: FALSE);
384: IF FND_API.To_Boolean(p_called_by_form) THEN
385: APP_EXCEPTION.Raise_Exception;
386: ELSE
387: x_msg_data := FND_MESSAGE.Get;
388: END IF;

Line 396: IF FND_API.To_Boolean(p_called_by_form) THEN

392: x_return_status := 'E';
393: x_oracle_error := APP_EXCEPTION.Get_Code;
394: FND_MESSAGE.SET_NAME('GR',
395: 'GR_ROW_IS_LOCKED');
396: IF FND_API.To_Boolean(p_called_by_form) THEN
397: APP_EXCEPTION.Raise_Exception;
398: ELSE
399: x_msg_data := FND_MESSAGE.Get;
400: END IF;

Line 412: IF FND_API.To_Boolean(p_called_by_form) THEN

408: 'GR_UNEXPECTED_ERROR');
409: FND_MESSAGE.SET_TOKEN('TEXT',
410: l_msg_data,
411: FALSE);
412: IF FND_API.To_Boolean(p_called_by_form) THEN
413: APP_EXCEPTION.Raise_Exception;
414: ELSE
415: x_msg_data := FND_MESSAGE.Get;
416: END IF;

Line 485: IF FND_API.TO_Boolean(p_commit) THEN

481: WHERE rowid = p_rowid;
482:
483: /* Check the commit flag and if set, then commit the work. */
484:
485: IF FND_API.TO_Boolean(p_commit) THEN
486: COMMIT WORK;
487: END IF;
488:
489: EXCEPTION

Line 495: IF FND_API.To_Boolean(p_called_by_form) THEN

491: WHEN Check_Integrity_Error THEN
492: ROLLBACK TO SAVEPOINT Delete_Row;
493: x_return_status := l_return_status;
494: x_oracle_error := l_oracle_error;
495: IF FND_API.To_Boolean(p_called_by_form) THEN
496: APP_EXCEPTION.Raise_Exception;
497: ELSE
498: x_msg_data := FND_MESSAGE.Get;
499: END IF;

Line 510: IF FND_API.To_Boolean(p_called_by_form) THEN

506: 'GR_RECORD_NOT_FOUND');
507: FND_MESSAGE.SET_TOKEN('CODE',
508: p_document_code,
509: FALSE);
510: IF FND_API.To_Boolean(p_called_by_form) THEN
511: APP_EXCEPTION.Raise_Exception;
512: ELSE
513: x_msg_data := FND_MESSAGE.Get;
514: END IF;

Line 527: IF FND_API.To_Boolean(p_called_by_form) THEN

523: 'GR_UNEXPECTED_ERROR');
524: FND_MESSAGE.SET_TOKEN('TEXT',
525: l_msg_data,
526: FALSE);
527: IF FND_API.To_Boolean(p_called_by_form) THEN
528: APP_EXCEPTION.Raise_Exception;
529: ELSE
530: x_msg_data := FND_MESSAGE.Get;
531: END IF;

Line 569: IF FND_API.To_Boolean(p_commit) THEN

565:
566: DELETE FROM gr_document_rtk
567: WHERE document_code = p_document_code;
568:
569: IF FND_API.To_Boolean(p_commit) THEN
570: COMMIT WORK;
571: END IF;
572:
573: EXCEPTION

Line 585: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 731: IF FND_API.To_Boolean(p_called_by_form) THEN

727: 'GR_UNEXPECTED_ERROR');
728: FND_MESSAGE.SET_TOKEN('TEXT',
729: l_msg_data,
730: FALSE);
731: IF FND_API.To_Boolean(p_called_by_form) THEN
732: APP_EXCEPTION.Raise_Exception;
733: ELSE
734: x_msg_data := FND_MESSAGE.Get;
735: END IF;

Line 787: IF FND_API.To_Boolean(p_called_by_form) THEN

783: 'GR_UNEXPECTED_ERROR');
784: FND_MESSAGE.SET_TOKEN('TEXT',
785: l_msg_data,
786: FALSE);
787: IF FND_API.To_Boolean(p_called_by_form) THEN
788: APP_EXCEPTION.Raise_Exception;
789: END IF;
790:
791: END Check_Primary_Key;