[Home] [Help]
61: -- API savepoint
62: SAVEPOINT create_note_pub;
63:
64: -- Check version number
65: IF NOT fnd_api.compatible_api_call
66: ( l_api_version
67: , p_api_version
68: , l_api_name
69: , g_pkg_name
68: , l_api_name
69: , g_pkg_name
70: )
71: THEN
72: RAISE fnd_api.g_exc_unexpected_error;
73: END IF;
74:
75: -- Initialize message list
76: IF fnd_api.to_boolean( p_init_msg_list )
72: RAISE fnd_api.g_exc_unexpected_error;
73: END IF;
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:
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;
83:
84:
85: -- Call the new Note API
86: Secure_Create_note( p_parent_note_id => p_parent_note_id
86: Secure_Create_note( p_parent_note_id => p_parent_note_id
87: , p_jtf_note_id => p_jtf_note_id
88: , p_api_version => p_api_version
89: , p_init_msg_list => p_init_msg_list
90: , p_commit => fnd_api.g_false
91: , p_validation_level => p_validation_level
92: , x_return_status => x_return_status
93: , x_msg_count => x_msg_count
94: , x_msg_data => x_msg_data
126: , p_jtf_note_contexts_tab => p_jtf_note_contexts_tab
127: , p_use_AOL_security => 'F'
128: );
129:
130: IF fnd_api.to_boolean(p_commit)
131: THEN
132: COMMIT WORK;
133: END IF;
134:
136: , p_count => x_msg_count
137: , p_data => x_msg_data
138: );
139: EXCEPTION
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'
139: EXCEPTION
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: );
145: , p_count => x_msg_count
146: , p_data => x_msg_data
147: );
148:
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'
148:
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:
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
210:
211: --
212: -- Standard call to check for call compatibility
213: --
214: IF NOT fnd_api.compatible_api_call( l_api_version
215: , p_api_version
216: , l_api_name, g_pkg_name
217: )
218: THEN
215: , p_api_version
216: , l_api_name, g_pkg_name
217: )
218: THEN
219: RAISE fnd_api.g_exc_unexpected_error;
220: END IF;
221:
222: --
223: -- Initialize message list if p_init_msg_list is set to TRUE
221:
222: --
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:
229:
230: --
231: -- Initialize API return status to success
232: --
233: x_return_status := fnd_api.g_ret_sts_success;
234:
235:
236: -- Call the new API
237: Secure_Update_note( p_api_version => p_api_version
235:
236: -- Call the new API
237: Secure_Update_note( p_api_version => p_api_version
238: , p_init_msg_list => p_init_msg_list
239: , p_commit => fnd_api.g_false
240: , p_validation_level => p_validation_level
241: , x_return_status => x_return_status
242: , x_msg_count => x_msg_count
243: , x_msg_data => x_msg_data
255: , p_use_AOL_security => 'F'
256: );
257:
258: -- Standard check of p_commit
259: IF fnd_api.to_boolean(p_commit)
260: THEN
261: COMMIT WORK;
262: END IF;
263:
267: , p_data => x_msg_data
268: );
269:
270: EXCEPTION
271: WHEN fnd_api.g_exc_error
272: THEN
273: ROLLBACK TO update_note_pub;
274:
275: x_return_status := fnd_api.g_ret_sts_error;
271: WHEN fnd_api.g_exc_error
272: THEN
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
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
282: THEN
283: ROLLBACK TO update_note_pub;
284:
285: x_return_status := fnd_api.g_ret_sts_unexp_error;
281: WHEN fnd_api.g_exc_unexpected_error
282: THEN
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
291: WHEN OTHERS
292: THEN
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);
317: )
318: IS
319: l_dummy VARCHAR2(1);
320: BEGIN
321: x_return_status := fnd_api.g_ret_sts_success;
322:
323: SELECT 'x' INTO l_dummy
324: FROM fnd_lookup_values
325: WHERE lookup_code = p_note_type
331: THEN
332: NULL;
333: WHEN NO_DATA_FOUND
334: THEN
335: x_return_status := fnd_api.g_ret_sts_error;
336: add_invalid_argument_msg( p_api_name
337: , p_note_type
338: , p_parameter_name
339: );
338: , p_parameter_name
339: );
340: WHEN OTHERS
341: THEN
342: x_return_status := fnd_api.g_ret_sts_error;
343: add_invalid_argument_msg( p_api_name
344: , p_note_type
345: , p_parameter_name
346: );
397:
398: BEGIN
399:
400: -- Initialize return status to SUCCESS
401: x_return_status := fnd_api.g_ret_sts_success;
402:
403: -- Defaulting
404: IF p_last_update_date = fnd_api.g_miss_date
405: THEN
400: -- Initialize return status to SUCCESS
401: x_return_status := fnd_api.g_ret_sts_success;
402:
403: -- Defaulting
404: IF p_last_update_date = fnd_api.g_miss_date
405: THEN
406: l_last_update_date := (SYSDATE);
407: ELSE
408: l_last_update_date := p_last_update_date;
407: ELSE
408: l_last_update_date := p_last_update_date;
409: END IF;
410:
411: IF p_creation_date = fnd_api.g_miss_date
412: THEN
413: l_creation_date := (SYSDATE);
414: ELSE
415: l_creation_date := p_creation_date;
415: l_creation_date := p_creation_date;
416: END IF;
417:
418: -- Validation
419: IF (p_validation_level > fnd_api.g_valid_level_none)
420: THEN
421: --Validate note_context_id based on the note_context_type
422: IF ( p_note_context_type IS NULL
423: AND p_note_context_type_id IS NOT NULL
426: ( p_note_context_type_id IS NULL
427: AND p_note_context_type IS NOT NULL
428: )
429: THEN
430: RAISE fnd_api.g_exc_error;
431: END IF;
432:
433: -- Validate source object id and code
434: Validate_object( p_api_name => l_api_name_full
436: , p_object_type_id => p_note_context_type_id
437: , x_return_status => l_return_status
438: );
439:
440: IF (l_return_status <> fnd_api.g_ret_sts_success)
441: THEN
442: RAISE fnd_api.g_exc_error;
443: END IF;
444: END IF;
438: );
439:
440: IF (l_return_status <> fnd_api.g_ret_sts_success)
441: THEN
442: RAISE fnd_api.g_exc_error;
443: END IF;
444: END IF;
445:
446: -- we should only do the insert if the relation doesn't already exist
534: -- Procedure : Update_note_context
535: --
536: -- Updates a context record in the JTF_NOTE_CONTEXTS table
537: ------------------------------------------------------------------------------
538: ( p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
539: , x_return_status OUT NOCOPY VARCHAR2
540: , p_note_context_id IN NUMBER
541: , p_jtf_note_id IN NUMBER
542: , p_note_context_type_id IN NUMBER
577: THEN
578: CLOSE lrec_note_context;
579: END IF;
580:
581: RAISE fnd_api.g_exc_error;
582:
583: END IF;
584:
585: --
603: ELSE
604: l_note_context_type_id := p_note_context_type_id;
605: END IF;
606:
607: IF (p_validation_level > fnd_api.g_valid_level_none)
608: THEN
609: -- Validate source object id and code
610: Validate_object( p_api_name => l_api_name_full
611: , p_object_type_code => p_note_context_type
611: , p_object_type_code => p_note_context_type
612: , p_object_type_id => p_note_context_type_id
613: , x_return_status => l_return_status
614: );
615: IF (l_return_status <> fnd_api.g_ret_sts_success)
616: THEN
617: RAISE fnd_api.g_exc_error;
618: END IF;
619: END IF;
613: , x_return_status => l_return_status
614: );
615: IF (l_return_status <> fnd_api.g_ret_sts_success)
616: THEN
617: RAISE fnd_api.g_exc_error;
618: END IF;
619: END IF;
620:
621: --
641: THEN
642: CLOSE lrec_note_context;
643: END IF;
644:
645: RAISE fnd_api.g_exc_unexpected_error;
646:
647: END Update_note_Context;
648:
649: PROCEDURE Add_Invalid_Argument_Msg
787:
788:
789: IF (l_result > 0)
790: THEN
791: x_return_status := fnd_api.g_ret_sts_success;
792: ELSE
793: add_invalid_argument_msg( p_api_name
794: , p_object_type_code
795: , 'Object Code'
798: add_invalid_argument_msg( p_api_name
799: , p_object_type_id
800: , 'Object Id'
801: );
802: x_return_status := fnd_api.g_ret_sts_error;
803: END IF;
804:
805: EXCEPTION
806: WHEN OTHERS
808: IF (cur_object%ISOPEN)
809: THEN
810: CLOSE cur_object;
811: END IF;
812: x_return_status := fnd_api.g_ret_sts_error;
813: add_invalid_argument_msg( p_api_name
814: , p_object_type_code
815: , 'Object Code'
816: );
908: AND NVL (end_date, SYSDATE) >= SYSDATE
909: AND NVL (start_date, SYSDATE) <= SYSDATE;
910:
911: BEGIN
912: x_return_status := fnd_api.g_ret_sts_success;
913:
914: IF p_entered_by IS NOT NULL
915: THEN
916: OPEN c_entered_by;
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
930: CLOSE c_entered_by;
929: THEN
930: CLOSE c_entered_by;
931: END IF;
932:
933: RAISE fnd_api.g_exc_unexpected_error;
934: END IF;
935:
936: IF (c_entered_by%ISOPEN)
937: THEN
945: THEN
946: CLOSE c_entered_by;
947: END IF;
948:
949: RAISE fnd_api.g_exc_unexpected_error;
950:
951: END validate_entered_by;
952:
953: PROCEDURE Secure_Delete_note
960: -- and JTF_NOTE_CONTEXTS
961: -- Pre-reqs : None
962: -- Parameters :
963: -- p_api_version IN NUMBER Required
964: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
965: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
966: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
967: -- x_return_status OUT VARCHAR2 Required
968: -- x_msg_count OUT NUMBER Required
961: -- Pre-reqs : None
962: -- Parameters :
963: -- p_api_version IN NUMBER Required
964: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
965: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
966: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
967: -- x_return_status OUT VARCHAR2 Required
968: -- x_msg_count OUT NUMBER Required
969: -- x_msg_data OUT VARCHAR2 Required
962: -- Parameters :
963: -- p_api_version IN NUMBER Required
964: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
965: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
966: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
967: -- x_return_status OUT VARCHAR2 Required
968: -- x_msg_count OUT NUMBER Required
969: -- x_msg_data OUT VARCHAR2 Required
970: -- p_jtf_note_id IN NUMBER Required Primary key of the note record
967: -- x_return_status OUT VARCHAR2 Required
968: -- x_msg_count OUT NUMBER Required
969: -- x_msg_data OUT VARCHAR2 Required
970: -- p_jtf_note_id IN NUMBER Required Primary key of the note record
971: -- p_use_AOL_security IN VARCHAR2 Optional Default FND_API.G_TRUE
972: --
973: -- Version : Initial version 1.0
974: --
975: --
1004:
1005: --
1006: -- Standard call to check for call compatibility
1007: --
1008: IF NOT FND_API.Compatible_API_Call( l_api_version
1009: , p_api_version
1010: , l_api_name
1011: , G_PKG_NAME
1012: )
1010: , l_api_name
1011: , G_PKG_NAME
1012: )
1013: THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END IF;
1016:
1017: --
1018: -- Initialize message list if p_init_msg_list is set to TRUE
1016:
1017: --
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:
1024:
1025: --
1026: -- Initialize API return status to success
1027: --
1028: x_return_status := FND_API.G_RET_STS_SUCCESS;
1029:
1030: --
1031: -- Security validations
1032: --
1029:
1030: --
1031: -- Security validations
1032: --
1033: IF (p_use_AOL_security = fnd_api.g_true)
1034: THEN
1035: --
1036: -- Check if the user is allowed to delete this note
1037: --
1036: -- Check if the user is allowed to delete this note
1037: --
1038: JTF_NOTES_SECURITY_PVT.check_function
1039: ( p_api_version => 1.0
1040: , p_init_msg_list => FND_API.G_FALSE
1041: , p_function => JTF_NOTES_SECURITY_PVT.G_FUNCTION_DELETE
1042: , p_object_name => JTF_NOTES_SECURITY_PVT.G_OBJECT_NOTE
1043: , p_instance_pk1_value => p_jtf_note_id
1044: , x_grant => l_note_delete
1049:
1050: --
1051: -- If there's an error push it onto the stack
1052: --
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;
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: --
1062: -- If the create function was not granted throw an error
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:
1073: --
1093: , p_SourceObjectID => l_source_object_id
1094: );
1095:
1096: -- Standard check of p_commit
1097: IF fnd_api.to_boolean(p_commit)
1098: THEN
1099: COMMIT WORK;
1100: END IF;
1101:
1106: , p_data => x_msg_data
1107: );
1108:
1109: EXCEPTION
1110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1111: THEN
1112: ROLLBACK TO delete_note_pub;
1113: --
1114: -- Set status
1112: ROLLBACK TO delete_note_pub;
1113: --
1114: -- Set status
1115: --
1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1117:
1118: --
1119: -- Get error message from FND stack
1120: --
1137: ROLLBACK TO delete_note_pub;
1138: --
1139: -- Set status
1140: --
1141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1142:
1143: --
1144: -- Push message onto CRM stack
1145: --
1263: -- API savepoint
1264: SAVEPOINT create_note_pvt;
1265:
1266: -- Check version number
1267: IF NOT fnd_api.compatible_api_call
1268: ( l_api_version
1269: , p_api_version
1270: , l_api_name
1271: , g_pkg_name
1270: , l_api_name
1271: , g_pkg_name
1272: )
1273: THEN
1274: RAISE fnd_api.g_exc_unexpected_error;
1275: END IF;
1276:
1277: -- Initialize message list
1278: IF fnd_api.to_boolean( p_init_msg_list )
1274: RAISE fnd_api.g_exc_unexpected_error;
1275: END IF;
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:
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;
1285:
1286: --
1287: -- Make the preprocessing call to the user hooks
1288: --
1297: jtf_notes_cuhk.create_note_pre
1298: ( p_parent_note_id => p_parent_note_id
1299: , p_api_version => p_api_version
1300: , p_init_msg_list => p_init_msg_list
1301: , p_commit => FND_API.G_FALSE
1302: , p_validation_level => p_validation_level
1303: , x_msg_count => x_msg_count
1304: , x_msg_data => x_msg_data
1305: , p_org_id => p_org_id
1336: , p_jtf_note_contexts_tab => p_jtf_note_contexts_tab
1337: , x_return_status => l_return_status
1338: );
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;
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:
1348: -- Pre call to the Vertical Type User Hook
1356: jtf_notes_vuhk.create_note_pre
1357: ( p_parent_note_id => p_parent_note_id
1358: , p_api_version => p_api_version
1359: , p_init_msg_list => p_init_msg_list
1360: , p_commit => FND_API.G_FALSE
1361: , p_validation_level => p_validation_level
1362: , x_msg_count => l_msg_count
1363: , x_msg_data => l_msg_data
1364: , p_org_id => p_org_id
1395: , p_jtf_note_contexts_tab => p_jtf_note_contexts_tab
1396: , x_return_status => l_return_status
1397: );
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;
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:
1407:
1405: END IF;
1406:
1407:
1408: -- Item level validation
1409: IF (p_validation_level > fnd_api.g_valid_level_none)
1410: THEN
1411: --
1412: -- Check if the note id passed is unique
1413: --
1412: -- Check if the note id passed is unique
1413: --
1414: BEGIN
1415: IF ( (l_jtf_note_id IS NOT NULL)
1416: OR (l_jtf_note_id <> FND_API.G_MISS_NUM)
1417: )
1418: THEN
1419: SELECT jtf_note_id
1420: INTO l_jtf_note_id
1430: Add_Invalid_Argument_Msg( p_token_an => l_api_name_full
1431: , p_token_v => p_jtf_note_id
1432: , p_token_p => 'p_jtf_note_id'
1433: );
1434: RAISE FND_API.G_EXC_ERROR;
1435: END IF;
1436: END IF;
1437: EXCEPTION
1438: WHEN NO_DATA_FOUND
1442: THEN
1443: RAISE l_duplicate_note;
1444: WHEN OTHERS
1445: THEN
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1447: END;
1448:
1449: -- If mobile passes ID they should never clash with the sequence
1450: IF ( (l_jtf_note_id IS NOT NULL)
1447: END;
1448:
1449: -- If mobile passes ID they should never clash with the sequence
1450: IF ( (l_jtf_note_id IS NOT NULL)
1451: OR (l_jtf_note_id <> FND_API.G_MISS_NUM)
1452: )
1453: AND (p_validation_level <> 0.5) -- JSP pages will be able to override
1454: -- this check so we can avoid the refresh problem
1455: AND (NVL(FND_PROFILE.Value('APPS_MAINTENANCE_MODE'),'X') <> 'FUZZY')
1461: Add_Invalid_Argument_Msg( p_token_an => l_api_name_full
1462: , p_token_v => p_jtf_note_id
1463: , p_token_p => 'p_jtf_note_id'
1464: );
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF ;
1467: END IF;
1468:
1469: -- Validate source object id and code against object_type_code
1473: , p_object_type_id => p_source_object_id
1474: , x_return_status => l_return_status
1475: );
1476:
1477: IF (l_return_status <> fnd_api.g_ret_sts_success)
1478: THEN
1479: add_invalid_argument_msg( l_api_name_full
1480: , p_source_object_id
1481: , 'p_source_object_id'
1479: add_invalid_argument_msg( l_api_name_full
1480: , p_source_object_id
1481: , 'p_source_object_id'
1482: );
1483: RAISE fnd_api.g_exc_error;
1484: END IF;
1485:
1486: -- Validate note status
1487: IF (p_note_status <> fnd_api.g_miss_char)
1483: RAISE fnd_api.g_exc_error;
1484: END IF;
1485:
1486: -- Validate note status
1487: IF (p_note_status <> fnd_api.g_miss_char)
1488: THEN
1489: IF (p_note_status NOT IN ('P', 'I','E'))
1490: THEN
1491: add_invalid_argument_msg( l_api_name_full
1491: add_invalid_argument_msg( l_api_name_full
1492: , p_note_status
1493: , 'p_note_status'
1494: );
1495: RAISE fnd_api.g_exc_error;
1496: END IF;
1497: END IF;
1498:
1499: -- Validate note length
1515: , p_parameter_name => 'p_note_type'
1516: , p_note_type => p_note_type
1517: , x_return_status => l_return_status
1518: );
1519: IF (l_return_status <> fnd_api.g_ret_sts_success)
1520: THEN
1521: -- Message added in Validate_note_type
1522: RAISE fnd_api.g_exc_error;
1523: END IF;
1518: );
1519: IF (l_return_status <> fnd_api.g_ret_sts_success)
1520: THEN
1521: -- Message added in Validate_note_type
1522: RAISE fnd_api.g_exc_error;
1523: END IF;
1524:
1525: END IF;
1526:
1530: validate_entered_by( p_entered_by => l_entered_by
1531: , x_return_status => l_return_status
1532: , x_entered_by => l_entered_by
1533: );
1534: IF (l_return_status <> fnd_api.g_ret_sts_success)
1535: THEN
1536: RAISE fnd_api.g_exc_error;
1537: END IF;
1538: END IF;
1532: , x_entered_by => l_entered_by
1533: );
1534: IF (l_return_status <> fnd_api.g_ret_sts_success)
1535: THEN
1536: RAISE fnd_api.g_exc_error;
1537: END IF;
1538: END IF;
1539: END IF;
1540:
1538: END IF;
1539: END IF;
1540:
1541: -- Defaulting
1542: IF p_parent_note_id = fnd_api.g_miss_num
1543: THEN
1544: l_parent_note_id := NULL;
1545: ELSE
1546: l_parent_note_id := p_parent_note_id;
1544: l_parent_note_id := NULL;
1545: ELSE
1546: l_parent_note_id := p_parent_note_id;
1547: END IF;
1548: IF p_entered_date = fnd_api.g_miss_date
1549: THEN
1550: l_entered_date := (SYSDATE);
1551: ELSE
1552: l_entered_date := p_entered_date;
1551: ELSE
1552: l_entered_date := p_entered_date;
1553: END IF;
1554:
1555: IF p_last_update_date = fnd_api.g_miss_date
1556: THEN
1557: l_last_update_date := (SYSDATE);
1558: ELSE
1559: l_last_update_date := p_last_update_date;
1558: ELSE
1559: l_last_update_date := p_last_update_date;
1560: END IF;
1561:
1562: IF p_creation_date = fnd_api.g_miss_date
1563: THEN
1564: l_creation_date := (SYSDATE);
1565: ELSE
1566: l_creation_date := p_creation_date;
1575:
1576: --
1577: -- AOL Security validations
1578: --
1579: IF (p_use_AOL_security = fnd_api.g_true)
1580: THEN
1581: --
1582: -- Check if the user is allowed to create notes at all
1583: --
1582: -- Check if the user is allowed to create notes at all
1583: --
1584: JTF_NOTES_SECURITY_PVT.check_function
1585: ( p_api_version => 1.0
1586: , p_init_msg_list => FND_API.G_FALSE
1587: , p_function => JTF_NOTES_SECURITY_PVT.G_FUNCTION_CREATE
1588: , p_object_name => JTF_NOTES_SECURITY_PVT.G_OBJECT_NOTE
1589: , x_grant => l_grant_select
1590: , x_return_status => l_return_status
1594:
1595: --
1596: -- If there's an error push it onto the stack
1597: --
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;
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: --
1607: -- If the create function was not granted throw an error
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: --
1618: -- Function was granted now we'll verify whether user is allowed to create notes of the given type
1618: -- Function was granted now we'll verify whether user is allowed to create notes of the given type
1619: --
1620: JTF_NOTES_SECURITY_PVT.check_note_type
1621: ( p_api_version => 1.0
1622: , p_init_msg_list => FND_API.G_FALSE
1623: , p_note_type => p_note_type
1624: , x_return_status => l_return_status
1625: , x_grant => l_grant_select_type
1626: , x_msg_count => l_msg_count
1629:
1630: --
1631: -- If there's an error push it onto the stack
1632: --
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;
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: --
1642: -- user is not allowed to create notes of this type
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
1653:
1654: --
1655: -- Get jtf_note_id from sequence
1656: --
1657: IF ( (l_jtf_note_id IS NULL)
1658: OR (l_jtf_note_id = FND_API.G_MISS_NUM)
1659: )
1660: THEN
1661: OPEN l_jtf_note_id_csr;
1662: FETCH l_jtf_note_id_csr INTO l_jtf_note_id;
1725: , p_note_context_type_id => p_jtf_note_contexts_tab(i).note_context_type_id
1726: , p_note_context_type => p_jtf_note_contexts_tab(i).note_context_type
1727: , x_note_context_id => l_note_context_id
1728: );
1729: IF (l_return_status <> fnd_api.g_ret_sts_success)
1730: THEN
1731: RAISE fnd_api.g_exc_error;
1732: EXIT;
1733: END IF;
1727: , x_note_context_id => l_note_context_id
1728: );
1729: IF (l_return_status <> fnd_api.g_ret_sts_success)
1730: THEN
1731: RAISE fnd_api.g_exc_error;
1732: EXIT;
1733: END IF;
1734: END LOOP;
1735: END IF;
1747: jtf_notes_cuhk.create_note_post
1748: ( p_parent_note_id => l_parent_note_id
1749: , p_api_version => p_api_version
1750: , p_init_msg_list => p_init_msg_list
1751: , p_commit => FND_API.G_FALSE
1752: , p_validation_level => p_validation_level
1753: , x_msg_count => x_msg_count
1754: , x_msg_data => x_msg_data
1755: , p_org_id => p_org_id
1787: , x_return_status => l_return_status
1788: , p_jtf_note_id => l_jtf_note_id
1789: );
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;
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:
1799:
1808: jtf_notes_vuhk.create_note_post
1809: ( p_parent_note_id => l_parent_note_id
1810: , p_api_version => p_api_version
1811: , p_init_msg_list => p_init_msg_list
1812: , p_commit => FND_API.G_FALSE
1813: , p_validation_level => p_validation_level
1814: , x_msg_count => x_msg_count
1815: , x_msg_data => x_msg_data
1816: , p_org_id => p_org_id
1848: , x_return_status => l_return_status
1849: , p_jtf_note_id => l_jtf_note_id
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;
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:
1859: -- Standard call for message generation
1892: , p_action_code => 'I'
1893: , p_bind_data_id => l_bind_data_id
1894: , x_return_code => l_return_status
1895: );
1896: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1897: THEN
1898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1899: END IF;
1900: END IF;
1894: , x_return_code => l_return_status
1895: );
1896: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1897: THEN
1898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1899: END IF;
1900: END IF;
1901: END IF;
1902:
1906: , p_SourceObjectCode => p_source_object_code
1907: , p_SourceObjectID => p_source_object_id
1908: );
1909:
1910: IF fnd_api.to_boolean(p_commit)
1911: THEN
1912: COMMIT WORK;
1913: END IF;
1914:
1923: WHEN l_duplicate_note
1924: THEN
1925: -- User hit 'Refresh' button, pretend it never happend and all is well
1926: ROLLBACK TO create_note_pvt;
1927: x_return_status := fnd_api.g_ret_sts_success;
1928:
1929: WHEN l_missing_parameter
1930: THEN
1931: -- A required parameter is missing
1929: WHEN l_missing_parameter
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);
1947: WHEN l_null_parameter
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);
1960: , p_count => x_msg_count
1961: , p_data => x_msg_data
1962: );
1963:
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'
1963:
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: );
1969: , p_count => x_msg_count
1970: , p_data => x_msg_data
1971: );
1972:
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'
1972:
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:
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
2108:
2109: --
2110: -- Standard call to check for call compatibility
2111: --
2112: IF NOT fnd_api.compatible_api_call( l_api_version
2113: , p_api_version
2114: , l_api_name, g_pkg_name
2115: )
2116: THEN
2113: , p_api_version
2114: , l_api_name, g_pkg_name
2115: )
2116: THEN
2117: RAISE fnd_api.g_exc_unexpected_error;
2118: END IF;
2119:
2120: --
2121: -- Initialize message list if p_init_msg_list is set to TRUE
2119:
2120: --
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:
2127:
2128: --
2129: -- Initialize API return status to success
2130: --
2131: x_return_status := fnd_api.g_ret_sts_success;
2132:
2133: --
2134: -- Fetch the original values for defaulting/comparison
2135: --
2142: add_invalid_argument_msg( l_api_name_full
2143: , p_jtf_note_id
2144: , 'p_jtf_note_id'
2145: );
2146: RAISE fnd_api.g_exc_error;
2147: END IF;
2148:
2149: OPEN l_tl_csr; -- _TL table
2150:
2155: add_invalid_argument_msg( l_api_name_full
2156: , p_jtf_note_id
2157: , 'p_jtf_note_id'
2158: );
2159: RAISE fnd_api.g_exc_error;
2160: END IF;
2161:
2162: --
2163: -- Defaulting values that are missing
2161:
2162: --
2163: -- Defaulting values that are missing
2164: --
2165: IF (p_notes = fnd_api.g_miss_char)
2166: THEN
2167: --substrb added for bug 4227634 by abraina
2168: l_notes := substrb(l_tl_rec.notes,1,2000);
2169: ELSE
2169: ELSE
2170: l_notes := substrb(p_notes,1,2000);
2171: END IF;
2172: --
2173: IF (p_note_status = fnd_api.g_miss_char)
2174: THEN
2175: l_note_status := l_com_rec.note_status;
2176: ELSE
2177: l_note_status := p_note_status;
2176: ELSE
2177: l_note_status := p_note_status;
2178: END IF;
2179: --
2180: IF (p_note_type = fnd_api.g_miss_char)
2181: THEN
2182: l_note_type := l_com_rec.note_type;
2183: ELSE
2184: l_note_type := p_note_type;
2183: ELSE
2184: l_note_type := p_note_type;
2185: END IF;
2186: --
2187: IF p_last_update_date = fnd_api.g_miss_date
2188: THEN
2189: l_last_update_date := SYSDATE;
2190: ELSE
2191: l_last_update_date := p_last_update_date;
2190: ELSE
2191: l_last_update_date := p_last_update_date;
2192: END IF;
2193: --
2194: IF p_last_updated_by = fnd_api.g_miss_num
2195: THEN
2196: l_last_updated_by := FND_GLOBAL.USER_ID;
2197: ELSE
2198: l_last_updated_by := p_last_updated_by;
2197: ELSE
2198: l_last_updated_by := p_last_updated_by;
2199: END IF;
2200: --
2201: IF p_last_update_login = fnd_api.g_miss_num
2202: THEN
2203: l_last_update_login := FND_GLOBAL.USER_ID;
2204: ELSE
2205: l_last_update_login := p_last_update_login;
2211: ELSE
2212: l_append_flag := 'N';
2213: END IF;
2214: --
2215: IF (p_attribute1 = fnd_api.g_miss_char)
2216: THEN
2217: l_attribute1 := l_com_rec.attribute1;
2218: ELSE
2219: l_attribute1 := p_attribute1;
2218: ELSE
2219: l_attribute1 := p_attribute1;
2220: END IF;
2221: --
2222: IF (p_attribute2 = fnd_api.g_miss_char)
2223: THEN
2224: l_attribute2 := l_com_rec.attribute2;
2225: ELSE
2226: l_attribute2 := p_attribute2;
2225: ELSE
2226: l_attribute2 := p_attribute2;
2227: END IF;
2228: --
2229: IF (p_attribute3 = fnd_api.g_miss_char)
2230: THEN
2231: l_attribute3 := l_com_rec.attribute3;
2232: ELSE
2233: l_attribute3 := p_attribute3;
2232: ELSE
2233: l_attribute3 := p_attribute3;
2234: END IF;
2235: --
2236: IF (p_attribute4 = fnd_api.g_miss_char)
2237: THEN
2238: l_attribute4 := l_com_rec.attribute4;
2239: ELSE
2240: l_attribute4 := p_attribute4;
2239: ELSE
2240: l_attribute4 := p_attribute4;
2241: END IF;
2242: --
2243: IF (p_attribute5 = fnd_api.g_miss_char)
2244: THEN
2245: l_attribute5 := l_com_rec.attribute5;
2246: ELSE
2247: l_attribute5 := p_attribute5;
2246: ELSE
2247: l_attribute5 := p_attribute5;
2248: END IF;
2249: --
2250: IF (p_attribute6 = fnd_api.g_miss_char)
2251: THEN
2252: l_attribute6 := l_com_rec.attribute6;
2253: ELSE
2254: l_attribute6 := p_attribute6;
2253: ELSE
2254: l_attribute6 := p_attribute6;
2255: END IF;
2256: --
2257: IF (p_attribute7 = fnd_api.g_miss_char)
2258: THEN
2259: l_attribute7 := l_com_rec.attribute7;
2260: ELSE
2261: l_attribute7 := p_attribute7;
2260: ELSE
2261: l_attribute7 := p_attribute7;
2262: END IF;
2263: --
2264: IF (p_attribute8 = fnd_api.g_miss_char)
2265: THEN
2266: l_attribute8 := l_com_rec.attribute8;
2267: ELSE
2268: l_attribute8 := p_attribute8;
2267: ELSE
2268: l_attribute8 := p_attribute8;
2269: END IF;
2270: --
2271: IF (p_attribute9 = fnd_api.g_miss_char)
2272: THEN
2273: l_attribute9 := l_com_rec.attribute9;
2274: ELSE
2275: l_attribute9 := p_attribute9;
2274: ELSE
2275: l_attribute9 := p_attribute9;
2276: END IF;
2277: --
2278: IF (p_attribute10 = fnd_api.g_miss_char)
2279: THEN
2280: l_attribute10 := l_com_rec.attribute10;
2281: ELSE
2282: l_attribute10 := p_attribute10;
2281: ELSE
2282: l_attribute10 := p_attribute10;
2283: END IF;
2284: --
2285: IF (p_attribute11 = fnd_api.g_miss_char)
2286: THEN
2287: l_attribute11 := l_com_rec.attribute11;
2288: ELSE
2289: l_attribute11 := p_attribute11;
2288: ELSE
2289: l_attribute11 := p_attribute11;
2290: END IF;
2291: --
2292: IF (p_attribute12 = fnd_api.g_miss_char)
2293: THEN
2294: l_attribute12 := l_com_rec.attribute12;
2295: ELSE
2296: l_attribute12 := p_attribute12;
2295: ELSE
2296: l_attribute12 := p_attribute12;
2297: END IF;
2298: --
2299: IF (p_attribute13 = fnd_api.g_miss_char)
2300: THEN
2301: l_attribute13 := l_com_rec.attribute13;
2302: ELSE
2303: l_attribute13 := p_attribute13;
2302: ELSE
2303: l_attribute13 := p_attribute13;
2304: END IF;
2305: --
2306: IF (p_attribute14 = fnd_api.g_miss_char)
2307: THEN
2308: l_attribute14 := l_com_rec.attribute14;
2309: ELSE
2310: l_attribute14 := p_attribute14;
2309: ELSE
2310: l_attribute14 := p_attribute14;
2311: END IF;
2312: --
2313: IF (p_attribute15 = fnd_api.g_miss_char)
2314: THEN
2315: l_attribute15 := l_com_rec.attribute15;
2316: ELSE
2317: l_attribute15 := p_attribute15;
2316: ELSE
2317: l_attribute15 := p_attribute15;
2318: END IF;
2319: --
2320: IF (p_context = fnd_api.g_miss_char)
2321: THEN
2322: l_context := l_com_rec.context;
2323: ELSE
2324: l_context := p_context;
2327: -- Defaulting the Note and Note details
2328: --
2329: writelobtoData(l_tl_rec.jtf_note_id,l_notes_detail_old); -- Copy the CLOB into a VARCHAR2 so we can use it
2330: --
2331: IF (p_notes_detail = fnd_api.g_miss_char)
2332: THEN
2333: -- use existing value, copy to local so we can append if nesecary
2334: l_notes_detail := l_notes_detail_old;
2335: ELSIF (p_notes_detail IS NULL )
2401: , p_note_type => l_note_type
2402: , x_return_status => l_return_status
2403: );
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;
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:
2413: IF jtf_usr_hks.ok_to_execute( 'JTF_NOTES_PUB'
2430: , p_note_type => l_note_type
2431: , x_return_status => l_return_status
2432: );
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;
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:
2442: IF (p_validation_level > fnd_api.g_valid_level_none)
2438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2439: END IF;
2440: END IF;
2441:
2442: IF (p_validation_level > fnd_api.g_valid_level_none)
2443: THEN
2444: -- Validate notes
2445: IF (p_notes IS NULL)
2446: THEN
2444: -- Validate notes
2445: IF (p_notes IS NULL)
2446: THEN
2447: add_null_parameter_msg(l_api_name_full, 'p_notes');
2448: RAISE fnd_api.g_exc_error;
2449: END IF;
2450:
2451: -- Validate note status
2452: IF (p_note_status <> fnd_api.g_miss_char)
2448: RAISE fnd_api.g_exc_error;
2449: END IF;
2450:
2451: -- Validate note status
2452: IF (p_note_status <> fnd_api.g_miss_char)
2453: THEN
2454: IF (p_note_status NOT IN ('P', 'I','E'))
2455: THEN
2456: add_invalid_argument_msg( l_api_name_full
2456: add_invalid_argument_msg( l_api_name_full
2457: , p_note_status
2458: , 'p_note_status'
2459: );
2460: RAISE fnd_api.g_exc_error;
2461: END IF;
2462: END IF;
2463:
2464: --Validate note_type
2469: , p_note_type => l_note_type
2470: , x_return_status => l_return_status
2471: );
2472:
2473: IF (l_return_status <> fnd_api.g_ret_sts_success)
2474: THEN
2475: RAISE fnd_api.g_exc_error;
2476: END IF;
2477: END IF;
2471: );
2472:
2473: IF (l_return_status <> fnd_api.g_ret_sts_success)
2474: THEN
2475: RAISE fnd_api.g_exc_error;
2476: END IF;
2477: END IF;
2478: END IF;
2479: --
2478: END IF;
2479: --
2480: -- AOL Security validations
2481: --
2482: IF (p_use_AOL_security = fnd_api.g_true)
2483: THEN
2484: --
2485: -- Check if the note is being updated
2486: --
2490: -- Check if the user is allowed to update note text for this note
2491: --
2492: JTF_NOTES_SECURITY_PVT.check_function
2493: ( p_api_version => 1.0
2494: , p_init_msg_list => FND_API.G_FALSE
2495: , p_function => JTF_NOTES_SECURITY_PVT.G_FUNCTION_UPDATE_NOTE
2496: , p_object_name => JTF_NOTES_SECURITY_PVT.G_OBJECT_NOTE
2497: , p_instance_pk1_value => p_jtf_note_id
2498: , x_grant => l_note_update_primary
2503:
2504: --
2505: -- If there's an error push it onto the stack
2506: --
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;
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: --
2516: -- If the create function was not granted throw an error
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:
2527: --
2533: -- Check if the user is allowed to update note details for this note
2534: --
2535: JTF_NOTES_SECURITY_PVT.check_function
2536: ( p_api_version => 1.0
2537: , p_init_msg_list => FND_API.G_FALSE
2538: , p_function => JTF_NOTES_SECURITY_PVT.G_FUNCTION_UPDATE_NOTE_DTLS
2539: , p_object_name => JTF_NOTES_SECURITY_PVT.G_OBJECT_NOTE
2540: , p_instance_pk1_value => p_jtf_note_id
2541: , x_grant => l_note_update_primary
2546:
2547: --
2548: -- If there's an error push it onto the stack
2549: --
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;
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: --
2559: -- If the create function was not granted throw an error
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:
2570: --
2579: -- Check if the user is allowed to update primary attributes for this note
2580: --
2581: JTF_NOTES_SECURITY_PVT.check_function
2582: ( p_api_version => 1.0
2583: , p_init_msg_list => FND_API.G_FALSE
2584: , p_function => JTF_NOTES_SECURITY_PVT.G_FUNCTION_UPDATE_SEC
2585: , p_object_name => JTF_NOTES_SECURITY_PVT.G_OBJECT_NOTE
2586: , p_instance_pk1_value => p_jtf_note_id
2587: , x_grant => l_note_update_secondary
2592:
2593: --
2594: -- If there's an error push it onto the stack
2595: --
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;
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: --
2605: -- If the create function was not granted throw an error
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
2616: --
2615: -- Function was granted now we'll verify whether user is allowed to create notes of the given type
2616: --
2617: JTF_NOTES_SECURITY_PVT.check_note_type
2618: ( p_api_version => 1.0
2619: , p_init_msg_list => FND_API.G_FALSE
2620: , p_note_type => p_note_type
2621: , x_return_status => l_return_status
2622: , x_grant => l_note_select_type
2623: , x_msg_count => l_msg_count
2626:
2627: --
2628: -- If there's an error push it onto the stack
2629: --
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;
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: --
2639: -- user is not allowed to create notes of this type
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;
2650: END IF; -- end of Security validations
2738: , p_last_update_date => p_jtf_note_contexts_tab(i).last_update_date
2739: , p_last_update_login => p_jtf_note_contexts_tab(i).last_update_login
2740: );
2741:
2742: IF (l_return_status <> fnd_api.g_ret_sts_success)
2743: THEN
2744: RAISE fnd_api.g_exc_error;
2745: END IF;
2746: END LOOP;
2740: );
2741:
2742: IF (l_return_status <> fnd_api.g_ret_sts_success)
2743: THEN
2744: RAISE fnd_api.g_exc_error;
2745: END IF;
2746: END LOOP;
2747: END IF;
2748:
2766: , p_note_type => l_note_type
2767: , x_return_status => l_return_status
2768: );
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;
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:
2778: IF jtf_usr_hks.ok_to_execute( 'JTF_NOTES_PUB'
2795: , p_note_type => l_note_type
2796: , x_return_status => l_return_status
2797: );
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;
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:
2807: -- Standard call for message generation
2839: , p_action_code => 'I'
2840: , p_bind_data_id => l_bind_data_id
2841: , x_return_code => l_return_status
2842: );
2843: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2844: THEN
2845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2846: END IF;
2847: END IF;
2841: , x_return_code => l_return_status
2842: );
2843: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2844: THEN
2845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2846: END IF;
2847: END IF;
2848: END IF;
2849:
2854: , p_SourceObjectID => l_com_rec.source_object_id
2855: );
2856:
2857: -- Standard check of p_commit
2858: IF fnd_api.to_boolean(p_commit)
2859: THEN
2860: COMMIT WORK;
2861: END IF;
2862:
2886:
2887: /**********************************************************
2888: ** Set Status to error
2889: **********************************************************/
2890: x_return_status := fnd_api.g_ret_sts_error;
2891:
2892: /**********************************************************
2893: ** Set the error
2894: **********************************************************/
2898: , p_count => x_msg_count
2899: , p_data => x_msg_data
2900: );
2901:
2902: WHEN fnd_api.g_exc_error
2903: THEN
2904: ROLLBACK TO update_note_pvt;
2905: IF (l_com_csr%ISOPEN)
2906: THEN
2911: THEN
2912: CLOSE l_tl_csr;
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
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
2922: THEN
2923: ROLLBACK TO update_note_pvt;
2924: IF (l_com_csr%ISOPEN)
2925: THEN
2930: THEN
2931: CLOSE l_tl_csr;
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
2949: THEN
2950: CLOSE l_tl_csr;
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);