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_REGIONS_PKG dependencies on FND_API

Line 67: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 96: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 104: IF FND_API.To_Boolean(p_commit) THEN

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

Line 119: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 134: IF FND_API.To_Boolean(p_called_by_form) THEN

130: 'GR_RECORD_EXISTS');
131: FND_MESSAGE.SET_TOKEN('CODE',
132: p_region_code,
133: FALSE);
134: IF FND_API.To_Boolean(p_called_by_form) THEN
135: APP_EXCEPTION.Raise_Exception;
136: ELSE
137: x_msg_data := FND_MESSAGE.Get;
138: END IF;

Line 149: IF FND_API.To_Boolean(p_called_by_form) THEN

145: 'GR_NO_RECORD_INSERTED');
146: FND_MESSAGE.SET_TOKEN('CODE',
147: p_region_code,
148: FALSE);
149: IF FND_API.To_Boolean(p_called_by_form) THEN
150: APP_EXCEPTION.Raise_Exception;
151: ELSE
152: x_msg_data := FND_MESSAGE.Get;
153: END IF;

Line 165: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 240: IF FND_API.To_Boolean(p_commit) THEN

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

Line 255: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 270: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 286: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 353: IF FND_API.To_Boolean(p_commit) THEN

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

Line 367: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 379: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 395: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 464: IF FND_API.TO_Boolean(p_commit) THEN

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

Line 474: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 489: IF FND_API.To_Boolean(p_called_by_form) THEN

485: 'GR_RECORD_NOT_FOUND');
486: FND_MESSAGE.SET_TOKEN('CODE',
487: p_region_code,
488: FALSE);
489: IF FND_API.To_Boolean(p_called_by_form) THEN
490: APP_EXCEPTION.Raise_Exception;
491: ELSE
492: x_msg_data := FND_MESSAGE.Get;
493: 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_data,
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 659: IF FND_API.To_Boolean(p_called_by_form) THEN

655: FALSE);
656: FND_MESSAGE.SET_TOKEN('TABLES',
657: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
658: FALSE);
659: IF FND_API.To_Boolean(p_called_by_form) THEN
660: APP_EXCEPTION.Raise_Exception;
661: ELSE
662: x_msg_data := FND_MESSAGE.Get;
663: END IF;

Line 674: IF FND_API.To_Boolean(p_called_by_form) THEN

670: 'GR_UNEXPECTED_ERROR');
671: FND_MESSAGE.SET_TOKEN('TEXT',
672: l_msg_data,
673: FALSE);
674: IF FND_API.To_Boolean(p_called_by_form) THEN
675: APP_EXCEPTION.Raise_Exception;
676: ELSE
677: x_msg_data := FND_MESSAGE.Get;
678: END IF;

Line 730: IF FND_API.To_Boolean(p_called_by_form) THEN

726: 'GR_UNEXPECTED_ERROR');
727: FND_MESSAGE.SET_TOKEN('TEXT',
728: l_msg_data,
729: FALSE);
730: IF FND_API.To_Boolean(p_called_by_form) THEN
731: APP_EXCEPTION.Raise_Exception;
732: END IF;
733:
734: END Check_Primary_Key;