DBA Data[Home] [Help]

APPS.ASO_APR_WF_PVT dependencies on FND_API

Line 1878: x_return_status := fnd_api.g_ret_sts_success;

1874: );
1875: END IF;
1876: -- Retreive the message name for that event
1877:
1878: x_return_status := fnd_api.g_ret_sts_success;
1879:
1880: ibe_wf_msg_mapping_pvt.retrieve_msg_mapping (
1881: p_org_id => l_orgid,
1882: p_msite_id => NULL,

Line 1900: IF ( (x_return_status <> fnd_api.g_ret_sts_success) OR (l_message IS NULL) )

1896: );
1897: END IF;
1898:
1899: -- bug 3295179
1900: IF ( (x_return_status <> fnd_api.g_ret_sts_success) OR (l_message IS NULL) )
1901: --IF ((x_msg_count > 0)
1902: -- OR (l_message IS NULL)
1903: -- )
1904: THEN

Line 2462: l_control_rec.auto_version_flag := fnd_api.g_true;

2458: );
2459: FETCH get_latest_date INTO l_quote_header_rec.last_update_date, l_quote_header_rec.org_id;
2460: CLOSE get_latest_date;
2461: -- Setting the auto version flag to true
2462: l_control_rec.auto_version_flag := fnd_api.g_true;
2463:
2464: -- set the org context , see bug 4731684
2465: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2466: aso_debug_pub.ADD (

Line 2486: p_init_msg_list => fnd_api.g_false,

2482: );
2483: END IF;
2484: aso_quote_pub.update_quote (
2485: p_api_version_number => 1.0,
2486: p_init_msg_list => fnd_api.g_false,
2487: p_commit => fnd_api.g_false,
2488: p_control_rec => l_control_rec,
2489: p_qte_header_rec => l_quote_header_rec,
2490: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,

Line 2487: p_commit => fnd_api.g_false,

2483: END IF;
2484: aso_quote_pub.update_quote (
2485: p_api_version_number => 1.0,
2486: p_init_msg_list => fnd_api.g_false,
2487: p_commit => fnd_api.g_false,
2488: p_control_rec => l_control_rec,
2489: p_qte_header_rec => l_quote_header_rec,
2490: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
2491: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,

Line 2530: IF x_return_status <> fnd_api.g_ret_sts_success

2526: x_msg_count => x_msg_count,
2527: x_msg_data => x_msg_data
2528: );
2529:
2530: IF x_return_status <> fnd_api.g_ret_sts_success
2531: THEN
2532: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2533: aso_debug_pub.ADD (
2534: 'Return Status from update quote API is :' || x_return_status,

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

2538: END IF;
2539:
2540:
2541: /*bug 3500380 */
2542: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2544: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2545: RAISE FND_API.G_EXC_ERROR;
2546: END IF;

Line 2543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2539:
2540:
2541: /*bug 3500380 */
2542: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2544: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2545: RAISE FND_API.G_EXC_ERROR;
2546: END IF;
2547: --RAISE update_quote_exception;

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

2540:
2541: /*bug 3500380 */
2542: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2544: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2545: RAISE FND_API.G_EXC_ERROR;
2546: END IF;
2547: --RAISE update_quote_exception;
2548:

Line 2545: RAISE FND_API.G_EXC_ERROR;

2541: /*bug 3500380 */
2542: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2544: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2545: RAISE FND_API.G_EXC_ERROR;
2546: END IF;
2547: --RAISE update_quote_exception;
2548:
2549:

Line 2577: WHEN FND_API.G_EXC_ERROR THEN

2573: END IF;
2574: EXCEPTION
2575:
2576: /*bug 3500380 */
2577: WHEN FND_API.G_EXC_ERROR THEN
2578: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2579: aso_debug_pub.ADD (
2580: 'Exception in update entity ',
2581: 1,

Line 2594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2590: TO_CHAR(actid),
2591: funcmode);
2592: RAISE;
2593:
2594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2595: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2596: aso_debug_pub.ADD (
2597: 'Exception in update entity ',
2598: 1,

Line 2762: fnd_api.g_false,

2758: );
2759: END IF;
2760: aso_apr_int.get_all_approvers (
2761: 1.0,
2762: fnd_api.g_false,
2763: fnd_api.g_false,
2764: l_object_id,
2765: l_object_type,
2766: l_application_id, ---p_application_id,

Line 2763: fnd_api.g_false,

2759: END IF;
2760: aso_apr_int.get_all_approvers (
2761: 1.0,
2762: fnd_api.g_false,
2763: fnd_api.g_false,
2764: l_object_id,
2765: l_object_type,
2766: l_application_id, ---p_application_id,
2767: fnd_api.g_false, --- p_clear_transaction_flag

Line 2767: fnd_api.g_false, --- p_clear_transaction_flag

2763: fnd_api.g_false,
2764: l_object_id,
2765: l_object_type,
2766: l_application_id, ---p_application_id,
2767: fnd_api.g_false, --- p_clear_transaction_flag
2768: l_return_status,
2769: l_msg_count,
2770: l_msg_data,
2771: x_approvers_list,

Line 2777: IF l_return_status <> fnd_api.g_ret_sts_success

2773: );
2774: CLOSE get_object_id;
2775:
2776: -- Checking to find OUT NOCOPY /* file.sql.39 change */ if call to get_all_approvers was successfull
2777: IF l_return_status <> fnd_api.g_ret_sts_success
2778: THEN
2779: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2780: aso_debug_pub.ADD (
2781: 'Status returned from get_all_approvers procedure :' || l_return_status,

Line 2794: IF ((x_approvers_list(i).approver_person_id is null) or (x_approvers_list(i).approver_person_id = fnd_api.g_miss_num) and

2790: -- fix for bug 4590633
2791:
2792: for i in 1..x_approvers_list.count loop
2793:
2794: IF ((x_approvers_list(i).approver_person_id is null) or (x_approvers_list(i).approver_person_id = fnd_api.g_miss_num) and
2795: (x_approvers_list(i).approver_user_id is not null) and (x_approvers_list(i).approver_user_id <> fnd_api.g_miss_num)) then
2796:
2797: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2798: aso_debug_pub.ADD ('Person_id is null from AME Hence deriving it from user_id',1,'N');

Line 2795: (x_approvers_list(i).approver_user_id is not null) and (x_approvers_list(i).approver_user_id <> fnd_api.g_miss_num)) then

2791:
2792: for i in 1..x_approvers_list.count loop
2793:
2794: IF ((x_approvers_list(i).approver_person_id is null) or (x_approvers_list(i).approver_person_id = fnd_api.g_miss_num) and
2795: (x_approvers_list(i).approver_user_id is not null) and (x_approvers_list(i).approver_user_id <> fnd_api.g_miss_num)) then
2796:
2797: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2798: aso_debug_pub.ADD ('Person_id is null from AME Hence deriving it from user_id',1,'N');
2799: END IF;

Line 2857: ).approver_person_id = fnd_api.g_miss_num

2853: -- converted into a null
2854:
2855: IF x_approvers_list (
2856: i
2857: ).approver_person_id = fnd_api.g_miss_num
2858: THEN
2859: x_approvers_list (
2860: i
2861: ).approver_person_id := NULL;

Line 2866: ).approver_user_id = fnd_api.g_miss_num

2862: END IF;
2863:
2864: IF x_approvers_list (
2865: i
2866: ).approver_user_id = fnd_api.g_miss_num
2867: THEN
2868: x_approvers_list (
2869: i
2870: ).approver_user_id := NULL;

Line 3226: ).rule_id = fnd_api.g_miss_num

3222: -- converted into a null
3223:
3224: IF x_rules_list (
3225: i
3226: ).rule_id = fnd_api.g_miss_num
3227: THEN
3228: x_rules_list (
3229: i
3230: ).rule_id := NULL;

Line 3557: AND (new_approver_record.person_id <> fnd_api.g_miss_num)

3553: );
3554: END IF;
3555:
3556: IF (((new_approver_record.person_id IS NOT NULL)
3557: AND (new_approver_record.person_id <> fnd_api.g_miss_num)
3558: )
3559: OR ((new_approver_record.user_id IS NOT NULL)
3560: AND (new_approver_record.user_id <> fnd_api.g_miss_num)
3561: )

Line 3560: AND (new_approver_record.user_id <> fnd_api.g_miss_num)

3556: IF (((new_approver_record.person_id IS NOT NULL)
3557: AND (new_approver_record.person_id <> fnd_api.g_miss_num)
3558: )
3559: OR ((new_approver_record.user_id IS NOT NULL)
3560: AND (new_approver_record.user_id <> fnd_api.g_miss_num)
3561: )
3562: )
3563: THEN
3564: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 3818: x_return_status := fnd_api.g_ret_sts_success;

3814: 'N'
3815: );
3816: END IF;
3817: -- Retreive the message name for that event
3818: x_return_status := fnd_api.g_ret_sts_success;
3819:
3820: ibe_wf_msg_mapping_pvt.retrieve_msg_mapping (
3821: p_org_id => l_orgid,
3822: p_msite_id => NULL,

Line 3834: IF x_return_status <> fnd_api.g_ret_sts_success

3830: );
3831:
3832: -- Check if the call to MSG mapping API was succssfull
3833: -- bug 3295179
3834: IF x_return_status <> fnd_api.g_ret_sts_success
3835: --IF x_msg_count > 0
3836: THEN
3837: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3838: aso_debug_pub.ADD (

Line 5392: -- Call Fnd API

5388: IF p_security_group_id IS NULL THEN
5389: l_security_group_id := -1 ;
5390: END IF ;
5391:
5392: -- Call Fnd API
5393: RETURN fnd_run_function.get_run_function_url
5394: ( p_function_id => l_function_id
5395: , p_resp_appl_id => l_resp_appl_id
5396: , p_resp_id => l_resp_id