DBA Data[Home] [Help]

APPS.GR_EIN_ASL_RISKS_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 Key_Exists_Error;
73: END IF;
74:
75: INSERT INTO gr_ein_asl_risks

Line 102: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 110: IF FND_API.To_Boolean(p_commit) THEN

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

Line 125: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 140: IF FND_API.To_Boolean(p_called_by_form) THEN

136: 'GR_RECORD_EXISTS');
137: FND_MESSAGE.SET_TOKEN('CODE',
138: p_sequence_number || ',' || p_risk_phrase_code,
139: FALSE);
140: IF FND_API.To_Boolean(p_called_by_form) THEN
141: APP_EXCEPTION.Raise_Exception;
142: ELSE
143: x_msg_data := FND_MESSAGE.Get;
144: END IF;

Line 155: IF FND_API.To_Boolean(p_called_by_form) THEN

151: 'GR_NO_RECORD_INSERTED');
152: FND_MESSAGE.SET_TOKEN('CODE',
153: p_sequence_number || ',' || p_risk_phrase_code,
154: FALSE);
155: IF FND_API.To_Boolean(p_called_by_form) THEN
156: APP_EXCEPTION.Raise_Exception;
157: ELSE
158: x_msg_data := FND_MESSAGE.Get;
159: END IF;

Line 171: IF FND_API.To_Boolean(p_called_by_form) THEN

167: 'GR_UNEXPECTED_ERROR');
168: FND_MESSAGE.SET_TOKEN('TEXT',
169: l_msg_data,
170: FALSE);
171: IF FND_API.To_Boolean(p_called_by_form) THEN
172: APP_EXCEPTION.Raise_Exception;
173: ELSE
174: x_msg_data := FND_MESSAGE.Get;
175: END IF;

Line 308: IF FND_API.TO_Boolean(p_commit) THEN

304: WHERE rowid = p_rowid;
305:
306: /* Check the commit flag and if set, then commit the work. */
307:
308: IF FND_API.TO_Boolean(p_commit) THEN
309: COMMIT WORK;
310: END IF;
311:
312: EXCEPTION

Line 318: IF FND_API.To_Boolean(p_called_by_form) THEN

314: WHEN Check_Integrity_Error THEN
315: ROLLBACK TO SAVEPOINT Delete_Row;
316: x_return_status := l_return_status;
317: x_oracle_error := l_oracle_error;
318: IF FND_API.To_Boolean(p_called_by_form) THEN
319: APP_EXCEPTION.Raise_Exception;
320: ELSE
321: x_msg_data := FND_MESSAGE.Get;
322: END IF;

Line 334: IF FND_API.To_Boolean(p_called_by_form) THEN

330: FND_MESSAGE.SET_TOKEN('CODE',
331: p_sequence_number || ', '
332: || p_risk_phrase_code,
333: FALSE);
334: IF FND_API.To_Boolean(p_called_by_form) THEN
335: APP_EXCEPTION.Raise_Exception;
336: ELSE
337: x_msg_data := FND_MESSAGE.Get;
338: END IF;

Line 350: IF FND_API.To_Boolean(p_called_by_form) THEN

346: 'GR_UNEXPECTED_ERROR');
347: FND_MESSAGE.SET_TOKEN('TEXT',
348: l_msg_data,
349: FALSE);
350: IF FND_API.To_Boolean(p_called_by_form) THEN
351: APP_EXCEPTION.Raise_Exception;
352: ELSE
353: x_msg_data := FND_MESSAGE.Get;
354: END IF;

Line 411: IF FND_API.To_Boolean(p_called_by_form) THEN

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