DBA Data[Home] [Help]

APPS.QA_CHAR_UPDATE_PKG dependencies on FND_API

Line 90: p_init_msg_list => FND_API.G_TRUE,

86: -- Elements. ( In this case the "Send Notification To" Element )
87: Update_Element_Value
88: (
89: p_api_version => 1.0,
90: p_init_msg_list => FND_API.G_TRUE,
91: p_commit => FND_API.G_TRUE,
92: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
93: p_char_id => QA_SS_CONST.send_notification_to,
94: p_old_value => l_old_user_name,

Line 91: p_commit => FND_API.G_TRUE,

87: Update_Element_Value
88: (
89: p_api_version => 1.0,
90: p_init_msg_list => FND_API.G_TRUE,
91: p_commit => FND_API.G_TRUE,
92: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
93: p_char_id => QA_SS_CONST.send_notification_to,
94: p_old_value => l_old_user_name,
95: p_new_value => l_new_user_name,

Line 92: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

88: (
89: p_api_version => 1.0,
90: p_init_msg_list => FND_API.G_TRUE,
91: p_commit => FND_API.G_TRUE,
92: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
93: p_char_id => QA_SS_CONST.send_notification_to,
94: p_old_value => l_old_user_name,
95: p_new_value => l_new_user_name,
96: x_return_status => l_return_status,

Line 111: IF ( l_return_status = FND_API.G_RET_STS_ERROR OR

107: );
108: END IF;
109:
110: -- Error Handling
111: IF ( l_return_status = FND_API.G_RET_STS_ERROR OR
112: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
113:
114: -- Get all Error Messages
115: FOR I IN 1..l_msg_count LOOP

Line 112: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

108: END IF;
109:
110: -- Error Handling
111: IF ( l_return_status = FND_API.G_RET_STS_ERROR OR
112: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
113:
114: -- Get all Error Messages
115: FOR I IN 1..l_msg_count LOOP
116: FND_MSG_PUB.get

Line 119: p_encoded => FND_API.G_FALSE,

115: FOR I IN 1..l_msg_count LOOP
116: FND_MSG_PUB.get
117: (
118: p_msg_index => I,
119: p_encoded => FND_API.G_FALSE,
120: p_data => l_msg_data,
121: p_msg_index_out => l_msg_index_out
122: );
123:

Line 734: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );

730: l_plans_exist VARCHAR2(1);
731: l_commit BOOLEAN;
732:
733: BEGIN
734: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
735:
736: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
737: FND_LOG.string
738: (

Line 749: IF NOT FND_API.Compatible_API_Call

745: -- Standard Start of API savepoint
746: SAVEPOINT Update_Element_Value_PKG;
747:
748: -- Standard call to check for call compatibility.
749: IF NOT FND_API.Compatible_API_Call
750: (
751: l_api_version,
752: NVL( p_api_version, 1.0 ),
753: l_api_name,

Line 756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

752: NVL( p_api_version, 1.0 ),
753: l_api_name,
754: g_pkg_name
755: ) THEN
756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: END IF;
758:
759: -- Initialize message list if p_init_msg_list is set to TRUE.
760: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

Line 760: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: END IF;
758:
759: -- Initialize message list if p_init_msg_list is set to TRUE.
760: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN
761: FND_MSG_PUB.initialize;
762: END IF;
763:
764: -- Initialize API return status to success

Line 765: x_return_status := FND_API.G_RET_STS_SUCCESS;

761: FND_MSG_PUB.initialize;
762: END IF;
763:
764: -- Initialize API return status to success
765: x_return_status := FND_API.G_RET_STS_SUCCESS;
766:
767: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
768: FND_LOG.string
769: (

Line 974: WHEN FND_API.G_EXC_ERROR THEN

970: END IF;
971:
972: EXCEPTION
973:
974: WHEN FND_API.G_EXC_ERROR THEN
975: ROLLBACK TO Update_Element_Value_PKG;
976: x_return_status := FND_API.G_RET_STS_ERROR;
977: FND_MSG_PUB.Count_And_Get
978: (

Line 976: x_return_status := FND_API.G_RET_STS_ERROR;

972: EXCEPTION
973:
974: WHEN FND_API.G_EXC_ERROR THEN
975: ROLLBACK TO Update_Element_Value_PKG;
976: x_return_status := FND_API.G_RET_STS_ERROR;
977: FND_MSG_PUB.Count_And_Get
978: (
979: p_count => x_msg_count,
980: p_data => x_msg_data

Line 992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

988: 'Exiting Procedure: Error'
989: );
990: END IF;
991:
992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
993: ROLLBACK TO Update_Element_Value_PKG;
994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
995: FND_MSG_PUB.Count_And_Get
996: (

Line 994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

990: END IF;
991:
992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
993: ROLLBACK TO Update_Element_Value_PKG;
994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
995: FND_MSG_PUB.Count_And_Get
996: (
997: p_count => x_msg_count,
998: p_data => x_msg_data

Line 1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1008: END IF;
1009:
1010: WHEN OTHERS THEN
1011: ROLLBACK TO Update_Element_Value_PKG;
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1013: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
1014: FND_MSG_PUB.Add_Exc_Msg
1015: (
1016: p_pkg_name => g_pkg_name,