DBA Data[Home] [Help]

APPS.PON_ATTR_MAPPING dependencies on FND_API

Line 347: x_return_status := FND_API.G_RET_STS_SUCCESS;

343: INCORRECT_DATA EXCEPTION;
344:
345: BEGIN
346: SAVEPOINT Process_User_Attrs_Data_PUB;
347: x_return_status := FND_API.G_RET_STS_SUCCESS;
348: x_err_msg := NULL;
349:
350: -- Bug 16401315
351: -- Added document_number to the query for mapping RFx Number

Line 611: , p_validate_hierarchy => FND_API.G_FALSE

607: , p_attr_group_id => supp_ag_dl_rec.attr_group_id-- input
608: , p_application_id => l_application_id-- 177 for supplier, 431 for item
609: , p_attr_group_type => l_attr_group_type-- POS_SUPP_PROFMGMT_GROUP/EGO_ITEMMGMT_GROUP
610: , p_attr_group_name => l_attr_group_name-- input
611: , p_validate_hierarchy => FND_API.G_FALSE
612: , p_pk_column_name_value_pairs => l_pk_column_pairs-- input
613: , p_class_code_name_value_pairs => l_class_code_pairs-- input
614: , p_data_level => l_data_level_name-- input
615: , p_data_level_name_value_pairs => l_data_level_pairs-- input

Line 621: , p_validate_only => FND_API.G_FALSE

617: , p_attr_name_value_pairs => l_row_attrs_table-- input
618: , p_entity_id => NULL
619: , p_entity_index => NULL
620: , p_entity_code => NULL
621: , p_validate_only => FND_API.G_FALSE
622: , p_language_to_process => NULL
623: , p_mode => ego_user_attrs_data_pvt.G_SYNC_MODE
624: , p_change_obj => NULL
625: , p_pending_b_table_name => NULL

Line 628: , p_init_fnd_msg_list => FND_API.G_FALSE

624: , p_change_obj => NULL
625: , p_pending_b_table_name => NULL
626: , p_pending_tl_table_name => NULL
627: , p_pending_vl_name => NULL
628: , p_init_fnd_msg_list => FND_API.G_FALSE
629: , p_add_errors_to_fnd_stack => FND_API.G_FALSE
630: , p_commit => FND_API.G_FALSE
631: , p_raise_business_event => FALSE
632: , x_extension_id => l_extension_id

Line 629: , p_add_errors_to_fnd_stack => FND_API.G_FALSE

625: , p_pending_b_table_name => NULL
626: , p_pending_tl_table_name => NULL
627: , p_pending_vl_name => NULL
628: , p_init_fnd_msg_list => FND_API.G_FALSE
629: , p_add_errors_to_fnd_stack => FND_API.G_FALSE
630: , p_commit => FND_API.G_FALSE
631: , p_raise_business_event => FALSE
632: , x_extension_id => l_extension_id
633: , x_mode => l_mode

Line 630: , p_commit => FND_API.G_FALSE

626: , p_pending_tl_table_name => NULL
627: , p_pending_vl_name => NULL
628: , p_init_fnd_msg_list => FND_API.G_FALSE
629: , p_add_errors_to_fnd_stack => FND_API.G_FALSE
630: , p_commit => FND_API.G_FALSE
631: , p_raise_business_event => FALSE
632: , x_extension_id => l_extension_id
633: , x_mode => l_mode
634: , x_return_status => l_return_status

Line 640: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

636: , x_msg_count => l_msg_count
637: , x_msg_data => l_msg_data
638: );
639:
640: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
641: x_return_status := l_return_status;
642: ERROR_HANDLER.Get_Message(l_msg_data, l_error_code, l_entity_id, l_message_type);
643: x_err_msg := x_err_msg || G_DELIMITER
644: || 'Supplier: ' || l_vendor_name

Line 890: , p_validate_hierarchy => FND_API.G_FALSE

886: , p_attr_group_id => item_ag_dl_rec.attr_group_id-- input
887: , p_application_id => l_application_id-- 177 for supplier, 431 for item
888: , p_attr_group_type => l_attr_group_type-- POS_SUPP_PROFMGMT_GROUP/EGO_ITEMMGMT_GROUP
889: , p_attr_group_name => l_attr_group_name-- input
890: , p_validate_hierarchy => FND_API.G_FALSE
891: , p_pk_column_name_value_pairs => l_pk_column_pairs-- input
892: , p_class_code_name_value_pairs => l_class_code_pairs-- input
893: , p_data_level => l_data_level_name-- input
894: , p_data_level_name_value_pairs => l_data_level_pairs-- input

Line 900: , p_validate_only => FND_API.G_FALSE

896: , p_attr_name_value_pairs => l_row_attrs_table-- input
897: , p_entity_id => NULL
898: , p_entity_index => NULL
899: , p_entity_code => NULL
900: , p_validate_only => FND_API.G_FALSE
901: , p_language_to_process => NULL
902: , p_mode => ego_user_attrs_data_pvt.G_SYNC_MODE
903: , p_change_obj => NULL
904: , p_pending_b_table_name => NULL

Line 907: , p_init_fnd_msg_list => FND_API.G_FALSE

903: , p_change_obj => NULL
904: , p_pending_b_table_name => NULL
905: , p_pending_tl_table_name => NULL
906: , p_pending_vl_name => NULL
907: , p_init_fnd_msg_list => FND_API.G_FALSE
908: , p_add_errors_to_fnd_stack => FND_API.G_FALSE
909: , p_commit => FND_API.G_FALSE
910: , p_raise_business_event => FALSE
911: , x_extension_id => l_extension_id

Line 908: , p_add_errors_to_fnd_stack => FND_API.G_FALSE

904: , p_pending_b_table_name => NULL
905: , p_pending_tl_table_name => NULL
906: , p_pending_vl_name => NULL
907: , p_init_fnd_msg_list => FND_API.G_FALSE
908: , p_add_errors_to_fnd_stack => FND_API.G_FALSE
909: , p_commit => FND_API.G_FALSE
910: , p_raise_business_event => FALSE
911: , x_extension_id => l_extension_id
912: , x_mode => l_mode

Line 909: , p_commit => FND_API.G_FALSE

905: , p_pending_tl_table_name => NULL
906: , p_pending_vl_name => NULL
907: , p_init_fnd_msg_list => FND_API.G_FALSE
908: , p_add_errors_to_fnd_stack => FND_API.G_FALSE
909: , p_commit => FND_API.G_FALSE
910: , p_raise_business_event => FALSE
911: , x_extension_id => l_extension_id
912: , x_mode => l_mode
913: , x_return_status => l_return_status

Line 918: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

914: , x_errorcode => l_error_code
915: , x_msg_count => l_msg_count
916: , x_msg_data => l_msg_data
917: );
918: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
919: x_return_status := l_return_status;
920: ERROR_HANDLER.Get_Message(l_msg_data, l_error_code, l_entity_id, l_message_type);
921: x_err_msg := x_err_msg || G_DELIMITER
922: || 'Supplier: ' || l_vendor_name

Line 943: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

939: END LOOP; -- item_ag_dl_cursor
940:
941: END IF; -- l_intgr_item_line_flag = 'Y'
942:
943: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
944: ROLLBACK TO Process_User_Attrs_Data_PUB;
945: END IF;
946:
947: END Process_User_Attrs_Data;

Line 1164: x_return_status := FND_API.G_RET_STS_SUCCESS;

1160: BID_NUMBER;
1161:
1162: BEGIN
1163: SAVEPOINT Sync_User_Attrs_Data_PUB;
1164: x_return_status := FND_API.G_RET_STS_SUCCESS;
1165: x_err_msg := NULL;
1166:
1167: IF (p_auction_header_id IS NOT NULL AND p_vendor_id IS NULL) THEN
1168: FOR bids_rec IN bids_cursor(p_auction_header_id) LOOP

Line 1172: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1168: FOR bids_rec IN bids_cursor(p_auction_header_id) LOOP
1169: l_return_status := NULL;
1170: l_msg_data := NULL;
1171: Process_User_Attrs_Data(p_auction_header_id, bids_rec.bid_number, l_return_status, l_msg_data);
1172: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1173: x_return_status := l_return_status;
1174: x_err_msg := x_err_msg || l_msg_data;
1175: END IF;
1176: END LOOP;

Line 1177: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1173: x_return_status := l_return_status;
1174: x_err_msg := x_err_msg || l_msg_data;
1175: END IF;
1176: END LOOP;
1177: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1178: Sync_Approved_Supplier_List(p_auction_header_id);
1179: END IF;
1180: ELSIF (p_auction_header_id IS NULL AND p_vendor_id IS NOT NULL) THEN
1181: FOR auctions_rec IN auctions_cursor(p_vendor_id) LOOP

Line 1186: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1182: l_return_status := NULL;
1183: l_msg_data := NULL;
1184: Process_User_Attrs_Data(auctions_rec.auction_header_id, auctions_rec.bid_number, l_return_status, l_msg_data);
1185: END LOOP;
1186: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1187: x_return_status := l_return_status;
1188: x_err_msg := x_err_msg || l_msg_data;
1189: END IF;
1190: END IF;

Line 1192: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1188: x_err_msg := x_err_msg || l_msg_data;
1189: END IF;
1190: END IF;
1191:
1192: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1193: ROLLBACK TO Sync_User_Attrs_Data_PUB;
1194: END IF;
1195:
1196: END Sync_User_Attrs_Data;