164: p_message => ' Return Status : ' ||l_return_status || ' Template ID ' || l_template_id
165: );
166: END IF;
167:
168: IF l_template_id IS NOT NULL AND l_return_status =FND_API.G_RET_STS_SUCCESS THEN
169: RETURN l_template_id;
170: ELSE
171: RETURN NULL;
172: END IF;
1505: ,from_pk_col_value_pairs => from_pk_col_value_pairs
1506: ,to_pk_col_value_pairs => to_pk_col_value_pairs
1507: ,copy_attribute_groups => 'SPECIFIC'
1508: ,attribute_group_table => l_attr_group_tbl
1509: ,p_commit => fnd_api.g_false
1510: ,x_return_status => x_return_status
1511: ,x_msg_count => x_msg_count
1512: ,x_msg_data => x_msg_data
1513: );
1996: ,from_pk_col_value_pairs => from_pk_col_value_pairs
1997: ,to_pk_col_value_pairs => to_pk_col_value_pairs
1998: ,copy_attribute_groups => 'SPECIFIC'
1999: ,attribute_group_table => l_attr_group_tbl
2000: ,p_commit => fnd_api.g_false
2001: ,x_return_status => x_return_status
2002: ,x_msg_count => x_msg_count
2003: ,x_msg_data => x_msg_data
2004: );
2011: );
2012: END IF;
2013:
2014: -- CLM UCA Project: Update clm_uda_pricing_total with the CP Total
2015: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2016: UPDATE po_lines_draft_all
2017: SET clm_uda_pricing_total = Decode(matching_basis, 'QUANTITY', quantity, amount)
2018: WHERE po_line_id = l_to_pk1_value
2019: AND draft_id = po_autocreate_params.g_draft_id
2137: );
2138:
2139: x_external_attr_value_pairs := EGO_COL_NAME_VALUE_PAIR_TABLE();
2140: x_external_attr_value_pairs.extend(4);
2141: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, x_external_attr_value_pairs);
2142: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_errorcode', '0', x_external_attr_value_pairs);
2143: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_count', '0', x_external_attr_value_pairs);
2144: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', x_external_attr_value_pairs);
2145:
3023: ||' Message Data: '|| x_msg_data || ' Error Code : '|| x_errorcode
3024: );
3025: END IF;
3026:
3027: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3028:
3029: x_external_attr_value_pairs := EGO_COL_NAME_VALUE_PAIR_TABLE(
3030: EGO_COL_NAME_VALUE_PAIR_OBJ('x_return_status', FND_API.G_RET_STS_SUCCESS)
3031: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_errorcode', '0')
3026:
3027: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3028:
3029: x_external_attr_value_pairs := EGO_COL_NAME_VALUE_PAIR_TABLE(
3030: EGO_COL_NAME_VALUE_PAIR_OBJ('x_return_status', FND_API.G_RET_STS_SUCCESS)
3031: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_errorcode', '0')
3032: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_msg_count', '0')
3033: ,EGO_COL_NAME_VALUE_PAIR_OBJ('x_msg_data', 'SUCCESS')
3034: );
3496: ,p_old_dtlevel_col_value_pairs => l_dtlevel_col_value_pairs
3497: ,p_new_pk_col_value_pairs => to_pk_col_value_pairs
3498: ,p_new_data_level_id => l_main_data_level_id
3499: ,p_new_dtlevel_col_value_pairs => l_dtlevel_col_value_pairs
3500: ,p_commit => FND_API.G_FALSE
3501: ,x_return_status => x_return_status
3502: ,x_errorcode => x_errorcode
3503: ,x_msg_count => x_msg_count
3504: ,x_msg_data => x_msg_data