DBA Data[Home] [Help]

APPS.PON_AUCTION_INTERFACE_PKG dependencies on FND_API

Line 1833: v_return_status <> FND_API.G_RET_STS_SUCCESS

1829: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',
1830: 'Copy Line UDAs Return '||v_return_status||' '||p_error_message) ;
1831: IF
1832: (
1833: v_return_status <> FND_API.G_RET_STS_SUCCESS
1834: )
1835: THEN
1836: P_RESULT := error;
1837: P_ERROR_CODE := 'ADD_NEG_LINE:COPY_LINE_UDA';

Line 2017: p_commit => fnd_api.g_false,

2013: AND flv.language = userenv('LANG');
2014:
2015: v_max_seq_number := 9999999999999;
2016: PO_NEGOTIATIONS4_GRP.insert_attributes( p_api_version => 1.0,
2017: p_commit => fnd_api.g_false,
2018: p_init_msg_list => fnd_api.g_false,
2019: p_validation_level => fnd_api.g_valid_level_full,
2020: p_auction_header_id => p_document_number,
2021: x_return_status => v_return_status,

Line 2018: p_init_msg_list => fnd_api.g_false,

2014:
2015: v_max_seq_number := 9999999999999;
2016: PO_NEGOTIATIONS4_GRP.insert_attributes( p_api_version => 1.0,
2017: p_commit => fnd_api.g_false,
2018: p_init_msg_list => fnd_api.g_false,
2019: p_validation_level => fnd_api.g_valid_level_full,
2020: p_auction_header_id => p_document_number,
2021: x_return_status => v_return_status,
2022: x_msg_count => v_msg_count,

Line 2019: p_validation_level => fnd_api.g_valid_level_full,

2015: v_max_seq_number := 9999999999999;
2016: PO_NEGOTIATIONS4_GRP.insert_attributes( p_api_version => 1.0,
2017: p_commit => fnd_api.g_false,
2018: p_init_msg_list => fnd_api.g_false,
2019: p_validation_level => fnd_api.g_valid_level_full,
2020: p_auction_header_id => p_document_number,
2021: x_return_status => v_return_status,
2022: x_msg_count => v_msg_count,
2023: x_msg_data => v_msg_data);

Line 2202: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2198: AND language = userenv('LANG')
2199: ORDER BY NVL(sequence, v_max_seq_number) ASC
2200: );
2201: END LOOP;
2202: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2203: X_MSG_COUNT := 0;
2204: X_MSG_DATA := NULL;
2205: EXCEPTION
2206: WHEN OTHERS THEN

Line 2207: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;

2203: X_MSG_COUNT := 0;
2204: X_MSG_DATA := NULL;
2205: EXCEPTION
2206: WHEN OTHERS THEN
2207: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;
2208: X_MSG_COUNT := 1;
2209: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2210: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2211: fnd_message.set_token('PROCEDURE','Add_Catalog_Descriptors');

Line 2454: x_return_status OUT FND_API.G_RET_STS_SUCCESS or FND_API.G_RET_STS_ERROR

2450: /*===================================================================
2451: PROCEDURE: add_negotiation_invitees PUBLIC
2452: PARAMETERS:
2453: p_api_version IN version of the api
2454: x_return_status OUT FND_API.G_RET_STS_SUCCESS or FND_API.G_RET_STS_ERROR
2455: x_msg_count OUT Internal code for error
2456: x_msg_data OUT Displayable error message
2457: P_DOCUMENT_NUMBER IN Negotiation Document number
2458: P_BUYER_ID IN FND_USER_ID of the creator

Line 2481: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

2477: l_umbrella_program_id pon_auction_headers_all.umbrella_program_id%TYPE;
2478: l_max_sequence NUMBER := 0;
2479: BEGIN
2480: -- Check for call compatibility.
2481: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2483: END IF;
2484: IF (P_DOCUMENT_NUMBER IS NULL) THEN
2485: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2478: l_max_sequence NUMBER := 0;
2479: BEGIN
2480: -- Check for call compatibility.
2481: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2483: END IF;
2484: IF (P_DOCUMENT_NUMBER IS NULL) THEN
2485: x_return_status := FND_API.G_RET_STS_SUCCESS;
2486: x_msg_count := 0;

Line 2485: x_return_status := FND_API.G_RET_STS_SUCCESS;

2481: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2483: END IF;
2484: IF (P_DOCUMENT_NUMBER IS NULL) THEN
2485: x_return_status := FND_API.G_RET_STS_SUCCESS;
2486: x_msg_count := 0;
2487: x_msg_data := 'Please provide a DOCUMENT_NUMBER';
2488: RETURN;
2489: END IF;

Line 2491: x_return_status := FND_API.G_RET_STS_SUCCESS;

2487: x_msg_data := 'Please provide a DOCUMENT_NUMBER';
2488: RETURN;
2489: END IF;
2490: IF (P_BUYER_ID IS NULL) THEN
2491: x_return_status := FND_API.G_RET_STS_SUCCESS;
2492: x_msg_count := 0;
2493: x_msg_data := 'Please specify a BUYER_ID';
2494: RETURN;
2495: END IF;

Line 2577: x_return_status := FND_API.G_RET_STS_SUCCESS;

2573: AND ps.vendor_site_id(+) = prl.vendor_site_id
2574: )
2575: ORDER BY vendor_name;
2576:
2577: x_return_status := FND_API.G_RET_STS_SUCCESS;
2578: x_msg_count := 0;
2579: x_msg_data := NULL;
2580: EXCEPTION
2581: WHEN NO_DATA_FOUND THEN

Line 2582: x_return_status := FND_API.G_RET_STS_SUCCESS;

2578: x_msg_count := 0;
2579: x_msg_data := NULL;
2580: EXCEPTION
2581: WHEN NO_DATA_FOUND THEN
2582: x_return_status := FND_API.G_RET_STS_SUCCESS;
2583: x_msg_count := 0;
2584: x_msg_data := NULL;
2585: RETURN;
2586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2582: x_return_status := FND_API.G_RET_STS_SUCCESS;
2583: x_msg_count := 0;
2584: x_msg_data := NULL;
2585: RETURN;
2586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2588: x_msg_count := 1;
2589: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2590: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

Line 2587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2583: x_msg_count := 0;
2584: x_msg_data := NULL;
2585: RETURN;
2586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2588: x_msg_count := 1;
2589: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2590: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2591: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');

Line 2596: x_return_status := FND_API.G_RET_STS_ERROR ;

2592: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2593: fnd_message.retrieve(x_msg_data);
2594: RETURN;
2595: WHEN OTHERS THEN
2596: x_return_status := FND_API.G_RET_STS_ERROR ;
2597: x_msg_count := 1;
2598: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2599: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2600: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');

Line 2628: x_return_status OUT FND_API.G_RET_STS_SUCCESS or FND_API.G_RET_STS_ERROR

2624: /*===================================================================
2625: PROCEDURE: maintain_clm_relations PUBLIC
2626: PARAMETERS:
2627: p_api_version version of the api
2628: x_return_status OUT FND_API.G_RET_STS_SUCCESS or FND_API.G_RET_STS_ERROR
2629: x_msg_count OUT Internal code for error
2630: x_msg_data OUT Displayable error message
2631: P_DOCUMENT_NUMBER IN Negotiation Document number
2632: COMMENT: -- After the lines have been autocreated. Set the CLM clin slin and option relations appropriately.

Line 2667: x_return_status := FND_API.G_RET_STS_SUCCESS;

2663: AND clm_base_line_num = oneline.requisition_line_id;
2664: END LOOP;
2665: EXCEPTION
2666: WHEN NO_DATA_FOUND THEN
2667: x_return_status := FND_API.G_RET_STS_SUCCESS;
2668: x_msg_count := 0;
2669: x_msg_data := NULL;
2670: logme(l_log_module, 'in NO_DATA_FOUND');
2671: RETURN;

Line 2673: x_return_status := FND_API.G_RET_STS_ERROR ;

2669: x_msg_data := NULL;
2670: logme(l_log_module, 'in NO_DATA_FOUND');
2671: RETURN;
2672: WHEN OTHERS THEN
2673: x_return_status := FND_API.G_RET_STS_ERROR ;
2674: x_msg_count := 1;
2675: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2676: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2677: fnd_message.set_token('PROCEDURE','maintain_clm_relations');

Line 2712: x_return_status := FND_API.G_RET_STS_SUCCESS;

2708: AND line_number = p_line_number;
2709: END IF;
2710: EXCEPTION
2711: WHEN NO_DATA_FOUND THEN
2712: x_return_status := FND_API.G_RET_STS_SUCCESS;
2713: x_msg_count := 0;
2714: x_msg_data := NULL;
2715: END;
2716: BEGIN

Line 2731: x_return_status := FND_API.G_RET_STS_SUCCESS;

2727: AND line_number = p_line_number;
2728: END IF;
2729: EXCEPTION
2730: WHEN NO_DATA_FOUND THEN
2731: x_return_status := FND_API.G_RET_STS_SUCCESS;
2732: x_msg_count := 0;
2733: x_msg_data := NULL;
2734: END;
2735: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2735: x_return_status := FND_API.G_RET_STS_SUCCESS;

2731: x_return_status := FND_API.G_RET_STS_SUCCESS;
2732: x_msg_count := 0;
2733: x_msg_data := NULL;
2734: END;
2735: x_return_status := FND_API.G_RET_STS_SUCCESS;
2736: x_msg_count := 0;
2737: x_msg_data := NULL;
2738: RETURN;
2739: END maintain_clm_relations;