DBA Data[Home] [Help]

APPS.ASO_TASK_INT dependencies on FND_API

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

26: */
27: PROCEDURE Copy_Tasks
28: (
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: p_old_object_id IN NUMBER,
33: p_new_object_id IN NUMBER,
34: p_old_object_type_code IN VARCHAR2,

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

27: PROCEDURE Copy_Tasks
28: (
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: p_old_object_id IN NUMBER,
33: p_new_object_id IN NUMBER,
34: p_old_object_type_code IN VARCHAR2,
35: p_new_object_type_code IN VARCHAR2,

Line 37: p_quote_version_flag IN VARCHAR2 := FND_API.G_FALSE,

33: p_new_object_id IN NUMBER,
34: p_old_object_type_code IN VARCHAR2,
35: p_new_object_type_code IN VARCHAR2,
36: p_new_object_name IN VARCHAR2,
37: p_quote_version_flag IN VARCHAR2 := FND_API.G_FALSE,
38: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
39: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
40: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41: )

Line 156: IF NOT FND_API.Compatible_API_Call(

152: -- Standard Start of API savepoint
153: SAVEPOINT Copy_Tasks_int;
154: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
155: -- Standard call to check for call compatibility.
156: IF NOT FND_API.Compatible_API_Call(
157: L_API_VERSION,
158: p_api_version,
159: L_API_NAME ,
160: G_PKG_NAME

Line 163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

159: L_API_NAME ,
160: G_PKG_NAME
161: )
162: THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165:
166: -- Initialize message list if p_init_msg_list is set to TRUE.
167: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 167: IF FND_API.To_Boolean(p_init_msg_list) THEN

163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165:
166: -- Initialize message list if p_init_msg_list is set to TRUE.
167: IF FND_API.To_Boolean(p_init_msg_list) THEN
168: FND_Msg_Pub.initialize;
169: END IF;
170:
171: -- Initialize API return status to success

Line 172: x_return_status := FND_API.G_RET_STS_SUCCESS;

168: FND_Msg_Pub.initialize;
169: END IF;
170:
171: -- Initialize API return status to success
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173: IF aso_debug_pub.g_debug_flag = 'Y' THEN
174: aso_debug_pub.add('ASO_TASK_INT: Copy_Tasks: Begin Copy_Tasks()', 1, 'Y');
175: aso_debug_pub.add('ASO_TASK_INT: Copy_Tasks: old_object_id: ' || p_old_object_id, 1, 'N');
176: aso_debug_pub.add('ASO_TASK_INT: Copy_Tasks: old_object_type_code: ' || p_old_object_type_code, 1, 'N');

Line 192: IF p_quote_version_flag = FND_API.G_TRUE THEN

188:
189: aso_debug_pub.add('ASO_TASK_INT: Copy_Tasks: l_reftask_rec.task_id: ' || l_reftask_rec.task_id, 1, 'N');
190: END IF;
191: /*Changes for Copy Quote Version We shouldn't create new task for a new version of quote */
192: IF p_quote_version_flag = FND_API.G_TRUE THEN
193: jtf_task_references_pub.create_references (
194: p_api_version => 1.0,
195: p_init_msg_list => fnd_api.g_false,
196: p_commit => fnd_api.g_false,

Line 195: p_init_msg_list => fnd_api.g_false,

191: /*Changes for Copy Quote Version We shouldn't create new task for a new version of quote */
192: IF p_quote_version_flag = FND_API.G_TRUE THEN
193: jtf_task_references_pub.create_references (
194: p_api_version => 1.0,
195: p_init_msg_list => fnd_api.g_false,
196: p_commit => fnd_api.g_false,
197: p_task_id => l_reftask_rec.task_id,
198: p_object_type_code => p_new_object_type_code,
199: p_object_name => p_new_object_name,

Line 196: p_commit => fnd_api.g_false,

192: IF p_quote_version_flag = FND_API.G_TRUE THEN
193: jtf_task_references_pub.create_references (
194: p_api_version => 1.0,
195: p_init_msg_list => fnd_api.g_false,
196: p_commit => fnd_api.g_false,
197: p_task_id => l_reftask_rec.task_id,
198: p_object_type_code => p_new_object_type_code,
199: p_object_name => p_new_object_name,
200: p_object_id => p_new_object_id,

Line 211: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

207: IF aso_debug_pub.g_debug_flag = 'Y' THEN
208: aso_debug_pub.add('ASO_TASK_INT: After Copy_Tasks: create_references ref_id' || l_task_reference_id, 1, 'N');
209: END IF;
210:
211: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213:
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

Line 212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

208: aso_debug_pub.add('ASO_TASK_INT: After Copy_Tasks: create_references ref_id' || l_task_reference_id, 1, 'N');
209: END IF;
210:
211: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213:
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
216: x_return_status := FND_API.G_RET_STS_ERROR;

Line 214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

210:
211: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213:
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: RAISE FND_API.G_EXC_ERROR;
218: END IF;

Line 215: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

211: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213:
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: RAISE FND_API.G_EXC_ERROR;
218: END IF;
219:

Line 216: x_return_status := FND_API.G_RET_STS_ERROR;

212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213:
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: RAISE FND_API.G_EXC_ERROR;
218: END IF;
219:
220:

Line 217: RAISE FND_API.G_EXC_ERROR;

213:
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: RAISE FND_API.G_EXC_ERROR;
218: END IF;
219:
220:
221: ELSE

Line 240: p_init_msg_list => FND_API.G_FALSE ,

236:
237:
238: JTF_Tasks_Pub.Create_Task(
239: p_api_version => 1.0 ,
240: p_init_msg_list => FND_API.G_FALSE ,
241: p_commit => FND_API.G_FALSE ,
242: x_return_status => x_return_status ,
243: x_msg_count => x_msg_count ,
244: x_msg_data => x_msg_data ,

Line 241: p_commit => FND_API.G_FALSE ,

237:
238: JTF_Tasks_Pub.Create_Task(
239: p_api_version => 1.0 ,
240: p_init_msg_list => FND_API.G_FALSE ,
241: p_commit => FND_API.G_FALSE ,
242: x_return_status => x_return_status ,
243: x_msg_count => x_msg_count ,
244: x_msg_data => x_msg_data ,
245: p_task_name => l_task_rec.task_name ,

Line 335: IF FND_API.To_Boolean(p_commit) THEN

331: aso_debug_pub.add('ASO_TASK_INT: Copy_Tasks: End Copy_Tasks()', 1, 'Y');
332: END IF;
333:
334: -- Standard check of p_commit.
335: IF FND_API.To_Boolean(p_commit) THEN
336: COMMIT WORK;
337: END IF;
338:
339: -- Standard call to get message count and if count is 1, get message info.

Line 341: p_encoded => FND_API.G_FALSE,

337: END IF;
338:
339: -- Standard call to get message count and if count is 1, get message info.
340: FND_Msg_Pub.Count_And_Get(
341: p_encoded => FND_API.G_FALSE,
342: p_count => x_msg_count ,
343: p_data => x_msg_data
344: );
345:

Line 347: WHEN FND_API.G_EXC_ERROR THEN

343: p_data => x_msg_data
344: );
345:
346: EXCEPTION
347: WHEN FND_API.G_EXC_ERROR THEN
348: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
349: P_API_NAME => L_API_NAME,
350: P_PKG_NAME => G_PKG_NAME,
351: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

356: X_MSG_DATA => X_MSG_DATA,
357: X_RETURN_STATUS => X_RETURN_STATUS
358: );
359:
360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
361: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
362: P_API_NAME => L_API_NAME,
363: P_PKG_NAME => G_PKG_NAME,
364: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

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

398:
399: PROCEDURE Copy_Opp_Tasks_To_Qte
400: (
401: p_api_version IN NUMBER,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404: p_old_object_id IN NUMBER,
405: p_new_object_id IN NUMBER,
406: p_old_object_type_code IN VARCHAR2,

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

399: PROCEDURE Copy_Opp_Tasks_To_Qte
400: (
401: p_api_version IN NUMBER,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404: p_old_object_id IN NUMBER,
405: p_new_object_id IN NUMBER,
406: p_old_object_type_code IN VARCHAR2,
407: p_new_object_type_code IN VARCHAR2,

Line 519: IF NOT FND_API.Compatible_API_Call(

515: -- Standard Start of API savepoint
516: SAVEPOINT Copy_Opp_Tasks_To_Qte_int;
517: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
518: -- Standard call to check for call compatibility.
519: IF NOT FND_API.Compatible_API_Call(
520: L_API_VERSION,
521: p_api_version,
522: L_API_NAME ,
523: G_PKG_NAME

Line 526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

522: L_API_NAME ,
523: G_PKG_NAME
524: )
525: THEN
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528:
529: -- Initialize message list if p_init_msg_list is set to TRUE.
530: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 530: IF FND_API.To_Boolean(p_init_msg_list) THEN

526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528:
529: -- Initialize message list if p_init_msg_list is set to TRUE.
530: IF FND_API.To_Boolean(p_init_msg_list) THEN
531: FND_Msg_Pub.initialize;
532: END IF;
533:
534: -- Initialize API return status to success

Line 535: x_return_status := FND_API.G_RET_STS_SUCCESS;

531: FND_Msg_Pub.initialize;
532: END IF;
533:
534: -- Initialize API return status to success
535: x_return_status := FND_API.G_RET_STS_SUCCESS;
536: IF aso_debug_pub.g_debug_flag = 'Y' THEN
537: aso_debug_pub.add('ASO_TASK_INT: Copy_Opp_Tasks_To_Qte: Begin Copy_Opp_Tasks_To_Qte()', 1, 'Y');
538: aso_debug_pub.add('ASO_TASK_INT: Copy_Opp_Tasks_To_Qte: old_object_id: ' || p_old_object_id, 1, 'N');
539: aso_debug_pub.add('ASO_TASK_INT: Copy_Opp_Tasks_To_Qte: old_object_type_code: ' || p_old_object_type_code, 1, 'N');

Line 556: p_init_msg_list => FND_API.G_FALSE ,

552: END IF;
553:
554: JTF_Tasks_Pub.Create_Task(
555: p_api_version => 1.0 ,
556: p_init_msg_list => FND_API.G_FALSE ,
557: p_commit => FND_API.G_FALSE ,
558: x_return_status => x_return_status ,
559: x_msg_count => x_msg_count ,
560: x_msg_data => x_msg_data ,

Line 557: p_commit => FND_API.G_FALSE ,

553:
554: JTF_Tasks_Pub.Create_Task(
555: p_api_version => 1.0 ,
556: p_init_msg_list => FND_API.G_FALSE ,
557: p_commit => FND_API.G_FALSE ,
558: x_return_status => x_return_status ,
559: x_msg_count => x_msg_count ,
560: x_msg_data => x_msg_data ,
561: p_task_name => l_task_rec.task_name ,

Line 651: IF FND_API.To_Boolean(p_commit) THEN

647: aso_debug_pub.add('ASO_TASK_INT: Copy_Opp_Tasks_To_Qte: End Copy_Opp_Tasks_To_Qte()', 1, 'Y');
648: END IF;
649:
650: -- Standard check of p_commit.
651: IF FND_API.To_Boolean(p_commit) THEN
652: COMMIT WORK;
653: END IF;
654:
655: -- Standard call to get message count and if count is 1, get message info.

Line 657: p_encoded => FND_API.G_FALSE,

653: END IF;
654:
655: -- Standard call to get message count and if count is 1, get message info.
656: FND_Msg_Pub.Count_And_Get(
657: p_encoded => FND_API.G_FALSE,
658: p_count => x_msg_count ,
659: p_data => x_msg_data
660: );
661:

Line 663: WHEN FND_API.G_EXC_ERROR THEN

659: p_data => x_msg_data
660: );
661:
662: EXCEPTION
663: WHEN FND_API.G_EXC_ERROR THEN
664: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
665: P_API_NAME => L_API_NAME,
666: P_PKG_NAME => G_PKG_NAME,
667: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

672: X_MSG_DATA => X_MSG_DATA,
673: X_RETURN_STATUS => X_RETURN_STATUS
674: );
675:
676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
677: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
678: P_API_NAME => L_API_NAME,
679: P_PKG_NAME => G_PKG_NAME,
680: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,