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

Line 78: fnd_msg_pub.initialize;

74:
75: -- Initialize message list
76: IF fnd_api.to_boolean( p_init_msg_list )
77: THEN
78: fnd_msg_pub.initialize;
79: END IF;
80:
81: -- Initialize return status to SUCCESS
82: x_return_status := fnd_api.g_ret_sts_success;

Line 135: fnd_msg_pub.count_and_get( p_encoded => 'F'

131: THEN
132: COMMIT WORK;
133: END IF;
134:
135: fnd_msg_pub.count_and_get( p_encoded => 'F'
136: , p_count => x_msg_count
137: , p_data => x_msg_data
138: );
139: EXCEPTION

Line 144: fnd_msg_pub.count_and_get( p_encoded => 'F'

140: WHEN fnd_api.g_exc_error
141: THEN
142: ROLLBACK TO create_note_pub;
143: x_return_status := fnd_api.g_ret_sts_error;
144: fnd_msg_pub.count_and_get( p_encoded => 'F'
145: , p_count => x_msg_count
146: , p_data => x_msg_data
147: );
148:

Line 153: fnd_msg_pub.count_and_get( p_encoded => 'F'

149: WHEN fnd_api.g_exc_unexpected_error
150: THEN
151: ROLLBACK TO create_note_pub;
152: x_return_status := fnd_api.g_ret_sts_unexp_error;
153: fnd_msg_pub.count_and_get( p_encoded => 'F'
154: , p_count => x_msg_count
155: , p_data => x_msg_data
156: );
157:

Line 162: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

158: WHEN OTHERS
159: THEN
160: ROLLBACK TO create_note_pub;
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
163: THEN
164: fnd_msg_pub.add_exc_msg( g_pkg_name
165: , l_api_name
166: );

Line 164: fnd_msg_pub.add_exc_msg( g_pkg_name

160: ROLLBACK TO create_note_pub;
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
163: THEN
164: fnd_msg_pub.add_exc_msg( g_pkg_name
165: , l_api_name
166: );
167: END IF;
168: fnd_msg_pub.count_and_get( p_encoded => 'F'

Line 168: fnd_msg_pub.count_and_get( p_encoded => 'F'

164: fnd_msg_pub.add_exc_msg( g_pkg_name
165: , l_api_name
166: );
167: END IF;
168: fnd_msg_pub.count_and_get( p_encoded => 'F'
169: , p_count => x_msg_count
170: , p_data => x_msg_data
171: );
172: END Create_note;

Line 227: fnd_msg_pub.initialize;

223: -- Initialize message list if p_init_msg_list is set to TRUE
224: --
225: IF fnd_api.to_boolean(p_init_msg_list)
226: THEN
227: fnd_msg_pub.initialize;
228: END IF;
229:
230: --
231: -- Initialize API return status to success

Line 265: fnd_msg_pub.count_and_get( p_encoded => 'F'

261: COMMIT WORK;
262: END IF;
263:
264: -- Standard call to get message count and if count is 1, get message info
265: fnd_msg_pub.count_and_get( p_encoded => 'F'
266: , p_count => x_msg_count
267: , p_data => x_msg_data
268: );
269:

Line 277: fnd_msg_pub.count_and_get( p_encoded => 'F'

273: ROLLBACK TO update_note_pub;
274:
275: x_return_status := fnd_api.g_ret_sts_error;
276:
277: fnd_msg_pub.count_and_get( p_encoded => 'F'
278: , p_count => x_msg_count
279: , p_data => x_msg_data
280: );
281: WHEN fnd_api.g_exc_unexpected_error

Line 287: fnd_msg_pub.count_and_get( p_encoded => 'F'

283: ROLLBACK TO update_note_pub;
284:
285: x_return_status := fnd_api.g_ret_sts_unexp_error;
286:
287: fnd_msg_pub.count_and_get( p_encoded => 'F'
288: , p_count => x_msg_count
289: , p_data => x_msg_data
290: );
291: WHEN OTHERS

Line 297: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

293: ROLLBACK TO update_note_pub;
294:
295: x_return_status := fnd_api.g_ret_sts_unexp_error;
296:
297: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
298: THEN
299: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
300: END IF;
301:

Line 299: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

295: x_return_status := fnd_api.g_ret_sts_unexp_error;
296:
297: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
298: THEN
299: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
300: END IF;
301:
302: fnd_msg_pub.count_and_get( p_encoded => 'F'
303: , p_count => x_msg_count

Line 302: fnd_msg_pub.count_and_get( p_encoded => 'F'

298: THEN
299: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
300: END IF;
301:
302: fnd_msg_pub.count_and_get( p_encoded => 'F'
303: , p_count => x_msg_count
304: , p_data => x_msg_data
305: );
306: END Update_note;

Line 659: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

655: , p_token_p IN VARCHAR2
656: )
657: IS
658: BEGIN
659: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
660: THEN
661: fnd_message.set_name('JTF', 'JTF_API_ALL_INVALID_ARGUMENT');
662: fnd_message.set_token('API_NAME', p_token_an);
663: fnd_message.set_token('VALUE', p_token_v);

Line 665: fnd_msg_pub.add;

661: fnd_message.set_name('JTF', 'JTF_API_ALL_INVALID_ARGUMENT');
662: fnd_message.set_token('API_NAME', p_token_an);
663: fnd_message.set_token('VALUE', p_token_v);
664: fnd_message.set_token('PARAMETER', p_token_p);
665: fnd_msg_pub.add;
666: END IF;
667: END Add_Invalid_Argument_Msg;
668:
669:

Line 679: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

675: , p_token_np IN VARCHAR2
676: )
677: IS
678: BEGIN
679: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
680: THEN
681: fnd_message.set_name('JTF', 'JTF_API_ALL_NULL_PARAMETER');
682: fnd_message.set_token('API_NAME', p_token_an);
683: fnd_message.set_token('NULL_PARAM', p_token_np);

Line 684: fnd_msg_pub.add;

680: THEN
681: fnd_message.set_name('JTF', 'JTF_API_ALL_NULL_PARAMETER');
682: fnd_message.set_token('API_NAME', p_token_an);
683: fnd_message.set_token('NULL_PARAM', p_token_np);
684: fnd_msg_pub.add;
685: END IF;
686: END Add_Null_Parameter_Msg;
687:
688: PROCEDURE Trunc_String_length

Line 705: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success)

701: BEGIN
702: l_len := LENGTHB(p_str);
703: IF (l_len > p_len)
704: THEN
705: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success)
706: THEN
707: fnd_message.set_name('JTF', 'JTF_API_ALL_VALUE_TRUNCATED');
708: fnd_message.set_token('API_NAME', p_api_name);
709: fnd_message.set_token('TRUNCATED_PARAM', p_parameter_name);

Line 712: fnd_msg_pub.add;

708: fnd_message.set_token('API_NAME', p_api_name);
709: fnd_message.set_token('TRUNCATED_PARAM', p_parameter_name);
710: fnd_message.set_token('VAL_LEN', l_len);
711: fnd_message.set_token('DB_LEN', p_len);
712: fnd_msg_pub.add;
713: END IF;
714: x_str := substrb(p_str, 1, p_len);
715: ELSE
716: x_str := p_str;

Line 731: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

727: , p_token_mp IN VARCHAR2
728: )
729: IS
730: BEGIN
731: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
732: THEN
733: fnd_message.set_name('JTF', 'JTF_API_ALL_MISSING_PARAM');
734: fnd_message.set_token('API_NAME', p_token_an);
735: fnd_message.set_token('MISSING_PARAM', p_token_mp);

Line 736: fnd_msg_pub.add;

732: THEN
733: fnd_message.set_name('JTF', 'JTF_API_ALL_MISSING_PARAM');
734: fnd_message.set_token('API_NAME', p_token_an);
735: fnd_message.set_token('MISSING_PARAM', p_token_mp);
736: fnd_msg_pub.add;
737: END IF;
738: END Add_MIssing_Param_Msg;
739:
740: PROCEDURE Validate_object

Line 925: fnd_msg_pub.ADD;

921: fnd_message.set_name('JTF', 'JTF_API_ALL_INVALID_ARGUMENT');
922: fnd_message.set_token('API_NAME', 'JTF_NOTES_PUB.CREATE_NOTE');
923: fnd_message.set_token('PARAMETER', 'p_entered_by');
924: fnd_message.set_token('VALUE', p_entered_by);
925: fnd_msg_pub.ADD;
926: x_return_status := fnd_api.g_ret_sts_unexp_error;
927:
928: IF (c_entered_by%ISOPEN)
929: THEN

Line 1022: FND_MSG_PUB.Initialize;

1018: -- Initialize message list if p_init_msg_list is set to TRUE
1019: --
1020: IF FND_API.To_Boolean(p_init_msg_list)
1021: THEN
1022: FND_MSG_PUB.Initialize;
1023: END IF;
1024:
1025: --
1026: -- Initialize API return status to success

Line 1057: FND_MSG_PUB.ADD;

1053: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1054: THEN
1055: FND_MESSAGE.SET_NAME('JTF', 'JTF_UNABLE_TO_CHECK_FUNCTION'); -- Unable to verify whether Security &FUNCTION function was granted
1056: FND_MESSAGE.SET_TOKEN('FUNCTION', 'JTF_NOTE_DELETE');
1057: FND_MSG_PUB.ADD;
1058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1059: END IF;
1060:
1061: --

Line 1068: FND_MSG_PUB.ADD;

1064: IF (l_note_delete = 0)
1065: THEN
1066: FND_MESSAGE.SET_NAME('JTF', 'JTF_FUNCTION_NOT_GRANTED'); -- Security &FUNCTION function was not granted
1067: FND_MESSAGE.SET_TOKEN('FUNCTION', 'JTF_NOTE_DELETE');
1068: FND_MSG_PUB.ADD;
1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1070: END IF;
1071: END IF; -- end of Security validations
1072:

Line 1105: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1101:
1102: --
1103: -- Standard call to get message count and if count is 1, get message info
1104: --
1105: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1106: , p_data => x_msg_data
1107: );
1108:
1109: EXCEPTION

Line 1126: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

1122:
1123: --
1124: -- Push message onto CRM stack
1125: --
1126: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1127: , l_api_name
1128: , l_msg_data
1129: );
1130: --

Line 1133: x_msg_count := FND_MSG_PUB.COUNT_MSG;

1129: );
1130: --
1131: -- Count the messages on the CRM stack
1132: --
1133: x_msg_count := FND_MSG_PUB.COUNT_MSG;
1134:
1135: WHEN OTHERS
1136: THEN
1137: ROLLBACK TO delete_note_pub;

Line 1146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

1142:
1143: --
1144: -- Push message onto CRM stack
1145: --
1146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1147: , l_api_name
1148: , SQLERRM
1149: );
1150: --

Line 1153: x_msg_count := FND_MSG_PUB.COUNT_MSG;

1149: );
1150: --
1151: -- Count the messages on the CRM stack
1152: --
1153: x_msg_count := FND_MSG_PUB.COUNT_MSG;
1154:
1155: END Secure_Delete_Note;
1156:
1157:

Line 1280: fnd_msg_pub.initialize;

1276:
1277: -- Initialize message list
1278: IF fnd_api.to_boolean( p_init_msg_list )
1279: THEN
1280: fnd_msg_pub.initialize;
1281: END IF;
1282:
1283: -- Initialize return status to SUCCESS
1284: x_return_status := fnd_api.g_ret_sts_success;

Line 1343: FND_MSG_PUB.Add;

1339:
1340: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1341: THEN
1342: FND_MESSAGE.Set_Name('JTF', 'JTF_API_ERR_PRE_CUST_USR_HK');
1343: FND_MSG_PUB.Add;
1344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1345: END IF;
1346: END IF;
1347:

Line 1402: FND_MSG_PUB.Add;

1398:
1399: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1400: THEN
1401: FND_MESSAGE.Set_Name('JTF', 'JTF_API_ERR_PRE_VERT_USR_HK');
1402: FND_MSG_PUB.Add;
1403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1404: END IF;
1405: END IF;
1406:

Line 1602: FND_MSG_PUB.ADD;

1598: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1599: THEN
1600: FND_MESSAGE.SET_NAME('JTF', 'JTF_UNABLE_TO_CHECK_FUNCTION'); -- Unable to verify whether Security &FUNCTION function was granted
1601: FND_MESSAGE.SET_TOKEN('FUNCTION', 'JTF_NOTE_CREATE');
1602: FND_MSG_PUB.ADD;
1603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1604: END IF;
1605:
1606: --

Line 1613: FND_MSG_PUB.ADD;

1609: IF (l_grant_select = 0)
1610: THEN
1611: FND_MESSAGE.SET_NAME('JTF', 'JTF_FUNCTION_NOT_GRANTED'); -- Security &FUNCTION function was not granted
1612: FND_MESSAGE.SET_TOKEN('FUNCTION', 'JTF_NOTE_CREATE');
1613: FND_MSG_PUB.ADD;
1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1615: END IF;
1616:
1617: --

Line 1637: FND_MSG_PUB.ADD;

1633: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1634: THEN
1635: FND_MESSAGE.SET_NAME('JTF', 'JTF_UNABLE_TO_CHECK_FUNCTION'); -- Unable to verify whether Security &FUNCTION function was granted
1636: FND_MESSAGE.SET_TOKEN('FUNCTION', 'JTF_NOTE_CREATE');
1637: FND_MSG_PUB.ADD;
1638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1639: END IF;
1640:
1641: --

Line 1648: FND_MSG_PUB.ADD;

1644: IF (l_grant_select = 0)
1645: THEN
1646: FND_MESSAGE.SET_NAME('JTF', 'JTF_FUNCTION_NOT_GRANTED'); -- Security &FUNCTION function was not granted
1647: FND_MESSAGE.SET_TOKEN('FUNCTION', 'JTF_NOTE_TYPE_CREATE');
1648: FND_MSG_PUB.ADD;
1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1650: END IF;
1651:
1652: END IF; -- Security validations

Line 1794: FND_MSG_PUB.Add;

1790:
1791: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1792: THEN
1793: FND_MESSAGE.Set_Name('JTF', 'JTF_API_ERR_POST_CUST_USR_HK');
1794: FND_MSG_PUB.Add;
1795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1796: END IF;
1797: END IF;
1798:

Line 1854: FND_MSG_PUB.Add;

1850: );
1851:
1852: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1853: FND_MESSAGE.Set_Name('JTF', 'JTF_ERR_POST_VERT_USR_HK');
1854: FND_MSG_PUB.Add;
1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1856: END IF;
1857: END IF;
1858:

Line 1915: fnd_msg_pub.count_and_get( p_encoded => 'F'

1911: THEN
1912: COMMIT WORK;
1913: END IF;
1914:
1915: fnd_msg_pub.count_and_get( p_encoded => 'F'
1916: , p_count => x_msg_count
1917: , p_data => x_msg_data
1918: );
1919:

Line 1934: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

1930: THEN
1931: -- A required parameter is missing
1932: ROLLBACK TO create_note_pvt;
1933: x_return_status := fnd_api.g_ret_sts_unexp_error;
1934: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1935: THEN
1936: fnd_message.set_name('JTF', 'JTF_API_ALL_MISSING_PARAM');
1937: fnd_message.set_token('API_NAME', g_pkg_name||'.'||l_api_name);
1938: fnd_message.set_token('MISSING_PARAM', l_missing_param);

Line 1939: fnd_msg_pub.ADD;

1935: THEN
1936: fnd_message.set_name('JTF', 'JTF_API_ALL_MISSING_PARAM');
1937: fnd_message.set_token('API_NAME', g_pkg_name||'.'||l_api_name);
1938: fnd_message.set_token('MISSING_PARAM', l_missing_param);
1939: fnd_msg_pub.ADD;
1940: END IF;
1941:
1942: fnd_msg_pub.count_and_get( p_encoded => 'F' -- Not encoding so HTML can use the message
1943: , p_count => x_msg_count

Line 1942: fnd_msg_pub.count_and_get( p_encoded => 'F' -- Not encoding so HTML can use the message

1938: fnd_message.set_token('MISSING_PARAM', l_missing_param);
1939: fnd_msg_pub.ADD;
1940: END IF;
1941:
1942: fnd_msg_pub.count_and_get( p_encoded => 'F' -- Not encoding so HTML can use the message
1943: , p_count => x_msg_count
1944: , p_data => x_msg_data
1945: );
1946:

Line 1952: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

1948: THEN
1949: -- A required field is NULL
1950: ROLLBACK TO create_note_pvt;
1951: x_return_status := fnd_api.g_ret_sts_unexp_error;
1952: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1953: THEN
1954: fnd_message.set_name('JTF', 'JTF_API_ALL_NULL_PARAMETER');
1955: fnd_message.set_token('API_NAME', g_pkg_name||'.'||l_api_name);
1956: fnd_message.set_token('NULL_PARAM', l_null_param);

Line 1957: fnd_msg_pub.ADD;

1953: THEN
1954: fnd_message.set_name('JTF', 'JTF_API_ALL_NULL_PARAMETER');
1955: fnd_message.set_token('API_NAME', g_pkg_name||'.'||l_api_name);
1956: fnd_message.set_token('NULL_PARAM', l_null_param);
1957: fnd_msg_pub.ADD;
1958: END IF;
1959: fnd_msg_pub.count_and_get( p_encoded => 'F'
1960: , p_count => x_msg_count
1961: , p_data => x_msg_data

Line 1959: fnd_msg_pub.count_and_get( p_encoded => 'F'

1955: fnd_message.set_token('API_NAME', g_pkg_name||'.'||l_api_name);
1956: fnd_message.set_token('NULL_PARAM', l_null_param);
1957: fnd_msg_pub.ADD;
1958: END IF;
1959: fnd_msg_pub.count_and_get( p_encoded => 'F'
1960: , p_count => x_msg_count
1961: , p_data => x_msg_data
1962: );
1963:

Line 1968: fnd_msg_pub.count_and_get( p_encoded => 'F'

1964: WHEN fnd_api.g_exc_error
1965: THEN
1966: ROLLBACK TO create_note_pvt;
1967: x_return_status := fnd_api.g_ret_sts_error;
1968: fnd_msg_pub.count_and_get( p_encoded => 'F'
1969: , p_count => x_msg_count
1970: , p_data => x_msg_data
1971: );
1972:

Line 1977: fnd_msg_pub.count_and_get( p_encoded => 'F'

1973: WHEN fnd_api.g_exc_unexpected_error
1974: THEN
1975: ROLLBACK TO create_note_pvt;
1976: x_return_status := fnd_api.g_ret_sts_unexp_error;
1977: fnd_msg_pub.count_and_get( p_encoded => 'F'
1978: , p_count => x_msg_count
1979: , p_data => x_msg_data
1980: );
1981:

Line 1986: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

1982: WHEN OTHERS
1983: THEN
1984: ROLLBACK TO create_note_pvt;
1985: x_return_status := fnd_api.g_ret_sts_unexp_error;
1986: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1987: THEN
1988: fnd_msg_pub.add_exc_msg( g_pkg_name
1989: , l_api_name
1990: );

Line 1988: fnd_msg_pub.add_exc_msg( g_pkg_name

1984: ROLLBACK TO create_note_pvt;
1985: x_return_status := fnd_api.g_ret_sts_unexp_error;
1986: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1987: THEN
1988: fnd_msg_pub.add_exc_msg( g_pkg_name
1989: , l_api_name
1990: );
1991: END IF;
1992: fnd_msg_pub.count_and_get( p_encoded => 'F'

Line 1992: fnd_msg_pub.count_and_get( p_encoded => 'F'

1988: fnd_msg_pub.add_exc_msg( g_pkg_name
1989: , l_api_name
1990: );
1991: END IF;
1992: fnd_msg_pub.count_and_get( p_encoded => 'F'
1993: , p_count => x_msg_count
1994: , p_data => x_msg_data
1995: );
1996: END Secure_Create_note;

Line 2125: fnd_msg_pub.initialize;

2121: -- Initialize message list if p_init_msg_list is set to TRUE
2122: --
2123: IF fnd_api.to_boolean(p_init_msg_list)
2124: THEN
2125: fnd_msg_pub.initialize;
2126: END IF;
2127:
2128: --
2129: -- Initialize API return status to success

Line 2361: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success)

2357: , 1
2358: , (32766 - l_old_clob_length)
2359: );-- 32367
2360:
2361: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success)
2362: THEN
2363: fnd_message.set_name('JTF', 'JTF_API_ALL_VALUE_TRUNCATED');
2364: fnd_message.set_token('API_NAME', l_api_name);
2365: fnd_message.set_token('TRUNCATED_PARAM', 'p_notes_detail');

Line 2368: fnd_msg_pub.add;

2364: fnd_message.set_token('API_NAME', l_api_name);
2365: fnd_message.set_token('TRUNCATED_PARAM', 'p_notes_detail');
2366: fnd_message.set_token('VAL_LEN', l_total_clob_length);
2367: fnd_message.set_token('DB_LEN', 32767);
2368: fnd_msg_pub.add;
2369: END IF;
2370:
2371: IF l_notes_detail_truncated IS NOT NULL
2372: THEN

Line 2408: FND_MSG_PUB.Add;

2404:
2405: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2406: THEN
2407: FND_MESSAGE.Set_Name('JTF', 'JTF_API_ERR_PRE_CUST_USR_HK');
2408: FND_MSG_PUB.Add;
2409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2410: END IF;
2411: END IF;
2412:

Line 2437: FND_MSG_PUB.Add;

2433:
2434: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2435: THEN
2436: FND_MESSAGE.Set_Name('JTF', 'JTF_API_ERR_PRE_CUST_USR_HK');
2437: FND_MSG_PUB.Add;
2438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2439: END IF;
2440: END IF;
2441:

Line 2511: FND_MSG_PUB.ADD;

2507: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2508: THEN
2509: FND_MESSAGE.SET_NAME('JTF', 'JTF_UNABLE_TO_CHECK_FUNCTION'); -- Unable to verify whether Security &FUNCTION function was granted
2510: FND_MESSAGE.SET_TOKEN('FUNCTION', 'JTF_NOTE_UPDATE_NOTE');
2511: FND_MSG_PUB.ADD;
2512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2513: END IF;
2514:
2515: --

Line 2522: FND_MSG_PUB.ADD;

2518: IF (l_note_update_primary = 0)
2519: THEN
2520: FND_MESSAGE.SET_NAME('JTF', 'JTF_FUNCTION_NOT_GRANTED'); -- Security &FUNCTION function was not granted
2521: FND_MESSAGE.SET_TOKEN('FUNCTION', 'JTF_NOTE_UPDATE_NOTE');
2522: FND_MSG_PUB.ADD;
2523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2524: END IF;
2525: END IF;
2526:

Line 2554: FND_MSG_PUB.ADD;

2550: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2551: THEN
2552: FND_MESSAGE.SET_NAME('JTF', 'JTF_UNABLE_TO_CHECK_FUNCTION'); -- Unable to verify whether Security &FUNCTION function was granted
2553: FND_MESSAGE.SET_TOKEN('FUNCTION', 'JTF_NOTE_UPDATE_NOTE_DETAILS');
2554: FND_MSG_PUB.ADD;
2555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2556: END IF;
2557:
2558: --

Line 2565: FND_MSG_PUB.ADD;

2561: IF (l_note_update_primary = 0)
2562: THEN
2563: FND_MESSAGE.SET_NAME('JTF', 'JTF_FUNCTION_NOT_GRANTED'); -- Security &FUNCTION function was not granted
2564: FND_MESSAGE.SET_TOKEN('FUNCTION', 'JTF_NOTE_UPDATE_NOTE_DETAILS');
2565: FND_MSG_PUB.ADD;
2566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2567: END IF;
2568: END IF;
2569:

Line 2600: FND_MSG_PUB.ADD;

2596: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2597: THEN
2598: FND_MESSAGE.SET_NAME('JTF', 'JTF_UNABLE_TO_CHECK_FUNCTION'); -- Unable to verify whether Security &FUNCTION function was granted
2599: FND_MESSAGE.SET_TOKEN('FUNCTION', 'JTF_NOTE_UPDATE');
2600: FND_MSG_PUB.ADD;
2601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2602: END IF;
2603:
2604: --

Line 2611: FND_MSG_PUB.ADD;

2607: IF (l_note_update_secondary = 0)
2608: THEN
2609: FND_MESSAGE.SET_NAME('JTF', 'JTF_FUNCTION_NOT_GRANTED'); -- Security &FUNCTION function was not granted
2610: FND_MESSAGE.SET_TOKEN('FUNCTION', 'JTF_NOTE_UPDATE_PRIMARY');
2611: FND_MSG_PUB.ADD;
2612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2613: ELSE
2614: --
2615: -- Function was granted now we'll verify whether user is allowed to create notes of the given type

Line 2634: FND_MSG_PUB.ADD;

2630: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2631: THEN
2632: FND_MESSAGE.SET_NAME('JTF', 'JTF_UNABLE_TO_CHECK_FUNCTION'); -- Unable to verify whether Security &FUNCTION function was granted
2633: FND_MESSAGE.SET_TOKEN('FUNCTION', 'JTF_NOTE_UPDATE');
2634: FND_MSG_PUB.ADD;
2635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2636: END IF;
2637:
2638: --

Line 2645: FND_MSG_PUB.ADD;

2641: IF (l_note_select_type = 0)
2642: THEN
2643: FND_MESSAGE.SET_NAME('JTF', 'JTF_FUNCTION_NOT_GRANTED'); -- Security &FUNCTION function was not granted
2644: FND_MESSAGE.SET_TOKEN('FUNCTION', 'JTF_NOTE_TYPE_UPDATE');
2645: FND_MSG_PUB.ADD;
2646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2647: END IF;
2648: END IF;
2649: END IF;

Line 2773: FND_MSG_PUB.Add;

2769:
2770: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2771: THEN
2772: FND_MESSAGE.Set_Name('JTF', 'JTF_API_ERR_POST_CUST_USR_HK');
2773: FND_MSG_PUB.Add;
2774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2775: END IF;
2776: END IF;
2777:

Line 2802: FND_MSG_PUB.Add;

2798:
2799: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2800: THEN
2801: FND_MESSAGE.Set_Name('JTF', 'JTF_API_ERR_POST_VERT_USR_HK');
2802: FND_MSG_PUB.Add;
2803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2804: END IF;
2805: END IF;
2806:

Line 2865: fnd_msg_pub.count_and_get( p_encoded => 'F'

2861: END IF;
2862:
2863:
2864: -- Standard call to get message count and if count is 1, get message info
2865: fnd_msg_pub.count_and_get( p_encoded => 'F'
2866: , p_count => x_msg_count
2867: , p_data => x_msg_data
2868: );
2869:

Line 2896: fnd_msg_pub.add;

2892: /**********************************************************
2893: ** Set the error
2894: **********************************************************/
2895: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');
2896: fnd_msg_pub.add;
2897: fnd_msg_pub.count_and_get( p_encoded => 'F'
2898: , p_count => x_msg_count
2899: , p_data => x_msg_data
2900: );

Line 2897: fnd_msg_pub.count_and_get( p_encoded => 'F'

2893: ** Set the error
2894: **********************************************************/
2895: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');
2896: fnd_msg_pub.add;
2897: fnd_msg_pub.count_and_get( p_encoded => 'F'
2898: , p_count => x_msg_count
2899: , p_data => x_msg_data
2900: );
2901:

Line 2917: fnd_msg_pub.count_and_get( p_encoded => 'F'

2913: END IF;
2914:
2915: x_return_status := fnd_api.g_ret_sts_error;
2916:
2917: fnd_msg_pub.count_and_get( p_encoded => 'F'
2918: , p_count => x_msg_count
2919: , p_data => x_msg_data
2920: );
2921: WHEN fnd_api.g_exc_unexpected_error

Line 2936: fnd_msg_pub.count_and_get( p_encoded => 'F'

2932: END IF;
2933:
2934: x_return_status := fnd_api.g_ret_sts_unexp_error;
2935:
2936: fnd_msg_pub.count_and_get( p_encoded => 'F'
2937: , p_count => x_msg_count
2938: , p_data => x_msg_data
2939: );
2940: WHEN OTHERS

Line 2955: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

2951: END IF;
2952:
2953: x_return_status := fnd_api.g_ret_sts_unexp_error;
2954:
2955: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2956: THEN
2957: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2958: END IF;
2959:

Line 2957: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2953: x_return_status := fnd_api.g_ret_sts_unexp_error;
2954:
2955: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2956: THEN
2957: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2958: END IF;
2959:
2960: fnd_msg_pub.count_and_get( p_encoded => 'F'
2961: , p_count => x_msg_count

Line 2960: fnd_msg_pub.count_and_get( p_encoded => 'F'

2956: THEN
2957: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2958: END IF;
2959:
2960: fnd_msg_pub.count_and_get( p_encoded => 'F'
2961: , p_count => x_msg_count
2962: , p_data => x_msg_data
2963: );
2964: END Secure_Update_note;