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

Line 33: If (px_GENERIC_ERRMSGS_ID IS NULL) OR (px_GENERIC_ERRMSGS_ID = FND_API.G_MISS_NUM) then

29:
30: IS
31: CURSOR C2 IS SELECT CSD_GENERIC_ERRMSGS_S1.nextval FROM sys.dual;
32: BEGIN
33: If (px_GENERIC_ERRMSGS_ID IS NULL) OR (px_GENERIC_ERRMSGS_ID = FND_API.G_MISS_NUM) then
34: OPEN C2;
35: FETCH C2 INTO px_GENERIC_ERRMSGS_ID;
36: CLOSE C2;
37: End If;

Line 55: ,decode( p_MODULE_CODE, FND_API.G_MISS_CHAR, NULL, p_MODULE_CODE)

51: ,LAST_UPDATE_LOGIN
52: ,OBJECT_VERSION_NUMBER
53: ) VALUES (
54: px_GENERIC_ERRMSGS_ID
55: ,decode( p_MODULE_CODE, FND_API.G_MISS_CHAR, NULL, p_MODULE_CODE)
56: ,decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID1)
57: ,decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID2)
58: ,decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_ENTITY_TYPE_CODE)
59: ,decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_MSG_TYPE_CODE)

Line 56: ,decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID1)

52: ,OBJECT_VERSION_NUMBER
53: ) VALUES (
54: px_GENERIC_ERRMSGS_ID
55: ,decode( p_MODULE_CODE, FND_API.G_MISS_CHAR, NULL, p_MODULE_CODE)
56: ,decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID1)
57: ,decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID2)
58: ,decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_ENTITY_TYPE_CODE)
59: ,decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_MSG_TYPE_CODE)
60: ,decode( p_MSG, FND_API.G_MISS_CHAR, NULL, p_MSG)

Line 57: ,decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID2)

53: ) VALUES (
54: px_GENERIC_ERRMSGS_ID
55: ,decode( p_MODULE_CODE, FND_API.G_MISS_CHAR, NULL, p_MODULE_CODE)
56: ,decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID1)
57: ,decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID2)
58: ,decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_ENTITY_TYPE_CODE)
59: ,decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_MSG_TYPE_CODE)
60: ,decode( p_MSG, FND_API.G_MISS_CHAR, NULL, p_MSG)
61: ,decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL, p_MSG_STATUS)

Line 58: ,decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_ENTITY_TYPE_CODE)

54: px_GENERIC_ERRMSGS_ID
55: ,decode( p_MODULE_CODE, FND_API.G_MISS_CHAR, NULL, p_MODULE_CODE)
56: ,decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID1)
57: ,decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID2)
58: ,decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_ENTITY_TYPE_CODE)
59: ,decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_MSG_TYPE_CODE)
60: ,decode( p_MSG, FND_API.G_MISS_CHAR, NULL, p_MSG)
61: ,decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL, p_MSG_STATUS)
62: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

Line 59: ,decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_MSG_TYPE_CODE)

55: ,decode( p_MODULE_CODE, FND_API.G_MISS_CHAR, NULL, p_MODULE_CODE)
56: ,decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID1)
57: ,decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID2)
58: ,decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_ENTITY_TYPE_CODE)
59: ,decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_MSG_TYPE_CODE)
60: ,decode( p_MSG, FND_API.G_MISS_CHAR, NULL, p_MSG)
61: ,decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL, p_MSG_STATUS)
62: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
63: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)

Line 60: ,decode( p_MSG, FND_API.G_MISS_CHAR, NULL, p_MSG)

56: ,decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID1)
57: ,decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID2)
58: ,decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_ENTITY_TYPE_CODE)
59: ,decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_MSG_TYPE_CODE)
60: ,decode( p_MSG, FND_API.G_MISS_CHAR, NULL, p_MSG)
61: ,decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL, p_MSG_STATUS)
62: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
63: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

Line 61: ,decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL, p_MSG_STATUS)

57: ,decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM, NULL, p_SOURCE_ENTITY_ID2)
58: ,decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_ENTITY_TYPE_CODE)
59: ,decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_MSG_TYPE_CODE)
60: ,decode( p_MSG, FND_API.G_MISS_CHAR, NULL, p_MSG)
61: ,decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL, p_MSG_STATUS)
62: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
63: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
65: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)

Line 62: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

58: ,decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_ENTITY_TYPE_CODE)
59: ,decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_MSG_TYPE_CODE)
60: ,decode( p_MSG, FND_API.G_MISS_CHAR, NULL, p_MSG)
61: ,decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL, p_MSG_STATUS)
62: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
63: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
65: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
66: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

Line 63: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)

59: ,decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_MSG_TYPE_CODE)
60: ,decode( p_MSG, FND_API.G_MISS_CHAR, NULL, p_MSG)
61: ,decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL, p_MSG_STATUS)
62: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
63: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
65: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
66: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
67: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER));

Line 64: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

60: ,decode( p_MSG, FND_API.G_MISS_CHAR, NULL, p_MSG)
61: ,decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL, p_MSG_STATUS)
62: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
63: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
65: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
66: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
67: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER));
68: End Insert_Row;

Line 65: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)

61: ,decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL, p_MSG_STATUS)
62: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
63: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
65: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
66: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
67: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER));
68: End Insert_Row;
69:

Line 66: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

62: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
63: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
65: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
66: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
67: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER));
68: End Insert_Row;
69:
70: PROCEDURE Update_Row(

Line 67: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER));

63: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
64: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
65: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
66: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
67: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER));
68: End Insert_Row;
69:
70: PROCEDURE Update_Row(
71: p_GENERIC_ERRMSGS_ID NUMBER

Line 90: MODULE_CODE = decode( p_MODULE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, MODULE_CODE, p_MODULE_CODE)

86: IS
87: BEGIN
88: Update CSD_GENERIC_ERRMSGS
89: SET
90: MODULE_CODE = decode( p_MODULE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, MODULE_CODE, p_MODULE_CODE)
91: ,SOURCE_ENTITY_ID1 = decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID1, p_SOURCE_ENTITY_ID1)
92: ,SOURCE_ENTITY_ID2 = decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID2, p_SOURCE_ENTITY_ID2)
93: ,SOURCE_ENTITY_TYPE_CODE = decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, SOURCE_ENTITY_TYPE_CODE, p_SOURCE_ENTITY_TYPE_CODE)
94: ,MSG_TYPE_CODE = decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,NULL, MSG_TYPE_CODE, p_MSG_TYPE_CODE)

Line 91: ,SOURCE_ENTITY_ID1 = decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID1, p_SOURCE_ENTITY_ID1)

87: BEGIN
88: Update CSD_GENERIC_ERRMSGS
89: SET
90: MODULE_CODE = decode( p_MODULE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, MODULE_CODE, p_MODULE_CODE)
91: ,SOURCE_ENTITY_ID1 = decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID1, p_SOURCE_ENTITY_ID1)
92: ,SOURCE_ENTITY_ID2 = decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID2, p_SOURCE_ENTITY_ID2)
93: ,SOURCE_ENTITY_TYPE_CODE = decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, SOURCE_ENTITY_TYPE_CODE, p_SOURCE_ENTITY_TYPE_CODE)
94: ,MSG_TYPE_CODE = decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,NULL, MSG_TYPE_CODE, p_MSG_TYPE_CODE)
95: ,MSG = decode( p_MSG, FND_API.G_MISS_CHAR,NULL,NULL, MSG, p_MSG)

Line 92: ,SOURCE_ENTITY_ID2 = decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID2, p_SOURCE_ENTITY_ID2)

88: Update CSD_GENERIC_ERRMSGS
89: SET
90: MODULE_CODE = decode( p_MODULE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, MODULE_CODE, p_MODULE_CODE)
91: ,SOURCE_ENTITY_ID1 = decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID1, p_SOURCE_ENTITY_ID1)
92: ,SOURCE_ENTITY_ID2 = decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID2, p_SOURCE_ENTITY_ID2)
93: ,SOURCE_ENTITY_TYPE_CODE = decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, SOURCE_ENTITY_TYPE_CODE, p_SOURCE_ENTITY_TYPE_CODE)
94: ,MSG_TYPE_CODE = decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,NULL, MSG_TYPE_CODE, p_MSG_TYPE_CODE)
95: ,MSG = decode( p_MSG, FND_API.G_MISS_CHAR,NULL,NULL, MSG, p_MSG)
96: ,MSG_STATUS = decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL,NULL, MSG_STATUS, p_MSG_STATUS)

Line 93: ,SOURCE_ENTITY_TYPE_CODE = decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, SOURCE_ENTITY_TYPE_CODE, p_SOURCE_ENTITY_TYPE_CODE)

89: SET
90: MODULE_CODE = decode( p_MODULE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, MODULE_CODE, p_MODULE_CODE)
91: ,SOURCE_ENTITY_ID1 = decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID1, p_SOURCE_ENTITY_ID1)
92: ,SOURCE_ENTITY_ID2 = decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID2, p_SOURCE_ENTITY_ID2)
93: ,SOURCE_ENTITY_TYPE_CODE = decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, SOURCE_ENTITY_TYPE_CODE, p_SOURCE_ENTITY_TYPE_CODE)
94: ,MSG_TYPE_CODE = decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,NULL, MSG_TYPE_CODE, p_MSG_TYPE_CODE)
95: ,MSG = decode( p_MSG, FND_API.G_MISS_CHAR,NULL,NULL, MSG, p_MSG)
96: ,MSG_STATUS = decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL,NULL, MSG_STATUS, p_MSG_STATUS)
97: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM,NULL,NULL, CREATED_BY, p_CREATED_BY)

Line 94: ,MSG_TYPE_CODE = decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,NULL, MSG_TYPE_CODE, p_MSG_TYPE_CODE)

90: MODULE_CODE = decode( p_MODULE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, MODULE_CODE, p_MODULE_CODE)
91: ,SOURCE_ENTITY_ID1 = decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID1, p_SOURCE_ENTITY_ID1)
92: ,SOURCE_ENTITY_ID2 = decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID2, p_SOURCE_ENTITY_ID2)
93: ,SOURCE_ENTITY_TYPE_CODE = decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, SOURCE_ENTITY_TYPE_CODE, p_SOURCE_ENTITY_TYPE_CODE)
94: ,MSG_TYPE_CODE = decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,NULL, MSG_TYPE_CODE, p_MSG_TYPE_CODE)
95: ,MSG = decode( p_MSG, FND_API.G_MISS_CHAR,NULL,NULL, MSG, p_MSG)
96: ,MSG_STATUS = decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL,NULL, MSG_STATUS, p_MSG_STATUS)
97: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM,NULL,NULL, CREATED_BY, p_CREATED_BY)
98: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,NULL,NULL, CREATION_DATE, p_CREATION_DATE)

Line 95: ,MSG = decode( p_MSG, FND_API.G_MISS_CHAR,NULL,NULL, MSG, p_MSG)

91: ,SOURCE_ENTITY_ID1 = decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID1, p_SOURCE_ENTITY_ID1)
92: ,SOURCE_ENTITY_ID2 = decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID2, p_SOURCE_ENTITY_ID2)
93: ,SOURCE_ENTITY_TYPE_CODE = decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, SOURCE_ENTITY_TYPE_CODE, p_SOURCE_ENTITY_TYPE_CODE)
94: ,MSG_TYPE_CODE = decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,NULL, MSG_TYPE_CODE, p_MSG_TYPE_CODE)
95: ,MSG = decode( p_MSG, FND_API.G_MISS_CHAR,NULL,NULL, MSG, p_MSG)
96: ,MSG_STATUS = decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL,NULL, MSG_STATUS, p_MSG_STATUS)
97: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM,NULL,NULL, CREATED_BY, p_CREATED_BY)
98: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,NULL,NULL, CREATION_DATE, p_CREATION_DATE)
99: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

Line 96: ,MSG_STATUS = decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL,NULL, MSG_STATUS, p_MSG_STATUS)

92: ,SOURCE_ENTITY_ID2 = decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID2, p_SOURCE_ENTITY_ID2)
93: ,SOURCE_ENTITY_TYPE_CODE = decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, SOURCE_ENTITY_TYPE_CODE, p_SOURCE_ENTITY_TYPE_CODE)
94: ,MSG_TYPE_CODE = decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,NULL, MSG_TYPE_CODE, p_MSG_TYPE_CODE)
95: ,MSG = decode( p_MSG, FND_API.G_MISS_CHAR,NULL,NULL, MSG, p_MSG)
96: ,MSG_STATUS = decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL,NULL, MSG_STATUS, p_MSG_STATUS)
97: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM,NULL,NULL, CREATED_BY, p_CREATED_BY)
98: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,NULL,NULL, CREATION_DATE, p_CREATION_DATE)
99: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
100: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)

Line 97: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM,NULL,NULL, CREATED_BY, p_CREATED_BY)

93: ,SOURCE_ENTITY_TYPE_CODE = decode( p_SOURCE_ENTITY_TYPE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, SOURCE_ENTITY_TYPE_CODE, p_SOURCE_ENTITY_TYPE_CODE)
94: ,MSG_TYPE_CODE = decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,NULL, MSG_TYPE_CODE, p_MSG_TYPE_CODE)
95: ,MSG = decode( p_MSG, FND_API.G_MISS_CHAR,NULL,NULL, MSG, p_MSG)
96: ,MSG_STATUS = decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL,NULL, MSG_STATUS, p_MSG_STATUS)
97: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM,NULL,NULL, CREATED_BY, p_CREATED_BY)
98: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,NULL,NULL, CREATION_DATE, p_CREATION_DATE)
99: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
100: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
101: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

Line 98: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,NULL,NULL, CREATION_DATE, p_CREATION_DATE)

94: ,MSG_TYPE_CODE = decode( p_MSG_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,NULL, MSG_TYPE_CODE, p_MSG_TYPE_CODE)
95: ,MSG = decode( p_MSG, FND_API.G_MISS_CHAR,NULL,NULL, MSG, p_MSG)
96: ,MSG_STATUS = decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL,NULL, MSG_STATUS, p_MSG_STATUS)
97: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM,NULL,NULL, CREATED_BY, p_CREATED_BY)
98: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,NULL,NULL, CREATION_DATE, p_CREATION_DATE)
99: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
100: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
101: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
102: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,NULL,NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

Line 99: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

95: ,MSG = decode( p_MSG, FND_API.G_MISS_CHAR,NULL,NULL, MSG, p_MSG)
96: ,MSG_STATUS = decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL,NULL, MSG_STATUS, p_MSG_STATUS)
97: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM,NULL,NULL, CREATED_BY, p_CREATED_BY)
98: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,NULL,NULL, CREATION_DATE, p_CREATION_DATE)
99: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
100: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
101: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
102: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,NULL,NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
103: where GENERIC_ERRMSGS_ID = p_GENERIC_ERRMSGS_ID;

Line 100: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)

96: ,MSG_STATUS = decode( p_MSG_STATUS, FND_API.G_MISS_CHAR, NULL,NULL, MSG_STATUS, p_MSG_STATUS)
97: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM,NULL,NULL, CREATED_BY, p_CREATED_BY)
98: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,NULL,NULL, CREATION_DATE, p_CREATION_DATE)
99: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
100: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
101: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
102: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,NULL,NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
103: where GENERIC_ERRMSGS_ID = p_GENERIC_ERRMSGS_ID;
104:

Line 101: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

97: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM,NULL,NULL, CREATED_BY, p_CREATED_BY)
98: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,NULL,NULL, CREATION_DATE, p_CREATION_DATE)
99: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
100: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
101: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
102: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,NULL,NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
103: where GENERIC_ERRMSGS_ID = p_GENERIC_ERRMSGS_ID;
104:
105: If (SQL%NOTFOUND) then

Line 102: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,NULL,NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

98: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,NULL,NULL, CREATION_DATE, p_CREATION_DATE)
99: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
100: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
101: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
102: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,NULL,NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
103: where GENERIC_ERRMSGS_ID = p_GENERIC_ERRMSGS_ID;
104:
105: If (SQL%NOTFOUND) then
106: RAISE NO_DATA_FOUND;