DBA Data[Home] [Help]

APPS.GR_ORGANIZATION_CONTACTS_PKG dependencies on FND_API

Line 89: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 140: IF FND_API.To_Boolean(l_key_exists) THEN

136: 'F',
137: l_rowid,
138: l_key_exists);
139:
140: IF FND_API.To_Boolean(l_key_exists) THEN
141: x_rowid := l_rowid;
142: ELSE
143: RAISE Row_Missing_Error;
144: END IF;

Line 148: IF FND_API.To_Boolean(p_commit) THEN

144: END IF;
145:
146: /* Check the commit flag and if set, then commit the work. */
147:
148: IF FND_API.To_Boolean(p_commit) THEN
149: COMMIT WORK;
150: END IF;
151:
152: EXCEPTION

Line 163: IF FND_API.To_Boolean(p_called_by_form) THEN

159: 'GR_FOREIGN_KEY_ERROR');
160: FND_MESSAGE.SET_TOKEN('TEXT',
161: l_msg_data,
162: FALSE);
163: IF FND_API.To_Boolean(p_called_by_form) THEN
164: APP_EXCEPTION.Raise_Exception;
165: ELSE
166: x_msg_data := FND_MESSAGE.Get;
167: END IF;

Line 179: IF FND_API.To_Boolean(p_called_by_form) THEN

175: 'GR_RECORD_EXISTS');
176: FND_MESSAGE.SET_TOKEN('CODE',
177: l_msg_token,
178: FALSE);
179: IF FND_API.To_Boolean(p_called_by_form) THEN
180: APP_EXCEPTION.Raise_Exception;
181: ELSE
182: x_msg_data := FND_MESSAGE.Get;
183: END IF;

Line 195: IF FND_API.To_Boolean(p_called_by_form) THEN

191: 'GR_NO_RECORD_INSERTED');
192: FND_MESSAGE.SET_TOKEN('CODE',
193: l_msg_token,
194: FALSE);
195: IF FND_API.To_Boolean(p_called_by_form) THEN
196: APP_EXCEPTION.Raise_Exception;
197: ELSE
198: x_msg_data := FND_MESSAGE.Get;
199: END IF;

Line 212: IF FND_API.To_Boolean(p_called_by_form) THEN

208: 'GR_UNEXPECTED_ERROR');
209: FND_MESSAGE.SET_TOKEN('TEXT',
210: l_msg_token,
211: FALSE);
212: IF FND_API.To_Boolean(p_called_by_form) THEN
213: APP_EXCEPTION.Raise_Exception;
214: ELSE
215: x_msg_data := FND_MESSAGE.Get;
216: END IF;

Line 322: IF FND_API.To_Boolean(p_commit) THEN

318: END IF;
319:
320: /* Check the commit flag and if set, then commit the work. */
321:
322: IF FND_API.To_Boolean(p_commit) THEN
323: COMMIT WORK;
324: END IF;
325:
326: EXCEPTION

Line 337: IF FND_API.To_Boolean(p_called_by_form) THEN

333: 'GR_FOREIGN_KEY_ERROR');
334: FND_MESSAGE.SET_TOKEN('TEXT',
335: l_msg_data,
336: FALSE);
337: IF FND_API.To_Boolean(p_called_by_form) THEN
338: APP_EXCEPTION.Raise_Exception;
339: ELSE
340: x_msg_data := FND_MESSAGE.Get;
341: END IF;

Line 352: IF FND_API.To_Boolean(p_called_by_form) THEN

348: 'GR_NO_RECORD_INSERTED');
349: FND_MESSAGE.SET_TOKEN('CODE',
350: l_msg_token,
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 368: IF FND_API.To_Boolean(p_called_by_form) THEN

364: 'GR_UNEXPECTED_ERROR');
365: FND_MESSAGE.SET_TOKEN('TEXT',
366: l_msg_token,
367: FALSE);
368: IF FND_API.To_Boolean(p_called_by_form) THEN
369: APP_EXCEPTION.Raise_Exception;
370: ELSE
371: x_msg_data := FND_MESSAGE.Get;
372: END IF;

Line 453: IF FND_API.To_Boolean(p_commit) THEN

449: RAISE No_Data_Found_Error;
450: END IF;
451: CLOSE c_lock_orgn_contacts;
452:
453: IF FND_API.To_Boolean(p_commit) THEN
454: COMMIT WORK;
455: END IF;
456:
457: EXCEPTION

Line 467: IF FND_API.To_Boolean(p_called_by_form) THEN

463: 'GR_RECORD_NOT_FOUND');
464: FND_MESSAGE.SET_TOKEN('CODE',
465: l_msg_token,
466: FALSE);
467: IF FND_API.To_Boolean(p_called_by_form) THEN
468: APP_EXCEPTION.Raise_Exception;
469: ELSE
470: x_msg_data := FND_MESSAGE.Get;
471: END IF;

Line 479: IF FND_API.To_Boolean(p_called_by_form) THEN

475: x_return_status := 'E';
476: x_oracle_error := APP_EXCEPTION.Get_Code;
477: FND_MESSAGE.SET_NAME('GR',
478: 'GR_ROW_IS_LOCKED');
479: IF FND_API.To_Boolean(p_called_by_form) THEN
480: APP_EXCEPTION.Raise_Exception;
481: ELSE
482: x_msg_data := FND_MESSAGE.Get;
483: END IF;

Line 495: IF FND_API.To_Boolean(p_called_by_form) THEN

491: 'GR_UNEXPECTED_ERROR');
492: FND_MESSAGE.SET_TOKEN('TEXT',
493: l_msg_token,
494: FALSE);
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 590: IF FND_API.TO_Boolean(p_commit) THEN

586: WHERE rowid = p_rowid;
587:
588: /* Check the commit flag and if set, then commit the work. */
589:
590: IF FND_API.TO_Boolean(p_commit) THEN
591: COMMIT WORK;
592: END IF;
593:
594: EXCEPTION

Line 600: IF FND_API.To_Boolean(p_called_by_form) THEN

596: WHEN Check_Integrity_Error THEN
597: ROLLBACK TO SAVEPOINT Delete_Row;
598: x_return_status := l_return_status;
599: x_oracle_error := l_oracle_error;
600: IF FND_API.To_Boolean(p_called_by_form) THEN
601: APP_EXCEPTION.Raise_Exception;
602: ELSE
603: x_msg_data := FND_MESSAGE.Get;
604: END IF;

Line 615: IF FND_API.To_Boolean(p_called_by_form) THEN

611: 'GR_RECORD_NOT_FOUND');
612: FND_MESSAGE.SET_TOKEN('CODE',
613: l_msg_token,
614: FALSE);
615: IF FND_API.To_Boolean(p_called_by_form) THEN
616: APP_EXCEPTION.Raise_Exception;
617: ELSE
618: x_msg_data := FND_MESSAGE.Get;
619: END IF;

Line 631: IF FND_API.To_Boolean(p_called_by_form) THEN

627: 'GR_UNEXPECTED_ERROR');
628: FND_MESSAGE.SET_TOKEN('TEXT',
629: l_msg_data,
630: FALSE);
631: IF FND_API.To_Boolean(p_called_by_form) THEN
632: APP_EXCEPTION.Raise_Exception;
633: ELSE
634: x_msg_data := FND_MESSAGE.Get;
635: END IF;

Line 791: IF FND_API.To_Boolean(p_called_by_form) THEN

787: 'GR_UNEXPECTED_ERROR');
788: FND_MESSAGE.SET_TOKEN('TEXT',
789: l_msg_data,
790: FALSE);
791: IF FND_API.To_Boolean(p_called_by_form) THEN
792: APP_EXCEPTION.Raise_Exception;
793: ELSE
794: x_msg_data := FND_MESSAGE.Get;
795: END IF;

Line 848: IF FND_API.To_Boolean(p_called_by_form) THEN

844: 'GR_UNEXPECTED_ERROR');
845: FND_MESSAGE.SET_TOKEN('TEXT',
846: l_msg_data,
847: FALSE);
848: IF FND_API.To_Boolean(p_called_by_form) THEN
849: APP_EXCEPTION.Raise_Exception;
850: END IF;
851:
852: END Check_Primary_Key;