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_API

Line 57: x_return_status := fnd_api.g_ret_sts_success;

53: )
54: IS
55: l_dummy VARCHAR2(1);
56: BEGIN
57: x_return_status := fnd_api.g_ret_sts_success;
58:
59: SELECT 'x' INTO l_dummy
60: FROM fnd_lookup_values
61: WHERE lookup_code = p_note_type

Line 71: x_return_status := fnd_api.g_ret_sts_error;

67: THEN
68: NULL;
69: WHEN NO_DATA_FOUND
70: THEN
71: x_return_status := fnd_api.g_ret_sts_error;
72: add_invalid_argument_msg( p_api_name
73: , p_note_type
74: , p_parameter_name
75: );

Line 78: x_return_status := fnd_api.g_ret_sts_error;

74: , p_parameter_name
75: );
76: WHEN OTHERS
77: THEN
78: x_return_status := fnd_api.g_ret_sts_error;
79: add_invalid_argument_msg( p_api_name
80: , p_note_type
81: , p_parameter_name
82: );

Line 138: x_return_status := fnd_api.g_ret_sts_success;

134:
135:
136: IF (l_result > 0)
137: THEN
138: x_return_status := fnd_api.g_ret_sts_success;
139: ELSE
140: add_invalid_argument_msg( p_api_name
141: , p_object_type_code
142: , 'Object Code'

Line 149: x_return_status := fnd_api.g_ret_sts_error;

145: add_invalid_argument_msg( p_api_name
146: , p_object_type_id
147: , 'Object Id'
148: );
149: x_return_status := fnd_api.g_ret_sts_error;
150: END IF;
151:
152: EXCEPTION
153: WHEN OTHERS

Line 159: x_return_status := fnd_api.g_ret_sts_error;

155: IF (cur_object%ISOPEN)
156: THEN
157: CLOSE cur_object;
158: END IF;
159: x_return_status := fnd_api.g_ret_sts_error;
160: add_invalid_argument_msg( p_api_name
161: , p_object_type_code
162: , 'Object Code'
163: );

Line 278: x_return_status := fnd_api.g_ret_sts_success;

274: SAVEPOINT create_note_pvt;
275:
276:
277: -- Initialize return status to SUCCESS
278: x_return_status := fnd_api.g_ret_sts_success;
279:
280: --
281: -- Make the preprocessing call to the user hooks
282: --

Line 326: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

322: , p_note_type => p_note_type
323: , x_return_status => l_return_status
324: );
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;

Line 330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
334: -- Pre call to the Vertical Type User Hook

Line 377: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

373: , p_note_type => p_note_type
374: , x_return_status => l_return_status
375: );
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;

Line 381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
385: -- Validate source object id and code against object_type_code

Line 393: IF (l_return_status <> fnd_api.g_ret_sts_success)

389: , p_object_type_id => p_source_object_id
390: , x_return_status => l_return_status
391: );
392:
393: IF (l_return_status <> fnd_api.g_ret_sts_success)
394: THEN
395: add_invalid_argument_msg( l_api_name_full
396: , p_source_object_id
397: , 'p_source_object_id'

Line 399: RAISE fnd_api.g_exc_error;

395: add_invalid_argument_msg( l_api_name_full
396: , p_source_object_id
397: , 'p_source_object_id'
398: );
399: RAISE fnd_api.g_exc_error;
400: END IF;
401:
402: -- Validate note status
403: IF (p_note_status <> fnd_api.g_miss_char)

Line 403: IF (p_note_status <> fnd_api.g_miss_char)

399: RAISE fnd_api.g_exc_error;
400: END IF;
401:
402: -- Validate note status
403: IF (p_note_status <> fnd_api.g_miss_char)
404: THEN
405: IF (p_note_status NOT IN ('P', 'I','E'))
406: THEN
407: add_invalid_argument_msg( l_api_name_full

Line 411: RAISE fnd_api.g_exc_error;

407: add_invalid_argument_msg( l_api_name_full
408: , p_note_status
409: , 'p_note_status'
410: );
411: RAISE fnd_api.g_exc_error;
412: END IF;
413: END IF;
414:
415: -- Validate note length

Line 435: IF (l_return_status <> fnd_api.g_ret_sts_success)

431: , p_parameter_name => 'p_note_type'
432: , p_note_type => p_note_type
433: , x_return_status => l_return_status
434: );
435: IF (l_return_status <> fnd_api.g_ret_sts_success)
436: THEN
437: -- Message added in Validate_note_type
438: RAISE fnd_api.g_exc_error;
439: END IF;

Line 438: RAISE fnd_api.g_exc_error;

434: );
435: IF (l_return_status <> fnd_api.g_ret_sts_success)
436: THEN
437: -- Message added in Validate_note_type
438: RAISE fnd_api.g_exc_error;
439: END IF;
440:
441: END IF;
442:

Line 616: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

612: , x_return_status => l_return_status
613: , p_jtf_note_id => l_jtf_note_id
614: );
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;

Line 620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
624:

Line 669: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

665: , x_return_status => l_return_status
666: , p_jtf_note_id => l_jtf_note_id
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;

Line 672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
676: -- Standard call for message generation

Line 712: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

708: , p_action_code => 'I'
709: , p_bind_data_id => l_bind_data_id
710: , x_return_code => l_return_status
711: );
712: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
713: THEN
714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715: END IF;
716: END IF;

Line 714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

710: , x_return_code => l_return_status
711: );
712: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
713: THEN
714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715: END IF;
716: END IF;
717: END IF;
718:

Line 735: WHEN fnd_api.g_exc_error

731:
732: EXCEPTION
733:
734:
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'

Line 738: x_return_status := fnd_api.g_ret_sts_error;

734:
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: );

Line 744: WHEN fnd_api.g_exc_unexpected_error

740: , p_count => x_msg_count
741: , p_data => x_msg_data
742: );
743:
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'

Line 747: x_return_status := fnd_api.g_ret_sts_unexp_error;

743:
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: );

Line 760: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
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

Line 830: x_return_status := fnd_api.g_ret_sts_success;

826: SAVEPOINT update_note_pvt;
827:
828:
829: -- Initialize return status to SUCCESS
830: x_return_status := fnd_api.g_ret_sts_success;
831:
832: --
833: -- Customer User Hook pre update
834: --

Line 854: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

850: , p_note_type => p_note_type
851: , x_return_status => l_return_status
852: );
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;

Line 858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
862: IF jtf_usr_hks.ok_to_execute( 'JTF_NOTES_PUB'

Line 881: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

877: , p_note_type => p_note_type
878: , x_return_status => l_return_status
879: );
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;

Line 885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
889: IF (l_note_status = FND_API.G_MISS_CHAR)

Line 889: IF (l_note_status = FND_API.G_MISS_CHAR)

885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
886: END IF;
887: END IF;
888:
889: IF (l_note_status = FND_API.G_MISS_CHAR)
890: THEN
891: l_note_status := NULL;
892: END IF;
893:

Line 894: IF (l_note_type = FND_API.G_MISS_CHAR)

890: THEN
891: l_note_status := NULL;
892: END IF;
893:
894: IF (l_note_type = FND_API.G_MISS_CHAR)
895: THEN
896: l_note_type := NULL;
897: END IF;
898:

Line 977: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

973: , p_note_type => l_note_type
974: , x_return_status => l_return_status
975: );
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;

Line 981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
985: IF jtf_usr_hks.ok_to_execute( 'JTF_NOTES_PUB'

Line 1004: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1000: , p_note_type => l_note_type
1001: , x_return_status => l_return_status
1002: );
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;

Line 1008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
1012: -- Standard call for message generation

Line 1046: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1042: , p_action_code => 'I'
1043: , p_bind_data_id => l_bind_data_id
1044: , x_return_code => l_return_status
1045: );
1046: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1047: THEN
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: END IF;
1050: END IF;

Line 1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1044: , x_return_code => l_return_status
1045: );
1046: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1047: THEN
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: END IF;
1050: END IF;
1051: END IF;
1052:

Line 1077: WHEN fnd_api.g_exc_error

1073:
1074: EXCEPTION
1075:
1076:
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'

Line 1080: x_return_status := fnd_api.g_ret_sts_error;

1076:
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: );

Line 1086: WHEN fnd_api.g_exc_unexpected_error

1082: , p_count => x_msg_count
1083: , p_data => x_msg_data
1084: );
1085:
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'

Line 1089: x_return_status := fnd_api.g_ret_sts_unexp_error;

1085:
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: );

Line 1102: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
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

Line 1138: x_return_status := FND_API.G_RET_STS_SUCCESS;

1134:
1135: --
1136: -- Initialize API return status to success
1137: --
1138: x_return_status := FND_API.G_RET_STS_SUCCESS;
1139:
1140: --
1141: -- get the source onject information so we can pas it to the WF event
1142: --

Line 1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1174: ROLLBACK TO delete_note_pvt;
1175: --
1176: -- Set status
1177: --
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1179:
1180: --
1181: -- Push message onto CRM stack
1182: --

Line 1241: x_return_status := fnd_api.g_ret_sts_success;

1237: -- API savepoint
1238: SAVEPOINT create_note_context_pvt;
1239:
1240: -- Initialize return status to SUCCESS
1241: x_return_status := fnd_api.g_ret_sts_success;
1242:
1243: -- Validate source object id and code
1244: Validate_object( p_api_name => l_api_name_full
1245: , p_object_type_code => p_note_context_type

Line 1250: IF (x_return_status <> fnd_api.g_ret_sts_success)

1246: , p_object_type_id => p_note_context_type_id
1247: , x_return_status => x_return_status
1248: );
1249:
1250: IF (x_return_status <> fnd_api.g_ret_sts_success)
1251: THEN
1252: RAISE fnd_api.g_exc_error;
1253: END IF;
1254:

Line 1252: RAISE fnd_api.g_exc_error;

1248: );
1249:
1250: IF (x_return_status <> fnd_api.g_ret_sts_success)
1251: THEN
1252: RAISE fnd_api.g_exc_error;
1253: END IF;
1254:
1255: -- we should only do the insert if the relation doesn't already exist
1256: OPEN c_duplicate( p_jtf_note_id

Line 1306: WHEN fnd_api.g_exc_error

1302: );
1303:
1304: EXCEPTION
1305:
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'

Line 1309: x_return_status := fnd_api.g_ret_sts_error;

1305:
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: );

Line 1315: WHEN fnd_api.g_exc_unexpected_error

1311: , p_count => x_msg_count
1312: , p_data => x_msg_data
1313: );
1314:
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'

Line 1318: x_return_status := fnd_api.g_ret_sts_unexp_error;

1314:
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: );

Line 1331: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
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

Line 1373: x_return_status := fnd_api.g_ret_sts_success;

1369: -- API savepoint
1370: SAVEPOINT update_note_context_pvt;
1371:
1372: -- Initialize return status to SUCCESS
1373: x_return_status := fnd_api.g_ret_sts_success;
1374:
1375: -- Validate source object id and code
1376: Validate_object( p_api_name => l_api_name_full
1377: , p_object_type_code => p_note_context_type

Line 1382: IF (x_return_status <> fnd_api.g_ret_sts_success)

1378: , p_object_type_id => p_note_context_type_id
1379: , x_return_status => x_return_status
1380: );
1381:
1382: IF (x_return_status <> fnd_api.g_ret_sts_success)
1383: THEN
1384: RAISE fnd_api.g_exc_error;
1385: END IF;
1386:

Line 1384: RAISE fnd_api.g_exc_error;

1380: );
1381:
1382: IF (x_return_status <> fnd_api.g_ret_sts_success)
1383: THEN
1384: RAISE fnd_api.g_exc_error;
1385: END IF;
1386:
1387: UPDATE JTF_NOTE_CONTEXTS
1388: SET

Line 1404: WHEN fnd_api.g_exc_error

1400: );
1401:
1402: EXCEPTION
1403:
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'

Line 1407: x_return_status := fnd_api.g_ret_sts_error;

1403:
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: );

Line 1413: WHEN fnd_api.g_exc_unexpected_error

1409: , p_count => x_msg_count
1410: , p_data => x_msg_data
1411: );
1412:
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'

Line 1416: x_return_status := fnd_api.g_ret_sts_unexp_error;

1412:
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: );

Line 1429: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
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

Line 1464: x_return_status := fnd_api.g_ret_sts_success;

1460: -- API savepoint
1461: SAVEPOINT delete_note_context_pvt;
1462:
1463: -- Initialize return status to SUCCESS
1464: x_return_status := fnd_api.g_ret_sts_success;
1465:
1466: DELETE FROM JTF_NOTE_CONTEXTS
1467: WHERE NOTE_CONTEXT_ID = p_note_context_id;
1468:

Line 1483: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
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