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_ASSOCIATION_TYPES_PVT dependencies on FND_MSG_PUB

Line 117: FND_MSG_PUB.ADD;

113: IF l_Association_type_rec.Association_type_code <> p_Association_TYPE_CODE THEN
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: FND_MESSAGE.Set_Name('IBC', 'Invalid Association TYPE');
116: FND_MESSAGE.Set_Token('COLUMN', 'Association_Type_Code', FALSE);
117: FND_MSG_PUB.ADD;
118: END IF;
119: END IF;
120:
121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

209: -- Check for Uniqueness
210: OPEN C_Association_Type(p_Association_Type_Code => l_Association_type_rec.Association_type_code);
211: FETCH C_Association_Type INTO l_Association_Type_Code;
212: IF C_Association_Type%FOUND THEN
213: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: FND_MESSAGE.Set_Name('IBC', 'RECORD Already EXISTS');
216: FND_MESSAGE.Set_Token('COLUMN', 'Association_Type_Code',FALSE);
217: FND_MSG_PUB.ADD;

Line 217: FND_MSG_PUB.ADD;

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

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

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

Line 288: FND_MSG_PUB.ADD;

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

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

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

Line 324: FND_MSG_PUB.ADD;

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

Line 345: FND_MSG_PUB.Count_And_Get

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

Line 357: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 370: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

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

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

Line 436: FND_MSG_PUB.ADD;

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

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

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

Line 469: FND_MSG_PUB.ADD;

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

Line 490: FND_MSG_PUB.Count_And_Get

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

Line 502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

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

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

Line 582: FND_MSG_PUB.ADD;

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

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

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

Line 612: FND_MSG_PUB.ADD;

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

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

618:
619: OPEN C_Association_Type;
620: FETCH C_Association_Type INTO l_Association_Type_Code;
621: IF C_Association_Type%FOUND THEN
622: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
623: FND_MESSAGE.Set_Name('IBC', 'References_ExistAssociationTypeCode');
624: FND_MESSAGE.Set_Token('COLUMN', 'Association_Type_Code', FALSE);
625: FND_MSG_PUB.ADD;
626: END IF;

Line 625: FND_MSG_PUB.ADD;

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

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

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

Line 654: FND_MSG_PUB.ADD;

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

Line 675: FND_MSG_PUB.Count_And_Get

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

Line 687: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 700: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

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

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

Line 926: FND_MSG_PUB.ADD;

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