eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GR_REGION_LANGUAGES_PKG dependencies on FND_API

Line 68: IF FND_API.To_Boolean(l_key_exists) THEN

64: 'F',
65: l_rowid,
66: l_key_exists);
67:
68: IF FND_API.To_Boolean(l_key_exists) THEN
69: RAISE Item_Exists_Error;
70: END IF;
71:
72: INSERT INTO gr_region_languages

Line 98: IF FND_API.To_Boolean(l_key_exists) THEN

94: 'F',
95: l_rowid,
96: l_key_exists);
97:
98: IF FND_API.To_Boolean(l_key_exists) THEN
99: x_rowid := l_rowid;
100: ELSE
101: RAISE Row_Missing_Error;
102: END IF;

Line 106: IF FND_API.To_Boolean(p_commit) THEN

102: END IF;
103:
104: /* Check the commit flag and if set, then commit the work. */
105:
106: IF FND_API.To_Boolean(p_commit) THEN
107: COMMIT WORK;
108: END IF;
109:
110: EXCEPTION

Line 121: IF FND_API.To_Boolean(p_called_by_form) THEN

117: 'GR_FOREIGN_KEY_ERROR');
118: FND_MESSAGE.SET_TOKEN('TEXT',
119: l_msg_data,
120: FALSE);
121: IF FND_API.To_Boolean(p_called_by_form) THEN
122: APP_EXCEPTION.Raise_Exception;
123: ELSE
124: x_msg_data := FND_MESSAGE.Get;
125: END IF;

Line 136: IF FND_API.To_Boolean(p_called_by_form) THEN

132: 'GR_RECORD_EXISTS');
133: FND_MESSAGE.SET_TOKEN('CODE',
134: p_region_code || ' ' || p_language,
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_NO_RECORD_INSERTED');
148: FND_MESSAGE.SET_TOKEN('CODE',
149: p_region_code || ' ' || p_language,
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 167: IF FND_API.To_Boolean(p_called_by_form) THEN

163: 'GR_UNEXPECTED_ERROR');
164: FND_MESSAGE.SET_TOKEN('TEXT',
165: l_msg_data,
166: FALSE);
167: IF FND_API.To_Boolean(p_called_by_form) THEN
168: APP_EXCEPTION.Raise_Exception;
169: ELSE
170: x_msg_data := FND_MESSAGE.Get;
171: END IF;

Line 242: IF FND_API.To_Boolean(p_commit) THEN

238: END IF;
239:
240: /* Check the commit flag and if set, then commit the work. */
241:
242: IF FND_API.To_Boolean(p_commit) THEN
243: COMMIT WORK;
244: END IF;
245:
246: EXCEPTION

Line 257: IF FND_API.To_Boolean(p_called_by_form) THEN

253: 'GR_FOREIGN_KEY_ERROR');
254: FND_MESSAGE.SET_TOKEN('TEXT',
255: l_msg_data,
256: FALSE);
257: IF FND_API.To_Boolean(p_called_by_form) THEN
258: APP_EXCEPTION.Raise_Exception;
259: ELSE
260: x_msg_data := FND_MESSAGE.Get;
261: END IF;

Line 272: IF FND_API.To_Boolean(p_called_by_form) THEN

268: 'GR_NO_RECORD_INSERTED');
269: FND_MESSAGE.SET_TOKEN('CODE',
270: p_region_code || ' ' || p_language,
271: FALSE);
272: IF FND_API.To_Boolean(p_called_by_form) THEN
273: APP_EXCEPTION.Raise_Exception;
274: ELSE
275: x_msg_data := FND_MESSAGE.Get;
276: END IF;

Line 288: IF FND_API.To_Boolean(p_called_by_form) THEN

284: 'GR_UNEXPECTED_ERROR');
285: FND_MESSAGE.SET_TOKEN('TEXT',
286: l_msg_data,
287: FALSE);
288: IF FND_API.To_Boolean(p_called_by_form) THEN
289: APP_EXCEPTION.Raise_Exception;
290: ELSE
291: x_msg_data := FND_MESSAGE.Get;
292: END IF;

Line 355: IF FND_API.To_Boolean(p_commit) THEN

351: RAISE No_Data_Found_Error;
352: END IF;
353: CLOSE c_lock_regions;
354:
355: IF FND_API.To_Boolean(p_commit) THEN
356: COMMIT WORK;
357: END IF;
358:
359: EXCEPTION

Line 369: IF FND_API.To_Boolean(p_called_by_form) THEN

365: 'GR_RECORD_NOT_FOUND');
366: FND_MESSAGE.SET_TOKEN('CODE',
367: p_region_code || ' ' || p_language,
368: FALSE);
369: IF FND_API.To_Boolean(p_called_by_form) THEN
370: APP_EXCEPTION.Raise_Exception;
371: ELSE
372: x_msg_data := FND_MESSAGE.Get;
373: END IF;

Line 381: IF FND_API.To_Boolean(p_called_by_form) THEN

377: x_return_status := 'E';
378: x_oracle_error := APP_EXCEPTION.Get_Code;
379: FND_MESSAGE.SET_NAME('GR',
380: 'GR_ROW_IS_LOCKED');
381: IF FND_API.To_Boolean(p_called_by_form) THEN
382: APP_EXCEPTION.Raise_Exception;
383: ELSE
384: x_msg_data := FND_MESSAGE.Get;
385: END IF;

Line 397: IF FND_API.To_Boolean(p_called_by_form) THEN

393: 'GR_UNEXPECTED_ERROR');
394: FND_MESSAGE.SET_TOKEN('TEXT',
395: l_msg_data,
396: FALSE);
397: IF FND_API.To_Boolean(p_called_by_form) THEN
398: APP_EXCEPTION.Raise_Exception;
399: ELSE
400: x_msg_data := FND_MESSAGE.Get;
401: END IF;

Line 466: IF FND_API.TO_Boolean(p_commit) THEN

462: WHERE rowid = p_rowid;
463:
464: /* Check the commit flag and if set, then commit the work. */
465:
466: IF FND_API.TO_Boolean(p_commit) THEN
467: COMMIT WORK;
468: END IF;
469:
470: EXCEPTION

Line 476: IF FND_API.To_Boolean(p_called_by_form) THEN

472: WHEN Check_Integrity_Error THEN
473: ROLLBACK TO SAVEPOINT Delete_Row;
474: x_return_status := l_return_status;
475: x_oracle_error := l_oracle_error;
476: IF FND_API.To_Boolean(p_called_by_form) THEN
477: APP_EXCEPTION.Raise_Exception;
478: ELSE
479: x_msg_data := FND_MESSAGE.Get;
480: END IF;

Line 491: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 508: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 550: IF FND_API.To_Boolean(p_commit) THEN

546:
547: DELETE FROM gr_region_languages
548: WHERE region_code = p_region_code;
549:
550: IF FND_API.To_Boolean(p_commit) THEN
551: COMMIT WORK;
552: END IF;
553:
554: EXCEPTION

Line 566: IF FND_API.To_Boolean(p_called_by_form) THEN

562: 'GR_UNEXPECTED_ERROR');
563: FND_MESSAGE.SET_TOKEN('TEXT',
564: l_msg_token,
565: FALSE);
566: IF FND_API.To_Boolean(p_called_by_form) THEN
567: APP_EXCEPTION.Raise_Exception;
568: ELSE
569: x_msg_data := FND_MESSAGE.Get;
570: END IF;

Line 673: IF FND_API.To_Boolean(p_called_by_form) THEN

669: 'GR_UNEXPECTED_ERROR');
670: FND_MESSAGE.SET_TOKEN('TEXT',
671: l_msg_data,
672: FALSE);
673: IF FND_API.To_Boolean(p_called_by_form) THEN
674: APP_EXCEPTION.Raise_Exception;
675: ELSE
676: x_msg_data := FND_MESSAGE.Get;
677: 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: END IF;
734:
735: END Check_Primary_Key;