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

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

12: , p_token_p IN VARCHAR2
13: )
14: IS
15: BEGIN
16: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
17: THEN
18: fnd_message.set_name('JTF', 'JTF_API_ALL_INVALID_ARGUMENT');
19: fnd_message.set_token('API_NAME', p_token_an);
20: fnd_message.set_token('VALUE', p_token_v);

Line 22: fnd_msg_pub.add;

18: fnd_message.set_name('JTF', 'JTF_API_ALL_INVALID_ARGUMENT');
19: fnd_message.set_token('API_NAME', p_token_an);
20: fnd_message.set_token('VALUE', p_token_v);
21: fnd_message.set_token('PARAMETER', p_token_p);
22: fnd_msg_pub.add;
23: END IF;
24: END Add_Invalid_Argument_Msg;
25:
26:

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

32: , p_token_np IN VARCHAR2
33: )
34: IS
35: BEGIN
36: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
37: THEN
38: fnd_message.set_name('JTF', 'JTF_API_ALL_NULL_PARAMETER');
39: fnd_message.set_token('API_NAME', p_token_an);
40: fnd_message.set_token('NULL_PARAM', p_token_np);

Line 41: fnd_msg_pub.add;

37: THEN
38: fnd_message.set_name('JTF', 'JTF_API_ALL_NULL_PARAMETER');
39: fnd_message.set_token('API_NAME', p_token_an);
40: fnd_message.set_token('NULL_PARAM', p_token_np);
41: fnd_msg_pub.add;
42: END IF;
43: END Add_Null_Parameter_Msg;
44:
45: PROCEDURE Validate_note_type

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

185: BEGIN
186: l_len := LENGTHB(p_str);
187: IF (l_len > p_len)
188: THEN
189: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success)
190: THEN
191: fnd_message.set_name('JTF', 'JTF_API_ALL_VALUE_TRUNCATED');
192: fnd_message.set_token('API_NAME', p_api_name);
193: fnd_message.set_token('TRUNCATED_PARAM', p_parameter_name);

Line 196: fnd_msg_pub.add;

192: fnd_message.set_token('API_NAME', p_api_name);
193: fnd_message.set_token('TRUNCATED_PARAM', p_parameter_name);
194: fnd_message.set_token('VAL_LEN', l_len);
195: fnd_message.set_token('DB_LEN', p_len);
196: fnd_msg_pub.add;
197: END IF;
198: x_str := substrb(p_str, 1, p_len);
199: ELSE
200: x_str := p_str;

Line 329: FND_MSG_PUB.Add;

325:
326: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
327: THEN
328: FND_MESSAGE.Set_Name('JTF', 'JTF_API_ERR_PRE_CUST_USR_HK');
329: FND_MSG_PUB.Add;
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: END IF;
332: END IF;
333:

Line 380: FND_MSG_PUB.Add;

376:
377: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
378: THEN
379: FND_MESSAGE.Set_Name('JTF', 'JTF_API_ERR_PRE_VERT_USR_HK');
380: FND_MSG_PUB.Add;
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383: END IF;
384:

Line 619: FND_MSG_PUB.Add;

615:
616: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
617: THEN
618: FND_MESSAGE.Set_Name('JTF', 'JTF_API_ERR_POST_CUST_USR_HK');
619: FND_MSG_PUB.Add;
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
621: END IF;
622: END IF;
623:

Line 671: FND_MSG_PUB.Add;

667: );
668:
669: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
670: FND_MESSAGE.Set_Name('JTF', 'JTF_ERR_POST_VERT_USR_HK');
671: FND_MSG_PUB.Add;
672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
673: END IF;
674: END IF;
675:

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

721: , p_SourceObjectCode => p_source_object_code
722: , p_SourceObjectID => p_source_object_id
723: );
724:
725: fnd_msg_pub.count_and_get( p_encoded => 'F'
726: , p_count => x_msg_count
727: , p_data => x_msg_data
728: );
729:

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

735: WHEN fnd_api.g_exc_error
736: THEN
737: ROLLBACK TO create_note_pvt;
738: x_return_status := fnd_api.g_ret_sts_error;
739: fnd_msg_pub.count_and_get( p_encoded => 'F'
740: , p_count => x_msg_count
741: , p_data => x_msg_data
742: );
743:

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

744: WHEN fnd_api.g_exc_unexpected_error
745: THEN
746: ROLLBACK TO create_note_pvt;
747: x_return_status := fnd_api.g_ret_sts_unexp_error;
748: fnd_msg_pub.count_and_get( p_encoded => 'F'
749: , p_count => x_msg_count
750: , p_data => x_msg_data
751: );
752:

Line 756: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

752:
753: WHEN OTHERS
754: THEN
755: ROLLBACK TO create_note_pvt;
756: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
757: , l_api_name
758: , l_debug
759: );
760: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

757: , l_api_name
758: , l_debug
759: );
760: x_return_status := fnd_api.g_ret_sts_unexp_error;
761: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
762: THEN
763: fnd_msg_pub.add_exc_msg( g_pkg_name
764: , l_api_name
765: );

Line 763: fnd_msg_pub.add_exc_msg( g_pkg_name

759: );
760: x_return_status := fnd_api.g_ret_sts_unexp_error;
761: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
762: THEN
763: fnd_msg_pub.add_exc_msg( g_pkg_name
764: , l_api_name
765: );
766: END IF;
767: fnd_msg_pub.count_and_get( p_encoded => 'F'

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

763: fnd_msg_pub.add_exc_msg( g_pkg_name
764: , l_api_name
765: );
766: END IF;
767: fnd_msg_pub.count_and_get( p_encoded => 'F'
768: , p_count => x_msg_count
769: , p_data => x_msg_data
770: );
771:

Line 857: FND_MSG_PUB.Add;

853:
854: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
855: THEN
856: FND_MESSAGE.Set_Name('JTF', 'JTF_API_ERR_PRE_CUST_USR_HK');
857: FND_MSG_PUB.Add;
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: END IF;
860: END IF;
861:

Line 884: FND_MSG_PUB.Add;

880:
881: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
882: THEN
883: FND_MESSAGE.Set_Name('JTF', 'JTF_API_ERR_PRE_CUST_USR_HK');
884: FND_MSG_PUB.Add;
885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
886: END IF;
887: END IF;
888:

Line 980: FND_MSG_PUB.Add;

976:
977: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
978: THEN
979: FND_MESSAGE.Set_Name('JTF', 'JTF_API_ERR_POST_CUST_USR_HK');
980: FND_MSG_PUB.Add;
981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
982: END IF;
983: END IF;
984:

Line 1007: FND_MSG_PUB.Add;

1003:
1004: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1005: THEN
1006: FND_MESSAGE.Set_Name('JTF', 'JTF_API_ERR_POST_VERT_USR_HK');
1007: FND_MSG_PUB.Add;
1008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1009: END IF;
1010: END IF;
1011:

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

1065: , p_SourceObjectCode => l_source_object_code
1066: , p_SourceObjectID => l_source_object_id
1067: );
1068:
1069: fnd_msg_pub.count_and_get( p_encoded => 'F'
1070: , p_count => x_msg_count
1071: , p_data => x_msg_data
1072: );
1073:

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

1077: WHEN fnd_api.g_exc_error
1078: THEN
1079: ROLLBACK TO update_note_pvt;
1080: x_return_status := fnd_api.g_ret_sts_error;
1081: fnd_msg_pub.count_and_get( p_encoded => 'F'
1082: , p_count => x_msg_count
1083: , p_data => x_msg_data
1084: );
1085:

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

1086: WHEN fnd_api.g_exc_unexpected_error
1087: THEN
1088: ROLLBACK TO update_note_pvt;
1089: x_return_status := fnd_api.g_ret_sts_unexp_error;
1090: fnd_msg_pub.count_and_get( p_encoded => 'F'
1091: , p_count => x_msg_count
1092: , p_data => x_msg_data
1093: );
1094:

Line 1098: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

1094:
1095: WHEN OTHERS
1096: THEN
1097: ROLLBACK TO update_note_pvt;
1098: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1099: , l_api_name
1100: , l_debug
1101: );
1102: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1099: , l_api_name
1100: , l_debug
1101: );
1102: x_return_status := fnd_api.g_ret_sts_unexp_error;
1103: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1104: THEN
1105: fnd_msg_pub.add_exc_msg( g_pkg_name
1106: , l_api_name
1107: );

Line 1105: fnd_msg_pub.add_exc_msg( g_pkg_name

1101: );
1102: x_return_status := fnd_api.g_ret_sts_unexp_error;
1103: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1104: THEN
1105: fnd_msg_pub.add_exc_msg( g_pkg_name
1106: , l_api_name
1107: );
1108: END IF;
1109: fnd_msg_pub.count_and_get( p_encoded => 'F'

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

1105: fnd_msg_pub.add_exc_msg( g_pkg_name
1106: , l_api_name
1107: );
1108: END IF;
1109: fnd_msg_pub.count_and_get( p_encoded => 'F'
1110: , p_count => x_msg_count
1111: , p_data => x_msg_data
1112: );
1113: END update_note;

Line 1167: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1163:
1164: --
1165: -- Standard call to get message count and if count is 1, get message info
1166: --
1167: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1168: , p_data => x_msg_data
1169: );
1170:
1171: EXCEPTION

Line 1183: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

1179:
1180: --
1181: -- Push message onto CRM stack
1182: --
1183: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1184: , l_api_name
1185: , SQLERRM
1186: );
1187: --

Line 1195: x_msg_count := FND_MSG_PUB.COUNT_MSG;

1191:
1192: --
1193: -- Count the messages on the CRM stack
1194: --
1195: x_msg_count := FND_MSG_PUB.COUNT_MSG;
1196:
1197: END delete_note;
1198:
1199: PROCEDURE create_note_context

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

1295: END IF;
1296:
1297: CLOSE c_duplicate;
1298:
1299: fnd_msg_pub.count_and_get( p_encoded => 'F'
1300: , p_count => x_msg_count
1301: , p_data => x_msg_data
1302: );
1303:

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

1306: WHEN fnd_api.g_exc_error
1307: THEN
1308: ROLLBACK TO create_note_context_pvt;
1309: x_return_status := fnd_api.g_ret_sts_error;
1310: fnd_msg_pub.count_and_get( p_encoded => 'F'
1311: , p_count => x_msg_count
1312: , p_data => x_msg_data
1313: );
1314:

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

1315: WHEN fnd_api.g_exc_unexpected_error
1316: THEN
1317: ROLLBACK TO create_note_context_pvt;
1318: x_return_status := fnd_api.g_ret_sts_unexp_error;
1319: fnd_msg_pub.count_and_get( p_encoded => 'F'
1320: , p_count => x_msg_count
1321: , p_data => x_msg_data
1322: );
1323:

Line 1327: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

1323:
1324: WHEN OTHERS
1325: THEN
1326: ROLLBACK TO create_note_context_pvt;
1327: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1328: , l_api_name
1329: , l_debug
1330: );
1331: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1328: , l_api_name
1329: , l_debug
1330: );
1331: x_return_status := fnd_api.g_ret_sts_unexp_error;
1332: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1333: THEN
1334: fnd_msg_pub.add_exc_msg( g_pkg_name
1335: , l_api_name
1336: );

Line 1334: fnd_msg_pub.add_exc_msg( g_pkg_name

1330: );
1331: x_return_status := fnd_api.g_ret_sts_unexp_error;
1332: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1333: THEN
1334: fnd_msg_pub.add_exc_msg( g_pkg_name
1335: , l_api_name
1336: );
1337: END IF;
1338: fnd_msg_pub.count_and_get( p_encoded => 'F'

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

1334: fnd_msg_pub.add_exc_msg( g_pkg_name
1335: , l_api_name
1336: );
1337: END IF;
1338: fnd_msg_pub.count_and_get( p_encoded => 'F'
1339: , p_count => x_msg_count
1340: , p_data => x_msg_data
1341: );
1342:

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

1393: LAST_UPDATED_BY = NVL(p_last_updated_by,fnd_global.user_id),
1394: LAST_UPDATE_LOGIN = NVL(p_last_update_login,fnd_global.login_id)
1395: WHERE NOTE_CONTEXT_ID = p_note_context_id;
1396:
1397: fnd_msg_pub.count_and_get( p_encoded => 'F'
1398: , p_count => x_msg_count
1399: , p_data => x_msg_data
1400: );
1401:

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

1404: WHEN fnd_api.g_exc_error
1405: THEN
1406: ROLLBACK TO update_note_context_pvt;
1407: x_return_status := fnd_api.g_ret_sts_error;
1408: fnd_msg_pub.count_and_get( p_encoded => 'F'
1409: , p_count => x_msg_count
1410: , p_data => x_msg_data
1411: );
1412:

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

1413: WHEN fnd_api.g_exc_unexpected_error
1414: THEN
1415: ROLLBACK TO update_note_context_pvt;
1416: x_return_status := fnd_api.g_ret_sts_unexp_error;
1417: fnd_msg_pub.count_and_get( p_encoded => 'F'
1418: , p_count => x_msg_count
1419: , p_data => x_msg_data
1420: );
1421:

Line 1425: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

1421:
1422: WHEN OTHERS
1423: THEN
1424: ROLLBACK TO update_note_context_pvt;
1425: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1426: , l_api_name
1427: , l_debug
1428: );
1429: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1426: , l_api_name
1427: , l_debug
1428: );
1429: x_return_status := fnd_api.g_ret_sts_unexp_error;
1430: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1431: THEN
1432: fnd_msg_pub.add_exc_msg( g_pkg_name
1433: , l_api_name
1434: );

Line 1432: fnd_msg_pub.add_exc_msg( g_pkg_name

1428: );
1429: x_return_status := fnd_api.g_ret_sts_unexp_error;
1430: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1431: THEN
1432: fnd_msg_pub.add_exc_msg( g_pkg_name
1433: , l_api_name
1434: );
1435: END IF;
1436: fnd_msg_pub.count_and_get( p_encoded => 'F'

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

1432: fnd_msg_pub.add_exc_msg( g_pkg_name
1433: , l_api_name
1434: );
1435: END IF;
1436: fnd_msg_pub.count_and_get( p_encoded => 'F'
1437: , p_count => x_msg_count
1438: , p_data => x_msg_data
1439: );
1440:

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

1465:
1466: DELETE FROM JTF_NOTE_CONTEXTS
1467: WHERE NOTE_CONTEXT_ID = p_note_context_id;
1468:
1469: fnd_msg_pub.count_and_get( p_encoded => 'F'
1470: , p_count => x_msg_count
1471: , p_data => x_msg_data
1472: );
1473:

Line 1479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

1475:
1476: WHEN OTHERS
1477: THEN
1478: ROLLBACK TO delete_note_context_pvt;
1479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1480: , l_api_name
1481: , l_debug
1482: );
1483: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1480: , l_api_name
1481: , l_debug
1482: );
1483: x_return_status := fnd_api.g_ret_sts_unexp_error;
1484: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1485: THEN
1486: fnd_msg_pub.add_exc_msg( g_pkg_name
1487: , l_api_name
1488: );

Line 1486: fnd_msg_pub.add_exc_msg( g_pkg_name

1482: );
1483: x_return_status := fnd_api.g_ret_sts_unexp_error;
1484: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1485: THEN
1486: fnd_msg_pub.add_exc_msg( g_pkg_name
1487: , l_api_name
1488: );
1489: END IF;
1490: fnd_msg_pub.count_and_get( p_encoded => 'F'

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

1486: fnd_msg_pub.add_exc_msg( g_pkg_name
1487: , l_api_name
1488: );
1489: END IF;
1490: fnd_msg_pub.count_and_get( p_encoded => 'F'
1491: , p_count => x_msg_count
1492: , p_data => x_msg_data
1493: );
1494: