APPS.IGW_PROP_RATES_PVT dependencies on FND_API

Line 5: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

1: PACKAGE BODY IGW_PROP_RATES_PVT AS
2: -- $Header: igwvprtb.pls 115.5 2002/11/15 00:44:31 ashkumar ship $
3:
4: procedure PROCESS_PROP_RATES
5: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
7: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
8: ,p_proposal_id NUMBER
9: ,p_version_id NUMBER

Line 6: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2: -- $Header: igwvprtb.pls 115.5 2002/11/15 00:44:31 ashkumar ship $
3:
4: procedure PROCESS_PROP_RATES
5: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
7: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
8: ,p_proposal_id NUMBER
9: ,p_version_id NUMBER
10: ,p_rate_class_id NUMBER

Line 7: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

3:
4: procedure PROCESS_PROP_RATES
5: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
7: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
8: ,p_proposal_id NUMBER
9: ,p_version_id NUMBER
10: ,p_rate_class_id NUMBER
11: ,p_rate_type_id NUMBER

Line 42: IF p_commit = FND_API.G_TRUE THEN

38: l_data VARCHAR2(250);
39: l_msg_index_out NUMBER;
40:
41: BEGIN
42: IF p_commit = FND_API.G_TRUE THEN
43: SAVEPOINT process_prop_rates;
44: END IF;
45:
46: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

Line 46: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

42: IF p_commit = FND_API.G_TRUE THEN
43: SAVEPOINT process_prop_rates;
44: END IF;
45:
46: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
47: fnd_msg_pub.initialize;
48: end if;
49:
50: x_return_status := 'S';

Line 51: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then

47: fnd_msg_pub.initialize;
48: end if;
49:
50: x_return_status := 'S';
51: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
52: open c_rates;
53: fetch c_rates into p_rowid;
54: if (c_rates%notfound) then
55: igw_prop_rates_tbh.insert_row(

Line 103: (p_encoded => FND_API.G_TRUE ,

99: If l_msg_count > 0 THEN
100: x_msg_count := l_msg_count;
101: If l_msg_count = 1 THEN
102: fnd_msg_pub.get
103: (p_encoded => FND_API.G_TRUE ,
104: p_msg_index => 1,
105: p_data => l_data,
106: p_msg_index_out => l_msg_index_out );
107:

Line 110: RAISE FND_API.G_EXC_ERROR;

106: p_msg_index_out => l_msg_index_out );
107:
108: x_msg_data := l_data;
109: End if;
110: RAISE FND_API.G_EXC_ERROR;
111: End if;
112:
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114:

Line 113: x_return_status := FND_API.G_RET_STS_SUCCESS;

109: End if;
110: RAISE FND_API.G_EXC_ERROR;
111: End if;
112:
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114:
115: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: IF p_commit = FND_API.G_TRUE THEN
117: ROLLBACK TO process_prop_rates;

Line 115: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

111: End if;
112:
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114:
115: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: IF p_commit = FND_API.G_TRUE THEN
117: ROLLBACK TO process_prop_rates;
118: END IF;
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 116: IF p_commit = FND_API.G_TRUE THEN

112:
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114:
115: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: IF p_commit = FND_API.G_TRUE THEN
117: ROLLBACK TO process_prop_rates;
118: END IF;
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
120: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

Line 119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

115: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: IF p_commit = FND_API.G_TRUE THEN
117: ROLLBACK TO process_prop_rates;
118: END IF;
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
120: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
121: p_procedure_name => l_api_name,
122: p_error_text => SUBSTRB(SQLERRM,1,240));
123: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

121: p_procedure_name => l_api_name,
122: p_error_text => SUBSTRB(SQLERRM,1,240));
123: fnd_msg_pub.count_and_get(p_count => x_msg_count
124: ,p_data => x_msg_data);
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126:
127: WHEN FND_API.G_EXC_ERROR THEN
128: IF p_commit = FND_API.G_TRUE THEN
129: ROLLBACK TO process_prop_rates;

Line 127: WHEN FND_API.G_EXC_ERROR THEN

123: fnd_msg_pub.count_and_get(p_count => x_msg_count
124: ,p_data => x_msg_data);
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126:
127: WHEN FND_API.G_EXC_ERROR THEN
128: IF p_commit = FND_API.G_TRUE THEN
129: ROLLBACK TO process_prop_rates;
130: END IF;
131: x_return_status := 'E';

Line 128: IF p_commit = FND_API.G_TRUE THEN

124: ,p_data => x_msg_data);
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126:
127: WHEN FND_API.G_EXC_ERROR THEN
128: IF p_commit = FND_API.G_TRUE THEN
129: ROLLBACK TO process_prop_rates;
130: END IF;
131: x_return_status := 'E';
132:

Line 134: IF p_commit = FND_API.G_TRUE THEN

130: END IF;
131: x_return_status := 'E';
132:
133: WHEN OTHERS THEN
134: IF p_commit = FND_API.G_TRUE THEN
135: ROLLBACK TO process_prop_rates;
136: END IF;
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

Line 137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

133: WHEN OTHERS THEN
134: IF p_commit = FND_API.G_TRUE THEN
135: ROLLBACK TO process_prop_rates;
136: END IF;
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
139: p_procedure_name => l_api_name,
140: p_error_text => SUBSTRB(SQLERRM,1,240));
141: fnd_msg_pub.count_and_get(p_count => x_msg_count