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.GMI_XFER_MST_PKG dependencies on FND_API

Line 152: IF FND_API.To_Boolean(l_key_exists) THEN

148: 'F',
149: l_rowid,
150: l_key_exists);
151:
152: IF FND_API.To_Boolean(l_key_exists) THEN
153: RAISE Transfer_Exists_Error;
154: END IF;
155:
156: INSERT INTO ic_xfer_mst

Line 304: IF FND_API.To_Boolean(l_key_exists) THEN

300: 'F',
301: l_rowid,
302: l_key_exists);
303:
304: IF FND_API.To_Boolean(l_key_exists) THEN
305: x_rowid := l_rowid;
306: ELSE
307: RAISE Row_Missing_Error;
308: END IF;

Line 312: IF FND_API.To_Boolean(p_commit) THEN

308: END IF;
309:
310: /* Check the commit flag and if set, then commit the work. */
311:
312: IF FND_API.To_Boolean(p_commit) THEN
313: COMMIT WORK;
314: END IF;
315: EXCEPTION
316: WHEN Foreign_Key_Error THEN

Line 322: IF FND_API.To_Boolean(p_called_by_form) THEN

318: x_return_status := l_return_status;
319: x_oracle_error := l_oracle_error;
320: FND_MESSAGE.SET_NAME('GMI', 'IC_FOREIGN_KEY_ERROR');
321: FND_MESSAGE.SET_TOKEN('TEXT', l_msg_data);
322: IF FND_API.To_Boolean(p_called_by_form) THEN
323: APP_EXCEPTION.Raise_Exception;
324: ELSE
325: x_msg_data := FND_MESSAGE.Get;
326: END IF;

Line 332: IF FND_API.To_Boolean(p_called_by_form) THEN

328: ROLLBACK TO SAVEPOINT Insert_Row;
329: x_return_status := 'E';
330: x_oracle_error := l_oracle_error;
331: FND_MESSAGE.SET_NAME('GMA', 'SY_DUPKEYINSERT');
332: IF FND_API.To_Boolean(p_called_by_form) THEN
333: APP_EXCEPTION.Raise_Exception;
334: ELSE
335: x_msg_data := FND_MESSAGE.Get;
336: END IF;

Line 343: IF FND_API.To_Boolean(p_called_by_form) THEN

339: x_return_status := 'E';
340: x_oracle_error := l_oracle_error;
341: FND_MESSAGE.SET_NAME('GMI', 'IC_NO_RECORD_INSERTED');
342: FND_MESSAGE.SET_TOKEN('CODE', p_orgn_code||' '||p_transfer_no);
343: IF FND_API.To_Boolean(p_called_by_form) THEN
344: APP_EXCEPTION.Raise_Exception;
345: ELSE
346: x_msg_data := FND_MESSAGE.Get;
347: END IF;

Line 355: IF FND_API.To_Boolean(p_called_by_form) THEN

351: x_oracle_error := l_oracle_error;
352: l_msg_data := sqlerrm;
353: FND_MESSAGE.SET_NAME('GMI', 'IC_UNEXPECTED_ERROR');
354: FND_MESSAGE.SET_TOKEN('TEXT', l_msg_data);
355: IF FND_API.To_Boolean(p_called_by_form) THEN
356: APP_EXCEPTION.Raise_Exception;
357: ELSE
358: x_msg_data := FND_MESSAGE.Get;
359: END IF;

Line 563: IF FND_API.To_Boolean(p_commit) THEN

559: RAISE Row_Missing_Error;
560: END IF;
561:
562: /* Check the commit flag and if set, then commit the work. */
563: IF FND_API.To_Boolean(p_commit) THEN
564: COMMIT WORK;
565: END IF;
566:
567: EXCEPTION

Line 575: IF FND_API.To_Boolean(p_called_by_form) THEN

571: x_return_status := l_return_status;
572: x_oracle_error := l_oracle_error;
573: FND_MESSAGE.SET_NAME('GMI', 'IC_FOREIGN_KEY_ERROR');
574: FND_MESSAGE.SET_TOKEN('TEXT', l_msg_data);
575: IF FND_API.To_Boolean(p_called_by_form) THEN
576: APP_EXCEPTION.Raise_Exception;
577: ELSE
578: x_msg_data := FND_MESSAGE.Get;
579: END IF;

Line 587: IF FND_API.To_Boolean(p_called_by_form) THEN

583: x_oracle_error := l_oracle_error;
584: FND_MESSAGE.SET_NAME('GMI',
585: 'IC_RECORD_MISSING');
586: FND_MESSAGE.SET_TOKEN('CODE', p_transfer_no);
587: IF FND_API.To_Boolean(p_called_by_form) THEN
588: APP_EXCEPTION.Raise_Exception;
589: ELSE
590: x_msg_data := FND_MESSAGE.Get;
591: END IF;

Line 599: IF FND_API.To_Boolean(p_called_by_form) THEN

595: x_oracle_error := l_oracle_error;
596: l_msg_data := sqlerrm;
597: FND_MESSAGE.SET_NAME('GMI', 'IC_UNEXPECTED_ERROR');
598: FND_MESSAGE.SET_TOKEN('TEXT', l_msg_data);
599: IF FND_API.To_Boolean(p_called_by_form) THEN
600: APP_EXCEPTION.Raise_Exception;
601: ELSE
602: x_msg_data := FND_MESSAGE.Get;
603: END IF;

Line 676: IF FND_API.To_Boolean(p_called_by_form) THEN

672: ROLLBACK TO SAVEPOINT Lock_Row;
673: X_return_status := 'E';
674: FND_MESSAGE.SET_NAME('GMI', 'IC_RECORD_NOT_FOUND');
675: FND_MESSAGE.SET_TOKEN('CODE',p_rowid,FALSE);
676: IF FND_API.To_Boolean(p_called_by_form) THEN
677: APP_EXCEPTION.Raise_Exception;
678: ELSE
679: X_msg_data := FND_MESSAGE.Get;
680: END IF;

Line 685: IF FND_API.To_Boolean(p_called_by_form) THEN

681: WHEN RECORD_CHANGED_ERROR THEN
682: ROLLBACK TO SAVEPOINT Lock_Row;
683: X_return_status := 'E';
684: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_CHANGED');
685: IF FND_API.To_Boolean(p_called_by_form) THEN
686: APP_EXCEPTION.Raise_Exception;
687: ELSE
688: X_msg_data := FND_MESSAGE.Get;
689: END IF;

Line 694: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

690: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
691: ROLLBACK TO SAVEPOINT Lock_Row;
692: X_return_status := 'L';
693: X_oracle_error := APP_EXCEPTION.Get_Code;
694: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
695: FND_MESSAGE.SET_NAME('GMI', 'IC_ROW_IS_LOCKED');
696: X_msg_data := FND_MESSAGE.Get;
697: END IF;
698: WHEN OTHERS THEN

Line 705: IF FND_API.To_Boolean(p_called_by_form) THEN

701: X_oracle_error := APP_EXCEPTION.Get_Code;
702: l_msg_data := APP_EXCEPTION.Get_Text;
703: FND_MESSAGE.SET_NAME('GMI', 'IC_UNEXPECTED_ERROR');
704: FND_MESSAGE.SET_TOKEN('TEXT', l_msg_data);
705: IF FND_API.To_Boolean(p_called_by_form) THEN
706: APP_EXCEPTION.Raise_Exception;
707: ELSE
708: X_msg_data := FND_MESSAGE.Get;
709: END IF;

Line 852: IF FND_API.To_Boolean(p_called_by_form) THEN

848: WHEN Others THEN
849: l_msg_data := sqlerrm;
850: FND_MESSAGE.SET_NAME('GMI', 'IC_UNEXPECTED_ERROR');
851: FND_MESSAGE.SET_TOKEN('TEXT',l_msg_data);
852: IF FND_API.To_Boolean(p_called_by_form) THEN
853: APP_EXCEPTION.Raise_Exception;
854: END IF;
855: END Check_Primary_Key;
856: