DBA Data[Home] [Help]

APPS.ASO_APR_WF_PVT dependencies on FND_API

Line 1879: x_return_status := fnd_api.g_ret_sts_success;

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

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

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

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

2477: );
2478: FETCH get_latest_date INTO l_quote_header_rec.last_update_date, l_quote_header_rec.org_id;
2479: CLOSE get_latest_date;
2480: -- Setting the auto version flag to true
2481: l_control_rec.auto_version_flag := fnd_api.g_true;
2482:
2483: -- set the org context , see bug 4731684
2484: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2485: aso_debug_pub.ADD (

Line 2505: p_init_msg_list => fnd_api.g_false,

2501: );
2502: END IF;
2503: aso_quote_pub.update_quote (
2504: p_api_version_number => 1.0,
2505: p_init_msg_list => fnd_api.g_false,
2506: p_commit => fnd_api.g_false,
2507: p_control_rec => l_control_rec,
2508: p_qte_header_rec => l_quote_header_rec,
2509: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,

Line 2506: p_commit => fnd_api.g_false,

2502: END IF;
2503: aso_quote_pub.update_quote (
2504: p_api_version_number => 1.0,
2505: p_init_msg_list => fnd_api.g_false,
2506: p_commit => fnd_api.g_false,
2507: p_control_rec => l_control_rec,
2508: p_qte_header_rec => l_quote_header_rec,
2509: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
2510: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,

Line 2549: IF x_return_status <> fnd_api.g_ret_sts_success

2545: x_msg_count => x_msg_count,
2546: x_msg_data => x_msg_data
2547: );
2548:
2549: IF x_return_status <> fnd_api.g_ret_sts_success
2550: THEN
2551: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2552: aso_debug_pub.ADD (
2553: 'Return Status from update quote API is :' || x_return_status,

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

2557: END IF;
2558:
2559:
2560: /*bug 3500380 */
2561: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2563: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2564: RAISE FND_API.G_EXC_ERROR;
2565: END IF;

Line 2562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2558:
2559:
2560: /*bug 3500380 */
2561: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2563: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2564: RAISE FND_API.G_EXC_ERROR;
2565: END IF;
2566: --RAISE update_quote_exception;

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

2559:
2560: /*bug 3500380 */
2561: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2563: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2564: RAISE FND_API.G_EXC_ERROR;
2565: END IF;
2566: --RAISE update_quote_exception;
2567:

Line 2564: RAISE FND_API.G_EXC_ERROR;

2560: /*bug 3500380 */
2561: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2563: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2564: RAISE FND_API.G_EXC_ERROR;
2565: END IF;
2566: --RAISE update_quote_exception;
2567:
2568:

Line 2606: WHEN FND_API.G_EXC_ERROR THEN

2602: END IF;
2603: EXCEPTION
2604:
2605: /*bug 3500380 */
2606: WHEN FND_API.G_EXC_ERROR THEN
2607: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2608: aso_debug_pub.ADD (
2609: 'Exception in update entity ',
2610: 1,

Line 2623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2619: TO_CHAR(actid),
2620: funcmode);
2621: RAISE;
2622:
2623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2624: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2625: aso_debug_pub.ADD (
2626: 'Exception in update entity ',
2627: 1,

Line 2791: fnd_api.g_false,

2787: );
2788: END IF;
2789: aso_apr_int.get_all_approvers (
2790: 1.0,
2791: fnd_api.g_false,
2792: fnd_api.g_false,
2793: l_object_id,
2794: l_object_type,
2795: l_application_id, ---p_application_id,

Line 2792: fnd_api.g_false,

2788: END IF;
2789: aso_apr_int.get_all_approvers (
2790: 1.0,
2791: fnd_api.g_false,
2792: fnd_api.g_false,
2793: l_object_id,
2794: l_object_type,
2795: l_application_id, ---p_application_id,
2796: fnd_api.g_false, --- p_clear_transaction_flag

Line 2796: fnd_api.g_false, --- p_clear_transaction_flag

2792: fnd_api.g_false,
2793: l_object_id,
2794: l_object_type,
2795: l_application_id, ---p_application_id,
2796: fnd_api.g_false, --- p_clear_transaction_flag
2797: l_return_status,
2798: l_msg_count,
2799: l_msg_data,
2800: x_approvers_list,

Line 2806: IF l_return_status <> fnd_api.g_ret_sts_success

2802: );
2803: CLOSE get_object_id;
2804:
2805: -- Checking to find OUT NOCOPY /* file.sql.39 change */ if call to get_all_approvers was successfull
2806: IF l_return_status <> fnd_api.g_ret_sts_success
2807: THEN
2808: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2809: aso_debug_pub.ADD (
2810: 'Status returned from get_all_approvers procedure :' || l_return_status,

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

2819: -- fix for bug 4590633
2820:
2821: for i in 1..x_approvers_list.count loop
2822:
2823: IF ((x_approvers_list(i).approver_person_id is null) or (x_approvers_list(i).approver_person_id = fnd_api.g_miss_num) and
2824: (x_approvers_list(i).approver_user_id is not null) and (x_approvers_list(i).approver_user_id <> fnd_api.g_miss_num)) then
2825:
2826: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2827: aso_debug_pub.ADD ('Person_id is null from AME Hence deriving it from user_id',1,'N');

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

2820:
2821: for i in 1..x_approvers_list.count loop
2822:
2823: IF ((x_approvers_list(i).approver_person_id is null) or (x_approvers_list(i).approver_person_id = fnd_api.g_miss_num) and
2824: (x_approvers_list(i).approver_user_id is not null) and (x_approvers_list(i).approver_user_id <> fnd_api.g_miss_num)) then
2825:
2826: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2827: aso_debug_pub.ADD ('Person_id is null from AME Hence deriving it from user_id',1,'N');
2828: END IF;

Line 2886: ).approver_person_id = fnd_api.g_miss_num

2882: -- converted into a null
2883:
2884: IF x_approvers_list (
2885: i
2886: ).approver_person_id = fnd_api.g_miss_num
2887: THEN
2888: x_approvers_list (
2889: i
2890: ).approver_person_id := NULL;

Line 2895: ).approver_user_id = fnd_api.g_miss_num

2891: END IF;
2892:
2893: IF x_approvers_list (
2894: i
2895: ).approver_user_id = fnd_api.g_miss_num
2896: THEN
2897: x_approvers_list (
2898: i
2899: ).approver_user_id := NULL;

Line 3255: ).rule_id = fnd_api.g_miss_num

3251: -- converted into a null
3252:
3253: IF x_rules_list (
3254: i
3255: ).rule_id = fnd_api.g_miss_num
3256: THEN
3257: x_rules_list (
3258: i
3259: ).rule_id := NULL;

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

3582: );
3583: END IF;
3584:
3585: IF (((new_approver_record.person_id IS NOT NULL)
3586: AND (new_approver_record.person_id <> fnd_api.g_miss_num)
3587: )
3588: OR ((new_approver_record.user_id IS NOT NULL)
3589: AND (new_approver_record.user_id <> fnd_api.g_miss_num)
3590: )

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

3585: IF (((new_approver_record.person_id IS NOT NULL)
3586: AND (new_approver_record.person_id <> fnd_api.g_miss_num)
3587: )
3588: OR ((new_approver_record.user_id IS NOT NULL)
3589: AND (new_approver_record.user_id <> fnd_api.g_miss_num)
3590: )
3591: )
3592: THEN
3593: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 3848: x_return_status := fnd_api.g_ret_sts_success;

3844: 'N'
3845: );
3846: END IF;
3847: -- Retreive the message name for that event
3848: x_return_status := fnd_api.g_ret_sts_success;
3849:
3850: ibe_wf_msg_mapping_pvt.retrieve_msg_mapping (
3851: p_org_id => l_orgid,
3852: p_msite_id => NULL,

Line 3864: IF x_return_status <> fnd_api.g_ret_sts_success

3860: );
3861:
3862: -- Check if the call to MSG mapping API was succssfull
3863: -- bug 3295179
3864: IF x_return_status <> fnd_api.g_ret_sts_success
3865: --IF x_msg_count > 0
3866: THEN
3867: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3868: aso_debug_pub.ADD (

Line 5422: -- Call Fnd API

5418: IF p_security_group_id IS NULL THEN
5419: l_security_group_id := -1 ;
5420: END IF ;
5421:
5422: -- Call Fnd API
5423: RETURN fnd_run_function.get_run_function_url
5424: ( p_function_id => l_function_id
5425: , p_resp_appl_id => l_resp_appl_id
5426: , p_resp_id => l_resp_id