DBA Data[Home] [Help]

APPS.INV_ITEM_STATUS_CP dependencies on FND_API

Line 58: ,p_commit IN VARCHAR2:= FND_API.g_TRUE

54: PROCEDURE update_item_attributes(p_pending_status IN VARCHAR2
55: ,p_control_level IN NUMBER
56: ,p_Org_Id IN NUMBER
57: ,p_Item_id IN NUMBER
58: ,p_commit IN VARCHAR2:= FND_API.g_TRUE
59: ,p_return_status OUT NOCOPY BOOLEAN)
60:
61: IS
62: /* Start Bug#7454766

Line 553: IF FND_API.To_Boolean (p_commit) THEN

549: /*end if;*/
550:
551: /*End Bug#7454766 */
552:
553: IF FND_API.To_Boolean (p_commit) THEN
554: COMMIT WORK;
555: END IF;
556:
557: p_return_status := TRUE;

Line 586: ,p_commit IN VARCHAR2 := FND_API.g_TRUE

582: PROCEDURE Process_Pending_Status(ERRBUF OUT NOCOPY VARCHAR2
583: ,RETCODE OUT NOCOPY NUMBER
584: ,p_Org_Id IN NUMBER := NULL
585: ,p_Item_Id IN NUMBER := NULL
586: ,p_commit IN VARCHAR2 := FND_API.g_TRUE
587: ,p_prog_appid IN NUMBER := NULL
588: ,p_prog_id IN NUMBER := NULL
589: ,p_request_id IN NUMBER := NULL
590: ,p_user_id IN NUMBER := NULL

Line 592: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

588: ,p_prog_id IN NUMBER := NULL
589: ,p_request_id IN NUMBER := NULL
590: ,p_user_id IN NUMBER := NULL
591: ,p_login_id IN NUMBER := NULL
592: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
593: ,p_msg_logname IN VARCHAR2 := 'FILE')
594: IS
595: CURSOR c_status_pending_items (cp_org_id NUMBER
596: ,cp_item_id NUMBER)

Line 667: IF FND_API.To_Boolean (p_init_msg_list) THEN

663: INV_ITEM_MSG.Initialize;
664: INV_ITEM_MSG.set_Message_Mode (p_msg_logname);
665: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);
666:
667: IF FND_API.To_Boolean (p_init_msg_list) THEN
668: INV_ITEM_MSG.Initialize_Error_Handler;
669: END IF;
670:
671: --13962600: LCP should not change when any expried status exists

Line 854: PROCEDURE Create_Item_ERES_Event ( p_commit IN VARCHAR2 := fnd_api.g_false,

850: END Process_Pending_Status;
851:
852: -- Fix for bug#9297937
853: -- ERES in Deferred during Item Creation
854: PROCEDURE Create_Item_ERES_Event ( p_commit IN VARCHAR2 := fnd_api.g_false,
855: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
856: p_event_name IN VARCHAR2,
857: p_event_key IN VARCHAR2,
858: p_caller_type IN VARCHAR2,

Line 855: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

851:
852: -- Fix for bug#9297937
853: -- ERES in Deferred during Item Creation
854: PROCEDURE Create_Item_ERES_Event ( p_commit IN VARCHAR2 := fnd_api.g_false,
855: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
856: p_event_name IN VARCHAR2,
857: p_event_key IN VARCHAR2,
858: p_caller_type IN VARCHAR2,
859: p_org_id IN NUMBER,

Line 887: p_commit IN VARCHAR2 := fnd_api.g_false,

883: -- Fix for bug#9297937
884: -- ERES in Deferred during Item Creation
885: PROCEDURE Create_Item_ERES_Event
886: (
887: p_commit IN VARCHAR2 := fnd_api.g_false,
888: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
889: p_event_name IN VARCHAR2,
890: p_event_key IN VARCHAR2,
891: p_caller_type IN VARCHAR2,

Line 888: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

884: -- ERES in Deferred during Item Creation
885: PROCEDURE Create_Item_ERES_Event
886: (
887: p_commit IN VARCHAR2 := fnd_api.g_false,
888: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
889: p_event_name IN VARCHAR2,
890: p_event_key IN VARCHAR2,
891: p_caller_type IN VARCHAR2,
892: p_org_id IN NUMBER,

Line 918: IF FND_API.to_Boolean( p_init_msg_list ) THEN

914: -- Standard Start of API savepoint
915: SAVEPOINT create_item_eres_event;
916:
917: -- Initialize message list if p_init_msg_list is set to TRUE.
918: IF FND_API.to_Boolean( p_init_msg_list ) THEN
919: FND_MSG_PUB.initialize;
920: END IF;
921:
922: -- Initialize API return status to success

Line 923: x_return_status := FND_API.g_RET_STS_SUCCESS;

919: FND_MSG_PUB.initialize;
920: END IF;
921:
922: -- Initialize API return status to success
923: x_return_status := FND_API.g_RET_STS_SUCCESS;
924:
925: -- Derive the control level
926: OPEN c_get_control_level;
927: FETCH c_get_control_level INTO l_control_level;

Line 961: ,p_commit => FND_API.g_TRUE

957: update_item_attributes(p_pending_status => l_status_code
958: ,p_control_level => l_control_level
959: ,p_Org_Id => p_org_id
960: ,p_Item_id => p_inventory_item_id
961: ,p_commit => FND_API.g_TRUE
962: ,p_return_status => l_return_status);
963:
964: -- Check if there are any errors
965: IF ( NOT l_return_status ) THEN

Line 1015: RAISE FND_API.G_EXC_ERROR;

1011: G_PURCHASABLE := 0;
1012:
1013: END IF;
1014:
1015: RAISE FND_API.G_EXC_ERROR;
1016:
1017: END IF;
1018:
1019: END IF;

Line 1022: IF FND_API.To_Boolean( p_commit) THEN

1018:
1019: END IF;
1020:
1021: -- Standard check of p_commit.
1022: IF FND_API.To_Boolean( p_commit) THEN
1023: COMMIT WORK;
1024: END IF;
1025:
1026: FND_MSG_PUB.Count_And_Get

Line 1033: WHEN FND_API.G_EXC_ERROR THEN

1029: );
1030:
1031:
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: ROLLBACK TO create_item_eres_event;
1035: x_return_status := FND_API.G_RET_STS_ERROR ;
1036: FND_MSG_PUB.Count_And_Get
1037: (p_count => x_msg_count,

Line 1035: x_return_status := FND_API.G_RET_STS_ERROR ;

1031:
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: ROLLBACK TO create_item_eres_event;
1035: x_return_status := FND_API.G_RET_STS_ERROR ;
1036: FND_MSG_PUB.Count_And_Get
1037: (p_count => x_msg_count,
1038: p_data => x_msg_data );
1039:

Line 1042: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

1038: p_data => x_msg_data );
1039:
1040: WHEN OTHERS THEN
1041: ROLLBACK TO create_item_eres_event;
1042: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
1043:
1044: IF FND_MSG_PUB.Check_Msg_Level
1045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1046: THEN