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

Line 379: IF NOT FND_API.Compatible_API_Call (

375:
376: -- ******* Standard Begins ********
377:
378: -- Standard call to check for call compatibility.
379: IF NOT FND_API.Compatible_API_Call (
380: l_api_version,
381: p_api_version,
382: l_api_name,
383: G_PKG_NAME)

Line 385: x_return_status := FND_API.G_RET_STS_ERROR;

381: p_api_version,
382: l_api_name,
383: G_PKG_NAME)
384: THEN
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: FND_MSG_PUB.ADD;
387: RAISE FND_API.G_EXC_ERROR;
388: END IF;
389: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 387: RAISE FND_API.G_EXC_ERROR;

383: G_PKG_NAME)
384: THEN
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: FND_MSG_PUB.ADD;
387: RAISE FND_API.G_EXC_ERROR;
388: END IF;
389: -- Initialize message list if p_init_msg_list is set to TRUE.
390: IF FND_API.to_Boolean( p_init_msg_list ) THEN
391: FND_MSG_PUB.initialize;

Line 390: IF FND_API.to_Boolean( p_init_msg_list ) THEN

386: FND_MSG_PUB.ADD;
387: RAISE FND_API.G_EXC_ERROR;
388: END IF;
389: -- Initialize message list if p_init_msg_list is set to TRUE.
390: IF FND_API.to_Boolean( p_init_msg_list ) THEN
391: FND_MSG_PUB.initialize;
392: END IF;
393:
394: -- Initialize API return status to success

Line 395: x_return_status := FND_API.G_RET_STS_SUCCESS;

391: FND_MSG_PUB.initialize;
392: END IF;
393:
394: -- Initialize API return status to success
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396:
397: -- Begin
398:
399: -- Validation of Content Item before submitting it for approval

Line 407: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

403: ,x_msg_count => x_msg_count
404: ,x_msg_data => x_msg_data
405: );
406:
407: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
408: RAISE FND_API.G_EXC_ERROR;
409: END IF;
410:
411: -- Validation of Components (they need to be approved already)

Line 408: RAISE FND_API.G_EXC_ERROR;

404: ,x_msg_data => x_msg_data
405: );
406:
407: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
408: RAISE FND_API.G_EXC_ERROR;
409: END IF;
410:
411: -- Validation of Components (they need to be approved already)
412: OPEN c_component_not_status(p_citem_ver_id, IBC_UTILITIES_PUB.G_STV_APPROVED);

Line 416: x_return_status := FND_API.G_RET_STS_ERROR;

412: OPEN c_component_not_status(p_citem_ver_id, IBC_UTILITIES_PUB.G_STV_APPROVED);
413: FETCH c_component_not_status INTO l_dummy;
414: IF (c_component_not_status%FOUND) THEN
415: CLOSE c_component_not_status;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: FND_MESSAGE.Set_Name('IBC', 'COMPONENT_APPROVAL_REQUIRED');
418: FND_MSG_PUB.ADD;
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;

Line 419: RAISE FND_API.G_EXC_ERROR;

415: CLOSE c_component_not_status;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: FND_MESSAGE.Set_Name('IBC', 'COMPONENT_APPROVAL_REQUIRED');
418: FND_MSG_PUB.ADD;
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;
421: CLOSE c_component_not_status;
422:
423: l_content_item_id := getCitemId(p_citem_ver_id);

Line 433: ,p_container_pk1_value => l_directory_node_id) = FND_API.g_false

429: p_instance_object_id => l_citem_object_type
430: ,p_instance_pk1_value => l_content_item_id
431: ,p_permission_code => 'CITEM_APPROVE'
432: ,p_container_object_id => l_directory_object_type
433: ,p_container_pk1_value => l_directory_node_id) = FND_API.g_false
434: AND
435: NVL(Fnd_Profile.Value_specific('IBC_USE_ACCESS_CONTROL',-999,-999,-999), 'N') = 'Y'
436: THEN
437: IBC_DATA_SECURITY_PVT.get_grantee_usernames(

Line 448: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

444: ,x_return_status => x_return_status
445: ,x_msg_count => x_msg_count
446: ,x_msg_data => x_msg_data
447: );
448: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
449: RAISE FND_API.G_EXC_ERROR;
450: END IF;
451: IF l_user_list IS NULL THEN
452: x_return_status := FND_API.G_RET_STS_ERROR;

Line 449: RAISE FND_API.G_EXC_ERROR;

445: ,x_msg_count => x_msg_count
446: ,x_msg_data => x_msg_data
447: );
448: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
449: RAISE FND_API.G_EXC_ERROR;
450: END IF;
451: IF l_user_list IS NULL THEN
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: FND_MESSAGE.Set_Name('IBC', 'IBC_NOT_APPROVER_DEFINED');

Line 452: x_return_status := FND_API.G_RET_STS_ERROR;

448: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
449: RAISE FND_API.G_EXC_ERROR;
450: END IF;
451: IF l_user_list IS NULL THEN
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: FND_MESSAGE.Set_Name('IBC', 'IBC_NOT_APPROVER_DEFINED');
454: FND_MSG_PUB.ADD;
455: RAISE FND_API.G_EXC_ERROR;
456: ELSE

Line 455: RAISE FND_API.G_EXC_ERROR;

451: IF l_user_list IS NULL THEN
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: FND_MESSAGE.Set_Name('IBC', 'IBC_NOT_APPROVER_DEFINED');
454: FND_MSG_PUB.ADD;
455: RAISE FND_API.G_EXC_ERROR;
456: ELSE
457: Create_Workflow_Role(
458: p_user_list => l_user_list
459: ,px_wf_role_name => l_wf_role_name

Line 471: ,p_commit => FND_API.g_false

467:
468: -- Unlock Content Id
469: IBC_CITEM_ADMIN_GRP.unlock_item(
470: p_content_item_id => l_content_item_id
471: ,p_commit => FND_API.g_false
472: ,p_init_msg_list => FND_API.g_false
473: ,x_return_status => x_return_status
474: ,x_msg_count => x_msg_count
475: ,x_msg_data => x_msg_data

Line 472: ,p_init_msg_list => FND_API.g_false

468: -- Unlock Content Id
469: IBC_CITEM_ADMIN_GRP.unlock_item(
470: p_content_item_id => l_content_item_id
471: ,p_commit => FND_API.g_false
472: ,p_init_msg_list => FND_API.g_false
473: ,x_return_status => x_return_status
474: ,x_msg_count => x_msg_count
475: ,x_msg_data => x_msg_data
476: );

Line 478: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

474: ,x_msg_count => x_msg_count
475: ,x_msg_data => x_msg_data
476: );
477:
478: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
479: RAISE FND_API.G_EXC_ERROR;
480: END IF;
481:
482: -- Approval Will go through Workflow

Line 479: RAISE FND_API.G_EXC_ERROR;

475: ,x_msg_data => x_msg_data
476: );
477:
478: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
479: RAISE FND_API.G_EXC_ERROR;
480: END IF;
481:
482: -- Approval Will go through Workflow
483: -- Creation of workflow process

Line 522: ,p_commit => FND_API.g_false

518: IBC_CITEM_ADMIN_GRP.change_status(
519: p_citem_ver_id => p_citem_ver_id
520: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED
521: ,p_language => p_language
522: ,p_commit => FND_API.g_false
523: ,p_init_msg_list => FND_API.g_false
524: ,px_object_version_number => px_object_version_number
525: ,x_return_status => x_return_status
526: ,x_msg_count => x_msg_count

Line 523: ,p_init_msg_list => FND_API.g_false

519: p_citem_ver_id => p_citem_ver_id
520: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED
521: ,p_language => p_language
522: ,p_commit => FND_API.g_false
523: ,p_init_msg_list => FND_API.g_false
524: ,px_object_version_number => px_object_version_number
525: ,x_return_status => x_return_status
526: ,x_msg_count => x_msg_count
527: ,x_msg_data => x_msg_data

Line 544: ,p_commit => FND_API.g_false

540: IBC_CITEM_ADMIN_GRP.change_status(
541: p_citem_ver_id => p_citem_ver_id
542: ,p_new_status => IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL
543: ,p_language => p_language
544: ,p_commit => FND_API.g_false
545: ,p_init_msg_list => FND_API.g_true
546: ,px_object_version_number => px_object_version_number
547: ,x_return_status => x_return_status
548: ,x_msg_count => x_msg_count

Line 545: ,p_init_msg_list => FND_API.g_true

541: p_citem_ver_id => p_citem_ver_id
542: ,p_new_status => IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL
543: ,p_language => p_language
544: ,p_commit => FND_API.g_false
545: ,p_init_msg_list => FND_API.g_true
546: ,px_object_version_number => px_object_version_number
547: ,x_return_status => x_return_status
548: ,x_msg_count => x_msg_count
549: ,x_msg_data => x_msg_data

Line 558: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

554: aname => 'ALREADY_APPROVED',
555: avalue => 'N');
556: END IF;
557:
558: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
559: RAISE FND_API.G_EXC_ERROR;
560: END IF;
561:
562: OPEN c_owner(p_citem_ver_id);

Line 559: RAISE FND_API.G_EXC_ERROR;

555: avalue => 'N');
556: END IF;
557:
558: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
559: RAISE FND_API.G_EXC_ERROR;
560: END IF;
561:
562: OPEN c_owner(p_citem_ver_id);
563: FETCH c_owner INTO l_owner_resource_id, l_owner_resource_type, l_version_number, l_creator_id;

Line 725: IF (p_commit = FND_API.g_true) THEN

721: -- If everything is okay so far then set x_wf_item_key
722: x_wf_item_key := l_ItemKey;
723:
724: -- COMMIT?
725: IF (p_commit = FND_API.g_true) THEN
726: COMMIT;
727: END IF;
728:
729: -- Standard call to get message count and if count=1, get the message

Line 733: WHEN FND_API.G_EXC_ERROR THEN

729: -- Standard call to get message count and if count=1, get the message
730: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
731: p_data => x_msg_data);
732: EXCEPTION
733: WHEN FND_API.G_EXC_ERROR THEN
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
736: p_data => x_msg_data);
737: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

Line 734: x_return_status := FND_API.G_RET_STS_ERROR;

730: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
731: p_data => x_msg_data);
732: EXCEPTION
733: WHEN FND_API.G_EXC_ERROR THEN
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
736: p_data => x_msg_data);
737: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
738: P_API_NAME => L_API_NAME

Line 748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

744: ,X_MSG_COUNT => X_MSG_COUNT
745: ,X_MSG_DATA => X_MSG_DATA
746: ,X_RETURN_STATUS => X_RETURN_STATUS
747: );
748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
751: p_data => x_msg_data);
752: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

Line 749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

745: ,X_MSG_DATA => X_MSG_DATA
746: ,X_RETURN_STATUS => X_RETURN_STATUS
747: );
748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
751: p_data => x_msg_data);
752: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
753: P_API_NAME => L_API_NAME

Line 764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

760: ,X_MSG_DATA => X_MSG_DATA
761: ,X_RETURN_STATUS => X_RETURN_STATUS
762: );
763: WHEN OTHERS THEN
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
766: THEN
767: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
768: END IF;

Line 829: ,p_commit => FND_API.g_true

825: IBC_CITEM_ADMIN_GRP.change_status(
826: p_citem_ver_id => l_citem_ver_id
827: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED
828: ,p_language => l_language
829: ,p_commit => FND_API.g_true
830: ,p_init_msg_list => FND_API.g_true
831: ,px_object_version_number => l_object_version_number
832: ,x_return_status => l_return_status
833: ,x_msg_count => l_msg_count

Line 830: ,p_init_msg_list => FND_API.g_true

826: p_citem_ver_id => l_citem_ver_id
827: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED
828: ,p_language => l_language
829: ,p_commit => FND_API.g_true
830: ,p_init_msg_list => FND_API.g_true
831: ,px_object_version_number => l_object_version_number
832: ,x_return_status => l_return_status
833: ,x_msg_count => l_msg_count
834: ,x_msg_data => l_msg_data

Line 837: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

833: ,x_msg_count => l_msg_count
834: ,x_msg_data => l_msg_data
835: );
836:
837: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
838: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
839: itemkey => itemkey,
840: aname => 'APPROVER_NAME',
841: avalue => get_user_description(FND_GLOBAL.user_id));

Line 865: ,p_commit => FND_API.g_true

861: p_activity => 'APPROVE'
862: ,p_object_type => IBC_AUDIT_LOG_GRP.G_CITEM_VERSION
863: ,p_object_value1 => l_citem_ver_id
864: ,p_parent_value => getCitemId(l_citem_ver_id)
865: ,p_commit => FND_API.g_true
866: ,p_init_msg_list => FND_API.g_true
867: ,x_return_status => l_return_status
868: ,x_msg_count => l_msg_count
869: ,x_msg_data => l_msg_data

Line 866: ,p_init_msg_list => FND_API.g_true

862: ,p_object_type => IBC_AUDIT_LOG_GRP.G_CITEM_VERSION
863: ,p_object_value1 => l_citem_ver_id
864: ,p_parent_value => getCitemId(l_citem_ver_id)
865: ,p_commit => FND_API.g_true
866: ,p_init_msg_list => FND_API.g_true
867: ,x_return_status => l_return_status
868: ,x_msg_count => l_msg_count
869: ,x_msg_data => l_msg_data
870: );

Line 873: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

869: ,x_msg_data => l_msg_data
870: );
871: END IF;
872:
873: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
874: -- IF l_return_status not successful then return 'N'
875: result := 'COMPLETE:N';
876: IBC_UTILITIES_PVT.Get_Messages (
877: p_message_count => l_msg_count,

Line 951: ,p_commit => FND_API.g_true

947: IBC_CITEM_ADMIN_GRP.change_status(
948: p_citem_ver_id => l_citem_ver_id
949: ,p_new_status => IBC_UTILITIES_PUB.G_STV_REJECTED
950: ,p_language => l_language
951: ,p_commit => FND_API.g_true
952: ,p_init_msg_list => FND_API.g_true
953: ,px_object_version_number => l_object_version_number
954: ,x_return_status => l_return_status
955: ,x_msg_count => l_msg_count

Line 952: ,p_init_msg_list => FND_API.g_true

948: p_citem_ver_id => l_citem_ver_id
949: ,p_new_status => IBC_UTILITIES_PUB.G_STV_REJECTED
950: ,p_language => l_language
951: ,p_commit => FND_API.g_true
952: ,p_init_msg_list => FND_API.g_true
953: ,px_object_version_number => l_object_version_number
954: ,x_return_status => l_return_status
955: ,x_msg_count => l_msg_count
956: ,x_msg_data => l_msg_data

Line 972: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

968: );
969:
970: END IF;
971:
972: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
973: -- Audit Log Action
974: l_comments := WF_ENGINE.GetItemAttrText(
975: itemtype => itemtype,
976: itemkey => itemkey,

Line 986: ,p_commit => FND_API.g_true

982: ,p_object_value1 => l_citem_ver_id
983: ,p_parent_value => getCitemId(l_citem_ver_id)
984: ,p_extra_info1_type => IBC_AUDIT_LOG_GRP.G_EI_CONSTANT
985: ,p_extra_info1_value => l_comments
986: ,p_commit => FND_API.g_true
987: ,p_init_msg_list => FND_API.g_true
988: ,x_return_status => l_return_status
989: ,x_msg_count => l_msg_count
990: ,x_msg_data => l_msg_data

Line 987: ,p_init_msg_list => FND_API.g_true

983: ,p_parent_value => getCitemId(l_citem_ver_id)
984: ,p_extra_info1_type => IBC_AUDIT_LOG_GRP.G_EI_CONSTANT
985: ,p_extra_info1_value => l_comments
986: ,p_commit => FND_API.g_true
987: ,p_init_msg_list => FND_API.g_true
988: ,x_return_status => l_return_status
989: ,x_msg_count => l_msg_count
990: ,x_msg_data => l_msg_data
991: );

Line 994: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

990: ,x_msg_data => l_msg_data
991: );
992: END IF;
993:
994: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
995: IBC_UTILITIES_PVT.Get_Messages (
996: p_message_count => l_msg_count,
997: x_msgs => l_error_msg_stack
998: );

Line 1087: IF l_translation_required = FND_API.g_true

1083: OPEN c_citem_info(l_citem_ver_id);
1084: FETCH c_citem_info INTO l_content_item_id, l_base_language,
1085: l_translation_required, l_directory_node_id,
1086: l_version_number;
1087: IF l_translation_required = FND_API.g_true
1088: THEN
1089:
1090: OPEN c_directory(l_content_item_id);
1091: FETCH c_directory INTO l_directory_node_id, l_directory_path;

Line 1106: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1102: ,x_msg_count => l_msg_count
1103: ,x_msg_data => l_msg_data
1104: );
1105:
1106: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1107: result := 'COMPLETE:Y';
1108: IF l_user_list IS NOT NULL THEN
1109: l_ItemKey := l_citem_ver_id || '@T' || TO_CHAR(SYSDATE, 'YYYYMMDD-HH24:MI:SS');
1110:

Line 1227: FND_MSG_PUB.get(p_encoded => FND_API.g_false) ||

1223: l_error_msg_stack := l_error_msg_stack || FND_GLOBAL.Newline() || 'Return Status: ' ||
1224: l_return_status || FND_GLOBAL.Newline() || FND_GLOBAL.Newline() ;
1225: FOR I IN 1..l_msg_count LOOP
1226: l_error_msg_stack := l_error_msg_stack || ' ... ' ||
1227: FND_MSG_PUB.get(p_encoded => FND_API.g_false) ||
1228: FND_GLOBAL.Newline();
1229: END LOOP;
1230: WF_ENGINE.SetItemAttrText(
1231: itemtype => itemtype,

Line 1287: IF NOT FND_API.Compatible_API_Call (

1283: BEGIN
1284: -- ******* Standard Begins ********
1285:
1286: -- Standard call to check for call compatibility.
1287: IF NOT FND_API.Compatible_API_Call (
1288: l_api_version,
1289: p_api_version,
1290: l_api_name,
1291: G_PKG_NAME)

Line 1293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1289: p_api_version,
1290: l_api_name,
1291: G_PKG_NAME)
1292: THEN
1293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1294: END IF;
1295: -- Initialize message list if p_init_msg_list is set to TRUE.
1296: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1297: FND_MSG_PUB.initialize;

Line 1296: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1292: THEN
1293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1294: END IF;
1295: -- Initialize message list if p_init_msg_list is set to TRUE.
1296: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1297: FND_MSG_PUB.initialize;
1298: END IF;
1299:
1300: -- Initialize API return status to success

Line 1301: x_return_status := FND_API.G_RET_STS_SUCCESS;

1297: FND_MSG_PUB.initialize;
1298: END IF;
1299:
1300: -- Initialize API return status to success
1301: x_return_status := FND_API.G_RET_STS_SUCCESS;
1302:
1303: -- Begin
1304:
1305: OPEN c_chk_notification;

Line 1309: x_return_status := FND_API.G_RET_STS_ERROR;

1305: OPEN c_chk_notification;
1306: FETCH c_chk_notification INTO l_dummy;
1307: IF c_chk_notification%NOTFOUND THEN
1308: CLOSE c_chk_notification;
1309: x_return_status := FND_API.G_RET_STS_ERROR;
1310: FND_MESSAGE.Set_Name('IBC', 'IBC_NOTIF_ALREADY_RESPONDED');
1311: FND_MSG_PUB.ADD;
1312: RAISE FND_API.G_EXC_ERROR;
1313: END IF;

Line 1312: RAISE FND_API.G_EXC_ERROR;

1308: CLOSE c_chk_notification;
1309: x_return_status := FND_API.G_RET_STS_ERROR;
1310: FND_MESSAGE.Set_Name('IBC', 'IBC_NOTIF_ALREADY_RESPONDED');
1311: FND_MSG_PUB.ADD;
1312: RAISE FND_API.G_EXC_ERROR;
1313: END IF;
1314: CLOSE c_chk_notification;
1315:
1316: IF p_response IN ('Y', 'N') THEN

Line 1336: x_return_status := FND_API.G_RET_STS_ERROR;

1332: p_item_key,
1333: p_activity,
1334: p_response);
1335: ELSE
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
1338: FND_MESSAGE.Set_Token('INPUT', 'p_response', FALSE);
1339: FND_MSG_PUB.ADD;
1340: RAISE FND_API.G_EXC_ERROR;

Line 1340: RAISE FND_API.G_EXC_ERROR;

1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
1338: FND_MESSAGE.Set_Token('INPUT', 'p_response', FALSE);
1339: FND_MSG_PUB.ADD;
1340: RAISE FND_API.G_EXC_ERROR;
1341: END IF;
1342:
1343: -- COMMIT?
1344: IF (p_commit = FND_API.g_true) THEN

Line 1344: IF (p_commit = FND_API.g_true) THEN

1340: RAISE FND_API.G_EXC_ERROR;
1341: END IF;
1342:
1343: -- COMMIT?
1344: IF (p_commit = FND_API.g_true) THEN
1345: COMMIT;
1346: END IF;
1347:
1348: -- Standard call to get message count and if count=1, get the message

Line 1352: WHEN FND_API.G_EXC_ERROR THEN

1348: -- Standard call to get message count and if count=1, get the message
1349: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1350: p_data => x_msg_data);
1351: EXCEPTION
1352: WHEN FND_API.G_EXC_ERROR THEN
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1355: p_data => x_msg_data);
1356: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

Line 1353: x_return_status := FND_API.G_RET_STS_ERROR;

1349: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1350: p_data => x_msg_data);
1351: EXCEPTION
1352: WHEN FND_API.G_EXC_ERROR THEN
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1355: p_data => x_msg_data);
1356: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1357: P_API_NAME => L_API_NAME

Line 1367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1363: ,X_MSG_COUNT => X_MSG_COUNT
1364: ,X_MSG_DATA => X_MSG_DATA
1365: ,X_RETURN_STATUS => X_RETURN_STATUS
1366: );
1367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1370: p_data => x_msg_data);
1371: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

Line 1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1364: ,X_MSG_DATA => X_MSG_DATA
1365: ,X_RETURN_STATUS => X_RETURN_STATUS
1366: );
1367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1370: p_data => x_msg_data);
1371: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1372: P_API_NAME => L_API_NAME

Line 1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1379: ,X_MSG_DATA => X_MSG_DATA
1380: ,X_RETURN_STATUS => X_RETURN_STATUS
1381: );
1382: WHEN OTHERS THEN
1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1385: THEN
1386: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1387: END IF;

Line 1428: IF NOT FND_API.Compatible_API_Call (

1424: BEGIN
1425: -- ******* Standard Begins ********
1426:
1427: -- Standard call to check for call compatibility.
1428: IF NOT FND_API.Compatible_API_Call (
1429: l_api_version,
1430: p_api_version,
1431: l_api_name,
1432: G_PKG_NAME)

Line 1434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1430: p_api_version,
1431: l_api_name,
1432: G_PKG_NAME)
1433: THEN
1434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1435: END IF;
1436: -- Initialize message list if p_init_msg_list is set to TRUE.
1437: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1438: FND_MSG_PUB.initialize;

Line 1437: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1433: THEN
1434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1435: END IF;
1436: -- Initialize message list if p_init_msg_list is set to TRUE.
1437: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1438: FND_MSG_PUB.initialize;
1439: END IF;
1440:
1441: -- Initialize API return status to success

Line 1442: x_return_status := FND_API.G_RET_STS_SUCCESS;

1438: FND_MSG_PUB.initialize;
1439: END IF;
1440:
1441: -- Initialize API return status to success
1442: x_return_status := FND_API.G_RET_STS_SUCCESS;
1443:
1444: -- Begin
1445:
1446: WF_ENGINE.CompleteActivity(p_item_type,

Line 1452: IF (p_commit = FND_API.g_true) THEN

1448: 'IBC_CITEM_TRANSLATE_REQ',
1449: NULL);
1450:
1451: -- COMMIT?
1452: IF (p_commit = FND_API.g_true) THEN
1453: COMMIT;
1454: END IF;
1455:
1456: -- Standard call to get message count and if count=1, get the message

Line 1460: WHEN FND_API.G_EXC_ERROR THEN

1456: -- Standard call to get message count and if count=1, get the message
1457: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1458: p_data => x_msg_data);
1459: EXCEPTION
1460: WHEN FND_API.G_EXC_ERROR THEN
1461: x_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1463: p_data => x_msg_data);
1464: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

Line 1461: x_return_status := FND_API.G_RET_STS_ERROR;

1457: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1458: p_data => x_msg_data);
1459: EXCEPTION
1460: WHEN FND_API.G_EXC_ERROR THEN
1461: x_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1463: p_data => x_msg_data);
1464: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1465: P_API_NAME => L_API_NAME

Line 1475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1471: ,X_MSG_COUNT => X_MSG_COUNT
1472: ,X_MSG_DATA => X_MSG_DATA
1473: ,X_RETURN_STATUS => X_RETURN_STATUS
1474: );
1475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1477: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1478: p_data => x_msg_data);
1479: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

Line 1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1472: ,X_MSG_DATA => X_MSG_DATA
1473: ,X_RETURN_STATUS => X_RETURN_STATUS
1474: );
1475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1477: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1478: p_data => x_msg_data);
1479: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1480: P_API_NAME => L_API_NAME

Line 1491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1487: ,X_MSG_DATA => X_MSG_DATA
1488: ,X_RETURN_STATUS => X_RETURN_STATUS
1489: );
1490: WHEN OTHERS THEN
1491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1492: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1493: THEN
1494: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1495: END IF;

Line 1559: IF NOT FND_API.Compatible_API_Call (

1555: BEGIN
1556: -- ******* Standard Begins ********
1557:
1558: -- Standard call to check for call compatibility.
1559: IF NOT FND_API.Compatible_API_Call (
1560: l_api_version,
1561: p_api_version,
1562: l_api_name,
1563: G_PKG_NAME)

Line 1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1561: p_api_version,
1562: l_api_name,
1563: G_PKG_NAME)
1564: THEN
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END IF;
1567: -- Initialize message list if p_init_msg_list is set to TRUE.
1568: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1569: FND_MSG_PUB.initialize;

Line 1568: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1564: THEN
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END IF;
1567: -- Initialize message list if p_init_msg_list is set to TRUE.
1568: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1569: FND_MSG_PUB.initialize;
1570: END IF;
1571:
1572: -- Initialize API return status to success

Line 1573: x_return_status := FND_API.G_RET_STS_SUCCESS;

1569: FND_MSG_PUB.initialize;
1570: END IF;
1571:
1572: -- Initialize API return status to success
1573: x_return_status := FND_API.G_RET_STS_SUCCESS;
1574:
1575: -- Begin
1576: l_index := 0;
1577: FOR r_notification IN c_notifications LOOP

Line 1598: WHEN FND_API.G_EXC_ERROR THEN

1594: -- Standard call to get message count and if count=1, get the message
1595: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1596: p_data => x_msg_data);
1597: EXCEPTION
1598: WHEN FND_API.G_EXC_ERROR THEN
1599: x_return_status := FND_API.G_RET_STS_ERROR;
1600: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1601: p_data => x_msg_data);
1602: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

Line 1599: x_return_status := FND_API.G_RET_STS_ERROR;

1595: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1596: p_data => x_msg_data);
1597: EXCEPTION
1598: WHEN FND_API.G_EXC_ERROR THEN
1599: x_return_status := FND_API.G_RET_STS_ERROR;
1600: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1601: p_data => x_msg_data);
1602: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1603: P_API_NAME => L_API_NAME

Line 1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1609: ,X_MSG_COUNT => X_MSG_COUNT
1610: ,X_MSG_DATA => X_MSG_DATA
1611: ,X_RETURN_STATUS => X_RETURN_STATUS
1612: );
1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1616: p_data => x_msg_data);
1617: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

Line 1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1610: ,X_MSG_DATA => X_MSG_DATA
1611: ,X_RETURN_STATUS => X_RETURN_STATUS
1612: );
1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1616: p_data => x_msg_data);
1617: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1618: P_API_NAME => L_API_NAME

Line 1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1625: ,X_MSG_DATA => X_MSG_DATA
1626: ,X_RETURN_STATUS => X_RETURN_STATUS
1627: );
1628: WHEN OTHERS THEN
1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1630: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1631: THEN
1632: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1633: END IF;

Line 1695: IF NOT FND_API.Compatible_API_Call (

1691: BEGIN
1692: -- ******* Standard Begins ********
1693:
1694: -- Standard call to check for call compatibility.
1695: IF NOT FND_API.Compatible_API_Call (
1696: l_api_version,
1697: p_api_version,
1698: l_api_name,
1699: G_PKG_NAME)

Line 1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1697: p_api_version,
1698: l_api_name,
1699: G_PKG_NAME)
1700: THEN
1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702: END IF;
1703: -- Initialize message list if p_init_msg_list is set to TRUE.
1704: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1705: FND_MSG_PUB.initialize;

Line 1704: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1700: THEN
1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702: END IF;
1703: -- Initialize message list if p_init_msg_list is set to TRUE.
1704: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1705: FND_MSG_PUB.initialize;
1706: END IF;
1707:
1708: -- Initialize API return status to success

Line 1709: x_return_status := FND_API.G_RET_STS_SUCCESS;

1705: FND_MSG_PUB.initialize;
1706: END IF;
1707:
1708: -- Initialize API return status to success
1709: x_return_status := FND_API.G_RET_STS_SUCCESS;
1710:
1711: -- Begin
1712: l_index := 0;
1713: FOR r_notification IN c_notifications LOOP

Line 1734: WHEN FND_API.G_EXC_ERROR THEN

1730: -- Standard call to get message count and if count=1, get the message
1731: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1732: p_data => x_msg_data);
1733: EXCEPTION
1734: WHEN FND_API.G_EXC_ERROR THEN
1735: x_return_status := FND_API.G_RET_STS_ERROR;
1736: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1737: p_data => x_msg_data);
1738: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

Line 1735: x_return_status := FND_API.G_RET_STS_ERROR;

1731: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1732: p_data => x_msg_data);
1733: EXCEPTION
1734: WHEN FND_API.G_EXC_ERROR THEN
1735: x_return_status := FND_API.G_RET_STS_ERROR;
1736: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1737: p_data => x_msg_data);
1738: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1739: P_API_NAME => L_API_NAME

Line 1749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1745: ,X_MSG_COUNT => X_MSG_COUNT
1746: ,X_MSG_DATA => X_MSG_DATA
1747: ,X_RETURN_STATUS => X_RETURN_STATUS
1748: );
1749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1751: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1752: p_data => x_msg_data);
1753: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

Line 1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1746: ,X_MSG_DATA => X_MSG_DATA
1747: ,X_RETURN_STATUS => X_RETURN_STATUS
1748: );
1749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1751: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1752: p_data => x_msg_data);
1753: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1754: P_API_NAME => L_API_NAME

Line 1765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1761: ,X_MSG_DATA => X_MSG_DATA
1762: ,X_RETURN_STATUS => X_RETURN_STATUS
1763: );
1764: WHEN OTHERS THEN
1765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1767: THEN
1768: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1769: END IF;

Line 1926: IF NOT FND_API.Compatible_API_Call (

1922:
1923: -- ******* Standard Begins ********
1924:
1925: -- Standard call to check for call compatibility.
1926: IF NOT FND_API.Compatible_API_Call (
1927: l_api_version,
1928: p_api_version,
1929: l_api_name,
1930: G_PKG_NAME)

Line 1932: x_return_status := FND_API.G_RET_STS_ERROR;

1928: p_api_version,
1929: l_api_name,
1930: G_PKG_NAME)
1931: THEN
1932: x_return_status := FND_API.G_RET_STS_ERROR;
1933: FND_MSG_PUB.ADD;
1934: RAISE FND_API.G_EXC_ERROR;
1935: END IF;
1936: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1934: RAISE FND_API.G_EXC_ERROR;

1930: G_PKG_NAME)
1931: THEN
1932: x_return_status := FND_API.G_RET_STS_ERROR;
1933: FND_MSG_PUB.ADD;
1934: RAISE FND_API.G_EXC_ERROR;
1935: END IF;
1936: -- Initialize message list if p_init_msg_list is set to TRUE.
1937: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1938: FND_MSG_PUB.initialize;

Line 1937: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1933: FND_MSG_PUB.ADD;
1934: RAISE FND_API.G_EXC_ERROR;
1935: END IF;
1936: -- Initialize message list if p_init_msg_list is set to TRUE.
1937: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1938: FND_MSG_PUB.initialize;
1939: END IF;
1940:
1941: -- Initialize API return status to success

Line 1942: x_return_status := FND_API.G_RET_STS_SUCCESS;

1938: FND_MSG_PUB.initialize;
1939: END IF;
1940:
1941: -- Initialize API return status to success
1942: x_return_status := FND_API.G_RET_STS_SUCCESS;
1943:
1944: -- Begin
1945:
1946:

Line 1959: ,p_container_pk1_value => l_directory_node_id) = FND_API.g_false

1955: p_instance_object_id => l_citem_object_type
1956: ,p_instance_pk1_value => l_content_item_id
1957: ,p_permission_code => 'CITEM_APPROVE_TRANSLATE'
1958: ,p_container_object_id => l_directory_object_type
1959: ,p_container_pk1_value => l_directory_node_id) = FND_API.g_false
1960: AND
1961: NVL(Fnd_Profile.Value_specific('IBC_USE_ACCESS_CONTROL',-999,-999,-999), 'N') = 'Y'
1962: THEN
1963: IBC_DATA_SECURITY_PVT.get_grantee_usernames(

Line 1974: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1970: ,x_return_status => x_return_status
1971: ,x_msg_count => x_msg_count
1972: ,x_msg_data => x_msg_data
1973: );
1974: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;
1977:
1978: IF l_user_list IS NULL THEN

Line 1975: RAISE FND_API.G_EXC_ERROR;

1971: ,x_msg_count => x_msg_count
1972: ,x_msg_data => x_msg_data
1973: );
1974: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;
1977:
1978: IF l_user_list IS NULL THEN
1979: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1979: x_return_status := FND_API.G_RET_STS_ERROR;

1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;
1977:
1978: IF l_user_list IS NULL THEN
1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980: FND_MESSAGE.Set_Name('IBC', 'IBC_NOT_APPROVER_DEFINED');
1981: FND_MSG_PUB.ADD;
1982: RAISE FND_API.G_EXC_ERROR;
1983: ELSE

Line 1982: RAISE FND_API.G_EXC_ERROR;

1978: IF l_user_list IS NULL THEN
1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980: FND_MESSAGE.Set_Name('IBC', 'IBC_NOT_APPROVER_DEFINED');
1981: FND_MSG_PUB.ADD;
1982: RAISE FND_API.G_EXC_ERROR;
1983: ELSE
1984: Create_Workflow_Role(p_user_list => l_user_list
1985: ,px_wf_role_name => l_wf_role_name
1986: ,px_wf_role_display_name => l_wf_role_display_name

Line 2014: ,p_commit => FND_API.g_false

2010: IBC_CITEM_ADMIN_GRP.Change_Translation_Status(
2011: p_citem_ver_id => p_citem_ver_id
2012: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED -- Change the status to approve
2013: ,p_language => p_language
2014: ,p_commit => FND_API.g_false
2015: ,p_init_msg_list => FND_API.g_true
2016: ,px_object_version_number => px_object_version_number
2017: ,x_return_status => x_return_status
2018: ,x_msg_count => x_msg_count

Line 2015: ,p_init_msg_list => FND_API.g_true

2011: p_citem_ver_id => p_citem_ver_id
2012: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED -- Change the status to approve
2013: ,p_language => p_language
2014: ,p_commit => FND_API.g_false
2015: ,p_init_msg_list => FND_API.g_true
2016: ,px_object_version_number => px_object_version_number
2017: ,x_return_status => x_return_status
2018: ,x_msg_count => x_msg_count
2019: ,x_msg_data => x_msg_data

Line 2022: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2018: ,x_msg_count => x_msg_count
2019: ,x_msg_data => x_msg_data
2020: );
2021:
2022: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2023: RAISE FND_API.G_EXC_ERROR;
2024: END IF;
2025:
2026: x_wf_item_key := -1;

Line 2023: RAISE FND_API.G_EXC_ERROR;

2019: ,x_msg_data => x_msg_data
2020: );
2021:
2022: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2023: RAISE FND_API.G_EXC_ERROR;
2024: END IF;
2025:
2026: x_wf_item_key := -1;
2027:

Line 2040: --,p_commit => FND_API.g_true

2036: ,p_message_name => 'IBC_TRANS_LOG_MSG'
2037: ,p_extra_info2_type => IBC_AUDIT_LOG_GRP.G_EI_LOOKUP
2038: ,p_extra_info2_ref_type => 'IBC_CITEM_VERSION_STATUS'
2039: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_APPROVED
2040: --,p_commit => FND_API.g_true
2041: ,p_init_msg_list => FND_API.g_true
2042: ,x_return_status => x_return_status
2043: ,x_msg_count => x_msg_count
2044: ,x_msg_data => x_msg_data

Line 2041: ,p_init_msg_list => FND_API.g_true

2037: ,p_extra_info2_type => IBC_AUDIT_LOG_GRP.G_EI_LOOKUP
2038: ,p_extra_info2_ref_type => 'IBC_CITEM_VERSION_STATUS'
2039: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_APPROVED
2040: --,p_commit => FND_API.g_true
2041: ,p_init_msg_list => FND_API.g_true
2042: ,x_return_status => x_return_status
2043: ,x_msg_count => x_msg_count
2044: ,x_msg_data => x_msg_data
2045: );

Line 2060: ,p_commit => FND_API.g_false

2056: IBC_CITEM_ADMIN_GRP.Change_Translation_Status(
2057: p_citem_ver_id => p_citem_ver_id
2058: ,p_new_status => IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL -- Change the status to submitted
2059: ,p_language => p_language
2060: ,p_commit => FND_API.g_false
2061: ,p_init_msg_list => FND_API.g_true
2062: ,px_object_version_number => px_object_version_number
2063: ,x_return_status => x_return_status
2064: ,x_msg_count => x_msg_count

Line 2061: ,p_init_msg_list => FND_API.g_true

2057: p_citem_ver_id => p_citem_ver_id
2058: ,p_new_status => IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL -- Change the status to submitted
2059: ,p_language => p_language
2060: ,p_commit => FND_API.g_false
2061: ,p_init_msg_list => FND_API.g_true
2062: ,px_object_version_number => px_object_version_number
2063: ,x_return_status => x_return_status
2064: ,x_msg_count => x_msg_count
2065: ,x_msg_data => x_msg_data

Line 2068: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2064: ,x_msg_count => x_msg_count
2065: ,x_msg_data => x_msg_data
2066: );
2067:
2068: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2069: RAISE FND_API.G_EXC_ERROR;
2070: END IF;
2071:
2072: --UI Logging

Line 2069: RAISE FND_API.G_EXC_ERROR;

2065: ,x_msg_data => x_msg_data
2066: );
2067:
2068: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2069: RAISE FND_API.G_EXC_ERROR;
2070: END IF;
2071:
2072: --UI Logging
2073: IBC_AUDIT_LOG_GRP.log_action(

Line 2084: --,p_commit => FND_API.g_true

2080: ,p_message_name => 'IBC_TRANS_LOG_MSG'
2081: ,p_extra_info2_type => IBC_AUDIT_LOG_GRP.G_EI_LOOKUP
2082: ,p_extra_info2_ref_type => 'IBC_CITEM_VERSION_STATUS'
2083: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL
2084: --,p_commit => FND_API.g_true
2085: ,p_init_msg_list => FND_API.g_true
2086: ,x_return_status => x_return_status
2087: ,x_msg_count => x_msg_count
2088: ,x_msg_data => x_msg_data

Line 2085: ,p_init_msg_list => FND_API.g_true

2081: ,p_extra_info2_type => IBC_AUDIT_LOG_GRP.G_EI_LOOKUP
2082: ,p_extra_info2_ref_type => 'IBC_CITEM_VERSION_STATUS'
2083: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL
2084: --,p_commit => FND_API.g_true
2085: ,p_init_msg_list => FND_API.g_true
2086: ,x_return_status => x_return_status
2087: ,x_msg_count => x_msg_count
2088: ,x_msg_data => x_msg_data
2089: );

Line 2302: IF (p_commit = FND_API.g_true) THEN

2298:
2299: END IF; -- End If of Conditionally invoking the WF
2300:
2301: -- COMMIT?
2302: IF (p_commit = FND_API.g_true) THEN
2303: COMMIT;
2304: END IF;
2305:
2306: -- Standard call to get message count and if count=1, get the message

Line 2310: WHEN FND_API.G_EXC_ERROR THEN

2306: -- Standard call to get message count and if count=1, get the message
2307: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2308: p_data => x_msg_data);
2309: EXCEPTION
2310: WHEN FND_API.G_EXC_ERROR THEN
2311: x_return_status := FND_API.G_RET_STS_ERROR;
2312: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2313: p_data => x_msg_data);
2314: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

Line 2311: x_return_status := FND_API.G_RET_STS_ERROR;

2307: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2308: p_data => x_msg_data);
2309: EXCEPTION
2310: WHEN FND_API.G_EXC_ERROR THEN
2311: x_return_status := FND_API.G_RET_STS_ERROR;
2312: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2313: p_data => x_msg_data);
2314: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2315: P_API_NAME => L_API_NAME

Line 2325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2321: ,X_MSG_COUNT => X_MSG_COUNT
2322: ,X_MSG_DATA => X_MSG_DATA
2323: ,X_RETURN_STATUS => X_RETURN_STATUS
2324: );
2325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2327: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2328: ,p_data => x_msg_data
2329: );

Line 2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2322: ,X_MSG_DATA => X_MSG_DATA
2323: ,X_RETURN_STATUS => X_RETURN_STATUS
2324: );
2325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2327: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2328: ,p_data => x_msg_data
2329: );
2330: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

Line 2342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2338: ,X_MSG_DATA => X_MSG_DATA
2339: ,X_RETURN_STATUS => X_RETURN_STATUS
2340: );
2341: WHEN OTHERS THEN
2342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2343: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2344: THEN
2345: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2346: END IF;

Line 2423: ,p_commit => FND_API.g_true

2419: IBC_CITEM_ADMIN_GRP.Change_Translation_Status(
2420: p_citem_ver_id => l_citem_ver_id
2421: ,p_new_status => IBC_UTILITIES_PUB.G_STV_REJECTED
2422: ,p_language => l_language
2423: ,p_commit => FND_API.g_true
2424: ,p_init_msg_list => FND_API.g_true
2425: ,px_object_version_number => l_object_version_number
2426: ,x_return_status => l_return_status
2427: ,x_msg_count => l_msg_count

Line 2424: ,p_init_msg_list => FND_API.g_true

2420: p_citem_ver_id => l_citem_ver_id
2421: ,p_new_status => IBC_UTILITIES_PUB.G_STV_REJECTED
2422: ,p_language => l_language
2423: ,p_commit => FND_API.g_true
2424: ,p_init_msg_list => FND_API.g_true
2425: ,px_object_version_number => l_object_version_number
2426: ,x_return_status => l_return_status
2427: ,x_msg_count => l_msg_count
2428: ,x_msg_data => l_msg_data

Line 2446: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2442: );
2443:
2444: END IF;
2445:
2446: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2447: -- Audit Log Action
2448: l_comments := WF_ENGINE.GetItemAttrText(itemtype => itemtype
2449: ,itemkey => itemkey
2450: ,aname => 'NOTES_TO_SUBMITTER'

Line 2466: --,p_commit => FND_API.g_true

2462: ,p_extra_info1_value => l_comments
2463: ,p_extra_info2_type => IBC_AUDIT_LOG_GRP.G_EI_LOOKUP
2464: ,p_extra_info2_ref_type => 'IBC_CITEM_VERSION_STATUS'
2465: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_REJECTED
2466: --,p_commit => FND_API.g_true
2467: ,p_init_msg_list => FND_API.g_true
2468: ,x_return_status => l_return_status
2469: ,x_msg_count => l_msg_count
2470: ,x_msg_data => l_msg_data

Line 2467: ,p_init_msg_list => FND_API.g_true

2463: ,p_extra_info2_type => IBC_AUDIT_LOG_GRP.G_EI_LOOKUP
2464: ,p_extra_info2_ref_type => 'IBC_CITEM_VERSION_STATUS'
2465: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_REJECTED
2466: --,p_commit => FND_API.g_true
2467: ,p_init_msg_list => FND_API.g_true
2468: ,x_return_status => l_return_status
2469: ,x_msg_count => l_msg_count
2470: ,x_msg_data => l_msg_data
2471: );

Line 2476: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2472:
2473:
2474: END IF;
2475:
2476: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2477: IBC_UTILITIES_PVT.Get_Messages(p_message_count => l_msg_count
2478: ,x_msgs => l_error_msg_stack
2479: );
2480:

Line 2553: ,p_commit => FND_API.g_true

2549: IBC_CITEM_ADMIN_GRP.Change_Translation_Status(
2550: p_citem_ver_id => l_citem_ver_id
2551: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED
2552: ,p_language => l_language
2553: ,p_commit => FND_API.g_true
2554: ,p_init_msg_list => FND_API.g_true
2555: ,px_object_version_number => l_object_version_number
2556: ,x_return_status => l_return_status
2557: ,x_msg_count => l_msg_count

Line 2554: ,p_init_msg_list => FND_API.g_true

2550: p_citem_ver_id => l_citem_ver_id
2551: ,p_new_status => IBC_UTILITIES_PUB.G_STV_APPROVED
2552: ,p_language => l_language
2553: ,p_commit => FND_API.g_true
2554: ,p_init_msg_list => FND_API.g_true
2555: ,px_object_version_number => l_object_version_number
2556: ,x_return_status => l_return_status
2557: ,x_msg_count => l_msg_count
2558: ,x_msg_data => l_msg_data

Line 2562: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2558: ,x_msg_data => l_msg_data
2559: );
2560:
2561:
2562: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2563: WF_ENGINE.SetItemAttrText(itemtype => itemtype
2564: ,itemkey => itemkey
2565: ,aname => 'APPROVER_NAME'
2566: ,avalue => get_user_description(FND_GLOBAL.user_id)

Line 2600: --,p_commit => FND_API.g_true

2596: ,p_message_name => 'IBC_TRANS_LOG_MSG'
2597: ,p_extra_info2_type => IBC_AUDIT_LOG_GRP.G_EI_LOOKUP
2598: ,p_extra_info2_ref_type => 'IBC_CITEM_VERSION_STATUS'
2599: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_APPROVED
2600: --,p_commit => FND_API.g_true
2601: ,p_init_msg_list => FND_API.g_true
2602: ,x_return_status => l_return_status
2603: ,x_msg_count => l_msg_count
2604: ,x_msg_data => l_msg_data

Line 2601: ,p_init_msg_list => FND_API.g_true

2597: ,p_extra_info2_type => IBC_AUDIT_LOG_GRP.G_EI_LOOKUP
2598: ,p_extra_info2_ref_type => 'IBC_CITEM_VERSION_STATUS'
2599: ,p_extra_info2_value => IBC_UTILITIES_PUB.G_STV_APPROVED
2600: --,p_commit => FND_API.g_true
2601: ,p_init_msg_list => FND_API.g_true
2602: ,x_return_status => l_return_status
2603: ,x_msg_count => l_msg_count
2604: ,x_msg_data => l_msg_data
2605: );

Line 2609: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2605: );
2606:
2607: END IF;
2608:
2609: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2610: -- IF l_return_status not successful then return 'N'
2611: result := 'COMPLETE:N';
2612: IBC_UTILITIES_PVT.Get_Messages(p_message_count => l_msg_count
2613: ,x_msgs => l_error_msg_stack

Line 2722: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2718: ,x_msg_count => l_msg_count
2719: ,x_msg_data => l_msg_data
2720: );
2721:
2722: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2723:
2724: IF l_item_approve_users IS NOT NULL THEN
2725: -- Preparing list of users so it can be used in Query as a pattern
2726: l_item_approve_users := '[' || REPLACE(l_item_approve_users, ',', '][') || ']';

Line 2866: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2862: ,x_msg_count => x_msg_count
2863: ,x_msg_data => x_msg_data
2864: );
2865:
2866: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2867: RAISE FND_API.G_EXC_ERROR;
2868: END IF;
2869:
2870: IF l_user_list IS NULL THEN

Line 2867: RAISE FND_API.G_EXC_ERROR;

2863: ,x_msg_data => x_msg_data
2864: );
2865:
2866: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2867: RAISE FND_API.G_EXC_ERROR;
2868: END IF;
2869:
2870: IF l_user_list IS NULL THEN
2871: --x_return_status := FND_API.G_RET_STS_ERROR;

Line 2871: --x_return_status := FND_API.G_RET_STS_ERROR;

2867: RAISE FND_API.G_EXC_ERROR;
2868: END IF;
2869:
2870: IF l_user_list IS NULL THEN
2871: --x_return_status := FND_API.G_RET_STS_ERROR;
2872: --FND_MESSAGE.Set_Name('IBC', 'IBC_NOT_APPROVER_DEFINED');
2873: --FND_MSG_PUB.ADD;
2874: --RAISE FND_API.G_EXC_ERROR;
2875: return;

Line 2874: --RAISE FND_API.G_EXC_ERROR;

2870: IF l_user_list IS NULL THEN
2871: --x_return_status := FND_API.G_RET_STS_ERROR;
2872: --FND_MESSAGE.Set_Name('IBC', 'IBC_NOT_APPROVER_DEFINED');
2873: --FND_MSG_PUB.ADD;
2874: --RAISE FND_API.G_EXC_ERROR;
2875: return;
2876: ELSE
2877: Create_Workflow_Role(p_user_list => l_user_list
2878: ,px_wf_role_name => l_wf_role_name

Line 2939: WHEN FND_API.G_EXC_ERROR THEN

2935:
2936: Wf_Notification.Denormalize_Notification(l_notif_id);
2937:
2938: EXCEPTION
2939: WHEN FND_API.G_EXC_ERROR THEN
2940: x_return_status := FND_API.G_RET_STS_ERROR;
2941: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2942: p_data => x_msg_data);
2943: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

Line 2940: x_return_status := FND_API.G_RET_STS_ERROR;

2936: Wf_Notification.Denormalize_Notification(l_notif_id);
2937:
2938: EXCEPTION
2939: WHEN FND_API.G_EXC_ERROR THEN
2940: x_return_status := FND_API.G_RET_STS_ERROR;
2941: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2942: p_data => x_msg_data);
2943: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2944: P_API_NAME => L_API_NAME

Line 3052: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3048: ,x_msg_count => x_msg_count
3049: ,x_msg_data => x_msg_data
3050: );
3051:
3052: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3053: RAISE FND_API.G_EXC_ERROR;
3054: END IF;
3055:
3056: IF l_user_list IS NULL THEN

Line 3053: RAISE FND_API.G_EXC_ERROR;

3049: ,x_msg_data => x_msg_data
3050: );
3051:
3052: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3053: RAISE FND_API.G_EXC_ERROR;
3054: END IF;
3055:
3056: IF l_user_list IS NULL THEN
3057: RETURN;

Line 3101: WHEN FND_API.G_EXC_ERROR THEN

3097:
3098: Wf_Notification.Denormalize_Notification(l_notif_id);
3099:
3100: EXCEPTION
3101: WHEN FND_API.G_EXC_ERROR THEN
3102: x_return_status := FND_API.G_RET_STS_ERROR;
3103: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3104: p_data => x_msg_data);
3105: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

Line 3102: x_return_status := FND_API.G_RET_STS_ERROR;

3098: Wf_Notification.Denormalize_Notification(l_notif_id);
3099:
3100: EXCEPTION
3101: WHEN FND_API.G_EXC_ERROR THEN
3102: x_return_status := FND_API.G_RET_STS_ERROR;
3103: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3104: p_data => x_msg_data);
3105: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3106: P_API_NAME => L_API_NAME