eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_SETS_PUB dependencies on FND_API

Line 30: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

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

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

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

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

Line 52: x_return_status := FND_API.G_RET_STS_SUCCESS;

48: PA_DEBUG.init_err_stack('PA_PROJECT_SETS_PUB.Create_Project_Set');
49: END IF;
50:
51: -- Initialize the return status to success
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53:
54: --Clear the global PL/SQL message table
55: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
56: FND_MSG_PUB.initialize;

Line 55: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

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

Line 60: IF p_commit = FND_API.G_TRUE THEN

56: FND_MSG_PUB.initialize;
57: END IF;
58:
59: -- Issue API savepoint if the transaction is to be committed
60: IF p_commit = FND_API.G_TRUE THEN
61: SAVEPOINT CREATE_PROJECT_SETS_PUB;
62: END IF;
63:
64: --Log Message

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

102: ,x_return_status => l_return_status);
103:
104: x_msg_count := FND_MSG_PUB.Count_Msg;
105: IF x_msg_count = 1 THEN
106: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
107: ,p_msg_index => 1
108: ,p_data => x_msg_data
109: ,p_msg_index_out => l_msg_index_out
110: );

Line 120: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 130: IF p_commit = FND_API.G_TRUE THEN

126: END IF;
127:
128: EXCEPTION
129: WHEN OTHERS THEN
130: IF p_commit = FND_API.G_TRUE THEN
131: ROLLBACK TO CREATE_PROJECT_SETS_PUB;
132: END IF;
133:
134: -- 4537865 : RESET the OUT params properly

Line 143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

139: -- Set the exception Message and the stack
140: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PUB.Create_Project_Set'
141: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
142: --
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
144: --RAISE;
145:
146: END create_project_set;
147:

Line 151: ,p_project_set_name IN pa_project_sets_tl.name%TYPE := FND_API.G_MISS_CHAR

147:
148:
149: PROCEDURE update_project_set
150: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
151: ,p_project_set_name IN pa_project_sets_tl.name%TYPE := FND_API.G_MISS_CHAR
152: ,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM
153: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE
154: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE
155: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM

Line 152: ,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM

148:
149: PROCEDURE update_project_set
150: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
151: ,p_project_set_name IN pa_project_sets_tl.name%TYPE := FND_API.G_MISS_CHAR
152: ,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM
153: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE
154: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE
155: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
156: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR

Line 153: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE

149: PROCEDURE update_project_set
150: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
151: ,p_project_set_name IN pa_project_sets_tl.name%TYPE := FND_API.G_MISS_CHAR
152: ,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM
153: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE
154: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE
155: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
156: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
157: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR

Line 154: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE

150: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
151: ,p_project_set_name IN pa_project_sets_tl.name%TYPE := FND_API.G_MISS_CHAR
152: ,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM
153: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE
154: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE
155: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
156: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
157: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR

Line 155: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM

151: ,p_project_set_name IN pa_project_sets_tl.name%TYPE := FND_API.G_MISS_CHAR
152: ,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM
153: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE
154: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE
155: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
156: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
157: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR

Line 156: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR

152: ,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM
153: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE
154: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE
155: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
156: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
157: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 157: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR

153: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE
154: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE
155: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
156: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
157: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR

Line 158: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR

154: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE
155: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
156: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
157: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR

Line 159: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR

155: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
156: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
157: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR

Line 160: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR

156: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
157: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := FND_API.G_MISS_CHAR

Line 161: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR

157: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := FND_API.G_MISS_CHAR

Line 162: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR

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

Line 163: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR

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

Line 164: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := FND_API.G_MISS_CHAR

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

Line 165: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := FND_API.G_MISS_CHAR

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

Line 166: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := FND_API.G_MISS_CHAR

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

Line 167: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := FND_API.G_MISS_CHAR

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

Line 168: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR

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

Line 169: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR

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

Line 170: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR

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

Line 171: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR

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

Line 172: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR

168: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR
174: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

Line 173: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR

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

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

172: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR
174: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
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_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR
174: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
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_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
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 197: x_return_status := FND_API.G_RET_STS_SUCCESS;

193: PA_DEBUG.init_err_stack('PA_PROJECT_SETS_PUB.Update_Project_Set');
194: END IF;
195:
196: -- Initialize the return status to success
197: x_return_status := FND_API.G_RET_STS_SUCCESS;
198:
199: --Clear the global PL/SQL message table
200: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
201: FND_MSG_PUB.initialize;

Line 200: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

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

Line 205: IF p_commit = FND_API.G_TRUE THEN

201: FND_MSG_PUB.initialize;
202: END IF;
203:
204: -- Issue API savepoint if the transaction is to be committed
205: IF p_commit = FND_API.G_TRUE THEN
206: SAVEPOINT UPDATE_PROJECT_SETS_PUB;
207: END IF;
208:
209: --Log Message

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

248:
249:
250: x_msg_count := FND_MSG_PUB.Count_Msg;
251: IF x_msg_count = 1 THEN
252: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
253: ,p_msg_index => 1
254: ,p_data => x_msg_data
255: ,p_msg_index_out => l_msg_index_out
256: );

Line 266: x_return_status := FND_API.G_RET_STS_ERROR;

262: END IF;
263: -- If any errors exist then set the x_return_status to 'E'
264:
265: IF x_msg_count > 0 THEN
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: END IF;
268:
269: -- Commit if the flag is set and there is no error
270: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

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

266: x_return_status := FND_API.G_RET_STS_ERROR;
267: END IF;
268:
269: -- Commit if the flag is set and there is no error
270: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
271: COMMIT;
272: END IF;
273:
274: EXCEPTION

Line 276: IF p_commit = FND_API.G_TRUE THEN

272: END IF;
273:
274: EXCEPTION
275: WHEN OTHERS THEN
276: IF p_commit = FND_API.G_TRUE THEN
277: ROLLBACK TO UPDATE_PROJECT_SETS_PUB;
278: END IF;
279:
280: -- 4537865 : RESET the OUT params properly

Line 288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

284: -- Set the excetption Message and the stack
285: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PUB.Update_Project_Set'
286: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
287: --
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
289: --RAISE;
290:
291: END update_project_set;
292:

Line 298: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

294: PROCEDURE delete_project_set
295: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE := NULL
296: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
297: ,p_api_version IN NUMBER := 1.0
298: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
299: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
300: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
301: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
302: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

295: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE := NULL
296: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
297: ,p_api_version IN NUMBER := 1.0
298: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
299: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
300: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
301: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
302: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
303: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

296: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
297: ,p_api_version IN NUMBER := 1.0
298: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
299: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
300: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
301: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
302: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
303: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
304: )

Line 319: x_return_status := FND_API.G_RET_STS_SUCCESS;

315: PA_DEBUG.init_err_stack('PA_PROJECT_SETS_PUB.Delete_Project_Set');
316: END IF;
317:
318: -- Initialize the return status to success
319: x_return_status := FND_API.G_RET_STS_SUCCESS;
320:
321: --Clear the global PL/SQL message table
322: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
323: FND_MSG_PUB.initialize;

Line 322: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

318: -- Initialize the return status to success
319: x_return_status := FND_API.G_RET_STS_SUCCESS;
320:
321: --Clear the global PL/SQL message table
322: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
323: FND_MSG_PUB.initialize;
324: END IF;
325:
326: -- Issue API savepoint if the transproject is to be committed

Line 327: IF p_commit = FND_API.G_TRUE THEN

323: FND_MSG_PUB.initialize;
324: END IF;
325:
326: -- Issue API savepoint if the transproject is to be committed
327: IF p_commit = FND_API.G_TRUE THEN
328: SAVEPOINT Delete_PROJECT_SETS_PUB;
329: END IF;
330:
331: --Log Message

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

346: ,x_return_status => l_return_status);
347:
348: x_msg_count := FND_MSG_PUB.Count_Msg;
349: IF x_msg_count = 1 THEN
350: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
351: ,p_msg_index => 1
352: ,p_data => x_msg_data
353: ,p_msg_index_out => l_msg_index_out
354: );

Line 364: x_return_status := FND_API.G_RET_STS_ERROR;

360: END IF;
361: -- If any errors exist then set the x_return_status to 'E'
362:
363: IF x_msg_count > 0 THEN
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: END IF;
366:
367: -- Commit if the flag is set and there is no error
368: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

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

364: x_return_status := FND_API.G_RET_STS_ERROR;
365: END IF;
366:
367: -- Commit if the flag is set and there is no error
368: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
369: COMMIT;
370: END IF;
371:
372: EXCEPTION

Line 374: IF p_commit = FND_API.G_TRUE THEN

370: END IF;
371:
372: EXCEPTION
373: WHEN OTHERS THEN
374: IF p_commit = FND_API.G_TRUE THEN
375: ROLLBACK TO Delete_PROJECT_SETS_PUB;
376: END IF;
377:
378: -- 4537865 : RESET the OUT params properly

Line 386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

382: -- Set the excetption Message and the stack
383: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PUB.Delete_Project_Set'
384: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
385: --
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
387: RAISE;
388:
389: END delete_project_set;
390:

Line 396: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

392: PROCEDURE create_project_set_line
393: (p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
394: ,p_project_id IN pa_project_set_lines.project_id%TYPE
395: ,p_api_version IN NUMBER := 1.0
396: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
397: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
398: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
399: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
400: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

393: (p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
394: ,p_project_id IN pa_project_set_lines.project_id%TYPE
395: ,p_api_version IN NUMBER := 1.0
396: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
397: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
398: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
399: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
400: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
401: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

394: ,p_project_id IN pa_project_set_lines.project_id%TYPE
395: ,p_api_version IN NUMBER := 1.0
396: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
397: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
398: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
399: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
400: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
401: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
402: )

Line 417: x_return_status := FND_API.G_RET_STS_SUCCESS;

413: PA_DEBUG.init_err_stack('PA_PROJECT_SETS_PUB.Create_Project_Set_Line');
414: END IF;
415:
416: -- Initialize the return status to success
417: x_return_status := FND_API.G_RET_STS_SUCCESS;
418:
419: --Clear the global PL/SQL message table
420: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
421: FND_MSG_PUB.initialize;

Line 420: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

416: -- Initialize the return status to success
417: x_return_status := FND_API.G_RET_STS_SUCCESS;
418:
419: --Clear the global PL/SQL message table
420: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
421: FND_MSG_PUB.initialize;
422: END IF;
423:
424: -- Issue API savepoint if the transproject is to be committed

Line 425: IF p_commit = FND_API.G_TRUE THEN

421: FND_MSG_PUB.initialize;
422: END IF;
423:
424: -- Issue API savepoint if the transproject is to be committed
425: IF p_commit = FND_API.G_TRUE THEN
426: SAVEPOINT CREATE_PROJECT_SET_LINE_PUB;
427: END IF;
428:
429: --Log Message

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

445: ,x_return_status => l_return_status);
446:
447: x_msg_count := FND_MSG_PUB.Count_Msg;
448: IF x_msg_count = 1 THEN
449: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
450: ,p_msg_index => 1
451: ,p_data => x_msg_data
452: ,p_msg_index_out => l_msg_index_out
453: );

Line 463: x_return_status := FND_API.G_RET_STS_ERROR;

459: END IF;
460: -- If any errors exist then set the x_return_status to 'E'
461:
462: IF x_msg_count > 0 THEN
463: x_return_status := FND_API.G_RET_STS_ERROR;
464: END IF;
465:
466: -- Commit if the flag is set and there is no error
467: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

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

463: x_return_status := FND_API.G_RET_STS_ERROR;
464: END IF;
465:
466: -- Commit if the flag is set and there is no error
467: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
468: COMMIT;
469: END IF;
470:
471: EXCEPTION

Line 473: IF p_commit = FND_API.G_TRUE THEN

469: END IF;
470:
471: EXCEPTION
472: WHEN OTHERS THEN
473: IF p_commit = FND_API.G_TRUE THEN
474: ROLLBACK TO CREATE_PROJECT_SET_LINE_PUB;
475: END IF;
476:
477: -- 4537865 : RESET the OUT params properly

Line 485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

481: -- Set the excetption Message and the stack
482: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PUB.Create_Project_Set_Line'
483: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
484: --
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
486: --RAISE;
487:
488: END create_project_set_line;
489:

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

492: PROCEDURE delete_project_set_line
493: (p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
494: ,p_project_id IN pa_project_set_lines.project_id%TYPE
495: ,p_api_version IN NUMBER := 1.0
496: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
497: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
498: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
499: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
500: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

493: (p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
494: ,p_project_id IN pa_project_set_lines.project_id%TYPE
495: ,p_api_version IN NUMBER := 1.0
496: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
497: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
498: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
499: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
500: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
501: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

494: ,p_project_id IN pa_project_set_lines.project_id%TYPE
495: ,p_api_version IN NUMBER := 1.0
496: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
497: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
498: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
499: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
500: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
501: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
502: )

Line 518: x_return_status := FND_API.G_RET_STS_SUCCESS;

514: PA_DEBUG.init_err_stack('PA_PROJECT_SETS_PUB.Delete_Project_Set_Line');
515: END IF;
516:
517: -- Initialize the return status to success
518: x_return_status := FND_API.G_RET_STS_SUCCESS;
519:
520: --Clear the global PL/SQL message table
521: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
522: FND_MSG_PUB.initialize;

Line 521: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

517: -- Initialize the return status to success
518: x_return_status := FND_API.G_RET_STS_SUCCESS;
519:
520: --Clear the global PL/SQL message table
521: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
522: FND_MSG_PUB.initialize;
523: END IF;
524:
525: -- Issue API savepoint if the transproject is to be committed

Line 526: IF p_commit = FND_API.G_TRUE THEN

522: FND_MSG_PUB.initialize;
523: END IF;
524:
525: -- Issue API savepoint if the transproject is to be committed
526: IF p_commit = FND_API.G_TRUE THEN
527: SAVEPOINT Delete_PROJECT_SET_LINE_PUB;
528: END IF;
529:
530: --Log Message

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

545: ,x_return_status => l_return_status);
546:
547: x_msg_count := FND_MSG_PUB.Count_Msg;
548: IF x_msg_count = 1 THEN
549: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
550: ,p_msg_index => 1
551: ,p_data => x_msg_data
552: ,p_msg_index_out => l_msg_index_out
553: );

Line 563: x_return_status := FND_API.G_RET_STS_ERROR;

559: END IF;
560: -- If any errors exist then set the x_return_status to 'E'
561:
562: IF x_msg_count > 0 THEN
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: END IF;
565:
566: -- Commit if the flag is set and there is no error
567: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

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

563: x_return_status := FND_API.G_RET_STS_ERROR;
564: END IF;
565:
566: -- Commit if the flag is set and there is no error
567: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
568: COMMIT;
569: END IF;
570:
571: EXCEPTION

Line 573: IF p_commit = FND_API.G_TRUE THEN

569: END IF;
570:
571: EXCEPTION
572: WHEN OTHERS THEN
573: IF p_commit = FND_API.G_TRUE THEN
574: ROLLBACK TO Delete_PROJECT_SET_LINE_PUB;
575: END IF;
576:
577: -- 4537865 : RESET the OUT params properly

Line 585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

581: -- Set the excetption Message and the stack
582: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PUB.Delete_Project_Set_Line'
583: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
584: --
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
586: --RAISE;
587:
588: END delete_project_set_line;
589:

Line 613: p_return_status := FND_API.G_RET_STS_SUCCESS;

609: ) IS
610: l_incoming_p_to_id NUMBER ; -- 4537865
611: BEGIN
612:
613: p_return_status := FND_API.G_RET_STS_SUCCESS;
614: l_incoming_p_to_id := p_to_id ; -- 4537865
615:
616: if (p_from_fk_id <> p_to_fk_id) then
617:

Line 632: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

628: end if;
629: -- 4537865
630: EXCEPTION
631: WHEN OTHERS THEN
632: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: p_to_id := l_incoming_p_to_id ; -- RESET this IN OUT param to the same IN value got
634:
635: FND_MSG_PUB.add_exc_msg
636: ( p_pkg_name => 'PA_PROJECT_SETS_PUB'