DBA Data[Home] [Help]

APPS.GR_DOCUMENT_DETAILS_PKG dependencies on FND_API

Line 75: IF FND_API.To_Boolean(l_key_exists) THEN

71: 'F',
72: l_rowid,
73: l_key_exists);
74:
75: IF FND_API.To_Boolean(l_key_exists) THEN
76: RAISE Label_Exists_Error;
77: END IF;
78:
79: INSERT INTO gr_document_details

Line 113: IF FND_API.To_Boolean(l_key_exists) THEN

109: 'F',
110: l_rowid,
111: l_key_exists);
112:
113: IF FND_API.To_Boolean(l_key_exists) THEN
114: x_rowid := l_rowid;
115: ELSE
116: RAISE Row_Missing_Error;
117: END IF;

Line 121: IF FND_API.To_Boolean(p_commit) THEN

117: END IF;
118:
119: /* Check the commit flag and if set, then commit the work. */
120:
121: IF FND_API.To_Boolean(p_commit) THEN
122: COMMIT WORK;
123: END IF;
124:
125: EXCEPTION

Line 136: IF FND_API.To_Boolean(p_called_by_form) THEN

132: 'GR_FOREIGN_KEY_ERROR');
133: FND_MESSAGE.SET_TOKEN('TEXT',
134: l_msg_data,
135: FALSE);
136: IF FND_API.To_Boolean(p_called_by_form) THEN
137: APP_EXCEPTION.Raise_Exception;
138: ELSE
139: x_msg_data := FND_MESSAGE.Get;
140: END IF;

Line 151: IF FND_API.To_Boolean(p_called_by_form) THEN

147: 'GR_RECORD_EXISTS');
148: FND_MESSAGE.SET_TOKEN('CODE',
149: p_document_text_id || ' ' || p_text_line_number,
150: FALSE);
151: IF FND_API.To_Boolean(p_called_by_form) THEN
152: APP_EXCEPTION.Raise_Exception;
153: ELSE
154: x_msg_data := FND_MESSAGE.Get;
155: END IF;

Line 166: IF FND_API.To_Boolean(p_called_by_form) THEN

162: 'GR_NO_RECORD_INSERTED');
163: FND_MESSAGE.SET_TOKEN('CODE',
164: p_document_text_id || ' ' || p_text_line_number,
165: FALSE);
166: IF FND_API.To_Boolean(p_called_by_form) THEN
167: APP_EXCEPTION.Raise_Exception;
168: ELSE
169: x_msg_data := FND_MESSAGE.Get;
170: END IF;

Line 182: IF FND_API.To_Boolean(p_called_by_form) THEN

178: 'GR_UNEXPECTED_ERROR');
179: FND_MESSAGE.SET_TOKEN('TEXT',
180: l_msg_data,
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 269: IF FND_API.To_Boolean(p_commit) THEN

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

Line 284: IF FND_API.To_Boolean(p_called_by_form) THEN

280: 'GR_FOREIGN_KEY_ERROR');
281: FND_MESSAGE.SET_TOKEN('TEXT',
282: l_msg_data,
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 299: IF FND_API.To_Boolean(p_called_by_form) THEN

295: 'GR_NO_RECORD_INSERTED');
296: FND_MESSAGE.SET_TOKEN('CODE',
297: p_document_text_id || ' ' || p_text_line_number,
298: FALSE);
299: IF FND_API.To_Boolean(p_called_by_form) THEN
300: APP_EXCEPTION.Raise_Exception;
301: ELSE
302: x_msg_data := FND_MESSAGE.Get;
303: END IF;

Line 315: IF FND_API.To_Boolean(p_called_by_form) THEN

311: 'GR_UNEXPECTED_ERROR');
312: FND_MESSAGE.SET_TOKEN('TEXT',
313: l_msg_data,
314: FALSE);
315: IF FND_API.To_Boolean(p_called_by_form) THEN
316: APP_EXCEPTION.Raise_Exception;
317: ELSE
318: x_msg_data := FND_MESSAGE.Get;
319: END IF;

Line 387: IF FND_API.To_Boolean(p_commit) THEN

383: RAISE No_Data_Found_Error;
384: END IF;
385: CLOSE c_lock_document_details;
386:
387: IF FND_API.To_Boolean(p_commit) THEN
388: COMMIT WORK;
389: END IF;
390:
391: EXCEPTION

Line 401: IF FND_API.To_Boolean(p_called_by_form) THEN

397: 'GR_RECORD_NOT_FOUND');
398: FND_MESSAGE.SET_TOKEN('CODE',
399: p_document_text_id || ' ' || p_text_line_number,
400: FALSE);
401: IF FND_API.To_Boolean(p_called_by_form) THEN
402: APP_EXCEPTION.Raise_Exception;
403: ELSE
404: x_msg_data := FND_MESSAGE.Get;
405: END IF;

Line 413: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 429: IF FND_API.To_Boolean(p_called_by_form) THEN

425: 'GR_UNEXPECTED_ERROR');
426: FND_MESSAGE.SET_TOKEN('TEXT',
427: l_msg_data,
428: FALSE);
429: IF FND_API.To_Boolean(p_called_by_form) THEN
430: APP_EXCEPTION.Raise_Exception;
431: ELSE
432: x_msg_data := FND_MESSAGE.Get;
433: END IF;

Line 506: IF FND_API.TO_Boolean(p_commit) THEN

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

Line 516: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 531: IF FND_API.To_Boolean(p_called_by_form) THEN

527: 'GR_RECORD_NOT_FOUND');
528: FND_MESSAGE.SET_TOKEN('CODE',
529: p_document_text_id || ' ' || p_text_line_number,
530: FALSE);
531: IF FND_API.To_Boolean(p_called_by_form) THEN
532: APP_EXCEPTION.Raise_Exception;
533: ELSE
534: x_msg_data := FND_MESSAGE.Get;
535: END IF;

Line 548: IF FND_API.To_Boolean(p_called_by_form) THEN

544: 'GR_UNEXPECTED_ERROR');
545: FND_MESSAGE.SET_TOKEN('TEXT',
546: l_msg_data,
547: FALSE);
548: IF FND_API.To_Boolean(p_called_by_form) THEN
549: APP_EXCEPTION.Raise_Exception;
550: ELSE
551: x_msg_data := FND_MESSAGE.Get;
552: END IF;

Line 590: IF FND_API.To_Boolean(p_commit) THEN

586:
587: DELETE FROM gr_document_details
588: WHERE document_text_id = p_document_text_id;
589:
590: IF FND_API.To_Boolean(p_commit) THEN
591: COMMIT WORK;
592: END IF;
593:
594: EXCEPTION

Line 606: IF FND_API.To_Boolean(p_called_by_form) THEN

602: 'GR_UNEXPECTED_ERROR');
603: FND_MESSAGE.SET_TOKEN('TEXT',
604: l_msg_token,
605: FALSE);
606: IF FND_API.To_Boolean(p_called_by_form) THEN
607: APP_EXCEPTION.Raise_Exception;
608: ELSE
609: x_msg_data := FND_MESSAGE.Get;
610: END IF;

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

652: (p_document_text_id,
653: 'F',
654: l_rowid,
655: l_key_exists);
656: IF NOT FND_API.To_Boolean(l_key_exists) THEN
657: x_return_status := 'E';
658: FND_MESSAGE.SET_NAME('GR',
659: 'GR_RECORD_NOT_FOUND');
660: FND_MESSAGE.SET_TOKEN('CODE',

Line 747: IF FND_API.To_Boolean(p_called_by_form) THEN

743: 'GR_UNEXPECTED_ERROR');
744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_data,
746: FALSE);
747: IF FND_API.To_Boolean(p_called_by_form) THEN
748: APP_EXCEPTION.Raise_Exception;
749: ELSE
750: x_msg_data := FND_MESSAGE.Get;
751: END IF;

Line 806: IF FND_API.To_Boolean(p_called_by_form) THEN

802: 'GR_UNEXPECTED_ERROR');
803: FND_MESSAGE.SET_TOKEN('TEXT',
804: l_msg_data,
805: FALSE);
806: IF FND_API.To_Boolean(p_called_by_form) THEN
807: APP_EXCEPTION.Raise_Exception;
808: END IF;
809:
810: END Check_Primary_Key;