[Home] [Help]
83: -- Add message to API message list.
84: FND_MSG_PUB.Add;
85:
86:
87: UPDATE pn_term_templates
88: SET vendor_id = p_vendor_id,
89: vendor_site_id = p_vendor_site_id,
90: last_updated_by = p_last_updated_by,
91: last_update_date = sysdate
92: WHERE vendor_id = p_dup_vendor_id
93: AND vendor_site_id = p_dup_vendor_site_id;
94:
95: -- Prepare message name
96: FND_MESSAGE.SET_NAME('PN','PN_TERM_TEMPLATES');
97: IF SQL%FOUND THEN
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99: l_row_count := SQL%ROWCOUNT;
100: ELSE