DBA Data[Home] [Help]

APPS.GR_PROPERTIES_TL_PKG dependencies on FND_API

Line 72: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 106: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 114: IF FND_API.To_Boolean(p_commit) THEN

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

Line 129: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 145: IF FND_API.To_Boolean(p_called_by_form) THEN

141: 'GR_RECORD_EXISTS');
142: FND_MESSAGE.SET_TOKEN('CODE',
143: l_msg_token,
144: FALSE);
145: IF FND_API.To_Boolean(p_called_by_form) THEN
146: APP_EXCEPTION.Raise_Exception;
147: ELSE
148: x_msg_data := FND_MESSAGE.Get;
149: END IF;

Line 161: IF FND_API.To_Boolean(p_called_by_form) THEN

157: 'GR_NO_RECORD_INSERTED');
158: FND_MESSAGE.SET_TOKEN('CODE',
159: l_msg_token,
160: FALSE);
161: IF FND_API.To_Boolean(p_called_by_form) THEN
162: APP_EXCEPTION.Raise_Exception;
163: ELSE
164: x_msg_data := FND_MESSAGE.Get;
165: END IF;

Line 178: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 261: IF FND_API.To_Boolean(p_commit) THEN

257: END IF;
258:
259: /* Check the commit flag and if set, then commit the work. */
260:
261: IF FND_API.To_Boolean(p_commit) THEN
262: COMMIT WORK;
263: END IF;
264:
265: EXCEPTION

Line 276: IF FND_API.To_Boolean(p_called_by_form) THEN

272: 'GR_FOREIGN_KEY_ERROR');
273: FND_MESSAGE.SET_TOKEN('TEXT',
274: l_msg_data,
275: FALSE);
276: IF FND_API.To_Boolean(p_called_by_form) THEN
277: APP_EXCEPTION.Raise_Exception;
278: ELSE
279: x_msg_data := FND_MESSAGE.Get;
280: END IF;

Line 291: IF FND_API.To_Boolean(p_called_by_form) THEN

287: 'GR_NO_RECORD_INSERTED');
288: FND_MESSAGE.SET_TOKEN('CODE',
289: l_msg_token,
290: FALSE);
291: IF FND_API.To_Boolean(p_called_by_form) THEN
292: APP_EXCEPTION.Raise_Exception;
293: ELSE
294: x_msg_data := FND_MESSAGE.Get;
295: END IF;

Line 307: IF FND_API.To_Boolean(p_called_by_form) THEN

303: 'GR_UNEXPECTED_ERROR');
304: FND_MESSAGE.SET_TOKEN('TEXT',
305: l_msg_token,
306: FALSE);
307: IF FND_API.To_Boolean(p_called_by_form) THEN
308: APP_EXCEPTION.Raise_Exception;
309: ELSE
310: x_msg_data := FND_MESSAGE.Get;
311: END IF;

Line 475: IF FND_API.To_Boolean(p_commit) THEN

471: END LOOP;
472: END IF;
473: CLOSE c_get_installed_languages;
474:
475: IF FND_API.To_Boolean(p_commit) THEN
476: COMMIT WORK;
477: END IF;
478:
479: EXCEPTION

Line 490: IF FND_API.To_Boolean(p_called_by_form) THEN

486: 'GR_RECORD_NOT_FOUND');
487: FND_MESSAGE.SET_TOKEN('CODE',
488: l_msg_token,
489: FALSE);
490: IF FND_API.To_Boolean(p_called_by_form) THEN
491: APP_EXCEPTION.Raise_Exception;
492: ELSE
493: x_msg_data := FND_MESSAGE.Get;
494: END IF;

Line 506: IF FND_API.To_Boolean(p_called_by_form) THEN

502: 'GR_UNEXPECTED_ERROR');
503: FND_MESSAGE.SET_TOKEN('TEXT',
504: l_msg_token,
505: FALSE);
506: IF FND_API.To_Boolean(p_called_by_form) THEN
507: APP_EXCEPTION.Raise_Exception;
508: ELSE
509: x_msg_data := FND_MESSAGE.Get;
510: END IF;

Line 577: IF FND_API.To_Boolean(p_commit) THEN

573: RAISE No_Data_Found_Error;
574: END IF;
575: CLOSE c_lock_properties_tl;
576:
577: IF FND_API.To_Boolean(p_commit) THEN
578: COMMIT WORK;
579: END IF;
580:
581: EXCEPTION

Line 591: IF FND_API.To_Boolean(p_called_by_form) THEN

587: 'GR_RECORD_NOT_FOUND');
588: FND_MESSAGE.SET_TOKEN('CODE',
589: l_msg_token,
590: FALSE);
591: IF FND_API.To_Boolean(p_called_by_form) THEN
592: APP_EXCEPTION.Raise_Exception;
593: ELSE
594: x_msg_data := FND_MESSAGE.Get;
595: END IF;

Line 603: IF FND_API.To_Boolean(p_called_by_form) THEN

599: x_return_status := 'E';
600: x_oracle_error := APP_EXCEPTION.Get_Code;
601: FND_MESSAGE.SET_NAME('GR',
602: 'GR_ROW_IS_LOCKED');
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,
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 696: IF FND_API.TO_Boolean(p_commit) THEN

692: WHERE rowid = p_rowid;
693:
694: /* Check the commit flag and if set, then commit the work. */
695:
696: IF FND_API.TO_Boolean(p_commit) THEN
697: COMMIT WORK;
698: END IF;
699:
700: EXCEPTION

Line 706: IF FND_API.To_Boolean(p_called_by_form) THEN

702: WHEN Check_Integrity_Error THEN
703: ROLLBACK TO SAVEPOINT Delete_Row;
704: x_return_status := l_return_status;
705: x_oracle_error := l_oracle_error;
706: IF FND_API.To_Boolean(p_called_by_form) THEN
707: APP_EXCEPTION.Raise_Exception;
708: ELSE
709: x_msg_data := FND_MESSAGE.Get;
710: END IF;

Line 721: IF FND_API.To_Boolean(p_called_by_form) THEN

717: 'GR_RECORD_NOT_FOUND');
718: FND_MESSAGE.SET_TOKEN('CODE',
719: l_msg_token,
720: FALSE);
721: IF FND_API.To_Boolean(p_called_by_form) THEN
722: APP_EXCEPTION.Raise_Exception;
723: ELSE
724: x_msg_data := FND_MESSAGE.Get;
725: END IF;

Line 738: IF FND_API.To_Boolean(p_called_by_form) THEN

734: 'GR_UNEXPECTED_ERROR');
735: FND_MESSAGE.SET_TOKEN('TEXT',
736: l_msg_token,
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 780: IF FND_API.To_Boolean(p_commit) THEN

776:
777: DELETE FROM gr_properties_tl
778: WHERE property_id = p_property_id;
779:
780: IF FND_API.To_Boolean(p_commit) THEN
781: COMMIT WORK;
782: END IF;
783:
784: EXCEPTION

Line 796: IF FND_API.To_Boolean(p_called_by_form) THEN

792: 'GR_UNEXPECTED_ERROR');
793: FND_MESSAGE.SET_TOKEN('TEXT',
794: l_msg_token,
795: FALSE);
796: IF FND_API.To_Boolean(p_called_by_form) THEN
797: APP_EXCEPTION.Raise_Exception;
798: ELSE
799: x_msg_data := FND_MESSAGE.Get;
800: END IF;

Line 963: IF FND_API.To_Boolean(p_called_by_form) THEN

959: 'GR_INSTALLED_LANG');
960: FND_MESSAGE.SET_TOKEN('CODE',
961: p_language,
962: FALSE);
963: IF FND_API.To_Boolean(p_called_by_form) THEN
964: APP_EXCEPTION.Raise_Exception;
965: ELSE
966: x_msg_data := FND_MESSAGE.Get;
967: END IF;

Line 979: IF FND_API.To_Boolean(p_called_by_form) THEN

975: 'GR_UNEXPECTED_ERROR');
976: FND_MESSAGE.SET_TOKEN('TEXT',
977: l_msg_data,
978: FALSE);
979: IF FND_API.To_Boolean(p_called_by_form) THEN
980: APP_EXCEPTION.Raise_Exception;
981: ELSE
982: x_msg_data := FND_MESSAGE.Get;
983: END IF;

Line 1039: IF FND_API.To_Boolean(p_called_by_form) THEN

1035: 'GR_UNEXPECTED_ERROR');
1036: FND_MESSAGE.SET_TOKEN('TEXT',
1037: l_msg_data,
1038: FALSE);
1039: IF FND_API.To_Boolean(p_called_by_form) THEN
1040: APP_EXCEPTION.Raise_Exception;
1041: END IF;
1042:
1043: END Check_Primary_Key;