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.IBC_LABELS_GRP dependencies on FND_MSG_PUB

Line 115: FND_MSG_PUB.ADD;

111: IF l_Label_rec.Label_code <> p_Label_CODE THEN
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: FND_MESSAGE.Set_Name('IBC', 'Invalid Association TYPE');
114: FND_MESSAGE.Set_Token('COLUMN', 'Label_Code', FALSE);
115: FND_MSG_PUB.ADD;
116: END IF;
117: END IF;
118:
119: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

207: -- Check for Uniqueness
208: OPEN C_Label(p_Label_Code => l_Label_rec.Label_code);
209: FETCH C_Label INTO l_Label_Code;
210: IF C_Label%FOUND THEN
211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
212: x_return_status := FND_API.G_RET_STS_ERROR;
213: FND_MESSAGE.Set_Name('IBC', 'RECORD Already EXISTS');
214: FND_MESSAGE.Set_Token('COLUMN', 'Label_Code',FALSE);
215: FND_MSG_PUB.ADD;

Line 215: FND_MSG_PUB.ADD;

211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
212: x_return_status := FND_API.G_RET_STS_ERROR;
213: FND_MESSAGE.Set_Name('IBC', 'RECORD Already EXISTS');
214: FND_MESSAGE.Set_Token('COLUMN', 'Label_Code',FALSE);
215: FND_MSG_PUB.ADD;
216: END IF;
217: END IF;
218:
219: CLOSE C_Label;

Line 281: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

277: -- Validate Environment
278: -- ******************************************************************
279: IF FND_GLOBAL.User_Id IS NULL
280: THEN
281: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
282: THEN
283: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
284: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
285: FND_MSG_PUB.ADD;

Line 285: FND_MSG_PUB.ADD;

281: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
282: THEN
283: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
284: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
285: FND_MSG_PUB.ADD;
286: END IF;
287: RAISE FND_API.G_EXC_ERROR;
288: END IF;
289:

Line 321: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

317: END IF;
318:
319: ---
320: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
321: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
322: FND_MESSAGE.Set_Name('IBC', 'IBC_INSERT_ERROR');
323: FND_MSG_PUB.ADD;
324: END IF;
325:

Line 323: FND_MSG_PUB.ADD;

319: ---
320: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
321: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
322: FND_MESSAGE.Set_Name('IBC', 'IBC_INSERT_ERROR');
323: FND_MSG_PUB.ADD;
324: END IF;
325:
326: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 344: FND_MSG_PUB.Count_And_Get

340: COMMIT WORK;
341: END IF;
342:
343: -- Standard call to get message count and if count is 1, get message info.
344: FND_MSG_PUB.Count_And_Get
345: ( p_count => x_msg_count,
346: p_data => x_msg_data
347: );
348:

Line 356: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

352: ROLLBACK;
353: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
354: P_API_NAME => L_API_NAME
355: ,P_PKG_NAME => G_PKG_NAME
356: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
357: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
358: ,P_SQLCODE => SQLCODE
359: ,P_SQLERRM => SQLERRM
360: ,X_MSG_COUNT => X_MSG_COUNT

Line 369: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

365: ROLLBACK;
366: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
367: P_API_NAME => L_API_NAME
368: ,P_PKG_NAME => G_PKG_NAME
369: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
370: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
371: ,P_SQLCODE => SQLCODE
372: ,P_SQLERRM => SQLERRM
373: ,X_MSG_COUNT => X_MSG_COUNT

Line 431: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

427: -- Validate Environment
428: -- ******************************************************************
429: IF FND_GLOBAL.User_Id IS NULL
430: THEN
431: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
432: THEN
433: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
434: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
435: FND_MSG_PUB.ADD;

Line 435: FND_MSG_PUB.ADD;

431: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
432: THEN
433: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
434: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
435: FND_MSG_PUB.ADD;
436: END IF;
437: RAISE FND_API.G_EXC_ERROR;
438: END IF;
439:

Line 469: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

465: END IF;
466:
467: ---
468: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
469: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
470: FND_MESSAGE.Set_Name('IBC', 'IBC_UPDATE_ERROR');
471: FND_MSG_PUB.ADD;
472: END IF;
473:

Line 471: FND_MSG_PUB.ADD;

467: ---
468: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
469: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
470: FND_MESSAGE.Set_Name('IBC', 'IBC_UPDATE_ERROR');
471: FND_MSG_PUB.ADD;
472: END IF;
473:
474: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 492: FND_MSG_PUB.Count_And_Get

488: COMMIT WORK;
489: END IF;
490:
491: -- Standard call to get message count and if count is 1, get message info.
492: FND_MSG_PUB.Count_And_Get
493: ( p_count => x_msg_count,
494: p_data => x_msg_data
495: );
496:

Line 504: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

500: ROLLBACK;
501: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
502: P_API_NAME => L_API_NAME
503: ,P_PKG_NAME => G_PKG_NAME
504: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
505: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
506: ,P_SQLCODE => SQLCODE
507: ,P_SQLERRM => SQLERRM
508: ,X_MSG_COUNT => X_MSG_COUNT

Line 517: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

513: ROLLBACK;
514: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
515: P_API_NAME => L_API_NAME
516: ,P_PKG_NAME => G_PKG_NAME
517: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
518: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
519: ,P_SQLCODE => SQLCODE
520: ,P_SQLERRM => SQLERRM
521: ,X_MSG_COUNT => X_MSG_COUNT

Line 580: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

576: -- Validate Environment
577: -- ******************************************************************
578: IF FND_GLOBAL.User_Id IS NULL
579: THEN
580: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
581: THEN
582: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
583: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
584: FND_MSG_PUB.ADD;

Line 584: FND_MSG_PUB.ADD;

580: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
581: THEN
582: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
583: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
584: FND_MSG_PUB.ADD;
585: END IF;
586: RAISE FND_API.G_EXC_ERROR;
587: END IF;
588:

Line 611: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

607: -- Check If the Record Exists
608: OPEN C_Label;
609: FETCH C_Label INTO l_Label_Code;
610: IF C_Label%NOTFOUND THEN
611: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
612: FND_MESSAGE.Set_Name('IBC', 'Cannot Find Record to be Deleted');
613: FND_MESSAGE.Set_Token('COLUMN', 'Label_Code', FALSE);
614: FND_MSG_PUB.ADD;
615: END IF;

Line 614: FND_MSG_PUB.ADD;

610: IF C_Label%NOTFOUND THEN
611: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
612: FND_MESSAGE.Set_Name('IBC', 'Cannot Find Record to be Deleted');
613: FND_MESSAGE.Set_Token('COLUMN', 'Label_Code', FALSE);
614: FND_MSG_PUB.ADD;
615: END IF;
616: CLOSE C_Label;
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;

Line 624: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

620:
621: OPEN C_Label;
622: FETCH C_Label INTO l_Label_Code;
623: IF C_Label%FOUND THEN
624: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
625: FND_MESSAGE.Set_Name('IBC', 'References_ExistAssociationTypeCode');
626: FND_MESSAGE.Set_Token('COLUMN', 'Label_Code', FALSE);
627: FND_MSG_PUB.ADD;
628: END IF;

Line 627: FND_MSG_PUB.ADD;

623: IF C_Label%FOUND THEN
624: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
625: FND_MESSAGE.Set_Name('IBC', 'References_ExistAssociationTypeCode');
626: FND_MESSAGE.Set_Token('COLUMN', 'Label_Code', FALSE);
627: FND_MSG_PUB.ADD;
628: END IF;
629: CLOSE C_Label;
630: RAISE FND_API.G_EXC_ERROR;
631: END IF;

Line 654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

650: p_Label_CODE =>p_Label_CODE);
651:
652:
653: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
655: FND_MESSAGE.Set_Name('IBC', 'IBC_DELETE_ERROR');
656: FND_MSG_PUB.ADD;
657: END IF;
658:

Line 656: FND_MSG_PUB.ADD;

652:
653: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
655: FND_MESSAGE.Set_Name('IBC', 'IBC_DELETE_ERROR');
656: FND_MSG_PUB.ADD;
657: END IF;
658:
659: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 677: FND_MSG_PUB.Count_And_Get

673: COMMIT WORK;
674: END IF;
675:
676: -- Standard call to get message count and if count is 1, get message info.
677: FND_MSG_PUB.Count_And_Get
678: ( p_count => x_msg_count,
679: p_data => x_msg_data
680: );
681:

Line 689: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

685: ROLLBACK;
686: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
687: P_API_NAME => L_API_NAME
688: ,P_PKG_NAME => G_PKG_NAME
689: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
690: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
691: ,P_SQLCODE => SQLCODE
692: ,P_SQLERRM => SQLERRM
693: ,X_MSG_COUNT => X_MSG_COUNT

Line 702: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

698: ROLLBACK;
699: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
700: P_API_NAME => L_API_NAME
701: ,P_PKG_NAME => G_PKG_NAME
702: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
703: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
704: ,P_SQLCODE => SQLCODE
705: ,P_SQLERRM => SQLERRM
706: ,X_MSG_COUNT => X_MSG_COUNT

Line 921: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

917: EXCEPTION
918: WHEN NO_DATA_FOUND THEN
919: RAISE NO_DATA_FOUND;
920: WHEN OTHERS THEN
921: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
922: FND_MESSAGE.Set_Name('IBC', 'Association TYPE RECORD Error');
923: FND_MSG_PUB.ADD;
924: END IF;
925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 923: FND_MSG_PUB.ADD;

919: RAISE NO_DATA_FOUND;
920: WHEN OTHERS THEN
921: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
922: FND_MESSAGE.Set_Name('IBC', 'Association TYPE RECORD Error');
923: FND_MSG_PUB.ADD;
924: END IF;
925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: END Query_Label_Row;
927: