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.

[Home] [Help]

APPS.PA_ACTION_SETS_PUB dependencies on FND_API

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

28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
31: ,p_api_version IN NUMBER := 1.0
32: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
33: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
34: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
35: ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
36: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
31: ,p_api_version IN NUMBER := 1.0
32: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
33: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
34: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
35: ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
36: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
37: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
31: ,p_api_version IN NUMBER := 1.0
32: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
33: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
34: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
35: ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
36: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
37: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
38: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 55: x_return_status := FND_API.G_RET_STS_SUCCESS;

51: -- Bug 4403338
52: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
53:
54: -- Initialize the return status to success
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: --Clear the global PL/SQL message table
58: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
59: FND_MSG_PUB.initialize;

Line 58: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

54: -- Initialize the return status to success
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: --Clear the global PL/SQL message table
58: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61:
62: -- Issue API savepoint if the transaction is to be committed

Line 63: IF p_commit = FND_API.G_TRUE THEN

59: FND_MSG_PUB.initialize;
60: END IF;
61:
62: -- Issue API savepoint if the transaction is to be committed
63: IF p_commit = FND_API.G_TRUE THEN
64: SAVEPOINT CREATE_ACTION_SETS_PUB;
65: END IF;
66:
67: --Log Message: 4403338

Line 111: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

107: ,x_return_status => l_return_status);
108:
109: x_msg_count := FND_MSG_PUB.Count_Msg;
110: IF x_msg_count = 1 THEN
111: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
112: ,p_msg_index => 1
113: ,p_data => x_msg_data
114: ,p_msg_index_out => l_msg_index_out
115: );

Line 123: x_return_status := FND_API.G_RET_STS_ERROR;

119: PA_DEBUG.Reset_Err_Stack;
120: -- If any errors exist then set the x_return_status to 'E'
121:
122: IF x_msg_count > 0 THEN
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: END IF;
125:
126: -- Commit if the flag is set and there is no error
127: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 127: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

123: x_return_status := FND_API.G_RET_STS_ERROR;
124: END IF;
125:
126: -- Commit if the flag is set and there is no error
127: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
128: COMMIT;
129: END IF;
130:
131: EXCEPTION

Line 133: IF p_commit = FND_API.G_TRUE THEN

129: END IF;
130:
131: EXCEPTION
132: WHEN OTHERS THEN
133: IF p_commit = FND_API.G_TRUE THEN
134: ROLLBACK TO CREATE_ACTION_SETS_PUB;
135: END IF;
136:
137: -- Set the excetption Message and the stack

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

137: -- Set the excetption Message and the stack
138: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Create_Action_Set'
139: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
140: --
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
142: RAISE;
143:
144: END Create_Action_Set;
145:

Line 149: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR

145:
146:
147: PROCEDURE update_action_set
148: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
149: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
150: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE

Line 150: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR

146:
147: PROCEDURE update_action_set
148: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
149: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
150: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE

Line 151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR

147: PROCEDURE update_action_set
148: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
149: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
150: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR

Line 152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM

148: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
149: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
150: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR

Line 153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE

149: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
150: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR

Line 154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE

150: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE

Line 155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR

151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR

Line 156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR

152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR

Line 157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR

153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR

155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR

Line 160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR

156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR

Line 161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR

157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR

Line 162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR

158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR

Line 163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR

159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR

Line 164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR

160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR

Line 165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR

161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR

Line 166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR

162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR

Line 167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR

163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR

Line 168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR

164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR

Line 169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR

165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR

Line 170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR

166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
174: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR

Line 171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR

167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
174: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
175: ,p_api_version IN NUMBER := 1.0

Line 172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR

168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
174: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 173: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR

169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
174: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 174: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR

170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
174: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
174: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
179: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
180: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

173: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
174: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
179: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
180: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
181: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

174: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
179: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
180: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
181: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
182: )

Line 200: x_return_status := FND_API.G_RET_STS_SUCCESS;

196: -- Bug 4403338
197: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
198:
199: -- Initialize the return status to success
200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201:
202: --Clear the global PL/SQL message table
203: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
204: FND_MSG_PUB.initialize;

Line 203: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

199: -- Initialize the return status to success
200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201:
202: --Clear the global PL/SQL message table
203: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
204: FND_MSG_PUB.initialize;
205: END IF;
206:
207: -- Issue API savepoint if the transaction is to be committed

Line 208: IF p_commit = FND_API.G_TRUE THEN

204: FND_MSG_PUB.initialize;
205: END IF;
206:
207: -- Issue API savepoint if the transaction is to be committed
208: IF p_commit = FND_API.G_TRUE THEN
209: SAVEPOINT UPDATE_ACTION_SETS_PUB;
210: END IF;
211:
212: --Log Message: 4403338

Line 279: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

275:
276:
277: x_msg_count := FND_MSG_PUB.Count_Msg;
278: IF x_msg_count = 1 THEN
279: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
280: ,p_msg_index => 1
281: ,p_data => x_msg_data
282: ,p_msg_index_out => l_msg_index_out
283: );

Line 291: x_return_status := FND_API.G_RET_STS_ERROR;

287: PA_DEBUG.Reset_Err_Stack;
288: -- If any errors exist then set the x_return_status to 'E'
289:
290: IF x_msg_count > 0 THEN
291: x_return_status := FND_API.G_RET_STS_ERROR;
292: END IF;
293:
294: -- Commit if the flag is set and there is no error
295: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 295: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

291: x_return_status := FND_API.G_RET_STS_ERROR;
292: END IF;
293:
294: -- Commit if the flag is set and there is no error
295: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
296: COMMIT;
297: END IF;
298:
299: EXCEPTION

Line 301: IF p_commit = FND_API.G_TRUE THEN

297: END IF;
298:
299: EXCEPTION
300: WHEN OTHERS THEN
301: IF p_commit = FND_API.G_TRUE THEN
302: ROLLBACK TO UPDATE_ACTION_SETS_PUB;
303: END IF;
304:
305: -- Set the excetption Message and the stack

Line 309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

305: -- Set the excetption Message and the stack
306: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Update_Action_Set'
307: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
308: --
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: RAISE;
311:
312: END Update_Action_Set;
313:

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

318: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
319: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
320: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
321: ,p_api_version IN NUMBER := 1.0
322: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
323: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
324: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
325: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
326: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

319: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
320: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
321: ,p_api_version IN NUMBER := 1.0
322: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
323: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
324: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
325: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
326: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
327: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

320: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
321: ,p_api_version IN NUMBER := 1.0
322: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
323: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
324: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
325: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
326: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
327: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
328: )

Line 351: x_return_status := FND_API.G_RET_STS_SUCCESS;

347: -- Bug 4403338
348: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
349:
350: -- Initialize the return status to success
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352:
353: --Clear the global PL/SQL message table
354: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
355: FND_MSG_PUB.initialize;

Line 354: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

350: -- Initialize the return status to success
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352:
353: --Clear the global PL/SQL message table
354: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
355: FND_MSG_PUB.initialize;
356: END IF;
357:
358: -- 5130421

Line 362: IF p_commit = FND_API.G_TRUE THEN

358: -- 5130421
359: l_start_msg_count := FND_MSG_PUB.count_msg ;
360:
361: -- Issue API savepoint if the transaction is to be committed
362: IF p_commit = FND_API.G_TRUE THEN
363: SAVEPOINT Delete_ACTION_SETS_PUB;
364: END IF;
365:
366: --Log Message: 4403338

Line 417: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

413: l_current_api_msg_count := l_end_msg_count - l_start_msg_count;
414:
415: -- 5130421 IF x_msg_count = 1 THEN
416: IF l_current_api_msg_count = 1 THEN
417: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
418: ,p_msg_index => 1
419: ,p_data => x_msg_data
420: ,p_msg_index_out => l_msg_index_out
421: );

Line 430: x_return_status := FND_API.G_RET_STS_ERROR;

426: -- If any errors exist then set the x_return_status to 'E'
427:
428: -- 5130421 IF x_msg_count > 0 THEN
429: IF l_current_api_msg_count > 0 THEN
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: END IF;
432:
433: -- Commit if the flag is set and there is no error
434: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 434: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

430: x_return_status := FND_API.G_RET_STS_ERROR;
431: END IF;
432:
433: -- Commit if the flag is set and there is no error
434: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
435: COMMIT;
436: END IF;
437:
438: EXCEPTION

Line 440: IF p_commit = FND_API.G_TRUE THEN

436: END IF;
437:
438: EXCEPTION
439: WHEN OTHERS THEN
440: IF p_commit = FND_API.G_TRUE THEN
441: ROLLBACK TO Delete_ACTION_SETS_PUB;
442: END IF;
443:
444: -- Set the excetption Message and the stack

Line 448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

444: -- Set the excetption Message and the stack
445: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Delete_Action_Set'
446: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
447: --
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
449: RAISE;
450:
451: END Delete_Action_Set;
452:

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

470: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
471: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
472: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
473: ,p_api_version IN NUMBER := 1.0
474: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
475: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
476: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
477: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
478: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

471: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
472: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
473: ,p_api_version IN NUMBER := 1.0
474: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
475: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
476: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
477: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
478: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
479: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

472: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
473: ,p_api_version IN NUMBER := 1.0
474: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
475: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
476: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
477: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
478: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
479: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
480: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 497: x_return_status := FND_API.G_RET_STS_SUCCESS;

493: -- Bug 4403338
494: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
495:
496: -- Initialize the return status to success
497: x_return_status := FND_API.G_RET_STS_SUCCESS;
498:
499: --Clear the global PL/SQL message table
500: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
501: FND_MSG_PUB.initialize;

Line 500: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

496: -- Initialize the return status to success
497: x_return_status := FND_API.G_RET_STS_SUCCESS;
498:
499: --Clear the global PL/SQL message table
500: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
501: FND_MSG_PUB.initialize;
502: END IF;
503:
504: -- Issue API savepoint if the transaction is to be committed

Line 505: IF p_commit = FND_API.G_TRUE THEN

501: FND_MSG_PUB.initialize;
502: END IF;
503:
504: -- Issue API savepoint if the transaction is to be committed
505: IF p_commit = FND_API.G_TRUE THEN
506: SAVEPOINT CREATE_ACTION_SET_LINE_PUB;
507: END IF;
508:
509: --Log Message: 4403338

Line 542: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

538: ,x_return_status => l_return_status);
539:
540: x_msg_count := FND_MSG_PUB.Count_Msg;
541: IF x_msg_count = 1 THEN
542: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
543: ,p_msg_index => 1
544: ,p_data => x_msg_data
545: ,p_msg_index_out => l_msg_index_out
546: );

Line 554: x_return_status := FND_API.G_RET_STS_ERROR;

550: PA_DEBUG.Reset_Err_Stack;
551: -- If any errors exist then set the x_return_status to 'E'
552:
553: IF x_msg_count > 0 THEN
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: END IF;
556:
557: -- Commit if the flag is set and there is no error
558: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 558: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

554: x_return_status := FND_API.G_RET_STS_ERROR;
555: END IF;
556:
557: -- Commit if the flag is set and there is no error
558: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
559: COMMIT;
560: END IF;
561:
562: EXCEPTION

Line 564: IF p_commit = FND_API.G_TRUE THEN

560: END IF;
561:
562: EXCEPTION
563: WHEN OTHERS THEN
564: IF p_commit = FND_API.G_TRUE THEN
565: ROLLBACK TO CREATE_ACTION_SET_LINE_PUB;
566: END IF;
567:
568: -- Set the excetption Message and the stack

Line 572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

568: -- Set the excetption Message and the stack
569: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Create_Action_Set_Line'
570: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
571: --
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
573: RAISE;
574:
575: END Create_Action_Set_Line;
576:

Line 581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM

577:
578: PROCEDURE update_action_set_line
579: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
580: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR

Line 583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR

579: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
580: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR

Line 584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR

580: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR

Line 585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR

581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR

Line 586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR

582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR

Line 587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR

583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR

Line 588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR

584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR

Line 589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR

585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR

Line 590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR

586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR

Line 591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR

587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type

Line 592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR

588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
596: ,p_api_version IN NUMBER := 1.0

Line 593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR

589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
596: ,p_api_version IN NUMBER := 1.0
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR

590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
596: ,p_api_version IN NUMBER := 1.0
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
598: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
596: ,p_api_version IN NUMBER := 1.0
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
598: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
599: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
600: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
601: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
596: ,p_api_version IN NUMBER := 1.0
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
598: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
599: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
600: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
601: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
602: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
596: ,p_api_version IN NUMBER := 1.0
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
598: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
599: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
600: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
601: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
602: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
603: )

Line 621: x_return_status := FND_API.G_RET_STS_SUCCESS;

617: -- Bug 4403338
618: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
619:
620: -- Initialize the return status to success
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: --Clear the global PL/SQL message table
624: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
625: FND_MSG_PUB.initialize;

Line 624: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

620: -- Initialize the return status to success
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: --Clear the global PL/SQL message table
624: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
625: FND_MSG_PUB.initialize;
626: END IF;
627:
628: -- Issue API savepoint if the transaction is to be committed

Line 629: IF p_commit = FND_API.G_TRUE THEN

625: FND_MSG_PUB.initialize;
626: END IF;
627:
628: -- Issue API savepoint if the transaction is to be committed
629: IF p_commit = FND_API.G_TRUE THEN
630: SAVEPOINT UPDATE_ACTION_SET_LINE_PUB;
631: END IF;
632:
633: --Log Message: 4403338

Line 665: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

661: ,x_return_status => l_return_status);
662:
663: x_msg_count := FND_MSG_PUB.Count_Msg;
664: IF x_msg_count = 1 THEN
665: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
666: ,p_msg_index => 1
667: ,p_data => x_msg_data
668: ,p_msg_index_out => l_msg_index_out
669: );

Line 677: x_return_status := FND_API.G_RET_STS_ERROR;

673: PA_DEBUG.Reset_Err_Stack;
674: -- If any errors exist then set the x_return_status to 'E'
675:
676: IF x_msg_count > 0 THEN
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: END IF;
679:
680: -- Commit if the flag is set and there is no error
681: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 681: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

677: x_return_status := FND_API.G_RET_STS_ERROR;
678: END IF;
679:
680: -- Commit if the flag is set and there is no error
681: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
682: COMMIT;
683: END IF;
684:
685: EXCEPTION

Line 687: IF p_commit = FND_API.G_TRUE THEN

683: END IF;
684:
685: EXCEPTION
686: WHEN OTHERS THEN
687: IF p_commit = FND_API.G_TRUE THEN
688: ROLLBACK TO UPDATE_ACTION_SET_LINE_PUB;
689: END IF;
690:
691: -- Set the excetption Message and the stack

Line 695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

691: -- Set the excetption Message and the stack
692: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Update_Action_Set_Line'
693: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
694: --
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
696: RAISE;
697:
698: END Update_Action_Set_Line;
699:

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

701: PROCEDURE delete_action_set_line
702: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE := NULL
703: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE := NULL
704: ,p_api_version IN NUMBER := 1.0
705: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
706: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
707: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
708: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
709: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

702: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE := NULL
703: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE := NULL
704: ,p_api_version IN NUMBER := 1.0
705: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
706: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
707: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
708: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
709: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
710: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

703: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE := NULL
704: ,p_api_version IN NUMBER := 1.0
705: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
706: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
707: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
708: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
709: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
710: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
711: )

Line 730: x_return_status := FND_API.G_RET_STS_SUCCESS;

726: -- Bug 4403338
727: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
728:
729: -- Initialize the return status to success
730: x_return_status := FND_API.G_RET_STS_SUCCESS;
731:
732: --Clear the global PL/SQL message table
733: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
734: FND_MSG_PUB.initialize;

Line 733: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

729: -- Initialize the return status to success
730: x_return_status := FND_API.G_RET_STS_SUCCESS;
731:
732: --Clear the global PL/SQL message table
733: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
734: FND_MSG_PUB.initialize;
735: END IF;
736:
737: -- Issue API savepoint if the transaction is to be committed

Line 738: IF p_commit = FND_API.G_TRUE THEN

734: FND_MSG_PUB.initialize;
735: END IF;
736:
737: -- Issue API savepoint if the transaction is to be committed
738: IF p_commit = FND_API.G_TRUE THEN
739: SAVEPOINT Delete_ACTION_SET_LINE_PUB;
740: END IF;
741:
742: --Log Message: 4403338

Line 770: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

766: ,x_return_status => l_return_status);
767:
768: x_msg_count := FND_MSG_PUB.Count_Msg;
769: IF x_msg_count = 1 THEN
770: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
771: ,p_msg_index => 1
772: ,p_data => x_msg_data
773: ,p_msg_index_out => l_msg_index_out
774: );

Line 782: x_return_status := FND_API.G_RET_STS_ERROR;

778: PA_DEBUG.Reset_Err_Stack;
779: -- If any errors exist then set the x_return_status to 'E'
780:
781: IF x_msg_count > 0 THEN
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: END IF;
784:
785: -- Commit if the flag is set and there is no error
786: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 786: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

782: x_return_status := FND_API.G_RET_STS_ERROR;
783: END IF;
784:
785: -- Commit if the flag is set and there is no error
786: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
787: COMMIT;
788: END IF;
789:
790: EXCEPTION

Line 792: IF p_commit = FND_API.G_TRUE THEN

788: END IF;
789:
790: EXCEPTION
791: WHEN OTHERS THEN
792: IF p_commit = FND_API.G_TRUE THEN
793: ROLLBACK TO Delete_ACTION_SET_LINE_PUB;
794: END IF;
795:
796: -- Set the excetption Message and the stack

Line 800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

796: -- Set the excetption Message and the stack
797: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Delete_Action_Set_Line'
798: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
799: --
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
801: RAISE;
802:
803: END Delete_Action_Set_Line;
804:

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

808: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
809: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
810: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
811: ,p_api_version IN NUMBER := 1.0
812: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
813: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
814: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
815: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
816: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

809: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
810: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
811: ,p_api_version IN NUMBER := 1.0
812: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
813: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
814: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
815: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
816: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
817: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

810: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
811: ,p_api_version IN NUMBER := 1.0
812: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
813: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
814: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
815: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
816: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
817: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
818: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 861: x_return_status := FND_API.G_RET_STS_SUCCESS;

857: -- Bug 4403338
858: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
859:
860: -- Initialize the return status to success
861: x_return_status := FND_API.G_RET_STS_SUCCESS;
862:
863: --Clear the global PL/SQL message table
864: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
865: FND_MSG_PUB.initialize;

Line 864: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

860: -- Initialize the return status to success
861: x_return_status := FND_API.G_RET_STS_SUCCESS;
862:
863: --Clear the global PL/SQL message table
864: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
865: FND_MSG_PUB.initialize;
866: END IF;
867:
868: -- Issue API savepoint if the transaction is to be committed

Line 869: IF p_commit = FND_API.G_TRUE THEN

865: FND_MSG_PUB.initialize;
866: END IF;
867:
868: -- Issue API savepoint if the transaction is to be committed
869: IF p_commit = FND_API.G_TRUE THEN
870: SAVEPOINT APPLY_ACTION_SET_PUB;
871: END IF;
872:
873: --Log Message: 4403338

Line 953: ,p_init_msg_list => FND_API.G_FALSE

949: ,p_attribute12 => l_attribute12
950: ,p_attribute13 => l_attribute13
951: ,p_attribute14 => l_attribute14
952: ,p_attribute15 => l_attribute15
953: ,p_init_msg_list => FND_API.G_FALSE
954: ,x_action_set_id => x_new_action_set_id
955: ,x_return_status => l_return_status
956: ,x_msg_count => l_msg_count
957: ,x_msg_data => l_msg_data);

Line 985: ,p_init_msg_list => FND_API.G_FALSE

981: ,p_action_attribute9 => l_action_set_lines_tbl(i).action_attribute9
982: ,p_action_attribute10 => l_action_set_lines_tbl(i).action_attribute10
983: ,p_condition_tbl => l_action_line_conditions_tbl
984: ,x_action_set_line_id => l_action_set_line_id
985: ,p_init_msg_list => FND_API.G_FALSE
986: ,x_return_status => l_return_status
987: ,x_msg_count => l_msg_count
988: ,x_msg_data => l_msg_data);
989:

Line 1001: ,p_init_msg_list => FND_API.G_FALSE

997:
998: IF p_perform_action_set_flag = 'Y' AND FND_MSG_PUB.Count_Msg = 0 THEN
999:
1000: Perform_Single_Action_Set(p_action_set_id => x_new_action_set_id
1001: ,p_init_msg_list => FND_API.G_FALSE
1002: ,x_return_status => l_return_status
1003: ,x_msg_count => l_msg_count
1004: ,x_msg_data => l_msg_data);
1005:

Line 1017: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

1013: END IF;
1014:
1015: x_msg_count := FND_MSG_PUB.Count_Msg;
1016: IF x_msg_count = 1 THEN
1017: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1018: ,p_msg_index => 1
1019: ,p_data => x_msg_data
1020: ,p_msg_index_out => l_msg_index_out
1021: );

Line 1025: x_return_status := FND_API.G_RET_STS_ERROR;

1021: );
1022: END IF;
1023:
1024: IF x_msg_count > 0 THEN
1025: x_return_status := FND_API.G_RET_STS_ERROR;
1026: END IF;
1027:
1028: -- Reset the error stack when returning to the calling program
1029: PA_DEBUG.Reset_Err_Stack;

Line 1033: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

1029: PA_DEBUG.Reset_Err_Stack;
1030: -- If any errors exist then set the x_return_status to 'E'
1031:
1032: -- Commit if the flag is set and there is no error
1033: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
1034: COMMIT;
1035: END IF;
1036:
1037: EXCEPTION

Line 1039: IF p_commit = FND_API.G_TRUE THEN

1035: END IF;
1036:
1037: EXCEPTION
1038: WHEN OTHERS THEN
1039: IF p_commit = FND_API.G_TRUE THEN
1040: ROLLBACK TO APPLY_ACTION_SET_PUB;
1041: END IF;
1042:
1043: -- Set the excetption Message and the stack

Line 1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1043: -- Set the excetption Message and the stack
1044: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Apply_Action_Set'
1045: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1046: --
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1048: RAISE;
1049:
1050: END;
1051:

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

1057: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
1058: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
1059: ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE
1060: ,p_api_version IN NUMBER := 1.0
1061: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1062: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1063: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1064: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1065: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

1058: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
1059: ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE
1060: ,p_api_version IN NUMBER := 1.0
1061: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1062: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1063: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1064: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1065: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1066: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

1059: ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE
1060: ,p_api_version IN NUMBER := 1.0
1061: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1062: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1063: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1064: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1065: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1066: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1067: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1089: x_return_status := FND_API.G_RET_STS_SUCCESS;

1085: -- Bug 4370082
1086: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1087:
1088: -- Initialize the return status to success
1089: x_return_status := FND_API.G_RET_STS_SUCCESS;
1090:
1091: --Clear the global PL/SQL message table
1092: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1093: FND_MSG_PUB.initialize;

Line 1092: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

1088: -- Initialize the return status to success
1089: x_return_status := FND_API.G_RET_STS_SUCCESS;
1090:
1091: --Clear the global PL/SQL message table
1092: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1093: FND_MSG_PUB.initialize;
1094: END IF;
1095:
1096: -- Issue API savepoint if the transaction is to be committed

Line 1097: IF p_commit = FND_API.G_TRUE THEN

1093: FND_MSG_PUB.initialize;
1094: END IF;
1095:
1096: -- Issue API savepoint if the transaction is to be committed
1097: IF p_commit = FND_API.G_TRUE THEN
1098: SAVEPOINT REPLACE_ACTION_SET_PUB;
1099: END IF;
1100:
1101: --Log Message: 4370082

Line 1121: ,p_init_msg_list => FND_API.G_FALSE

1117:
1118: delete_action_set(
1119: p_action_set_id => l_current_action_set_id
1120: ,p_record_version_number => p_record_version_number
1121: ,p_init_msg_list => FND_API.G_FALSE
1122: ,x_return_status => l_return_status
1123: ,x_msg_count => l_msg_count
1124: ,x_msg_data => l_msg_data);
1125:

Line 1138: ,p_init_msg_list => FND_API.G_FALSE

1134:
1135: Apply_Action_Set(p_action_set_id => p_new_action_set_id
1136: ,p_object_type => p_object_type
1137: ,p_object_id => p_object_id
1138: ,p_init_msg_list => FND_API.G_FALSE
1139: ,x_new_action_set_id => x_new_action_set_id
1140: ,x_return_status => l_return_status
1141: ,x_msg_count => l_msg_count
1142: ,x_msg_data => l_msg_data);

Line 1149: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

1145:
1146:
1147: x_msg_count := FND_MSG_PUB.Count_Msg;
1148: IF x_msg_count = 1 THEN
1149: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1150: ,p_msg_index => 1
1151: ,p_data => x_msg_data
1152: ,p_msg_index_out => l_msg_index_out
1153: );

Line 1161: x_return_status := FND_API.G_RET_STS_ERROR;

1157: PA_DEBUG.Reset_Err_Stack;
1158: -- If any errors exist then set the x_return_status to 'E'
1159:
1160: IF x_msg_count > 0 THEN
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: END IF;
1163:
1164: -- Commit if the flag is set and there is no error
1165: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 1165: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: END IF;
1163:
1164: -- Commit if the flag is set and there is no error
1165: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
1166: COMMIT;
1167: END IF;
1168:
1169: EXCEPTION

Line 1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1171: /*
1172: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1173: ,p_procedure_name => 'INVALID RESULTS CODE: '||l_action_line_result_code);
1174: --
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1176: */
1177: RAISE;
1178: WHEN OTHERS THEN
1179: IF p_commit = FND_API.G_TRUE THEN

Line 1179: IF p_commit = FND_API.G_TRUE THEN

1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1176: */
1177: RAISE;
1178: WHEN OTHERS THEN
1179: IF p_commit = FND_API.G_TRUE THEN
1180: ROLLBACK TO REPLACE_ACTION_SET;
1181: END IF;
1182:
1183: -- Set the excetption Message and the stack

Line 1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1183: -- Set the excetption Message and the stack
1184: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Replace_Action_Set'
1185: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1186: --
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1188: RAISE;
1189:
1190: END;
1191:

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

1196: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
1197: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
1198: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
1199: ,p_api_version IN NUMBER := 1.0
1200: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1201: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1202: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1203: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1204: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

1197: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
1198: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
1199: ,p_api_version IN NUMBER := 1.0
1200: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1201: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1202: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1203: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1204: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1205: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

1198: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
1199: ,p_api_version IN NUMBER := 1.0
1200: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1201: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1202: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1203: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1204: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1205: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1206: ) IS

Line 1241: x_return_status := FND_API.G_RET_STS_SUCCESS;

1237: -- Bug 4370082
1238: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1239:
1240: -- Initialize the return status to success
1241: x_return_status := FND_API.G_RET_STS_SUCCESS;
1242:
1243: --Clear the global PL/SQL message table
1244: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1245: FND_MSG_PUB.initialize;

Line 1244: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

1240: -- Initialize the return status to success
1241: x_return_status := FND_API.G_RET_STS_SUCCESS;
1242:
1243: --Clear the global PL/SQL message table
1244: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1245: FND_MSG_PUB.initialize;
1246: END IF;
1247:
1248: -- Issue API savepoint if the transaction is to be committed

Line 1249: IF p_commit = FND_API.G_TRUE THEN

1245: FND_MSG_PUB.initialize;
1246: END IF;
1247:
1248: -- Issue API savepoint if the transaction is to be committed
1249: IF p_commit = FND_API.G_TRUE THEN
1250: SAVEPOINT PERFORM_SINGLE_ACTION_SET_PUB;
1251: END IF;
1252:
1253: --Log Message: 4370082

Line 1311: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

1307: END IF;
1308:
1309: x_msg_count := FND_MSG_PUB.Count_Msg;
1310: IF x_msg_count = 1 THEN
1311: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1312: ,p_msg_index => 1
1313: ,p_data => x_msg_data
1314: ,p_msg_index_out => l_msg_index_out
1315: );

Line 1323: x_return_status := FND_API.G_RET_STS_ERROR;

1319: PA_DEBUG.Reset_Err_Stack;
1320: -- If any errors exist then set the x_return_status to 'E'
1321:
1322: IF x_msg_count > 0 OR NVL(PA_ACTION_SET_UTILS.G_ERROR_EXISTS,'N') = 'Y' THEN /* Bug 11834798 */
1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: END IF;
1325:
1326: -- Commit if the flag is set and there is no error
1327: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 1327: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: END IF;
1325:
1326: -- Commit if the flag is set and there is no error
1327: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
1328: COMMIT;
1329: END IF;
1330:
1331: EXCEPTION

Line 1333: IF p_commit = FND_API.G_TRUE THEN

1329: END IF;
1330:
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: IF p_commit = FND_API.G_TRUE THEN
1334: ROLLBACK TO PERFORM_SINGLE_ACTION_SET;
1335: END IF;
1336:
1337: -- Set the excetption Message and the stack

Line 1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1337: -- Set the excetption Message and the stack
1338: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Perform_Single_Action_Set'
1339: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1340: --
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1342: RAISE;
1343:
1344: END;
1345:

Line 1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1449: /*
1450: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1451: ,p_procedure_name => 'INVALID RESULTS CODE: '||l_action_line_result_code);
1452: --
1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1454: */
1455: RAISE;
1456:
1457: WHEN OTHERS THEN

Line 1462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1458: -- Set the excetption Message and the stack
1459: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1460: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1461: --
1462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1463: RAISE;
1464:
1465:
1466: END;

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

1495: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := NULL
1496: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := NULL
1497: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := NULL
1498: ,p_api_version IN NUMBER := 1.0
1499: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1500: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1501: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1502: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1503: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

1496: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := NULL
1497: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := NULL
1498: ,p_api_version IN NUMBER := 1.0
1499: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1500: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1501: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1502: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1503: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1504: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

1497: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := NULL
1498: ,p_api_version IN NUMBER := 1.0
1499: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1500: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1501: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1502: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1503: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1504: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1505: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1518: x_return_status := FND_API.G_RET_STS_SUCCESS;

1514: -- Initialize the Error Stack
1515: PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.create_line_single_cond');
1516:
1517: -- Initialize the return status to success
1518: x_return_status := FND_API.G_RET_STS_SUCCESS;
1519:
1520: l_condition_tbl(1).condition_code := p_condition_code;
1521: l_condition_tbl(1).description := p_condition_description;
1522: l_condition_tbl(1).condition_attribute1 := p_condition_attribute1;

Line 1561: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1557: -- 2452316: Need to set MOD_SOURCE_ACTION_SET_FLAG = 'Y' when a new line
1558: -- is added from self-service page. Should not put this logic in
1559: -- PA_ACTION_SET_PVT.create_action_set_line because that is also called when
1560: -- an action set is created for the first time.
1561: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1562: SELECT action_set_template_flag
1563: INTO l_action_set_template_flag
1564: FROM pa_action_sets
1565: WHERE action_set_id = p_action_set_id;

Line 1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1577: -- Set the excetption Message and the stack
1578: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.create_line_single_cond'
1579: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1580: --
1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1582: RAISE;
1583:
1584: END;
1585:

Line 1590: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR

1586:
1587: PROCEDURE update_line_single_cond
1588: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
1589: ,p_record_version_number IN NUMBER := NULL
1590: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
1591: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR

Line 1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR

1588: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
1589: ,p_record_version_number IN NUMBER := NULL
1590: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
1591: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR

Line 1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR

1589: ,p_record_version_number IN NUMBER := NULL
1590: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
1591: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR

Line 1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR

1590: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
1591: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR

Line 1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR

1591: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR

Line 1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR

1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR

Line 1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR

1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR

Line 1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR

1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR

Line 1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR

1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE

Line 1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR

1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR

Line 1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR

1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR

Line 1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR

1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR

Line 1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR

1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR

Line 1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR

1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR

Line 1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR

1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR

Line 1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR

1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR

Line 1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR

1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR

Line 1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR

1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR

Line 1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR

1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
1614: ,p_api_version IN NUMBER := 1.0

Line 1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR

1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
1614: ,p_api_version IN NUMBER := 1.0
1615: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR

1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
1614: ,p_api_version IN NUMBER := 1.0
1615: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1616: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR

1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
1614: ,p_api_version IN NUMBER := 1.0
1615: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1616: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1617: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
1614: ,p_api_version IN NUMBER := 1.0
1615: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1616: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1617: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1618: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1619: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
1614: ,p_api_version IN NUMBER := 1.0
1615: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1616: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1617: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1618: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1619: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1620: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
1614: ,p_api_version IN NUMBER := 1.0
1615: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1616: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1617: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1618: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1619: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1620: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1621: )

Line 1634: x_return_status := FND_API.G_RET_STS_SUCCESS;

1630: -- Initialize the Error Stack
1631: PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.update_line_single_cond');
1632:
1633: -- Initialize the return status to success
1634: x_return_status := FND_API.G_RET_STS_SUCCESS;
1635:
1636: l_condition_tbl(1).condition_code := p_condition_code;
1637: l_condition_tbl(1).description := p_condition_description;
1638: l_condition_tbl(1).condition_attribute1 := p_condition_attribute1;

Line 1680: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1676: -- 2452316: Need to set MOD_SOURCE_ACTION_SET_FLAG = 'Y' when updating a line
1677: -- from self-service page. Should not put this logic in
1678: -- PA_ACTION_SET_PVT.update_action_set_line because that could be called when
1679: -- a line is performed.
1680: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1681: SELECT s.action_set_template_flag, s.action_set_id
1682: INTO l_action_set_template_flag, l_action_set_id
1683: FROM pa_action_sets s, pa_action_set_lines l
1684: WHERE l.action_set_line_id = p_action_set_line_id

Line 1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1697: -- Set the excetption Message and the stack
1698: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.update_line_single_cond'
1699: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1700: --
1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1702: RAISE;
1703:
1704: END;
1705:

Line 1721: x_return_status := FND_API.G_RET_STS_SUCCESS;

1717:
1718: BEGIN
1719:
1720: -- Initialize the return status to success
1721: x_return_status := FND_API.G_RET_STS_SUCCESS;
1722:
1723: FND_MSG_PUB.initialize;
1724:
1725: SELECT action_set_template_flag, action_set_type_code INTO l_action_set_template_flag, l_action_set_type_code

Line 1736: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

1732: x_return_status => l_return_status);
1733:
1734: x_msg_count := FND_MSG_PUB.Count_Msg;
1735: IF x_msg_count = 1 THEN
1736: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1737: ,p_msg_index => 1
1738: ,p_data => x_msg_data
1739: ,p_msg_index_out => l_msg_index_out
1740: );

Line 1748: x_return_status := FND_API.G_RET_STS_ERROR;

1744: PA_DEBUG.Reset_Err_Stack;
1745: -- If any errors exist then set the x_return_status to 'E'
1746:
1747: IF x_msg_count > 0 THEN
1748: x_return_status := FND_API.G_RET_STS_ERROR;
1749: END IF;
1750:
1751: EXCEPTION
1752: WHEN OTHERS THEN

Line 1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1753: -- Set the excetption Message and the stack
1754: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Validate_Action_Set'
1755: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1756: --
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1758: RAISE;
1759:
1760: END;
1761: